[itaialroy]

Hey everybody. I'm trying to compile this WC-RP 3.4 gamemode and it seems like there's a problem with the mysql include.

Quote:

C:\Users\itauv\Desktop\TA-RP\pawno\include\progress.inc(170) : warning 217: loose indentation C:\Users\itauv\Desktop\TA-RP\pawno\include\progress.inc(172) : warning 217: loose indentation wcrp\admin.pwn(1097) : error 017: undefined symbol "mysql_affected_rows" wcrp\admin.pwn(1226) : error 017: undefined symbol "mysql_affected_rows" wcrp\admin.pwn(375 : warning 213: tag mismatch wcrp\admin.pwn(3761) : warning 213: tag mismatch wcrp\admin.pwn(3772) : warning 213: tag mismatch wcrp\admin.pwn(3773) : warning 213: tag mismatch wcrp\admin.pwn(3774) : warning 213: tag mismatch wcrp\admin.pwn(3776) : warning 213: tag mismatch wcrp\admin.pwn(5581) : warning 203: symbol is never used: "playerid" wcrp\admin.pwn(5694) : error 017: undefined symbol "mysql_affected_rows" wcrp\admin.pwn(5700) : error 017: undefined symbol "mysql_insert_id" wcrp\admin.pwn(5955) : error 017: undefined symbol "mysql_affected_rows" wcrp\account.pwn(274) : error 017: undefined symbol "mysql_insert_id" wcrp\account.pwn(29 : error 017: undefined symbol "mysql_insert_id" wcrp\account.pwn(799) : error 017: undefined symbol "mysql_insert_id" wcrp\account.pwn(800) : error 017: undefined symbol "mysql_insert_id" wcrp\account.pwn(972) : warning 202: number of arguments does not match definition wcrp\account.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\account.pwn(155 : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\account.pwn(197 : error 017: undefined symbol "mysql_affected_rows" wcrp\account.pwn(2021) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(1167) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(1372) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(1513) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\vehicles.pwn(1552) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(2387) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(2712) : error 017: undefined symbol "mysql_insert_id" wcrp\vehicles.pwn(3975) : warning 204: symbol is assigned a value that is never used: "driver" wcrp\business.pwn(1117) : error 017: undefined symbol "mysql_insert_id" wcrp\business.pwn(2019) : warning 217: loose indentation wcrp\business.pwn(2020) : warning 217: loose indentation wcrp\business.pwn(2021) : warning 217: loose indentation wcrp\business.pwn(2022) : warning 217: loose indentation wcrp\business.pwn(2023) : warning 217: loose indentation wcrp\business.pwn(2114) : warning 217: loose indentation wcrp\interiors.pwn(27 : warning 209: function "interiorTryEnterExit" should return a value wcrp\families.pwn(186) : error 017: undefined symbol "mysql_insert_id" wcrp\families.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\families.pwn(109 : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\houses.pwn(752) : error 017: undefined symbol "mysql_affected_rows" wcrp\jobs.pwn(2541) : error 017: undefined symbol "cache_get_field" wcrp\safes.pwn(75) : error 017: undefined symbol "mysql_insert_id" wcrp\safes.pwn(283) : error 017: undefined symbol "mysql_insert_id" wcrp\safes.pwn(290) : error 017: undefined symbol "mysql_insert_id" wcrp\safes.pwn(754) : error 017: undefined symbol "mysql_affected_rows" wcrp\safes.pwn(789) : error 017: undefined symbol "mysql_affected_rows" wcrp\accessories.pwn(622) : error 017: undefined symbol "mysql_insert_id" Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 26 Errors.

I tried several versions of that a_mysql include but it didn't work.
Help ?

[Chilli9434]

are you sure you have the right version of the plugin/include, or even if it is indeed the correct plugin/include

[itaialroy]

Quote:

Originally Posted by Chilli9434 are you sure you have the right version of the plugin/include, or even if it is indeed the correct plugin/include

I tried lots of versions already...

[AndySedeyn]

Quote:

Originally Posted by itaialroy I tried lots of versions already...

Have you only tested the most recent versions? Or also the older versions? mysql_affected_rows, mysql_insert_id. I reckon these functions being quite old. Try versions R7 and below.

[itaialroy]

Quote:

Originally Posted by AndySedeyn Have you only tested the most recent versions? Or also the older versions? mysql_affected_rows, mysql_insert_id. I reckon these functions being quite old. Try versions R7 and below.

Tried everything. In R34 it shows only two errors though.

[AndySedeyn]

R34? That's odd. I just checked the a_mysql.inc version R34, and it does not have those functions in it. What you could do is update the script with the most recent version (and thus, the most recent functions). A time consuming task but definitely worth it when it comes to efficiency and security.

[itaialroy]

Quote:

Originally Posted by AndySedeyn R34? That's odd. I just checked the a_mysql.inc version R34, and it does not have those functions in it. What you could do is update the script with the most recent version (and thus, the most recent functions). A time consuming task but definitely worth it when it comes to efficiency and security.

How can I do that ? any tutorial ?

[AndySedeyn]

Quote:

Originally Posted by itaialroy How can I do that ? any tutorial ?

I'm wrong. I had the wrong version opened. R34 does have those functions. What errors are you still getting when compiling with R34?

[itaialroy]

Quote:

Originally Posted by AndySedeyn I'm wrong. I had the wrong version opened. R34 does have those functions. What errors are you still getting when compiling with R34?

Quote:

C:\Users\itauv\Desktop\TA-RP\pawno\include\progress.inc(170) : warning 217: loose indentation C:\Users\itauv\Desktop\TA-RP\pawno\include\progress.inc(172) : warning 217: loose indentation wcrp\admin.pwn(375 : warning 213: tag mismatch wcrp\admin.pwn(3761) : warning 213: tag mismatch wcrp\admin.pwn(3772) : warning 213: tag mismatch wcrp\admin.pwn(3773) : warning 213: tag mismatch wcrp\admin.pwn(3774) : warning 213: tag mismatch wcrp\admin.pwn(3776) : warning 213: tag mismatch wcrp\admin.pwn(5581) : warning 203: symbol is never used: "playerid" wcrp\account.pwn(972) : warning 202: number of arguments does not match definition wcrp\account.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\account.pwn(155 : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\vehicles.pwn(1513) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\vehicles.pwn(3975) : warning 204: symbol is assigned a value that is never used: "driver" wcrp\business.pwn(2019) : warning 217: loose indentation wcrp\business.pwn(2020) : warning 217: loose indentation wcrp\business.pwn(2021) : warning 217: loose indentation wcrp\business.pwn(2022) : warning 217: loose indentation wcrp\business.pwn(2023) : warning 217: loose indentation wcrp\business.pwn(2114) : warning 217: loose indentation wcrp\interiors.pwn(27 : warning 209: function "interiorTryEnterExit" should return a value wcrp\families.pwn(1087) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\families.pwn(109 : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\factions\leo.pwn(493) : warning 204: symbol is assigned a value that is never used: "rank" wcrp\factions\leo.pwn(492) : warning 204: symbol is assigned a value that is never used: "faction" wcrp\forumsync.pwn(31) : warning 203: symbol is never used: "email" wcrp\forumsync.pwn(31) : warning 203: symbol is never used: "pass" wcrp\forumsync.pwn(31) : warning 203: symbol is never used: "username" wcrp\forumsync.pwn(31) : warning 203: symbol is never used: "playerid" wcrp\forumsync.pwn(3 : warning 203: symbol is never used: "pass" wcrp\forumsync.pwn(3 : warning 203: symbol is never used: "playerid" wcrp\forumsync.pwn(92) : warning 203: symbol is never used: "newusername" wcrp\forumsync.pwn(92) : warning 203: symbol is never used: "oldusername" wcrp\forumsync.pwn(92) : warning 203: symbol is never used: "playerid" wcrp\walltags.pwn(512) : warning 224: indeterminate array size in "sizeof" expression (symbol "max_len") wcrp\cartoys.pwn(96) : warning 217: loose indentation wcrp\cartoys.pwn(100) : warning 203: symbol is never used: "inputtext" wcrp\cartoys.pwn(409) : warning 203: symbol is never used: "CRY" wcrp\cartoys.pwn(409) : warning 203: symbol is never used: "CRX" wcrp\cheats.pwn(1 : warning 203: symbol is never used: "reason" wcrp\cheats.pwn(61) : warning 203: symbol is never used: "inputtext" wcrp\cheats.pwn(76) : warning 203: symbol is never used: "oldkeys" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(351) : error 017: undefined symbol "enable_mutex" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(417) : error 017: undefined symbol "mysql_ping" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1113) : warning 219: local variable "query" shadows a variable at a preceding level C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "EventOnPlayerDeath" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "IsEventAdmin" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "IsFlyCar" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "LookupPlayerIP" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "NumPlayerRentCars" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "RPTestLabels" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "SendMsgToRadioSnoopers" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "ShowAllNameTagsForPlayer" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(1239) : warning 203: symbol is never used: "SyncWarns" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212) : warning 204: symbol is assigned a value that is never used: "VoteStarter" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "canUseDrugCommand" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "diseaseCheck" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "doBankSettlement" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "doDiseaseEffect" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "endRace" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "fpscamkeysOnPlayerKeyState" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "getBasketTeam" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "getCraftCooldownTime" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "getDrugCooldownTime" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "getPlayerNumAjails" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "getVehicleReclaimPrice" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "hasOOCTag" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "infectNearbyPlayers" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "isBankInNegative" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "isRaceActive" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "isSwitchingChars" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "playerGetsDisease" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(212 -- 1239) : warning 203: symbol is never used: "sendTourettesMessage" C:\Users\itauv\Desktop\TA-RP\gamemodes\WCRP.pwn(724) : warning 204: symbol is assigned a value that is never used: "servermaintenance" Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 2 Errors.

Warnings are scary though

[AndySedeyn]

Warnings are not only scary, I recommend getting rid of them (obviously, 'The symbol is never used before', isn't that harming. It does take memory for nothing really.). Reading the R34 source code, I understand that 'mysql_ping' is deprecated. Could you show me the piece of code where mysql_ping is used? The other error is self-explanatory. You are using a variable that is not declared. You either declare the variable correctly or remove the code where it is used.