Windows Skills doesn't save

[Xexza]

Hi. I set up the db by importing forgotten.sql. I get errors about triggers. I run the server. Skills doesn't save.
Nope, the server does not create the triggers when starting up.

Please help me.

 

[Migxxx]

You need to import those triggers..... i really wont post the whole information about how/them to import them since i'm tired but you need the triggers, use the search function, i have answered this question few times and have been asked much times on otlandd anyway BB i'm gonna beddddd btw sorry for my bad english but i'm almost falling aslepp :S.....

 

[tompan]

Update your phpmyadmin?

 

[Xexza]

Update your phpmyadmin?

I did that, but then I couldn't access it. It says I don't got permission. And yes, I'm accessing via localhost!

 

[Xexza]

I still need help.

 

[wlj]

Loool if you dont have mutch players resete and use xampp 1.6.6a

 

[Xexza]

Loool if you dont have mutch players resete and use xampp 1.6.6a

Well, the problem is that some of my sites are not compatible with xampp 1.6.6a

I know there is another solution, because I've installed/used triggers several times on this xampp version before.

 

[Evan]

I highly doubt anyone has used any xampp higher than 1.6.6a for phpmyadmin without any problems.

 

[Pyromental]

I highly doubt anyone has used any xampp higher than 1.6.6a for phpmyadmin without any problems.

Yea, even the guilds (on website with Gesior AAC) don't work if you use XAMPP newer than 1.6.6a, due to failure to create this trigger:

DELIMITER |

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END|

DELIMITER ;

I could import all of these triggers successfully while using XAMPP 1.6.6a, even though I didn't update to the newest phpMyAdmin:

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `account` = OLD.`id`;
END|

CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON `guilds`
FOR EACH ROW
BEGIN
    UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
END|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
    DELETE FROM `bans` WHERE `type` = 2 AND `player` = OLD.`id`;
    UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`);
    INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`id`);
END|

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
    INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

DELIMITER ;

 

[Xexza]

Problem solved by downloading another version of phpmyadmin.