vB2 User Activation ID MYSQL Query

[hurrican]

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

[hurrican]

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

[sabret00the]

Originally Posted by hurrican

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

it definately sent the activation id when i sent it.

[hurrican]

Originally Posted by sabret00the

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?