Создаю 2 триггера:
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- DELIMITER |
- CREATE TRIGGER `after_insert_invite_friends_to_chat` AFTER INSERT ON `invite_friends_to_chat`
- FOR EACH ROW BEGIN
- INSERT INTO `messages` (`id_user_from`, `id_user_to`, `message`, `dt`, `is_watch`)
- VALUES (NEW.id_user_who,
- NEW.id_user_whom,
- CONCAT((SELECT `lastname` FROM `users` WHERE `id` = NEW.id_user_who),
- ' ',
- (SELECT `name` FROM `users` WHERE `id` = NEW.id_user_who),
- ' приглашает вас в чат: <a href="room.php?code1=',
- NEW.chat_code,
- '&code2=0">перейти в чат</a>'),
- NOW(), 1);
- END|
- |
- DELIMITER ;
- DELIMITER |
- CREATE TRIGGER `after_delete_invite_friends_to_chat` AFTER DELETE ON `invite_friends_to_chat`
- FOR EACH ROW BEGIN
- DELETE FROM `messages` WHERE `id_user_from` = OLD.id_user_who AND
- `id_user_to` = OLD.id_user_whom AND
- `message` = CONCAT((SELECT `lastname` FROM `users` WHERE `id` = OLD.id_user_who),
- ' ',
- (SELECT `name` FROM `users` WHERE `id` = OLD.id_user_who),
- ' приглашает вас в чат: <a href="room.php?code1=',
- OLD.chat_code,
- '&code2=0">перейти в чат</a>');
- END|
- |
- DELIMITER ;