Problema quando morre

Postado Agosto 21, 2015 9 anos

Galera estou com um erro muito ruim e o seguinte tenho um server de wodbo mais tou com um serio problema o char quando morre volta pro lvl 1 pode estar qualquer level ele volta pro 1 como resolvo isso !!! agradeço desde ja quem ajudar !!!!

Citar

Mention

Postado Agosto 21, 2015 9 anos

executa isso no sql

DROP TRIGGER IF EXISTS `oncreate_players`;

DELIMITER //

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 ;

DROP TRIGGER IF EXISTS `ondelete_players`;

DELIMITER //

CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`

FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END

//

DELIMITER ;