SQL issue.
#5

Yo Getty! There was one missing integer specifier in your code.

pawn Код:
format(Query, sizeof(Query), "UPDATE `PlayerVehicles` SET `Mod1`='%d', `Mod2`='%d', `Mod3`='%d', `Mod4`='%d', `Mod5`='%d', `Mod6`='%d', `Mod7`='%d', `Mod8`='%d', `Mod9`='%d', `Mod10`='%d',\
    `Mod11` = '%d', `Mod12`='%d', `Mod13`='%d', `Mod14`='%d', `Mod15`='%d', `Mod16`='%d', `Mod17`= '%d' WHERE `OwnedVehicleID` = %i LIMIT 1"
,
    Vehicles[iVehicleID][mod1],
    Vehicles[iVehicleID][mod2],
    Vehicles[iVehicleID][mod3],
    Vehicles[iVehicleID][mod4],
    Vehicles[iVehicleID][mod5],
    Vehicles[iVehicleID][mod6],
    Vehicles[iVehicleID][mod7],
    Vehicles[iVehicleID][mod8],
    Vehicles[iVehicleID][mod9],
    Vehicles[iVehicleID][mod10],
    Vehicles[iVehicleID][mod11],
    Vehicles[iVehicleID][mod12],
    Vehicles[iVehicleID][mod13],
    Vehicles[iVehicleID][mod14],
    Vehicles[iVehicleID][mod15],
    Vehicles[iVehicleID][mod16],
    Vehicles[iVehicleID][mod17],
    iVehicleID);
   
    mysql_query(Query);
Or you can also do with strcat.

pawn Код:
new Query2[200]
    format(Query, sizeof(Query), "UPDATE `PlayerVehicles` SET `Mod1`='%d', `Mod2`='%d', `Mod3`='%d', `Mod4`='%d', `Mod5`='%d', `Mod6`='%d', `Mod7`='%d', `Mod8`='%d', `Mod9`='%d', `Mod10`='%d'",
    Vehicles[iVehicleID][mod1],
    Vehicles[iVehicleID][mod2],
    Vehicles[iVehicleID][mod3],
    Vehicles[iVehicleID][mod4],
    Vehicles[iVehicleID][mod5],
    Vehicles[iVehicleID][mod6],
    Vehicles[iVehicleID][mod7],
    Vehicles[iVehicleID][mod8],
    Vehicles[iVehicleID][mod9],
    Vehicles[iVehicleID][mod10]);
    format(Query2,sizeof(Query2),"`Mod11` = '%d', `Mod12`='%d', `Mod13`='%d', `Mod14`='%d', `Mod15`='%d', `Mod16`='%d', `Mod17`= '%d' WHERE `OwnedVehicleID` = %d LIMIT 1",
    Vehicles[iVehicleID][mod11],
    Vehicles[iVehicleID][mod12],
    Vehicles[iVehicleID][mod13],
    Vehicles[iVehicleID][mod14],
    Vehicles[iVehicleID][mod15],
    Vehicles[iVehicleID][mod16],
    Vehicles[iVehicleID][mod17],
    iVehicleID);
    strcat(Query,Query2);
   
    mysql_query(Query);
Reply


Messages In This Thread
SQL issue. - by iGetty - 01.12.2012, 09:55
Re: SQL issue. - by Konstantinos - 01.12.2012, 10:08
Re: SQL issue. - by iGetty - 01.12.2012, 11:06
Re: SQL issue. - by Konstantinos - 01.12.2012, 11:16
Re: SQL issue. - by Ballu Miaa - 01.12.2012, 11:32
Re: SQL issue. - by iGetty - 01.12.2012, 11:34
Re: SQL issue. - by Konstantinos - 01.12.2012, 11:39
Re: SQL issue. - by iGetty - 01.12.2012, 11:40
Re: SQL issue. - by iGetty - 01.12.2012, 12:04
Re: SQL issue. - by Ballu Miaa - 02.12.2012, 06:21

Forum Jump:


Users browsing this thread: 3 Guest(s)