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


All times are GMT. The time now is 09:50 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.01621 seconds
  • Memory Usage 1,758KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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