SA-MP Forums Archive
/top10. - 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: /top10. (/showthread.php?tid=352197)


/top10. - budelis - 18.06.2012

Now i try do diffrent, almost done, but problem here:

Код:
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.
How you see here is all well.

IN MY GUI:

Код:
1. TEST2 - 41 kills
2. HOUSE - 8 kills
Where disappear TEST1?

Re: /top10. - budelis - 19.06.2012

anyhelp?

Re: /top10. - budelis - 24.06.2012

UP...

Re: /top10. - Grand_Micha - 24.06.2012

Hello, son.

My first question: What are you trying to do? I can see the errors, but I am not sure if you want to do what it seems like you are trying to do.