22.05.2016, 02:14
Код:
* [MySQL]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `carID` = '2314'' at line 1
* [MySQL]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `carID` = '2314'' at line 1
Car_Save(carid) { static query[2048]; if (CarData[carid][carVehicle] != INVALID_VEHICLE_ID) { for (new i = 0; i < 14; i ++) { CarData[carid][carMods][i] = GetVehicleComponentInSlot(CarData[carid][carVehicle], i); } } format(query, sizeof(query), "UPDATE `cars` SET `carModel` = '%d', `carOwner` = '%d',`carMultas` = '%d', carDono = '%s', `carPosX` = '%.4f', `carPosY` = '%.4f', `carPosZ` = '%.4f', `carPosR` = '%.4f', `carColor1` = '%d', `carColor2` = '%d', `carPaintjob` = '%d', `carLocked` = '%d', `carPrice` = '%d', `carPlate` = '%d', `carAlarm` = '%d', `carTime` = '%d'", CarData[carid][carModel], CarData[carid][carOwner], CarData[carid][carMultas], SQL_ReturnEscaped(CarData[carid][carDono]), CarData[carid][carPos][0], CarData[carid][carPos][1], CarData[carid][carPos][2], CarData[carid][carPos][3], CarData[carid][carColor1], CarData[carid][carColor2], CarData[carid][carPaintjob], CarData[carid][carLocked], CarData[carid][carPrice], CarData[carid][carPlate], CarData[carid][carAlarm], CarData[carid][carTime] ); format(query, sizeof(query), "%s, `carMod1` = '%d', `carMod2` = '%d', `carMod3` = '%d', `carMod4` = '%d', `carMod5` = '%d', `carMod6` = '%d', `carMod7` = '%d', `carMod8` = '%d', `carMod9` = '%d', `carMod10` = '%d', `carMod11` = '%d', `carMod12` = '%d', `carMod13` = '%d', `carMod14` = '%d', `carMod15` = '%d', `carMod16` = '%d'", query, CarData[carid][carMods][0], CarData[carid][carMods][1], CarData[carid][carMods][2], CarData[carid][carMods][3], CarData[carid][carMods][4], CarData[carid][carMods][5], CarData[carid][carMods][6], CarData[carid][carMods][7], CarData[carid][carMods][8], CarData[carid][carMods][9], CarData[carid][carMods][10], CarData[carid][carMods][11], CarData[carid][carMods][12], CarData[carid][carMods][13], CarData[carid][carMods][14], CarData[carid][carMods][15] ); format(query, sizeof(query), "%s, `carImpounded` = '%d', `carImpoundPrice` = '%d', `carFaction` = '%d', `carSiren` = '%d',`carWeapon1` = '%d', `carWeapon2` = '%d', `carWeapon3` = '%d', `carWeapon4` = '%d', `carWeapon5` = '%d', `carAmmo1` = '%d', `carAmmo2` = '%d', `carAmmo3` = '%d', `carAmmo4` = '%d', `carAmmo5` = '%d', `CarArmaPL` = '%d', `CarMuniPL` = '%d', `CarArmaAssento` = '%d', `CarMuniAssento` = '%d', `CarArmaGunrack` = '%d', `CarMuniGunrack` = '%d' WHERE `carID` = '%d' ", query, CarData[carid][carImpounded], CarData[carid][carImpoundPrice], CarData[carid][carFaction], CarData[carid][carSiren], CarData[carid][carWeapons][0], CarData[carid][carWeapons][1], CarData[carid][carWeapons][2], CarData[carid][carWeapons][3], CarData[carid][carWeapons][4], CarData[carid][carAmmo][0], CarData[carid][carAmmo][1], CarData[carid][carAmmo][2], CarData[carid][carAmmo][3], CarData[carid][carAmmo][4], CarData[carid][carArmaPL], CarData[carid][carMuniPL], CarData[carid][carArmaAssento], CarData[carid][carMuniAssento], CarData[carid][carArmaGunrack], CarData[carid][carMuniGunrack], CarData[carid][carID] ); return mysql_tquery(g_iHandle, query);