• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Smart Ass AAC 2.0.0 and Simple Tutorial.

Is it ... to set it up?

  • Simple

    Votes: 25 69.4%
  • Hard

    Votes: 11 30.6%

  • Total voters
    36
  • Poll closed .

Starmio

Starmio
Joined
Feb 9, 2008
Messages
167
Reaction score
2
Location
...
Made by Pekay

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:
Does this account manager works with tfs 0.3 or is it to old?
:D

Yes it does, I hosted my 8.11 realmap with this acc.
To be honest, It wasn't popular by the players,
the death list doesn't work, guild system and other things.
I recommend the gesior acc, real tibia acc :p
BTW, i didnt like the layout of smart ass anyway, so.


Regards,
Limannen
 
Back
Top