Jamzitox
ImperiUs Online
Now you can not create new guilds and players it's cleared skills, anyone can help me?
I'm using 1.7.1 xamp and the console is Mystic Spirit 0.2.9!
Help Please!
Code:
Players Error:
--
-- (Evento) desencadenante `players`
--
DROP TRIGGER IF EXISTS `database`.`oncreate_players`;
DELIMITER //
CREATE TRIGGER `dating`.`oncreate_players` AFTER INSERT ON `database`.`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 ;
DROP TRIGGER IF EXISTS `database`.`ondelete_players`;
DELIMITER //
CREATE TRIGGER `database`.`ondelete_players` BEFORE DELETE ON `database`.`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
//
DELIMITER ;
I'm using 1.7.1 xamp and the console is Mystic Spirit 0.2.9!
Help Please!