With the help of a friend I manage to upload a querry (that I was intending to post it for others to use) that when a new user ID is created (a new registered user) some data will be inserted in another table that will subscribe that user to a newsletter (php list integrated with vb with another script).
Querry is:
Unfortunately that has crashed registration of new users from forum ( I receive a DB error, not a specific one, just serious database problem).
If someone can contribute it would be appreciated. At least where too look.
In order for this to work you would need phplist installed in same database and a bridge script (unfortunately not available anymore).
Querry is:
Code:
DELIMITER $$ CREATE TRIGGER adaugareAutomata BEFORE INSERT ON `vbuser` FOR EACH ROW BEGIN INSERT INTO phplist_listuser(userid,listid,entered,modified) VALUES(NEW.userid,1,now(),now()); INSERT INTO phplist_listuser(userid,listid,entered,modified) VALUES(NEW.userid,2,now(),now()); END $$ DELIMITER ;
If someone can contribute it would be appreciated. At least where too look.
In order for this to work you would need phplist installed in same database and a bridge script (unfortunately not available anymore).
Comment