[KaLoIaN]

http://pastebin.com/MuXMnHmj

As you see plugin_end function is quoted because it gives me error : [MySQL] Invalid handle: 0

The variable: escapes just does not saves.. I haven't got any errors from the plugin.


P.S. I put the code in pastebin because when I try to post the thread with the code - cloudflare of the forum does not allows me (maybe because of the sql symbols idk)..

[SpeeDeeR]

Doesn't

PHP Code:

"UPDATE `zmescape` SET `escapes` = '%i' WHERE `escapes`.`name` = '%s' 


has to be

PHP Code:

"UPDATE `zmescape` SET `escapes` = '%i' WHERE `zmescape`.`name` = '%s' 


You don't need to specify the column's table since you are updating it.

PHP Code:

"UPDATE `zmescape` SET `escapes` = '%i' WHERE `name` = '%s' 


[KaLoIaN]

Here is how I made the update line:

format(szTemp,charsmax(szTemp),"UPDATE `zmescape` SET `escapes` = '%i' WHERE `zmescape`.`name` = '%s';",escapes[id], szName)

But it's still not working. It just does not saves.

[KaLoIaN]

Somebody?

[gabuch2]

PHP Code:

format(szTemp,charsmax(szTemp),"UPDATE `zmescape` SET `escapes` = '%i' WHERE `zmescape`.`name` = '%s';",escapes[id], szName) 


This is redundant

>>

PHP Code:

format(szTemp,charsmax(szTemp),"UPDATE `zmescape` SET `escapes` = '%i' WHERE `name` = '%s';",escapes[id], szName) 


You don't need to specify the table if you're manipulating only one.

[KaLoIaN]

Originally Posted by Shattered Heart Lynx PHP Code: format(szTemp,charsmax(szTemp),"UPDATE `zmescape` SET `escapes` = '%i' WHERE `zmescape`.`name` = '%s';",escapes[id], szName)  This is redundant >> PHP Code: format(szTemp,charsmax(szTemp),"UPDATE `zmescape` SET `escapes` = '%i' WHERE `name` = '%s';",escapes[id], szName)  You don't need to specify the table if you're manipulating only one.

Again it does not save anything .....

[KaLoIaN]

Is it so damn difficult lol? No one has made an correct answer...

[Bugsy]

This doesn't appear to have anything to do with his SQL query.

Are you setting g_SqlTuple to 0 somewhere else in your code? Are you getting this error in any other places when you try to use g_SqlTuple?

[KaLoIaN]

g_SqlTuple is not set to 0 nowhere. And yes I am getting it everytime I am using this tutorial:

click me

but it seems to be not well written or I do somethin' bad..

The main problem is that it does not saves.

[Bugsy]

See if this works for you:

PHP Code:


#include <amxmodx>
#include <sqlx>

new Handle:g_SQLTuple , g_szQueryCache[ 2000 ];

new const SQL_CreateTable[] = "QUERY TO CREATE TABLE WHICH WAS BLOCKED BY SERVER";

public plugin_init() 
{
    SQL_SetAffinity( "sqlite" );
    g_SQLTuple = SQL_MakeDbTuple( "" , "" , "" , "MyDatabaseFile" );
    
    new Handle:SqlConnection , ErrorCode;
    SqlConnection = SQL_Connect( g_SQLTuple , ErrorCode , g_szQueryCache , charsmax( g_szQueryCache ) );
    
    if( SqlConnection == Empty_Handle )
        set_fail_state( g_szQueryCache );
    
    RunQuery( SqlConnection , SQL_CreateTable );
}

public plugin_end() 
{
    SQL_FreeHandle( g_SQLTuple );
}

public RunQuery( Handle:SQLConnection , const szQuery[] )
{
    new Handle:Query = SQL_PrepareQuery( SQLConnection , szQuery );
    
    if( !SQL_Execute( Query ) )
    {
        SQL_QueryError( Query , g_szQueryCache , 100 );
        set_fail_state( g_szQueryCache );
    }
}