[Fastmancz]

Hello,

I have to you question. Can I use SQL queries during the game? Because I have a problem that sometimes crashes the server. I use standard SQL query (SQL_TQuery).

Example:

PHP Code:

public void MySQL(Handle owner, Handle hquery, const char[] error, any client)
{
    if(hquery == INVALID_HANDLE)
    {
        LogError("[SQL]  Error: %s\n\n\n", error);
    }

    char steamid[32];
    GetClientAuthId(client, AuthId_Engine, steamid, sizeof(steamid));
    Format(query, sizeof(query), "SELECT * FROM xxxxx WHERE steamid LIKE '%s'", steamid);
    SQL_TQuery(DB, MySQL_Data, query, client);

    CloseHandle(h_query);
}

public void MySQL_Data(Handle owner, Handle hquery, const char[] error, any client)
{
    if(hquery == INVALID_HANDLE)
    {
        LogError("[SQL]  Error: %s\n\n\n", error);
    }
    .....
    
    CloseHandle(h_query);
} 


It can also cause this, that I did not use closed handles (return Plugin_Handled, etc.)?

Thank you for the explanation and answer.

[Mitchell]

what is 'h_query' and why are you closing it? Most plugins use sql queries mid game perfectly fine.

[Fastmancz]

Thank you for the reply. I checked what it is. I have found that basically I do not use it.

PHP Code:

Handle h_query = INVALID_HANDLE; 


Is it possible to somehow check the handles? I mean the debug plugin. I found the command:
sm_dump_handles

Thanks for answer.

[Totenfluch]

Invalid info

Spoiler

you should close hquery not h_query

[Mitchell]

Originally Posted by Totenfluch you should close hquery not h_query

You shouldn't need to close that either, unless the wiki is passing out bad information.

[Fastmancz]

Thanks for reply. How do I know which handles is the need to close? It is necessary for SQL_TQuery to close the handles?

[Drixevel]

Originally Posted by Fastmancz Thanks for reply. How do I know which handles is the need to close? It is necessary for SQL_TQuery to close the handles?

You should only have to open 1 database handle globally if you want to use it consistently and just create threaded queries using 'SQL_TQuery' without closing any of the handles inside of it unless you pass a datapack through it, you need to close that.

[Fastmancz]

Thanks for reply. I looked in the log and I found this:

Mysql Error: Lost connection to MySQL server during query

Which in turn will cause a server crash. Where there may be an error?

[Fyren]

Code similar to what you gave in your first post shouldn't crash the server and neither should losing your database connection. You might want to try posting a crash dump if possible (perhaps using Accelerator).