Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- native serverBan(playereid, adminid, motivo[])
- native checarBan(playerid)
- native conectar() // ongamemodeinit
- native desconectar() //ongamemodeexit
- Créditos, Ricop522
- */
- #include <a_mysql>
- #include <a_samp>
- #define SERVER_HOST "localhost"
- #define SERVER_USER "root"
- #define SERVER_PASSWORD ""
- #define SERVER_DB "qrp"
- new
- xconectar,
- xstring[128];
- stock serverBan ( playerid, adminid, motivo[] ) {
- new
- IP[30],
- d,m,a, hr, mi, seg, data[30]
- ;
- getdate(d,m,a);
- gettime(hr,mi,seg);
- GetPlayerIp(playerid, IP, sizeof(IP));
- format(data, sizeof(data), "[%i/%i/%i] as [%i:%i:%i]", d,m,a,hr,mi,seg);
- 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));
- mysql_query(xstring);
- Kick(playerid);
- return 1;
- }
- stock checarBan(playerid) {
- mysql_format(1, xstring, "SELECT * FROM `Banidos` WHERE `Nome` = '%e'", r_GetName(playerid));
- mysql_store_result();
- new a = mysql_num_rows();
- mysql_free_result();
- return a;
- }
- stock conectar() {
- xconectar = mysql_connect(SERVER_HOST, SERVER_USER, SERVER_DB, SERVER_PASSWORD);
- mysql_debug(1);
- if(mysql_ping(xconectar) == -1) {
- print(" Conexão perdida!!");
- SendRconCommand("exit");
- }
- else {
- printf("[Ricop522] Conectado com sucesso! Ping: %i, ", mysql_ping(xconectar));
- }
- mysql_query("CREATE TABLE IF NOT EXISTS Banidos(\
- ID INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,\
- Nome VARCHAR(24) NOT NULL,\
- IP VARCHAR(40) NOT NULL,\
- Motivo VACHAR(128) NOT NULL,\
- Data VARCHAR(30) NOT NULL,\
- Admin VARCHAR(24) NOT NULL");
- }
- stock desconectar() return mysql_close(xconectar);
- stock r_GetName(playerid){
- new name[24]; GetPlayerName(playerid, name, 24); return name;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement