[Metharon]

/**
* MySQL plugin R39
*/

Can somebody fix it , and if isn't soo much , to explain what i did wrong ? i try to learn to use mysql!

Code:

[18:28:34] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `users` SET `Cash` ='750', `Bank` ='0', `Salary` ='0', `Skin` = '3' WHERE' at line 2

pawn Code:

Function SalvareDate(playerid)
{
    new name[MAX_PLAYER_NAME+1];
    GetPlayerName(playerid, name, sizeof(name));
    if( IsPlayerAlreadyLoggedIN[playerid] == 0 ) return 1;
    new Float: x, Float: y, Float: z, Float: angle;
    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, angle);
    new query1[456], query2[456], query3[456], query4[456],query5[456],query6[456],query7[456],query8[456],query9[456],query10[456],querycomplet[1430];
    szQuery[ 0 ] = EOS;
    format( query8, sizeof( query8 ), "UPDATE `users` SET `Adverts` = '%d', `Admin` = '%d', `Helper` = '%d', `Donate` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][Advertismente], PlayerInfo[playerid][Administrator], PlayerInfo[playerid][Helper], PlayerInfo[playerid][Donator], name );
    mysql_tquery( SQL , query8 , "" , "" );     

    if( RecentChangedPass[playerid] == 1 )
    {
        format( query10, sizeof( query10 ), "UPDATE `users` SET  `Password` = '%s' WHERE `Name` = '%s'", PlayerInfo[playerid][Password], name);
        mysql_tquery( SQL , query10 , "" , "" );                
        RecentChangedPass[playerid] = 0;
    }
    format( query1, sizeof( query1 ), "UPDATE `users` SET `aFlag` = '%d', `hFlag` = '%d', `FactionID` = '%d', `FactionRank` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][aFlag], PlayerInfo[playerid][hFlag], PlayerInfo[playerid][FactionID], PlayerInfo[playerid][FactionRank], name);
    format( query2, sizeof( query2 ), "UPDATE `users` SET `Cash` ='%d', `Bank` ='%d', `Salary` ='%d', `Skin` = '%d' WHERE `Name` = '%s'", GetPlayerMoney( playerid ), PlayerInfo[playerid][MoneyInBank], PlayerInfo[playerid][Salariul], PlayerInfo[playerid][pSkin], name );       
    format( query3, sizeof( query3 ), "UPDATE `users` SET `Sex` ='%d', `Age` ='%d', `Job` ='%d', `Level` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][Sex], PlayerInfo[playerid][Varsta], PlayerInfo[playerid][Job], PlayerInfo[playerid][Nivel], name);
    format( query4, sizeof( query4 ), "UPDATE `users` SET `Respect` ='%d', `hPoints` ='%d', `Banned` ='%d', `Mute` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][Respect], PlayerInfo[playerid][OreJucate], PlayerInfo[playerid][Blocare], PlayerInfo[playerid][pMute], name);
    format( query5, sizeof( query5 ), "UPDATE `users` SET `MuteTime` ='%d', `Spawn` ='%d', `CarLic` ='%d', `FlyLic` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][pMuteTime], PlayerInfo[playerid][pSpawnChoose], PlayerInfo[playerid][CarLic], PlayerInfo[playerid][FlyLic], name);
    format( query6, sizeof( query6 ), "UPDATE `users` SET `GunLic` ='%d', `BoatLic` ='%d', `Tutorial` ='%d', `Paydays` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][GunLic], PlayerInfo[playerid][BoatLic], PlayerInfo[playerid][pStagiuTut], PlayerInfo[playerid][PayDays], name);
    format( query7, sizeof( query7 ), "UPDATE `users` SET `ATMCard` ='%d', `PhoneCard` ='%d', `pCars` ='%d', `pHomes` = '%d', `RobState` = '%d' WHERE `Name` = '%s'", PlayerInfo[playerid][pATMcard], PlayerInfo[playerid][PhoneCard], PlayerInfo[playerid][Cars], PlayerInfo[playerid][pHomes], PlayerInfo[playerid][RobState], name);
    format( querycomplet, sizeof( querycomplet ), "%s\n%s\n%s\n%s\n%s\n%s\n%s ", query1,query2,query3,query4,query5,query6,query7);
    mysql_tquery( SQL , querycomplet , "" , "" );       
     
    if( IsServerRestarting[playerid] == 0 )
    {
        format( query9, sizeof( query9 ), "UPDATE `users` SET  `sAngle` = '%f', `sPosX` = '%f', `sPosY` = '%f', `sPosZ` = '%f' WHERE `Name` = '%s'", angle, x, y, z, name );
        mysql_tquery( SQL , query9 , "" , "" );             
    }       
    return 1;
}

[Xabi]

It's %d, not '%d', the '' are used only for strings ('%s')

[Metharon]

pawn Code:

[18:42:11] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `users` SET `Cash` =750, `Bank` =0, `Salary` =0, `Skin` = 1 WHERE `Name` ' at line 2

Still don't working.. ?

[Metharon]

UP PLEASE