[Nerus]

SOLVED: Array auth was too short for SteamID64 correct length is 21

Hi guys I have problem with taken value from DB after query - all the time I've getting value equals to 0, but executing same query on DB I'll get correct value.

DB Vip table:

VipId|SteamId|Expired|ServerId

PHP Code:

static Handle database = null;

public void OnPluginStart()
{
    InitDB();
}

public void InitDB()
{
    SQL_TConnect(SQLConnecting, "Vips");
}

public void SQLConnecting(Handle owner, Handle hndl, const char[] error, any data)
{    
    if(owner == null || owner == INVALID_HANDLE)
        ThrowError("Can't connect to the database, error occurred:\n%s", error);

    database = hndl;
}

public void OnClientPostAdminCheck(int client)
{
    if(!IsValidPlayer(client, true))
        return;

    char auth[17];
    if(GetClientAuthId(client, AuthId_SteamID64, auth, 17, true))
    {
        char query[256];
        //Format(query, 256, "SELECT IsVip('%s');", auth);
        Format(query, 256, "SELECT COUNT(VipId) FROM Vips WHERE SteamId = '%s' AND Expired >= NOW() LIMIT 1;", auth);
        SQL_TQuery(database, CheckPlayerVip, query, client);
    }
        
}

stock void CheckPlayerVip(Handle owner, Handle result, const char[] error, any client)
{
    if (result != null && SQL_FetchRow(result))
    {
        int value = SQL_FetchInt(result, 0);
        bool isVip = view_as<bool>(value);

        PrintToServer("Player %N isVip %d", client, vvalue);

        if(isVip)
            AddUserFlags(client, Admin_Reservation);
    
        delete result;
    }
    else
        PrintToServer("Error occurred: '%s'", error);
} 


[Ilusion9]

PHP Code:

Format(query, 256, "SELECT SteamId FROM Vips WHERE SteamId = '%s' AND Expired >= NOW();", auth); 


SteamId should be a primary key. Then in callback function you check if steamid is not null.
Use the new syntax btw.

PHP Code:

static Handle database = null; 


static with global variables?

PHP Code:

SQL_TQuery(database, CheckPlayerVip, query, client); 


Send the userid of the clients. The client can disconnect before the callback.

[Nerus]

Originally Posted by Ilusion9 PHP Code: Format(query, 256, "SELECT SteamId FROM Vips WHERE SteamId = '%s' AND Expired >= NOW();", auth);  SteamId should be a primary key. Then in callback function you check if steamid is not null. Use the new syntax btw.

Problem is I have ServerId field in this table, so I need other index than SteamId, we can have couple clients that can be in relation with Servers (many to many).
First post edited please look at table.