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

[Held der Nacht]

Can nobody help me ?

My users get the text mode e-mails as .txt file (textfile) in the mail.

[slideboxer]

Originally posted by DJ FRESCO
Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT userid,username,birthday FROM user WHERE SUBSTRING(birthday,6)>='02-11' AND SUBSTRING(birthday,6)<='02-25' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1

mysql error number: 1064

Date: Monday 11th of February 2002 03:28:57 PM
Script: http://www.djfresco.com/forum/forum/admin/commbull.php
Referer: http://www.djfresco.com/forum/admin/commbull.php

So what's the word on the fix for this error? I get it whenever I allow birthdays or events into the bulletin. Doesn't happen when I leave them as zero. ANyone get this to go?

[The Matrix 7]

My users get the text mode e-mails as .txt file (textfile) in the mail.

The problem is recovered

[pigsy]

Now we just need a way of saving the settings. Changing them each time is a real chore!

Good work though!

[pran]

Is it possible to configure the sender of the e-mail?

[Dan Flynn]

Hello,

Can anyone tell me what might be wrong. I sent a test email to myself.

The dates are all messed up. 1938????? plus recent post are from 38 and last post 2 uears ago in 2000.

Thanks

[cditty]

I seem to be having a problem in the members.php page. It doesn't seem to remember the yes/no choice the user made. It reflects it in the database, just not on the page itself.

Any tips?

Chris

[Ig@r]

Installed and tested!
Good job! Thank you!

Now, can I make it work with cron?

[cditty]

Can anyone offer any advice on this? I want to send a bulletin out to my people but I want them to be able to remove themselves if they want.

Chris

[christec]

Under the users control panel a user can select NOT to receive the community bulletin.