vb.org Archive

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)

Toneboy 11-07-2004 09:58 PM

Yeah, the option was there previously. I'll check the links when I get a moment.

A readme.txt file in with the .zip file might be a useful addition to this hack.

Cheertobi 11-09-2004 02:18 PM

Hi,

did someone know how to fix the event & birthday problem?

Also the "last topic" on forum home is not shown, when sending the newsletter into a selected forum...

Regards,

Tobias

Europeanlee 11-10-2004 11:49 AM

I just want to confirm that this hack still currently works with VB 2.3.2?

Regards,

Lee

Toneboy 11-10-2004 12:00 PM

Versions of this hack for vB 2.*.* are here:
https://vborg.vbsupport.ru/showthread.php?t=32129 and
https://vborg.vbsupport.ru/showthread.php?t=16290

In regard to the vB3 version I'm going to take a look through the installation instructions tonight and make sure I've changed all the templates appropriately. I missed that before, so apologies for that.

One last request: with the new thread style here this hack is currently shown as mod version 1.0.0. On my script this is shown as "Community Bulletin Email Generator version 2.4" - could the mod version be changed so that we can refer back to here to see if we're using the most up-to-date version of this hack? Thanks.

Toneboy 11-10-2004 05:52 PM

Okay within the installation instructions I see the initial message:
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

I've made the edits as shown below that, and I now have the Community Bulletin option back on the user's options page, but I only have a checkbox and no text where I presume the format of the message is meant to be?

Still nothing under the links within the admincp either - by the looks of things that it is to do with the phrases. What exactly should I be looking to edit there?

By the way, if it helps I went into the properties of my user table and it shows the following.
Code:

CREATE TABLE user (
  userid int(10) unsigned NOT NULL auto_increment,
  usergroupid smallint(5) unsigned NOT NULL default '0',
  username varchar(50) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  styleid smallint(5) unsigned NOT NULL default '0',
  parentemail varchar(50) NOT NULL default '',
  homepage varchar(100) NOT NULL default '',
  icq varchar(20) NOT NULL default '',
  aim varchar(20) NOT NULL default '',
  yahoo varchar(32) NOT NULL default '',
  usertitle varchar(250) NOT NULL default '',
  customtitle smallint(6) NOT NULL default '0',
  joindate int(10) unsigned NOT NULL default '0',
  daysprune smallint(6) NOT NULL default '0',
  lastvisit int(10) unsigned NOT NULL default '0',
  lastactivity int(10) unsigned NOT NULL default '0',
  lastpost int(10) unsigned NOT NULL default '0',
  posts int(10) unsigned NOT NULL default '0',
  timezoneoffset varchar(4) NOT NULL default '',
  pmpopup smallint(6) NOT NULL default '0',
  avatarid smallint(6) NOT NULL default '0',
  options int(10) unsigned NOT NULL default '0',
  birthday varchar(10) NOT NULL default '0000-00-00',
  maxposts smallint(6) NOT NULL default '-1',
  startofweek smallint(6) NOT NULL default '1',
  ipaddress varchar(15) NOT NULL default '',
  referrerid int(10) unsigned NOT NULL default '0',
  receivebulletin smallint(5) unsigned NOT NULL default '1',
  pmtotal smallint(5) unsigned NOT NULL default '0',
  pmunread smallint(5) unsigned NOT NULL default '0',
  passworddate date NOT NULL default '0000-00-00',
  salt char(3) NOT NULL default '',
  showvbcode smallint(5) unsigned NOT NULL default '0',
  msn varchar(100) NOT NULL default '',
  avatarrevision int(10) unsigned NOT NULL default '0',
  membergroupids varchar(250) NOT NULL default '',
  displaygroupid smallint(5) unsigned NOT NULL default '0',
  reputation int(11) NOT NULL default '10',
  reputationlevelid int(10) unsigned NOT NULL default '1',
  languageid smallint(5) unsigned NOT NULL default '0',
  threadedmode smallint(5) unsigned NOT NULL default '0',
  emailstamp int(10) unsigned NOT NULL default '0',
  autosubscribe smallint(6) NOT NULL default '-1',
  birthday_search date NOT NULL default '0000-00-00',
  receivebulletin_type smallint(5) unsigned NOT NULL default '1',
  PRIMARY KEY  (userid),
  KEY usergroupid (usergroupid),
  KEY username (username),
  KEY birthday (birthday),
  KEY birthday_search (birthday_search)
) TYPE=MyISAM;

I take it that's correct?

memobug 11-10-2004 06:00 PM

Quote:

Originally Posted by Europeanlee
I just want to confirm that this hack still currently works with VB 2.3.2?

Regards,

Lee

No, it doesn't You want to go back and search on COMMBULL and find one of the vb2.x.x versions. the one I was using way back was not a hack (it didnt' change or modify any vb scripts) but a standalone called commbull.php that went in the admin folder. It worked great for what it was. Actually it worked better than this 3.x.x version, which doesn't actually do events, birthdays or let the admin select specific posts to include in the newsletter.

Regards,

Matt

wirewolf 11-10-2004 06:23 PM

Quote:

Originally Posted by Cheertobi
Hi,
did someone know how to fix the event & birthday problem?.............................
Regards,
Tobias

Ditto. No one seems to have an answer for this. Please someone! :disappointed:
I finally had to add a hard coded link in the html version for my forums' calendar for the users to click.

memobug 11-11-2004 12:36 AM

EVENTS

I have taken a crack at fixing the event problems. They are related to the fact that the database as of 3.0.3 now has the dates stored as an integer timestamp (big number) and this combull script expects them to be stored as a MM-DD-YYYY date format. There is also an issue related to the fact that there are now start and end dates associated with each event, and a separate issue related to the possible existence of private calendars.

If someone wants to PM me with their email address I can send instructions on how to modify the script to print events. This will help debug it. If you can't use an editor to modify the script and test the results, please don't bother PM'ing at this point. This is for debugging purposes only. I will send you a piece of code that replaces the CALENDAR section of commbull.php. It is ugly because it has the existing lines commented out with corrections inserted. We'll test it then clean it up before publishing it.

BIRTHDAYS

Birthdays are more messed up. The storage order MDY changed around and the script also has a bug in it that would prevent it from working properly if the birthday window (30, 60 days) wrapped a year end. I got it printing the current month's birthdays, but with 3500+ users, there is basically no point for me in taking the birthday thing any further. I am not going to acknowledge 300+ birthdays in the monthly newsletter anyway.

I suspect that there is a way to reuse code from the forumhome to do that, I might look at it if I have the chance but I have a lot of important things pressing.

PLEASE CONTACT ME BY PM ONLY, so we don't clutter this thread until we have a solution. Include your EMAIL address if you want code to test.

Regards,

Matt

grandeur_69 11-13-2004 04:15 PM

hi everyone ... i'm going to look into fixing some of these bugs, including all the calendar stuff, but i am currently traveling/working in Europe and won't be back till January. I now have it running on over 30 vB's (all on a couple of our servers) and it works really well ... we send out about 100,000 mailouts between all the forums.

dethfire 11-14-2004 11:01 PM

Quote:

Originally Posted by grandeur_69
hi everyone ... i'm going to look into fixing some of these bugs, including all the calendar stuff, but i am currently traveling/working in Europe and won't be back till January. I now have it running on over 30 vB's (all on a couple of our servers) and it works really well ... we send out about 100,000 mailouts between all the forums.

grandeur_69 thanks, my 13k member forum still times out before preview

memobug 11-15-2004 02:44 AM

Quote:

Originally Posted by dethfire
grandeur_69 thanks, my 13k member forum still times out before preview

Does it preview ok if you deselect the Registered members and just leave Admins or Moderators?

Regards,

Matt

dethfire 11-15-2004 05:51 AM

Quote:

Originally Posted by memobug
Does it preview ok if you deselect the Registered members and just leave Admins or Moderators?

Regards,

Matt

yeah it works if I uncheck registered

sfowler39 11-18-2004 03:29 PM

How do we make this an automation procedure? Can this be a schedule task to run weekly or daily or monthly? This question has been asked now 3 times.

grandeur_69 11-18-2004 04:14 PM

currently there is no way to run it automated ... at least i haven't tried a way ... i guess the easiest way would be to use a javascript.submit if a certain value is passed through the url ... but, this could cause security issues as you would have to disable the check if you are logged in and someone could send out your newsletters whenever they want ...

... anyone have some other ideas?

joeychgo 11-19-2004 09:36 PM

one wish- is that I can send it only to specific usergroups ---

Pseudomizer 11-20-2004 12:33 AM

Quote:

Originally Posted by joeychgo
one wish- is that I can send it only to specific usergroups ---

Please install the hack and then go into the options and just use them. This feature is already implemented.

Cheers,

NorwayKid 11-20-2004 12:46 AM

hi there,
great hack but i think it still can be improved much, like having a WYSIWYG editor for the extra text, and also having the forums header also, and also to have the latest topics of the news forums shown out completely not just as links,

by the way how can i uninstall this hack !

regards and thank you for a good job.

SilverBoy 11-22-2004 05:14 AM

how I can add this script to Scheduled Tasks to work one time at a week, and seending only 100 email at once (coz of server resources).

grandeur_69 11-22-2004 02:10 PM

there is no uninstall, but if the extra tables in your database don't bother you, just delete the commbull files from the /admincp/

SilverBoy ... please read prevous posts ... this question has been brought up way 2 many times

joeychgo 11-23-2004 09:14 AM

How about the ability to send a TEST email out?

welo 11-23-2004 09:20 AM

Quote:

Originally Posted by joeychgo
How about the ability to send a TEST email out?

Assign yourself to your own usergroup, uncheck everyone else, send test email.

joeychgo 11-23-2004 09:40 AM

I guess that would work -- thanks for the idea.

I think I found a bug --- at least I might have --

If I store my CSS as a file - I lose the style in the newsletter -

grandeur_69 11-23-2004 11:09 AM

yea, i actually just discovered that myself ... as 99.9% of the users of vB don't do this, it's not something i was in a rush to fix

joeychgo 11-23-2004 09:07 PM

Quote:

Originally Posted by grandeur_69
yea, i actually just discovered that myself ... as 99.9% of the users of vB don't do this, it's not something i was in a rush to fix


I found it cuz im also trying to speed up my board

welo 11-23-2004 09:19 PM

This should help with that. :)

futureye 11-24-2004 08:20 AM

can any body write here
the modify the profile.php

but the steps are not clear to me
am adminstarting an arabic site
right to left

grandeur_69 11-25-2004 08:03 AM

permanent fix for using css as a file:
in includes/adminfunctions_template.php

find:
Code:

if (preg_match('#^<link rel="stylesheet" type="text/css" href="(clientscript/vbulletin_css/style-\w{8}-0*' . $styleid . '\.css)" />$#', $csscontents, $match))
replace with:
Code:

if (preg_match('#^<link rel="stylesheet" type="text/css" href="'.$vboptions['bburl'].'/(clientscript/vbulletin_css/style-\w{8}-0*' . $styleid . '\.css)" />$#', $csscontents, $match))
and, find:
Code:

$QUERY[] = "css = '" . addslashes("<link rel=\"stylesheet\" type=\"text/css\" href=\$cssfilename\" />") . "'";
replace with:
Code:

$QUERY[] = "css = '" . addslashes("<link rel=\"stylesheet\" type=\"text/css\" href=\"{$vboptions['bburl']}/$cssfilename\" />") . "'";
cheers

welo 11-25-2004 01:53 PM

Tested and confirmed. Thanks man. Works like a charm.

Toneboy 12-04-2004 06:58 PM

Another question (different from my usual, recurring one!), which template do you need to edit to change some of the standard text?

Specifically I want to permanently change the line, "Currently, community updates are sent weekly." to "Currently, community updates are sent monthly."

Thanks.

grandeur_69 12-05-2004 01:05 PM

you'll find all the phrase information in the file commbull_phrases.php

docvader 12-05-2004 05:10 PM

Installed quite easily. Excellent job to all who contributed.

docvader 12-06-2004 12:44 AM

It's working great. Truly impressive. But, one question, and it really isn't important; I was just curious. I've got five styles on my board, one parent, four children. The email goes out in the parent style, which was my old default style. Is there any way of sending it out using one of the children's styles, which also happens to be my current "default" style???

CSS59 12-07-2004 11:05 PM

installed and I am almost done. but I can't figure this out:

Quote:

Go into phrase manager, search for 'commbull' and update
What do you mean by update?

I cant see "Send Comm Bull" in my cp

memobug 12-08-2004 12:12 AM

The combull is in the USERS part of AdminCP
The Phrase Manager is a different tool, used to manage phrases, also in AdminCP

Regards,

Matt

CSS59 12-08-2004 12:36 AM

Quote:

Originally Posted by memobug
The combull is in the USERS part of AdminCP
The Phrase Manager is a different tool, used to manage phrases, also in AdminCP

I understand matt, however, I am having this problem:

Quote:

Upload admin/index.php and profile.php to your server, then go to your Admin CP and look for the "Send Community Bulletin" option under "Users" If you find that the option isn't showing up on the control panel, then it's because you aren't using the default phrases. Go into phrase manager, search for 'commbull' and update.
I do not see it under USERS so I must go into the phrase manager and update? Im not sure how this update is done?

memobug 12-08-2004 06:46 AM

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

CSS59 12-08-2004 12:32 PM

Quote:

Originally Posted by memobug
. Sometimes if you simply Save it with no changes it will fix up the phrases. I don't know why.

Thank you! I went and edited each one saving w/o changes and now it works :) thank you

Viks 12-08-2004 11:38 PM

I am going to instal this hack on my forum.

- Can anyone here pls let me know if is this works ok with vB3.0.3?
- also do i need to back any other file besides profile.php and admincp/index.php?

- any known issues with vb 3.0.3? sorry but cant really go through all 10 pages of messages.

I did come across few post where users were having issues with vb3.0.3! question - does it come with uninstaller as well?

docvader 12-09-2004 04:45 AM

I had no problem installing it on 3.03. It was easy, and it functions superbly.

memobug 12-09-2004 06:05 PM

Quote:

Originally Posted by Viks
I am going to instal this hack on my forum.

- Can anyone here pls let me know if is this works ok with vB3.0.3?
- also do i need to back any other file besides profile.php and admincp/index.php?

- any known issues with vb 3.0.3? sorry but cant really go through all 10 pages of messages.

I did come across few post where users were having issues with vb3.0.3! question - does it come with uninstaller as well?

There are some issues with operation, but not many problems with installation. Mainly, the coming events and birthdays don't work under vb3.0.3 You just don't get anything. I also documented a minor bug affecting the sort of one of the listings

For your own education & safety, you should really read through the past posts before installing a hack. Ten or twelve pages is almost nothing. Some of the more popular hacks have many, many more.

I would backup my database. The stock vb scripts you can restore quite easily.

Regards,

Matt


All times are GMT. The time now is 11:56 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01779 seconds
  • Memory Usage 1,847KB
  • 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
  • (6)bbcode_code_printable
  • (13)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