[Gortex]

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!

[Konstantinos]

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

For example:

pawn Code:

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

Do the same for the rest.

[Gortex]

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 


[Konstantinos]

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

[Gortex]

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!

[Konstantinos]

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.

[Gortex]

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

[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));

[Gortex]

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?

[Gortex]

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

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

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.

[Gortex]

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