· 7 years ago · Nov 15, 2018, 10:08 PM
1#pragma semicolon 1
2#pragma tabsize 0
3#pragma newdecls required
4
5#include <sourcemod>
6
7Handle DB;
8
9public void OnPluginStart()
10{
11 RegAdminCmd("sm_ctban", Cmd_CtBan, ADMFLAG_BAN);
12
13 char error[255];
14 DB = SQL_Connect("sql_test", true, error, sizeof(error));
15
16 if(DB == null)
17 {
18 SetFailState(error);
19 return;
20 }
21
22 char query[255];
23 Format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS players_banned (player_name TEXT, player_steamid TEXT, ban_reason TEXT, admin_name TEXT, admin_steamid TEXT, date TEXT);");
24 SQL_LockDatabase(DB);
25 SQL_FastQuery(DB, query);
26 SQL_UnlockDatabase(DB);
27}
28
29public Action Cmd_CtBan(int client, int args)
30{
31 if(args != 1)
32 {
33 ReplyToCommand(client, "[SM] Usage: sm_ctban <name|userid>");
34 return Plugin_Handled;
35 }
36
37 char target_string[64];
38 GetCmdArg(1, target_string, sizeof(target_string));
39
40 char target_name[MAX_TARGET_LENGTH];
41 int target_list[MAXPLAYERS], target_count;
42 bool tn_is_ml;
43
44 if((target_count = ProcessTargetString(target_string, client, target_list, MAXPLAYERS, COMMAND_FILTER_NO_MULTI, target_name, sizeof(target_name), tn_is_ml)) <= 0)
45 {
46 ReplyToTargetError(client, target_count);
47 ReplyToCommand(client, "[SM] Usage: sm_ctban <name|userid>, no multiple targets allowed.");
48 return Plugin_Handled;
49 }
50
51
52 return Plugin_Handled;
53}
54
55/*char szTime[512];
56FormatTime(szTime, sizeof(szTime), "%d|%m|%Y", GetTime());*/