MysQL - těžké začátky

[TheSwoody]

Server: 82.208.17.16:27728

Zdravím, potřebuji pomoc a už si nevím rady proto jsem se obrátil zde na fórum.
Hledal jsem na fóru nějaký "záčátky s MysQL" a nenašel tak se chci zeptat, potřebuji poradit jaké pluginy které vidíte na screenu ( http://ctrlv.cz/qgbs ) nahodit na mysql + nějaký podrobný návod jak protože ani nevím co kde napsat a co všechno znamená.
Vím že musím nahodit iConomy a HawkEye protože mi to hází errory v konzoli skrz to ale nevím které pluginy z těch co tam mám jsou ještě potřeba.

Vyskytl se v konzoli další error a právě nevím jestli je to způsobenou mysql nebo něčím jiným...

Spoiler: zobrazit

Kód: Vybrat vše

> [22:38:29 ERROR]: Error initializing FakaHedaMinequery
java.net.BindException: Cannot assign requested address
at java.net.PlainSocketImpl.socketBind(Native Method) ~[?:1.7.0_51]
at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:376) ~[?:1.7.0_51]
at java.net.ServerSocket.bind(ServerSocket.java:376) ~[?:1.7.0_51]
at java.net.ServerSocket.bind(ServerSocket.java:330) ~[?:1.7.0_51]
at fakahedaminequery.QueryServer.<init>(QueryServer.java:69) ~[FakaHedaMinequery.jar:?]
at fakahedaminequery.Minequery.onEnable(Minequery.java:112) [FakaHedaMinequery.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.loadPlugin(CraftServer.java:441) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.enablePlugins(CraftServer.java:375) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.n(MinecraftServer.java:344) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.g(MinecraftServer.java:319) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.a(MinecraftServer.java:275) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.DedicatedServer.init(DedicatedServer.java:175) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:426) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

> [22:38:29 ERROR]: Error occurred while enabling FakaHedaMinequery v1.3 (Is it up to date?)
java.lang.IllegalStateException: Cannot enable - FakaHedaMinequery not initialized
at fakahedaminequery.Minequery.onEnable(Minequery.java:119) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250) ~[minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.loadPlugin(CraftServer.java:441) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.enablePlugins(CraftServer.java:375) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.n(MinecraftServer.java:344) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.g(MinecraftServer.java:319) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.a(MinecraftServer.java:275) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.DedicatedServer.init(DedicatedServer.java:175) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:426) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

Dopředu moc děkuji všem co se mnou budou mít trpělivost a pomůžou mi a omlouvám se, v tomhle jsem fakt levej :/

[Aishak]

Dej sem configy pluginů, které chceš hodit na mysql a já ti je popíšu co a jak. Jinak k té chybě. Je to způsobené pluginem FakahedaMineQuery (je to jasně vidět) a bude chyba nejspíše s kompatibilitou. Mě se to občas stalo a po restartu to šlo zase normálně. Pokud to bude dělat pořád, tak napiš ticket v CP.

[TheSwoody]

No právě bych chtěl vědět které pluginy potřebuji napojit na mysql, aby byl chod serveru čistý bez erroru.

Jinak tu máš HawkEye:

Spoiler: zobrazit

Kód: Vybrat vše

log:
  lava-bucket: false
  water-bucket: false
  item-place: false
  pvp-death: false
  mob-death: false
  other-death: false
  command: false
  chat: false
  join: false
  quit: false
  door-interact: false
  open-container: false
  container-transaction: false
  item-pickup: false
  item-drop: false
  button: false
  teleport: false
  lever: false
  sign-place: false
  sign-break: false
  item-break: false
  flint-steel: false
  block-place: true
  block-break: true
  block-burn: false
  block-fade: false
  block-form: false
  leaf-decay: false
  mushroom-grow: false
  tree-grow: false
  water-flow: false
  lava-flow: false
  explosion: false
  enderman-pickup: false
  enderman-place: false
  entity-kill: false
  other: false
  spawnmob-egg: false
  herochat: false
  entity-modify: false
  block-inhabit: false
  super-pickaxe: false
  worldedit-place: false
  worldedit-break: false
  crop-trample: true
  block-ignite: false
  fallingblock-place: true
  player-water-flow: false
  player-lava-flow: false
general:
  max-lines: 0
  log-item-drops-on-death: false
  cleanse-period: 20m
  cleanse-age: 0
  delete-data-on-rollback: true
  log-ip-addresses: false
  debug: false
  debug-level: low
  max-radius: 0
  give-user-tool: true
  tool-block: '17'
  default-here-radius: 5
  default-tool-command: ''
  check-for-updates: true
  op-permissions: false
  simplify-time: true
  log-delay: 2
  max-write-logs: 5000
mysql:
  hawkeye-table: hawkeye
  port: 3306
  player-table: hawk_players
  username: root
  world-table: hawk_worlds
  hostname: localhost
  max-connections: 10
  password: ''
  database: minecraft
ignore-worlds:
- thisworldisignored
- soisthisone
command-filter:
- /login
- /restartsrv
- /register
- /spawn
block-filter:
- 567
containertransaction-filter:
  chest: true
  doublechest: true
  furnace: true
  dispenser: true
version: 1.6.0


a iConomy:

Spoiler: zobrazit

Kód: Vybrat vše

# 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:
  Permissions:
    Use:
      # Should a user have the 'iConomy.holdings' to use /money
      # By default this is false, so that people stop complaining that
      # iConomy doesn't work. Yes, people actually report that.
      # If you are one of those people, leave this false.
      Holdings: false

  Default:
    Currency:
      # Major is the first segment [Major].Minor

      # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Major: [ 'MW Dukat', 'MW Dukatu' ]

      # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
      Minor: [ 'Coin', 'Coins' ]

    Account:
      # Default account balance when created
      Holdings: 30.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: false                               # 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: false

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

  # Purges Default Balances at Loading
  # Good way to keep unused accounts or default accounts wiped out and lower database usage.
  Purging:
    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: 'sql'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # 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] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port 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'

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

    ##############################################################
    # !!! Conversion is not your database settings !!!
    ##############################################################
    # 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

Jinak stačí napsat další pluginy které ti sem mám dát a já tak udělám, moc ti děkuji za pomoc!

[Mikko]

Niektoré errory niesu sposobené tým že ich nedaš na MySQL ale napr chyba v configu alebo tak. Odporúčam s dať všetky dôležité pluginy na DB.

[TheSwoody]

Error HawkEye:

Spoiler: zobrazit

Kód: Vybrat vše

> [22:38:30 INFO]: [HawkEye] Enabling HawkEye v1.6.0
> [22:38:30 INFO]: [HawkEye] Starting HawkEye 1.6.0 initiation process...
> [22:38:30 INFO]: [HawkEye] Searching for updates..
> [22:38:30 ERROR]: [HawkEye] Error whilst attempting to get connection: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
> [22:38:30 ERROR]: [HawkEye] Error initiating HawkEye database connection, disabling plugin
> [22:38:30 INFO]: [HawkEye] Disabling HawkEye v1.6.0
> [22:38:30 ERROR]: Error occurred while disabling HawkEye v1.6.0 (Is it up to date?)
java.lang.NullPointerException
at uk.co.oliwali.HawkEye.HawkEye.onDisable(HawkEye.java:79) ~[?:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:252) ~[minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.java.JavaPluginLoader.disablePlugin(JavaPluginLoader.java:348) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.SimplePluginManager.disablePlugin(SimplePluginManager.java:423) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at uk.co.oliwali.HawkEye.HawkEye.onEnable(HawkEye.java:136) [HawkEye.jar:?]
at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:250) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:324) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:404) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.loadPlugin(CraftServer.java:441) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at org.bukkit.craftbukkit.v1_7_R2.CraftServer.enablePlugins(CraftServer.java:375) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.n(MinecraftServer.java:344) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.g(MinecraftServer.java:319) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.a(MinecraftServer.java:275) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.DedicatedServer.init(DedicatedServer.java:175) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.MinecraftServer.run(MinecraftServer.java:426) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

at net.minecraft.server.v1_7_R2.ThreadServerApplication.run(SourceFile:618) [minecraft_server.jar:git-Bukkit-1.7.2-R0.3-14-g8f8716c-b3042jnks]

[Arcas]

Kód: Vybrat vše

[22:38:30 ERROR]: [HawkEye] Error whilst attempting to get connection: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)

Nezadal jsi v configu údaje k MySQL.

[Hanakocz]

MySQL je ještě dobré pro PEX, pak už to HawkEye, co tu už řešítem, a iConomy....jde o to, že tam je dobré mít takové věci, co se buď často mění (to jso uty peníze a logger činnosti) , nebo to, kde se další pluginy často ptají, jak to je (permissiony)

[TheSwoody]

Děkuju moc a teď bych prosil radu jak teda ty určité pluginy navedu na mysql, protože fakt nevím kam co mám napsat. Zkoušel jsem navést plugin market na web a na mysql a píše to "Problém s databází, kontaktujte nás přes ticket systém" takže jsem to asi někde po...

[Aishak]

Takže, prvně hawkeye:

Kód: Vybrat vše

log:
  lava-bucket: false
  water-bucket: false
  item-place: false
  pvp-death: false
  mob-death: false
  other-death: false
  command: false
  chat: false
  join: false
  quit: false
  door-interact: false
  open-container: false
  container-transaction: false
  item-pickup: false
  item-drop: false
  button: false
  teleport: false
  lever: false
  sign-place: false
  sign-break: false
  item-break: false
  flint-steel: false
  block-place: true
  block-break: true
  block-burn: false
  block-fade: false
  block-form: false
  leaf-decay: false
  mushroom-grow: false
  tree-grow: false
  water-flow: false
  lava-flow: false
  explosion: false
  enderman-pickup: false
  enderman-place: false
  entity-kill: false
  other: false
  spawnmob-egg: false
  herochat: false
  entity-modify: false
  block-inhabit: false
  super-pickaxe: false
  worldedit-place: false
  worldedit-break: false
  crop-trample: true
  block-ignite: false
  fallingblock-place: true
  player-water-flow: false
  player-lava-flow: false
general:
  max-lines: 0
  log-item-drops-on-death: false
  cleanse-period: 20m
  cleanse-age: 0
  delete-data-on-rollback: true
  log-ip-addresses: false
  debug: false
  debug-level: low
  max-radius: 0
  give-user-tool: true
  tool-block: '17'
  default-here-radius: 5
  default-tool-command: ''
  check-for-updates: true
  op-permissions: false
  simplify-time: true
  log-delay: 2
  max-write-logs: 5000
mysql:
  hawkeye-table: hawkeye
  port: 3306
  player-table: hawk_players
  username: root
  world-table: hawk_worlds
  hostname: localhost
  max-connections: 10
  password: ''
  database: minecraft
ignore-worlds:
- thisworldisignored
- soisthisone
command-filter:
- /login
- /restartsrv
- /register
- /spawn
block-filter:
- 567
containertransaction-filter:
  chest: true
  doublechest: true
  furnace: true
  dispenser: true
version: 1.6.0

pro napojení na mysql tě bude zajímat část, budu zde vkládat komentáře za znak # s vysvětlením co a jak:

Kód: Vybrat vše

mysql:
  #jmeno tabulky v databazi pro plugin hawkeye, nemusis menit
  #pokud se ale za pul roku rozhodnes, ze to zmenis, musis zmenit nazev teto tabulky i v jiz vytvorene databazi
  chawkeye-table: hawkeye
  #port mysql serveru, defaultne je 3306 (ten stejny pouziva FH takze nemen)
  port: 3306
  #jmeno tabulky v databazi, kam se asi ukladaji nejake data o uzivateli (jak vyplyva z nazvu)
  #stejne jako u prvni tabulky nemusis menit
  player-table: hawk_players
  #uzivatel (username) je prihlasovaci jmeno do databaze, to ti bylo prideleno FH
  #zmen hodnotu root na pridelene uz. jmeno
  username: root
  #jmeno tabulky v databazi kam se budou ukladat asi nejake data ze svetu
  #opet nemusis menit
  world-table: hawk_worlds
  #hostname pokud se nepletu, muze na FH zustat localhost
  #doporucuji zmenit na IP, kterou ti FH zaslala spolecne s prihlasenim do mysql
  hostname: localhost
  #musel bych se podivat, ale max-connections budou asi pokusy o prihlaseni do mysql
  #nemusis menit
  max-connections: 10
  #heslo (password), zde samozrejme musis vyplnit heslo k mysql, opet ti prislo emailem od FH
  password: ''
  #database: = jmeno database, opet zaslano FH na tvuj email
  database: minecraft

a to je celé, pokud vyplníš správně jak jsem okomentoval, tak by se mělo připojení k mysql uskutečnit v pořádku. Za chvilku dopíšu ještě ten iConomy config.

-- 25 čer 2015, 09:05 --

iConomy

Kód: Vybrat vše

# 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:
  Permissions:
    Use:
      # Should a user have the 'iConomy.holdings' to use /money
      # By default this is false, so that people stop complaining that
      # iConomy doesn't work. Yes, people actually report that.
      # If you are one of those people, leave this false.
      Holdings: false

  Default:
    Currency:
      # Major is the first segment [Major].Minor

      # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Major: [ 'MW Dukat', 'MW Dukatu' ]

      # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
      Minor: [ 'Coin', 'Coins' ]

    Account:
      # Default account balance when created
      Holdings: 30.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: false                               # 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: false

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

  # Purges Default Balances at Loading
  # Good way to keep unused accounts or default accounts wiped out and lower database usage.
  Purging:
    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: 'sql'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # 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] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port 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'

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

    ##############################################################
    # !!! Conversion is not your database settings !!!
    ##############################################################
    # 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

bude tě zajímat část, která je již zakomentovaná, ale pro jistotu okomentuji ještě česky:

Kód: Vybrat vše

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
    ##
    # Zde vyberes uloziste dat pro iConomy, jelikoz chces pouzit mysql tak zde zadas mysql (dle komentu nahore)
    Type: 'mysql'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # 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 nemusis resit, to je zde pro plugin inventoryDB
    MajorItem: 266
    MinorItem: 265

    # This controls the database name, by default it is iConomy
    ##
    #Jmeno tabulky v databazi, kam se budou data ukladat, muzes klidne nechat iConomy
    #nebo si to muzes zmenit treba na 'ekonomika', je to jenom na tobe
    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] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port 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 je vlastne IP mysql serveru vcetne portu a nazvu databaze
    #zacatek (mysql) nebudes menit, zajima te az cast localhost, kam hodis IP mysql serveru
    #port :3306 nechej i s dvojtečkou, za port hodis lomitko / a za to nazev databaze
    #nazev databaze a IP si dostal emailem od fakahedy
    #celkove to pak bude vypadat nejak takto: URL: 'mysql://93.91.150.150:3306/32546_mysql_xx'
    URL: 'mysql://localhost:3306'

    # Login details for binary databases
    ##
    #Zde uz vyplnis jenom uzivatele (username) a heslo (password) k mysql
    #To ti zaslala opet FH na email, pote uz jenom ulozis na server a server spustit
    #pokud si vyplnil udaje spravne tak by se melo navazat uspesne spojeni
    Username: ''
    Password: ''

pokud ti nepůjde něco z toho, nebo pokud stále nebudeš chápat i mé komentáře tak mi napiš SZ a můžeme pak dát třeba hovor na skypu a vysvětlím ještě jinak.