Hi,
This plugin crashes my server. No info is written to the sourcemod logs. The only thing that appears is in the console log and that is:
./srcds_run: line 337: 19853 Alarm clock $HL_CMD
However, I wrote a test plugin using essentially the same code as this plugin and it works.
Here is the code:
PHP Code:
#include <sourcemod>
#define DB_CONF_NAME "l4dstats"
new Handle:db = INVALID_HANDLE;
public Plugin:myinfo =
{
name = "MySQL Connection Test",
author = "krlll",
description = "MySQL Connection Test",
version = "0.0.0.1",
url = "<- URL ->"
}
public OnPluginStart()
{
if(!ConnectDB())
{
SetFailState("Connecting to database failed. Read error log for further details.");
}
}
bool:ConnectDB()
{
if (db != INVALID_HANDLE)
return true;
if (SQL_CheckConfig(DB_CONF_NAME))
{
decl String:Error[256];
db = SQL_Connect(DB_CONF_NAME, true, Error, sizeof(Error));
if (db == INVALID_HANDLE)
{
LogError("Failed to connect to database: %s", Error);
return false;
}
else if (!SQL_FastQuery(db, "SET NAMES 'utf8'"))
{
if (SQL_GetError(db, Error, sizeof(Error)))
LogError("Failed to update encoding to UTF8: %s", Error);
else
LogError("Failed to update encoding to UTF8: unknown");
}
if(!CheckDatabaseValidity(""))
{
LogError("Database is missing required table or tables.");
return false;
}
}
else
{
LogError("Databases.cfg missing '%s' entry!", DB_CONF_NAME);
return false;
}
LogMessage("DataBase Connected!");
return true;
}
bool:CheckDatabaseValidity(const String:Prefix[])
{
if (!DoFastQuery(0, "SELECT * FROM %splayers WHERE 1 = 2", Prefix) ||
!DoFastQuery(0, "SELECT * FROM %smaps WHERE 1 = 2", Prefix) ||
!DoFastQuery(0, "SELECT * FROM %stimedmaps WHERE 1 = 2", Prefix) ||
!DoFastQuery(0, "SELECT * FROM %ssettings WHERE 1 = 2", Prefix))
{
return false;
}
return true;
}
bool:DoFastQuery(Client, const String:Query[], any:...)
{
new String:FormattedQuery[4096];
VFormat(FormattedQuery, sizeof(FormattedQuery), Query, 3);
new String:Error[1024];
if (!SQL_FastQuery(db, FormattedQuery))
{
if (SQL_GetError(db, Error, sizeof(Error)))
{
PrintToConsole(Client, "[RANK] Fast query failed! (Error = \"%s\") Query = \"%s\"", Error, FormattedQuery);
LogError("Fast query failed! (Error = \"%s\") Query = \"%s\"", Error, FormattedQuery);
}
else
{
PrintToConsole(Client, "[RANK] Fast query failed! Query = \"%s\"", FormattedQuery);
LogError("Fast query failed! Query = \"%s\"", FormattedQuery);
}
return false;
}
return true;
}
public OnPluginEnd()
{
if(db != INVALID_HANDLE)
CloseHandle(db);
}
I've used sourcemod versions 1.3.5, 1.3.6 and now 1.4.0-hg3146.
Is there anyone who has their server hosted by gameservers.com have this thing working?
5
Depending on how the MySQL server user access is configured.
... Working 60 hours a week then at weekends im busy so I don't have much time to support my own Sourcemod Plugin. But I wish you well 
Linear Mode
