[vb_guru]

Originally Posted by Paul M

That's explains the problem then. All the database references are to $DB_site which is vb3.0 code.

Change them to $vbulletin->db.

That would explain the problem. I will give that a try. Funny thing is that I went to the vbulletin.com user manual and looked at their coding standards and saw the $DB_site in the examples.

Paul M,

Thanks for the help. I made the update you suggested, changing $DB_site to $vbulletin->db. The task now runs.

However, there is still one small problem. Based upon the data in the database when the script runs I should get three users updated. I do get the 3 e-mails sent to the correct users however only the last user gets the column retaileremailaccept = '1' updated.

I think there may be a problem in the code so that it is not looping through and doing the update for each of the rows selected in the first SQL query. Any ideas on why this is happening?