[Nin9r]

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);

[Nin9r]

bump?

[Vince]

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.