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

it loads fine with defualt znote its only after i add your layout i get problems
 
Peonso said:
A new mirror: http://www.4shared.com/zip/35kjGErBba/guilcera_layout.html?


Dude, try to download it again from the link above and see if the same error occurs.

Open your characterprofile.php file search for "town_id" and replate each one for "town".
Click to expand...

About the characterview problem i have the same issue.
Changing all towns_id and replacing it for town doenst resolve the problem D:
it is a missig table in the database or something? a query?
 
Using latest Znote Github rev and getting this error:
sMVJYqI.png
 
bump any other ideas for my "Myaccount" problem?
 
Hello! I love your template, but i cannot seem to get the whoisonline to work. I have tried all your php edits in the comments but still nothing, even if i go to localhost/layout/sub/whoisonline.php

It just loads a completly white browser window, no errors, no nothing :/:/
I was just wondering how to fix this or if there is any workaround!
Thanks in advance!
 
Felix Korch said:
Hello! I love your template, but i cannot seem to get the whoisonline to work. I have tried all your php edits in the comments but still nothing, even if i go to localhost/layout/sub/whoisonline.php

It just loads a completly white browser window, no errors, no nothing :/:/
I was just wondering how to fix this or if there is any workaround!
Thanks in advance!
Click to expand...

Show us a screen shot.
 
So i got it working! had to put it in the www folder for it to work, and redirect the links to localhost/whoisonline.php

Now everything is displaying right except the record of the server. It just says OT record of players online: on 1 Jan 1970.
so the srong time and no record at all :/ Im using TFS 1.1 and Znote 1.5
 
Hi @Peonso could u help me pls everything is okay but when i try to find a character get this error
for example bubexel
im using otx 2 wich is based on tfs 0.3-0.4

appears this

string(73) "SELECT `id`, `owner`, `name`, `town_id` FROM `houses` WHERE `owner` = 1 ;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'town_id' in 'field list'
Character Information
Name: Account Manager
Sex: Female
Vocation: No vocation
Level: 1
World: Tibia-Fragmania
Residence: Thais

regards
 
Adding Title Image to your pages:
Open the page .php file and search for this line of code:
Code: 
include 'layout/overall/header.php';
after that add this:
Code: 
?>
<img src="layout/images/titles/t_DESIREDTITLE.png"/><p>
<?php
Remember to change t_DESIREDTITLE.png for your desired image name, you can see the ones available at .../layout/images/titles/
The code should be like this:
Code: 
include 'layout/overall/header.php';
?>
<img src="layout/images/titles/t_DESIREDTITLE.png"/><p>
<?php

Any problem or questions, just ask.[/QUOTE]


i've looking for the page.php and haven't found it
 
Felipe93 said:
Hi @Peonso could u help me pls everything is okay but when i try to find a character get this error
for example bubexel
im using otx 2 wich is based on tfs 0.3-0.4

appears this

string(73) "SELECT `id`, `owner`, `name`, `town_id` FROM `houses` WHERE `owner` = 1 ;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'town_id' in 'field list'
Character Information
Name: Account Manager
Sex: Female
Vocation: No vocation
Level: 1
World: Tibia-Fragmania
Residence: Thais

regards
Click to expand...
Just look for town_id in the script and delete the _id
 
Last edited:
Olddies said:
Just look for town_id in the script and delete the _id
Click to expand...
i did it but i get this :
string(105) "SELECT `name`, `level`, `vocation`, `lastlogin`, `sex`, `group_id`, `town` FROM `players` WHERE `id` = 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'town' in 'field list'

i must add i have no town_id or town file in my sql database
im using otx 2 the same as you
 
Felipe93 said:
Hi @Peonso could u help me pls everything is okay but when i try to find a character get this error
for example bubexel
im using otx 2 wich is based on tfs 0.3-0.4

appears this

string(73) "SELECT `id`, `owner`, `name`, `town_id` FROM `houses` WHERE `owner` = 1 ;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'town_id' in 'field list'
Character Information
Name: Account Manager
Sex: Female
Vocation: No vocation
Level: 1
World: Tibia-Fragmania
Residence: Thais

regards
Click to expand...
@Felipe93 in the script look for houses and in houses look for this
Code: 
$houses = mysql_select_multi("SELECT `id`, `owner`, `name`, `town_id` FROM `houses` WHERE `owner` = $user_id ;");
then you see where it says town_id? delete the _id and u are done
 
Olddies said:
@Felipe93 in the script look for houses and in houses look for this
Code: 
$houses = mysql_select_multi("SELECT `id`, `owner`, `name`, `town_id` FROM `houses` WHERE `owner` = $user_id ;");
then you see where it says town_id? delete the _id and u are done
Click to expand...
yeah bro i did it but i get a similar error
saying Unknown column 'town' in 'field list'

and now doesnt even show the account manager
im getting the same trouble as this guy and never solved :(
https://otland.net/threads/error-with-website.225599/
 
if you fixed it can you share your script to check if it works please?
i liked this layout and this is the only one problem
 
Back
Top