vB2 User Activation ID MYSQL Query
 

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");

Anyone? I know there's some MySQL Guru's on here ;)

it definately sent the activation id when i sent it.

I can get it to send it out if I change the LEFT JOIN a little bit, but it keeps looping and will send out mail indefinately. There's surely something array?