1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
#include <sourcemod>
#define plugin_version "0.1 alpha"
#define plugin_name "Maple-Maniac"
new Handle:hDatabase = INVALID_HANDLE;
new Handle:serverid = INVALID_HANDLE;
public Plugin:myinfo =
{
name = "Maple-Maniac",
author = "Schrubber",
description = "Easy MapCycle-Management for YOUR server",
version = plugin_version,
url = " "
};
public OnPluginStart() {
serverid = CreateConVar("sm_maplemaniac_sid", "31", "ServerID for the database", FCVAR_PLUGIN);
RegAdminCmd("sm_reloadmaplemaniac", ReloadMapleManiac, ADMFLAG_ROOT);
InitDB();
}
public InitDB() {
decl String:error[255];
hDatabase = SQL_Connect("mapcycle", false, error, sizeof(error));
if (hDatabase == INVALID_HANDLE) {
SetFailState("SQL error: %s", error);
}
GetMapCycle();
}
public Action:ReloadMapleManiac(client, args) {
InitDB();
return Plugin_Handled;
}
public GetMapCycle() {
decl String:table[256], String:query[512];
GetConVarString(serverid, table, sizeof(table));
Format(query, sizeof(query), "SELECT mapcycle FROM `maplemaniac_current` WHERE serverid = '%d';",GetConVarInt(FindConVar("sm_maplemaniac_sid")));
SQL_TQuery(hDatabase, SQL_GetInfo5, query);
}
public SQL_GetInfo5(Handle:owner, Handle:hndl, const String:error[], any:data) {
new String:maps[255];
LogMessage("Test: GetInfo5");
if (hndl == INVALID_HANDLE) {
LogError("[Maple-Maniac] SQL Getting Maps Error: %s", error);
} else if (SQL_FetchRow(hndl)) {
SQL_FetchString(hndl, 0, maps, sizeof(maps));
}
LogMessage(maps);
}
|