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

[FWC]

Cool! I'll have to try this when I get home from work tonight.

[Princeton]

GREAT JOB! I was hoping for a text or html version.

thank you and keep up the great work.

[FWC]

I lied. I installed it during lunch. Excellent job!!

[DarkReaper]

Does this display the forums in a straight list or in a hierarchy?

[Robert Basil]

Well,

I told you in the other thread I'm not ready to give up on this hack.

I gave up on the script not being able to add the fields in my user table so I added them myself using these commands (Yes, it worked fine)

ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null

ALTER TABLE user ADD receivebulletin_type SMALLINT (5) UNSIGNED DEFAULT '1' not null

Then I made the changes according to the admin_commbull.txt

I then accessed the commbull.php via the web and yes, it FINALLY asked me for my admin username and password (This was my stumbling block with the old version)

I entered my username and password and then got the screen stating:

"User tables have been altered sucessfully.

Installation instructions for the News and Email Community Bulletin Generator. "

So I made all of the changes according to this file. And then I clicked on the "Go" button at the bottom of the page.

And....... nothing. The same install page just keeps repeating itself when I click on the "Go" button.


Sooooo close..........

Any ideas?

[christec]

Originally posted by DarkReaper
Does this display the forums in a straight list or in a hierarchy?

Hierarchy, just like the list is displayed in the modify forum section, Sorted by Categories, but listed in a straight line.

[christec]

And....... nothing. The same install page just keeps repeating itself when I click on the "Go" button.

Have you tried the link through the Admin CP

[Robert Basil]

Originally posted by christec

Have you tried the link through the Admin CP

Yes, it just keeps repeating itself there also.

[christec]

Originally posted by Sportbikeworld


Yes, it just keeps repeating itself there also.

How about www.yoursite.com/forums/admin/commbull.php?&action=info