vb.org Archive - CommBull (Community Bulletin)

Page 6 of 12

« First

Last »

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

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

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - CommBull (Community Bulletin) (https://vborg.vbsupport.ru/showthread.php?t=66334)

jluerken

12-30-2004 01:37 PM

Ok I found the problem.

If you have photopost installed DO NOT include this part into your global.php
http://www.photopost.com/members/for...ght=stylesheet

wirewolf

12-30-2004 02:06 PM

Quote:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<link rel="stylesheet" type="text/css" href="http://yoursite.com.net/bulletincssfolder/vb.css" /> //hard code in your stylesheet - I copied my defalut forum sheet, renamed it as vb.css, and placed it in a different folder - note full url - did same with full url to my logo too - see below
</head>
<body> 
<img border="0" src="http://yoursite.com/bulletincssfolder/logo.jpg" width="80" height="80">  <a href="{$vboptions['bburl']}">
{$lang['mailsubject']}</a>

Once you have established your site sytlesheet enough, you shouldn't have to make too many changes to this commbull email html sheet. Even if you do, just recopy your new forum sheet, naming it as the vb.css, and replace the old vb.css one.
I played enough with this stylesheet and logo thing, and I found this to be the easiest answer. You have to remember, the user is calling for the stylesheet and logo from their email client, not directly from your site.
John

sabret00the

12-30-2004 03:57 PM

Quote:

Originally Posted by jluerken

Is there a way to send out a newsletter automatically once every 1 of a month?

The template says: Currently, community updates are sent weekly.
Is this really done automatically or do I have to change this text?

where does it say that? it is hardcoded though and not automatically.

sabret00the

12-30-2004 03:58 PM

Quote:

Originally Posted by jluerken

Ok I found the problem.

If you have photopost installed DO NOT include this part into your global.php
http://www.photopost.com/members/for...ght=stylesheet

i've got zachery's version of that installed, hence why i could use css at files even for this.

sabret00the

12-30-2004 04:00 PM

Quote:

Originally Posted by wirewolf

Guys, don't mess with your forum stylesheets for the commbull html mail. Leave your current storage alone system for your forum. (uness you want to change it for your forum itself). As for the commbull email html calling for a stylesheet, you make a copy of your default stylesheet, rename it (something like - vb.css, as I did), place it in a different folder outside of your forum's directory ( I out it in a folder in my site root, also did the same for my forums' logo), and then in the html preview section of the commbull.php file, type in the full url path to these two files.:
example:
http://yoursite.com/bulletincssfolder/vb.css
http://yoursite.com/bulletincssfolder/logo.gif
Around line 318:

Once you have established your site sytlesheet enough, you shouldn't have to make too many changes to this commbull email html sheet. Even if you do, just recopy your new forum sheet, naming it as the vb.css, and replace the old vb.css one.
I played enough with this stylesheet and logo thing, and I found this to be the easiest answer. You have to remember, the user is calling for the stylesheet and logo from their email client, not directly from your site.
John

you shouldn't even need to do that, if you're storing css as files and have a large enough image, then your email client will download the stylesheet (with the help of zachery's hack) automatically, else it will use it as part of the page generation at which rate you get it anyway.

jluerken

12-30-2004 04:09 PM

Quote:

Originally Posted by sabret00the

where does it say that? it is hardcoded though and not automatically.

Its in the commbull phrases file but I don't see a sheduled task or something like this which will run the commbull really once a week.

wirewolf

12-30-2004 04:20 PM

Editing the html email in the commbull.php file.
In the commbull.php file look for (line numbers are approx.):

Quote:

// line 44
// get css file// comment out
//$sql = "SELECT * FROM ". TABLE_PREFIX."style WHERE userselect > 0 LIMIT 1";
//$cssrow = $DB_site->query_first($sql);
//$css = $cssrow['css'];
// add full site url to gradients, etc in css
//$css = str_replace(' url('," url({$vboptions['bburl']}/",$css);

//line 309
//$uselogo = $cbgLogo ? "<img src=\"$cbgLogo\">" : ''; // comment out

// line 317
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> // start here!!
<html>
<head>
<link rel="stylesheet" type="text/css" href="http://yoursite.com.net/folder/vb.css" /> //hard code in your stylesheet - I copied my defalut forum sheet, renamed it as vb.css, and placed it in a different folder - note full url - did same with full url to my logo too - see below
</head>
<body> 
<img border="0" src="http://yoursite.com/folder/logo2.jpg">  <a href="{$vboptions['bburl']}">
{$lang['mailsubject']}</a> 
<table class="tborder" width="80%" cellpadding="6" cellspacing="1"> // note table width - you have to set this in about four places as you will see in the other tags below
<tr>
<td class="alt1Active">$extramaterial_parsed</td>
</tr>
</table>
 
<table class="tborder" width="80%" cellpadding="6" cellspacing="1">
<tr>
<td class="tcat" colspan="2">
Current Forum Activity</td> //typed this phrase in directly - planning to add a phrase variable
</tr>
<tr>
<td class="alt1Active">$lang[todaysdate] $todaysdate1. {$lang['activitysincede']} $todaysdate2 $lang[activitysince]</td>
</tr>
</table> 

// line 359
$HTML_footer = "$lang[tounsubscribe]
<a href=\"{$vboptions['bburl']}/profile.php?do=editoptions\">{$lang['unsubscribelink']}</a>. //didn't change anything here except for language
$lang[changeprofile]
 
$lang[bestregards] </body></html>";

// line 513 - the other sections - most replies, most views, etc. follow this format. it's the table width that counts here.
<table class="tborder" cellspacing="2" cellpadding="6" width="80%">
<tr>
<td class="tcat" colspan="7">{$lang['latestthreads']}</td>
</tr>
<tr class="alt1Active">
<td>{$vbphrase['title']}:</td>
<td>{$vbphrase['thread_starter']}:</td>
<td>{$lang['threadstartdate']}:</td>
<td>{$vbphrase['replies']}:</td>
<td>{$vbphrase['views']}:</td>
<td>{$vbphrase['last_post']}:</td>
<td>Last Post by:</td> // typed in directly. planning to add a phrase variable
</tr>

// line 918
<table class="tborder" border="0" width="80%"> // note width
<tr class="tcat">
<td>{$lang['upcoming_events']}: <a href="http://yoursite.com/forum/calendar.php?">Click here to
view this Months' Calendar</a></td> // note hard code to calendar
</tr>

// line 1064
<table border="0" class="tborder" width="80%"> // note width
<tr class="tcat">
<td colspan="2">{$vbphrase['user']} {$vbphrase['info']}:</td>
</tr>
<tr class="alt1">
<td>{$lang['userdetails']}</td>
</tr>
<tr class="alt1">
<td>{$lang['yourusername']}: "\$username"</td>
</tr>
<tr class="alt1">
<td><a href="{$vboptions['bburl']}/login.php?do=lostpw">{$lang['forgotpass']}?</a></td>
</tr>
<tr class="alt1">
<td>{$lang['youhave']} \$posts {$vbphrase['posts']}</td>
</tr>
<tr class="alt1">
<td>{$lang['youregistered']} \$joindate</td>
</tr>
<tr class="alt1">
<td>{$lang['yourlastactivity']} \$lastactivity</td>
</tr>
</table>

Try to keep the html email simple and as small (file size) as possible. Users get pissed (as I do) with over sized html emails. Mine is only about 15 kb's
I didn't mess around with the poll sections. I only have three on my forum, and thay don't update much. But if you want to edit the html for these, or any part of the html, just look in the commbull.php file for any <table>, <tr>, <td> start tags.
Basically, the html output is a bunch of table structures, but they are spread out in the commbull.php file. I'm going to experiment with making a commbull html email template with the variables in it, and just have the commbull.php script call it up. Language changes are easy, just go to the commbull_phrase.php file (thinking of switching that over to phrase variables too!)
As always, MAKE and save a copy of the file prior to editing. Make your changes a little at a time, then send the bulletin to yourself (admin) and take a look. I must have sent myself at least twenty before I was satisfied.

Here's my how my final edit html email bulletin looks like:
http://shipmodeling.net/forumnewsletter.html

wirewolf

12-30-2004 04:32 PM

Quote:

Originally Posted by sabret00the

Haven't seen zachery's hack. What does it do?
I didn't feel like muking around with other files. This works quite nicely. I do have my froum css's stored as in file (s). My image is small too.

CtrlAltDel

01-02-2005 01:36 AM

thanks man, great to have this back on the vb3 board

rex_b

01-03-2005 05:38 PM

I have this hack installed and it has been working but now whenever I send something it thinks for a minute then brings up a page saying "The page cannot be displayed" . Any ideas on what is going wrong?

sabret00the

01-03-2005 05:55 PM

Quote:

Originally Posted by wirewolf

Haven't seen zachery's hack. What does it do?
I didn't feel like muking around with other files. This works quite nicely. I do have my froum css's stored as in file (s). My image is small too.

basically makes sure you can use full urls's for on-file stylesheets :)

Quote:

Originally Posted by rex_b

have you installed any hacks since this?

rex_b

01-03-2005 06:07 PM

To be frank, I have no idea. I'm sure I have. Should I just reinstall this?

sabret00the

01-03-2005 06:10 PM

Quote:

Originally Posted by rex_b

To be frank, I have no idea. I'm sure I have. Should I just reinstall this?

would be a good idea :)

worth a try anyhoo.

trackpads

01-06-2005 01:07 PM

I really want to keep using this but so many of my emails seem to keep getting blocked by spam blockers like Yahoo I instead decided to send it out via PM. The problem is that there is no VBcode option.

Is there a way to make the text version (or html) format for vbcode so I could the mass pm hack to send this out instead?

thanks again,

-Jason

sabret00the

01-06-2005 01:38 PM

Quote:

Originally Posted by trackpads

you could convert the block that makes a new thread so it sends out pm's instead :shrug:

Pseudomizer

01-06-2005 01:41 PM

Quote:

Originally Posted by sabret00the

you could convert the block that makes a new thread so it sends out pm's instead :shrug:

Or just use the Mass PM Hack for VB and copy and paste the preview email from this hack into the PM field to all users. :classic:

Cheers,

jackiewill

01-16-2005 01:43 PM

My Comm Bull has never shown up in my Admin CP although it works well. How can I get it to show up in my Admin CP?

I was able to send one out but now that time has passed I can't remember how I did it!! Sorry to be such a sclub.

Thanks,
JW

sabret00the

01-16-2005 02:04 PM

in your admincp/index.php

find

PHP Code:


		
			
        construct_nav_group($vbphrase['users']);

    }

    // ***

    if (can_administer('canadminpermissions'))

    {

and above it add

PHP Code:


		
			
        construct_nav_option($vbphrase['commbull'], 'commbull.php', '<br />');

memobug

01-16-2005 07:09 PM

Quote:

Originally Posted by jackiewill

1. You might have never actually completed the installation. There are links at the top and bottom of commbull.php when you run it that are in a small font and hard to see, mixed in with the credits. Either of those links will install the phrases and put commbull in your admincp

2. You might just have a hard time finding it. It's in the admincp User menu, if you expand it and look toward the bottom.

Regards,

Matt

H2k	01-17-2005 06:18 AM

Hello

After Installing this hack .. i check the Profile .. ther eis one options is blank ihave attach the Pic u can see it blow..

other think i try to send Mailling .. and i t send only for 100 user and i have over then 10000 user why it dont send for all .. it just show me

100

and ALL DONE

and retern me to the Admin Page . :ermm:

sabret00the

01-17-2005 07:46 AM

the second bit, i have no idea what you're on about, but the reason the option wasn't installed was because you never installed the phrases correctly, repease the installtion steps.

Pseudomizer

01-17-2005 09:06 AM

Quote:

Originally Posted by H2k

Depends to what group of people you are sending it to. You can choose this in the configuration menu. If you have done this for all groups and its still sending it only to 100 people then i would check the total number of emails per page and if you have activated the automatic javascript next page option. Perhaps you have disabled javascript in your browser.

Hope this helps.

Cheers,

internetjunkie

01-19-2005 10:58 PM

Quote:

Originally Posted by memobug

Well, I did not have that problem (you are expanding the Users block and not just looking beneath it) but if you go into Languages&Phrases under it you will see Search In Phrases and in there you can type in commbull (two mm!), click Phrase Text AND Variable name and see if anything comes up.

For instance, if you click receive_email_from_commbull you should see the phrase "Receive Community Bulletin Newsletter (Approximately 1 per month)" which, by the way is a question someone was asking here. Sometimes if you simply Save it with no changes it will fix up the phrases. I don't know why.

particularly you want to be sure you have this:

Control Panel Global Phrases Containing 'commbull'
Varname $vbphrase[commbull]
Text Send Community Bulletin

Hope that helps. Sorry it is not a problem I had so I am a little amiss as to how to fix it.

Regards,

Matt

that worked for me as well. thank you very much!!!

skizzy203

01-20-2005 10:42 AM

I dont think that my phrases installed correctly either because I had both issues with the installation: memobugs "community bulletin option" not showing up in admin CP. - It constructs the table, but there is no text in the table because the phrase is not available (installed correctly).

Can someone check on this as I have noticed that there are a few people that are having this problem and it should be resolved so that everyone can take advantage of this excellent hack.

Fixing this "phrase installation issue" would address the concerns about the blank subscription options in the user profile.php as it is refrencing phrases that aren't installed as well.

- As for the phrases being installed, there is not an option to do this once your files are online, i go to click install instructions and get the following:

Code:

User table altered... Failed (Possibly already updated)

User table altered... Failed (Possibly already updated)

Phrase table updated (profile.php 1 of 3)...Already Update

Phrase table updated (profile.php 2 of 3)...Already Update

Phrase table updated (profile.php 3 of 3)...Already Update

Phrase table updated (admincp/index.php) ...Already Update

When I search for commbull in the phrase manager, I only find 3 phrases...

How can I reinstall just the phrases without manually adding them all..

- Nevermind... I went back into those 3 phrases and resaved without editing them as suggested memobug... now the options show up.

Sidenote: I would really like to see someone come up with a solution to the "Upcoming Events" issue as well because this feature would be very useful on my bulletin because I post many car events.

Reeve of shinra

01-26-2005 08:10 PM

Question: we are creating our own weekly newsletter. We're adding alot of hot stuff, whats going on around the forum, etc and some of the info in this hack would be a perfect compliment. Is it possible to output the info on a page, so our staff can copy/paste it into thier thread rather than emailing it out to everyone? Thanks!

Pseudomizer

01-26-2005 08:27 PM

Quote:

Originally Posted by Reeve of shinra

Sure. It should work like this:

- Create a hidden forum where your staff has access
- Create a user for the newsletter with access to this forum
- in the commbull options check the create a thread with user blabla in subforum xyz
- uncomment in the commbull PHP file the mail command

Solution: Thread will be created, your staff can copy and paste it wherever they want, and no emails will be sent out

Cheers,

Reeve of shinra

01-27-2005 01:54 AM

Simple enough =) Thanks.

jzewatsky

01-27-2005 11:28 PM

Great Hack.... I too had an issue with Admin CP phrase not showing up and found that it was actually there, it was just covered by the box around it. Searching for the phrase and saving it again brought it into view....same for the user CP. I'll be watching this thread for additons specifically a way to select a certian number of threads out of a specific forum and the ability to automate the bulletin...great hack.

Viks	01-29-2005 03:09 PM

Having issues with Events and Calender not showing up in bulletins.. if anyone knows how to fix.. please share!

thanks

Vik

LadyBeth

01-29-2005 03:17 PM

We have that issue also... :(

LadyBeth

01-30-2005 12:49 PM

We also have problems emailing since updating to 3.0.6 and readding the hack. It used to work. Now even set as low as 50 users we get the following....see attached.

I really love this hack and really need it to work again. Please help.
Thank you so very much!!! :)

LB~

iSpanish

01-30-2005 11:38 PM

Nice hack

installed when i using vB 3.0.1

and now using 3.0.6

*installed*

LadyBeth

01-31-2005 12:08 PM

Please help...really want this hack to work again.
LB

joeychgo

01-31-2005 01:24 PM

I jsut installed it on 3.06 last night - smooth install

Viks	01-31-2005 01:51 PM

Hi guys,
I do not show upcoming event in the CommBull newsletter. im running vB3.0.3. My settings are ok..i've checked that.

As per this thread there is an known issue with events not showing up in the newsletter. Has anyone been able to fix that??!?

thanks,

Viks

tormodg

01-31-2005 06:13 PM

Quote:

Originally Posted by Viks

Works fine in 3.0.6.

*clicks install*

tormodg

01-31-2005 06:14 PM

Sorry, didn't mean to quote Viks. I forget that the quick reply creates a quote in this forum. :devious:

tormodg

02-01-2005 06:48 PM

Hm...it worked fine during testing with my mods and admins, but when I start sending out the commbull to all my members, I have to set the limit to 5 per page to avoid a 30 second timeout (default at my host).

After 3 pages I get this error:

Quote:

Warning: Division by zero in \admincp\commbull.php on line 1127
Sending mail to users .... .... (page 1/0)

The previous page read "page 3/165". I have about 880 members.

What is causing this?

tormodg

02-01-2005 06:49 PM

Ah...here is the MySQL error:

Quote:

Invalid SQL: SELECT * FROM vb_user WHERE receivebulletin=1 AND IF (options & 16,1,0)=1 AND usergroupid IN(2,3,5,6,7,18) LIMIT 0,
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

mysql error number: 1064

tormodg

02-01-2005 06:54 PM

Took out this bit and now it works:

Quote:

AND IF (options & 16,1,0)=1

This is the check for "receive admin emails".

All times are GMT. The time now is 04:05 AM.

Page 6 of 12

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01709 seconds Memory Usage 1,876KB 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 (1)bbcode_code_printable (2)bbcode_php_printable (20)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: