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

Hi, how i can add Homepay to ZNOTE SMS shop ?

What i must write in config.php ;> Please help me ;D ++
 
Dolololo said:
hi, I followed your tutorial and everything seemed to go well. I can put the server online and have people connect to it, however when I attempt to connect to the AAC using the domain name I linked to my IP, it gives me the following error:

vfq8.jpg


if anyone else tries to connect to the website it just says 'This webpage is not available'
Click to expand...

192.168.1.1 is wrong IP, that is the local IP to your gateway (router).
 
A Database Error Occurred
Error Number: 1054

Unknown column 'nickname' in 'where clause'

SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Boogie'

any help?
 
i go a problem with !shop command this error appear when i execute comand
Code: 
[24/7/2013 17:36:36] [Error - TalkAction Interface] 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:onSay
[24/7/2013 17:36:36] Description: 
[24/7/2013 17:36:36] (LuaInterface::luaGetItemWeight) Item not found

[24/7/2013 17:36:36] [Error - TalkAction Interface] 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:onSay
[24/7/2013 17:36:36] Description: 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:27: attempt to compare boolean with number
[24/7/2013 17:36:36] stack traceback:
[24/7/2013 17:36:36] 	data/talkactions/scripts/znoteshop.lua:27: in function <data/talkactions/scripts/znoteshop.lua:2>
I use The OTX Server Version: (2.51 - SE - 1549)
 
Hello, after create an account its shows this message:

My account

Welcome to your account page, teste
Character List: 0 characters.
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'

And when i try to add a new character it shows this message:
Create Character
1INSERT ERROR: Unknown column 'rank_id' in 'field list'

- - - Updated - - -

I fix this just add the coluns alter table players add bla bla bla...
 
dgprado said:
Hello, after create an account its shows this message:

My account

Welcome to your account page, teste
Character List: 0 characters.
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'

And when i try to add a new character it shows this message:
Create Character
1INSERT ERROR: Unknown column 'rank_id' in 'field list'

I fix this just add the coluns alter table players add bla bla bla...
Click to expand...

Looks like a dirty workaround to me. I think you should configure correct TFS version in config.php instead. ^_^

monstruo1 said:
i go a problem with !shop command this error appear when i execute comand
Code: 
[24/7/2013 17:36:36] [Error - TalkAction Interface] 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:onSay
[24/7/2013 17:36:36] Description: 
[24/7/2013 17:36:36] (LuaInterface::luaGetItemWeight) Item not found

[24/7/2013 17:36:36] [Error - TalkAction Interface] 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:onSay
[24/7/2013 17:36:36] Description: 
[24/7/2013 17:36:36] data/talkactions/scripts/znoteshop.lua:27: attempt to compare boolean with number
[24/7/2013 17:36:36] stack traceback:
[24/7/2013 17:36:36] 	data/talkactions/scripts/znoteshop.lua:27: in function <data/talkactions/scripts/znoteshop.lua:2>
I use The OTX Server Version: (2.51 - SE - 1549)
Click to expand...

Try the shop script in the alternative folder znoteaac/LUA/TFS_03/talkaction shopsystem/Alternatives/

wafuboe said:
A Database Error Occurred
Error Number: 1054
Unknown column 'nickname' in 'where clause'
SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Boogie'
any help?
Click to expand...
Znote AAC don't use that column. :S

soba said:
when Znote aac 1.5?
Click to expand...

TODO before 1.5:
  • Main Features:
    • TFS 1.0 compatibility is working properly. [In progress...]
    • Cast System.
    • Improved error reporting. [In progress...]
  • Wishlist features that may be delayed until later version:
    • Improved house system.
    • Improved guild system.
    • Direct OT communication.
    • Highscore paging.
    • Death and killers show assists.
 
Last edited:
Hoy Znote,

First of all, great work! But I've a problem with this AAC, hehe. When I'm trying to create a board on the forum I get this error:

string(139) "INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Test', '1', '', '', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Incorrect integer value: '' for column 'closed' at row 1

The table znote_forum and the columns closed and hidden are tinyints, so should not 0 or 1 be inserted here instead of an empty char/string?

But it must be me doing something wrong, else alot of others would have the same problem. So, how to solve this? :)

Using TFS 0.3.7 and it's set in config.php.
 
Blixmo said:
Hoy Znote,

First of all, great work! But I've a problem with this AAC, hehe. When I'm trying to create a board on the forum I get this error:

string(139) "INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Test', '1', '', '', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Incorrect integer value: '' for column 'closed' at row 1

The table znote_forum and the columns closed and hidden are tinyints, so should not 0 or 1 be inserted here instead of an empty char/string?

But it must be me doing something wrong, else alot of others would have the same problem. So, how to solve this? :)

Using TFS 0.3.7 and it's set in config.php.
Click to expand...

yeah
PHP: 
// Insert data
mysql_insert("INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) 
	VALUES ('$admin_board_create_name', 
		'$admin_board_create_access', 
		'$admin_board_create_closed', 
		'$admin_board_create_hidden', 
		'$admin_board_create_guild_id');");
echo '<h1>Board has been created.</h1>';

It appears to be missing some POST values.
PHP: 
<h2>Create board:</h2>
<form action="" method="post">
	<input type="text" name="admin_board_create_name" placeholder="Board name"><br><br>
	
	Required access: <select name="admin_board_create_access">
		<?php
		foreach($config['ingame_positions'] as $access => $name) {
			echo "<option value='$access'>$name</option>";
		}
		?>
	</select><br><br>

	Board closed: <select name="admin_board_create_closed">
		<option value="0">No</option>
		<option value="1">Yes</option>
	</select><br>
	
	Board hidden: <select name="admin_board_create_hidden">
		<option value="0">No</option>
		<option value="1">Yes</option>
	</select><br><br>

	Guild board: <select name="admin_board_create_guild_id">
		<?php
		foreach($guilds as $guild) {
			if ($guild['id'] == 0) echo "<option value='". $guild['id'] ."' selected>". $guild['name'] ."</option>";
			else echo "<option value='". $guild['id'] ."'>". $guild['name'] ."</option>";
		}
		?>
	</select><br><br>
	
	<input type="submit" value="Create Board" class="btn btn-primary">
</form>

Have you modified forum.php? Since this should work fine by default.
 
Thanks for fast reply.

No, I've not edited my forum.php at all,

PHP: 
	// Create board
	if ($admin_board_create_name !== false) {
		
		// Insert data
		mysql_insert("INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) 
			VALUES ('$admin_board_create_name', 
				'$admin_board_create_access', 
				'$admin_board_create_closed', 
				'$admin_board_create_hidden', 
				'$admin_board_create_guild_id');");
		echo '<h1>Board has been created.</h1>';
	}

and here is the other one:

PHP: 
if ($admin) {
		?>
		<h2>Create board:</h2>
		<form action="" method="post">
			<input type="text" name="admin_board_create_name" placeholder="Board name"><br><br>
			
			Required access: <select name="admin_board_create_access">
				<?php
				foreach($config['ingame_positions'] as $access => $name) {
					echo "<option value='$access'>$name</option>";
				}
				?>
			</select><br><br>

			Board closed: <select name="admin_board_create_closed">
				<option value="0">No</option>
				<option value="1">Yes</option>
			</select>
			
			Board hidden: <select name="admin_board_create_hidden">
				<option value="0">No</option>
				<option value="1">Yes</option>
			</select><br><br>

			Guild board: <select name="admin_board_create_guild_id">
				<?php
				foreach($guilds as $guild) {
					if ($guild['id'] == 0) echo "<option value='". $guild['id'] ."' selected>". $guild['name'] ."</option>";
					else echo "<option value='". $guild['id'] ."'>". $guild['name'] ."</option>";
				}
				?>
			</select><br><br>
			
			<input type="submit" value="Create Board">
		</form>
		<?php
	}
 
ERROR: The database you have specified in config.lua is empty, please import schemas/<engine>.sql to the database.
 
Hey, im at the part of your video tutorial where we edit the IPN.. How do i know my website url to use? only way i know how to access the site is by typing localhost and i know that wont work for everyone :p
 
Znote, 1 question:

When i namelock or punish someone, this info appear to the players on website?
He have the option to change his name?
 
How long we'll have to wait till TFS 1.0 compability? Is that planned?
I saw new database is rebuilt and not compatible with any of these: 0.2.15, 0.3.6, 0.3.7, 0.4
eg. there is no rank_id, online in players, guild_rank is stored in separate table, skills and tries are also stored in players table
 
Blixmo said:
Hoy Znote,

First of all, great work! But I've a problem with this AAC, hehe. When I'm trying to create a board on the forum I get this error:

string(139) "INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES ('Test', '1', '', '', '');"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Incorrect integer value: '' for column 'closed' at row 1

The table znote_forum and the columns closed and hidden are tinyints, so should not 0 or 1 be inserted here instead of an empty char/string?

But it must be me doing something wrong, else alot of others would have the same problem. So, how to solve this? :)

Using TFS 0.3.7 and it's set in config.php.
Click to expand...

Still having this problem... Seems like the <option value="0"> sends an empty string instead of 0. If I set them to 1/yes it sends number 1 but the "Guild option" still sends an empty var/string.

Solving it by hardcode in 0 or 1 in forum.php but it's far from a good solution. Been trying to add selected=selected or selected=yes to the option values aswell, still the same problem.

And I've not modified forum.php at all, wont work with the original file.

Anyone?
 
Blixmo said:
Still having this problem... Seems like the <option value="0"> sends an empty string instead of 0. If I set them to 1/yes it sends number 1 but the "Guild option" still sends an empty var/string.

Solving it by hardcode in 0 or 1 in forum.php but it's far from a good solution. Been trying to add selected=selected or selected=yes to the option values aswell, still the same problem.

And I've not modified forum.php at all, wont work with the original file.

Anyone?
Click to expand...
I will see if I can reproduce this, if I can I will fix it for the next version. Are you using Znote AAC from private svn?


zbizu said:
How long we'll have to wait till TFS 1.0 compability? Is that planned?
I saw new database is rebuilt and not compatible with any of these: 0.2.15, 0.3.6, 0.3.7, 0.4
eg. there is no rank_id, online in players, guild_rank is stored in separate table, skills and tries are also stored in players table
Click to expand...

TFS 1.0 support is currently in progress.
 

Similar threads

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