ZnoteAAC

What is ZnoteAAC:

What is ZnoteAAC

Znote AAC is a full-fledged website used together with an Open Tibia(OT) server. It aims to be super easy to install and compatible with all the popular OT distributions. It is created in PHP with a simple custom procedural framework.

Optionals:
For email registration verification and account recovery: PHPMailer Version 6.x, extracted and renamed to just "PHPMailer" in Znote AAC directory.
PHP extension curl for PHPMailer, paypal and google reCaptcha services.
PHP extension openssl for google reCaptcha services.
PHP extension gd for guild logos.

Features:
Znote AAC is very rich feature wise, here is an attempt at summarizing what we offer.

General:
Server wide latest death list.
Server wide latest kills list.
Server information with PvP settings, skill rates, experience stages (parses config.lua and stages.xml file).
Spells page with vocation filters (parses spells.xml file).
Item list showing equippable items (parses items.xml file).

Account & login:
Basic account registration
Change password and email
reCaptcha antibot(spam) system
Email verification & lost account interface
Two-factor authentication support
Hide characters from character list
Support helpdesk (tickets)

Create character:
Supports custom vocations, starting skills, available towns.
Character firstitems through provided Lua script.
Soft character deletion.

House:
Houses list with towns filter.
House bidding.
Direct house purchase with shop points.

Character profile:
General information such as name, vocation, level, guild membership etc...
Obtained achievement list.
Player comments.
Death list.
Quest progression.
Character list.
EQ shower, skills, full outfits.

Guilds:
Configurable level and account type restrictions to create guild.
Create and disband guilds.
Invite and revoke players to guild.
Change name of guild positions.
Add nickname to guild members.
Guild forum board accessible only for guild members & admin.
Upload guild image.
Guild description.
Invite, accept and cancel war declarations.
View ongoing guild wars.

Item market:
Want to buy list.
Want to sell list.
Item search.
Compare item offer with other similar offers, as well as transaction history.

Downloads:
Page with download links to client version and IP changer.
Tutorial on how to connect to server.

Achievement system:
List of all achievements and character obtained achievements in their profile.

Highscores:
Vocation & skill type filters.

Buy shop points / digital currency:
PayPal payment gateway.
PayGol (SMS) payment gateway.
PagSeguro payment gateway.

Shop system:
Items.
Premium days.
Change character gender.
Change character name.
Outfits.
Mounts.
Custom offer types. (basic Lua knowledge required).

Forum:
Create custom discussion boards.
Level restriction to post.
Player outfit as avatars.
Player position.
Guildboards.
Feedback board where all threads are only visible for admins.
Hide thread, close thread, stick thread.
Forum search.

Cache system:
Offload SQL load and CPU usage by loading treated data from a flatfile instead of raw SQL queries.

Administration:
Delete character.
Ban character and/or account.
Change password of account.
Give character in-game position.
Give shop points to character.
Teleport a player or all players to home town, specific town or specific position.
Edit level and skills of player.
View in-game bug reports and feedback on forum.
Overview of shop transactions and their status.
Moderate user submitted images to the gallery.
Create news with a feature rich text editor.
Add changelogs.
Load and update server and spells information.
Helpdesk.

Github:

Github

ZnoteAAC

Getting Started:

Linux

Requirements:

PHP Version 7.4 or higher. Mostly tested on 7.4. Most web stacks ships with this as default these days.

Compatible znote_schema.sql for ZnoteAAC:

Download

Installation:

1: Extract the .zip file to your web directory (Example: C:\UniServ\www\ ) Without modifying config.php, enter the website and wait for mysql connection error. This will show you the rest of the instructions as well as the mysql schema.
2: Edit config.php and:
- modify $config['ServerEngine'] with correct version you are running. For Canary / OTServBR-Global use TFS_10.
- modify $config['page_admin_access'] with your admin account username(s).
3: Before inserting correct SQL connection details, visit the website ( http://127.0.0.1/ ), it will generate a mysql schema you should import to your OT servers database.
4: Follow the steps on the website and import the SQL schema for Znote AAC, and edit config.php with correct mysql details.
5: IF you have existing database from active OT server, enter the folder called "special" and convert the database for Znote AAC support ( http://127.0.0.1/special/ )
6: Enjoy Znote AAC.
7: Please note that you need PHP cURL enabled to make Paypal payments work.
8: You may need to change directory access rights of /engine/cache to allow writing.

Windows

Requirements:

PHP Version 7.4 or higher. Mostly tested on 7.4. Most web stacks ships with this as default these days.

Web Package:

Uniform Server (Recommended)

Compatible znote_schema.sql for ZnoteAAC:

Download

Installation:

1: Extract the .zip file to your web directory (Example: C:\UniServ\www\ ) Without modifying config.php, enter the website and wait for mysql connection error. This will show you the rest of the instructions as well as the mysql schema.
2: Edit config.php and:
- modify $config['ServerEngine'] with correct version you are running. For Canary / OTServBR-Global use TFS_10.
- modify $config['page_admin_access'] with your admin account username(s).
3: Before inserting correct SQL connection details, visit the website ( http://127.0.0.1/ ), it will generate a mysql schema you should import to your OT servers database.
4: Follow the steps on the website and import the SQL schema for Znote AAC, and edit config.php with correct mysql details.
5: IF you have existing database from active OT server, enter the folder called "special" and convert the database for Znote AAC support ( http://127.0.0.1/special/ )
6: Enjoy Znote AAC.
7: Please note that you need PHP cURL enabled to make Paypal payments work.
8: You may need to change directory access rights of /engine/cache to allow writing.

Configuration example on config.php

// TFS 1.x = TFS_10 (Current under development version)
$config['ServerEngine'] = 'TFS_10';

// Path to server folder without "\" (or "/") at the end, ex: C:\Canary
$config['server_path'] = 'C:\Canary';

// ------------------------ \\
// MYSQL CONNECTION DETAILS \\
// ------------------------ \\
// phpmyadmin username for OT server: (DONT USE "root" if you are hosting to public).
$config['sqlUser'] = 'root';

// phpmyadmin password for OT server:
$config['sqlPassword'] = 'root';

// The database name to connect to. 
$config['sqlDatabase'] = 'canary';

// Hostname is usually localhost or 127.0.0.1.
$config['sqlHost'] = '127.0.0.1';
// ------------------------ \\
$config['port'] = 7171; // Port number to connect to your OT.
// ------------------------ \\
$config['status'] = array(
    'status_check' => false, // Enable or disable status checker
    'status_ip' => '127.0.0.1',
    'status_port' => "7171",
);

// Gameserver info is used for client 11+ loginWebService
$config['login_web_service'] = true; // loginWebService for client 11+ enabled?
$config['gameserver'] = array(
    'ip' => '127.0.0.1',
    'port' => 7172,
    'name' => 'Canary' // Must be identical to config.lua (OT config file) server name.
);

How to connect with ZnoteAAC:

Canary

Znote Revscriptsys LoginWebService:
Download
Move the znote_login.lua file to the server's data/scripts folder.
The server should automatically load the script.
This script will help ZnoteAAC connect players to the server.

ZnoteAAC

What is ZnoteAAC:

Github:

Getting Started:

Requirements:

Compatible znote_schema.sql for ZnoteAAC:

Installation:

Requirements:

Web Package:

Compatible znote_schema.sql for ZnoteAAC:

Installation:

Configuration example on config.php

How to connect with ZnoteAAC:

Client 13:

OTClient Redemption:

Animated Items and Outfits: