This will just add some temporary flags i think, so try this one out instead.
PHP Code:
#pragma semicolon 1
#include <sourcemod>
new Handle:db = INVALID_HANDLE;
public Plugin:myinfo =
{
name = "VIP",
author = "ecca",
description = "",
version = "1.0",
url = ""
};
public OnPluginStart()
{
SQL_TConnect(SQL_OnConnect, "VipPlugin");
}
public SQL_OnConnect(Handle:owner, Handle:hndl, const String:error[], any:data)
{
if (hndl == INVALID_HANDLE)
{
LogError("Error connecting to the database: %s", error);
}
else
{
db = hndl;
PrintToServer("Connection successful");
}
}
public OnClientPostAdminCheck(client)
{
if (IsClientInGame(client) && !IsFakeClient(client))
{
new String:steamid[20];
GetClientAuthString(client, steamid, sizeof(steamid));
new String:query[1024];
FormatEx(query, sizeof(query), "SELECT * FROM viplist WHERE steamid='%s'", steamid);
SQL_TQuery(db, CheckVIP, query, client);
}
}
public CheckVIP(Handle:owner, Handle:hndl, const String:error[], any:client)
{
if (hndl == INVALID_HANDLE)
{
LogError("error: %s", error);
}
if (SQL_FetchRow(hndl))
{
new clientFlags = 0;
clientFlags = GetUserFlagBits(client);
clientFlags |= ADMFLAG_RESERVATION|ADMFLAG_CUSTOM6;
SetUserFlagBits(client, clientFlags);
}
}