Server restarting - Printable Version

Server restarting - 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: Server restarting (/showthread.php?tid=628342)

Server restarting - Nin9r - 09.02.2017

server_logs:

[HTML]

Код HTML:

15:03:00] [debug] Server crashed while executing gmi.amx
[15:03:00] [debug] AMX backtrace:
[15:03:00] [debug] #0 native mysql_query () from mysql_static.so
[15:03:00] [debug] #1 004992e8 in public CheckAccountUserName (extraid=161) at D:\server\gmi.pwn:80162
[15:03:00] [debug] Native backtrace:
[15:03:00] [debug] #0 f7493e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so
[15:03:00] [debug] #22 080aa13a in ?? () from samp03svr

Line 80162:

Код HTML:

new Cache: cachee = mysql_query(handle, "SELECT * FROM `playeraccounts` WHERE `playerID` > '0'");

Код HTML:

	    new Cache: cachee= mysql_query(handle, "SELECT * FROM `playeraccounts` WHERE `playerID` > '0'");
		accamount = cache_get_row_count();
		cache_delete(cachee);

Re: Server restarting - Nin9r - 10.02.2017

bump?

Re: Server restarting - Vince - 10.02.2017

Don't use row_count if you only want to count something! That is terribly inefficient because it sends over the entire result set. Use the COUNT() aggregate function instead and then fetch the result like you would any regular integer variable.