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.

[aldamon]

Is this built into 2.2.0???

[tubedogg]

No.

[JJR512]

Any ideas on completing the last step of the installation with 2.2.0:

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 believe this is the new line we're looking for:

makenavoption("Email Users","email.php?action=start","<br>");

I tried this as the new line below it:

makenavoption("Send Community Bulletin","commbull.php","<br>");

But that only gave me a 404 page in the right side of the CP.

[MarkB]

It shouldn't give you a 404 error if commbull.php is in your admin directory. I added something basically the same (although mine references commbull.php?s=, which I doubt makes any diff), and it worked fine...

Good luck

[DarkReaper]

Originally posted by SirSteve


Look through commbull.php until you find what you want to change and you'll see "checked> Yes <", change Yes to No.

Nice try, but that won't work, because that's not the way the script is setup

I've tried changing the block of code that outputs the forums to this, but its not working correctly:

	maketableheader("Include Info From Forums...");
	makelabelcode("<b>Include info from the following forums:</b>","&nbsp;");
	$forums = $DB_site->query("SELECT * FROM forum WHERE allowposting=1 AND active=1");
	while ($forum = $DB_site->fetch_array($forums)) {
		$permission = $DB_site->query("SELECT canview FROM forumpermission WHERE forumid='$forum[forumid]' AND usergroupid=2");
		if($permission == 0)
		{
			makeyesnocode($forum[title],"forum[$forum[forumid]]",0);
		}
		else
		{
			makeyesnocode($forum[title],"forum[$forum[forumid]]",1);
		}
	}
	restarttable();

Any ideas? It always goes to the else part of the if statement.

[JJR512]

Originally posted by MarkB
It shouldn't give you a 404 error if commbull.php is in your admin directory. I added something basically the same (although mine references commbull.php?s=, which I doubt makes any diff), and it worked fine...

Good luck

When I point to the link, I see in the status bar that the URL is correct: www.jjr512.com/forums/admin/commbull.php. And even though I didn't put in any s= part, the end of the URL, after what I just mentioned, is &s=. But it still results in a 404. The file is there; I used it to give me the installation instructions.

[aldamon]

Don't forget, the admin control panel is also coded differently now, so the find and replace code portion of the instructions will not work.

I'm sure tubedogg will hook us up. I just hope it's before my next update is due to go out

[orca]

The correct syntax for the addition would be:

PHP Code:

makenavoption("Send Community Bulletin","commbull.php?action=info","<br>"); 


If you don't add the action command it will display a blank page. I tested it. It works on my site.

[DarkReaper]

Can someone help me with my problem plz?

[christec]

Quick thought: [DarkReaper]

if $permission == 0
It will pass the $value of 0 to the function makeyesnocode for each loop it makes, making the value = "No"

if $permission != 0
It will pass the $value of 1 to the function makeyesnocode for each loop it makes, making the value = "Yes"

It will not select between the two.

Right?