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

[Intex]

Superb work grandeur_69. I was waiting for this . I'll add to my install list.

[mikeB]

Is there an easy mod to make it auto click the next page button? in the last one there was and when you have 30,000+ members that next button becomes a task - thx!

[mikeB]

I get this error:

Invalid SQL: SELECT a.dateline, u.username FROM adminlog a LEFT JOIN user u USING(userid) WHERE action='sent bulletin' ORDER BY dateline DESC LIMIT 0,1
mysql error: Table 'XXXXX.adminlog' doesn't exist

and on install it errored on the top 2 commands

[mikeB]

User table altered... Failed (Possibly already updated)
User table altered... Failed (Possibly already updated)
Phrase table updated (profile.php 1 of 3)...Already Update
Phrase table updated (profile.php 2 of 3)...Already Update
Phrase table updated (profile.php 3 of 3)...Already Update
Phrase table updated (admincp/index.php) ...Already Update

[grandeur_69]

Mikey ...
1. - to your first post, yes ... you didn't look hard enough because it's an option.
2. - why don't you have an adminlog, it's part of vB3?
3. - that's normal if u've tried to install it twice, or you had it installed with vB2

[mikeB]

weird - I don't know now that you mention it - anyone have a tutorial or way to rebuild adminlog - and yes I had it in VB2

[dndog]

What does this hack do?

Thanks.

[grandeur_69]

good point ... guess it's an assumption by people who've been around vB for awhile. I'll post it in the first post.

[badpacket]

Great stuff grandeur!.. installed

[mikeB]

any idea why I'd get this error: Fatal error: Call to undefined function: html_entity_decode() in /home/httpd/vhosts/bakermedia.com/httpdocs/learn/admincp/commbull.php on line 554

when I hit Preview Mailing?