Hey guys, I'm wondering if there's a possibility that when certain keywords are triggered in a user's post, the administrator can automatically reply to the post. The reason for this wild idea is that the "reply2see" plugin has been marked as incompatible by the moderator due to bugs in the latest version. However, I found that it only works when someone replies to a hidden post, then the hidden box will be displayed.
I've tried using MySQL triggers to insert data but MySQL doesn't support triggers to continue inserting data into the same table. Do you have any other suggestions?
# NOT WORK
CREATE TRIGGER `add_reply2see_bot_on_reply` AFTER INSERT ON `posts`
FOR EACH ROW BEGIN
IF NEW.content LIKE '%[reply]%' THEN
INSERT INTO `posts` (`discussion_id`, `number`, `created_at`, `user_id`, `type`, `content`)
VALUES (NEW.discussion_id, NEW.number + 1, NOW(), 1, 'comment', '<t><p>Reply2See Bot</p></t>');
END IF;
END;
