News & Email Community Bulletin Generator

Updated 30 Nov 2001
Fixed a typo and Birthday Date Bug
---------------------------------------------

Here's a new version of the Community Bulletin + HTML
With the changes and the inclusion of the news section I have
titled it News and Email Community Bulletin Generator.

Here's a list of the changes/modifications that were made

Include News Articles (Threads) in bulletin.
Remove vbCode from news articles before sending email.
User email options include HTML or Text.
Forums are sorted by displayorder.
Category forums do not contain yes/no option.
Private forums marked as no by default.
Fix lasteventdate bug.
Modify admin/index.php installation instructions for version 2.2.x and version 2.0.x.
Include Admin CP edit user option to include Receive Community Email Bulletin and Type (HTML or TEXT).
Remove user password, send link instead.
Preview of HTML and TEXT email.
Post to Forum can be HTML or TEXT
Modified a few mysql SELECT * queries to include only necessary fields.
Cosmetic changes
......

To install
Copy the commbull.php file to the admin/ directory.
WIth a web browser access the commbull.php file.

Example: http: //yoursite.com/forums/admin/commbull.php

Follow the additional installation instructions.

This hack is based on Community Bulletin Generator by Kier
and additional Community Bulletin Generator functions by Kevin

Additional: This hack has only been tested on my machines. I don't have the ability to send emails
to a lot of users so this has not been tested either.

Remember: BACKUP and TEST.
213

[afterlab]

They must first say "Yes" that they want to receive the newsletter. Tell them to go find it within their User CP:

User CP > Edit Options

[Kars10]

Ok.
But in "my" own CP is also switched to yes, i i didnt get the Newsletter...

The script says : sending Mail, Site 1/2...
but on the Point where 78 Users are send, ....its ready.
I didnt get a second site... and i can´t reload that page, without sending the Mail to the 78 Users twice.
Ive installed everything correctly. The installation was very easy.
But why i cant send to more than 78 users?
Is there a query i cant run, that in all cps is switched to yes...
Normaly after the installation, all is switched to yes?
I dont think that 280 Users regonize that ive made a new install of a Newsletter-Script and switched in there CP to No..
And ther Problem is, i cant tested without sending the Mails. I dont want to spam my Board-Members!

[FleaBag]

Works with 2.2.7. Top work!

[Aurore]

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks

[wolfe]

since i added this i get an error

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1970-01-01 01:00:00'),returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='10',username='rpm',email=useremail@site.com,styleid='14',parentemail='',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminemail=1,receivebulletin=1,receivebulletin_type=1,showemail,showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars}/1stars.gif">,customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-04 17:54:20'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-09-04 20:35:39'),lastactivity=UNIX_TIMESTAMP('2002-09-04 21:11:46'),lastpost=UNIX_TIMESTAMP('2002-09-04 19:10:38'),posts='20',timezoneoffset='0',emailnotification=1,receivepm='1',emailonpm='0',ipaddress='62.30.77.26',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=331
mysql error: You have an error in your SQL syntax near 'showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars' at line 1

mysql error number: 1064

Date: Wednesday 04th of September 2002 09:49:36 PM
Script: http://mysite.com/forums/forums/admin/user.php
Referer: http://mysite.com/forums/admin/user....dit&userid=331

whats that all mean

[Joe Page]

Very nice add-on, thanks

[Webdork]

Quick thanks from me too, works perfectly.

Would love to see a version where you could add a message to top of mailout...

Can do this simply by cutting and pasting in the html and the text form of the mailout, but would be nice if you could add a message when compiling.

[tractor-beam]

Howdy folks,

I just installed this great hack on my vBulletin 2.2.5 web site and it works great. I too wanted the bulletin to create hyperlinked calendar events.

I'v been messing around with PHP for a month or so and decided to try and hack the "commbull.php" myself to see what I could do.

I made two very small changes to the code and here is my results. I'll post the changes if anyone is interested.

- Gerry

[LightBringer]

I installed this hack recently and I am experiencing an issue where the news article titles (the ones selected here: Select news articles to include in your email) aren't all showing up.

Notice how the thread titled "Unreal Tournament 2003 Server Specs Demo" has a nice table behind it and the title actually shows up?

The ones above it do not show the title or the table.

Screenie included

Could really use some help on this one.

[Aurore]

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks