• 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!

Znote AAC 1.4 - [TFS 0.2.13+] & [TFS 0.3.6+/0.4]

In config.php set $config['client'] to 772
and $config['ServerEngine'] to OTHIRE.

Tks, but i get new error:

PHP:
string(1306) "SELECT `p`.`health`, `p`.`healthmax`, `p`.`mana`, `p`.`manamax`, `p`.`cap`, `p`.`experience`, `p`.`level`, 0 AS `p`.`soul`, 0 AS `p`.`stamina`, `p`.`maglevel`, `fist`.`value` AS `skill_fist`, `club`.`value` AS `skill_club`, `sword`.`value` AS `skill_sword`, `axe`.`value` AS `skill_axe`, `dist`.`value` AS `skill_dist`, `shield`.`value` AS `skill_shielding`, `fish`.`value` AS `skill_fishing` FROM `players` AS `p` LEFT JOIN `player_skills` AS `fist` ON `p`.`id` = `fist`.`player_id` AND `fist`.`skillid` = 0 LEFT JOIN `player_skills` AS `club` ON `p`.`id` = `club`.`player_id` AND `club`.`skillid` = 1 LEFT JOIN `player_skills` AS `sword` ON `p`.`id` = `sword`.`player_id` AND `sword`.`skillid` = 2 LEFT JOIN `player_skills` AS `axe` ON `p`.`id` = `axe`.`player_id` AND `axe`.`skillid` = 3 LEFT JOIN `player_skills` AS `dist` ON `p`.`id` = `dist`.`player_id` AND `dist`.`skillid` = 4 LEFT JOIN `player_skills` AS `shield` ON `p`.`id` = `shield`.`player_id` AND `shield`.`skillid` = 5 LEFT JOIN `player_skills` AS `fish` ON `p`.`id` = `fish`.`player_id` AND `fish`.`skillid` = 6 WHERE `p`.`id`= 8 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.`soul`, 0 AS `p`.`stamina`, `p`.`maglevel`, `fist`.`value` AS' at line 6
 
Tks, but i get new error:

PHP:
string(1306) "SELECT `p`.`health`, `p`.`healthmax`, `p`.`mana`, `p`.`manamax`, `p`.`cap`, `p`.`experience`, `p`.`level`, 0 AS `p`.`soul`, 0 AS `p`.`stamina`, `p`.`maglevel`, `fist`.`value` AS `skill_fist`, `club`.`value` AS `skill_club`, `sword`.`value` AS `skill_sword`, `axe`.`value` AS `skill_axe`, `dist`.`value` AS `skill_dist`, `shield`.`value` AS `skill_shielding`, `fish`.`value` AS `skill_fishing` FROM `players` AS `p` LEFT JOIN `player_skills` AS `fist` ON `p`.`id` = `fist`.`player_id` AND `fist`.`skillid` = 0 LEFT JOIN `player_skills` AS `club` ON `p`.`id` = `club`.`player_id` AND `club`.`skillid` = 1 LEFT JOIN `player_skills` AS `sword` ON `p`.`id` = `sword`.`player_id` AND `sword`.`skillid` = 2 LEFT JOIN `player_skills` AS `axe` ON `p`.`id` = `axe`.`player_id` AND `axe`.`skillid` = 3 LEFT JOIN `player_skills` AS `dist` ON `p`.`id` = `dist`.`player_id` AND `dist`.`skillid` = 4 LEFT JOIN `player_skills` AS `shield` ON `p`.`id` = `shield`.`player_id` AND `shield`.`skillid` = 5 LEFT JOIN `player_skills` AS `fish` ON `p`.`id` = `fish`.`player_id` AND `fish`.`skillid` = 6 WHERE `p`.`id`= 8 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.`soul`, 0 AS `p`.`stamina`, `p`.`maglevel`, `fist`.`value` AS' at line 6

Fixed:

Update characterprofile.php with latest version (or patch in those changes in link).
 
Hi guys ;) i have problem when i create guild in my ZnoteAAC is comming like that problem

Guild list is empty.

string(128) "INSERT INTO guilds (name, ownerid, creationdata, motd, checkdata) VALUES ('Old School', '5', '1588102435', '', '0');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Thread stack overrun: 18024 bytes used of a 131072 byte stack, and 160000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

anyone got that problem ? :>
 
can you help me here? AAC - Znote pagseguro problem (https://otland.net/threads/znote-pagseguro-problem.270932/#post-2609992)

also the schema available on /special doesn't come with the pagseguro sqls

SQL:
CREATE TABLE IF NOT EXISTS `znote_pagseguro` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,
                  `transaction` varchar(36) NOT NULL,
                  `account` int(11) NOT NULL,
                  `price` decimal(11,2) NOT NULL,
                  `points` int(11) NOT NULL,
                  `payment_status` tinyint(1) NOT NULL,
                  `completed` tinyint(4) NOT NULL,
                  PRIMARY KEY (`id`),
                  FOREIGN KEY (account) REFERENCES accounts(id)
                ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

                CREATE TABLE IF NOT EXISTS `znote_pagseguro_notifications` (
                  `id` int(11) NOT NULL AUTO_INCREMENT,
                  `notification_code` varchar(40) NOT NULL,
                  `details` text NOT NULL,
                  `receive_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
                  PRIMARY KEY (`id`)
                ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
Last edited:
Introducing Znote AAC: - LIVE DEMO
Latest Znote AAC news: https://twitter.com/ZnoteAAC
iu0Pw6.jpg


Features:
  • - Forum System
    • - Flexible config: required level, cooldownPost, enable/disable guildboards, markup [hidden/closed/sticky].
    • - Create and edit boards. [required access, closed, hidden, guild]
    • - Create and edit threads. [delete, close, stick, edit]
    • - Create tutors board, gamemaster board, god boards etc.
    • - Guild Leaders can create their own guildboard (optional in config.php), only guildmembers got access.(+ GMs)
    • - Guild Leaders got admin access in their own guild board. [delete, close, stick, edit] thread and posts.
    • - Basic BBcode support [bold, image(clickable for fullsize), center, link, text with link assigned, color=anything, list]
    • -
    • - Anonymous feedback system [create threads in feedback section, only threadstarter + GMs can view and reply to threads here]. !+ When GM login he will be notified of numbers of unanswered feedback threads.
  • - Gallery System
    • - Users can submit images to gallery, write title and description.
    • - Admin moderates images through admin_gallery page before they become public.
    • - An OT gallery that is powered by the community!
  • - Cache system that greatly reduces page load. Cache time optional in config.php.
  • - Layout specific sub-page system
    • - Allows any layout to override default views, creating custom view versions tailored for layouts. (etc custom characterprofile.php, highscore.php instead of default one).
    • - (Without touching anything outside its own layout file, great flexibility).
  • - House list, latest deaths, killers.
  • - Optional captcha system when registering account.
  • - Prevention against hackers and bruteforce (etc POST register spam).
  • - Guildwar system (Also integrated with Guilds display).
  • - Guild Management (Create guild, change guild titles, player guild positions, invite, kick etc).
  • - Integrated simple and flexible paypal system.
  • - Integrated simple and flexible shop system.
  • - Database structure that does not alter the original TFS tables at all.
  • - Secure lost account interface that does not require email verification.
  • - LUA scripts for shop system communication for Znote AAC, both TFS 0.2 and 0.3.
  • - Widget system to allow you to add minipages and forms in template. (Like the highscore widget).
  • - Admin Panel which lets you add tutors/GMs, BAN characters, delete characters, reset password to characters, add news, give shop points.
  • - Quick and simple account and character creation.
  • - ALL features fully supported for both TFS 0.2 and 0.3.

Tested and confirmed compatibility with:
  • - TFS 0.2.15 (With war system, TFS 0.2 in config.php)
  • - TFS 0.2.14 (With war system, TFS 0.2 in config.php)
  • - TFS 0.2.13pl1 (With war system, TFS_02 in config.php)
  • - TFS 0.2.14 Mystic Spirit
  • - TFS 0.3.6pl1 Crying damson (Without war system, with TFS_03 in config.php, and config['salt'] = false) (Fixed on Znote AAC 1.2)
  • - TFS 0.3.7_svn_5772 (with war system, with TFS_03 in config.php)
  • - TFS 0.3.7_svn_3777 (with war system, with TFS_03 in config.php)
  • - TFS 0.3.7_svn_3884 (with war system, with TFS_03 in config.php)
  • - TFS 0.3.7_svn_3952 (with war system, with TFS_03 in config.php)

Download version 1.5_dev from Github



Installation instructions:
  1. - Extract the .zip file to your web directory (Example: C:\UniServ\www\ )
  2. - 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.
  3. - Edit config.php and modify $config['page_admin_access'] with your admin account name(s).
  4. - 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/ )
  5. - Enjoy Znote AAC.
You can also watch VIDEO TUTORIAL where you see me install and get everything up working:
VIDEO TUTORIAL: From nothing to a fully working OT server, website and shop system (http://otland.net/f479/video-tutorial-nothing-fully-working-ot-server-website-shop-system-166818/)

Resources:
  • You can find Znote AAC resources/plugins/layouts on THIS LINK.
  • If you want to convert a layout to Znote AAC, wether you want it free or private for a lump of money, I recommend you to contact these persons: @HalfAway, @Tibiamakers. They have done a great job with Znote AAC layouts.

Changelog Znote AAC 1.3 --> 1.4
Code:
Changelog: (More detailed changelog available in premium board, this is a huge update).
* many minor bugs fixed.
* Added status checker, which will actively check if your OT and display if it is actually online or offline.
---(check serverstatus widget on default layout).Credits: Nottinghster
* Custom forum system created, works on both TFS 0.2 and 0.3.
* Added Captcha system which you can enable for people who register.
* Fixed house list for TFS 0.2
* Optimized the default layout
* Support for normal BBcode tags in forum and news, making it alot easier to manage if you are familiar with forums.
* Top 5 players widget to use as reference on how to use cache and DB function.
* Separating admin links to an own widget linkmenu. (instead of mixing them with my account widget).
* Added better database communication functions, mysql _select_multi/single, _update, _insert, _delete
* You can now disable "bonus" column in shop if you want.
* Gallery System: http://www.youtube.com/watch?v=r9pEc7T3cJg&feature=youtu.be
* Killers system added (TFS 0.2 and 0.3)
* Latest Deaths added (TFS 0.2 and 0.3)
* More template flexibility - sub page system
* if /layout/sub/index.php exist, it will load this page instead of default index.php site. (Allows custom news designs etc from custom layouts).
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'tfs13'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 35
Failed to connect to MySQL: (1045) Access denied for user 'tfs13'@'localhost' (using password: YES)
???
TFS 0.4
 
Last edited:
Where does znote store paypal ipn ips? Because i receive a email from paypal with the new ips that should have ipn file
Lua:
66.211.170.66
173.0.81.1
173.0.81.0/24
173.0.81.33
173.0.81.65 (new)
173.0.81.140 (new)
64.4.240.0/21 (new)
64.4.248.0/22 (new)
66.211.168.0/22 (new)
173.0.80.0/20 (new)
91.243.72.0/23 (new)
 
Where does znote store paypal ipn ips? Because i receive a email from paypal with the new ips that should have ipn file
Lua:
66.211.170.66
173.0.81.1
173.0.81.0/24
173.0.81.33
173.0.81.65 (new)
173.0.81.140 (new)
64.4.240.0/21 (new)
64.4.248.0/22 (new)
66.211.168.0/22 (new)
173.0.80.0/20 (new)
91.243.72.0/23 (new)

Znote AAC check it in file ipn.php:
Code:
if (gethostbyaddr($_SERVER['REMOTE_ADDR']) !== 'notify.paypal.com') {
        exit();
    }

Here it checks if IP belong to notify.paypal.com.
 
Not sure how up to date this is. But found a bug/error

When someone tries to change their name and dont meet the requirement, this error show up
Warning: Trying to access array offset on value of type bool in C:\xampp\htdocs\myaccount.php on line 158

image.png


But if they meet it, it works fine
TFS 0.4
 
wtam, ma ktos moze dzialajacego acc makera z shop systemem zeby tylko podmianke zrobic bo 7h dzi walcze i caly czas jakies bledy pod ots 12.65
 
Not sure how up to date this is. But found a bug/error

When someone tries to change their name and dont meet the requirement, this error show up


image.png


But if they meet it, it works fine
TFS 0.4
$order is returning false from the db query. So it's trying to access an array key of something that is false...

Just from a quick glance, best to wrap it in an else:
PHP:
if ($order === false) {
    $errors[] = 'Did not find any name change tickets, buy them in our <a href="shop.php">shop!</a>';
} else {
    // Check if player and account matches
    if ($session_user_id != $order['account_id']) {
        $errors[] = 'Failed to find your order.';
    }
}

if($session_user_id != $accountId){
    $errors[] = 'Failed to sync your account.';
}

Also, not sure why it's checking if $errors is empty, may as well chuck that error in there no matter what...
 
Last edited by a moderator:
Back
Top