View Single Post
ecca
Sexy Santa
Join Date: Jan 2011
Old 01-30-2013 , 09:29   Re: [Need help] Check if connecting client's steamid is in database
Reply With Quote #4

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:ownerHandle: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(clientsteamidsizeof(steamid));
        
        new 
String:query[1024];
        
FormatEx(querysizeof(query),  "SELECT * FROM viplist WHERE steamid='%s'"steamid);
        
        
SQL_TQuery(dbCheckVIPqueryclient);
    }
}

public 
CheckVIP(Handle:ownerHandle: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(clientclientFlags);
    }

ecca is offline