[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