Advertisement
ricop522

[PAWN] Sistema de Bans em MySQL

Feb 17th, 2012
466
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.00 KB | None | 0 0
  1. /*
  2.     native serverBan(playereid, adminid, motivo[])
  3.     native checarBan(playerid)
  4.     native conectar()  // ongamemodeinit
  5.     native desconectar() //ongamemodeexit
  6.    
  7.     Créditos, Ricop522
  8. */
  9. #include <a_mysql>
  10. #include <a_samp>
  11.  
  12. #define              SERVER_HOST               "localhost"
  13. #define              SERVER_USER                    "root"
  14. #define              SERVER_PASSWORD                    ""
  15. #define              SERVER_DB                       "qrp"
  16. new
  17.     xconectar,
  18.     xstring[128];
  19.  
  20. stock serverBan ( playerid, adminid, motivo[] ) {
  21.     new
  22.         IP[30],
  23.         d,m,a, hr, mi, seg, data[30]
  24.         ;
  25.  
  26.     getdate(d,m,a);
  27.     gettime(hr,mi,seg);
  28.     GetPlayerIp(playerid, IP, sizeof(IP));
  29.  
  30.     format(data, sizeof(data), "[%i/%i/%i] as [%i:%i:%i]", d,m,a,hr,mi,seg);
  31.     format(xstring, sizeof(xstring), "INSERT INTO `Banidos` (Nome, IP, Motivo, Data, Admin) VALUES ('%s','%s', '%s', '%s', '%s')", r_GetName(playerid), IP, motivo, data, r_GetName(adminid));
  32.  
  33.     mysql_query(xstring);
  34.     Kick(playerid);
  35.     return 1;
  36. }
  37. stock checarBan(playerid) {
  38.     mysql_format(1, xstring, "SELECT * FROM `Banidos` WHERE `Nome` = '%e'", r_GetName(playerid));
  39.     mysql_store_result();
  40.     new a = mysql_num_rows();
  41.         mysql_free_result();
  42.     return a;  
  43. }
  44. stock conectar() {
  45.     xconectar = mysql_connect(SERVER_HOST, SERVER_USER, SERVER_DB, SERVER_PASSWORD);   
  46.     mysql_debug(1);
  47.     if(mysql_ping(xconectar) == -1) {
  48.         print("  Conexão perdida!!");
  49.         SendRconCommand("exit");
  50.     }
  51.     else {
  52.         printf("[Ricop522]  Conectado com sucesso! Ping: %i, ", mysql_ping(xconectar));
  53.     }
  54.     mysql_query("CREATE TABLE IF NOT EXISTS Banidos(\
  55.    ID INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,\
  56.    Nome VARCHAR(24) NOT NULL,\
  57.    IP VARCHAR(40) NOT NULL,\
  58.    Motivo VACHAR(128) NOT NULL,\
  59.    Data VARCHAR(30) NOT NULL,\
  60.    Admin VARCHAR(24) NOT NULL");
  61. }
  62. stock desconectar() return mysql_close(xconectar);
  63.  
  64. stock r_GetName(playerid){
  65.     new name[24]; GetPlayerName(playerid, name, 24); return name;
  66.    
  67. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement