jobs\Iconomy + MySQL

Вечер добрый, в общем сервер у меня стоит на хостинге, вроде бы все норм, но вот бывает подлагивает, а бывает жутко лагает, 2,5 гига оперативки на 43 слота, плагины стоят только нужные для классик сервера, вот решил попробыть перевести парочку плагинов на
MySQL, плагины : Jobs, Iconomy. Кто может дать ссылку на норм MySQL и помочь разобраться с Iconomy\jobs + MySQL, тоесть именно в конфиг файлах, что куда вводить.

Iconomy

Спойлер

# iConomy 6.0.8b
# @author Nijikokun <nijikokun@gmail.com>
# @license GPLv2
# @copyright Copyright AniGaiku LLC (C) 2010-2011
##
# Setup Notes
# - Seconds
# Basic Table:
# 1 minute = 60 seconds
# 1 hour = 1 minute * 60 = 3600 seconds
# 1 day = 1 hour * 24 = 86400 seconds
# 1 week = 1 day * 7 = 604800 seconds
# - Database
# Do not use remote databases from free sites, please use either a
# remote database from a personal hosted VPS or DEDI or a local
# database. This will prevent any 'timeout' or 'invalid settings'
# or 'cannot connect to database' issues. Thank you !
##

System:
Default:
Currency:
# Major is the first segment [Major].Minor
Major: [ 'Майнера', 'Майнеров' ] # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
Minor: [ 'Coin', 'Coins' ] # Minor (Major.[Minor]) 0.23 Coins (With Seperate 0 Dollars, 23 Coins)

Account:
# Default account balance when created
Holdings: 1000.0

# Controls how money is formatted through methods
Formatting:
# Minor allows you to use the Minor amounts for amounts <1
# Example (true) 0.23 Coins and 1.23 Dollars (false) 0.23 Dollars and 1.23 Dollars
Minor: false

# Seperate allows your money to be shown in an alternative way,
# instead of 1.32 it will show as 1 Dollar 23 Coins
# !!! NOTICE: This only works if Minor is set to true !!!
Seperate: true # Example (true) 1 Dollar, 23 Coins (false) 1.23 Dollars (Only if Minor is true)

# Single shows your money in another alternative way.
# Instead of 1.23 Dollars you will see: 1 Dollar.
# If your money is 0.23 you will see 0 Dollars if Minor is false, 23 Coins if Minor is true.
# !!! Notice: This overrides seperate !!!
Single: true

# Logs all monetary transactions passed through iConomy
Logging:
Enabled: true

# Controls amount of money gained at a set interval.
Interest:
Enabled: false

# Only give interest to players who are currently online?
Online: true

Announce:
# Send a message when the player gains interest?
Enabled: false

Interval:
# Interval is done in seconds, here is a easy reference table for commonly set intervals:
# 1 minute = 60 seconds
# 1 hour = 1 minute * 60 = 3600 seconds
# 1 day = 1 hour * 24 = 86400 seconds
# 1 week = 1 day * 7 = 604800 seconds
Seconds: 60

Amount:
# The balance to be met where we stop giving interest.
# 0.0 for no limit
Cutoff: 0.0

# Percentage of holdings to give / take (Negative to take) (Overrides Min/Max)
Percent: 0.0

# This is range based, to set a "flat" or "constant" rate, set each (Maximum and Minimum) to the same number.
# If the two numbers are different, it will be a random amount in-between the two.
Maximum: 1
Minimum: 2

Database:
# Databases Supported:
# Flatfile, FF, mini, minidb
# - These all equate to miniDB
##
# item, items, inventory, inventoryDB
# - These all equate to InventoryDB, which uses inventory for storage
##
# xp, exp, orb, xpdb, expdb, orbdb
# - These all equate to ExperienceDB, which relies on Experience for balance.
##
# mysql, mysqldb
# - These will attempt to connect to MySQL
##
# sqlite, sqlite2, sqlite3, sqlitedb
# - These will attempt to create & connect to SQLite
##
# postgre, postgreSQL, postgreDB
# - These will attempt to connect to PostgreSQL
Type: 'minidb'

# These are for InventoryDB only.
# MajorItem is the item or block ID of the major currency
# MinorItem is the item or block ID of the minor currency
# e.g. MajorItem: 266, MinorItem: 265 for Gold/Iron
MajorItem: 266
MinorItem: 265

# This controls the database name, by default it is iConomy
Table: 'iConomy'

# URL is for SQL Databases Only
##
# Path to iConomy folder is easy, it's the COMPLETE path.
# (Mine) G:\MineCraft\plugins\iConomy\
# Won't be the same as yours, but it usually looks like that.
##
# [H2DB Default] h2ath/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
# [SQLite Default] sqliteath/to/iConomy/folder/iConomy.db
##
# Binary Databases use iport style connections.
# ip
# - is the connection identifier (internet protocol)
# - for ipv6 usually encased in brackets [::1]
# port
# - the port that the database is listening on
# - defaults: 3306 for mysql, postgre is either 5740 or 5432
##
# [MySQL Default] mysql://localhost:3306/iConomy
# [Postgre Default] postgresql://localhost:5740/iConomy
URL: 'mysql://localhost:3306/iConomy'

# Login details for binary databases
Username: 'root'
Password: ''

# Conversion allows you to convert your old 5.x to the new 6.x
# All is currently unused.
# URL is for MySQL only, H2DB doesn't use it.
Conversion:
# Set to True, After converting, change this back to false!
Enabled: false

# Database Type, H2DB or MySQL
Type: 'H2DB'

# Database Table
Table: 'iConomy'

# Database URL without table at the end.
URL: 'mysql://localhost:3306'

# Username / Password
# H2DB does not use this. MySQL Only.
Username: 'root'
Password: ''

# Unused ATM.
All: true

Jobs

Спойлер

# Jobs configuration.
Jobs:
Woodcutter:
fullname: Woodcutter
shortname: W
ChatColour: GREEN
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Break:
LOG:
income: 5.0
experience: 5.0
Place:
SAPLING:
income: 1.0
experience: 1.0
WOOD:
income: 2.0
experience: 2.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Woodcutter:
income: 10.0
experience: 10.0
Miner:
fullname: Miner
shortname: M
ChatColour: DARK_GRAY
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Break:
STONE:
income: 2.0
experience: 2.0
COAL_ORE:
income: 3.0
experience: 3.0
REDSTONE_ORE:
income: 3.0
experience: 3.0
IRON_ORE:
income: 4.0
experience: 4.0
GOLD_ORE:
income: 5.0
experience: 5.0
LAPIS_ORE:
income: 5.0
experience: 5.0
DIAMOND_ORE:
income: 6.0
experience: 6.0
OBSIDIAN:
income: 7.5
experience: 7.5
MOSSY_COBBLESTONE:
income: 6.0
experience: 6.0
Place:
RAILS:
income: 2.0
experience: 2.0
IRON_ORE:
income: -5.0
experience: -5.0
GOLD_ORE:
income: -6.0
experience: -6.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Miner:
income: 10.0
experience: 10.0
Builder:
fullname: Builder
shortname: B
ChatColour: WHITE
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Place:
COBBLESTONE:
income: 1.0
experience: 1.0
WOOD:
income: 1.5
experience: 1.5
FENCE:
income: 1.5
experience: 1.5
WOOL:
income: 1.5
experience: 1.5
STONE:
income: 2.25
experience: 2.25
GLOWSTONE:
income: 3.0
experience: 3.0
SANDSTONE:
income: 2.0
experience: 2.0
GLASS:
income: 3.0
experience: 3.0
BRICK:
income: 4.0
experience: 4.0
LAPIS_BLOCK:
income: 5.0
experience: 5.0
DOUBLE_STEP:
income: 2.0
experience: 2.0
STEP:
income: 2.0
experience: 2.0
BOOKSHELF:
income: 3.0
experience: 3.0
WOOD_STAIRS:
income: 2.0
experience: 2.0
COBBLESTONE_STAIRS:
income: 2.0
experience: 2.0
MOSSY_COBBLESTONE:
income: 5.0
experience: 5.0
DIAMOND_BLOCK:
income: 5.0
experience: 5.0
GOLD_BLOCK:
income: 5.0
experience: 5.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Builder:
income: 10.0
experience: 10.0
Digger:
fullname: Digger
shortname: D
ChatColour: GOLD
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Break:
DIRT:
income: 2.0
experience: 2.0
GRASS:
income: 2.0
experience: 2.0
GRAVEL:
income: 2.0
experience: 2.0
SAND:
income: 2.0
experience: 2.0
CLAY:
income: 2.0
experience: 2.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Digger:
income: 10.0
experience: 10.0
Farmer:
fullname: Farmer
shortname: Fa
ChatColour: BLUE
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Break:
CROPS-7:
income: 4.0
experience: 4.0
SUGAR_CANE_BLOCK:
income: 4.0
experience: 4.0
Place:
SEEDS:
income: 3.0
experience: 3.0
SUGAR_CANE_BLOCK:
income: 1.0
experience: 1.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Farmer:
income: 10.0
experience: 10.0
Hunter:
fullname: Hunter
shortname: H
ChatColour: RED
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Kill:
Chicken:
income: 2.5
experience: 2.5
Cow:
income: 2.5
experience: 2.5
Pig:
income: 2.5
experience: 2.5
Sheep:
income: 2.5
experience: 2.5
Wolf:
income: 5.0
experience: 5.0
Creeper:
income: 10.0
experience: 10.0
Skeleton:
income: 10.0
experience: 10.0
Spider:
income: 10.0
experience: 10.0
Zombie:
income: 10.0
experience: 10.0
Player:
income: 7.5
experience: 7.5
custom-kill:
Woodcutter:
income: 10.0
experience: 10.0
Miner:
income: 10.0
experience: 10.0
Digger:
income: 10.0
experience: 10.0
Farmer:
income: 10.0
experience: 10.0
Builder:
income: 10.0
experience: 10.0
Hunter:
income: 20.0
experience: 20.0
Fisherman:
fullname: Fisherman
shortname: Fi
ChatColour: AQUA
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Fish:
RAW_FISH:
income: 4.0
experience: 4.0
Kill:
Player:
income: 7.5
experience: 7.5
custom-kill:
Fisherman:
income: 10.0
experience: 10.0
Weaponsmith:
fullname: Weaponsmith
shortname: W
ChatColour: DARK_PURPLE
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Craft:
WOOD_SWORD:
income: 1.0
experience: 1.0
IRON_SWORD:
income: 2.0
experience: 2.0
GOLD_SWORD:
income: 3.0
experience: 3.0
DIAMOND_SWORD:
income: 4.0
experience: 4.0
None:
fullname: None
shortname: N
ChatColour: WHITE
chat-display: none
leveling-progression-equation: 100*((1.13+(0.01*(numjobs-1)))^(joblevel-1))
income-progression-equation: baseincome*((1.05)^(joblevel-1))
experience-progression-equation: baseexperience*((1.05)^(joblevel-1))
Kill:
Player:
income: 7.5

 

Up

 

В этой теме всё объяснено http://rubukkit.org/threads/Подключаем-плагины-к-mysql.11569/

 

Все подключил, вписал куда нужно, как теперь узнать, что все работает ? когда захожу на сервер, пишу команду плагина, все норм.

 

Что именно вам нужно узнать?

 

Правильно ли я все сделал ?работает ли ?

 

Зайдите в свою MySQL базу данных и посмотрите, создалась ли таблица!