Ultraban-problem

[tramvajak]

Server: 93.91.250.101:27663 Felixzone

zdravim

stal jse mi nejspíš problem a neco jsem zvoral a netušim co kde jak ....

chtel jsem odbanovat všechn hráče na serveru tak jsem jednoduse pres PhPmy admin v bans a IPbans smazal co tam bylo a asi jsem smazal neco co sem mazat nemel.....

jedine co v tam zustalo je :
name varchar(32) latin1_swedish_ci Ne Žádná
reason text latin1_swedish_ci Ne Žádná
admin varchar(32) latin1_swedish_ci Ne Žádná
time bigint(20) Ne Žádná
temptime bigint(20) Ne Žádná
id int(11) Ne Žádná auto_increment
type int(1) Ne 0


a v bansIP nezustalo vubec nic ve hre mi to ted pise internal error nejde ani kick zadny prikazy s ultra bans jedine co jde je /help ultraban....

pokud nekdo vi kde jsem udelal chybu zkuste mi prosim poradit dekuji

s pozdravem tramvajak

[Vojko]

Skús vymazať kompletne celú tabuľku UltraBanu ...

[tramvajak]

tak jsem to vymazal jedine co tam zustalo je :

type int(1) Ne 0


to kdyz vymazu tak se hned udela znova a ve hre to porad pise internal error

[Nyqi]

Hoď sem config UltraBans. Smaž heslo MySQL !

[tramvajak]

Spoiler: zobrazit

Database: MySQL
mysql-database: jdbc:mysql://localhost:3306/gs_27663_1
mysql-user: gs_27663_1
mysql-password:
mysql-table: banlist
mysql-table-ip: banlistip
sqlite-dbname: banlist
auto-complete: true
useFine: true
maxFineAmt: 0
useJail: false
useLockdown: true
useStarve: true
useForceRespawn: true
useEmpty: true
usePermaban: true
useWarn: true
useRules: true
defAdminName: Server
defReason: Nezadouci
lockdown: false
dupePolicy: false
PingCheck: false
HostPingTimeOut: 1800
LogonInfo: false
messages:
banMsgFailed: '&c%victim% &8is already banned!'
unbanMsg: '&8Successfully unbanned &c%victim%&8!'
unbanMsgBroadcast: '&c%victim% &8was unbanned by &9%admin%&8!'
unbanMsgFailed: '&c%victim% &8is already unbanned!'
kickAllMsg: '%admin% kicked everyone. Reason: %reason%!'
kickMsgVictim: 'You have been kicked by %admin%. Reason: %reason%!'
kickMsgBroadcast: '&c%victim% &8was kicked by &9%admin%&8. Reason: &c%reason%!'
kickMsgFailed: '&8Kick failed: &8%victim% &8isn''t online.'
banMsgVictim: 'You have been banned by %admin%. Reason: %reason%!'
banMsgBroadcast: '&c%victim% &8was banned by &9%admin%&8. Reason: &c%reason%!'
permbanMsgVictim: 'You have been permabanned by %admin%. Reason: %reason%!'
permbanMsgBroadcast: '&c%victim% &8has been permabanned by &9%admin%&8. Reason:
&c%reason%!'
tempbanMsgVictim: 'You have been temp. banned by %admin%. Reason: %reason%!'
tempbanMsgBroadcast: '&c%victim% &8was temp. banned by &9%admin%&8. Reason: &c%reason%!'
LoginTempban: '&8You are banned until &c%time%&8! Reason: &c%reason%!'
LoginBan: '&8You are banned from this server! Reason: &c%reason%!'
LoginIPBan: Your IP is banned!
fineMsgVictim: You have been fined by %admin% in the amount of %amt%!
fineMsgBroadcast: '&c%victim% &8was fined by &9%admin%&8 in the amount of &c%amt%!'
emptyMsgVictim: '&9%admin% has cleared your inventory!'
emptyMsgBroadcast: '&9%admin% has cleared the inventory of &c%victim%!'
starveMsgVictim: '&8You are now starving!'
starveMsgBroadcast: '&c%victim% is now starving!'
fspawnMsgVictim: '&8You have been sent to spawn!'
fspawnMsgBroadcast: '&c%victim% &8is now at spawn!'
jailMsgVictim: '&8You have been jailed by &9%admin%&8. Reason: &c%reason%!'
jailMsgRelease: '&c%victim% &8was released from jail by &9%admin%&8!'
jailMsgBroadcast: '&c%victim% &8was jailed by &9%admin%&8. Reason: &c%reason%!'
warnMsgVictim: '&8You have been warned by &9%admin%&8. Reason: &c%reason%!'
warnMsgBroadcast: '&c%victim% &8was warned by &9%admin%&8. Reason: &c%reason%!'
lockMsgLogin: Server is under a lockdown, Try again later! Sorry.
DupeIPKick: Duplicate IP addresses disabled.
jailCmdMsg: You cannot use commands while jailed!
jailChatMsg: Your cry falls on deaf ears.
jailPlaceMsg: You cannot place blocks while you are jailed!
jailBreakMsg: You cannot break blocks while you are jailed!
muteChatMsg: You have been muted!
unmuteMsgVictim: You have been unmuted.
unmuteMsg: You have unmuted %victim%.
ruleMsg: '&9The Servers Rules Are As Follows!'
rules: {}
jail:
x: 209
y: 69
z: 439
yaw: 0
pitch: 0
world: world

[Mysteria]

Jak jsi to mazal? MySQL má na to přímo příkaz (z hlavy nevím), ale v PHPMyAdminovi je to vyprázdnit tabulku, která smaže veškerý obsah tabulky, nic víc.

[tramvajak]

ja jsem sel proste do phpmyadmin > bans a tam jsem smazal vsechno co tam bylo nic tam nezustalo ten config co jsem poslal se mi zda ze je dobrej delal ho LavorekCz takze pochybuju ze by byl spatnej takze jsem neco pokazil ja vtom phpmyadmins protoze jinam jsem nesahal

[tramvajak]

tak jsem kousek popolezl uz mi to nevyhazuje internal error ale normalne to napise ze jsem zabanoval hrace duvd a tak dal


ovsem ten hrac se normalne muze pripojit na server a ban nema takze neco nefunguje...

+ na strankach mi ban list pise tohle : Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /data/web/virtuals/17357/virtual/www/subdom/banlist/index.php on line 134

[nejento]

Dal bys nám odkaz?

[tramvajak]

jestli myslis odkaz na stranky s banama tak tady je : http://www.felixzone.eu/?page_id=20