Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <a_samp>
- #include <zcmd>
- #include <sscanf>
- #include <a_mysql>
- #define SQL_HOST "localhost"
- #define SQL_USER "root"
- #define SQL_PASS ""
- #define SQL_DB "DB_NAME"
- #define BANS_TABLE "banai"
- public OnPlayerSpawn(playerid)
- {
- new query[140];
- format(query, 140, "SELECT 'Blocked' FROM "BANS_TABLE" WHERE 'Name' = '%s'", PlayerName(playerid));
- mysql_query(query);
- mysql_store_result();
- if(mysql_num_rows() != 0)
- {
- SendClientMessage(playerid, 0xFF0000FF, "Šis account'as užblokuotas");
- Kick(playerid);
- }
- return 1;
- }
- CMD:accban(playerid, params[])
- {
- new zID, Reason[128];
- if(sscanf(params,"is", zID, Reason)) return SendClientMessage(playerid, -1, "{FF0000}Užblokuoti žaidėjo acc: /ban [žaidėjo ID] [Priežastis]");
- if(zID == INVALID_PLAYER_ID && !IsPlayerNPC(zID)) return SendClientMessage(playerid, -1, "{FF0000} Žaidėjo su šiuo ID serveryje nėra.");
- if(zID == playerid) return SendClientMessage(playerid, -1, "{FF0000}Savo acc užblokuoti negalite.");
- new string[128];
- format(string, 128, "Administratorius %s užblokavo %s account'ą(priežastis: %s)", PlayerName(playerid), PlayerName(zID), Reason);
- SendClientMessageToAll(0xFF0000FF, string);
- format(string, 128, "Administratorius %s užblokavo jūsų account'ą(priežastis: %s)", PlayerName(playerid), Reason);
- SendClientMessage(zID, 0xFF0000FF, string);
- BanAcc(zID, PlayerName(playerid), Reason);
- Kick(zID);
- return 1;
- }
- BanAcc(playerid, adminid[], reason[])
- {
- new query[256], year, month, day;
- getdate(year, month, day);
- format(query, 256, "INSERT INTO "BANS_TABLE" (Name, Blocked, Reason) VALUES ('%s', '%s', '%s')", PlayerName(playerid), adminid, reason);
- mysql_query(query);
- mysql_free_result();
- }
- PlayerName(id)
- {
- new name[MAX_PLAYER_NAME];
- GetPlayerName(id, name, MAX_PLAYER_NAME);
- return name;
- }
Advertisement
Add Comment
Please, Sign In to add comment