Updated Community Bulletin Generator

SPECIAL NOTE for those upgrading to vBulletin v2.0.0: You will need to make changes to the default RC3 files, as you did with the previous version files. The files are member.php and admin/index.php. After you upgrade to RC3, the link in your Admin CP will no longer be there. In order to find instructions for upgrading, go to http://yoursite/forum/admin/commbull.php and click the link for Instructions. Make these changes to your files, and reupload the two modified files. The link will then be back in your Admin CP.
------------------------------------------------------------------------------------

With Kier's permission, I am rereleasing this hack. It has been updated, but most of the credit still goes to Kier. I just added a couple things. Namely, I took Kier's starting point for birthdays and reworked it a bit so they can now be included. I also added 3 new sets of Latest Threads input, and added a sorting option to get topics with no replies (aka "Virgin" topics).
I also added a box to change the section separation character (Kier had it as a "-", now you can change it) and the list item character (Kier had it as an "o"). There are also instructions on how to integrate it into your Admin CP.

To install, just upload it to your Admin directory and go to it in a browser.

If you had previously installed Kier's original version, simply overwrite the commbull.php file on your server, and make this change to your admin/index.php file:
Find

<a href="email.php?s=<?php echo $session[sessionhash]; ?>"> Email users </a><br>

and right below it, add

<a href="commbull.php?s=<?php echo $session[sessionhash]; ?>"> Send Community Bulletin </a><br>

Upload your admin/index.php file and go to your Admin CP. You should see the new option under "Users" on the left-hand side.

Hack version: 0.98

Changes since v0.97: Fixed a stupid bug that screwed up the script when you posted a copy to a forum and that forum didn't count posts toward post totals.

Changes since v0.96: Fixed a minor bug that was causing large problems when the number of emails to send was more than it was set to per page.

Changes since v0.95: Minor cosmetic changes; fixed "copy post to board" function so it actually works; added option to exclude threads from being used more than once (if doing multiple blocks); fixed sorting by most replies/most views so they don't return threads with 0 replies or 1 view, respectively;

Changes since v0.93: Option to post a copy of the email to your board, to a forum you specify using a username your specify (If you do this, there is a function to exclude certain parts (for example, the user info section that details username/password etc) and it parses URLs so the message on your board has hyperlinks to the threads/polls/etc); various cosmetic upgrades; minor little things here and there; fixed/changed "Only include threads that have been started or replied to since this date?" so it doesn't defeat the purpose of specifying a date.

For version: v2.0.0

Info for Clean Install -------
Files needed: commbull.php

Files to edit: admin/index.php, member.php

Templates to edit: none

Instructions are in the script itself. When you first run it, it will tell you what you need to do. If upgrading from Kier's original version, see instructions above.
End Info for Clean Install -------

Info for Upgrading from v0.90, v0.91, v0.93, v0.94, v0.95, v0.96, v0.97 ------
Files needed: commbull.php

Files to edit: none

Instructions: Upload the commbull.php file from the commbull98.zip file.
End Info for Upgrading -------

Please do not bug Kier about this hack!
Please also DO NOT contact me via AIM, ICQ, PM, or email about this hack. Post your question/problem here and I will try to help you.

[Dave#]

[heynurse]

this is an awesome hack!!!! Kudos! Thanks a million!!

[Joe]

Anyone haveing date problems with "Threads posted most recently"?

look at my dates:

Title: "Heya, where is everyone from?" (posted 01-18-38 by SnoTurtle)
o 0 replies, 68 views, last post: 01:41 AM, 10-28-99 by SnoTurtle
o http://216.215.238.193/showthread.php?s=&threadid=2

Title: "Administrative Test Post" (posted 01-18-38 by donco)
o 0 replies, 58 views, last post: 08:12 AM, 03-13-00 by donco
o http://216.215.238.193/showthread.php?s=&threadid=3

Title: "Training / riding groups in Kuala Lumpur" (posted 01-18-38 by chrisbeddows)
o 1 replies, 67 views, last post: 02:23 PM, 05-15-00 by Joe Gardner
o http://216.215.238.193/showthread.php?s=&threadid=5

These are all old UBB threads that were coverted to vB forumat in version 1.12...

[tubedogg]

OH you didn't mention that! That I have a fix for...somewhere around here...umm let me find it.

*runs off to find it*

*runs back*

OK I got it. This is not my script being wrong. It is the way vB imports/imported UBB threads. So here's the deal: rename this to fixubbdate.php, upload it to your admin directory, [important step] backup your database [/important step] and then run it by going to it in a browser.

That should fix your dates and make it so the script selects them correctly. The basic idea of why it doesn't work is the old import script gave the threads dates 30+ years in the future...which means when selected by date those come first.

[edit]Upon further inspection I realized that Joe, not Dave, posted the second message. so the "oh you didn't mention that" doesn't apply but I can only assume that Dave's was imported too...(at least I can hope - then it means there's nothing wrong with my script ).[/edit]

[Dave#]

Kevin - Yes mine is a UBB import too-

Off to test the script

oops

Parse error: parse error, expecting `T_VARIABLE' or `'$'' in /home/cpfc/www/forums/admin/fixubbdate.php on line 15

[tubedogg]

*doh* I thought I fixed that last time I posted this script...anyway replace line 15 (which is currently

	if ($i = $50) {

with

	if ($i = 50) {

sorry

[teenfront]

Hi I installed this script with no problem and I did with the welcome message script. However although it says messages sent to user@domain.com and no error messages appear it does not actually send the email when i test it.

Pleae help!

I don't think it is a problem with this script but something to do with the server or database is this possible.

Cheers,
Nick

[MApI]

With my 2.0.1 works great ! Thx.

bye

[Joe]

Nice! The fix ubbdate work great, i can new use the hack! In the future, i would like to see a "set preferences" section, where we can set what we sent out, so we dont have to configure the email each time, also if it sent every thing out by itself (cron?) that would be dandy... Good job.

[webhost]

Just installed into version 2.0.1 took about 15 minutes was very easy . Worked without any errors. I have been using a mailing list from mailman and this is alot easier and better. Will this also send data from a locked forum? I hope so that way I can use the locked forum to write messages to members and than lock it back just for me to update on a weekly basis.

Kier/Tubedoog
Thanks Again