sourceserver.info

Source code

#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);
}