Community Bulletin Email Generator + HTML

First off this is Kier's hack and it's a great one. There are other contributors like tubedog.

Update 16-Nov-2001:
Include News Article(s) in bulletin
Optional - Add "Receive Community Email Bulliten" option to the admin CP. When editing a user you can turn on and off the bulletin.
Fixed lasteventdate bug

These changes are based on version 0.98
Changes/Additions
Preview includes html tags
Email is sent in an HTML format
Post to thread is HTML
Updated install to include changes for vBulletin v2.2
Private Forums marked No by default (if accessmask is ON)
Password removed - Link to Forgot your password added

Installation is still the same. If you already have commbull.php installed you can just copy this file to the same location.

(I'm not trying to take any credit for this hack. Just share the modifications that I made.)
Always backup and test.
CC

[Prince]

I did that, but when you edit a user in the CP it does not show up. It only shows when you go to your own profile.

[patvdv]

Lovely extension on a great hack but why not also add the obvious? Add another selection to the USER CP to indicate whether a user wants to receive the bulletin in either TXT or HTML format? And send the email out accordingly?

[Prince]

Originally posted by christec
In the install instructions you will see this (add this field to the users cp)

modifyoptions template
You will need to add this code to an appropriate place in your modifyoptions template:

<tr>
<td bgcolor="#1C5780"><normalfont><b>Receive Community Bulletin Email?</b></normalfont></td>
<td bgcolor="#1C5780"><normalfont>
<input type="radio" name="receivebulletin" value="yes"$receivebulletinchecked> Yes
<input type="radio" name="receivebulletin" value="no"$receivebulletinnotchecked> No
</normalfont></td>
</tr>

Look at this screen shot of the CP:

[Prince]

I'm trying to create the e-mail to generate "most recently posted", and it is giving threads that are 2 months old.....?

[christec]

Add Receive Community Email Bulletin field to Admin CP, under "Edit User"

Here ya go :stoned:

[Prince]

okay, but what about the fact that the hack does not produce the correct dates?
It makes it quite useless.

[christec]

Originally posted by Prince
I'm trying to create the e-mail to generate "most recently posted", and it is giving threads that are 2 months old.....?

The order that you put the thread blocks in and this option -
Reuse threads gathered for this block?
Will affect the output.

[Prince]

Originally posted by christec


The order that you put the thread blocks in and this option -
Reuse threads gathered for this block?
Will affect the output.

I'm not sure what you mean....

All I am trying to do is one block (the first block) I put 10 and select "most recently posted". Using the date: 11-01-2001

It spits out threads that 2-3 months old, and I mean threads that have not been replied to for 2-3 months.

AND it is saying that some posts were posted in the year 2003!...which is what seems to be the problem.

Any ideas????

[Prince]

Save as ubbdatefix.php, upload to admin directory and run in browser.

(back-up your database first!!!)

PHP Code:

<?
require("./global.php");
if (!isset($action)) {
    echo("This script will correct the dates on threads which were imported from UBB5.4x. Make sure you backup your database before proceeding!<br>");
    echo("If you have a backup, <a href="fixubbdate.php?action=doconvert">click here</a> to proceed.");
}
if ($action=="doconvert") {
  $threads=$DB_site->query("SELECT MIN(post.postid),post.dateline AS dateline,post.threadid AS id,thread.threadid FROM post,thread WHERE post.threadid=thread.threadid GROUP BY thread.threadid ORDER BY thread.threadid ASC");
  echo("Line inserted on purpose<br>Rows in result: ");
  echo(mysql_num_rows($threads));
  while ($thread=$DB_site->fetch_array($threads)) {
    $DB_site->query("UPDATE thread SET dateline='$thread[dateline]' WHERE threadid='$thread[id]'");
    echo(mysql_affected_rows());
    $i++;
    if ($i==50) {
        echo("Updated another 50 threads...continuing<br>");
        $i = 0;
    }
  }
} else {
  echo("Done.");
}
?>

[Steve Machol]

Did it work for you? I got:

Warning: Failed opening '/home/smachol/public_html/forums/admin/fixubbdate.php' for inclusion (include_path='') in Unknown on line 0