MySQL server. - 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: MySQL server. (
/showthread.php?tid=517821)
MySQL server. -
Gogorakis - 06.06.2014
When I open my server it says:
Код:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team
[01:26:35]
[01:26:35] Server Plugins
[01:26:35] --------------
[01:26:35] Loading plugin: sscanf
[01:26:35]
[01:26:35] ===============================
[01:26:35] sscanf plugin loaded.
[01:26:35] © 2009 Alex "******" Cole
[01:26:35] ===============================
[01:26:35] Loaded.
[01:26:35] Loading plugin: encrypt
[01:26:35]
[01:26:35] ______________________________________
[01:26:35] Encrypt Plugin v0.1 loaded
[01:26:35] ______________________________________
[01:26:35] By: Fro © Copyright <TBG> 2009-2010
[01:26:35] ______________________________________
[01:26:35] Loaded.
[01:26:35] Loading plugin: crashdetect
[01:26:35] crashdetect v4.8.5 is OK.
[01:26:35] Loaded.
[01:26:35] Loading plugin: mysql
[01:26:35]
> MySQL plugin R7 successfully loaded.
[01:26:35] Loaded.
[01:26:35] Loaded 4 plugins.
[01:26:35]
[01:26:35] Ban list
[01:26:35] --------
[01:26:35] Loaded: samp.ban
[01:26:35]
[01:26:35]
[01:26:35] Filterscripts
[01:26:35] ---------------
[01:26:35] Loading filterscript 'bowling.amx'...
[01:26:35] [debug] Run time error 19: "File or function is not found"
[01:26:35] [debug] Streamer_CallbackHook
[01:26:35] [debug] SSCANF_Init
[01:26:35] [debug] SSCANF_Join
[01:26:35] [debug] SSCANF_Leave
[01:26:35] [debug] CreateDynamicPickup
[01:26:35] [debug] CreateDynamic3DTextLabel
[01:26:35] [debug] CreateDynamicCP
[01:26:35] [debug] CreateDynamicObject
[01:26:35] [debug] UpdateDynamic3DTextLabelText
[01:26:35] [debug] Streamer_Update
[01:26:35] [debug] Streamer_UpdateEx
[01:26:35] [debug] DestroyDynamicPickup
[01:26:35] [debug] DestroyDynamic3DTextLabel
[01:26:35] [debug] DestroyDynamicMapIcon
[01:26:35] [debug] CreateDynamicMapIcon
[01:26:35] [debug] MoveDynamicObject
[01:26:35] [debug] DestroyDynamicObject
[01:26:35] [debug] GetDynamicObjectPos
[01:26:35] Loading filterscript 'objects-server.amx'...
[01:26:35] Loaded 2 filterscripts.
[01:26:36] [debug] Run time error 19: "File or function is not found"
[01:26:36] [debug] Streamer_CallbackHook
[01:26:36] [debug] CreateDynamicObject
[01:26:36] [debug] DestroyDynamicObject
[01:26:36] [debug] mysql_query
[01:26:36] [debug] mysql_fetch_int
[01:26:36] [debug] mysql_fetch_row
[01:26:36] [debug] mysql_init
[01:26:36] [debug] CreateDynamicObjectEx
[01:26:36] [debug] SetDynamicObjectMaterialText
[01:26:36] [debug] CreateDynamic3DTextLabel
[01:26:36] [debug] CreateDynamicPickup
[01:26:36] [debug] TogglePlayerAllDynamicCPs
[01:26:36] [debug] CreateDynamicCP
[01:26:36] [debug] TogglePlayerDynamicCP
[01:26:36] [debug] DestroyDynamic3DTextLabel
[01:26:36] [debug] Run time error 19: "File or function is not found"
[01:26:36] [debug] Streamer_CallbackHook
[01:26:36] [debug] CreateDynamicObject
[01:26:36] [debug] DestroyDynamicObject
[01:26:36] [debug] mysql_query
[01:26:36] [debug] mysql_fetch_int
[01:26:36] [debug] mysql_fetch_row
[01:26:36] [debug] mysql_init
[01:26:36] [debug] CreateDynamicObjectEx
[01:26:36] [debug] SetDynamicObjectMaterialText
[01:26:36] [debug] CreateDynamic3DTextLabel
[01:26:36] [debug] CreateDynamicPickup
[01:26:36] [debug] TogglePlayerAllDynamicCPs
[01:26:36] [debug] CreateDynamicCP
[01:26:36] [debug] TogglePlayerDynamicCP
[01:26:36] [debug] DestroyDynamic3DTextLabel
[01:26:36] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[01:26:36] Number of vehicle models: 0
I don't know..Should I create a MySQL server?
It's really hard for me..so I want to know if you guys can help me create a MySQL server and tell me how it works!
*I want to test a gamemode*
*I am not hosting a server on a host company*
*I host the server on my laptop*
Re: MySQL server. -
Konstantinos - 06.06.2014
You forgot to load streamer plugin. Except that, you've loaded the wrong mysql plugin. The script uses the plugin by StrickenKid.
You should really update the plugins and their includes because sscanf and crashdetect are older versions.
And to answer your question - yes. You'll need a MySQL server so install WAMP.
Re: MySQL server. -
Gogorakis - 07.06.2014
I installed the WAMP server.
I got all the MySQL information to connect (username,pass etc)..
Now how can I host it?
*I JUST INSTALLED WAMP*
Re: MySQL server. -
Konstantinos - 07.06.2014
Run WampServer and when the icon (at the botton and right of the screen) is green, it's online.
You'll probably need to create the database so login through phpMyAdmin* to do so. You can create another user from there as well.
* Clicking on the icon, will give you a list. The second one is phpMyAdmin.
Re: MySQL server. -
rymax99 - 07.06.2014
WAMP is outdated, and not stable for live use. For the MySQL server, there's lots of articles on ****** relating to that. MySQL isn't specific to SA-MP by any means, it's used in many places including just about every forum, most popular SA-MP servers, etc. Once you get MySQL working, you'll need the table structure of the mode you're using imported to the database that you have connected with the server.