[DJ Data]

Hey,

I've been trying to figure out how to setup a full sql script all morning, I can't get my head around it.
https://wiki.alliedmods.net/SQL_(SourceMod_Scripting) tells you how to format queries and such, but i dont know how to use the actual value that i get from SELECT.

What im trying to do:
I want to show a number (points) in a menu item. Whenever the menu is opened, it should make a call. However, i heard this can cause lag spikes and that would make this unusable. I've heard about sql threading but i honestly don't understand a single bit of it.

I'd be thankful if someone could show me a script to fulfill what i've described above.

Cheers!

[Miu]

Originally Posted by DJ Data i dont know how to use the actual value that i get from SELECT.

The "processing results" section has information about this

[DJ Data]

Originally Posted by Miu The "processing results" section has information about this

Looking at that confuses me so much haha, i wish there were some YouTube videos with indepth examples for us noobs ^^

[Powerlord]

With normal queries, when you send a statement the game server stops and sits there until the database server gives you the results. Hence the lag spikes as the server stops processing everything until it returns.

With threaded queries, you send a statement and a callback for it to call. When the database server has the results, your callback is called. In the meantime, the game server goes on its merry way doing stuff like processing game frames. The main downside here is that you have no idea when the results will arrive.

Then again, if you're using an external DB for time-sensitive information, your code is going to have issues anyway.

[Miu]

PHP Code:

void ShowPoints(int client, const char[] steamid)
{
    char query[128];
    FormatEx(query, sizeof(query), "SELECT points FROM table WHERE steamid = '%s'", steamid);
    SQL_TQuery(g_hDB, callback, query, client);
}

public void callback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
        return;
    }
    
    SQL_FetchRow(hndl);
    
    int points = SQL_FetchInt(hndl, 0);
    
    PrintToChat(client, "You have %d points!!!!!!!!!!!", points);
} 


[Potato Uno]

Pass the menu handle through the optional callback parameter so you can use it on the callback.

[Impact123]

@Miu
Don't use client indexes with asynchronous functions, use an userid or serial instead. You should also check that a row was fetched before trying to retrieve data.

[DJ Data]

PHP Code:

AddMenuItem(menu, "tokens", "You have %d VIP Tokens", tokens);

stock ShowPoints(client, 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 Action:callback(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
        return;
    }
    
    SQL_FetchRow(hndl);
    
    tokens = SQL_FetchInt(hndl, 0);
} 


So this would essentially work? As well as not freeze the server whenever someone opens the menu?
Also, I've converted the 1.7 code back to 1.6 because I dont feel comfortable with 1.7 yet.

[Miu]

i don't know where you're creating the menu but probably not, you should create it imn the callback

[DJ Data]

Originally Posted by Miu i don't know where you're creating the menu but probably not, you should create it imn the callback

The menu is called when someone types !menu, if thats what you mean.

Edit:

Here is the full (minimalized) code:

PHP Code:

new Handle:hDatabase = INVALID_HANDLE;

public OnPluginStart() 
{ 
    //reg command
    RegAdminCmd("sm_menu", Command_menu, ADMFLAG_ROOT); 
    
    //Make Threaded DB Connection
    StartSQL();
}

//Main Menu 
public Action:Command_vipmenu(client, args) 
{ 
    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); 
} 

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

StartSQL()
{
    SQL_TConnect(GotDatabase);
}

public GotDatabase(Handle:owner, Handle:hndl, const String:error[], any:client)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("error: %s", error);
        return;
    }
    
    SQL_FetchRow(hndl);
    
    tokens = SQL_FetchInt(hndl, 0);
} 


2 things i dont get:
Where do I define which database the TConnect is using in my databases.cfg?
And when is ShowPoints called?