UltraBans banlist

[Neon1_Cz]

Asi tak

[fantomas2]

no spravil som to tak a teraz toto

Kód: Vybrat vše

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/users/minecraftking/minecraftking.4fan.cz/web/Banlist/index.php on line 103
V aplikaci se vyskytla následující chyba:
Tabulka v MySQL databázi, která má obsahovat tresty je prázdná
Reklamu na tomto hostingu zajišťuje Business Factory - internetová reklama a pokročilý internetový marketing.

[Neon1_Cz]

To znamená, že tabulka která má obsahovat tresty buď neexistuje, nebo jak ti to píše je prázdná, tudíž zkontroluj napojení Ultrabanu na databázi.

[fantomas2]

Ako sa to roba ? ta kontrola?

[Neon1_Cz]

Třeba že se kouknu jestli se vytvořila tabulka v databázi a zkontroluji config Ultrabanu?

[fantomas2]

Config

Kód: Vybrat vše

#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: SQLite
#MySQL Information#
MySQL:
  Database: 'jdbc:mysql://localhost:3306/minecraft'
  User: 'root'
  Password: 'root'
  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: 5
  #ban,kick,ipban,perma,tempban,tempipban#
  Result: ban
  Silent: true
  Reason: 'Max Warnings'
  #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: '*****'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    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: 'test testing tests pica kokot jebem pici kkt jebo gay pico kurva'
    #Wildcards %scramble% will scramble the word#
    #If no wildcards are present the message entered will replace the word#
    #leave blank to erase#
    Blocking: '*****'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    Reason: 'Vaz sva slova'
  #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: kick
    Silent: false
    Reason: 'Spam'
Muted:
  Vannila: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'
#Jail Configuration#
Jail:
  Mute: true
  Vanilla: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'
Messages:
  Ban:
    MsgToVictim: '&6Dostal si ban od &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 byl zabanovan adminem &7%admin%&6. Duvod: &7%reason%&6!'
    Failed: '&4%victim%&c uz je zabanovan.'
    Denied: '&cYour ban attempt has been denied!'
    Emo: '&cYou cannot ban yourself!'
    Login: '&7%admin%&6 byl si zabanovan serverem 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: '&6Mate IP ban od admina &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 dostal IP ban od admina &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: '&7Your IP is banned!'
  Jail:
    MsgToVictim: '&6You have been jailed by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was jailed by &7%admin%&6. Reason: &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: '&6Byl ste vyhozen adminem &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToVictim: '&6Byl ste vyhozen adminem &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 byl vyhozen adminem &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: '&6You have muted &7%victim%&6.'
    MuteMsgToVictim: '&4You have been muted!'
    UnmuteMsgToSender: '&6You have unmuted &7%victim%&6.'
    UnmuteMsgToVictim: '&aYou have been unmuted.'
    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: '&6Mate perma ban od admina &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 dostal perma ban 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 ste casovy ban od admina &7%admin%&6 do &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 dostal casovy ban od admina &7%admin%&6 do &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: '&6You have been tempbanned by &7%admin%&6 for &7%time%&6. Reason: &7%reason%&6!'
  TempIpBan:
    MsgToVictim: '&6Dostal ste casovy IP ban od &7%admin%&6 do &7%amt% %mode%s.&6 Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 Dostal casovy ban od amdmina &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: '&6You have been tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &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 odbanovan adminem &7%admin%&6!'
    PermaBanned: '&cUnable to unban, &7%victim%&c was Permabanned.'
    Failed: '&4%victim%&c is already unbanned!'
  Warn:
    MsgToVictim: '&6Byl si varovan adminem &7%admin%&6. Duvod: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 dostal varovani od admina &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

Screen ultrabanu s webu

[vojtamaniak]

Zadáváš do toho configu ultrabans správné username a password?

[Neon1_Cz]

Jak jsem tušil, nemáš to napojené na databázi.
Tuto část:

Kód: Vybrat vše

#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: SQLite
#MySQL Information#
MySQL:
  Database: 'jdbc:mysql://localhost:3306/minecraft'
  User: 'root'
  Password: 'root'
  Table: 'banlist'
  IPTable: 'banlistip'

uprav na:

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://localhost:3306/66252_mysql_db'
  User: '66252_mysql_db'
  Password: 'tady_heslo'
  Table: 'banlist'
  IPTable: 'banlistip'

[fantomas2]

Počkat to sa musí aj v configu UltraBans doplnovat tie MySQL údaje?

[vojtamaniak]

Ano, to je překvapení.