vb.org Archive - News & Email Community Bulletin Generator

Page 1 of 6

Last »

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)

- - News & Email Community Bulletin Generator (https://vborg.vbsupport.ru/showthread.php?t=32517)

christec

11-18-2001 10:00 PM

Updated 30 Nov 2001
Fixed a typo and Birthday Date Bug
---------------------------------------------

Here's a new version of the Community Bulletin + HTML
With the changes and the inclusion of the news section I have
titled it News and Email Community Bulletin Generator.

Here's a list of the changes/modifications that were made

Include News Articles (Threads) in bulletin.
Remove vbCode from news articles before sending email.
User email options include HTML or Text.
Forums are sorted by displayorder.
Category forums do not contain yes/no option.
Private forums marked as no by default.
Fix lasteventdate bug.
Modify admin/index.php installation instructions for version 2.2.x and version 2.0.x.
Include Admin CP edit user option to include Receive Community Email Bulletin and Type (HTML or TEXT).
Remove user password, send link instead.
Preview of HTML and TEXT email.
Post to Forum can be HTML or TEXT
Modified a few mysql SELECT * queries to include only necessary fields.
Cosmetic changes
......

To install
Copy the commbull.php file to the admin/ directory.
WIth a web browser access the commbull.php file.

Example: http: //yoursite.com/forums/admin/commbull.php

Follow the additional installation instructions.

This hack is based on Community Bulletin Generator by Kier
and additional Community Bulletin Generator functions by Kevin

Additional: This hack has only been tested on my machines. I don't have the ability to send emails
to a lot of users so this has not been tested either.

Remember: BACKUP and TEST.
213

FWC	11-19-2001 05:45 PM

Cool! I'll have to try this when I get home from work tonight. :)

Princeton

11-19-2001 07:50 PM

GREAT JOB! I was hoping for a text or html version.

thank you and keep up the great work.

FWC	11-19-2001 07:52 PM

I lied. I installed it during lunch. Excellent job!! :D

DarkReaper

11-19-2001 09:35 PM

Does this display the forums in a straight list or in a hierarchy?

Robert Basil

11-20-2001 12:26 AM

Well,

I told you in the other thread I'm not ready to give up on this hack. :)

I gave up on the script not being able to add the fields in my user table so I added them myself using these commands (Yes, it worked fine)

Code:

ALTER TABLE user ADD receivebulletin SMALLINT (5) UNSIGNED DEFAULT '1' not null

Code:

ALTER TABLE user ADD receivebulletin_type SMALLINT (5) UNSIGNED DEFAULT '1' not null

Then I made the changes according to the admin_commbull.txt

I then accessed the commbull.php via the web and yes, it FINALLY asked me for my admin username and password (This was my stumbling block with the old version)

I entered my username and password and then got the screen stating:

"User tables have been altered sucessfully.

Installation instructions for the News and Email Community Bulletin Generator. "

So I made all of the changes according to this file. And then I clicked on the "Go" button at the bottom of the page.

And....... nothing. :( The same install page just keeps repeating itself when I click on the "Go" button.

Sooooo close..........

Any ideas?

christec

11-20-2001 02:17 AM

Quote:

Originally posted by DarkReaper
Does this display the forums in a straight list or in a hierarchy?

Hierarchy, just like the list is displayed in the modify forum section, Sorted by Categories, but listed in a straight line.

christec

11-20-2001 02:19 AM

Quote:

And....... nothing. The same install page just keeps repeating itself when I click on the "Go" button.

Have you tried the link through the Admin CP

Robert Basil

11-20-2001 02:40 AM

Quote:

Originally posted by christec

Have you tried the link through the Admin CP

Yes, it just keeps repeating itself there also.

christec

11-20-2001 02:44 AM

Quote:

Originally posted by Sportbikeworld

Yes, it just keeps repeating itself there also.

How about www.yoursite.com/forums/admin/commbull.php?&action=info

DarkReaper

11-20-2001 02:50 AM

I already have the first version of this installed, what should I do to upgrade?

christec

11-20-2001 02:57 AM

Upgrade instructions
Copy the new commbull.php file over your existing (backup your old one first) one.
Access the commbull.php either through the Admin CP or directly through web browser.
Installation will appear and install new user table field.
Read the installation instructions. There are some additional fields to be added. Mainly for the "user option to select html or text" in a template and the member.php file.
For additional Admin options see the attached admin_commbull text file.

christec

11-21-2001 08:27 PM

Quote:

Originally posted by Sportbikeworld

Yes, it just keeps repeating itself there also.

PROBLEM SOLVED

christec

11-22-2001 05:57 AM

In general, any comments or feedback?

FWC	11-22-2001 07:35 AM

Quote:

Originally posted by christec
In general, any comments or feedback?

This hack is wonderful!! The only feature left I could imagine asking for is remembering settings. Seriously, this is great work. I know you built upon a great hack, but your contribution shouldn't be underestimated.

People who are using earlier versions of this have no idea what they are missing. :)

amykhar

11-22-2001 10:37 AM

Thank you :) it was a nice upgrade.

Working fine and installation was a snap.

Amy

JJR512

11-23-2001 08:37 PM

Quote:

Originally posted by christec
In general, any comments or feedback?

Yes. Is there an easy way to change the appearance of the HTML email sent out? Some easy way to change the colors, fonts, etc. Maybe make it take these things from the board's own styles.

amykhar

11-23-2001 10:01 PM

I noticed a SIGNIFICANT improvement in how many people actually came to check out the board because of the bulletin.

I have been sending out the old style bulletin for months, with pretty decent results. However, the new style brought in people that haven't logged on in ages. And they stuck around to read stuff instead of just going to the control panel to turn off the bulletin option.

Nice job :)

Amy

christec

11-23-2001 10:14 PM

Quote:

Originally posted by JJR512

Yes. Is there an easy way to change the appearance of the HTML email sent out? Some easy way to change the colors, fonts, etc. Maybe make it take these things from the board's own styles.

It is pretty much hard coded. I wanted to keep the html output to a minimum. There are some color variables in the commbull.php file to change the colors. Just look for this section.

// HTML Color Variables
$cbgLink = "";
$cbgVLink = "";
$cbgALink = "";
$cbgTitleText = "#41344A";
$cbgTableHead = "#626194";
$cbgTHFontColor = "#FFF788";
$cbgTableCategory = "#A4A1CD";
$cbgTableCells = "#E7E7F1";

centris

11-24-2001 01:19 PM

Great update, the html bulletin looks awsome, thanks guys.

RobAC

11-24-2001 08:08 PM

The admin_commbull.txt file is in binary code in the zip file. I've downloaded it twice and I get the same thing.

centris

11-24-2001 08:44 PM

Quote:

Originally posted by RobAC
The admin_commbull.txt file is in binary code in the zip file. I've downloaded it twice and I get the same thing.

sorry wrong file

centris

11-24-2001 08:50 PM

Commbull txt file;

RobAC

11-24-2001 09:07 PM

I installed this hack and tested it out. Nice job! However, just a couple things. Towards the top of the bulletin in front of one of the table tags is an extra { that shouldn't be there.

Also....towards the bottom, Recieve should be Receive. :D Would also be nice to see the total number of registered members in the Stats section. Other than that, looks great. Thanks!

christec

11-24-2001 10:07 PM

These extra " { and } " brackets that you're seeing are used to remove text when you post the bulletin to a forum. They are also removed when the bulletin is emailed. Example. The script generates each users info, like posts, last time the user visited ... These brackets surround the user info so when the bulletin is posted to a forum the user information is removed. If you remove the brackets then the post in the forum will show the users stats from the user generating the email. It also removes the news articles sections when you post to a forum. There is no reason to maintain multiple copies of the news information.

These brackets are also explained in the "Preview Email" section under the Community Bulletin Generator. :)

Prince

11-28-2001 07:16 PM

Why are there NO instructions to add this hack?

All I see in the zip are the Admin CP instructions.

Am I missing something here???

FWC	11-28-2001 07:19 PM

Quote:

Originally posted by Prince
Why are there NO instructions to add this hack?

All I see in the zip are the Admin CP instructions.

Am I missing something here???

The instructions are in the installer that runs the first time you access the hack. Upload the file, edit your admin cp and run it. It will walk you through the rest.

christec

11-28-2001 07:22 PM

OK I will put install instructions on the first post.

To install
Copy the commbull.php file to the admin/ directory.
WIth a web browser access the commbull.php file.

Example: http: //yoursite.com/forums/admin/commbull.php

Follow the installation instructions.

That's it.
:)

Prince

11-28-2001 07:44 PM

Oh, okay.

I installed the older version before I upgraded my VB to 2.2.1 and I thought I remembered having to edit some files...maybe not.

christec

11-28-2001 07:46 PM

The files to edit are listed in the commbull install instructions, which are displayed when you access the commbull file through a web browser.

Sukij

11-30-2001 06:27 AM

Hi..

Got problem !!! The Age behind the name is shift down.. Normally, Benjapa(26), Duengpon(34).... etc.
Please help..

UPCOMING BIRTHDAYS:
December 3: Benjapa
December 5: Duengpon (26)
December 5: Busakorn Laohawiroj (34)

christec

11-30-2001 05:02 PM

Quote:

Originally posted by Sukij
Hi..
Got problem !!! The Age behind the name is shift down.. Normally, Benjapa(26), Duengpon(34).... etc.
Please help..

Birthday Fix:
Find This:

PHP Code:


		
			
if ($user[birthday] != $lastbirthday) {

    if ($datebits[0] != "0000") {

        $currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));

        $birthdayspreview .=" <tr>\n";

        $birthdayspreview .="  <td><font size=\"2\">$currentdate:  <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";

        $birthdayspreview .=" </tr>\n";

        // text mail option start

        $text_birthdayspreview .= "\n$currentdate:\n";

        // text mail option end

        $age = " (".($thisyear - $datebits[0]).")";

    } else {

        $currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));

        $birthdayspreview .= " <tr>\n";

        $birthdayspreview .="  <td><font size=\"2\">$currentdate:  <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";

        $birthdayspreview .=" </tr>\n";

        // text mail option start

        $text_birthdayspreview .= "\n$currentdate:\n";

        // text mail option end

        $age = "";

    }

}

Replace With This

PHP Code:


		
			
if ($user[birthday] != $lastbirthday) {

    if ($datebits[0] != "0000") {

        $currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));

        $age = " (".($thisyear - $datebits[0]).")";

        $birthdayspreview .=" <tr>\n";

        $birthdayspreview .="  <td><font size=\"2\">$currentdate:  <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";

        $birthdayspreview .=" </tr>\n";

        // text mail option start

        $text_birthdayspreview .= "\n$currentdate:\n";

        // text mail option end

    } else {

        $currentdate = date($calformat2, mktime(0,0,0,$datebits[1],$datebits[2],0));

        $age = "";

        $birthdayspreview .= " <tr>\n";

        $birthdayspreview .="  <td><font size=\"2\">$currentdate:  <a href=\"$bburl/member.php?action=getinfo&userid=$user[userid]\">$user[username]$age</a></font></td>\n";

        $birthdayspreview .=" </tr>\n";

        // text mail option start

        $text_birthdayspreview .= "\n$currentdate:\n";

        // text mail option end

    }

}

christec

11-30-2001 05:06 PM

News & Emil Community Bulletin Generator has been updated to fix a typo and the Birthday Date bug.

:)

JJR512

11-30-2001 05:46 PM

So just download the new .zip and upload the new commbull.php, and that's all there is? That will fix the problem Sukij mentioned, or do we still need to do what you said in Post 32?

christec

11-30-2001 05:49 PM

Quote:

Originally posted by JJR512
So just download the new .zip and upload the new commbull.php, and that's all there is? That will fix the problem Sukij mentioned, or do we still need to do what you said in Post 32?

YES, Just download the new .zip file and then upload the new commbull.php file.
That's it.

Steve Machol

12-01-2001 03:24 PM

Great hack! One problem though - it doesn't find my Super Moderators even though I choose to send to them. Any ideas?

DarkReaper

12-01-2001 04:15 PM

Would it be possible to have it remember settings? That would help a LOT.

Also, I spent about 5 minutes getting the settings right, then hit preview, forgot someting, hit back, and it was reset! :(

Steve Machol

12-02-2001 04:54 PM

I have a problem that I need help with. Although I set:

"Only include threads that have been started or replied to since this date? Note: Only applies to sections sorted by Most Replies or Most Views (others automatically adhere to above date)"

....to 'Yes', the choices for Most Replies and Most Views does not adhere to the date I choose. Instead it chooses them from the beginning. How can I fix this?

RobAC

12-02-2001 05:11 PM

Is there a way to set NO as the default for the forums selected in the admin panel when putting the bulletin together? I only select a few forums, so I end up having to click NO on most of the forums that I have.

christec

12-03-2001 03:50 PM

Quote:

Originally posted by smachol
I have a problem that I need help with. Although I set:

"Only include threads that have been started or replied to since this date? Note: Only applies to sections sorted by Most Replies or Most Views (others automatically adhere to above date)"

....to 'Yes', the choices for Most Replies and Most Views does not adhere to the date I choose. Instead it chooses them from the beginning. How can I fix this?

This option inlcludes the complete thread, not just the posts.
"Only include threads that have been started or replied to"

If a new thread is start on 1 May 2001 and the last post is 1 June 2001 and you select the date to be 25 May 2001, it will include this thread because of the last post being after 25 May.
Does that make sense?

All times are GMT. The time now is 11:47 AM.

Page 1 of 6

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01657 seconds Memory Usage 1,863KB 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 (2)bbcode_code_printable (2)bbcode_php_printable (13)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: