mysql error - Printable Version

mysql error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql error (/showthread.php?tid=618557)

mysql error - IndependentGaming - 07.10.2016

Hello, I have add 2 things to the line and getting errors I cannot see what I did wrong please help me out here I have added VW and Int

PHP код:



format(szQuery, sizeof(szQuery), "%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW %d, Int %d WHERE Owner = %d AND ID = %d", szQuery, PlayerVehicleInfo[extraid][v][pvMods][3], PlayerVehicleInfo[extraid][v][pvMods][4], PlayerVehicleInfo[extraid][v][pvMods][5],

                        PlayerVehicleInfo[extraid][v][pvMods][6], PlayerVehicleInfo[extraid][v][pvMods][7], PlayerVehicleInfo[extraid][v][pvMods][8], PlayerVehicleInfo[extraid][v][pvMods][9], PlayerVehicleInfo[extraid][v][pvMods][10], PlayerVehicleInfo[extraid][v][pvMods][11], PlayerVehicleInfo[extraid][v][pvMods][12],

                        PlayerVehicleInfo[extraid][v][pvMods][13], PlayerVehicleInfo[extraid][v][pvMods][14], PlayerVehicleInfo[extraid][v][pvVW][15], PlayerVehicleInfo[extraid][v][pvInt][16], PlayerInfo[extraid][pID], PlayerVehicleInfo[extraid][v][pvRealID]);

Error List

Код:

 Roleplay\gamemodes\RP.pwn(46827 -- 46829) : error 001: expected token: ",", but found "["
 Roleplay\gamemodes\RP.pwn(46829) : error 029: invalid expression, assumed zero
 Roleplay\gamemodes\RP.pwn(46829) : warning 215: expression has no effect
 Roleplay\gamemodes\RP.pwn(46829) : error 001: expected token: ";", but found "]"
 Roleplay\gamemodes\RP.pwn(46829) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.

Re: mysql error - Luicy. - 07.10.2016

Код:

format(szQuery, sizeof(szQuery), "%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW %d, Int %d WHERE Owner = %d AND ID = %d", szQuery, PlayerVehicleInfo[extraid][v][pvMods][3], PlayerVehicleInfo[extraid][v][pvMods][4], PlayerVehicleInfo[extraid][v][pvMods][5],\
                        PlayerVehicleInfo[extraid][v][pvMods][6], PlayerVehicleInfo[extraid][v][pvMods][7], PlayerVehicleInfo[extraid][v][pvMods][8], PlayerVehicleInfo[extraid][v][pvMods][9], PlayerVehicleInfo[extraid][v][pvMods][10], PlayerVehicleInfo[extraid][v][pvMods][11], PlayerVehicleInfo[extraid][v][pvMods][12],\
                        PlayerVehicleInfo[extraid][v][pvMods][13], PlayerVehicleInfo[extraid][v][pvMods][14], PlayerVehicleInfo[extraid][v][pvVW][15], PlayerVehicleInfo[extraid][v][pvInt][16], PlayerInfo[extraid][pID], PlayerVehicleInfo[extraid][v][pvRealID]);

When you're doing as you did, breaking lines, then you must use the letter \ at the end of the line.

Re: mysql error - SyS - 07.10.2016

probably you are using the array in wrong dimension as per its declaration.

Quote:

Originally Posted by Luicy.

Код:

format(szQuery, sizeof(szQuery), "%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW %d, Int %d WHERE Owner = %d AND ID = %d", szQuery, PlayerVehicleInfo[extraid][v][pvMods][3], PlayerVehicleInfo[extraid][v][pvMods][4], PlayerVehicleInfo[extraid][v][pvMods][5],\
                        PlayerVehicleInfo[extraid][v][pvMods][6], PlayerVehicleInfo[extraid][v][pvMods][7], PlayerVehicleInfo[extraid][v][pvMods][8], PlayerVehicleInfo[extraid][v][pvMods][9], PlayerVehicleInfo[extraid][v][pvMods][10], PlayerVehicleInfo[extraid][v][pvMods][11], PlayerVehicleInfo[extraid][v][pvMods][12],\
                        PlayerVehicleInfo[extraid][v][pvMods][13], PlayerVehicleInfo[extraid][v][pvMods][14], PlayerVehicleInfo[extraid][v][pvVW][15], PlayerVehicleInfo[extraid][v][pvInt][16], PlayerInfo[extraid][pID], PlayerVehicleInfo[extraid][v][pvRealID]);

When you're doing as you did, breaking lines, then you must use the letter \ at the end of the line.

escape sequences are used in strings not in statements.

Re: mysql error - Luicy. - 07.10.2016

Quote:

Originally Posted by Sreyas

escape sequences are used in strings not in statements.

My bad.

Re: mysql error - IndependentGaming - 07.10.2016

Quote:

Originally Posted by Luicy.

My bad.

So How to I fix this problem ?

Re: mysql error - azzerking - 07.10.2016

You have a bit of an error here:

Код:

%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW %d, Int %d WHERE Owner = %d AND ID = %d

change to

Код:

%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW = %d, Int = %d WHERE Owner = %d AND ID = %d

Also, do you use sscanf at all? you could just have one field in your table called mods, which would be a string and you could separate the mod ids by a comma.

So you could grab the contents of field from the table and it would look like this

Код:

1010,1074,1031,1139,1033,1140,1169,0,0,0,0,0

now using sscanf you could split this string by the comma.

Example:

Код:

new mod_split[ 12 ]; // 12 being the max mods a vehicle can have. 0 - 12 ( 13 total )
sscanf( mods, "p<,>a<12>", mod_split );

now you can loop through the array and check if each value is a valid mod then apply it to the vehicle. The reason I do this is because it looks neater in my db and the code is not that much to do.

Though I did not help you solve this issue, I hope I managed to help you optimize your code and db.

Re: mysql error - IndependentGaming - 07.10.2016

Quote:

Originally Posted by azzerking

You have a bit of an error here:

Код:

%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW %d, Int %d WHERE Owner = %d AND ID = %d

change to

Код:

%s Mod3 = %d, Mod4 = %d, Mod5 = %d, Mod6 = %d, Mod7 = %d, Mod8 = %d, Mod9 = %d, Mod10 = %d, Mod11 = %d, Mod12 = %d, Mod13 = %d, Mod14 = %d, VW = %d, Int = %d WHERE Owner = %d AND ID = %d

Код:

1010,1074,1031,1139,1033,1140,1169,0,0,0,0,0

now using sscanf you could split this string by the comma.

Example:

Код:

new mod_split[ 12 ]; // 12 being the max mods a vehicle can have. 0 - 12 ( 13 total )
sscanf( mods, "p<,>a<12>", mod_split );

I have changed the line you said but getting the same errors.. I'm not good with mysql things..

Re: mysql error - azzerking - 07.10.2016

Can we see your enum structure? as well as another place in your script you have used the enum variables?