CommBull (Community Bulletin)

vb3.5 Commbull
vb3.6 Commbull

Note:
The 3.6 version is a commercial product, any queries on it should be submitted to: vb3.6 Support Site

THIS THREAD IS FOR SUPPORT FOR 3.0 VERSIONS ONLY. PLEASE VISIT THE APPROPRIATE FORUMS (links above) FOR THEIR SUPPORT

[valid point]
it's been brought to my attention that not everyone knows what this is ... fair enough: This hack is considered a "weekly newsletter" by the fact that it will email members (only sent by an admin) who have opted to receive it new posts, hot threads, etc ... basically a summary of what has been going on since the last time the newsletter was sent out. However there is a vast number of options, and I won't go into detail of all of them ... you can view the the images that I've attached, but u will only get a full idea by installing it.
I would say that there is 0 risk of this installation doing any damage to your current install as these are the changes that it does (manually and automatically):
- change profile.php and admincp/index.php
- add a couple columns to user table (receivebulletin and receivebulletin_type)
- add some phrases to phrase table (receive_email_from_commbull, type_email_from_commbull, newsletterformat, commbul)
- add a row to datastore table (commbull)
- add some html to nav template for admin side
So, if you are unhappy with the install. you can just ignore that it's there and it'll never cause any problems ... your next upgrade will overwrite any changes to the index and profile pages and the extra columns in the DB won't be an issue

[mods that i've added from vB2 version]
- to change languages, comment/uncomment line 22 and 23 to switch from English to German
- save prefs (option)
- skip to page X in case of mailout freeze
- auto redirect to next page (option)
- adding personalized text to top of newsletter w/out searching through the two text & html fields ... u'll c what i mean :ermm:

[INSTALL]
drop the 3 files into the admincp directory and then go to admincp/commbull.php ... follow the instructions and you are good to go.
If you find that the option isn't showing up on the control panel after the install, then it's because you aren't using the default phrases. Go into phrase manager, search for 'commbull' and update the fields appropriately.

If something goes wrong, don't worry .. it checks for already completed updates to the database to avoid redundancy ... enjoy!!

[LadyBeth]

We also have problems emailing since updating to 3.0.6 and readding the hack. It used to work. Now even set as low as 50 users we get the following....see attached.

I really love this hack and really need it to work again. Please help.
Thank you so very much!!!

LB~

[iSpanish]

Nice hack

installed when i using vB 3.0.1

and now using 3.0.6

*installed*

[LadyBeth]

Please help...really want this hack to work again.
LB

[joeychgo]

I jsut installed it on 3.06 last night - smooth install

[Viks]

Hi guys,
I do not show upcoming event in the CommBull newsletter. im running vB3.0.3. My settings are ok..i've checked that.

As per this thread there is an known issue with events not showing up in the newsletter. Has anyone been able to fix that??!?

thanks,

Viks

[tormodg]

Originally Posted by Viks

Hi guys,
I do not show upcoming event in the CommBull newsletter. im running vB3.0.3. My settings are ok..i've checked that.

As per this thread there is an known issue with events not showing up in the newsletter. Has anyone been able to fix that??!?


thanks,

Viks

Works fine in 3.0.6.

*clicks install*

[tormodg]

Sorry, didn't mean to quote Viks. I forget that the quick reply creates a quote in this forum. :devious:

[tormodg]

Hm...it worked fine during testing with my mods and admins, but when I start sending out the commbull to all my members, I have to set the limit to 5 per page to avoid a 30 second timeout (default at my host).

After 3 pages I get this error:

Warning: Division by zero in \admincp\commbull.php on line 1127
Sending mail to users .... .... (page 1/0)

The previous page read "page 3/165". I have about 880 members.

What is causing this?

[tormodg]

Ah...here is the MySQL error:

Invalid SQL: SELECT * FROM vb_user WHERE receivebulletin=1 AND IF (options & 16,1,0)=1 AND usergroupid IN(2,3,5,6,7,18) LIMIT 0,
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

[tormodg]

Took out this bit and now it works:

AND IF (options & 16,1,0)=1

This is the check for "receive admin emails".