Hi, how i can add Homepay to ZNOTE SMS shop ?
What i must write in config.php ;> Please help me ;D ++
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:
if anyone else tries to connect to the website it just says 'This webpage is not available'
[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>
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...
i go a problem with !shop command this error appear when i execute comand
I use The OTX Server Version: (2.51 - SE - 1549)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>
Znote AAC don't use that column. :SA Database Error Occurred
Error Number: 1054
Unknown column 'nickname' in 'where clause'
SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Boogie'
any help?
when Znote aac 1.5?
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.
// 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>';
<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>
// 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>';
}
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
}
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.
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?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?
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