[Tutorial] [TUT]Installing and Running XAMPP ( For mysql servers )
#1

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.
Reply
#2

You know what you are the @@BEST@@
Reply
#3

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
Reply
#4

Why did you make this?

This shoudl be in the moderntopia topic for starters.
Reply
#5

i made it for people who dont know how to work it
Reply
#6

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?
Reply
#7

help please why happen this?

Reply
#8

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.
Reply
#9

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 ^_^
Reply
#10

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
Reply
#11

I don't have the libmysql.dll

where i can find this?
Reply
#12

in the plugin developement forum at the mysql plugin topic.
Reply
#13

It keeps repeating that it sucessfully has connected to mysql
Reply
#14

Hey mates

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

can you help me anyhow?

thanks, extrak.
Reply
#15

use 127.0.0.1 or simple "localhost"
Reply
#16

NICE
Reply
#17

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.
Reply
#18

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

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

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
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)