[zipcore]

I'm writing on a plugin where you don't need to learn sql to create a new database inside sourcemod and use it.

[DJ Data]

Originally Posted by zipcore I'm writing on a plugin where you don't need to learn sql to create a new database inside sourcemod and use it.

That sounds cool, but I asked the community because I want to learn ^^

[Miu]

PHP Code:

new Handle:g_hDB = INVALID_HANDLE;

public OnPluginStart()
{
    RegAdminCmd("sm_menu", Command_vipmenu, ADMFLAG_ROOT);
    
    StartSQL();
}

public Action:Command_vipmenu(client, args)
{
    new String:steamid[32];
    GetClientAuthId(client, AuthId_Engine, steamid, sizeof(steamid));
    ShowPoints(client, steamid);
}

ShowPoints(client, const String:steamid[])
{
    new String:query[128];
    FormatEx(query, sizeof(query), "SELECT points FROM Users WHERE steamid = '%s'", steamid);
    SQL_TQuery(g_hDB, callback, query, client);
}

public callback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if (hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
        return;
    }
    
    new tokens = 0;
    
    if(SQL_FetchRow(hndl))
    {
        tokens = SQL_FetchInt(hndl, 0);
    }
        
    
    new Handle:menu = CreateMenu(vipmenu, MenuAction_Select | MenuAction_End);
    SetMenuTitle(menu, "► arctekservers.com ◄");
    
    AddMenuItem(menu, "tokens", "You have %d VIP Tokens", tokens);
    
    DisplayMenu(menu, client, MENU_TIME_FOREVER);
}

StartSQL()
{
    SQL_TConnect(DB_Connect, "your_database_name");
}

public DB_Connect(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if (hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
    }
    else
    {
        g_hDB = hndl;
    }
} 


edit: db name is second argument to tconnect btw, forgot about that

[Powerlord]

Originally Posted by zipcore I'm writing on a plugin where you don't need to learn sql to create a new database inside sourcemod and use it.

How are you planning on deciding which types each column should have?

For that matter, how are you planning on avoiding the Inner-platform Effect?

[Potato Uno]

Learn SQL, because not only is it used in Sourcemod but it is also used in virtually any programming language that provides an API to query databases.

[DJ Data]

Originally Posted by Potato Uno Learn SQL, because not only is it used in Sourcemod but it is also used in virtually any programming language that provides an API to query databases.

Yeah I hope to learn it this year in IT school ^^

Merge:

Originally Posted by Miu PHP Code: code

Thanks!
1 compile error occured though:

GetClientAuthId is an undefined symbol.


Cheers

[Potato Uno]

https://sm.alliedmods.net/new-api/cl...etClientAuthId ?

It returns undefined symbol? Do you have #include <sourcemod> at the top? Are you using SM 1.7 and not 1.6? Update to the latest snapshot of sourcemod.

[Miu]

use getclientauthstring instead then

[DJ Data]

Originally Posted by Miu use getclientauthstring instead then

I'm using this and it compiled now. Thanks a lot for your help.

I'll report back if it works.