[juss]

Trying to replace/add clan tag to once who found in db

not really working , can you guys take a look please

PHP Code:

#include <sourcemod>
#include <cstrike>
#define PLUGIN_VERSION    "1.0"

public Plugin:myinfo = {
    name = "suspect checker",
    author = "forums.alliedmods.net",
    description = "suspect checker",
    version = PLUGIN_VERSION,
    url = "forums.alliedmods.net"
};

new Handle:db;

public OnPluginStart()
{
    new String:error[512];

    db = SQL_Connect("default", true, error, sizeof(error));

    if(db == INVALID_HANDLE)
    {
        SetFailState(error);
    }

}

public OnClientPostAdminCheck(client) 
{ 
    decl String:sQuery[256], String:sAuth[32]; 
    GetClientAuthId(client, AuthId_Engine, sAuth, sizeof(sAuth)); 
    FormatEx(sQuery, sizeof(sQuery), "SELECT steam FROM suspects WHERE steam = '%s'", sAuth); 
    SQL_TQuery(db, SQL_LoadClient, sQuery, GetClientUserId(client)); 
} 

public SQL_LoadClient(Handle:hOwner, Handle:hQuery, const String:sError[], any:UserID) 
{ 
    if (hQuery == INVALID_HANDLE || sError[0]) 
    { 
        LogError("SQL_LoadClient: %s", sError); 
    } 
     
    new client = GetClientOfUserId(UserID); 
    if ( client && SQL_FetchRow(hQuery)) 
    {
        if(!SQL_FetchInt(hQuery, 0)) 
        {
            CS_SetClientClanTag(client, "[SUSPECTED]");
        }         
    }  
} 


[psychonic]

Don't send unsolicited PMs to random people to look at your thread. The next one is a ban.

[BraveFox]

Instend:

PHP Code:

 if(!SQL_FetchInt(hQuery, 0)) 
{
            CS_SetClientClanTag(client, "[SUSPECTED]"); 


Use:

PHP Code:

while(SQL_FetchRow(hQuery))
    {
        if(SQL_FetchInt(hQuery, 0))
        {
            //Found Results
        }
    }
} 


[juss]

Originally Posted by BraveFox Instend: PHP Code:  if(!SQL_FetchInt(hQuery, 0))  {             CS_SetClientClanTag(client, "[SUSPECTED]");  Use: PHP Code: while(SQL_FetchRow(hQuery))     {         if(SQL_FetchInt(hQuery, 0))         {             //Found Results         }     } }

nope , not working

not sure why i need while here ? I'm checking only one client in mysql select (the player who connects to the server)

[Neuro Toxin]

Break it down.

Print messages to chat to confirm you're getting a result and it's what you expect.

[pizza_lover]

#include <dbi> ?
edit: give it a try

PHP Code:

#include <sourcemod>
#include <cstrike>
#include <dbi>
#define PLUGIN_VERSION    "1.0"

public Plugin:myinfo = {
    name = "suspect checker",
    author = "forums.alliedmods.net",
    description = "suspect checker",
    version = PLUGIN_VERSION,
    url = "forums.alliedmods.net"
};

new Handle:db;

public OnPluginStart()
{
    new String:error[512];

    db = SQL_Connect("default", true, error, sizeof(error));

    if(db == INVALID_HANDLE)
    {
        SetFailState(error);
    }

}

public OnClientPostAdminCheck(client)
{
    decl String:sQuery[256], String:sAuth[32];
    new data;
    GetClientAuthId(client, AuthId_Engine, sAuth, sizeof(sAuth));
    data = GetClientOfUserId(client);
    FormatEx(sQuery, sizeof(sQuery), "SELECT steam FROM suspects WHERE steam = '%s'", sAuth);
    SQL_TQuery(db, SQL_LoadClient, sQuery, data);
}

public SQL_LoadClient(Handle:hOwner, Handle:hQuery, const String:sError[], any:data) 
{
    new client = data;
    if (hQuery == INVALID_HANDLE || sError[0])
    {
        LogError("SQL_LoadClient: %s", sError);
    }

    if ( client && SQL_FetchRow(hQuery))
    {
        if(!SQL_FetchInt(hQuery, 0))
        {
            CS_SetClientClanTag(client, "[SUSPECTED]");
        }
    }
} 


[fiction]

Originally Posted by pizza_lover #include <dbi> ?

Using #include <sourcemod> includes many of the default includes on it's own, dbi is one of them. Also sourcemod.inc is automatically included by the compiler I believe.

[juss]

Originally Posted by Neuro Toxin Break it down. Print messages to chat to confirm you're getting a result and it's what you expect.

I do have PrintToServer and PrintToChat for debagging on my test file , and it prints but the clan tag doesn't want to change

PHP Code:

        if(SQL_FetchInt(hQuery, 0))
        {
            CS_SetClientClanTag(client, "[SUSPECTED]");
            PrintToChat(client, "found you!!");
            PrintToServer("1233455667778");
        } 


[fiction]

Originally Posted by juss I do have PrintToServer and PrintToChat for debagging on my test file , and it prints but the clan tag doesn't want to change

What version of SourceMod are you running on your server?

[juss]

Originally Posted by fiction What version of SourceMod are you running on your server?

SourceMod Version: 1.8.0.6024