• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

Windows Znote ACC 1,4 Problems

Grochu

New Member
Joined
Aug 10, 2009
Messages
202
Reaction score
2
Hi guys, i got some Znote ACC problems:

I use dwarf layout:
-CLICK!

1. After login in localhost/myaccount.php it shows me:

Code:
string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'online' in 'field list'

2. localhost/onlinelist.php error:

Code:
Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 1180
Nobody is online.

1180 line:

Code:
return mysql_result(mysql_query("SELECT COUNT(`id`) from `players` WHERE `online` = 1;"), 0);

3. localhost/guilds.php error:

Code:
string(128) "SELECT `name`, `level`, `vocation`, `town_id`, `lastlogin`, `online` FROM `players` WHERE `account_id`='1' ORDER BY `level` DESC"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'online' in 'field list'

4. localhost/support.php error:

Code:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\engine\function\users.php on line 140

140 line:

Code:
while ($row = mysql_fetch_assoc($query)) {


Thanx for help!



and my database:

http://pastebin.com/Gxc2i9ta


+znote SQL

Andd sorry because of it (all massage not in one post)

http://otland.net/threads/znote-aac-dwarf-layout.208644/
 
@edit HalfAway, sorry i dont give You all info, lol

TFS version is 1.0, in config is
Code:
$config['TFSVersion'] = 'TFS_02';
. Tested on 0_3 but still same errors. So Znote 1.4 isnt compatible with TFS 1.0?
 
Last edited:
Znote AAC 1.4 is not compatible with TFS 1.0, but Znote AAC 1.5 is!

Znote AAC 1.5 is not polished enough for official otland release yet, and I am also waiting for an official TFS 1.0 release.

But you can grab Znote AAC 1.5_DEV files here: https://github.com/Znote/ZnoteAAC/archive/master.zip
Which supports TFS 1.0.
 
Solution
Back
Top