Advertisement
Guest User

Untitled

a guest
Dec 13th, 2020
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 1.45 KB | None | 0 0
  1. public Cmd_TOP(id, iLevel, iCid)
  2. {
  3.     new data[5];
  4.     formatex(data,4,"%d",id);
  5.     new iErrorCode, Handle:iSqlConnection = SQL_Connect(g_iSqlTuple, iErrorCode, g_szSqlError, charsmax(g_szSqlError))
  6.     SQL_ThreadQuery(g_iSqlTuple, "QueryHandler2", "SELECT Name, XP FROM CRXRanks ORDER BY XP DESC LIMIT 15",data,5)
  7.     SQL_FreeHandle(iSqlConnection)
  8.     return PLUGIN_HANDLED
  9. }
  10.  
  11. public QueryHandler2(iFailState, Handle:iQuery, szError[], iErrorCode,data[], size, Float:querytime)
  12. {
  13.  
  14.     if (iFailState == TQUERY_CONNECT_FAILED)
  15.     {
  16.         log_amx("[SQL Error] Connection failed  2 (%i): %s", iErrorCode, szError)
  17.         return;
  18.     }
  19.     else if (iFailState ==  TQUERY_QUERY_FAILED)
  20.     {
  21.         log_amx("[SQL Error] Connection failed  2 (%i): %s", iErrorCode, szError)
  22.         return;
  23.     }
  24.     new str2[2048];
  25.    
  26.     if( SQL_NumResults(iQuery) > 0 )
  27.     {
  28.         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>");
  29.         while(SQL_MoreResults(iQuery))
  30.         {
  31.             add(str2,2047,"<tr><td>")
  32.             new str[64]
  33.             SQL_ReadResult(iQuery, 0, str, 63)
  34.             add(str2,2047,str)
  35.             add(str2,2047,"</td><td>")
  36.             new str3[64]
  37.             SQL_ReadResult(iQuery, 1, str3, 63)
  38.             add(str2,2047,str3);
  39.             add(str2,2047,"</td></tr>")
  40.             SQL_NextRow(iQuery)
  41.         }
  42.         add(str2,2047,"</table></body></html>");
  43.         show_motd(str_to_num(data), str2, "STATS")
  44.     }
  45.     else
  46.     {
  47.         show_motd(str_to_num(data), "ERROR", "STATS")
  48.     }
  49. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement