Yaboihunna
New Member
- Joined
- Mar 27, 2019
- Messages
- 136
- Reaction score
- 3
i need the query to add guild stuff in sql i think
[6:18:15.542] > Trigger: oncreate_guilds does not exist, creating it...
[6:18:15.586] mysql_real_query(): CREATE TRIGGER
[6:18:16.376] > Trigger: ondelete_guilds does not exist, creating it...
[6:18:16.475] mysql_real_query(): CREATE TRIGGER
[6:18:15.542] > Trigger: oncreate_guilds does not exist, creating it...
[6:18:15.586] mysql_real_query(): CREATE TRIGGER
oncreate_guilds
AFTER INSERT ON guilds
FOR EACH ROW BEGIN INSERT INTO guild_ranks
(name
, level
, guild_id
) VALUES ('Leader', 3, NEW.id
); INSERT INTO guild_ranks
(name
, level
, guild_id
) VALUES ('Vice-Leader', 2, NEW.id
); INSERT INTO guild_ranks
(name
, level
, guild_id
) VALUES ('Member', 1, NEW.id
); END; - MYSQL ERROR: Table 'venorewar.guilds' doesn't exist (1146)[6:18:16.376] > Trigger: ondelete_guilds does not exist, creating it...
[6:18:16.475] mysql_real_query(): 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; - MYSQL ERROR: Table 'venorewar.guilds' doesn't exist (1146)