[21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:18] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:50] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:50] [ERROR] mysql_tquery - invalid connection handle (id: 0) [21:25:55] [ERROR] mysql_tquery - invalid connection handle (id: 0)
It's highly recommended to thread all your queries (even INSERT & UPDATE). |
mysql_query does not thread the queries, mysql_tquery which is better.
|
Nothing. Connection handle 0 means that there isn't a connection. Either you simply forgot to open it, or the connection parameters are wrong.
|
SQL_CheckAccount(playerid)
{
static query[128];
mysql_tquery(g_iHandle,"SELECT `Username` FROM `characters` WHERE `Character` = '%s'",ReturnName(playerid));
//format(query, sizeof(query), "SELECT `Username` FROM `characters` WHERE `Character` = '%s'", ReturnName(playerid));
//mysql_function_query(g_iHandle, query, true, "OnQueryFinished", "dd", playerid, THREAD_FIND_USERNAME);
return 1;
}
The above example is wrong, you need to format the query before calling it.
|
Hello!
![]() Try this: PHP код:
![]() |
SQL_CheckAccount(playerid)
{
static query[128];
format(query,sizeof query,"SELECT `Username` FROM `characters` WHERE `Character`='%s'",ReturnName(playerid));
mysql_tquery(g_iHandle,query,"OnQueryFinished","ii",playerid,THREAD_FIND_USERNAME);
//format(query, sizeof(query), "SELECT `Username` FROM `characters` WHERE `Character` = '%s'", ReturnName(playerid));
//mysql_function_query(g_iHandle, query, true, "OnQueryFinished", "dd", playerid, THREAD_FIND_USERNAME);
return 1;
}