mysql check ban - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql check ban (/showthread.php?tid=313824)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql check ban (/showthread.php?tid=313824)
mysql check ban - Ricop522 - 27.01.2012
Fxxxxxxxxed
Re: mysql check ban - Ricop522 - 28.01.2012
bump..
Re: mysql check ban - Scenario - 28.01.2012
Read the forum rules please. Don't bump your post until 48 (yes, it's changed) hours have passed!
As for the issue, which MySQL plugin are you using?
Re: mysql check ban - MP2 - 28.01.2012
Check the mysql log. If there's nothing useful there, debug it.
Re: mysql check ban - Ricop522 - 28.01.2012
Quote:
|
Originally Posted by RealCop228
 Read the forum rules please. Don't bump your post until 48 (yes, it's changed) hours have passed!
As for the issue, which MySQL plugin are you using? |
BlueG Plugin
There's nothing useful in Debug.. ;\
Re: mysql check ban - MP2 - 28.01.2012
Quote:
|
Originally Posted by MP2
If there's nothing useful there, debug it.
|
Re: mysql check ban - Bogdan1992 - 28.01.2012
This is my ban check, take a look over it.
PHP код:
//This is on playerconnect
new query[200], ip[16];
GetPlayerName(playerid, pname, sizeof pname);
GetPlayerIp(playerid, ip, 16);
format(query, sizeof(query), "SELECT * FROM `Banned` WHERE `User` LIKE '%s' OR `IP` LIKE '%s' LIMIT 1", pname, ip);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() >= 1)
{
format(query, sizeof(query), "UPDATE `Banned` SET IP='%s' WHERE `User` LIKE '%s'", ip, pname);
mysql_query(query);
SendClientMessage(playerid, COLOR_SILVER, "You are banned from this server");
TogglePlayerControllable(playerid, 0);
Kick(playerid);
}
mysql_free_result();
Re: mysql check ban - Ricop522 - 28.01.2012
THANKS!
Re: mysql check ban - Ricop522 - 01.02.2012
Bump. Continue with this question =/