vb.org Archive - Community Bulletin Email Generator + HTML

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Community Bulletin Email Generator + HTML (https://vborg.vbsupport.ru/showthread.php?t=32129)

christec

11-03-2001 10:00 PM

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

MarkB

11-04-2001 09:25 PM

It comes up with raw html when I receive it in Outlook... any ideas?:(

|DarkManX|

11-05-2001 12:11 AM

works good on my end....thanks :)

Neo	11-05-2001 12:17 AM

example? i am not sure what this does.. something with email right

FWC	11-05-2001 12:18 AM

This is great! The webmaster wanted HTML. The best part is the HTML works in Outlook Express. I tried a bunch of programs that didn't. Very nice! :D

|DarkManX|

11-05-2001 12:18 AM

Quote:

Originally posted by neo
example? i am not sure what this does.. something with email right

whats your email and i'll send you a copy of what it sends...

Neo	11-05-2001 01:37 AM

twilightstar0@hotmail.com

|DarkManX|

11-05-2001 02:14 AM

ya got mail neo....btw you never got back to me on that top5 hack that you modified.........

christec

11-05-2001 01:11 PM

Quote:

Originally posted by MarkB
It comes up with raw html when I receive it in Outlook... any ideas?:(

It's a setting in Outlook. Not sure where it is but Outlook will convert html to text.

cyrus

11-05-2001 03:38 PM

i dont see any install instructions anywhere. Can somene point me in the right direction ? thanks

christec

11-05-2001 03:41 PM

Copy the commbull.php file to your forums/admin directory.

Access the commbull.php file through a web browser
http://www. yoursite.com/forums/admin/commbull.php

It will show the install instructions

cyrus

11-05-2001 04:38 PM

thanks
done
like it
BUT

To unsubscribe from the Community Bulletin Email, click unsubscribe. In the user control panel change "Recive Community Bulletin Email" from yes, to no.

typo : receive

thanks

aldamon

11-05-2001 05:04 PM

WOW! Thanks! I swear we get some truly amazing results on this board when more than one person works on a hack!

RobAC

11-05-2001 10:06 PM

I received the following error when I set it to send out emails to 1000 users at a time:

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /pathway/commbull.php(692) : eval()'d code on line 484

It sent out 800 emails and then quit. I have no way of emailing the rest of my members from that point on.

christec

11-06-2001 01:42 AM

1000 email at once, (:eek: )

Quote:

Maximum execution time of 30 seconds exceeded

You received this error because it took longer that 30 seconds to process this script and email.

In the php.ini file there is a max_execution_time = 30 (limit in seconds).
You can increase the time limit to something higher.

RobAC

11-06-2001 01:48 AM

Yeah I realized that afterwards. I'm curious....how would AOL users receive the Community Bulletin with the HTML code in it?

tamarian

11-06-2001 02:12 AM

Great hack Christec!

Any thoughts of setting an option for Txt vs Html for members' options?

FWC	11-06-2001 05:27 AM

Quote:

Originally posted by RobAC
Yeah I realized that afterwards. I'm curious....how would AOL users receive the Community Bulletin with the HTML code in it?

Works fine with AOL users. I've tried it.

Prince

11-06-2001 03:08 PM

When you edit a user's profile in the CP the "Receive Community Bulletin Email?" field is not there.

christec

11-06-2001 03:14 PM

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="{secondaltcolor}"><normalfont><b>Receive Community Bulletin Email?</b></normalfont></td>
<td bgcolor="{secondaltcolor}"><normalfont>
<input type="radio" name="receivebulletin" value="yes"$receivebulletinchecked> Yes
<input type="radio" name="receivebulletin" value="no"$receivebulletinnotchecked> No
</normalfont></td>
</tr>

Prince

11-06-2001 03:17 PM

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

11-06-2001 04:08 PM

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

11-06-2001 04:19 PM

Quote:

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

11-06-2001 04:31 PM

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

christec

11-06-2001 04:39 PM

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

Here ya go :stoned:

Prince

11-06-2001 04:51 PM

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

christec

11-06-2001 05:10 PM

Quote:

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

11-06-2001 05:47 PM

Quote:

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

11-06-2001 08:30 PM

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

11-06-2001 08:34 PM

Did it work for you? I got:

Quote:

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

Prince

11-06-2001 08:40 PM

Yes, it worked perfectly for me! :)

Steve Machol

11-06-2001 08:46 PM

It was a file permission problem for me. Once I chmod'd it, it worked perfectly!

DarkReaper

11-07-2001 02:06 AM

To make excluding forums easier, would it be possible to have the forums shown in a hierarchial view, instead of a straight down list?

Littlebit

11-07-2001 02:47 PM

Installed great! But how did you get it readable for aol users in html? I'm using my aol browser and it's not converting for me. What's the trick?
Nice hack btw
Could there be an easy way to put a send as text option if I can't get it to work with aol?

christec

11-08-2001 03:15 PM

Bug:
All calendar events on the same day are not being displayed in the community bulletin email.

To fix the bug
Find This:

PHP Code:


		
			
while ($event = $DB_site->fetch_array($events)) {

     if ($event[eventdate] != $lastdate) {

Replace With this:

PHP Code:


		
			
while ($event = $DB_site->fetch_array($events)) {

     if ($event[eventdate] != $lasteventdate) {

Littlebit

11-08-2001 03:40 PM

I thought I read that it worked fine for one of you guys using +html with AOL users. It's not working fine on my end and I would love to be able to just make some alterations rather then uninstall it all together.
Can anyone help me out with getting the html mailings to work with AOL? :?:
Thanks!
P.S. Christec...thanks for the bug fix!

christec

11-08-2001 03:50 PM

Can you send me a copy of the html email.
elric_red@hotmail.com

Littlebit

11-08-2001 03:57 PM

you have mail....its in need of modifications for AOL users to not see the html code...I just don't know how

christec

11-08-2001 04:35 PM

Here is a link that talks about AOL email client programs.
http://www.wilsonweb.com/wmt6/email-client-summary.htm
AOL version 4.0 and 5.0 do not support HTML
AOL version 6.0 only supports standard HTML

You can try upgrading AOL to the latest version 7.0 (I think)

The original Community Bulletin Email Generator outputs its data in text format.

You can get that here
https://vborg.vbsupport.ru/showthrea...threadid=16290

christec

11-08-2001 04:40 PM

For those of you who need both text and html here's a thought.
You can install the original Community Bulletin Generator and the HTML version. Just rename the html version to something other the commbull.php like html_commbull.php. You will also need to modify the admin/index.php file to include a link to generate both versions. Now you can send both version by using the same input data. Of course you will have to fill out both forms.

I have not tested this yet. It's just a thought.

All times are GMT. The time now is 02:03 PM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03120 seconds Memory Usage 1,824KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: