Error when using OTHire...
In config.php set
$config['client']
to 772and
$config['ServerEngine']
to OTHIRE.Error when using OTHire...
$config['client']
to 772$config['ServerEngine']
to OTHIRE.In config.php set$config['client']
to 772
and$config['ServerEngine']
to OTHIRE.
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
How I do for reinstall all Znote tables of my db?
I had to delete line 206, if not, it gives error. doesn't take the "--". Thank you.Import this:
ZnoteAAC/engine/database/znote_schema.sql at master · Znote/ZnoteAAC
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAACgithub.com
--,FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
guilds
(name
, ownerid
, creationdata
, motd
, checkdata
) VALUES ('Old School', '5', '1588102435', '', '0');"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;
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'tfs13'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 35Introducing Znote AAC: - LIVE DEMO
Latest Znote AAC news: https://twitter.com/ZnoteAAC
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:
You can also watch VIDEO TUTORIAL where you see me install and get everything up working:
- - 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.
- - Edit config.php and modify $config['page_admin_access'] with your admin account name(s).
- - 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/ )
- - Enjoy Znote AAC.
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).
That depends a lot on the use case.What is needed to do for use multiple databases in the same website?
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)
if (gethostbyaddr($_SERVER['REMOTE_ADDR']) !== 'notify.paypal.com') {
exit();
}
Warning: Trying to access array offset on value of type bool in C:\xampp\htdocs\myaccount.php on line 158
$order is returning false from the db query. So it's trying to access an array key of something that is false...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
But if they meet it, it works fine
TFS 0.4
ZnoteAAC/myaccount.php at master · Znote/ZnoteAAC
Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAACgithub.com
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.';
}