05.04.2014, 07:52
Hey COuld someone convert this script to mysql r33 please?
pawn Код:
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;
}