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

rwxsu

Computer Engineer
Joined
Mar 31, 2018
Messages
64
Reaction score
82
Location
Jugoslavija
Hello,
I'm working on your tibiacom layout and have done a lot of fixes to the menu etc.
Link (in progress): rwxsu/tibiacom

Is there a way to use the sub pages as layout files and keep the logic outside of the layout directory?

E.g. layout/sub/settings.php should only contain the form
on POST request: do the validation and database stuff in the root directory's settings.php

Because I'm overriding with subpages action="settings.php" won't work.
 

Hitman94

Excellent OT User
Joined
Feb 9, 2009
Messages
68
Reaction score
9
please help me i use ubuntu 16.04 php 7 apache 2
i use mysql [7.4][OTX] RLMAP 100%, Port Hope 7.4, POI, Demon OaK, War System, Shared Exp ...

I added all the tables as on the film

this tfs 1.2?
Code:
$config['TFSVersion'] = 'TFS_10';
I can not get away with the configuration I'm doing everything as in the movie and as if the site could not connect with the database and nothing works
Znote AAC

and when it changes to
Code:
$config['TFSVersion'] = 'TFS_02';
there are many errors


after reset apache

Code:
2018-07-17T17:48:06.094101Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-17T17:48:06.094175Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-17T17:48:06.269109Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-17T17:48:06.271289Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.22-0ubuntu0.16.04.1) starting as process 309 ...
2018-07-17T17:48:06.276795Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-17T17:48:06.276837Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-17T17:48:06.276844Z 0 [Note] InnoDB: Uses event mutexes
2018-07-17T17:48:06.276852Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-17T17:48:06.276857Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-17T17:48:06.276862Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-17T17:48:06.277172Z 0 [Note] InnoDB: Number of pools: 1
2018-07-17T17:48:06.277317Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-07-17T17:48:06.279648Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-17T17:48:06.289683Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-17T17:48:06.292299Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-17T17:48:06.305172Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-17T17:48:06.339640Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-17T17:48:06.339713Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-17T17:48:06.358049Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-17T17:48:06.359341Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-17T17:48:06.359364Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-17T17:48:06.359728Z 0 [Note] InnoDB: Waiting for purge to start
2018-07-17T17:48:06.409890Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 27483096
2018-07-17T17:48:06.410172Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-17T17:48:06.410300Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-17T17:48:06.411212Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180717 13:48:06
2018-07-17T17:48:06.416293Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-17T17:48:06.416316Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-17T17:48:06.416346Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-17T17:48:06.416373Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-17T17:48:06.424319Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-17T17:48:06.424495Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.22-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-17T17:48:07.098389Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-17T18:09:43.511356Z 31 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:11:57.485395Z 33 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
2018-07-17T18:12:00.277732Z 35 [Note] Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
and I do not know if the error lies on the configuration side /var/www/ whether on the side apache

I am asking for a very good answer because matches have already been done since the morning
I am asking for a reply because I'm struggling with it from the morning

I will add that I had to delete the file .htaccess and if it has anything to do with it?

sorry for english I use the translator
 

mateo8361

Member
Joined
Jun 17, 2017
Messages
43
Reaction score
1
I also have the same problem with AAC.



what tfs version it is?

I can not find an old znote AAC, maybe someone has one for this engine version.
 

OwnerDurk

Member
Joined
May 5, 2014
Messages
51
Reaction score
2
Introducing Znote AAC: - LIVE DEMO
Latest Znote AAC news: Znote AAC (@ZnoteAAC) | Twitter


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

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).
















i am unable to make a new character on website and i need help with setting it up if anyone can help plz message me
 

afferek

New Member
Joined
Oct 16, 2018
Messages
12
Reaction score
0
string(45) "SELECT `id` FROM `accounts` WHERE `name`='1';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'name' in 'where clause'
 

Amiroslo

Support Team
Support Team
Joined
Jul 28, 2009
Messages
6,666
Reaction score
666
Friendly reminder, this project is not dead, it just have no posts on here.
3 commits so far in 2019, 12 accepted pull requests in 2018 (Znote/ZnoteAAC (https://github.com/Znote/ZnoteAAC/commits/master))

Also @Znote decided to have his project up on our Discord ( All new commits will now appear on his #Znote-AAC channel)
Feel free to join the discord here

PS: More information and updates will be posted soon by Znote, stay tuned!
 

Curb

New Member
Joined
Sep 7, 2014
Messages
17
Reaction score
2
Location
San Diego CA
string(51) "SELECT `id` FROM `accounts` WHERE `name`='1234567';"
(query - SQL error)
Type: [B]select_single[/B] (select single row from database)

Unknown column 'name' in 'where clause'


this is happening when I create the first acc :(
 
OP
Znote

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,466
Reaction score
1,156
Location
Norway, Oslo
string(51) "SELECT `id` FROM `accounts` WHERE `name`='1234567';"
(query - SQL error)
Type: [B]select_single[/B] (select single row from database)

Unknown column 'name' in 'where clause'


this is happening when I create the first acc :(
What server distribution are you using?
Try setting $config['ServerEngine'] to OTHIRE in config.php.
 

Curb

New Member
Joined
Sep 7, 2014
Messages
17
Reaction score
2
Location
San Diego CA
Im using TFS 1.2 Nostalrius 7.7
I've tried OTHIRE as well.
Probably doing something wrong right?


// Available options: TFS_02, TFS_03, OTHIRE
// OTHire = OTHIRE
// TFS 0.2 = TFS_02
// TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
// TFS 0.4 = TFS_03
// TFS 1.0 = TFS_10 (Under developement)
$config['ServerEngine'] = 'TFS_10';
// As far as I know, OTX is based on TFS_03, so make sure TFS version is configured TFS_03
$config['CustomVersion'] = false;

$config['site_title'] = 'Znote AAC';
$config['site_title_context'] = 'Because open communities are good communities. :3';
$config['site_url'] = "http://demo.znote.eu";

// Path to server folder without / Example: C:\Users\Alvaro\Documents\GitHub\forgottenserver
$config['server_path'] = '';

// ------------------------ \\
// MYSQL CONNECTION DETAILS \\
// ------------------------ \\

if ($config['ServerEngine'] !== 'OTHIRE') {

 
Last edited:

Curb

New Member
Joined
Sep 7, 2014
Messages
17
Reaction score
2
Location
San Diego CA
Well, I added the Colum 'e-mail' in 'accounts' and looks like it worked.

But now, when I try to create a new account:
"That email address is already in use."

And also can't login to the existing account.
"Failed to authorize your account, are the details correct, have you registered?"


Any ideas?
 
Last edited:
OP
Znote

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,466
Reaction score
1,156
Location
Norway, Oslo
I think I can simulate generic nostalrius support with a combination of configured client version and serverEngine, but right now there are a few issues with it. I might have time to look into it this weekend. Since its based on TFS 1.2 I can guess most of it already works, but there is a few changes in the db due to protocol downgrade which is currently only accomodated for in Znote AAC under engine OTHire.
 

Curb

New Member
Joined
Sep 7, 2014
Messages
17
Reaction score
2
Location
San Diego CA
I think I can simulate generic nostalrius support with a combination of configured client version and serverEngine, but right now there are a few issues with it. I might have time to look into it this weekend. Since its based on TFS 1.2 I can guess most of it already works, but there is a few changes in the db due to protocol downgrade which is currently only accomodated for in Znote AAC under engine OTHire.
I've found the answer here if someone need it:
AAC - Znote (Change "name" to "id") (https://otland.net/threads/znote-change-name-to-id.262497/#post-2538850)

Thanks!! Amazing work bro.
 

Flinkton

New Member
Joined
Jul 30, 2013
Messages
2
Reaction score
1
why u don't use smarty as template manager?

it's really so bad to code new layouts for your aac.
 
OP
Znote

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,466
Reaction score
1,156
Location
Norway, Oslo
why u don't use smarty as template manager?

it's really so bad to code new layouts for your aac.
Smarty implies that PHP code is application logic, and is separated from the presentation. This is an uneccesary added restriction. PHP itself can be used as a templating engine.

A basic Znote AAC layout consists of 3 files. layout/overall/header.php, which is the top half of the document. (above main content body). And layout/overall/footer.php which is everything else.
The third file is a sub.php file you can just pull from the default layout and make the array empty.

After that just fix the links to css/js/menu to pages and your done.

Its pretty easy, but I guess I could document this better.

If you want to do more, you can cut out sections from the files in the overall folder and place them in their own file, and just include them through php in the overall folder. That way you can ensure all files directly accessible when entering the layout folder are relevant pieces of code for your layout. (like a menu.php for menu items, aside.php for the aside bar).

If you want to override a file, you can copy the file you want to override into layout/sub/ folder, etc characterprofile.php. You can then add that file in sub.php and set override to true. Now when someone visits website.com/characterprofile.php, it will actually load the file inside layout/sub/characterprofile.php.

If you want to add additional layout specific pages, you can also add files here, but set override to false. The files will then be available through a "subtopic" url handler similar to Gesior AAC. Etc create a file called "blank.php" in layout/sub/ folder, call it "blank" in layout/sub.php with override set to false, and you can access it using website.com/sub.php?page=blank
 
Last edited:

OscarPaez

God Telania
Joined
Dec 19, 2018
Messages
39
Reaction score
1
i try to make payment paypal and recived cash but didnt recive points :( im trying to player recive coins "tibia coins" can you help me znote
 
OP
Znote

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,466
Reaction score
1,156
Location
Norway, Oslo
i try to make payment paypal and recived cash but didnt recive points :( im trying to player recive coins "tibia coins" can you help me znote
Do you get points in the znote_accounts table? (Etc while in shop.php)?
 

OscarPaez

God Telania
Joined
Dec 19, 2018
Messages
39
Reaction score
1
i didnt take nothing with your script only i put me info paypal and didnt recive points on znote accounts
 
OP
Znote

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,466
Reaction score
1,156
Location
Norway, Oslo
i didnt take nothing with your script only i put me info paypal and didnt recive points on znote accounts
You need to configure IPN notifications in paypal properly.
 

OscarPaez

God Telania
Joined
Dec 19, 2018
Messages
39
Reaction score
1
I think its correct IPN link website but i need to put link ??

'ipn' => "http://".$_SERVER['HTTP_HOST']."/ipn.php",
 
Top