PHP Code:
public TopFunction(State, Query, Error[], ErrorCode, Data[])
{
static Client, Buffer[4096], Line[4096], Place, PlaceString[16], Name[32], Score, ScoreString[16], Kills, KillsString[16], Deaths, DeathsString[16], Points, PointsString[16], Time, TimeString[16];
Buffer[0] = '^0';
Client = str_to_num(Data);
Place = 0;
if (is_user_connected(Client))
{
add(Buffer, sizeof(Buffer) - 1, "<body bgcolor=#000000>");
add(Buffer, sizeof(Buffer) - 1, "<pre>");
formatex(Line, sizeof(Line) - 1, "<font color=#49B630 size=2>%-5s %-32s %-8s %-6s %-7s %-10s %-6s</font>^n<font color=#FFFFFF size=2>", "Place", "Name", "Score", "Kills", "Deaths", "Points", "Time");
add(Buffer, sizeof(Buffer) - 1, Line);
while (SQL_MoreResults(_:Query))
{
SQL_ReadResult(_:Query, 0, Name, sizeof(Name) - 1);
replace_all(Name, sizeof(Name) - 1, "<", "*");
replace_all(Name, sizeof(Name) - 1, "<", "*");
Score = SQL_ReadResult(_:Query, 1);
Kills = SQL_ReadResult(_:Query, 2);
Deaths = SQL_ReadResult(_:Query, 3);
Points = SQL_ReadResult(_:Query, 4);
Time = SQL_ReadResult(_:Query, 5);
AddCommas(Score, ScoreString, sizeof(ScoreString) - 1);
AddCommas(Kills, KillsString, sizeof(KillsString) - 1);
AddCommas(Deaths, DeathsString, sizeof(DeathsString) - 1);
AddCommas(Points, PointsString, sizeof(PointsString) - 1);
formatex(TimeString, sizeof(TimeString) - 1, "%d h", Time / 60);
formatex(PlaceString, sizeof(PlaceString) - 1, "%d.", ++Place);
formatex(Line, sizeof(Line) - 1, "%-5s %-32s %-8s %-6s %-7s %-10s %-6s^n", PlaceString, Name, ScoreString, KillsString, DeathsString, PointsString, TimeString);
add(Buffer, sizeof(Buffer) - 1, Line);
SQL_NextRow(_:Query);
}
add(Buffer, sizeof(Buffer) - 1, "</font></pre>");
show_motd(Client, Buffer, "Ranking");
}
SQL_FreeHandle(_:Query);
}
I want TOP 15 like this one just remove SQL and Points. THX in advance