PDA

View Full Version : MYSQL TOP `X` Players Dialog Example???


nGen.SoNNy
10/05/2012, 01:11 PM
Hello!

Can somebody give me an example of mysql top player order by ex: Score ??:D in MSGBOX style dialog:D

REP++; :)

nGen.SoNNy
10/05/2012, 01:31 PM
No Ideas???

Vince
10/05/2012, 01:34 PM
select name, score from playertable order by score desc limit 5

I'm not in the mood to type out an entire function, so here's some pseudo-code.

while( fetch row )
sscanf/split/explode
format tempstring
strcat output, tempstring

showplayerdialog


Edit: damn, if I'd have seen that bump earlier I wouldn't have replied at all.

nGen.SoNNy
10/05/2012, 01:51 PM
Thx! and when you have a good mood type all the example!

SuperViper
10/05/2012, 02:25 PM
new playerData[30], playersName[MAX_PLAYER_NAME], playersScore;
mysql_query("SELECT `name`, `score` FROM `users` ORDER BY `score`");
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_row(playerData);
sscanf(playerData, "p<|>s[24]d", playersName, playersScore);
// do something with 'playersName' and 'playersScore'
}
mysql_free_result();

nGen.SoNNy
10/05/2012, 02:32 PM
I will try this :D Thx! REP++:D

EDIT: and if i want to order by score and money?:D

I made this but have some bugs:| Can Fix this?

CMD:top(playerid, params[])
{
new playerData[512], clanname[MAX_PLAYER_NAME], string[512], clankills;
mysql_query("SELECT `clanname`, `clankills` FROM `clans` ORDER BY `clankills`");
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_row(playerData);
sscanf(playerData, "p<|>s[512]d", clanname, clankills);
// do something with 'playersName' and 'playersScore'
format(string, sizeof(string), "%s\n"R"Clan: %s"W"Kills: %d", string, clanname, clankills);
//SendClientMessage(playerid, ~1, string);
ShowPlayerDialog( playerid, 1, DIALOG_STYLE_MSGBOX,"Location: Top Clans", string, "(Close)", "");
}
mysql_free_result();
return 1;
}