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

[Sal Collaziano]

Originally Posted by breathwork

How can I automate the production of the community bulletin to run say every Monday morning at 06:00 hrs?

:speechless:

I can't imagine what I did wrong but my newsletters aren't being sent out in HTML.. I sent it to myself and when I opened it in Outlook, it's all text.. Any ideas?

Great mod!!

[memobug]

Originally Posted by Sal Collaziano

I can't imagine what I did wrong but my newsletters aren't being sent out in HTML.. I sent it to myself and when I opened it in Outlook, it's all text.. Any ideas?

Great mod!!

Hi Sal,

What is your USERCP setting for newsletter type? checked or unchecked?

And while I have you on the line...

Are you getting any events or birthdays showing in the output? This same question has been asked by myself and others, but no one seems to know or care...

Regards,

Matt

[Sal Collaziano]

Originally Posted by memobug

Hi Sal,

What is your USERCP setting for newsletter type? checked or unchecked?

And while I have you on the line...

Are you getting any events or birthdays showing in the output? This same question has been asked by myself and others, but no one seems to know or care...

Regards,

Matt

Yeah, I do have the option checked in my control panel. HTML and all.. That's what's got me confused. I can't figure out why I'd get the email in text only...

Otherwise.. All I get is the header for events.. Nothing beneath it in regards.. So I have the same problem too..

[sully02]

I am getting this error...

Database error in vBulletin 3.0.3:

Invalid SQL:
UPDATE vb3_user SET
styleid = 3,
showvbcode = 2,
pmpopup = 0,
maxposts = -1,
daysprune = 0,
timezoneoffset = '-6',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = -1,
usereplacementscensor = ,
options = 3799
WHERE userid = 11

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 '
options = 3799
WHERE userid = 11' at line 12

mysql error number: 1064

Date: Friday 15th of October 2004 12:31:37 PM
Script: http://sports-boards.net/forums/profile.php
Referer: http://sports-boards.net/forums/prof...do=editoptions

==================================

Any suggestions?

[rex_b]

It's only sending to 400 out of my 1100 users.

Any ideas on why or how to fix?

[breathwork]

Originally Posted by sully02

WHERE userid = 11' at line 12

mysql error number: 1064

Date: Friday 15th of October 2004 12:31:37 PM
Script: http://sports-boards.net/forums/profile.php
Referer: http://sports-boards.net/forums/prof...do=editoptions

==================================

Any suggestions?

There is a missing quote preceeding the number 11, should read :

WHERE userid = '11'

hope it helps

[memobug]

Originally Posted by Sal Collaziano

Yeah, I do have the option checked in my control panel. HTML and all.. That's what's got me confused. I can't figure out why I'd get the email in text only...

That does seem like a mystery. How does the HTML preview look? When it mails stuff out, if memory serves, I think it tells the type of newsletter it's sending HTML or text . Maybe that was the previous version, though. Do you have anything like that?

Regards,

Matt

[theArchitect]

*theArchitect Clicks Install*.

A sensational hack. Your work is most appreciated.

[Sal Collaziano]

Originally Posted by memobug

That does seem like a mystery. How does the HTML preview look? When it mails stuff out, if memory serves, I think it tells the type of newsletter it's sending HTML or text . Maybe that was the previous version, though. Do you have anything like that?

Regards,

Matt

Yeah, it does say "html" when mailing out.. But even more strange, I guess, is - I don't see any html in the preview. The way I see the preview is the way I get it - text only.. Even more strange now?

[theArchitect]

Originally Posted by Sal Collaziano

Yeah, it does say "html" when mailing out.. But even more strange, I guess, is - I don't see any html in the preview. The way I see the preview is the way I get it - text only.. Even more strange now?

Does anyone know how to comment out a section of HTML that one does not want to appear in the post?

I have used the { which stops it from appearing in the post, but the { then appear in the e-mail version.