[Dr.Mohammad]

hi guys!!

i started programing for mysql. this cod is true??

PHP Code:

#include <sourcemod>

public Plugin myinfo = 
{
    name = "Sql_Test",
    author = "Dr.Mohammad",
    description = "This Plugin Only For Test",
    version = "1.0.0"
    url = ""
};

public OnPluginStart()
{
    char error[255];
    Database db = SQL_Connect("sqltest", true, error, sizeof(error));

    if (db == null)
    {
        PrintToServer("Cannot connect to MySQL Server: %s", error);
    }
    else
    {
        char query[512];
        Format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS mysqltest(name TEXT,steamid INTEGER NOT NULL)");
        SQL_TQuery(db, db_Connect_Callback, query);
        PrintToServer("Connection Successfull");
    }
}

public void db_Connect_Callback(Handle owner, Handle hndl, const char[] error, any data)
{
    if(hudl == INVALID_HANDLE)
    {
        LogError(error);
    }
} 


[eyal282]

Say goodbye to your CPU, using unthreaded connections with a sql that requires internet ( MySQL ). Refer to SQL_TConnect and TQuery. If multiple plugins did that I think the result would be worse. Also I can't find errors but compile and give it a go. Error logs will help.

[Dr.Mohammad]

Originally Posted by eyal282 Say goodbye to your CPU, using unthreaded connections with a sql that requires internet ( MySQL ). Refer to SQL_TConnect and TQuery. If multiple plugins did that I think the result would be worse. Also I can't find errors but compile and give it a go. Error logs will help.

What is the best way to write this code?

[Neuro Toxin]

https://wiki.alliedmods.net/SQL_(Sou...ing)#Threading

Database hDatabase = null;
 
void StartSQL()
{
	Database.Connect(GotDatabase);
}
 
public void GotDatabase(Database db, const char[] error, any data)
{
	if (db == null)
	{
		LogError("Database failure: %s", error);
	} 
        else 
        {
		hDatabase = db;
	}
}

[Ilusion9]

Database hDatabase = null;
 
public void OnPluginStart()
{
	Database.Connect(GotDatabase, "sqltest");
}
 
public void GotDatabase(Database db, const char[] error, any data)
{
	if (db == null)
	{
		LogError("Database failure: %s", error);
	} 
        else 
        {
		hDatabase = db;
	}
}

or

Database hDatabase = null;
 
public void OnMapStart()
{
	if (hDatabase == null)
	{
		Database.Connect(GotDatabase, "sqltest");
	}
}
 
public void GotDatabase(Database db, const char[] error, any data)
{
	if (db == null)
	{
		LogError("Database failure: %s", error);
	} 
        else 
        {
		hDatabase = db;
	}
}

[Dr.Mohammad]

Originally Posted by Neuro Toxin https://wiki.alliedmods.net/SQL_(Sou...ing)#Threading Database hDatabase = null; void StartSQL() { Database.Connect(GotDatabase); } public void GotDatabase(Database db, const char[] error, any data) { if (db == null) { LogError("Database failure: %s", error); } else { hDatabase = db; } }

Originally Posted by Ilusion9 Database hDatabase = null; public void OnPluginStart() { Database.Connect(GotDatabase, "sqltest"); } public void GotDatabase(Database db, const char[] error, any data) { if (db == null) { LogError("Database failure: %s", error); } else { hDatabase = db; } } or Database hDatabase = null; public void OnMapStart() { if (hDatabase == null) { Database.Connect(GotDatabase, "sqltest"); } } public void GotDatabase(Database db, const char[] error, any data) { if (db == null) { LogError("Database failure: %s", error); } else { hDatabase = db; } }

thank you.

i can not create table database. please help

my cod:

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;
        
        char query[512];
        Format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS sqltest(name TEXT,steamid TEXT)");
        SQL_TQuery(hDatabase, db_Connect_Callback, query);
        LogToFile(ZLogFile, "Connection Successfull");
    }
}

public void db_Connect_Callback(Handle owner, Handle hndl, const char[] error, any data)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError(error);
        LogToFile(ZLogFile, "Database failure: %s", error);
    }
} 


database.cfg

	"sqltest"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sqltest"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		"port"			"3306"
	}

[Ilusion9]

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

[Dr.Mohammad]

i have errror:

L 11/10/2018 - 14:56:13: [sql.smx] 1- Connection Successfull
L 11/10/2018 - 14:56:21: [sql.smx] 2- player Dr.Mohammad connected
L 11/10/2018 - 14:56:21: [sql.smx] 2- Database Create Table Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''2' at line 1

with this cod:

PHP Code:

#include <sourcemod>

#pragma semicolon 1
#pragma newdecls required

char ZLogFile[PLATFORM_MAX_PATH];

Database g_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_test, const char[] error, any data)
{
    if (db_test == null)
    {
        LogToFile(ZLogFile, "1- Connection Loss: %s", error);
    }
    else
    {
        g_hDatabase = db_test;
        
        g_hDatabase.Query(SQL_Error, "CREATE TABLE IF NOT EXISTS players (name TEXT, steamid varchar(32) NOT NULL, ip TEXT, generic TINYINT(32), reservation TINYINT(32), kick TINYINT(32), ban TINYINT(32), unban TINYINT(32), slay TINYINT(32), changemap TINYINT(32), convars TINYINT(32), config TINYINT(32), chat TINYINT(32), vote TINYINT(32), password TINYINT(32), rcon TINYINT(32), cheats TINYINT(32), root TINYINT(32), custom1 TINYINT(32), custom2 TINYINT(32), custom3 TINYINT(32), custom4 TINYINT(32), custom5 TINYINT(32), custom6 TINYINT(32));");
        LogToFile(ZLogFile, "1- Connection Successfull");
    }
}

public void SQL_Error(Database db_test, DBResultSet hResults, const char[] error, any data)
{
    if(hResults == null)
    {
        LogToFile(ZLogFile, "2- Database Create Table Error: %s", error);
    }
} 


how to fix??

[Neuro Toxin]

You probably need to put all your fields in ` chars due to custom being a keyword.