How to make those MTA:SQL Scripts work.

[ThaD4N13L]

Okay so today I am going to show you how to get your MySQL Script to work weather you use Venux or MTA Paradise or a nother gamemode such as vG

First you will need to download XAMMP from:

http://www.apachefriends.org/en/xampp.html

install it and select the MySQL or SQL Feature.

once installed go into your browser and type in localhost then choose a language then click on phpMyAdmin

and you should get a new look click on databases

Create a new database and call it whatever you like I would use mta as mine

when you have done

if you have a script that needs you to import the homserver.sql then click on the database you made and click on import the import the file if you don't have one like the MTA Paradise then

go into your SQL Script and look for the mysql.lua in the MTA paradise and you should see something like this

if you look

local function connect( ) 
    -- retrieve the settings 
    local server = get( "server" ) or "localhost" 
    local user = get( "user" ) or "root" 
    local password = get( "password" ) or "" 
    local db = get( "database" ) or "mta" 
    local port = get( "port" ) or 3306 
    local socket = get( "socket" ) or nil 

if its like that its okay just click on run the server it should say upgrade whitch you do. then you should be able to join the Game.

now you can have MTA paradise

(this tut was for people who kept on asking me how to do the SQL.

[Thelastride]

This doesn't helps

[ThaD4N13L]

Worked for meh.

[12p]

MTA Paradise? Oh cmon, I don't want more noobs to start making EVEN MORE copycat servers

I thought you were with me, now I see I was wrong.

[Thelastride]

MTA Paradise? Oh cmon, I don't want more noobs to start making EVEN MORE copycat servers

I thought you were with me, now I see I was wrong.

Dude there are not even enough roleplay servers, around 10.There are hundreds of servers with race,basemode,freeroam,rpg etc.Why roleplay servers get treated like crap when someone starts a server with released gamemode.Nothing wrong with that.

[Castillo]

Please try not to start a flame war, I don't want to have to trash the topic.

[AeroXbird]

Actually, VenuX uses the Paradise MySQL functions, so the way they work is identical.

[ThaD4N13L]

When I started to try to use MTA Paradise I did not have a clue about XAMMp or phpmyAdmin iswell someone can make great edits of these projects.

[Unknown76]

You don't need xampp to run MTA:Paradise, just if you want to have weather-system which retrieves data from Google Weather. All you need is MySQL which can be downloaded from: http://dev.mysql.com/downloads/mysql/ and Navicat http://www.roportal.ro/download/navicat_lite_796.htm to navigate through database records. Much easier than XAMPP.

[ThaD4N13L]

You don't need xampp to run MTA:Paradise, just if you want to have weather-system which retrieves data from Google Weather. All you need is MySQL which can be downloaded from: http://dev.mysql.com/downloads/mysql/ and Navicat http://www.roportal.ro/download/navicat_lite_796.htm to navigate through database records. Much easier than XAMPP.

ur first link did not work for meh

[Thelastride]

You don't need xampp to run MTA:Paradise, just if you want to have weather-system which retrieves data from Google Weather. All you need is MySQL which can be downloaded from: http://dev.mysql.com/downloads/mysql/ and Navicat http://www.roportal.ro/download/navicat_lite_796.htm to navigate through database records. Much easier than XAMPP.

Xampp is much better and easy to use.

[ThaD4N13L]

Yep

[BriGhtx3]

Quantum thats wrong.

Its easier to use xampp cause you don't have to configurate anything. Youre right Navicat is good for navigating.

[Xeno]

When I type in local host, it says:

Oops! This link appears to be broken. 
Did you mean: localhost.­net 
Additional suggestions: 
Go to localho.­st 
Go to localhost.­com 
Search on Google: 

Also when I do: http://localhost/phpmyadmin/

Oops! This link appears to be broken. 
Suggestions: 
Search on Google: 

[Axel]

You will need WampServer(this is what i use) or XAMMP to oen localhost server...

[ThaD4N13L]

First time I installed XAMMP it took me 3 computer restarts to get the localhost thing to work

[Tricky]

Is more simple with WampServer Program but you should know use it !

[colagutten]

The english is bad so i don't understand everything... when i have made the database... wich file do i have to import?, i imported the mysql.lua file but it says that there is an error, i fixed the error, the file got imported but now the server just shuts down by it self.....

please help me!

[Anderl]

The english is bad so i don't understand everything... when i have made the database... wich file do i have to import?, i imported the mysql.lua file but it says that there is an error, i fixed the error, the file got imported but now the server just shuts down by it self.....

please help me!

You should import the SQL data file not the Lua script.

[colagutten]

But where can i find the SQL data file????

[Baseplate]

Search for it, it should be a file with .sql as extension

[ThaD4N13L]

With MTA Paradise you just update your server with paradise's roleplay files then go into a resource called 'sql' and open the lua file and config the sql db name pass ect pass is normally nothing and username is root and you just start the server and its done!(It adds the database from the lua file to the xammp files.)