[Mysql] position.
#6

But now i do with mysql,and i try to do it myself:

pawn Код:
new Query[ 100 ];
format(Query,sizeof(Query),"SELECT `Exp` FROM `playerdata` ORDER BY `Exp` DESC LIMIT %d", ReturnUserCount());
mysql_query(Query);
mysql_store_result();
new ID,tmpStr[64];
while(mysql_retrieve_row())
{
ID ++;
new scorevariable[5];
mysql_fetch_field_row(scorevariable, "Exp");
format(tmpStr, sizeof(tmpStr), "Your position is %d with %d XP",ID,strval(scorevariable));
}
mysql_free_result();
ShowPlayerDialog(playerid, 8, DIALOG_STYLE_MSGBOX, "players top10", tmpStr, "OK", "");
return 1;
}
But this is not work...
Reply


Messages In This Thread
[Mysql] position. - by budelis - 10.09.2011, 19:51
Re: [Mysql] position. - by [M]onsieur - 10.09.2011, 20:00
Re: [Mysql] position. - by budelis - 10.09.2011, 20:16
Re: [Mysql] position. - by [HiC]TheKiller - 10.09.2011, 20:33
Re: [Mysql] position. - by [M]onsieur - 10.09.2011, 20:37
Re: [Mysql] position. - by budelis - 11.09.2011, 06:37
Re: [Mysql] position. - by [HiC]TheKiller - 11.09.2011, 07:17
Re: [Mysql] position. - by budelis - 11.09.2011, 07:37
Re: [Mysql] position. - by Retardedwolf - 11.09.2011, 07:53
Re: [Mysql] position. - by budelis - 11.09.2011, 08:04

Forum Jump:


Users browsing this thread: 1 Guest(s)