Znote AAC 1.4 - [TFS 0.2.13+] & [TFS 0.3.6+/0.4]

Rowhan1337 · Feb 12, 2015

forgee said:
You need to forward port 80 on your router to the computer running the webserver.

Oh it was that easy, had been boggling my mind for days, thanks alot!

popoverde · Feb 12, 2015

i port fowared 80, but i dont know what ip give to ppl so they can acess to my website, im using that noip thing

when i try to acess to my noip it shows my router panel lol,

forgee · Feb 12, 2015

popoverde said:
i port fowared 80, but i dont know what ip give to ppl so they can acess to my website, im using that noip thing

when i try to acess to my noip it shows my router panel lol,

Sounds like either your router is running a remote admin interface on port 80 or you forwarded port 80 to the router's IP address. There is usually a setting on the router to disable the public admin interface or move it to a different port. On my D-Link it's called remote management.
If you need further assistance you should create a thread on the support board. Make sure you read the rules and provide any relevant information about your setup.

Shoshooo · Feb 15, 2015

please any one help me i have this errors
1
string(208) "SELECT `d`.`level`, `p`.`name` AS `victim`, `d`.`time`, `d`.`is_player`, `d`.`killed_by` FROM `player_deaths` AS `d` INNER JOIN `players` AS `p` ON `d`.`player_id` = `p`.`id` ORDER BY `time` DESC LIMIT 0, 30
2
string(90) "SELECT id,subject,creation,status FROM znote_tickets WHERE owner=29 ORDER BY creation DESC"
(query - SQL error
3
string(159) "SELECT `killed_by`, COUNT(`killed_by`) AS `kills` FROM `player_deaths` WHERE `is_player`='1' GROUP BY `killed_by` ORDER BY COUNT(`killed_by`) DESC LIMIT 0, 10;"
(query - SQL error)
4
FAILED TO LOCATE/READ FILE AT:
C:\test\Mystic Spirit_0.2.5\data\world\forgotten-house.xml
5
string(46) "SELECT `type` FROM `accounts` WHERE `id` ='2';"
(query - SQL error)
please help me

Kasaye · Feb 19, 2015

Hello everyone!
I have weird problem, i have installed znote on windows and everything works fine but on linux i see only blank page i have included sql tables to the database and nothing... Website files are placed in var/www/html and tried for test var/www/html/acc but no luck but for example testphp.php file works ok so its something with znote or my apache config? Any ideas?

Greetings

Kasaye · Feb 19, 2015

PHP Parse error: syntax error, unexpected 'sqlUser' (T_STRING) in /var/www/html/acc/config.php on line 23

line 23: $config['sqlUser'] = 'root';

What's wrong?!

tfs 0.3.7 8.6
Ubuntu 14.04 64bit
Znote 1.5

Purple Cow · Feb 24, 2015

Kasaye said:
PHP Parse error: syntax error, unexpected 'sqlUser' (T_STRING) in /var/www/html/acc/config.php on line 23

line 23: $config['sqlUser'] = 'root';

What's wrong?!

tfs 0.3.7 8.6
Ubuntu 14.04 64bit
Znote 1.5

User "root" exists in your db? Check it.

Someone knows how to limit the number of highscores that are shown?

forgee · Feb 24, 2015

Purple Cow said:
Someone knows how to limit the number of highscores that are shown?

I think this is what you're looking for?
https://github.com/Znote/ZnoteAAC/blob/master/config.php#L414-L418

Purple Cow · Feb 25, 2015

forgee said:
I think this is what you're looking for?
https://github.com/Znote/ZnoteAAC/blob/master/config.php#L414-L418

Not really.. The version of the Znote ACC that I have it does not support that code in the config.lua. But after some time exploring the folders I found what I was looking for. For those who maybe are searching for the same thing, it is in engine/function/users.php. In there you will find the following code:

Code:

// Returns an array containing up to 30 best players in terms of (selected skillid). Returns player ID and skill value.
function highscore_skills($skillid) {
    $skillid = (int)$skillid;
    $query = mysql_query("SELECT `player_id`, `value` FROM `player_skills` WHERE `skillid`='$skillid' ORDER BY `value` DESC LIMIT 0, 30");
    while ($row = mysql_fetch_assoc($query)) {
        if ($skillid == 6 || $skillid == 5) {// If skillid is fish fighting, lets display vocation name instead of id.
            $row['vocation'] = vocation_id_to_name(mysql_result(mysql_query("SELECT `vocation` FROM `players` WHERE `id` = '". $row['player_id'] ."';"), 0));
        }
        $row['group_id'] = mysql_result(mysql_query("SELECT `group_id` FROM `players` WHERE `id` = '". $row['player_id'] ."';"), 0);
        $row['name'] = mysql_result(mysql_query("SELECT `name` FROM `players` WHERE `id` = '". $row['player_id'] ."';"), 0);
        unset($row['player_id']);
        $array[] = $row;
    }
    if (isset($array)) {return $array; } else {return false;}
}

You must change the number 30 for the number length of your desire list.

Kasaye · Feb 25, 2015

Purple Cow said:
User "root" exists in your db? Check it.

Ofcourse i have. I have enabled error log, dig a little and discovered that to run znote on lamp you need curl php to be installed. Without it you'll have many weird errors. So i solved my problem but thanks for help

.

Greetings

Purple Cow · Feb 25, 2015

Kasaye said:
Ofcourse i have. I have enabled error log, dig a little and discovered that to run znote on lamp you need curl php to be installed. Without it you'll have many weird errors. So i solved my problem but thanks for help .

Greetings

It was a wierd error. Good to know you solved it.

7804364 · Feb 27, 2015

im getting
Failed to connect to MySQL: (2002) Connection refused

On Debian 7
Im able to connect remotely ip/phpmyadmin
user/pass is 100% and why im getting it?

Nhtoegyn · Feb 28, 2015

Any compatible TFS 1.0? 1.1?

dominique120 · Feb 28, 2015

Nhtoegyn said:
Any compatible TFS 1.0? 1.1?

https://github.com/Znote/ZnoteAAC

Damon · Feb 28, 2015

I do have a strange Problem here. I installed everything and ZnoteAAC is up, however I cannot login with my created account. However it is definitly created as it exists in phpmyadmin but when i try to login it says wrong username/pw combination.

Damon · Mar 1, 2015

I know that I suck as a scripter, however I still want to make a contribution to this nice AAC

When I installed it recently I noticed, that the Clients download site in config.php doesn't work anymore.
In order to make this work again you have to search for "client" in config.php (should be around line 465/466) and replace the download link for the clients with this code:

PHP:

$config['client_download'] = 'http://clients.************/windows.php?tibia='. $config['client'] .'';
    $config['client_download_linux'] = 'http://clients.************/linux.php?tibia='. $config['client'] .'';

Thanks to @HalfAway for providing us with the clients

lekods · Mar 5, 2015

Znote have function to return uptime server?

7804364 · Mar 7, 2015

When i use the Tfs_10 in config, it laggs my webhost like a mother, and 02 and 03 works fine..

7804364 · Mar 9, 2015

After people donate they do not get there points some poeple say there was an error, but i do get their paypal donation, but they do not get their points. i need to give them it manually

HalfAway · Mar 9, 2015

7804364 said:
After people donate they do not get there points some poeple say there was an error, but i do get their paypal donation, but they do not get their points. i need to give them it manually

You need phpcURL enabled.
Check the database table incase you have any errors.

Znote AAC 1.4 - [TFS 0.2.13+] & [TFS 0.3.6+/0.4]

New Member

Intermediate OT User

Veteran OT User

New Member

New Member

New Member

Well-Known Member

Veteran OT User

Well-Known Member

New Member

Well-Known Member

Member

New Member

Science & Reason

Check my status to contact me :)

Check my status to contact me :)

New Member

Member

Member

Thanatos

Similar threads