Mysql error.

[Incognito.]

Sveiki taigi nezinau kame beda nesaugoje i sql faila. uzsimetu saibu ar xp bet neuzkrauna ju.

[23] >> mysql_connect( )

[23] CMySQLHandler::CMySQLHandler() - constructor called.

[23] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sasa" | Username: "root" ...

[23] CMySQLHandler::Connect() - Connection was successful.

[23] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[23] >> mysql_ping( Connection handle: 1 )

[23] CMySQLHandler::Ping() - Connection is still alive.

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `banai` WHERE IP = '127.0.0.1') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `banai` WHERE Vardas = 'Jack_Night') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT id FROM `users` WHERE vardas = 'Jack_Night') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(INSERT INTO `users` (vardas,slaptazodis) VALUES ('Jack_Night', ( 'AS' ))) - Successfully executed.

[23] >> mysql_insert_id( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET MoneyPocket = 0, MoneyBank = 0, MoneyHome = 0, Biznis = 0, Wanted = 0, Car = 0, LastSession = 58, Islead = 0, Gang = 0, Lead = 0, Kalejime = 0, Job = 0, WHERE `vardas` = 'Jack_Night') - 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 `vardas` = 'Jack_Night'' at line 1)

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET Drabuziai = 0, Uniforma = 0, Uniformd = 0, Xp = 0, Mobsas = 0, Pastatas = 0, Lytis = 0, pos_X = 0.000000, pos_Y = 2.000000, pos_Z = 0.000000, Interior = 0, Drugs = 0, License = 0, World = 0 Insurance = 74 WHERE `vardas` = '') - 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 'Insurance = 74 WHERE `vardas` = ''' at line 1)

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET `Ginklas0` = 0, `Ammo0` = 0, `Ginklas1` = 0, `Ammo1` = 0, `Ginklas2` = 0, `Ammo2` = 0, `Ginklas3` = 0, `Ammo3` = 0, `Ginklas4` = 0, `Ammo4` = 0, `Ginklas5` = 0, `Ammo5` = 0, `Ginklas6` = 0, `Ammo6` = 0, `Ginklas7` = 0, `Ammo7` = 0, `Ginklas8` = 0, `Ammo8` = 0, `Ginklas9` = 0, `Ammo9` = 0, `Ginklas10` = 0, `Ammo10` = 0, `Ginklas11` = 0, `Ammo11` = 0 WHERE `vardas` = 'Jack_Night') - Successfully executed.

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `banai` WHERE IP = '127.0.0.1') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `banai` WHERE Vardas = 'Eva_Cortez') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT id FROM `users` WHERE vardas = 'Eva_Cortez') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] CMySQLHandler::FetchRow() - Return: 125

[23] >> mysql_free_result( Connection handle: 1 )

[23] CMySQLHandler::FreeResult() - Result was successfully free'd.

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `users` WHERE id = 125) - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] CMySQLHandler::FetchRow() - Return: Eva_Cortez|AS|100000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|125|0|0|0|0|0

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `users` WHERE `vardas` = 'Eva_Cortez' AND `slaptazodis` = ( 'as' )) - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_num_rows( Connection handle: 1 )

[23] CMySQLHandler::NumRows() - Returned 1 row(s)

[23] >> mysql_retrieve_row( Connection handle: 1 )

[23] >> mysql_fetch_field_row( Connection handle: 1 )

[23] CMySQLHandler::FetchField("Xp") - 0

[23] >> mysql_fetch_field_row( Connection handle: 1 )

[23] CMySQLHandler::FetchField("Admin") - 0

[23] >> mysql_fetch_field_row( Connection handle: 1 )

[23] CMySQLHandler::FetchField("Superadmin") - 0

[23] >> mysql_fetch_field_row( Connection handle: 1 )

[23] CMySQLHandler::FetchField("Vip") - 0

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(SELECT * FROM `users` WHERE vardas = 'Eva_Cortez') - Successfully executed.

[23] >> mysql_store_result( Connection handle: 1 )

[23] CMySQLHandler::StoreResult() - Result was stored.

[23] >> mysql_fetch_row_format( Connection handle: 1 )

[23] CMySQLHandler::FetchRow() - Return: Eva_Cortez|AS|100000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|125|0|0|0|0|0

[23] >> mysql_fetch_field_row( Connection handle: 1 )

[23] CMySQLHandler::FetchField("Xp") - 0

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET MoneyPocket = 0, MoneyBank = 0, MoneyHome = 0, Biznis = 0, Wanted = 0, Car = 0, LastSession = 58, Islead = 0, Gang = 0, Lead = 0, Kalejime = 0, Job = 0, WHERE `vardas` = 'Eva_Cortez') - 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 `vardas` = 'Eva_Cortez'' at line 1)

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET Drabuziai = 0, Uniforma = 0, Uniformd = 0, Xp = 0, Mobsas = 0, Pastatas = 0, Lytis = -994743433, pos_X = -302.604156, pos_Y = 8.594780, pos_Z = 0.000000, Interior = 0, Drugs = 0, License = 0, World = 0 Insurance = 69 WHERE `vardas` = '') - 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 'Insurance = 69 WHERE `vardas` = ''' at line 1)

[23] >> mysql_query( Connection handle: 1 )

[23] CMySQLHandler::Query(UPDATE `users` SET `Ginklas0` = 0, `Ammo0` = 0, `Ginklas1` = 0, `Ammo1` = 0, `Ginklas2` = 0, `Ammo2` = 0, `Ginklas3` = 0, `Ammo3` = 0, `Ginklas4` = 0, `Ammo4` = 0, `Ginklas5` = 0, `Ammo5` = 0, `Ginklas6` = 0, `Ammo6` = 0, `Ginklas7` = 0, `Ammo7` = 0, `Ginklas8` = 0, `Ammo8` = 0, `Ginklas9` = 0, `Ammo9` = 0, `Ginklas10` = 0, `Ammo10` = 0, `Ginklas11` = 0, `Ammo11` = 0 WHERE `vardas` = 'Eva_Cortez') - Successfully executed.

Mysql logas

[Coder]

Parodyk "Zaidejai" sql tablės struktūrą.

[GuitarHero]

Po World = 0 trūksta kablelio.

[Incognito.]

Tas pats.

19:44:42] CMySQLHandler::Query(UPDATE `users` SET MoneyPocket = 3000, MoneyBank = 0, MoneyHome = 0, Biznis = 0, Wanted = 0, Car = 0, LastSession = 60, Islead = 0, Gang = 0, Lead = 0, Kalejime = 0, Job = 0, WHERE `vardas` = 'Jack_Night') - 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 `vardas` = 'Jack_Night'' at line 1)

[19] >> mysql_query( Connection handle: 1 )

[19] CMySQLHandler::Query(UPDATE `users` SET Drabuziai = 93, Uniforma = 0, Uniformd = 0, Xp = 0, Mobsas = 0, Pastatas = 0, Lytis = -994959263, pos_X = -293.175109, pos_Y = 16.148437, pos_Z = 0.000000, Interior = 0, Drugs = 0, License = 0, World = 0, Insurance = 74 WHERE `vardas` = '') - An error has occured. (Error ID: 1054, Unknown column 'Insurance' in 'field list')

[19] >> mysql_query( Connection handle: 1 )

[19] CMySQLHandler::Query(UPDATE `users` SET `Ginklas0` = 0, `Ammo0` = 0, `Ginklas1` = 0, `Ammo1` = 0, `Ginklas2` = 0, `Ammo2` = 0, `Ginklas3` = 0, `Ammo3` = 0, `Ginklas4` = 0, `Ammo4` = 0, `Ginklas5` = 0, `Ammo5` = 0, `Ginklas6` = 0, `Ammo6` = 0, `Ginklas7` = 0, `Ammo7` = 0, `Ginklas8` = 0, `Ammo8` = 0, `Ginklas9` = 0, `Ammo9` = 0, `Ginklas10` = 0, `Ammo10` = 0, `Ginklas11` = 0, `Ammo11` = 0 WHERE `vardas` = 'Jack_Night') - Successfully executed.