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

I'm also getting the above issue.

knighters god said:

Is this compatible with tfs 1.1? Because I can't get out of this place.

Click to expand...

Have you copied what was in the box and inserted it in to you PHPMYADMIN SQL?

Tyson12302 said:

Have you copied what was in the box and inserted it in to you PHPMYADMIN SQL?

Click to expand...

I actually fixed it by closing down Skype, VmWare and changing back all ports ^^

Well I'm running a minimal fedora 22 server so the above solution isn't going to work for me xD I imported the schema and everything in the white box and I edited config.php

Failed to connect to MySQL: (2002) Permission denied

I'm thinking this is a permissions error with something in the OS, not in the configuration. I've tried making mysql.mysql the owner of the mysql folder and subfolders, I've tried making a permanent firewalld entry for mysql, http and https, I've tried reinstalling mariadb and reconfiguring it, but nothing seems to be working. Just keeps giving me a permission denied error. If it was related to my connection details, it would say that, but this is a rather different error. Any thoughts @Znote ? running Fedora 22 minimal and operating as root. Using base httpd, not using nginx or another installation for my web server. Using mariadb (mysql-server) and phpmyadmin. I do have full access to phpmyadmin at localip/phpmyadmin but if I go to localip/*.php I just get permission denied.

RazorBlade said:

Failed to connect to MySQL: (2002) Permission denied

I'm thinking this is a permissions error with something in the OS, not in the configuration. I've tried making mysql.mysql the owner of the mysql folder and subfolders, I've tried making a permanent firewalld entry for mysql, http and https, I've tried reinstalling mariadb and reconfiguring it, but nothing seems to be working. Just keeps giving me a permission denied error. If it was related to my connection details, it would say that, but this is a rather different error. Any thoughts @Znote ? running Fedora 22 minimal and operating as root. Using base httpd, not using nginx or another installation for my web server. Using mariadb (mysql-server) and phpmyadmin. I do have full access to phpmyadmin at localip/phpmyadmin but if I go to localip/*.php I just get permission denied.

Click to expand...

Thats an interesting setup. My demo site is running Debian 7 with mysql-server and lighttpd with php5-cgi. Are you using digitalocean? If so then feel free to send me a snapshot of your droplet and I will check it out.

Znote said:

Thats an interesting setup. My demo site is running Debian 7 with mysql-server and lighttpd with php5-cgi. Are you using digitalocean? If so then feel free to send me a snapshot of your droplet and I will check it out.

Click to expand...

I have to be honest, I don't really know what you're talking about xD I've only been using Linux for like a week. Never used it cause I always used Windows. I just installed fedora 22 minimal on a fresh hard drive cause I have like 20 extras lying around, threw it into one of my extra computers, installed httpd, mariadb, phpmyadmin, php, nano, all the stuff listed on the fedora compiling guide on the tfs git, configured phpmyadmin to allow connections from my client computer, compiled tfs and moved all of the files to /home/servername, threw all your AAC files in the document root (/var/www/html) and tried going to my local ip from my client machine, and I get the setup page saying the permission denied thing. I was able to access phpmyadmin and before installing the AAC I had info.php in there to test and I was able to do that. Just contained phpinfo() and it readily displayed all of the info about my install, so I know I have permission to access html/php files in that directory. Seems to only be complaining about the AAC. Not seeing an error log anywhere though. And all the tutorials or solutions I find for 2002 permission errors are a little outdated and half the folders/files people advertise as solutions don't exist in my installation

Anyone know why i get these? everything semse to work

Link didnt seem to work and cant find where to edit my post :O so trying again
https://imgur.com/9PrwLdR

Teabing90 said:

Link didnt seem to work and cant find where to edit my post :O so trying again
https://imgur.com/9PrwLdR

Click to expand...

You are missing the Znote AAC database tables, in config.php try to deliberately write wrong mysql details, visit site and it will generate a schema for you to import into phpmyadmin. Once your done, write correct details and those errors should be fixed.

I have a server and a file server 10.76 7.72 and each has a different database, it is possible to connect the databases or the opening of accounts on the server at the same acc maker?

Hello, Znote. It is very nice. I need just one more thing. How to install captcha?

waqmaz said:

Hello, Znote. It is very nice. I need just one more thing. How to install captcha?

Click to expand...

Put this to true
https://github.com/Znote/ZnoteAAC/blob/master/config.php#L632

I have a question, is it vulnerable to SQL Injection? I do not see any prepared statements.

waqmaz said:

I have a question, is it vulnerable to SQL Injection? I do not see any prepared statements.

Click to expand...

I don't know what vulnerable SQL injections is. But, trust me ZnoteAAC is one of the safest and securest AAC's released on OTLand. So don't be afraid.

SQL injections are attacks on sites, which uses for expample MySQL database. u shoudl use then prepared statements or PDO. there are many attacks type, for example XSS, when u have to use htmlspecialchars etc.

Aight so the website pops up and the server works fine but i cant log in into the website nor click on anything. Is there any solution for that?

I got the following error when I tried copying the text into the SQL on my phpMyAdmin page.

Error
SQL query:

CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

MySQL said:

#1005 - Can't create table 'otserv.znote_guild_wars' (errno: 150) (Details…)

Click to expand...

I simply tried to just remove these lines from the thing but once I got the site up (after editing the config according to the video), all links semt to be broken. I tried going to the localhost/special and click the "database2znoteacc" but I never got any success message there. Only the "converting accounts and characters to work with Znote Acc" - Not the "success..."-part.
I'm following your tutorial at
Okay, the website is up and running. It's interactive and seem to be working fine. (I changed a line and set the TFSVersion to 02 instead of 10 in the config and that seemed to do the trick!)
$config['TFSVersion'] = 'TFS_02';
My current status is that I've deleted the "guild-war-part" (see above) and things are working up until this point. When I clicked the database2znoteacc, I got the same result as above and no success message.
I tried to loggin on the homepage with the loggin credentials for the account I've created (and logged in with in the game client) but it said that the "Username and password combination is wrong.", while when I tried with the "localhost" as account name, it said "Failed to authorize your account, are the details correct, have you registered?"

As for now, I'm dying to get some help since I'm completely stuck :\

Update: Managed to fix everything now. I've been working with the [8.60] The Forgotten Server 0.3.6 (Crying Damson) V8
I ran into some troubles, where I was unable to loggin with the client but could loggin at the webpage. This was solved by changing the $config['TFSVersion'] = 'TFS_02'; to $config['TFSVersion'] = 'TFS_03';

So, everything's working now except that I don't have a map to actually play on right now, since the map in the "[8.60] The forg... " only consist of a mall island.
Help on how to "install" a proper map would be very, very much appreciated and if possible, I'd like to install a replica of the original Tibia map!

I also have one other small issue and that's when a character is created, it's spawn location gets set to something else than where a temple is, so I have to change it's position manually on the phpMyAdmin page every time. Advice on how to change this would also be greatly appreciated!

Wuthow said:

Update: Managed to fix everything now. I've been working with the [8.60] The Forgotten Server 0.3.6 (Crying Damson) V8
I ran into some troubles, where I was unable to loggin with the client but could loggin at the webpage. This was solved by changing the $config['TFSVersion'] = 'TFS_02'; to $config['TFSVersion'] = 'TFS_03';

So, everything's working now except that I don't have a map to actually play on right now, since the map in the "[8.60] The forg... " only consist of a mall island.
Help on how to "install" a proper map would be very, very much appreciated and if possible, I'd like to install a replica of the original Tibia map!

I also have one other small issue and that's when a character is created, it's spawn location gets set to something else than where a temple is, so I have to change it's position manually on the phpMyAdmin page every time. Advice on how to change this would also be greatly appreciated!

Click to expand...

In config.php search for townID.
And then in RME click on CTRL + T Then you can change the pos of the town where they should spawn.

Thank you a lot, Tarek! Unfortunately, I've been opening the SQL files in MS Word 2007, so I don't know what you mean with CTRL + T in this case... and what does the abbrevation RME stand for? ^^;
(Sorry, I'm completely new at this and started yesterday evening)