Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Cmd_TOP(id, iLevel, iCid)
- {
- new data[5];
- formatex(data,4,"%d",id);
- new iErrorCode, Handle:iSqlConnection = SQL_Connect(g_iSqlTuple, iErrorCode, g_szSqlError, charsmax(g_szSqlError))
- SQL_ThreadQuery(g_iSqlTuple, "QueryHandler2", "SELECT Name, XP FROM CRXRanks ORDER BY XP DESC LIMIT 15",data,5)
- SQL_FreeHandle(iSqlConnection)
- return PLUGIN_HANDLED
- }
- public QueryHandler2(iFailState, Handle:iQuery, szError[], iErrorCode,data[], size, Float:querytime)
- {
- if (iFailState == TQUERY_CONNECT_FAILED)
- {
- log_amx("[SQL Error] Connection failed 2 (%i): %s", iErrorCode, szError)
- return;
- }
- else if (iFailState == TQUERY_QUERY_FAILED)
- {
- log_amx("[SQL Error] Connection failed 2 (%i): %s", iErrorCode, szError)
- return;
- }
- new str2[2048];
- if( SQL_NumResults(iQuery) > 0 )
- {
- add(str2,2047,"<html><body bgcolor=^"gray^"><table bgcolor=^"white^" align=^"center^" border=^"1^" cellpadding=^"5^" cellspacing=^"5^"><tr><th>Name</th><th>XP</th></tr>");
- while(SQL_MoreResults(iQuery))
- {
- add(str2,2047,"<tr><td>")
- new str[64]
- SQL_ReadResult(iQuery, 0, str, 63)
- add(str2,2047,str)
- add(str2,2047,"</td><td>")
- new str3[64]
- SQL_ReadResult(iQuery, 1, str3, 63)
- add(str2,2047,str3);
- add(str2,2047,"</td></tr>")
- SQL_NextRow(iQuery)
- }
- add(str2,2047,"</table></body></html>");
- show_motd(str_to_num(data), str2, "STATS")
- }
- else
- {
- show_motd(str_to_num(data), "ERROR", "STATS")
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement