Latest version of Znote AAC is here:Znote, Mysql is deprecated in php, i suggest to improve to PDO or to Mysqli, specialy if you are updating it.
Thanks a lot too for always give support and update your AAC and, in general, for help this comunity.
¡Cheers up!
when i enter local host it says Failed to connect to MySQL: (1045) Access denied for user 'tfs10'@'localhost' (using password: YES)
- Import the below schema to a TFS database in phpmyadmin:
- Edit config.php with correct mysql connection details.
Yes.Does all this works also with new versions like 10.77 or whatever?
im sorry what do you means with use 127.0.0.1?
where should i write it?
aha thankyou mate <333Instead of localhost.
In config.php, config.lua and on users/priviledges in phpmyadmin for the database. And in your browser to visit the site.
i made it 127.0.0.1 and still getting that erorrInstead of localhost.
In config.php, config.lua and on users/priviledges in phpmyadmin for the database. And in your browser to visit the site.
He is using 0.2.1.x After the release of TFS 1.0 they removed SQlite and Account manager. Hit me up if you need setuping Znoteacc and TFS 1.xHello, so I have been following this guide, noticing a few differences here and there, and now im stuck. First difference: in the config.lua file he change a sqlite to mysql, in my config.lua there isnt even a text saying sqlite. He also changes the password type to sha1 or w.e, that was also something I could not do. I was able to get the server launched anyways. Now I am stuck trying to log in, it is just saying account name or password incorrect. and when I look at my localhost it doesnt look anywhere near the same as his, and I can't seem to find a way to set the acc name/password to what I want it as. another thing I noticed is that in my config.lua he has an account manager setup in his. mine does not have this. I downloaded TFS 1.1 for this. Rather then his version, BTW.
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: Documentation
#1005 - Can't create table 'serv.znote_guild_wars' (errno: 150) (Details…)
...teleporttown.lua:38: attempt to concatenate field '?' (a nil value)
...
Okay so I've been following this tutorial and I successfuly made a website however, I got lil questions.
First,
When I was importing the sql thing to create tables this is what I got after hitting GO:
Code:#1005 - Can't create table 'serv.znote_guild_wars' (errno: 150) (Details…)
Remove the part with znote_guild_warsWhen I import the SQL at 21:32 it gives me this error:
Can someone help me?
CREATE TABLE `guild_wars` (
`id` INT NOT NULL AUTO_INCREMENT,
`guild_id` INT NOT NULL,
`enemy_id` INT NOT NULL,
`begin` BIGINT NOT NULL DEFAULT 0,
`end` BIGINT NOT NULL DEFAULT 0,
`frags` INT UNSIGNED NOT NULL DEFAULT 0,
`payment` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`guild_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0,
`status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id`), KEY `status` (`status`),
KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`),
FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB;
Thank youRemove the part with znote_guild_wars
And add this
Code:CREATE TABLE `guild_wars` ( `id` INT NOT NULL AUTO_INCREMENT, `guild_id` INT NOT NULL, `enemy_id` INT NOT NULL, `begin` BIGINT NOT NULL DEFAULT 0, `end` BIGINT NOT NULL DEFAULT 0, `frags` INT UNSIGNED NOT NULL DEFAULT 0, `payment` BIGINT UNSIGNED NOT NULL DEFAULT 0, `guild_kills` INT UNSIGNED NOT NULL DEFAULT 0, `enemy_kills` INT UNSIGNED NOT NULL DEFAULT 0, `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `guild_id` (`guild_id`), KEY `enemy_id` (`enemy_id`), FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE, FOREIGN KEY (`enemy_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE ) ENGINE=InnoDB;