• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Database importing help =(

Jamzitox

ImperiUs Online
Joined
May 30, 2008
Messages
245
Reaction score
0
Location
Venezuela/Margarita
Now you can not create new guilds and players it's cleared skills, anyone can help me?

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!
 
Back
Top Bottom