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

help me please i cant find the sql znoteacc tables
Old database to Znote AAC compatibility converter:
Converting accounts and characters to work with Znote AAC:

string(41) "SELECT `account_id` FROM `znote_accounts`"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'otserv.znote_accounts' doesn't exist

Help
 
string(106) "SELECT `ip`, `created`, `points`, `cooldown`, `flag` FROM `znote_accounts` WHERE `account_id` = 6 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'cooldown' in 'field list'

help me
 
15:51:37 Restoring D:\ForgottenL Stuff\znote.sql
Running: mysql.exe --defaults-file="c:\users\will\appdata\local\temp\tmpxneswn.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=theforgottenserver < "D:\\ForgottenL Stuff\\znote.sql"
ERROR 1364 (HY000) at line 25: Field 'activekey' doesn't have a default value

Operation failed with exitcode 1
15:51:39 Import of D:\ForgottenL Stuff\znote.sql has finished with 1 errors
when trying to import SQL help?
 
When following the tutorial, I get this error:
dot.gif
# MySQL returned an empty result set (i.e. zero rows).
How do I fix this?
 
please help in characterprofile.php missing town, no set town_id

lols.png

Which town id does it display when you just do this:
PHP:
<?php echo $profile_data['town_id']; ?>

And have you configured that town id in $config['towns']?
I am having this same issue. Mine shows up like this
Residence: Missing Town


Town names in config.php are accurate.
 
string(106) "SELECT `ip`, `created`, `points`, `cooldown`, `flag` FROM `znote_accounts` WHERE `account_id` = 6 LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'cooldown' in 'field list'

help pleas!
 
1string(739) "INSERT INTO `players`(`name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `premend`, `online`, `balance`) VALUES ('Test', '1', '2', '8', '1', '185', '185', '4200', '68', '76', '78', '58', '128', '0', '0', '40', '40', '0', '100', '2', '5', '5', '2', '', '470', '1', '0', '', '1', '0', '0', '0', '', '0', '0', '0', '10', '10', '10', '0', '0', '0');"
(query -SQL error)
Type:voidQuery(voidQuery is used for update, insert or delete from database)

What i have to do ?
 
Good evening ladies and gents. I am unaware if this issue has been raised or not.
Let me start by saying. I have loved ZnoteAAC since you first released it way back when.
I never really got serious about putting a server online for other people to play until lately, and i have run into this issue.

In config.php I added some items to the shop. the shop works perfectly, although i had to add my own talkaction for retrieving items from online purchases, and that works fine as well, but the image server items.znote.eu does not have all items added to that list. no photos show for umbral master items. and possibly other items as well. Is there an updated list i can use?
 
Hello,
I have a question , is it possible and how to make in Znote Acc - Death list - that shows more than 1 killer.?
 
you need enable stages in server:
but we dont want to enable stages. i want a flat rate server! i am having this exact problem. the information should still show up on the website, regardless of wether its stage enabled xp or not.
 
Back
Top