SA-MP Forums Archive
[Tutorial] [TUT]Installing and Running XAMPP ( For mysql servers ) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Tutorials (https://sampforum.blast.hk/forumdisplay.php?fid=70)
+---- Thread: [Tutorial] [TUT]Installing and Running XAMPP ( For mysql servers ) (/showthread.php?tid=38561)

Pages: 1 2


[TUT]Installing and Running XAMPP ( For mysql servers ) - jat1801 - 01.06.2008

This tutorial is outdated, I will no longer offer support on it


Jats XAMMP Tutorial
In this tutorial i will show you how to install and run mysql. I used the gamemode moderntopia for this tutorial .

Here are the steps.

1. Getting moderntopia to download it use this link Moderntopia Thread.

2. Getting SAMP-MySQL. SAMP-MySQL Thread

3.Setting Up The Plugin.
I'm Only Gonna Show How To Setup Windows.
Ok Open Up The Zip MySQL Zip File And Minus It Down We Will Need It Later, Open Up Your Sever Folder And Create A New Folder Called "plugins" without the "".
Now Maximize The Zip Again And Put sampmysql.dll inside the plugins. Now go back to the folder where your sa-mp-server.exe is and put libmysql.dll in there. After that close the zip file and open up your config file and add this line "plugins sampmysql" without the "".


4. Getting xxamp to setup database.sql
Goto xxamp windows and scroll down tell you see XAMPP Windows 1.6.6a under that click the Installer. After you install that open up your internet browser and goto http://localhost then click the page that says PhpMyAdmin, After that loads where is says Create new database create a new database called modern, after it reloads over on the left you should see
Код:
cdcol (1)
 
information_schema (17)
 
modern (0)
 
mysql (23)
 
phpmyadmin (8)
 
test (0)
 
webauth (1)
Click Modern after you click that database up at the top you should see
Код:
Structure
 SQL
 Search
 Query
 Export
 Import
 Designer
 Operations
 Privileges
 Drop
click import after that it shows Location Of The Text File click browse then find your server folder then in there click the file database.sql and click upload. Now you can exit that and open up your server file and goto gamemodes mtrp-final open the pwn file and where it show
s
Код:
define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "whateveritsays"

replace that with


#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DB "modern"
Now Compile it and run your server it should work if you have any problems pm me.


Re: [TUT]Installing And Running Modertopia - Imran - 01.06.2008

You know what you are the @@BEST@@


Re: [TUT]Installing And Running Modertopia - jat1801 - 01.06.2008

Quote:
Originally Posted by Imran
You know what you are the @@BEST@@
Thanks im just willing to help if you need any help P.M. ME


Re: [TUT]Installing And Running Modertopia - xClumx - 01.06.2008

Why did you make this?

This shoudl be in the moderntopia topic for starters.


Re: [TUT]Installing And Running Modertopia - jat1801 - 01.06.2008

i made it for people who dont know how to work it


Re: [TUT]Installing And Running Modertopia - darkmaster56 - 07.07.2008

Im using a db from a free web hosting 260mb.com and i wanna use their db but in the conection it fails, i put the Host, User, Pass and DB name that they provide me but i have this error

Код:
[04:05]  Moderntopia: Los Santos
[04:05] _____________________________
[04:05] By Moderntopia Scripting Team 
[04:05] 
[04:05] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[04:05] MYSQL: Attempting to connect to server...
[04:05] 
Connection to MySQL database: Failed !
[04:05] Can't connect to MySQL server on 'sql201.260mb.com' (10060)
[04:05] Error in mysql_select_db: MySQL server has gone away
[04:05] MYSQL: Connection error, retrying...
[04:05]
how can i solve this?


Re: [TUT]Installing And Running Modertopia - agusfn20 - 31.08.2008

help please why happen this?




Re: [TUT]Installing And Running Modertopia - server_making - 31.08.2008

1. You forget inc. file
2. i got this
Код:
----------
Loaded log file: "server_log.txt".
----------

SA:MP Dedicated Server
----------------------
v0.2.2, ©2005-2007 SA:MP Team

[07:31] 
[07:31] Server Plugins
[07:31] --------------
[07:31] Loading plugin: samp-mysql
[07:31]  Failed.
[07:31] Loaded 0 plugins.

[07:31] 
[07:31] Filter Scripts
[07:31] ---------------
[07:31]  Loading filter script 'adminspec.amx'...
[07:31]  Loading filter script 'vactions.amx'...
[07:31]  Loaded 2 filter scripts.

[07:31] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
[07:32] --- Server Shutting Down.



Re: [TUT]Installing And Running Modertopia - lsrp - 31.08.2008

Quote:
Originally Posted by Parky
1. You forget inc. file
2. i got this
Код:
----------
Loaded log file: "server_log.txt".
----------

SA:MP Dedicated Server
----------------------
v0.2.2, ©2005-2007 SA:MP Team

[07:31] 
[07:31] Server Plugins
[07:31] --------------
[07:31] Loading plugin: samp-mysql
[07:31] Failed.
[07:31] Loaded 0 plugins.

[07:31] 
[07:31] Filter Scripts
[07:31] ---------------
[07:31] Loading filter script 'adminspec.amx'...
[07:31] Loading filter script 'vactions.amx'...
[07:31] Loaded 2 filter scripts.

[07:31] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
[07:32] --- Server Shutting Down.
so you didnt done something ^_^


Re: [TUT]Installing And Running Modertopia - server_making - 31.08.2008

Quote:
Originally Posted by lsrp
Quote:
Originally Posted by Parky
1. You forget inc. file
2. i got this
Код:
----------
Loaded log file: "server_log.txt".
----------

SA:MP Dedicated Server
----------------------
v0.2.2, ©2005-2007 SA:MP Team

[07:31] 
[07:31] Server Plugins
[07:31] --------------
[07:31] Loading plugin: samp-mysql
[07:31] Failed.
[07:31] Loaded 0 plugins.

[07:31] 
[07:31] Filter Scripts
[07:31] ---------------
[07:31] Loading filter script 'adminspec.amx'...
[07:31] Loading filter script 'vactions.amx'...
[07:31] Loaded 2 filter scripts.

[07:31] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
[07:32] --- Server Shutting Down.
so you didnt done something ^_^
nvm
now it works


Re: [TUT]Installing And Running Modertopia - luma - 11.11.2008

I don't have the libmysql.dll

where i can find this?


Re: [TUT]Installing And Running Modertopia - Extremo - 11.11.2008

in the plugin developement forum at the mysql plugin topic.


Re: [TUT]Installing And Running Modertopia - zanakinz - 17.01.2009

It keeps repeating that it sucessfully has connected to mysql


Re: [TUT]Installing And Running Modertopia - Extrak - 07.02.2009

Hey mates

well, for me, http://localhost dont work

can you help me anyhow?

thanks, extrak.


Re: [TUT]Installing And Running Modertopia - Masj - 07.02.2009

use 127.0.0.1 or simple "localhost"


Re: [TUT]Installing And Running Modertopia - douglas_dgs - 24.02.2009

NICE


Re: [TUT]Installing And Running Modertopia - Landon - 26.02.2009

I get this when i try to compile him

Code:
 C:\Documents and Settings\invisible\Bureaublad\Godfather\gamemodes\mtrp-final.pwn(36153) : error 004: function "NameTimer" is not implemented
C:\Documents and Settings\BekkersP\invisible\Godfather\gamemodes\mtrp-final.pwn(39599) : warning 203: symbol is never used: "GetPointDistanceToPointExMorph"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.



Re: [TUT]Installing And Running Modertopia - Aoi_Rikuto - 24.03.2009

What do you mean to go to localhost? It won't work!


Re: [TUT]Installing And Running Modertopia - Ryhanna - 24.03.2009

Nice Tutorial. It's very usefull for people who don't know anything about MySQL and that stuff...


Re: [TUT]Installing And Running Modertopia - Mikep - 24.03.2009

Quote:
Originally Posted by Aoi_Rikuto
What do you mean to go to localhost? It won't work!
Run your samp-server.exe and join 127.0.0.1:PORT