NGRP Script+fixed Mysql [Release]

G

giogimic

New member
Joined
Aug 18, 2015
Messages
2
Reaction score
0
Ofue1937 link said:
Really not sure why everyone insists on using NGRP's script, it's not that great, there's better ways to do many things that are going on in the script, and it only makes sense if you have a large enough player base to support it. If you have 20 players and you use this script, chances are you're not ever going to see another player since the script is so spread across the map.
Click to expand...

Sure if you are dumb enough to leave the script as is, If you move everything to LS and close it all in then you've your a script with tons of features thats great to start on. I'm personally not going to use it but it's just the way i see it.
 
A

Arrow

Member
Joined
Aug 15, 2015
Messages
6
Reaction score
0
----------
Loaded log file: "server_log.txt".
----------

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

[20:10:26] password = ""  (string)
[20:10:26]
[20:10:26] Server Plugins
[20:10:26] --------------
[20:10:26]  Loading plugin: whirlpool.dll
[20:10:26] 
[20:10:26]  ==================
[20:10:26] 
[20:10:26]  Whirlpool loaded
[20:10:26] 
[20:10:26]  ==================
[20:10:26] 
[20:10:26]  Loaded.
[20:10:26]  Loading plugin: streamer.dll
[20:10:26]

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

[20:10:26]  Loaded.
[20:10:26]  Loading plugin: sscanf.dll
[20:10:26]

[20:10:26]  ===============================

[20:10:26]      sscanf plugin loaded.   

[20:10:26]          Version:  2.8.1       

[20:10:26]    (c) 2012 Alex "Y_Less" Cole 

[20:10:26]  ===============================

[20:10:26]  Loaded.
[20:10:26]  Loading plugin: nativechecker.dll
[20:10:26]  Loaded.
[20:10:26]  Loading plugin: crashdetect.dll
[20:10:26]  CrashDetect v4.10 is OK.
[20:10:26]  Loaded.
[20:10:26]  Loading plugin: mysql.dll
[20:10:26]  >> plugin.mysql: R33 successfully loaded.
[20:10:26]  Loaded.
[20:10:26]  Loaded 6 plugins.

[20:10:26]
[20:10:26] Filterscripts
[20:10:26] ---------------
[20:10:26]  Loading filterscript 'Maping.amx'...
[20:10:26]  Loading filterscript 'PlayerInteriors.amx'...
[20:10:27]  Loading filterscript 'PlayerExteriors.amx'...
[20:10:27]  Loading filterscript 'yom_buttons.amx'...
[20:10:27]  Loading filterscript 'vactions.amx'...
[20:10:27]  Loading filterscript 'Server.amx'...
[20:10:28]  Loaded 6 filterscripts.

[20:10:28]    Error: Function not registered: 'mysql_tquery'
[20:10:28]    Error: Function not registered: 'mysql_escape_string'
[20:10:28]    Error: Function not registered: 'cache_get_data'
[20:10:28]    Error: Function not registered: 'cache_get_field_content'
[20:10:28]    Error: Function not registered: 'mysql_stat'
[20:10:28]    Error: Function not registered: 'mysql_log'
[20:10:28]    Error: Function not registered: 'mysql_connect'
[20:10:28]    Error: Function not registered: 'mysql_errno'
[20:10:28]    Error: Function not registered: 'mysql_close'
[20:10:28]    Error: Function not registered: 'cache_get_row'
[20:10:28]    Error: Function not registered: 'cache_insert_id'
[20:10:28]    Error: Function not registered: 'cache_affected_rows'
[20:10:28] 
[20:10:28] 
[20:10:28] 
[20:10:28]  =======================================
[20:10:28]  |                                    |
[20:10:28]  |        YSI version 3.09.0684        |
[20:10:28]  |        By Alex "Y_Less" Cole        |
[20:10:28]  |                                    |
[20:10:28]  =======================================
[20:10:28] 
[20:10:28] 
[20:10:28] 
[20:10:28] Preparing the gamemode, please wait...
[20:10:30] [MySQL] (Main Pipelines) Connecting to localhost...
[20:10:30] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host localhost - DB: rs_db_3_3010 - User: rs_db_3_3010
[20:10:30] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[20:10:30] [MySQL] Error number: 2003
[20:10:30] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[20:10:30] [LoadCrates] Load Query Sent
[20:10:30] [LoadHouses] Loading data from database...
[20:10:30] [LoadDynamicDoors] Loading data from database...
[20:10:30] [LoadDynamicMapIcons] Loading data from database...
[20:10:30] [LoadMailboxes] Loading data from database...
[20:10:30] [LoadBusinesses] Loading data from database...
[20:10:30] [LoadAuctions] Loading data from database...
[20:10:30] [LoadTxtLabels] Loading data from database...
[20:10:30] [LoadPlants] Loading data from database...
[20:10:30] [SpeedCameras] Loading data from database...
[20:10:30] [LoadPayNSprays] Loading data from database...
[20:10:30] [LoadArrestPoints] Loading data from database...
[20:10:30] [LoadImpoundPoints] Loading data from database...
[20:10:30] [LoadRelayForLifeTeams] Loading data from database...
[20:10:30] [LoadBusinessSales] Loading data from database...
[20:10:30] [LoadTurfWars] 65 turfs loaded.
[20:10:30] [LoadPaintballArenas] 10 paintball arenas loaded.
[20:10:30] [LoadEventPoints] 0 event points loaded.
[20:10:30] [LoadGates] Loading data from database...
[20:10:30] [LoadElevatorStuff] 20 floors loaded.
[20:10:30] [LoadFamilies] Loading data from database...
[20:10:30] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[20:10:30] [MiscLoad] Misc Loaded
[20:10:30] Resetting news...
[20:10:30] Resetting default server variables..
[20:10:30] Adjusted the server time...
[20:10:30] [Streamer] Loading Dynamic Static Vehicles...
[20:10:30] [Streamer] Dynamic Static Vehicles has been loaded.
[20:10:30] [Streamer] Loading Dynamic Pickups...
[20:10:30] [Streamer] Dynamic Pickups has been loaded.
[20:10:30] [Streamer] Loading 3D Text Labels...
[20:10:30] [Streamer] Dynamic 3D Text Labels has been loaded.
[20:10:30] [Streamer] Loading Dynamic Buttons...
[20:10:30] [Streamer] Dynamic Buttons has been loaded.
[20:10:30] [Streamer] Loading Dynamic Objects...
[20:10:30] [Streamer] Dynamic Objects has been loaded.
[20:10:30] [Textdraws] Loading Textdraws...
[20:10:30] [Textdraws] Loaded textdraws.
[20:10:30] [Dynamic Groups] Loading Dynamic Groups...
[20:10:30] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[20:10:30]
-------------------------------------------
[20:10:30] Bloo Gaming Roleplay

[20:10:30] Copyright (C) Bloo Gaming, LLC (2013-2014)
[20:10:30] All Rights Reserved
[20:10:30] -------------------------------------------

[20:10:30] Successfully initiated the gamemode...
[20:10:30] Number of vehicle models: 29
[20:10:30] --- Server Shutting Down.
Click to expand...
:celeral_spitting: :angry:
Help me please
 
Mizaz

Mizaz

Active member
Joined
Feb 23, 2015
Messages
25
Reaction score
0
Arrow link said:
:celeral_spitting: :angry:
Help me please
Click to expand...

Edit userame and password in scriptfiles\mysql.cfg & mysql_remote.cfg
 
0xf0rd

0xf0rd

Active member
Joined
Jun 20, 2014
Messages
68
Reaction score
1
You are not connecting to the database correctly. Either the MySQL server is offline or you did not import the database correctly.
 
C0RE

C0RE

Active member
Joined
Apr 16, 2014
Messages
36
Reaction score
0
Think it'd help if I made a shitty tutorial for all the downies who can't figure out how to set this up?  :ppffh:
 
A

Arrow

Member
Joined
Aug 15, 2015
Messages
6
Reaction score
0
0xf0rd link said:
You are not connecting to the database correctly. Either the MySQL server is offline or you did not import the database correctly.
Click to expand...

explain please...

hamster link said:
Think it'd help if I made a shitty tutorial for all the downies who can't figure out how to set this up?  :ppffh:
Click to expand...
would be cool :trollface:
 
Mizaz

Mizaz

Active member
Joined
Feb 23, 2015
Messages
25
Reaction score
0
Do you have any program for mysql localhost?  :surprised:
 
A

Arrow

Member
Joined
Aug 15, 2015
Messages
6
Reaction score
0
Nope but i have an online server with mysql and i wanted to add it to it but it didnt work
 
Mizaz

Mizaz

Active member
Joined
Feb 23, 2015
Messages
25
Reaction score
0
try exporting localhost.sql to the desktop and import in mysql from host
 
P

Pr0GreSiVe

New member
Joined
Apr 27, 2014
Messages
1
Reaction score
0
Kahtam link said:
pawn compiler library has stopped working
Click to expand...
to compile it right change whatever you want from gamemode/include/commands.pwn for example click save and after that open the gamemode and click compile so that error wont show up again
 
0xf0rd

0xf0rd

Active member
Joined
Jun 20, 2014
Messages
68
Reaction score
1
Pwn files are in the includes folder inside the gamemode  folder.
 
S

Silent Sniper

New member
Joined
Jul 25, 2017
Messages
1
Reaction score
0
0xf0rd said:
Pwn files are in the includes folder inside the gamemode  folder.
Click to expand...


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

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[23:37:11] password = ""  (string)
[23:37:11]
[23:37:11] Server Plugins
[23:37:11] --------------
[23:37:11]  Loading plugin: mysql.dll
[23:37:11]  >> plugin.mysql: R33 successfully loaded.
[23:37:11]   Loaded.
[23:37:11]  Loading plugin: whirlpool.dll
[23:37:11]  
[23:37:11]  ==================
[23:37:11]  
[23:37:11]   Whirlpool loaded
[23:37:11]  
[23:37:11]  ==================
[23:37:11]  
[23:37:11]   Loaded.
[23:37:11]  Loading plugin: streamer.dll
[23:37:11]

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

[23:37:11]   Loaded.
[23:37:11]  Loading plugin: sscanf.dll
[23:37:11]

[23:37:11]  ===============================

[23:37:11]       sscanf plugin loaded.    

[23:37:11]          Version:  2.8.1        

[23:37:11]    (c) 2012 Alex "Y_Less" Cole  

[23:37:11]  ===============================

[23:37:11]   Loaded.
[23:37:11]  Loading plugin: nativechecker.dll
[23:37:11]   Loaded.
[23:37:11]  Loading plugin: crashdetect.dll
[23:37:11]   CrashDetect v4.10 is OK.
[23:37:11]   Loaded.
[23:37:11]  Loaded 6 plugins.

[23:37:11]
[23:37:11] Filterscripts
[23:37:11] ---------------
[23:37:11]   Loading filterscript 'Maping.amx'...
[23:37:11]   Loading filterscript 'PlayerInteriors.amx'...
[23:37:11]   Loading filterscript 'PlayerExteriors.amx'...
[23:37:12]   Loading filterscript 'yom_buttons.amx'...
[23:37:12]   Loading filterscript 'vactions.amx'...
[23:37:12]   Loading filterscript 'Server.amx'...
[23:37:13]   Loaded 6 filterscripts.

[23:37:13]  
[23:37:13]  
[23:37:13]  
[23:37:13]  =======================================
[23:37:13]  |                                     |
[23:37:13]  |        YSI version 3.09.0684        |
[23:37:13]  |        By Alex "Y_Less" Cole        |
[23:37:13]  |                                     |
[23:37:13]  =======================================
[23:37:13]  
[23:37:13]  
[23:37:14]  
[23:37:14] Preparing the gamemode, please wait...
[23:37:17] [MySQL] (Main Pipelines) Connecting to 185.27.134.10...
[23:37:17] [MySQL] (MainPipeline) Fatal Error! Could not connect to MySQL: Host 185.27.134.10 - DB: epiz_20417729_samp - User: epiz_20417729
[23:37:17] [MySQL] Note: Make sure that you have provided the correct connection credentials.
[23:37:17] [MySQL] Error number: 2003
[23:37:17] [Dynamic Giftbox] Loading the Dynamic Giftbox...
[23:37:17] [LoadCrates] Load Query Sent
[23:37:17] [LoadHouses] Loading data from database...
[23:37:17] [LoadDynamicDoors] Loading data from database...
[23:37:17] [LoadDynamicMapIcons] Loading data from database...
[23:37:17] [LoadMailboxes] Loading data from database...
[23:37:17] [LoadBusinesses] Loading data from database...
[23:37:17] [LoadAuctions] Loading data from database...
[23:37:17] [LoadTxtLabels] Loading data from database...
[23:37:17] [LoadPlants] Loading data from database...
[23:37:17] [SpeedCameras] Loading data from database...
[23:37:17] [LoadPayNSprays] Loading data from database...
[23:37:17] [LoadArrestPoints] Loading data from database...
[23:37:17] [LoadImpoundPoints] Loading data from database...
[23:37:17] [LoadRelayForLifeTeams] Loading data from database...
[23:37:17] [LoadBusinessSales] Loading data from database...
[23:37:18] [LoadTurfWars] 65 turfs loaded.
[23:37:18] [LoadPaintballArenas] 10 paintball arenas loaded.
[23:37:18] [LoadEventPoints] 0 event points loaded.
[23:37:18] [LoadGates] Loading data from database...
[23:37:18] [LoadElevatorStuff] 20 floors loaded.
[23:37:18] [LoadFamilies] Loading data from database...
[23:37:18] [LoadFamilyPoints] Loading Family Points from the database, please wait...
[23:37:18] [MiscLoad] Misc Loaded
[23:37:18] Resetting news...
[23:37:18] Resetting default server variables..
[23:37:18] Adjusted the server time...
[23:37:18] [Streamer] Loading Dynamic Static Vehicles...
[23:37:19] [Streamer] Dynamic Static Vehicles has been loaded.
[23:37:19] [Streamer] Loading Dynamic Pickups...
[23:37:19] [Streamer] Dynamic Pickups has been loaded.
[23:37:19] [Streamer] Loading 3D Text Labels...
[23:37:19] [Streamer] Dynamic 3D Text Labels has been loaded.
[23:37:19] [Streamer] Loading Dynamic Buttons...
[23:37:19] [Streamer] Dynamic Buttons has been loaded.
[23:37:19] [Streamer] Loading Dynamic Objects...
[23:37:19] [Streamer] Dynamic Objects has been loaded.
[23:37:19] [Textdraws] Loading Textdraws...
[23:37:19] [Textdraws] Loaded textdraws.
[23:37:19] [Dynamic Groups] Loading Dynamic Groups...
[23:37:19] [Dynamic Groups] Loading Dynamic Groups Vehicles...
[23:37:19]
-------------------------------------------
[23:37:19] Bloo Gaming Roleplay

[23:37:19] Copyright (C) Bloo Gaming, LLC (2013-2014)
[23:37:19] All Rights Reserved
[23:37:19] -------------------------------------------

[23:37:19] Successfully initiated the gamemode...
[23:37:19] Number of vehicle models: 29
[23:37:19] --- Server Shutting Down.
that did connect to the mysql. Can you help me?
 
U

UmarX

New member
Joined
Dec 13, 2017
Messages
1
Reaction score
0
[09:55:10] --- Server Shutting Down.
[09:55:38] [debug] Server crashed while executing BGRP.amx
[09:55:38] [debug] AMX backtrace:
[09:55:38] [debug] #0 native mysql_close () [70d1d240] from mysql.dll
[09:55:38] [debug] #1 0037f6a4 in ?? () from BGRP.amx
[09:55:38] [debug] #2 00524f7c in ?? () from BGRP.amx
[09:55:38] [debug] #3 0000cdc8 in ?? () from BGRP.amx
[09:55:38] [debug] #4 00006f68 in public OnGameModeExit () from BGRP.amx
[09:55:38] [debug] System backtrace:
[09:55:38] [debug] #0 1000c859 in ?? () from C:\Users\Umar\Desktop\Project\LIBMYSQL.dll
[09:55:38] [debug] #1 1000dcfd in ?? () from C:\Users\Umar\Desktop\Project\LIBMYSQL.dll
[09:55:38] [debug] #2 77d657f9 in ?? () from C:\WINDOWS\SYSTEM32\ntdll.dll

this is the reason why server is crashed
 
Harrison Khan

Harrison Khan

Active member
Joined
Jan 1, 2015
Messages
27
Reaction score
0
I am getting a runtime error 19.  And according to their solution, I must update the include files and the plugin. Why do I have to update them myself? Why would you upload something that is broken.

Code: 
[17:19:46]    Error: Function not registered: 'mysql_log'
[17:19:46]    Error: Function not registered: 'mysql_tquery'
[17:19:46]    Error: Function not registered: 'mysql_escape_string'
[17:19:46]    Error: Function not registered: 'cache_get_data'
[17:19:46]    Error: Function not registered: 'cache_get_field_content'
[17:19:46]    Error: Function not registered: 'mysql_stat'
[17:19:46]    Error: Function not registered: 'mysql_connect'
[17:19:46]    Error: Function not registered: 'mysql_errno'
[17:19:46]    Error: Function not registered: 'mysql_close'
[17:19:46]    Error: Function not registered: 'cache_get_row'
[17:19:46]    Error: Function not registered: 'cache_insert_id'
[17:19:46]    Error: Function not registered: 'cache_affected_rows'
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] Script[gamemodes/BGRP.amx]: Run time error 19: "File or function is not found"
[17:19:46] Number of vehicle models: 0
 
0xf0rd

0xf0rd

Active member
Joined
Jun 20, 2014
Messages
68
Reaction score
1
Harrison Khan said:
I am getting a runtime error 19.  And according to their solution, I must update the include files and the plugin. Why do I have to update them myself? Why would you upload something that is broken.

Code: 
[17:19:46]    Error: Function not registered: 'mysql_log'
[17:19:46]    Error: Function not registered: 'mysql_tquery'
[17:19:46]    Error: Function not registered: 'mysql_escape_string'
[17:19:46]    Error: Function not registered: 'cache_get_data'
[17:19:46]    Error: Function not registered: 'cache_get_field_content'
[17:19:46]    Error: Function not registered: 'mysql_stat'
[17:19:46]    Error: Function not registered: 'mysql_connect'
[17:19:46]    Error: Function not registered: 'mysql_errno'
[17:19:46]    Error: Function not registered: 'mysql_close'
[17:19:46]    Error: Function not registered: 'cache_get_row'
[17:19:46]    Error: Function not registered: 'cache_insert_id'
[17:19:46]    Error: Function not registered: 'cache_affected_rows'
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] Script[gamemodes/BGRP.amx]: Run time error 19: "File or function is not found"
[17:19:46] Number of vehicle models: 0
Click to expand...

No you don't need to update any includes. You simply need Visual Studio runtime 2010 
https://www.microsoft.com/en-ca/download/details.aspx?id=5555
 
Harrison Khan

Harrison Khan

Active member
Joined
Jan 1, 2015
Messages
27
Reaction score
0
0xf0rd said:
Harrison Khan said:
I am getting a runtime error 19.  And according to their solution, I must update the include files and the plugin. Why do I have to update them myself? Why would you upload something that is broken.

Code: 
[17:19:46]    Error: Function not registered: 'mysql_log'
[17:19:46]    Error: Function not registered: 'mysql_tquery'
[17:19:46]    Error: Function not registered: 'mysql_escape_string'
[17:19:46]    Error: Function not registered: 'cache_get_data'
[17:19:46]    Error: Function not registered: 'cache_get_field_content'
[17:19:46]    Error: Function not registered: 'mysql_stat'
[17:19:46]    Error: Function not registered: 'mysql_connect'
[17:19:46]    Error: Function not registered: 'mysql_errno'
[17:19:46]    Error: Function not registered: 'mysql_close'
[17:19:46]    Error: Function not registered: 'cache_get_row'
[17:19:46]    Error: Function not registered: 'cache_insert_id'
[17:19:46]    Error: Function not registered: 'cache_affected_rows'
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] [debug] Run time error 19: "File or function is not found"
[17:19:46] [debug]  mysql_log
[17:19:46] [debug]  mysql_tquery
[17:19:46] [debug]  mysql_escape_string
[17:19:46] [debug]  cache_get_data
[17:19:46] [debug]  cache_get_field_content
[17:19:46] [debug]  mysql_stat
[17:19:46] [debug]  mysql_connect
[17:19:46] [debug]  mysql_errno
[17:19:46] [debug]  mysql_close
[17:19:46] [debug]  cache_get_row
[17:19:46] [debug]  cache_insert_id
[17:19:46] [debug]  cache_affected_rows
[17:19:46] Script[gamemodes/BGRP.amx]: Run time error 19: "File or function is not found"
[17:19:46] Number of vehicle models: 0
Click to expand...

No you don't need to update any includes. You simply need Visual Studio runtime 2010 
https://www.microsoft.com/en-ca/download/details.aspx?id=5555
Click to expand...
Says I have the latest version of runtime.
 
You must log in or register to reply here.
Top