[condolent]

Every time my plugin attempts to use the native SQL_Query() it sends a Invalid database Handle 0 (error 4) error to the server, saying it's an invalid database handle. However from what I can see on the docs it looks like it's supposed to?

My code:

Database gH_Db;

stock void SQL_InitDB() {
	char sError[255];
	if(gH_Db == INVALID_HANDLE) {
		gH_Db = SQL_Connect("betterwarden", true, sError, sizeof(sError));
		
		if(gH_Db == INVALID_HANDLE) {
			PrintToServer("### Could not connect to the database! ##");
			PrintToServer("%s", sError);
		} else {
			SQL_CreateBWTable();
		}
	}
}

stock bool SQL_IsInGang(int client) {
	char sQuery[255];
	char sID[64];
	GetClientAuthId(client, AuthId_Steam2, sID, sizeof(sID));
	
	Format(sQuery, sizeof(sQuery), "SELECT GangID FROM betterwarden_players WHERE STEAMID LIKE '%s'", sID);
	
	DBResultSet SQL = SQL_Query(gH_Db, sQuery);
	if(SQL != null) {
		if(SQL_FetchRow(SQL)) {
			CloseHandle(SQL);
			return true;
		}
	}
	
	return false;
}

SQL_InitDB() is called OnPluginStart.

Anyone see why this is happening?

[Kellan123]

PHP Code:

if(gH_Db == INVALID_HANDLE) 


wheres the

PHP Code:

CloseHandle(gH_Db); 


?

[condolent]

Originally Posted by Kellan123 PHP Code: if(gH_Db == INVALID_HANDLE)  wheres the PHP Code: CloseHandle(gH_Db);  ?

I want to use that handle for other methods. Won't be able to use it if I close it?

[Kellan123]

Originally Posted by condolent I want to use that handle for other methods. Won't be able to use it if I close it?

Then goodluck with the error, you have to close it...

[condolent]

Originally Posted by Kellan123 Then goodluck with the error, you have to close it...

Do I have to use SQL_Connect in every method before SQL_Query then??
Or do I just need to close it once in Init_SQL() and then be able to re-use the handle later?

[condolent]

It's working just fine with

PHP Code:

SQL_FastQuery(gH_Db, sQuery); 


But not with

PHP Code:

DBResultSet SQL = SQL_Query(gH_Db, sQuery); 


[Kellan123]

PHP Code:

stock void SQL_InitDB() {
    char sError[255];
    if(gH_Db == INVALID_HANDLE) {
        gH_Db = SQL_Connect("betterwarden", true, sError, sizeof(sError));
        
        if(gH_Db == INVALID_HANDLE) {
            PrintToServer("### Could not connect to the database! ##");
            PrintToServer("%s", sError);
            CloseHandle(gh_Db); // invalid database :lol:
        } else {
            SQL_CreateBWTable();
        }
    } 


[condolent]

Originally Posted by Kellan123 PHP Code: stock void SQL_InitDB() {     char sError[255];     if(gH_Db == INVALID_HANDLE) {         gH_Db = SQL_Connect("betterwarden", true, sError, sizeof(sError));                  if(gH_Db == INVALID_HANDLE) {             PrintToServer("### Could not connect to the database! ##");             PrintToServer("%s", sError);             CloseHandle(gh_Db); // invalid database :lol:         } else {             SQL_CreateBWTable();         }     }

Where did you get that from? Can't close an invalid handle?

[Kellan123]

show SQL_CreateBWTable... dont use the last post...