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.

I think you forgot these lines at the top so it updates with prrogress:

Will this work for 2.0.3 and is the file updated and complete?

This may have already been asked:
Is it possible to have the 'Allow Bulletin Board Administrators and Moderators To Send You Email Notices' revert to 'Yes' if the user selects 'Yes' for 'Receive Community Bulletin Email?' ?

Also, it would be cool to have the top x amount of posters and referral getters listed in the stat list. (or another new list)

I'm currently getting my host to update MySQL so I can send calendar and b-day updates. Figures, the cool stuff doesn't work!

What about adding top referrals?

Question: What is the best way to edit the mailing that shows up everytime you preview the mailing? I want to edit some things, such as the miss-spelling of "receive" so I don't have to edit it everytime I send it out.

Simply go into commbull.php and search for whatever you want to fix and edit it. I even made certain options default to NO rather than yes. What I DO NOT like is how you do want to go back and make a change, it resets all the fields. :(

Would it be possible to get another feature added to this hack to email the admin/mods of the forum the day the bulletin is due to be sent out?

Quick question also to those that use this hack, how often do you send out your community bulletin?

I try to send out mine weekly... however, I am having a hard time, which brings me to another point.

Does anyone on a dial-up connection have trouble sending the Bulletin? When I try to send it out on the preview mailing screen, it stalls and takes FOREVER to load. I have reduced the number of users it sends to at a time (down to 30 from 500) and I have tried only sending it to one or two user groups at a time, still SLOOOOOOW. It takes all day to send out the Bulletin, as I let it load for 30 minutes at a time while I do other things. Am I alone? Is this a problem with my Internet connection or my host's MySQL server?

Can this hack work for 2.0.3?

Works fine in 2.0.3

I contacted my host about this. They told me I have mySQL 3.22.32 running on my box and that it supports substring. Eh? What should I tell them?

There were apparently changes made to it in 3.23.3 and 3.23.7...which would lead me to believe that how I'm using it was not supported until one of those versions, which is higher than the version you are running.

I installed this hack sometime back and had no problems with it.I have since installed vb 2.0.3. I haven't used it in a month or so. Today I ran the bulletin and everything went find, except I excluded some of the forums by selecting no to them and they still send out threads from those forums.

Any ideas what might be causing this.

Absolutely beautiful hack, but it needs one key element:

Save the settings!!!

I can deal with manually sending it out, but having to go back and double check all my settings is a royal pain in the butt. Although, a small shell script to add to cron would be a very, very welcome addition.

Yea I also would like to see a SAVE SETTINGS addon to htis hack, great job again though tube. Any chances on the addon :D

Me too! Save settings! Add referral information as well!

you know u guys can actualy do all this stuff yourself :rolleyes:

If I knew how to write PHP, I would!

Same here. If I knew

Now what would be great was if you could select in the admin control panel what stats you wanted in each issue. Whether it be posts, referrals, views, etc. Referrals is a must!!

I'm going to post in the request forum and we'll see if anyone wants to help us out here. Can you guys just post in here a list of features you would like to see. Thanks!

when you say.. save settings (I have not downloaded or installed this yet) do you mean the settings for what is emailed out and everything.... ?

I would not personally think it would be all that tuff to do..

Well Brad not like what's sent. In this code there are setting you have to set before the mail goes out. We want to be able to make it so it remembers or saves these settings.

Just posted a request to add those save features to this hack. Tube please add this to your own hack to make things easier you do such a good job updating hacks. :D
http://www.vbulletin.com/forum/showt...threadid=28107

Another welcomed addition would be to make it easy to distinguish categories and forums. I have several categories with the same forum names (example would be general news for a toys section another classified section) but I don't want to include the classified section and it is hard to tell which is which. Is this written clearly?

;)

thx great hack, works fine in 2.0.3

It's not saving the option for my users:

Change "receive community updates" from yes, to no.

What a great hack. I got home from work today and had an email from the Webmaster talking about site upgrades. Amongst other things he lamented the lack of a newsletter feature we used to have when we were on the now defunct Rivals network. I sent back an email telling him to give me a few minutes. Then I sent him a Community Bulletin. :D

I just got around to installing this hack Very nice job tubedogg!

I have one minor problem with dates though. Here's a excerpt from a test bulletin I sent:

The posted date on this should actually be 10-29-2000. This exact date error (01-18-2038) is repeated for every thread that was originally started in my UBB forums prior to upgrading to vB.

Any idea how to fix this?

I found another problem in the statistics:

There are only 81 new threads so far this month - not 1866. The posts and members are correct though.