SA-MP Forums Archive
Banned player (MYSQL) makes server crash - 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: Banned player (MYSQL) makes server crash (/showthread.php?tid=488012)



Banned player (MYSQL) makes server crash - SomebodyAndMe - 16.01.2014

Fixed


Re: Banned player (MYSQL) makes server crash - MatriXgaMer - 16.01.2014

I realy want to help you but i dont know much about MySQL


Re: Banned player (MYSQL) makes server crash - Zex Tan - 16.01.2014

Quote:
Originally Posted by MatriXgaMer
Посмотреть сообщение
I realy want to help you but i dont know much about MySQL
Then why did you even need to post in this thread since that you have no idea to help him!

On topic: You could minimize your code instead of sending lots of queries, use "SELECT * FROM bans" and use the sscanf format according to your database bans table. Example like your column is banindex, name, issuer, date, reason and expiration. So you could do something like this in your sscanf format. Make it like in the ascending order from the first column to the last column in your bans table.

pawn Код:
sscanf(query, "p<|>is[24]s[24]is[128]i", banindex, name, issuer, date reason, expirstion");



Re: Banned player (MYSQL) makes server crash - SomebodyAndMe - 16.01.2014

Fixed


Re: Banned player (MYSQL) makes server crash - Excelize - 17.01.2014

Quote:
Originally Posted by MatriXgaMer
Посмотреть сообщение
I realy want to help you but i dont know much about MySQL
Stop trying to increase your post count with a stupid excuse.