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!!

HELP



Database error in vBulletin 3.0.8:

Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1127346816',lastposter='Mark' WHERE forumid IN ()
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

Date: Wednesday 21st of September 2005 06:53:36 PM
Script: http://www.
Referer: http://www.
Username:
IP Address:

[rcull]

A feature I would like on commbull is to know how many people it actually sends out to. I know how many registered members I have, but probably many have unsubscribed.

[Toneboy]

Any update on whether or not this will become available for 3.5?

[noppid]

Originally Posted by Toneboy

Any update on whether or not this will become available for 3.5?

I have converted it for my forums. It's an important hack for us. I will not be supporting it or posting it however. I have contacted the author and offered him the code. Beyond that, I have no clue what will happen. He may even have his own plans.

[aldamon]

Originally Posted by noppid

I have converted it for my forums. It's an important hack for us. I will not be supporting it or posting it however. I have contacted the author and offered him the code. Beyond that, I have no clue what will happen. He may even have his own plans.

Does the original author even care any more? I don't see why you'd have to support it if you just posted the changes. I hope you reconsider.

[noppid]

Originally Posted by aldamon

Does the original author even care any more? I don't see why you'd have to support it if you just posted the changes. I hope you reconsider.

The latest author has said the code is free to share. But, I am not posting anyone's code that I modified ever again for personal reasons.

I sent him a copy and asked him to post it. I would monitor the thread though since he is very busy and can't support the hack any longer if that happens.

[aldamon]

Don't need support. All I need is a description of the modified files and simple instructions, just like every other version of this hack for the last 4 years.

[Toneboy]

I might go down the newsletter road then rather than wait for a hack I found to be quite buggy with the 3.0.x series.

[Neutral Singh]

Yes please share the code modification for vb 350 with us. Thanks

[aldamon]

Noppid saves the day! Commbull lives on!

https://vborg.vbsupport.ru/showthread.php?t=97809