1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
SQL issue.
iGetty
High-roller
*****
Posts: 1,753
Threads: 277
Joined: Sep 2010
Reputation: 0
#1

01.12.2012, 09:55
I'm having a small problem with a query, not actually inserting the data into the database.


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` 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);
That there, doesn't insert the above items into the actual table.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

01.12.2012, 10:08
This is UPDATE, not INSERT. it updates already inserted data.

pawn Код:
INSERT INTO table_name ( field1, field2,...fieldN ) VALUES( value1, value2,...valueN )
and
pawn Код:
UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_value
Find
Reply
iGetty
High-roller
*****
Posts: 1,753
Threads: 277
Joined: Sep 2010
Reputation: 0
#3

01.12.2012, 11:06
I meant updating.. It's not updating the data correctly.
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#4

01.12.2012, 11:16
Make sure the table is called PlayerVehicles.
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);

    print(Query); // Debug
    mysql_query(Query);
Show what it prints and if it still does not update, there's a way.
For example on SQLite, I can execute SQL from a database editor, if there is error, it says which one.
Find
Reply
Ballu Miaa
High-roller
*****
Posts: 1,849
Threads: 96
Joined: Apr 2010
Reputation: 0
#5

01.12.2012, 11:32
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);
Find
Reply
iGetty
High-roller
*****
Posts: 1,753
Threads: 277
Joined: Sep 2010
Reputation: 0
#6

01.12.2012, 11:34
Код:
[52:12 - 05] UPDATE `PlayerVehicles` SET Mod1=0, Mod2=0, Mod3=0, Mod4=0, Mod5=0, Mod6=0, Mod7=0, Mod8=0, Mod9=0, Mod10=0, Mod12=0, Mod13=0, Mod13=0, Mod14=0, Mod15=0, Mod16=0, Mod17=0 WHERE OwnedVehicleID=2
[52:12 - 05] Vehicle ID: 56 - Component ID: 1014
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#7

01.12.2012, 11:39
Код:
[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);
Find
Reply
iGetty
High-roller
*****
Posts: 1,753
Threads: 277
Joined: Sep 2010
Reputation: 0
#8

01.12.2012, 11:40
Thank you both!
Find
Reply
iGetty
High-roller
*****
Posts: 1,753
Threads: 277
Joined: Sep 2010
Reputation: 0
#9

01.12.2012, 12:04
The mods still aren't saving..


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 WHERE `OwnedVehicleID` = %d 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],
    iVehicleID);
    
    mysql_query(Query);
    
    format(Query,sizeof(Query),"UPDATE `PlayerVehicles` SET `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);

    mysql_query(Query);
Find
Reply
Ballu Miaa
High-roller
*****
Posts: 1,849
Threads: 96
Joined: Apr 2010
Reputation: 0
#10

02.12.2012, 06:21
Getty use this code! This will work fine for you!! We gotta format two strings and strcat these two strings together.

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);
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help