hurrican
02-08-2005, 02:44 PM
Hi everyone,
I am using Amy's unactivated user management cron script, the problem I am having is the emails are being sent out without the activation ID.. here is the MySQL Statement she had suggested for the version it was released for.. Maybe some of the database scheme has changed since then? Any help is appreciated :)
$userArray=$DB_site->query("SELECT username,user.userid,email,adminemail,joindate,act ivationid FROM user LEFT JOIN useractivation ON (user.userid=useractivation.userid) WHERE user.usergroupid=3 AND posts=0");
I am using Amy's unactivated user management cron script, the problem I am having is the emails are being sent out without the activation ID.. here is the MySQL Statement she had suggested for the version it was released for.. Maybe some of the database scheme has changed since then? Any help is appreciated :)
$userArray=$DB_site->query("SELECT username,user.userid,email,adminemail,joindate,act ivationid FROM user LEFT JOIN useractivation ON (user.userid=useractivation.userid) WHERE user.usergroupid=3 AND posts=0");