znote / znoteaac Goto Github PK

When I choose for example 'Sword' from the highscore list on the right menu it will still show me 'Ranking for Experience' when I click on 'Fetch scoreboard'

When I try to recover my password or account name it just gives me the message "That character name does not exist.".

Had en error trying to use validate_ip() when creating an account from my own host, turns out that getIP() returns ::1

Change validate_ip from

// Checks if an IPv4 address is valid
function validate_ip($ip) {
$ipL = ip2long($ip);
$ipR = long2ip($ipL);

if ($ip === $ipR) {
    return true;
} else {
    return false;
}

}

to

// Checks if an IPv4 address is valid (or host with ipv6)
function validate_ip($ip) {
$ipL = ip2long($ip);
$ipR = long2ip($ipL);

if ($ip === $ipR) {
    return true;
} elseif ($ip=='::1')  {
    return true;
} else {
    return false;
}

}

And at the same time, the getIP() function, why not return $IP, instead of
return $_SERVER['REMOTE_ADDR'];
?

Can add some code to take the item name and post it in the market.php???

Could you add this function?
E.g
"my account" ->
"change character name" -> (15 points) ->
"New name, password" - submit

"you have successfully changed your characters name (x-time until can do it again)
and if its not too much to ask,
would it be possible to show "old character name" on characterview.php Tho, I might be able to figure out that one later.

I was wondering what is the best and right way to add a new menu in ZnoteAAC, lets say VIP or whatever, which files should I look at?

the guild is invited but get a pag error, someone know what is wrong?
is when you invite another guild to a war, but the invite is ok only show that erros link i think someone know how fix or what is wrong?

Warning: Invalid argument supplied for foreach() in C:\xampp2\htdocs\ComodatoSite\guilds.php on line 370
You have invited Art Of Noise to war.

and my file guilds.php

http://pastebin.com/CKFWkDwX

The report system I will refer to in this text can be found here:
http://otland.net/threads/znote-aac-report-bug-system.211072/

It would be very helpful if there was a direct output for the public to see from the moment a submitted report get placed into the "Fixed" report list. This direct output should be displayed as a changelog message on the website so that the people of the server can see their submitted reports actually getting fixed.

The changelogs could be displayed as some sort of news ticker, similar to the official tibia website. I think that it would be suitable to have a /changelog archive page of some sort.

The changelog function should not only be used as a "fixed bugs"-changelog. In my opinion it should also be used to broadcast smaller changes that was made to the server that was not submitted as a bug report.

Skykes own multiple houses:
http://nelvara.com/houses?id=4

I need to restrict one house per account.

Or make epic config:
$config['houseConfig'] = array(
'HouseListDefaultTown' => 1,
'minimumBidSQM' => 200,
'auctionPeriod' => 24 * 60 * 60,
'housesPerAccount' => 1,
'requirePremium' => false,
'levelToBuyHouse' => 8,
);

Also, you can outbid yourself. What should happen instead is to allow you to raise your own pledge without paying previous pledge.

Notice: Undefined index: playerName in C:\xampp2\htdocs\ComodatoSite\admin_reports.php on line 104

Fix partly submitted by CorneX:
http://pastebin.no/34ah

Implement [video]youtube link[/video] BB code.
Some people find it hard to use forum because they forget to select a character before posting something, thus losing their contents. The hard way: save their contents to cache, the easy way: Make sure they always have a character selected. :)

Havent done any further research beside knowing it just don't work so far.

If your character is a tutor it won't show on the highscores.

As the title says:
This house have bidders! If you want this house, now is your chance!
Active bid: 22402gp
Active bid by: Ryukku Ai
Bid will end on: 12 September 2013 (19:56)
You need to login before you can bid on houses.

The clock is now 21:08, still saying its selling and the house ingame still has no owner set.

Notice: Undefined index: compare in C:\xampp2\htdocs\ComodatoSite\market.php on line 6
Marketplace

Warning: Invalid argument supplied for foreach() in C:\xampp2\htdocs\ComodatoSite\market.php on line 61

The function mysql_real_escape_string stops the page to work (at least for me).
I had to comment it out, but I don't know the fix for it :(

function mysql_real_escape_string($escapestr) {
global $connect;
return mysqli_real_escape_string($connect, $escapestr);
}

A delay before your character gets deleted would be nice.

Will it have like gesior charcter skills and life status and items on body????

By using this RSS feeder from otland:
http://otland.net/forums/website-applications.118/index.rss

I am able to fetch recent thread activity from otland website application forum. I can then filter threads by [znote and list them in an admin sub-page. That way it will be easier to see what plugins are offered for Znote AAC.

Since the feeder does not show all threads, but the ones with recent activity. I should create a backend database on znote.eu which will constantly generate and build up this list for me. And make this AAC load the list from there instead of directly from the feeder.

My question is - are blank.php and blanktest.php files still needed? Maybe they could be removed or, at least, one of them.

I have added imagens on gallery and not show, show the "Quest Done" and others images

Why are highscores written as they are?

Would it be possible to write them as in gesior?

(talking about, "fetching skill")

Would be much better if it was something like this:
http://www.tibia.com/community/?subtopic=highscores

Hello Znote,

Maybe some people would like to use nginx like me...

I'm posting a nginx vhost entry for it to work ok?

if (!-f $request_filename){
set $rule_0 1$rule_0;
}
if (!-d $request_filename){
set $rule_0 2$rule_0;
}
if ($rule_0 = "21"){
rewrite ^/(.*)$ /characterprofile.php?name=$1;
}

PS: Copy the ONLY between between the "###'s"

Hope you like :)

The houses page have a rent value, How can I change this value?

As you can see, RME site doesn't offer clients higher than 9.6 version, so I think we should use an alternative site for it, or at least tweak the config file so we can change it easily

Self reminder to fix.

I think that it's an easy fix, and it will look more professional.

Bug on Guild war 1.0 I use
all systems and on try send invitations don't happend nothing just reload website.
i really don't know why I have one guilds.php ninja upload in otland and one functions in engine.
now website works yes but on try send invitations dont happend nothing.
and I have added functions war in users.php
:/

Paypal changed their policy for donations.

http://i.imgur.com/oZDW5Sg.png?1

i think this is the same of market.php error

A normal use case for the marketplace could be to checkout a specific item that you're about to put up for sale on the in-game market. You would do this to get a grip on what the current price is and maybe investigate the history prices.

But what if the item you're looking to put up for sale is not currently being auctioned? Then a search/browse history function would come in handy, right?

Signed into account and go to account management. Click the change gender button on a character, you receive:

string(46) "SELECT online FROM players WHERE id = 1;"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'online' in 'field list'

Reviewing TFS' scheme, it appears online has moved to it's own table called "players_online"

Self remainder to revise the paygol system. paygol ipn contains current + default code and does not work.

When I try to access the ZnoteAAC on the browser of the server machine in which I've installed it, I get the following error:

⛔ Incorrect integer value: " for column 'ip' at row 1

It works when accessed by other computers on the LAN and WAN, just not on the server itself. (I tried changing the "not null" property on the DB hoping it was a problem getting the local IP but it didn't work.)
Is there a way to make the page accessible on the server? Thanks!

Hi,

I just wonder is it possible to add house owner without restart?

TFS: 1.0

Can't recognize TFS version. It has to be either TFS_02 or TFS_03. Correct this in config.php

When i put TFS_10 at config.php

The last commits on this repository is only for people that want use mysqli? or I can update my files with them if use mysql? its compatible? Because I'm getting this error when I try to enter

string(42) "SELECT ip, value FROM znote_visitors"
(query - SQL error)
Type: select_multi (select multiple rows from database)

While the newest stable jQuery library is v2.1.0 Znote by default use v1.4.2(2010 year). This is huge disadvantage in case of using newest HTML5 technologies and modern jQuery code. For example, I get TypeError: undefined is not a function when I use:

$('li > input[placeholder]').on('input', function() { // on this line
// logic
});

Please, consider an update.

It's better not to show staff on ranks

Hello Znote,

Maybe it's because I'm using TFS 1.0~

But the passwords aren't being changed using the website.

Register.php is giving Username is already registred a lot of times.
to fix change user_exist function in engine/functions/users.php to this:

function user_exist($username) {
$username = sanitize($username);
$data = mysql_select_single("SELECT id FROM accounts WHERE name='$username';");
return ($data !== false) ? true : false;
}

This error:
string(43) "SELECT name FROM players WHERE id = ;"
(query - SQL error)
Type: select_single (select single row from database)

Is fixed by:
engine/functions/users.php function fetchAllNews():
Change for ($i = 0; $i < count($data); $i++) {
to
for ($i = 1; $i < count($data); $i++) {

Admin creating a new, when its not created, fixed by:
change all mysql_query to
mysql_update if its an update query
mysql_insert if its an insert query
mysql_delete if its an delete query

It only works well if you are a God, if you are a Gamemaster it keeps showing character on highscores and top players widget.

This is the right sentence in top players widget:
$players = mysql_select_multi('SELECT name, level, experience FROM players WHERE group_id < ' . $config['highscore']['ignoreGroupId'] . ' ORDER BY experience DESC LIMIT 5;');

The problem is the <=, it should be only <

In other places like in engine/function/users.php you have to replace <= with <

https://github.com/Znote/ZnoteAAC/blob/master/special/database2znoteaac.php

It appears to not work correctly on TFS 1.0.
http://otland.net/threads/znote-aac-1-4-tfs-0-2-13-tfs-0-3-6-0-4.166722/page-38#post-2034280

You can set rewards based on the amount of points the player earned in shop, for example:

I buy 1000 ponits, i can unlock a mount as reward.
I buy 5000 points, i can unlock a free outfit...
etc

On put GOD tfs 1.0 use group id 3, not 2...

After last github update when i try go to menus guilds for example i cant click at guildwars or cause when you goes with mouse down to submenu guild wars it go out so fast and you cant click on that, plz fix that :)

You can reproduce that at http://worldofcomodato.servegame.com

Doesnt work aswell

Just some ideas that I have thought of lately :)

(guilds)

1. Guild avatars for guilds
2. Guild MOTD on website + general information such as creation date of the guild
3. Showing one rank only one time.
   Atm it repeats it and it doesn't look very good.

Update; powergamers have been added.
Removed refferal system idea because it really isn't that effective. (tested)
There are lots of better ways to advertise the OT, that refferal system that I suggested wouldn't have been the best one.