Community Bulletin Email Generator + HTML

First off this is Kier's hack and it's a great one. There are other contributors like tubedog.

Update 16-Nov-2001:
Include News Article(s) in bulletin
Optional - Add "Receive Community Email Bulliten" option to the admin CP. When editing a user you can turn on and off the bulletin.
Fixed lasteventdate bug

These changes are based on version 0.98
Changes/Additions
Preview includes html tags
Email is sent in an HTML format
Post to thread is HTML
Updated install to include changes for vBulletin v2.2
Private Forums marked No by default (if accessmask is ON)
Password removed - Link to Forgot your password added

Installation is still the same. If you already have commbull.php installed you can just copy this file to the same location.

(I'm not trying to take any credit for this hack. Just share the modifications that I made.)
Always backup and test.
CC

[Robert Basil]

Originally posted by FWC
I only have 604 lines in combull.php. :surprised

For some reason I don't think my commbull.php file is un-zipping correctly.

Can someone post a .txt version of it here?

Thanks for all your help everyone!

[Robert Basil]

I've been looking at the script, and it looks like it's supposed to create a receivebulletin field in my user table.

After the error I thought I would check and it is not adding the field for me.

So I thought I would try and force it with the action=install option. But still getting the same error message.

uugg..

[FWC]

Here's a copy. The HTML color variables are set for my board. You'll need to edit those:

[Robert Basil]

Originally posted by FWC
Here's a copy. The HTML color variables are set for my board. You'll need to edit those:

I still get the same error with your copy.

Damn, I wish I knew what was going on, I REALLY could use this script.

[FWC]

Have you tried the original non-HTML version to see if that works?

Ooops, I see you already did above.

[christec]

Originally posted by Sportbikeworld


I still get the same error with your copy.

Damn, I wish I knew what was going on, I REALLY could use this script.

Try this
Find this

PHP Code:

if ($DB_site->query("ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null, ADD receivebulletin_html SMALLINT (5) UNSIGNED DEFAULT '1' not null")) { 


and replace with this

PHP Code:

if ($DB_site->query("ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null")) { 


I was working on including the text and html option. It may be causing the problem.
Line 831 is } and line 832 is blank

[Robert Basil]

Just tried the fix....

Now getting the error:

Parse error: parse error in /home/admin/www/v2/forums/admin/commbull.php on line 831

[Robert Basil]

Originally posted by christec
Line 831 is } and line 832 is blank

Can you post a few lines above and below this } so I can maybe take a look?

Thanks!

[christec]

Are you being prompted for the admin login page before getting the error code. It should show up first before proceeding on to the commbull install.
Try setting the full path to the require(./global.php) file

[christec]

Originally posted by Sportbikeworld
Can you post a few lines above and below this } so I can maybe take a look?
Thanks!

829 <?php
830
831 }
832
833 //########################
834
835 if ($action == "changelog") {
836
837 echo "<b>Community Bulletin Email Gen....."