[maddinat0r]

Quote:

Originally Posted by IstuntmanI I guess that you made the system in the wrong way. It is pretty weird. You are surely messing IDs. -- Is there a way for getting a value from database (with mysql_query) when executing a query (mysql_pquery) without automatically removing the first result set (from mysql_pquery)?

This should do:

Код:

function ChangePassword( )
{
    new liRows = cache_get_row_count( ), liKey;
    new Cache:cache = cache_save();
    for( new rowid = 0; rowid < liRows; rowid ++ )
    {
    	cache_set_active(cache);
        liKey = cache_get_row_int( rowid, 0 );
        format( gsQuery, 1024, "UPDATE `Accounts` SET `Password` = '%s' WHERE `Key` = %d", SHA512_Account( liKey, gsString, "password" ), liKey );
        mysql_pquery( 1, gsQuery );
        
        // because SHA512_Account function has been executed, the result set is now empty and the following rows are returning only 0. I think that this result set is deleted when the one from mysql_query is created and activated.
    }
    cache_delete(cache);
}

Quote:

Originally Posted by kurta999 Please check this, if mysql plugin caused this then try to fix it, but I think that's not caused by plugin.

Could be indeed a bug in the plugin. It likely seems, that you are passing a non-numerical value to the 'X' specifier in a mysql_format call (which is probably in function 'FixGameString'). Please report back if you found any mistake.