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

Jfrye said:
I am having this same issue. Mine shows up like this
Residence: Missing Town


Town names in config.php are accurate.
Click to expand...

Does anyone have any information on this?

Also, how do I display Achievement points? and display 0 if they have no points?
 
BBlackfur said:
#1005 - Can't create table 'otserv.znote_guild_wars' (errno: 150) (Details...)
Anyone know this error?
Click to expand...
Hey, If you are using 0.4/0.3.7. Remove the table znote_guild_wars in the querey @Znote provide and put this instead.


Code: 
CREATE TABLE `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
   `guild_id` INT NOT NULL,
   `enemy_id` INT NOT NULL,
   `begin` BIGINT NOT NULL DEFAULT 0,
   `end` BIGINT NOT NULL DEFAULT 0,
   `frags` INT UNSIGNED NOT NULL DEFAULT 0,
   `payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
   `enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
   `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`), KEY `status` (`status`),
   KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
   FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
Credits to @Limos
 
I get this error.. have tried to fix it with different solutions, please help me..
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'tfs13'@'localhost' (using password: YES) in C:\xampp\htdocs\engine\database\connect.php on line 278
Failed to connect to MySQL: (1045) Access denied for user 'tfs13'@'localhost' (using password: YES)
 
And when i get the website to work, i get these errors instead
9da75da25aac9ada9e9312a8d278af10
 
There is a problem, we config "Token = false" but its required to log in on accounts, i'm having problems with it

string(183) "SELECT `a`.`secret` AS `secret`, `za`.`secret` AS `znote_secret` FROM `accounts` AS `a` INNER JOIN `znote_accounts` AS `za` ON `a`.`id` = `za`.`account_id` WHERE `a`.`id`='1' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'a.secret' in 'field list'
 
Vittyn said:
There is a problem, we config "Token = false" but its required to log in on accounts, i'm having problems with it

string(183) "SELECT `a`.`secret` AS `secret`, `za`.`secret` AS `znote_secret` FROM `accounts` AS `a` INNER JOIN `znote_accounts` AS `za` ON `a`.`id` = `za`.`account_id` WHERE `a`.`id`='1' LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'a.secret' in 'field list'
Click to expand...
In phpmyadmin, select your database and click on SQL, run this:
Code: 
ALTER TABLE `accounts` ADD `secret` char(16) DEFAULT NULL;
Its a bug in TFS 1.2 that was fixed 3 days after release, and they havent updated the download. :/
 
a1020 said:
Logged in as Admin: SQL queries executed:
Print: - Array
(
[0] => [0.081] SELECT `id`, `name`, `password`, `email`, `premdays` FROM `accounts` WHERE `id` = 134 LIMIT 1;
[1] => [0.081] SELECT `ip`, `created`, `points`, `cooldown`, `flag` FROM `znote_accounts` WHERE `account_id` = 134 LIMIT 1;
[2] => [0.082] SELECT `id`, `player_id` FROM `znote_forum_threads` WHERE `forum_id`='4' AND `closed`='0';
[3] => [0.083] SELECT `id` FROM `players` WHERE `group_id` > '1';
[4] => [0.083] SELECT `id`, `player_id` FROM `znote_forum_posts` WHERE `thread_id`='1';
[5] => [0.083] SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < 2 ORDER BY `experience` DESC LIMIT 5;
[6] => [0.085] SELECT COUNT(`player_id`) AS `value` FROM `players_online`;
[7] => [0.085] SELECT COUNT(`id`) AS `id` from `accounts`;
[8] => [0.085] SELECT `id`, `name`, `group_id` FROM `players` WHERE `level`>='1' AND `account_id`='134';
[9] => [0.085] SELECT `name`, `group_id`, `account_id` FROM `players` WHERE `account_id`='134';
[10] => [0.086] SELECT `type` FROM `accounts` WHERE `id`='134' LIMIT 1;
[11] => [0.086] SELECT `rank_id` FROM `guild_membership` WHERE `player_id`='155' LIMIT 1;
[12] => [0.086] SELECT `id`, `name`, `access`, `closed`, `hidden`, `guild_id` FROM `znote_forum` ORDER BY `name`;
[13] => [0.086] SELECT `id`, `name` FROM `guilds` ORDER BY `name`;
)
froumbs not wroking
Click to expand...

I see no errors there, what is it with forums that does not work?

That list just shows the code used to extract correct data fom the database. It is only visible if you are logged in as an admin, and is used to look for performance issues. All thoose queries loaded in 5ms so no problems here.
 
When i copy all files into my www location all i get is problem loading page? Never had this before with the older version.
 
Cant edit the above post but i get this,

File not found

Firefox can't find the file at http://158.69.12.209/.

Check the file name for capitalisation or other typing errors.
Check to see if the file was moved, renamed or deleted.
 
When i click anywhere, like on Home, or i type in my acc and pass, nothing happens, it loads but then NOTHING :(

when i go to phpMYADMIN i click on Znote players (which has acouple in there and also Account, but the rest have nothing in them, like Znote Forum Znote_Shop, etc etc, PLEASE HELP i edited the config.php in WWW uniform server
 
Swift Magic said:
When i click anywhere, like on Home, or i type in my acc and pass, nothing happens, it loads but then NOTHING :(

when i go to phpMYADMIN i click on Znote players (which has acouple in there and also Account, but the rest have nothing in them, like Znote Forum Znote_Shop, etc etc, PLEASE HELP i edited the config.php in WWW uniform server
Click to expand...

Are you sure there are no SQL error messages?


D_Evans89 said:
will this work for TFS 0.2.13 Client 9.54? I downloaded the znote acc and did all the steps but when I try doing anything it is unresponsive. I also have this under Server Information at the bottom right hand corner

Any Suggestions?
Click to expand...

Set TFS_Version to TFS_02 in config.php


fishie said:
Cant edit the above post but i get this,

File not found

Firefox can't find the file at http://158.69.12.209/.

Check the file name for capitalisation or other typing errors.
Check to see if the file was moved, renamed or deleted.
Click to expand...

That website loads fine for me. :)
 

Similar threads

Joriku
[ZNOTE ACC] Change login method from Username to Email address
Replies
0
Views
493
Joriku
Joriku
alelu541
  • Question
AAC AAC not connecting with my SQL
Replies
1
Views
309
slaw
slaw
elnelson
  • Question
Linux Znote AAC 1.6 not creating account nor character (no info given by website)
Replies
2
Views
490
tomaszek123
tomaszek123
Back
Top