{ new p_top[24],score,string[600],row[600]; mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10"); mysql_store_result(); mysql_fetch_row(row); sscanf(row, "p<|>s[600]d",p_top,score); format(string, sizeof string, "Top Player: %s | XP: %d",p_top,score); mysql_free_result(); ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Player", string, "Close", ""); return 1; }
COMMAND:topxp(playerid, params[])
Код:
{ new p_top[24],score,string[600],row[600]; mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10"); mysql_store_result(); mysql_fetch_row(row); sscanf(row, "p<|>s[600]d",p_top,score); format(string, sizeof string, "Top Player: %s | XP: %d",p_top,score); mysql_free_result(); ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Player", string, "Close", ""); return 1; } |
new p_top[24],score,string[600],row[600];
mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10");
mysql_store_result();
while( mysql_fetch_row(row) ) {
sscanf(row, "p<|>s[600]d",p_top,score);
format(string, sizeof string, "%sTop Player: %s | XP: %d", string, p_top,score);
}
mysql_free_result();
ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Players", string, "Close", "");
return 1;
new p_top[24],score,string[600],row[600];
mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10");
mysql_store_result();
while( mysql_fetch_row(row) ) {
sscanf(row, "p<|>s[600]d",p_top,score);
format(string, sizeof string, "%sTop Player: %s | XP: %d\n", string, p_top,score);
}
mysql_free_result();
ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Players", string, "Close", "");
return 1;
But How do i make like this.
1)greatm8 || XP:696969 (adding number) |
new p_top[24],score,string[600],row[600];
mysql_query("SELECT playerName, playerXP FROM playerdata ORDER BY playerXP DESC Limit 10");
mysql_store_result();
new Count = 1;
while( mysql_fetch_row(row) ) {
sscanf(row, "p<|>s[600]d",p_top,score);
format(string, sizeof string, "%s%d) Top Player: %s | XP: %d\n", string, Count, p_top,score);
Count++;
}
mysql_free_result();
ShowPlayerDialog(playerid, 108, DIALOG_STYLE_MSGBOX,"Top Players", string, "Close", "");
return 1;