MySQL problem..
#7

pawn Код:
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Origin` = '2', `Sex` = '1', `FirstLogin` = '1', `Staff` = '5' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Mapper` = '0', `PosX` = '2719.636962', `PosY` = '-1769.138549', `PosZ` = '1604.602294' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Interior` = '1', `SavePos` = '1',`Member` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Rank` = '0', `Bani` = '400', `Warns` = '0', `Age` = '14' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `CarLic` = '0', `FlyLic` = '0', `BoatLic` = '0', `GunLic` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `AccesDMV` = '0', `UpgradeAge` = '0', `Skin` = '23', `Bilet` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Ban` = '0', `Job` = '0', `JobEchipat` = '0', `JobFinish` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `JobPlata` = '0', `JobTimed` = '0', `JobTime` = '0', `World` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Muted` = '0', `MuteTime` = '0', `AmmuTrainTime` = '0', `PistSkill` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `SilenSkill` = '0', `DesertSkill` = '0', `ShotgSkill` = '0', `SmgSkill` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `AkSkill` = '0', `M4Skill` = '0', `Undite` = '0', `Rame` = '0' WHERE `username` ='Wally_Larro' ) - Successfully executed.
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `HouseKey` = '0', `RentKey` = '0', `CarKey` = '255'` WHERE `username` ='Wally_Larro' ) - An error has occured. (Error ID: 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 '` WHERE `username` ='Wally_Larro'' at line 1)
[10:51:15] >> mysql_query( Connection handle: 1 )
[10:51:15] CMySQLHandler::Query(UPDATE `players` SET `Scoala` = '0', `Profil` = '0', `Romana` = '0', `RT1` = '0', WHERE `username` ='Wally_Larro' ) - An error has occured. (Error ID: 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 'WHERE `username` ='Wally_Larro'' at line 1)
[10:51:15] >> mysql_free_result( Connection handle: 1 )
Reply


Messages In This Thread
MySQL problem.. - by GeonMake - 06.03.2012, 07:44
Re: MySQL problem.. - by MP2 - 06.03.2012, 07:46
Re: MySQL problem.. - by GeonMake - 06.03.2012, 07:53
Re: MySQL problem.. - by MP2 - 06.03.2012, 08:10
Re: MySQL problem.. - by GeonMake - 06.03.2012, 08:21
Re: MySQL problem.. - by MP2 - 06.03.2012, 08:30
Re: MySQL problem.. - by GeonMake - 06.03.2012, 08:33
Re: MySQL problem.. - by MP2 - 06.03.2012, 08:36
Re: MySQL problem.. - by GeonMake - 06.03.2012, 08:37

Forum Jump:


Users browsing this thread: 1 Guest(s)