I am using this great plugin called participant database but I want all my signed up users to become wordPress’ users as well to give them more power and to log their activities on the site. So I decided to use a trigger in my database that would fire every time a [participants Database] user signs up. the problem is that the trigger doesn’t fire and it stops the [participants Database] plugin from displaying thank you messages and to send emails. is there a better way to do this or is my trigger absolutely wrong. bellow is the code. Thanks for replying.:)
CREATE TRIGGER user_insert
AFTER insert ON participants_database FOR EACH ROW
INSERT into wp_users(ID,user_login,user_pass,user_nicename,user_email,user_registered,user_status,display_name)
VALUES (id, CONCAT(new.first_name,’ ‘,new.last_name),new.password,new.email,new.date_recorded,’Subscriber’,CONCAT(new.first_name,’ ‘,new.last_name)
- The topic ‘[Participants Database] make all users WordPress users’ is closed to new replies.