Made by Pekay
The features from 1.0 to 2.0 are (as of present):
http://sourceforge.net/projects/otaac/files/otaac/Smart-Aac 2beta/
Simple SQL Tutorial
Made by Darkheart
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 The Forgotten 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 tfs)
6 - Once you have made tfs you will need to goto import a file open your tfs folder>source>forgottenserver.sql
7 - Ok, now the "hard" parts done. Open your tfs folder and open config.lua change the ip in there also change this.
and
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 Smart-Ass download the .rar
2 - Now open your Xampp folder again and delete everything in your htdocs folder and extract smart-ass into it.
3 - Enter your IP into your browser and install smart-ass from there (it will guide you through it)
Part III Making a GM
1 - Go to http://localhost/phpmyadmin
2 - Open your tfs database
3 - Go to accounts, then browse at the top, find your account, then change the account type to 5
4 - Go to players, then browse at the top, find your character, then change the group id to 3.
And there ya go, you should have a fully functional sql server running.
Hope you enjoyed the tutorial and it helped you out.
Question -> answer
What it can support
Smart-Ass aims to provide support for a wide range of servers and database types that OTServers use. Currently the support provided with Smart-Ass is XML and SQL. You may have noticed OTServ has begun to start support for SQLite, Smart-Ass is also working to support it soon.
Is this easy?
Sure! Smart-Ass being as it is the 'Simple AAC' is designed from the ground up with great support from documentation to help right in the setup for you!
Can I use this with Xampp?
Yep, Smart-Ass has been tested on Xampp on Windows and Linux .
Will this work on Linux?
Should do, it has been tested on Debian and Ubuntu systems before, just makke the Smart-Ass directory readable and writable.
The features from 1.0 to 2.0 are (as of present):
* Rewritten 95% of Smart-Ass
* New directory structure
* Updated for the new SQL Database Structure
* Visitor logging
* Site statistics
* New structure for config.php (now conf.php)
* Express is GONE, (for you old Smart-Ass users)
* Voting system
* Image verification
* Rescripted setup (now install) to be more flexible
* AAC itself much more flexible for the configuration by users
* Brand new templates
* Some AJAX
* Frontpage
* News system
* Character search (with house and guild links)
* Feedback system
* Affliates page
* Houses page
* Highscores system
* Information page
* Server Stats system
* Downloads page
* Banned players page
* Commands page
* Rules page
* Configurable frontpage, and other pages
* Modules system (so admins can choose what they want, flexibility)
* Manager now should work 100%
* Installer protection
* Anti-SQL-Injection =)
* News backend
* Logging system
* More security than before
* Admin panel
* Forum/Site image of the server statistics
* WYSIWYG editor
* Reinterfaced AAC Manager
* Player item configuration
* Player town configuration
* Feedback mailer
* Auto generation of acc numbers (if chosen)
* Spells page
* Monsters page
* Videos page
* Gallery page
* Custom pages (like a CMS)
* Configurable frontpage text
* Mass spawn changer
* More!
http://sourceforge.net/projects/otaac/files/otaac/Smart-Aac 2beta/
Simple SQL Tutorial
Made by Darkheart
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 The Forgotten 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 tfs)
6 - Once you have made tfs you will need to goto import a file open your tfs folder>source>forgottenserver.sql
7 - Ok, now the "hard" parts done. Open your tfs folder and open config.lua change the ip in there also change this.
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = "YOURPASSHERE"
mysqlDatabase = "tfs"
mysqlPort = 3306
and
-- 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 Smart-Ass download the .rar
2 - Now open your Xampp folder again and delete everything in your htdocs folder and extract smart-ass into it.
3 - Enter your IP into your browser and install smart-ass from there (it will guide you through it)
Part III Making a GM
1 - Go to http://localhost/phpmyadmin
2 - Open your tfs database
3 - Go to accounts, then browse at the top, find your account, then change the account type to 5
4 - Go to players, then browse at the top, find your character, then change the group id to 3.
And there ya go, you should have a fully functional sql server running.
Hope you enjoyed the tutorial and it helped you out.
Question -> answer
What it can support
Smart-Ass aims to provide support for a wide range of servers and database types that OTServers use. Currently the support provided with Smart-Ass is XML and SQL. You may have noticed OTServ has begun to start support for SQLite, Smart-Ass is also working to support it soon.
Is this easy?
Sure! Smart-Ass being as it is the 'Simple AAC' is designed from the ground up with great support from documentation to help right in the setup for you!
Can I use this with Xampp?
Yep, Smart-Ass has been tested on Xampp on Windows and Linux .
Will this work on Linux?
Should do, it has been tested on Debian and Ubuntu systems before, just makke the Smart-Ass directory readable and writable.
Last edited by a moderator: