[rtk]

Firstly, I'm sorry to make such a dumb question.
I never got to play with SQL on SM before but I've been searching for some time and now I'm confused, specially with SQL_TQuery and callbacks.

All i need is a fast UPDATE query, so this should be easy.

In PHP it would look like this:

PHP Code:

function UpdatePlayerPoints($steamID64, $amount)
{
    $mysqli = mysqli_connect(SQL_HOST, SQL_USER, SQL_PW, SQL_DB);
    if(!$mysqli){
        return false;
    }

    $result = mysqli_query($mysqli, "UPDATE `users` SET `points` = `points` + '{$amount}' WHERE `steamID64` = '{$sid64}'") or die(mysqli_error($mysqli));
    if($result){
        return true;
    } else {
        return false;
    }

    mysqli_close($mysqli);
} 


How would that look like ?

Thanks!

[LambdaLambda]

Take a look on that topic SQL (SourceMod Scripting)

[rtk]

Nice example there, missed it.

So I came up with this:

PHP Code:

#include <sourcemod>
#include <morecolors>

public Plugin:myinfo =
{
    name = "Plugin Name",
    author = "Author",
    description = "",
    version = "1.0",
    url = ""
};

new Float:IntervalTime = 60.0;
new NumPlaytime = 1; //minute(s)

public OnPluginStart()
{
    new Handle:kv = CreateKeyValues("sql");
    KvSetString(kv, "driver", "mysql");
    KvSetString(kv, "host", "hostname");
    KvSetString(kv, "port", "3306");
    KvSetString(kv, "database", "databasename");
    KvSetString(kv, "user", "sqluser");
    KvSetString(kv, "pass", "xxxxxxxxxx");

    decl String:error[255];
    
    new Handle:hDatabase = SQL_ConnectCustom(kv, error, sizeof(error), true);
    
    if (hDatabase == INVALID_HANDLE)
    {
        LogError("SQL Connection Failed: %s", error);
        return;
    }
    CloseHandle(kv);
    
    CreateTimer(IntervalTime, Timer_AddPlaytime, _, TIMER_REPEAT);
}

public Action:Timer_AddPlaytime(Handle:timer)
{
    for (new i = 1; i <= MAXPLAYERS + 1; i++)
    {
        if (IsClientConnected(i) && !IsFakeClient(i) && IsPlayerInGame(i))
        {
            new team = GetClientTeam(i);
            if (team == 2 || team == 3)
            {
                decl String:SteamID32[21];
                new String:CommunityID[18];
                
                GetClientAuthString(i, SteamID32, sizeof(SteamID32));
                GetCommunityIDString(SteamID32, CommunityID, sizeof(CommunityID));
                
                new String:query[512];
                Format(query, sizeof(query), "UPDATE players SET playtime = playtime + %s WHERE SteamID64 = %s", NumPlaytime, CommunityID);
                
                if (!SQL_FastQuery(hDatabase, query))
                {
                    new String:error[255]
                    SQL_GetError(hDatabase, error, sizeof(error))
                    PrintToServer("Failed to query (error: %s)", error)
                }
            }
        }
    }
} 


While compiling I get:

plugin.sp(58) : error 017: undefined symbol "hDatabase" // if (!SQL_FastQuery(hDatabase, query))
plugin.sp(61) : error 017: undefined symbol "hDatabase" // SQL_GetError(hDatabase, error, sizeof(error))

Yes, I'm sure I want to hardcore my sql credentials.

Help please.

[Internet Bully]

You declare hDatabase in the scope of OnPluginStart.. It needs to be in the global scope the way you're using it. Read your errors, they tell you what's wrong...

[rtk]

"It needs to be in the global scope". Already noticed that, that's exactly what I needed help with...

It didn't work when moved out of OnPluginStart and declaring it inside the Timer_AddPlaytime doesn't look like a very good idea, or is it ?

[bladez]

Declare it at the same level that you declared IntervalTime and NumPlayTime. Define it in OnPluginStart.

i.e new Handle:hDatabase = INVALID_HANDLE; and then hDatabase = SQL_TConnect.... Make sure you check that the handle is (still) valid in your timer.