Actually, read up a few posts. :) Your version of MySQL does not support SUBSTRING, or does not support using SUBSTRING in a where clause.

Setting it to 0 eliminates using birthdays and therefore solves the problem.

Thanks tubedogg! I must've overlooked that step.

Ah, i see! Is that something I should talk to my isp about? Does that mean they're using an older version of SQL?

Did a test post to myself and worked fine, tried a post to all members and got this:

Database error in vBulletin Control Panel: Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='997310960',lastposter='warrior' WHERE forumid IN ()
mysql error: You have an error in your SQL syntax near ')' at line 1
mysql error number: 1064
Date: Wednesday 08th of August 2001 11:49:20 PM
Script: /forum/admin/commbull.php
Referer: http://www.******.co.uk/forum/admin/commbull.php

I have the entry in my CP and I turned birthdays etc. to 0

Also getting this error when I try to enter my CP:
Parse error: parse error in /usr/home/c/a/******/public_html/forum/member.php on line 1291

any ideas.


Please disregard this post, was a syntax error in member.php (My Fault) all working as it should - great Hack TNX

Can someone please explane how to Install this because I cannot find the members, admin or index.php files in my forum.

Do I have to Install them via templates?

:rolleyes:

Your members.php is in the main forum folder, index.php is in the admin folder.

Download members.php, index.php(index.php from the admin folder) upload commbull.php to your admin folder and run from your browser. All the instructions will appear on screen. Give yourself some time to complete.

Any chance you could add an extra feature to the community bulletin mail hack tubedogg?

The feature is the PM or email the admin/mods etc when it's time to send out the next mail with an option to set how often you wish to send out the mail?

This would be really appreciated!

WHy not just run it via cron?

Would that work? What if you wanted to change some of the settings for the mail like which threads and posts to include? I don't think it'd work.

Just installed it, brilliant !!!

Minor "cosmetic" problem.

" are displayed as & quot in the email. (without the space).

Obviously ok when posted to forum.

Can you tell me what needs to be changed to get around this please.