PHP Code:
#include <sourcemod>
char ZLogFile[PLATFORM_MAX_PATH];
Database hDatabase = null;
public Plugin myinfo =
{
name = "Sql_Test",
author = "Dr.Mohammad",
description = "This Plugin Only For Test",
version = "1.0.0",
url = ""
};
public void OnPluginStart()
{
Database.Connect(GotDatabase, "sqltest");
BuildPath(Path_SM, ZLogFile, sizeof(ZLogFile), "logs/sqltest.log");
}
public void GotDatabase(Database db, const char[] error, any data)
{
if (db == null)
{
LogToFile(ZLogFile, "Database failure: %s", error);
}
else
{
hDatabase = db;
db.Query(db_Connect_Callback, "CREATE TABLE IF NOT EXISTS sqltest (name TEXT, steamid TEXT);");
LogToFile(ZLogFile, "Connection Successfull");
}
}
public void db_Connect_Callback(Database db, DBResultSet rs, const char[] error, any data)
{
if(rs == null)
{
LogError(error);
LogToFile(ZLogFile, "Database failure: %s", error);
}
}
Use the new syntax (Database class):
https://sm.alliedmods.net/new-api/dbi/Database