Stránka 1 z 1
MysQL - těžké začátky
Napsal: 24 čer 2015, 22:42
od 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...
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 :/
Re: MysQL - těžké začátky
Napsal: 24 čer 2015, 22:48
od 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.
Re: MysQL - těžké začátky
Napsal: 24 čer 2015, 22:50
od 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:
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:
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: trueJinak stačí napsat další pluginy které ti sem mám dát a já tak udělám, moc ti děkuji za pomoc!
Re: MysQL - těžké začátky
Napsal: 24 čer 2015, 22:54
od 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.
Re: MysQL - těžké začátky
Napsal: 24 čer 2015, 23:34
od TheSwoody
Error HawkEye:
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]
Re: MysQL - těžké začátky
Napsal: 24 čer 2015, 23:53
od 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.
Re: MysQL - těžké začátky
Napsal: 25 čer 2015, 00:02
od 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)
Re: MysQL - těžké začátky
Napsal: 25 čer 2015, 00:09
od 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...
Re: MysQL - těžké začátky
Napsal: 25 čer 2015, 08:52
od 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.0pro 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: minecrafta 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: truebude 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.