· 6 years ago · Aug 25, 2019, 05:50 PM
1public OnSQLConnect(Handle:owner, Handle:hndl, String:error[], any:data)
2{
3 if(hndl == INVALID_HANDLE)
4 {
5 LogError("Database failure: %s", error)
6 }
7 else
8 {
9 g_Database = hndl
10
11 Format(g_SQLBuffer, sizeof(g_SQLBuffer), "CREATE TABLE IF NOT EXISTS `f2p` (`playername` varchar(128) NOT NULL, `steamid` varchar(32) PRIMARY KEY NOT NULL,`last_accountuse` int(64) NOT NULL)")
12
13 SQL_TQuery(g_Database, OnSQLConnectCallback, g_SQLBuffer)
14
15 PruneDatabase()
16 }
17}
18
19public OnSQLConnectCallback(Handle:owner, Handle:hndl, String:error[], any:data)
20{
21 if(hndl == INVALID_HANDLE)
22 {
23 LogError("Query failure: %s", error)
24 return
25 }
26
27 for(new client = 1; client <= MaxClients; client++)
28 {
29 if(IsClientInGame(client))
30 {
31 OnClientPostAdminCheck(client)
32 }
33 }
34}