18.06.2012, 21:08
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

