Convert R7 into R38 - 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: Convert R7 into R38 (
/showthread.php?tid=557086)
Convert R7 into R38 -
ReD_HunTeR - 12.01.2015
hello,
can you please convert this into r38?
pawn Код:
mysql_tquery("SELECT `Username`, `Scores` FROM `players` ORDER BY `Scores` DESC LIMIT 10");
mysql_store_result();
new ID, output[800];
while(mysql_retrieve_row())
{
ID ++;
new username[24], scorevariable[80];
cache_get_field_content_int(username, "Username");
cache_get_field_content_int(scorevariable, "Scores");
format(output, sizeof(output), "%s%d. %s %d Kills\n", output, ID, username, strval(scorevariable));
}
mysql_free_result();
ShowPlayerDialog(playerid, DIALOG_TOPSCORES, DIALOG_STYLE_MSGBOX, "Top 10 Scorer", output, "Ok", "Back");
Re: Convert R7 into R38 -
PaulDinam - 12.01.2015
Try this:
pawn Код:
mysql_tquery(dbHandle, "SELECT `Username`, `Scores` FROM `players` ORDER BY `Scores` DESC LIMIT 10", "OnSelectFinish", "");
forward OnSelectFinish();
public OnSelectFinish()
{
new ID, scores, output[800], username[MAX_PLAYER_NAME];
for(new i = 0; i < cache_get_row_count(); i++)
{
ID++;
cache_get_field_content(i, "Username", username);
scores = cache_get_field_content_int(i, "Scores");
format(output, sizeof(output), "%s%d. %s %d Kills\n", output, ID, username, scores);
}
ShowPlayerDialog(playerid, DIALOG_TOPSCORES, DIALOG_STYLE_MSGBOX, "Top 10 Scorer", output, "Ok", "Back");
return 1;
}
Didn't test so there might be bugs.