mysql_log:
pawn Код:
[14:37:31] CMySQLHandler::Query(SELECT * FROM `zaidejudb` WHERE `Vardas` = 'Raimis_R') - Successfully executed.
[14:37:31] >> mysql_store_result( Connection handle: 1 )
[14:37:31] CMySQLHandler::StoreResult() - Result was stored.
[14:37:31] >> mysql_fetch_row_format( Connection handle: 1 )
[14:37:31] >> mysql_free_result( Connection handle: 1 )
[14:37:31] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:52:06] >> mysql_query( Connection handle: 1 )
[14:52:06] CMySQLHandler::Query(UPDATE `namudb` SET `IsejimasX` = '-2646.763916', `IsejimasY` = '-26.979505', `IsejimasZ` = '6.132812', `IeimasX` = '-42.452201', `IeimasY` = '1405.485351', `IeimasZ` = '1084.429565', `Parduodamas` = '0', `Uzrakintas` = '1', `Raktai` = '0' WHERE `SQL` = '1') - Successfully executed.
[14:52:06] >> mysql_query( Connection handle: 1 )
[14:52:06] CMySQLHandler::Query(UPDATE `namudb` SET `Savininkas` = 'AndriusZ', `RaktuSavininkas` = 'NERA', `Interior` = '0', `NamoID` = '1', `PadetiPinigai` = '0', `Kaina` = '110000` WHERE `SQL` = '1') - 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 '1'' at line 1)
[14:52:06] >> mysql_close( Connection handle: 1 )
[14:52:06] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[14:52:06] CMySQLHandler::Disconnect() - Connection was closed.
lines
pawn Код:
format( Query, 750, "UPDATE `namudb` SET `IsejimasX` = '%f', `IsejimasY` = '%f', `IsejimasZ` = '%f', `IeimasX` = '%f', `IeimasY` = '%f', `IeimasZ` = '%f', `Parduodamas` = '%i', `Uzrakintas` = '%i', `Raktai` = '%i' WHERE `SQL` = '%d'",
NamuDB[ hID ][ hIsejimas ][ 0 ], NamuDB[ hID ][ hIsejimas ][ 1 ], NamuDB[ hID ][ hIsejimas ][ 2 ], NamuDB[ hID ][ hIeimas ][ 0 ], NamuDB[ hID ][ hIeimas ][ 1 ], NamuDB[ hID ][ hIeimas ][ 2 ], NamuDB[ hID ][ hParduodamas ], NamuDB[ hID ][ hUzrakintas ], NamuDB[ hID ][ hRaktai ], NamuDB[ hID ][ hNamoID ] );
mysql_query( Query );
format( Query, 500, "UPDATE `namudb` SET `Savininkas` = '%s', `RaktuSavininkas` = '%s', `Interior` = '%d', `NamoID` = '%d', `PadetiPinigai` = '%d', `Kaina` = '%d` WHERE `SQL` = '%d'", NamuDB[ hID ][ hSavininkas ], NamuDB[ hID ][ hRSavininkas ], NamuDB[ hID ][ hInterior ], NamuDB[ hID ][ hNamoID ], NamuDB[ hID ][ hPinigai ], NamuDB[ hID ][ hKaina ], NamuDB[ hID ][ hNamoID ] );
mysql_query( Query );