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.

The .zip file in the first message has been updated every time. Besides, there isn't another one in this thread, so that's the one you want

At first when I installed it, I got this error:

----------------------------------
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
-----------------------------------

But then I turned the Brithdays annd Calendar stuff to 0 and it worked like a charm Whew! I'm gonna have some fun now..

Thanks

[Tarion]

Hello, is a very good hack,

but i have some problems with the inclution of some code in members.php and index.php. All of this code i don't finde in the two files. waths happends???

PHP Code:

then find this: 
  $pmpopup=iif($pmpopup=="yes",1,0);
and after it add this 
  $receivebulletin=iif($receivebulletin=="yes",1,0);
and finally find this 
  $DB_site->query("UPDATE user
                   SET ".$updatestyles."adminemail='$adminemail',
and replace it with this: 
  $DB_site->query("UPDATE user
                   SET ".$updatestyles."adminemail='$adminemail', receivebulletin='$receivebulletin',


--------------------------------------------------------------------------------

admin/index.php 
You will need to make the following alterations to your admin/index.php file: 
After this:
<a href="email.php?s=<?php echo $session[sessionhash]; ?>"> Email users </a><br>
add this:
<a href="commbull.php?s=<?php echo $session[sessionhash]; ?>"> Send Community Bulletin </a><br>

I hope you can help me.

PS. I can open the file commbull.php an send mails to all users, but i didn't see the link in the cp.

[Tarion]

i was to stupid to find the code, but at the moment i see it.

THX

[SirSteve]

Does this work on 2.0.3 ?

[tubedogg]

Yes.

[Tarion]

perfektly it's a very good Hack and it works fine with V2.0.3

[SirSteve]

I just got this when trying to run commbull.php:

Fatal error: Call to undefined function: cpheader() in /usr/www/users/gandalf/starwarsguide.com/forums/commbull.php on line 6

[tubedogg]

You have to put commbull.php into your admin directory.

At the moment I'm just toying around with vBulletin, seeing what it can do etc, before putting it live (same thing can be said for my whole website actually), so I found the following error when I tried Previewing my "community bulletin"..

"Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='08-08' AND SUBSTRING(birthday,6)<='08-22' 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: Wednesday 08th of August 2001 12:49:23 PM
Script: /forum/admin/commbull.php
Referer: http://www.dogwalks.org/forum/admin/commbull.php?"

If I set the number of birthdays to display to zero then it works... so I suspect that the problem is something like that there aren't 10 users subscribed to my forum, so therefore it's not gonna find 10 birthdays - 10 seems to be the default value for birthday output...

Just a minor error, doubt most people would see it, but thought you might like to know anyway.

Looking forward to using the community bulletin feature when I go live with the site :-).