SQL issue.
#7

Код:
[52:12 - 05] UPDATE [..] Mod8=0, Mod9=0, Mod10=0, Mod12=0, Mod13=0, Mod13=0, Mod14=0, Mod15=0, Mod16=0, Mod17=0 WHERE OwnedVehicleID=2
it's mod10,12,13,13. You're missing 11 as Ballu Miaa said it above.

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=%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],
    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);
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: 1 Guest(s)