Fixed. Download the zip file and reupload commbull.php.

tubedogg & Kier, thank you for this hack! It's awesome!!!

WOW.... great fix

This looks great and I can't wait for it to work but I got this error and I do not know enough about mySQL or php to figure where it came from

After installing the hack and setting up the preferences .. I clicked the okay or whatever and it sent me this error

Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='06-10' AND SUBSTRING(birthday,6)<='06-24' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1
mysql error number: 1064

Not sure what to do to fix it..

Set birthdays to 0.

Thank you thank you thank you!

This hack rules!!!

I love watching who's online after I send out the weekly bulletin. People that I thought had died show up on the board and poke around.

Thanks for this great hack. :)

Now, I can't resist picking on you a little bit and asking for this hack to be upgraded so that it maintains the settings (the forums not to include, how many threads to include, etc.) so that all I have to do is tell it to send once a week.

Amy

When I try previewing the mail I get the database error.

Anyone got any ideas?

Tiss ok, I see the post above about it. Thanks

Im having problems with the Threads posted most recently option, im showing the first few threads posted, not the last threads posted. Is this a v.98 bug, or am i using this wrong? :)

- Will adding the new field to user database cause any conflict in future vb release?

- Just in case if we do not want to use this script after adding the new field to user database, how do we revert back any changes to the database?

- Hope that hack will appear in the next vb release.