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.

[Guru]

If the number of days for birthdays goes past the end of the year the block is not included.

Here's some offending code:

PHP Code:

    $btoday = date("m-d");
    if ($daysaffect == "1") {
        $bdaysprune = date("m-d",(time()+$eventdays*86400));
    } else {
        $bdaysprune = date("m-d",(time()+200*86400));
    } 


The dates need to be changed to include the year.

[Lionel]

How can I automatically include headers and footers in the generated email?

[Guru]

Here's the repaired code. I tested it on my board, and found and fixed another flaw.

• Changed birthday code to correctly handle end of year roll-over
• Separated the date headline and age calculation code

PHP Code:

    // do birthdays
    if ($numbirthdays) {
        // Accomodate end of year roll-over
        if ($btoday >= $bdaysprune) {
            $users = $DB_site->query("SELECT * FROM user WHERE SUBSTRING(birthday,6)>'00-00' AND (SUBSTRING(birthday,6)>='$btoday' OR SUBSTRING(birthday,6)<='$bdaysprune') ORDER BY SUBSTRING(birthday,6) LIMIT 0,$numbirthdays");
        } else {
            $users = $DB_site->query("SELECT * FROM user WHERE SUBSTRING(birthday,6)>='$btoday' AND SUBSTRING(birthday,6)<='$bdaysprune' ORDER BY SUBSTRING(birthday,6) LIMIT 0,$numbirthdays");
        }
        if ($DB_site->num_rows($users)) {
            $thisyear = date("Y");
            $birthdayspreview = "$dashes\nFORTHCOMING BIRTHDAYS:\nto view the calendar, click the link below:\n$bburl/calendar.php\n$dashes\n";
            // $birthdayspreview .= "DEBUG: btoday: $btoday   bdaysprune: $bdaysprune\n";
            while ($user = $DB_site->fetch_array($users)) {
                $datebits = explode("-", $user[birthday]);
                if (substr($user[birthday],6) != substr($lastbirthday,6)) {
                    $currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));
                    $birthdayspreview .= "\n$currentdate:\n";
                }
                if ($datebits[0] != "0000") {
                    $age = " (".($thisyear - $datebits[0]).")";
                } else {
                    $age = "";
                }
                $birthdayspreview .= " $lic $user[username]$age - $bburl/member.php?action=getinfo&userid=$user[userid]\n";
                $lastbirthday = $user[birthday];
            }
            $birthdayspreview .= "\n\n";
        }
    } 


[tubedogg]

Due to some personal/computer problems (namely my hard drive trying to eat itself) this is not going to be out for a while. I am setting a target of the end of January but no promises.

[Gutspiller]

I installed this hack and have two problems.

Problem 1: The icon for the post is a dead image link, you know the white with the red X. That's what I am getting on the post. I set it to also post the update to a post, and that's when it gives this error.

Problem 2: I have a user (a mod in fact) that has a }{ and in the update that was posted into a thread it did this:






-- Threads with the most replies --

Title: "Ye' ol' Word Association Thread (aka Noum's house)" (posted 09-05-2001 by BenTech)
o 2065 replies, 6548 views, last post: 06:23 PM, 01-03-2002 by Giraffe }---------------------------------------------------------------------------
To unsubscribe from the community updates, click this link:
http://www.TheForumz.com/forumz/mem...ion=editoptions
and change "recive community updates" from yes, to no.

Currently, community updates are sent weekly.
---------------------------------------------------------------------------
Best regards, The TheForumz.com Administrators.





So it started that line of ---- without finishing his name. Can this be fixed? It looks like it cutout most of the actual message, because I set each block to ten posts and it didn't do it, so I think his name caused it to not show MOST of the community update.

Can somebody please help me on this?

Thanks in advance.

[xug]

Dear tubedogg or somebody else !!

Can you help me with the following:

I use this generator also to mail a weekly newsletter with several articles in it made by my members.
There is also a game review in this newsletter.

What I want and my members too, that I can submit graphics with the articles in this newsletter to all my members.

I think that the picture(s) doesn't need to be actual submitted in this newsletter, maybe with a link trick where the pictures are on my server so that they still show up in the newsletter.
I hope you understand what I try to ask here.

Please help me out on this, we want this option so badly.

[trainer]

any news on the next release? maybe someone else can take over where these guys left off if they don't have time to finish it up

[xug]

When I go to my edit panel to unselect the option of getting this bulletin I don't see any dot in the circle of the radio button, when I click on it the dot will be placed, after storing the settings and going back to the edit panel the dot is gone !

Anybody has an idea where this error could be ?

[aldamon]

2.2.3 approved!

[DarkReaper]

tubedogg...where's the new release?