Stránka 1 z 2
Mysql
Napsal: 24 bře 2013, 13:47
od enalan
Server: Podpis Ahoj, umí tu někdo v ultrabans zapojit mysql, aby mi šel /banlist ? (ve hře) Díky
Re: Mysql
Napsal: 24 bře 2013, 13:49
od Smexhy
Pošli config ultrabans...
Re: Mysql
Napsal: 24 bře 2013, 14:02
od enalan
Zde:
Kód: Vybrat vše
#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: MySQL
#MySQL Information#
MySQL:
Database: ''jdbc:mysql://bane.fakaheda.eu:3306/117527_web''
User: '117527_web'
Password: 'heslo'
Table: 'banlist'
IPTable: 'banlistip'
#SQLite Information#
SQLite:
Filename: 'banlist'
#delete dat on ban#
CleanOnBan: true
#clear warnings on ban#
ClearWarnOnBan: false
Log:
Enabled: true
#Max Warnings#
MaxWarning:
Enable: false
Amt: 3
#ban,kick,ipban,perma,tempban,tempipban#
Result: tempban
Silent: true
Reason: 'Uz jsi byl mockrat varovan!'
#Used with Temporary actions#
Temp:
Amt: 5
#sec,min,hour,day,week,month#
Mode: day
#Default labels#
Label:
Console: 'Server'
Reason: 'Unsure'
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
Lockdown: false
Login:
#Check for duplicates on Login#
DupeCheck:
Enable: true
#PingBack joining players, and kick if unreachable. //Experimental#
ProxyPingBack:
Enable: false
#How long in milliseconds to Timeout#
Timeout: 10000
#This will set the server to sync the database if multiple servers are in place.#
Sync:
Enabled: false
#Timing is in Long format Example:#
#1 Hour = 60 Seconds * 60 Minutes * 20 ServerTickRatePerSec = 72000L
Timing: 72000L
#Auto Updater#
AutoUpdater:
Enabled: true
#Chat#
Chat:
#Checks Chat Messages for a valid IP address#
#If its not valid, trust me they can't connect to it#
IPCheck:
Enable: true
#Wildcards %scramble% will scramble the ip and %replace% will show your ip instead#
#If no wildcards are present the message entered will replace the ip#
#leave blank to erase#
Blocking: '{zablokovano}'
#kick,jail,warn,ban,ipban, leave blank for no action#
Result: warn
Silent: true
Reason: 'Advertising'
#This will allow you to filter out messages containing any words that you define#
SwearCensor:
Enable: true
#Use your imagination these are not for me to decide#
Words: 'kokot'
#Wildcards %scramble% will scramble the word#
#If no wildcards are present the message entered will replace the word#
#leave blank to erase#
Blocking: '{Block}'
#kick,jail,warn,ban,ipban, leave blank for no action#
Result: warn
Silent: false
Reason: 'Language'
#Checks if the message is duplicate and disables it#
SpamCheck:
Enable: true
#The amount of messages to give a result#
Counter: 10
#kick,jail,warn,ban,ipban, leave blank for no action#
Result: ban
Silent: false
Reason: 'Spam'
Muted:
Vannila: true
#When Vanilla: true allowed commands.#
AllowedCommands:
- '/login'
- '/register'
- '/home'
- '/spawn'
#Jail Configuration#
Jail:
Mute: true
Vanilla: true
#When Vanilla: true allowed commands.#
AllowedCommands:
- '/login'
- '/register'
Messages:
Ban:
MsgToVictim: '&6Dostal jsi ban od &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 Byl zabanovan od &7%admin%&6. duvod: &7%reason%&6!'
Failed: '&4%victim%&c is already in banned.'
Denied: '&cYour ban attempt has been denied!'
Emo: '&cYou cannot ban yourself!'
Login: '&7%admin%&6 na tomhle servery mas ban! duvod: &7%reason%&6!'
CheckBan:
Header: '&6Found &7%amt%&6 records for &7%victim%&6.'
None: '&cNo records found for &4%victim%&c.'
Clean:
Complete: '&6Deleted &7%amt%&6 player.dat files.'
DupeIP:
Failed: '&cUnable to view ip for &4%victim% &c!'
Header: '&6Scanning Current IP of &7%victim%&6: &7%ip% !'
Completed: '&aScanning Complete!'
Empty:
MsgToVictim: '&7%admin%&6 has cleared your inventory!'
MsgToSender: '&7%admin%&6 has cleared the inventory of &7%victim%&6!'
Online: '&4%victim%&c must be online.'
Export:
Failed: '&cCould not export ban lists.'
Completed: '&aExported banlists.'
History:
Header: '&6Ultrabans Listing &7%amt%&6 Records.'
Failed: '&cUnable to find any bans.'
Import:
Loading: '&cBe patient. Loading...'
Failed: '&cCould not import ban list.'
Completed: '&aSystem imported the banlist to the database.'
InvOf:
Failed: '&cUnable to find player.'
Console: '&cThis command must be executed by a &4player&c.'
IPBan:
MsgToVictim: '&6Mas IPban od &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 dostal IPban od &7%admin%&6. duvod: &7%reason%&6!'
IPNotFound: '&cIP address not found. &6Processed as a normal ban for &7%victim%&6!'
Failed: '&4%victim%&c is already in banned.'
Denied: '&cYour ipban attempt has been denied!'
Emo: '&cYou cannot ipban yourself!'
Login: '&7Zde mas IPban za porusovani pravidel!'
Jail:
MsgToVictim: '&6Jsi v jail od: &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 je jailu od: &7%admin%&6. duvod: &7%reason%&6!'
SetJail: '&aJail has been set!'
SetRelease: '&aRelease has been set!'
Failed: '&4%victim%&c is already in jail.'
Online: '&4%victim%&c must be online to be jailed.'
Denied: '&cYour jail attempt has been denied!'
Emo: '&cYou cannot jail yourself!'
PlaceMsg: '&cYou cannot place blocks while you are jailed!'
BreakMsg: '&cYou cannot break blocks while you are jailed!'
Kick:
MsgToAll: '&6Everyone has been kicked by &7%admin%&6. Reason: &7%reason%&6!'
MsgToVictim: '&6Dostal jsi kick od &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 byl kicknut od &7%admin%&6. duvod: &7%reason%&6!'
Online: '&4%victim%&c must be online.'
Denied: '&cYour kick has been denied!'
Emo: '&cYou cannot kick yourself!'
Lockdown:
Start: '&cLockdown initiated. &4Player Login&c disabled.'
End: '&aLockdown ended. &2Player Login&a reenabled.'
Status: '&cLockdown is disabled.'
LoginMsg: '&4Server is under a lockdown, Try again later!&c Sorry.'
Mute:
MuteMsgToSender: '&6Mas mute od &7%victim%&6.'
MuteMsgToVictim: '&4Mas mute !'
UnmuteMsgToSender: '&6Dostal jsi unmuted &7%victim%&6.'
UnmuteMsgToVictim: '&aMas unmute.'
Denied: '&cYour mute has been denied!'
Emo: '&cYou cannot mute yourself!'
Chat: '&cYour cry falls on deaf ears.'
Pardon:
Msg: '&7%victim%&6 was released from jail by &7%admin%&6!'
PermaBan:
MsgToVictim: '&6Dostal jsi permaban od &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 byl permamentne zabanovan od &7%admin%&6. duvod: &7%reason%&6!'
Failed: '&4%victim%&c is already banned.'
Online: '&4%victim%&c must be online.'
Denied: '&cYour permaban has been denied!'
Emo: '&cYou cannot permaban yourself!'
Spawn:
MsgToVictim: '&cYou have been sent to spawn!'
MsgToSender: '&7%victim%&6 is now at spawn!'
Failed: '&4%victim%&c is not online.'
Starve:
MsgToVictim: '&cYou are now starving!'
MsgToSender: '&6%victim%&7 is now starving!'
Failed: '&4%victim%&c is not online.'
Denied: '&cYour starve attempt has been denied!'
Emo: '&cYou cannot starve yourself!'
TempBan:
MsgToVictim: '&6Dostal jsi casovany ban od &7%admin%&6 na: &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 dostal casovany ban od &7%admin%&6 na &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
Failed: '&4%victim%&c is already tempbanned!'
Denied: '&cYour tempban has been denied!'
Emo: '&cYou cannot tempban yourself!'
Login: '&6Mas casovany ban od: &7%admin%&6 do: &7%time%&6. duvod: &7%reason%&6!'
TempIpBan:
MsgToVictim: '&6Dostal jsi casovany IPban od &7%admin%&6 do &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 Dostal casovany IPban od: &7%admin%&6 do: &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
Failed: '&4%victim%&c is already tempipbanned!'
Denied: '&cYour tempipban has been denied!'
Emo: '&cYou cannot tempipban yourself!'
IPNotFound: '&cIP address not found.&6 Processed as a normal tempban for &7%victim%&6!'
TempJail:
MsgToVictim: '&6Dostal jsi casovany jail od: &7%admin%&6 do: &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 Je v jailu od: &7%admin%&6 do: &7%amt% %mode%s.&6 duvod: &7%reason%&6!'
Failed: '&4%victim%&c is already jailed!'
Denied: '&cYour tempjail has been denied!'
Emo: '&cYou cannot tempjail yourself!'
Unban:
MsgToBroadcast: '&7%victim%&6 byl unbanovan od &7%admin%&6!'
PermaBanned: '&cUnable to unban, &7%victim%&c was Permabanned.'
Failed: '&4%victim%&c is already unbanned!'
Warn:
MsgToVictim: '&6byl jsi varovan od: &7%admin%&6. duvod: &7%reason%&6!'
MsgToBroadcast: '&7%victim%&6 byl varovan od: &7%admin%&6. duvod: &7%reason%&6!'
Denied: '&cYour warning has been denied!'
Emo: '&cYou cannot warn yourself!'
MaxWarn:
MsgToBroadcast: '&7%cmd%&6 performed by Ultrabans on &7%victim%&6. Reason: &7Reached Max Warnings&6!'
Permission: 'You do not have the required permissions.'
Mode:
Second: Second
Minute: Minute
Hour: Hour
Day: Day
Week: Week
Month: Month
Year: Year
#Do Not Change Values Below#
Config:
Version: 3.0
Re: Mysql
Napsal: 24 bře 2013, 14:16
od Smexhy
Má to vyzerať nejak takto:
Kód: Vybrat vše
MySQL:
Database: jdbc:mysql://localhost:3306/gs_port_1
User: gs_port_1
Password: xxxxxxxx
Table: banlist
IPTable: banlistipSamozrejme musíš mať MySQL údaje svoje...
Re: Mysql
Napsal: 24 bře 2013, 14:22
od enalan
takže doplnit jen heslo ?
Re: Mysql
Napsal: 24 bře 2013, 14:23
od Smexhy
a ten port... gs_port_1
Re: Mysql
Napsal: 24 bře 2013, 14:25
od enalan
takže:
Kód: Vybrat vše
MySQL:
Database: jdbc:mysql://localhost:3306/gs_port_1
User: gs_port_1
Password: heslo_od_mysql
Table: banlist
IPTable: banlistipa kam ten port ?
Re: Mysql
Napsal: 24 bře 2013, 14:56
od Smexhy
lol ten port dáš miesto toho slova port takto:
gs_port_1 -> gs_27706_1
Re: Mysql
Napsal: 24 bře 2013, 14:58
od enalan
Díky a co mám udělat v Mysql ? Nic ?
Re: Mysql
Napsal: 24 bře 2013, 16:31
od Smexhy
Podľa toho čo chceš dosiahnuť. V podstate už netreba robiť nič, plugin ti odteraz zapisuje bany do databáze...