17.06.2012, 08:55
Now i try do diffrent, almost done, but problem here:
How you see here is all well.
IN MY GUI:
Where disappear TEST1?
Код:
stock TOP10(playerid) { new String[ 500 ],savingstring[ 1000 ]; mysql_query("SELECT Name,Kills FROM players ORDER BY Kills DESC LIMIT 10"); mysql_store_result(); new Allplayers; strcat(String,"TOP10 kills\n\n"); while(mysql_fetch_row_format(savingstring)) { Allplayers ++; new Username[24],Userkills; mysql_fetch_row(savingstring); sscanf(savingstring, "p<|>s[24]i", Username, Userkills); format(String, sizeof(String), "%s%d. %s %d kills\n", String, Allplayers, Username, Userkills); } mysql_free_result(); ShowPlayerDialog( playerid, 8, DIALOG_STYLE_MSGBOX, "TOP 10", String, "OK", "" ); return 1; }
Код:
[11:20:12] >> mysql_query( Connection handle: 1 ) [11:20:12] CMySQLHandler::Query(SELECT Name,Kills FROM players ORDER BY Kills DESC LIMIT 10) - Successfully executed. [11:20:12] >> mysql_store_result( Connection handle: 1 ) [11:20:12] CMySQLHandler::StoreResult() - Result was stored. [11:20:12] >> mysql_fetch_row_format( Connection handle: 1 ) [11:20:12] CMySQLHandler::FetchRow() - Return: TEST1|50 [11:20:12] >> mysql_fetch_row_format( Connection handle: 1 ) [11:20:12] CMySQLHandler::FetchRow() - Return: TEST2|41 [11:20:12] >> mysql_fetch_row_format( Connection handle: 1 ) [11:20:12] CMySQLHandler::FetchRow() - Return: HOUSE|8 [11:20:12] >> mysql_fetch_row_format( Connection handle: 1 ) [11:20:12] >> mysql_fetch_row_format( Connection handle: 1 ) [11:20:12] >> mysql_free_result( Connection handle: 1 ) [11:20:12] CMySQLHandler::FreeResult() - Result was successfully free'd.
IN MY GUI:
Код:
1. TEST2 - 41 kills 2. HOUSE - 8 kills