- Joined
- Aug 6, 2007
- Messages
- 1,767
- Reaction score
- 36
Oke we will be working on how to get your Server Mysql or Sqlite working!
Now we will begin and of course u need a server duh we will be using using TheForgottenServer because it rox Download: here
How to Get the Server working on Sqlite:
After you have downloaded the server and unpacked it you can run it on a Sqlite server.
Whats the diference with MySql?
You are able to set your server online without installing Xampp and other program's
SQLite is better than MySQL but SqLite is only good for around 50 Players.
Lets begin!
If you have unpacked your server you now need to change some things.
Open your forgotten Server map and open "Config.lua" with Notepad
(Right button>Open with>Notepad)
http://i76.photobucket.com/albums/j12/mokerxx/notepad.jpg[/URL]
Now you have opened config u need to change the following things:
Change 127.0.0.1 to your own i.p, Find out your own i.p here!
And ofcourse to use Sqlite you need to confige it:
Should be
Now you are able to put your server online and play! and if u dont like somting in game, try to look in config.lua if you are able to change them.
If you want to change players and other things u should use this programe, SQLite Expert Personal download here
But dont forget if you want to change players and htings like that i would advance you to put your server first offline and then use SQLite Expert Personal to open "forgottenserver.s3db"
Server+Mysql Setup:
If you have unpacked your server you now need to change some things.
Open your forgotten Server map and open "Config.lua" with Notepad
(Right button>Open with>Notepad)
http://i76.photobucket.com/albums/j12/mokerxx/notepad.jpg[/URL]
Now you have opened config u need to change the following things:
Change 127.0.0.1 to your own i.p, Find out your own i.p here!
And ofcourse to use Sqlite you need to confige it:
Should be
But dont forget to change this to:
Now u have to download a programe that is able to run MySql, I would advice you to use Xampp, download it here Windows version.
While instalation:
Note while installation it will stop at 27% That's normale just give it time!
After u have installed Xampp you need to do some things,
Click on xampp_start.exe and open Internet Explorer. Go to http://localhost/xampp/xamppsecurity.php ; enter a password for mysql there. Now go to http://localhost/phpmyadmin/ and login with root/<yourpasswordhere> (SAME AS U USED IN CONFIG.LUA). (I am using English language in phpadmin). Below Create new database you see a field. Enter Otserv there and create the database. Now on your left side of the screen, select Otserv in the dropdown menu. In the right part, click on the tab. And inport forgottenserver.sql
Now you have you sql database up and running you should be able to start your server without any problems
Note)
I might forgot some things if i dit please tell it to me!
Yours,
Mokerhamer
Now we will begin and of course u need a server duh we will be using using TheForgottenServer because it rox Download: here
How to Get the Server working on Sqlite:
After you have downloaded the server and unpacked it you can run it on a Sqlite server.
Whats the diference with MySql?
You are able to set your server online without installing Xampp and other program's
SQLite is better than MySQL but SqLite is only good for around 50 Players.
Lets begin!
If you have unpacked your server you now need to change some things.
Open your forgotten Server map and open "Config.lua" with Notepad
(Right button>Open with>Notepad)
Now you have opened config u need to change the following things:
Code:
ip = "127.0.0.1"
And ofcourse to use Sqlite you need to confige it:
Code:
sqlType = ""
Code:
sqlType = "sqlite"
Now you are able to put your server online and play! and if u dont like somting in game, try to look in config.lua if you are able to change them.
If you want to change players and other things u should use this programe, SQLite Expert Personal download here
But dont forget if you want to change players and htings like that i would advance you to put your server first offline and then use SQLite Expert Personal to open "forgottenserver.s3db"
Server+Mysql Setup:
If you have unpacked your server you now need to change some things.
Open your forgotten Server map and open "Config.lua" with Notepad
(Right button>Open with>Notepad)
Now you have opened config u need to change the following things:
Code:
ip = "127.0.0.1"
And ofcourse to use Sqlite you need to confige it:
Code:
sqlType = ""
Code:
sqlType = "mysql"
But dont forget to change this to:
Code:
sqlUser = "root" <---- leave it like this
sqlPass = "" <---- But a password
sqlDatabase = "OTserv" <---- If you want you can change it
Now u have to download a programe that is able to run MySql, I would advice you to use Xampp, download it here Windows version.
While instalation:
Note while installation it will stop at 27% That's normale just give it time!
After u have installed Xampp you need to do some things,
Click on xampp_start.exe and open Internet Explorer. Go to http://localhost/xampp/xamppsecurity.php ; enter a password for mysql there. Now go to http://localhost/phpmyadmin/ and login with root/<yourpasswordhere> (SAME AS U USED IN CONFIG.LUA). (I am using English language in phpadmin). Below Create new database you see a field. Enter Otserv there and create the database. Now on your left side of the screen, select Otserv in the dropdown menu. In the right part, click on the tab. And inport forgottenserver.sql
Now you have you sql database up and running you should be able to start your server without any problems
Note)
I might forgot some things if i dit please tell it to me!
Yours,
Mokerhamer
Last edited: