here is my problem: first time i tryed, i did DROP USER 'pma'@'localhost'; and it didnt work anything else like import db and shit, but this time i didnt do DROP USER 'pma'@'localhost'; and it worked. what can happen if i keep the mysql without doing that?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:
After that you should download a server to start with..
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!
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!
im learning so dont hate pls.
After struggle got tfs to turn on, made config lua, created database, but engine i downloaded didnt come with this sql i have to import. Im using tfs 1.0 for tibia 10.41 could anyone help me?
And it would be much better if screens worked, or person who created this tutorial didnt rely on screens as much because without them its alot guessing and trying to put pieces of other tutorials without screens together so you can figure things out.
