Sam
Banned User
They make the leader not in the guild; EVERYTIME. how do i fix
latest version used
latest version used
It does NOT work.
what does that mean? :|
will that fix !createguild?
Please some1 answer, how tu upload that file in the database?
By the way, I updated my server to 8.31, so since I did, skills dont save on new account chars, so If i upload that file u posted it wont make any problem? and If not, please EXPLAIN me how.
Thanks
INSERT INTO `player_skills` VALUES (ID OF PLAYER,0,10,0),(ID OF PLAYER,1,10,0),(ID OF PLAYER,3,10,0),(ID OF PLAYER,4,10,0),(ID OF PLAYER,5,10,0),(ID OF PLAYER,6,10,0)
INSERT INTO `player_skills` VALUES (ID OF PLAYER,0,10,0),(ID OF PLAYER,1,10,0),(ID OF PLAYER,3,10,0),(ID OF PLAYER,4,10,0),(ID OF PLAYER,5,10,0),(ID OF PLAYER,6,10,0)
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 do believe its this:
Code: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 ;
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
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|
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|
DELIMITER ;