In this tutorial I will explain step by step on how to setup an sql server, setup an acc for the server, and how to create a GM character on the server.
Part I Setting up and SQL server
1 - Download a sql server, I recommend
B-fox SQL Server
2 - Download
Xampp
3 - Open your Xampp folder, and run setup_xampp, after your done with that open Xampp control and start Apache and MySql
4 - Type in
http://localhost/security/xamppsecurity.php and change your password.
5 - Type in
http://localhost/phpmyadmin , and log in, create a new database (to make things easier, name it bfox)
6 - Once you have made bfox you will need to goto import a file, import database.sql, located in your server folder, same place as config.lua and the launcher for your ot.
7 - Ok, now the "hard" parts done. Open your B-fox server and open config.lua change the ip in there also change this.
Code:
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "YOURPASSHERE"
mysqlDatabase = "bfox"
mysqlPort = 3306
and
Code:
-- SQL
sqlType = "mysql"
useMD5Passwords = "no"
8 - Open your server and it should work
Part II Setting up an Acc
1 - You will need to choose an acc I high reccomend
Nicaw acc SQL
2 - Now open your Xampp folder again and delete everything in your
htdocs folder and extract nicaw acc SQL into it.
3 - Now enter Config.inc in a txt document, change the neccessary files so it fits your server.
[You can also run xampp, and go on
http://localhost. And your homepage will be displayed, not finished, but a tutorial will pop-up.
Part III Making a GM and make nicaw online acc work properly
1 - Go to
http://localhost/phpmyadmin
2 - Open your bfox database
6 - Once you have made bfox you will need to goto import a file, import database.sql, located in your server folder, same place as config.lua and the launcher for your ot.
3 - Remember when you did this, now login to your bfox database, and import a new file. This new database file is located in Xampp/htdocs. look for a file in htdocs named "database.sql"
4 - Now you will have the full list of queries, if it has launched in this example a total of 27 actions then it has succeed.
In the list to the left side of phpmyadmin, you can enter players, go there ---> show list. Then you can edit the only char with God~name to whatever you want, and change its account number to whatever you want.
Then go in accounts, remember what the GM's old account was, find that old account, rename it the new account you did, and add a password.
And there ya go, you should have a fully functional sql server running.
Hope you enjoyed the tutorial and it helped you out.
This is 90% done by Darkheart from *******,net.[For some reason it has been sensured, lol, so i won't try to abuse the word filter.] Im just editing it to make it easier to configurate with nicaw.
, Well im always worked with a xml cuz its was easy to add any monsters or npc But Now i started to work with a Sql server TFS (newest version)
