[superchat]

Hello! How to make mysql connect? I read this, but no't help me... I make databases.cfg this:

PHP Code:

    "test"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "test"
        "user"                "root"
        "pass"                "*****"
        "port"                "3306"
    } 


[TheKiwI]

PHP Code:

    "test"
    {
        "driver"            "mysql"
        "host"                "127.0.0.1 (localhost) - or your adress"
        "database"            "DB name"
        "user"                "DB user"
        "pass"                "DB password"
        "port"            "3306"
    } 


[superchat]

Originally Posted by TheKiwI PHP Code:     "test"     {         "driver"            "mysql"         "host"                "127.0.0.1 (localhost) - or your adress"         "database"            "DB name"         "user"                "DB user"         "pass"                "DB password"         "port"            "3306"     }

I need working code connecting MYSQL.

[SEGnosis]

Originally Posted by superchat I need working code connecting MYSQL.

I cut these parts out of one of my plugins.
It does not have escaping or full error checking so that is something you might want to add.

PHP Code:

new Handle:db;


/* Start up */

public OnPluginStart()
{
    new String:error[255];
    db = SQL_Connect("test", false, error, sizeof(error));
    
    if (db == INVALID_HANDLE)
        LogError(error);


    HookEvent("player_death", Event_PlayerDeath);
}


/* SQL */

public SQL_SlowCommand(String:command[], any:...)
{
    new Handle:result = INVALID_HANDLE;
    
    if (db != INVALID_HANDLE)
    {
        new String:formatted[255];
        VFormat(formatted, sizeof(formatted), command, 2);
        result = SQL_Query(db, formatted);
    }
        
    return result;
}

public SQL_FastCommand(String:command[], any:...)
{
    if (db != INVALID_HANDLE)
    {
        new String:formatted[255];
        VFormat(formatted, sizeof(formatted), command, 2);        
        new Handle:result = SQL_FastQuery(db, formatted);
    }
}


/* Events */

public Action:Event_PlayerDeath(Handle:event, const String:name[], bool:dontBroadcast)
{
    new attackee = GetClientOfUserId(GetEventInt(event, "userid"));
    new attacker = GetClientOfUserId(GetEventInt(event, "attacker"));
    
    
    if(attacker > 0 && GetClientTeam(attackee) != GetClientTeam(attacker))
    {
        new String:auth[32];
        GetClientAuthString(attacker, auth, sizeof(auth));
        SQL_FastCommand("UPDATE users SET points = points + 1 WHERE steam_id='%s' AND points < 100", auth);
    }
}

public OnClientPutInServer(client)
{
    new String:auth[32];
    GetClientAuthString(client, auth, sizeof(auth));
    SQL_FastCommand("INSERT INTO users VALUES('%s', UNIX_TIMESTAMP(), 100)", auth);
} 


[Mitchell]

Originally Posted by SEGnosis I cut these parts out of one of my plugins. It does not have escaping or full error checking so that is something you might want to add. PHP Code: new Handle:db; /* Start up */ public OnPluginStart() {     new String:error[255];     db = SQL_Connect("test", false, error, sizeof(error));          if (db == INVALID_HANDLE)         LogError(error);     HookEvent("player_death", Event_PlayerDeath); } /* SQL */ public SQL_SlowCommand(String:command[], any:...) {     new Handle:result = INVALID_HANDLE;          if (db != INVALID_HANDLE)     {         new String:formatted[255];         VFormat(formatted, sizeof(formatted), command, 2);         result = SQL_Query(db, formatted);     }              return result; } public SQL_FastCommand(String:command[], any:...) {     if (db != INVALID_HANDLE)     {         new String:formatted[255];         VFormat(formatted, sizeof(formatted), command, 2);                 new Handle:result = SQL_FastQuery(db, formatted);     } } /* Events */ public Action:Event_PlayerDeath(Handle:event, const String:name[], bool:dontBroadcast) {     new attackee = GetClientOfUserId(GetEventInt(event, "userid"));     new attacker = GetClientOfUserId(GetEventInt(event, "attacker"));               if(attacker > 0 && GetClientTeam(attackee) != GetClientTeam(attacker))     {         new String:auth[32];         GetClientAuthString(attacker, auth, sizeof(auth));         SQL_FastCommand("UPDATE users SET points = points + 1 WHERE steam_id='%s' AND points < 100", auth);     } } public OnClientPutInServer(client) {     new String:auth[32];     GetClientAuthString(client, auth, sizeof(auth));     SQL_FastCommand("INSERT INTO users VALUES('%s', UNIX_TIMESTAMP(), 100)", auth); }

needs to be threaded. or it will lag the server

[DHJ]

^

how do you thread it properly?

[PriceLess]

threaded connect should look something like this :

PHP Code:

#include <sourcemod>

new Handle:hDatabase = INVALID_HANDLE;

public OnPluginStart()
{
    if(!SQL_CheckConfig("databasename"))
    PrintToServer("failed to connect to database.cfg");
    SQL_TConnect(Callback, "databasename");
}

public Callback(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    if(hndl == INVALID_HANDLE)
    {
        PrintToServer("Failed to query (%s)", error);
    }
    else
    {
        PrintToServer("Connected");
        hDatabase = hndl;
    }
} 


Hope it helps out!