This is the complete tutorial for you that know nothing about OTs / MYSQL on how to setup a own OT.
First check so you got all necessarily ports open in your router /firewall. Ports: (7171/7172/80)
If you dont know how to open the ports you can use:
PortForward.com - Free Help Setting up Your Router or Firewall
After opening the ports you can check if they are open on:
Open Port Check Tool
After that you need to download xampp:
Here you got all xampp files.
Just download the latest version (installer).
Click in Apache and MYSQL it's absolutely necessarily !
After installing go to:
http://localhost/security/xamppsecurity.php
You can choose to save the password as a text file.
It's good to have a backup if you forget! So I suggest you save it there just in-case!
After choosing you password you need to restart Apache and Mysql.
You can do it two ways:
Go to your xampp folder and press the "Xampp restart".
Or you can use the xampp control panel which might be usefull in the future!
Hit the Stop buttons and then press the Start button which will appear after you have stopped.
After that go to:
http://localhost/phpmyadmin/
Then enter root as user name and your password under it.
After logging in there is one thing you need to do to make your server even more secure..
Do this:
There is many good servers.. but I recommend 0.2.4 which you can get by clicking here.
After downloading the server you will need to download the dll files here.
Once finished with downloading the dll files you will need to extract them into the server. (Only the dll files.. Not the whole map.)
Now you will need to go into the config.lua and change these things:
So.. Go into http://localhost/phpmyadmin/ again and login..
After logged in you can either create a new database or use the "test" database that's already there:
After you created you database you need to import "schema.mysql" or "forgottenserver.sql" depending on what server version you choose.
After that you are done! You got your own server!
[SHORT] How to create a GOD
First you will need to create a character and an account.
After that go to the "accounts" table and find your account and then change the account type to 5 and the group_id to 3.
After that you press "drive".
Then you got the "players" table and find you character and change the group_id to 3 and you can change the name to "GOD <nick>" if you want.
After that you've got a GOD!
Note: Your character has to be offline when you change this.
Feel free to add some reputation if you found this tutorial useful!
First check so you got all necessarily ports open in your router /firewall. Ports: (7171/7172/80)
If you dont know how to open the ports you can use:
PortForward.com - Free Help Setting up Your Router or Firewall
After opening the ports you can check if they are open on:
Open Port Check Tool
After that you need to download xampp:
Here you got all xampp files.
Just download the latest version (installer).
Click in Apache and MYSQL it's absolutely necessarily !
After installing go to:
http://localhost/security/xamppsecurity.php
You can choose to save the password as a text file.
It's good to have a backup if you forget! So I suggest you save it there just in-case!
After choosing you password you need to restart Apache and Mysql.
You can do it two ways:
Go to your xampp folder and press the "Xampp restart".
Or you can use the xampp control panel which might be usefull in the future!
Hit the Stop buttons and then press the Start button which will appear after you have stopped.
After that go to:
http://localhost/phpmyadmin/
Then enter root as user name and your password under it.
After logging in there is one thing you need to do to make your server even more secure..
Do this:
After that you should download a server to start with..DROP USER 'pma'@'localhost';
There is many good servers.. but I recommend 0.2.4 which you can get by clicking here.
After downloading the server you will need to download the dll files here.
Once finished with downloading the dll files you will need to extract them into the server. (Only the dll files.. Not the whole map.)
Now you will need to go into the config.lua and change these things:
When you are done changing those things then you need to create a database!-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "" <- your password
mysqlDatabase = "" <- name of your database (will come to that later)
mysqlPort = 3306
and the sql connection should be like this if you are using MYSQL.
-- SQL
sqlType = "mysql"
passwordType = "plain"
So.. Go into http://localhost/phpmyadmin/ again and login..
After logged in you can either create a new database or use the "test" database that's already there:
After you created you database you need to import "schema.mysql" or "forgottenserver.sql" depending on what server version you choose.
After that you are done! You got your own server!
[SHORT] How to create a GOD
First you will need to create a character and an account.
After that go to the "accounts" table and find your account and then change the account type to 5 and the group_id to 3.
After that you press "drive".
Then you got the "players" table and find you character and change the group_id to 3 and you can change the name to "GOD <nick>" if you want.
After that you've got a GOD!
Note: Your character has to be offline when you change this.
Feel free to add some reputation if you found this tutorial useful!
Last edited: