[IndependentGaming]

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.

[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.

[SyS]

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.

[Luicy.]

Quote:

Originally Posted by Sreyas escape sequences are used in strings not in statements.

My bad.

[IndependentGaming]

Quote:

Originally Posted by Luicy. My bad.

So How to I fix this problem ?

[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

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.

[IndependentGaming]

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 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.

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

[azzerking]

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