URjwYC4z

1
2#include <sourcemod>
3#include <sdktools>
4#include <cstrike>
5#include <sdkhooks>
6#pragma semicolon 1
7
8new Handle:DB = INVALID_HANDLE;
9
10public OnMapStart()
11{
12	SQL_TConnect(SQL_Connection, "GuppyShop");
13}
14
15public SQL_Connection(Handle:owner, Handle:handle, const String:error[], any:data)
16{
17	if(handle == INVALID_HANDLE)
18	{
19		PrintToServer("[GuppyShop] Error : %s", error);
20	}
21	else
22	{
23		DB = handle;
24		SQL_TQuery(DB, SQL_CheckError, "SET NAMES UTF8;", 0, DBPrio_High);		
25		SQL_TQuery(DB, SQL_CheckTable, "SHOW TABLES LIKE 'UserData';", 0, DBPrio_High);			
26	}
27}
28
29public SQL_CheckTable(Handle:owner, Handle:handle, const String:error[], any:data)
30{
31	if(handle == INVALID_HANDLE)
32	{
33		PrintToServer("[GuppyShop] Error : %s", error);
34	}
35	
36	if(SQL_GetRowCount(handle) == 0)
37	{
38		if(DB != INVALID_HANDLE)
39		{
40			SQL_TQuery(DB, SQL_CheckError, "CREATE TABLE IF NOT EXISTS UserData(SteamID VARCHAR(128) NOT NULL, Name VARCHAR(128) NOT NULL, Point INT, PRIMARY KEY (SteamID)) ENGINE=MyISAM DEFAULT CHARSET=UTF8;", 0, DBPrio_High);		
41		}
42	}
43}
44
45public SQL_CheckError(Handle:owner, Handle:handle, const String:error[], any:data)
46{
47	if(handle == INVALID_HANDLE)
48	{
49		PrintToServer("[GuppyShop] Error : %s", error);
50	}
51}