SQLMM

SQLMM provides simple non-blocking MySQL/SQLite connectors for MetaMod.

Important

Linux build requires libmysqlclient-dev package to be installed.

Features

Non-blocking MySQL/SQLite queries/transactions
Windows & Linux support
Simple API

Interface

SQLMM will expose an interface in OnMetamodQuery which can then be queried with (ISQLInterface*)g_SMAPI->MetaFactory(SQLMM_INTERFACE, &ret, NULL); by other plugins. Example:

  ISQLiteClient *g_pSQLiteClient;
	g_pSQLiteClient = ((ISQLInterface *)g_SMAPI->MetaFactory(SQLMM_INTERFACE, nullptr, nullptr))->GetSQLiteClient();
	g_SMAPI->PathFormat(buffer, sizeof(buffer), "path/to/database/db.sqlite3");
	if (g_pSQLiteClient)
	{
		SQLiteConnectionInfo info;
		info.database = buffer;
		conn = g_pSQLiteClient->CreateSQLiteConnection(info);
		conn->Connect(
			[](bool success)
			{
        //...
			});
	}

Interface definition can be found in src/public.

Compilation

Requirements

Metamod:Source (build 1219 or higher)
AMBuild

git clone https://github.com/zer0k-z/sql_mm && cd sql_mm

export MMSOURCE112=/path/to/metamod/
export HL2SDKCS2=/path/to/hl2sdk-cs2

mkdir build && cd build
python3 ../configure.py -s cs2
ambuild