"./include/enums.pwn" - Printable Version

"./include/enums.pwn" - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: "./include/enums.pwn" (/showthread.php?tid=514607)

"./include/enums.pwn" - Gortex - 22.05.2014

Hello there!

So, I've bought a script, and it isn't working, it's showing me that shit

I don't know how to fix it! It's mad!
http://prntscr.com/3lj0nj Here's a picture of my include folder, and here's the picture of the error: http://prntscr.com/3lj0aw

Please help me, I need to get it running as soon as possible!

Re: "./include/enums.pwn" - Konstantinos - 22.05.2014

It's "../" and not "./"

For example:

pawn Code:

#include "../include/enums.pwn"

Do the same for the rest.

Re: "./include/enums.pwn" - Gortex - 22.05.2014

PHP Code:



C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/functions.pwn(3135) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(21508) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(21537) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(21685) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(21710) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(22978) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23082) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23107) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23127) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23154) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23255) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23293) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23492) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(23493) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(25312) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(26596) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(29693) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(31302) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(33564) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(33565) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(33590) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(33591) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(36441) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(36442) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(36572) : error 017: undefined symbol "mysql_escape_string"
C:\Users\Andrej\Desktop\Secret\pawno\include\../includes/commands.pwn(37336) : error 017: undefined symbol "mysql_escape_string"

Compilation aborted.Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase

Re: "./include/enums.pwn" - Konstantinos - 22.05.2014

Are you sure the mysql version of the include you use has mysql_escape_string function defined?

Re: "./include/enums.pwn" - Gortex - 22.05.2014

Quote:

Originally Posted by Konstantinos

Are you sure the mysql version of the include you use has mysql_escape_string function defined?

I don't have a clue, The script was given to me. What version should I use? and How, also, thank you so much for replies!

Re: "./include/enums.pwn" - Konstantinos - 22.05.2014

Me neither without knowing the mysql plugin and version. Find the include for the mysql in pawno\include folder and open it. It may be written which one it is.

Re: "./include/enums.pwn" - Gortex - 22.05.2014

On include it is: * MySQL plugin R26
and there's the pwn code of the mysql.pwn: http://pastebin.com/V5MNai6x

Re: "./include/enums.pwn" - Konstantinos - 22.05.2014

In R26 by BlueG the function mysql_escape_string doesn't exist but there is mysql_real_escape_string:

pawn Code:

native mysql_real_escape_string(const source[], destination[], connectionHandle = 1, max_len=sizeof(destination));

Re: "./include/enums.pwn" - Gortex - 22.05.2014

Quote:

Originally Posted by Konstantinos

In R26 by BlueG the function mysql_escape_string doesn't exist but there is mysql_real_escape_string:

pawn Code:

native mysql_real_escape_string(const source[], destination[], connectionHandle = 1, max_len=sizeof(destination));

So what does that mean? Should I use the R33 Plugin that plugin have mysql_escape_string or I should change it?

Re: "./include/enums.pwn" - Gortex - 22.05.2014

PHP Code:



----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team

[17:18:32] 
[17:18:32] Server Plugins
[17:18:32] --------------
[17:18:32]  Loading plugin: streamer
[17:18:32] 

*** Streamer Plugin v2.6.1 by Incognito loaded ***

[17:18:32]   Loaded.
[17:18:32]  Loading plugin: sscanf
[17:18:32] 

[17:18:32]  ===============================

[17:18:32]       sscanf plugin loaded.     

[17:18:32]    (c) 2009 Alex "Y_Less" Cole

[17:18:32]    0.3d-R2 500 Players "dnee"

[17:18:32]  ===============================

[17:18:32]   Loaded.
[17:18:32]  Loading plugin: mysql
[17:18:32]  >> plugin.mysql: R33 successfully loaded.
[17:18:32]   Loaded.
[17:18:32]  Loading plugin: Whirlpool
[17:18:32]  
[17:18:32]  ==================
[17:18:32]  
[17:18:32]   Whirlpool loaded
[17:18:32]  
[17:18:32]  ==================
[17:18:32]  
[17:18:32]   Loaded.
[17:18:32]  Loaded 4 plugins.

[17:18:32] 
[17:18:32] Ban list
[17:18:32] --------
[17:18:32]  Loaded: samp.ban
[17:18:32] 
[17:18:32] 
[17:18:32] Filterscripts
[17:18:32] ---------------
[17:18:32]   Loading filterscript 'yom_buttons.amx'...
[17:18:32]   Loading filterscript 'gcustom.amx'...
[17:18:33]   Loaded 2 filterscripts.

[17:18:33]  
[17:18:33]  ======================================= 
[17:18:33]  |                                     | 
[17:18:33]  |        YSI version 3.01.0002        | 
[17:18:33]  |        By Alex "Y_Less" Cole        | 
[17:18:33]  |                                     | 
[17:18:33]  ======================================= 
[17:18:33]  
[17:18:33] Preparing the gamemode, please wait...
[17:18:33] [MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[17:18:33] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 127.0.0.1 - DB: ngrp_main - User: root
[17:18:33] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[17:18:33] [MySQL] Error number: 1049
[17:18:33] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[17:18:33] [LoadCrates] Load Query Sent
[17:18:33] [LoadHouses] Loading data from database...
[17:18:33] [LoadDynamicDoors] Loading data from database...
[17:18:33] [LoadDynamicMapIcons] Loading data from database...
[17:18:33] [LoadMailboxes] Loading data from database...
[17:18:33] [LoadBusinesses] Loading data from database...
[17:18:33] [LoadAuctions] Loading data from database...
[17:18:33] [LoadTxtLabels] Loading data from database...
[17:18:33] [LoadPlants] Loading data from database...
[17:18:33] [SpeedCameras] Loading data from database...
[17:18:33] [LoadPayNSprays] Loading data from database...
[17:18:33] [LoadArrestPoints] Loading data from database...
[17:18:33] [LoadImpoundPoints] Loading data from database...
[17:18:33] [LoadRelayForLifeTeams] Loading data from database...
[17:18:33] [LoadBusinessSales] Loading data from database...
[17:18:33] -mSelection- WARNING: Failed to load list: "ToyList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "CarList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "PlaneList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "BoatList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "ToyList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "CarList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "RestrictedCarList.txt"
[17:18:33] -mSelection- WARNING: Failed to load list: "SkinList.txt"
[17:18:33] [LoadTurfWars] 0 turfs loaded.
[17:18:33] [LoadPaintballArenas] 10 paintball arenas loaded.
[17:18:33] [LoadGates] Loading data from database...
[17:18:33] [LoadFamilies] Loading data from database...
[17:18:33] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[17:18:33] [MiscLoad] Misc Loaded
[17:18:33] Resetting news...
[17:18:33] Resetting default server variables..
[17:18:33] Adjusted the server time...
[17:18:33] [Streamer] Loading Dynamic Static Vehicles...
[17:18:33] [Streamer] Dynamic Static Vehicles has been loaded.
[17:18:33] [Streamer] Loading Dynamic Pickups...
[17:18:33] [Streamer] Dynamic Pickups has been loaded.
[17:18:33] [Streamer] Loading 3D Text Labels...
[17:18:33] [Streamer] Dynamic 3D Text Labels has been loaded.
[17:18:33] [Streamer] Loading Dynamic Buttons...
[17:18:33] [Streamer] Dynamic Buttons has been loaded.
[17:18:33] [Streamer] Loading Dynamic Objects...
[17:18:33] [Streamer] Dynamic Objects has been loaded.
[17:18:33] [Textdraws] Loading Textdraws...
[17:18:33] [Textdraws] Loaded textdraws.
[17:18:33] [Dynamic Groups] Loading Dynamic Groups...
[17:18:33] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[17:18:33] 
-------------------------------------------
[17:18:33] Prestigiuos Gaming Roleplay

[17:18:33] Copyright (C) Prestigiuos Gaming Roleplay, LLC (2012-2013)
[17:18:33] All Rights Reserved
[17:18:33] -------------------------------------------

[17:18:33] Successfully initiated the gamemode...
[17:18:33] Number of vehicle models: 29
[17:18:33] --- Server Shutting Down.
[17:18:33] 

*** Streamer Plugin v2.6.1 by Incognito unloaded ***

[17:18:33] 

[17:18:33]  ===============================

[17:18:33]      sscanf plugin unloaded.    

[17:18:33]  ===============================

[17:18:33] plugin.mysql: Unloading plugin...
[17:18:38] plugin.mysql: Plugin unloaded.
[17:18:38]  
[17:18:38]  ====================
[17:18:38]  
[17:18:38]   Whirlpool unloaded
[17:18:38]  
[17:18:38]  ====================
[17:18:38]

Now it will run but then it crash :<

Re: "./include/enums.pwn" - Konstantinos - 22.05.2014

From what I see in R33, it's defined in R33. It's recommended though to use R38 which is the latest one and you can use mysql_format (it should be '%e' instead of '%s' to the one you want to escape) instead, without the need of using mysql_escape_string all the time for strings.

EDIT: It shuts down the server because of this:

pawn Code:

[MySQL] (Main Pipelines) Connecting to 127.0.0.1...
[17:18:33] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 127.0.0.1 - DB: ngrp_main - User: root
[17:18:33] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[17:18:33] [MySQL] Error number: 1049

And by the way, update streamer to 2.7.2 and sscanf to 2.8.1 as well as re-compile your scripts with the latest version of their include too.

Re: "./include/enums.pwn" - Gortex - 22.05.2014

Quote:

Originally Posted by Konstantinos

From what I see in R33, it's defined in R33. It's recommended though to use R38 which is the latest one and you can use mysql_format (it should be '%e' instead of '%s' to the one you want to escape) instead, without the need of using mysql_escape_string all the time for strings.

Now server will start and die the same freaking second