vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Updated Community Bulletin Generator (https://vborg.vbsupport.ru/showthread.php?t=16290)

Cold Steel 06-18-2001 03:36 AM

This is great.

Thanks!!!!

tubedogg 06-18-2001 04:06 AM

Quote:

Originally posted by Byron
Will adding the new field to user database cause any conflict in future vb release?
Not unless this hack becomes part of vB itself, in which case Kier or I (or somebody) will try to make sure that some sort of contingency exists for those that already installed it.

Quote:

Just in case if we do not want to use this script after adding the new field to user database, how do we revert back any changes to the database?
DROP receivebulletin FROM user;
Run that query from telnet or phpMyAdmin.

Quote:

Hope that hack will appear in the next vb release.
Maybe. ;)

Byron 06-18-2001 04:38 AM

Thanks tubedogg!

VirtueTech 06-20-2001 02:42 PM

The hack installed great, but when ever I try and run the hack...it timesout.....I have over 150 forums, maybe that is why.

Too bad...I really want to use it. :(

tubedogg 06-21-2001 10:17 AM

Does it timeout after the first screen or when going to send emails?

Dave# 06-21-2001 09:11 PM

ooops - ignore

mjames 06-22-2001 01:58 AM

Kevin,

Thanks for this wonderful hack. I went through all the steps and got to the part where I can specify when it goes out, to who, etc., but I got the "There seems to have been a slight problem with the database..." error and this e-mail:
Quote:

Database error in vBulletin Control Panel: Invalid SQL: SELECT * FROM user WHERE SUBSTRING(birthday,6)>='06-21' AND SUBSTRING(birthday,6)<='07-05' ORDER BY SUBSTRING(birthday,6) LIMIT 0,10
mysql error: You have an error in your SQL syntax near 'SUBSTRING(birthday,6) LIMIT 0,10' at line 1
mysql error number: 1064
Date: Thursday 21st of June 2001 10:51:46 PM
Script: /community/boards/admin/commbull.php
Referer: http://www.sports-central.org/commun...n/commbull.php
Any idea? Thanks!

tubedogg 06-22-2001 06:04 AM

Unfortunately that's a limitation of some older versions of MySQL that don't allow sorting by substring. For right now the workaround is to set birthdays to 0 and not send them until I can figure out some other way to do it. :(

Dave# 06-22-2001 08:58 AM

Damn I am having problems:

I have set the comm to only use data from the 1st of June onwards but look at the dates in this snip from the preview.

NB dates are in European format date:month:year

Quote:

Title: "Bruce is New Manager!!!" (posted 05-06-2003 by CM_Addicted)
o 249 replies, 575 views, last post: 09:41 AM, 31-05-2001 by DiscoDaveyf
o http://forums.cpfc.org/showthread.php?s=&threadid=8875

Title: "One word answer; Who would you like to take over from AS??" (posted 05-03-2002 by Eddie McGoldrick's tash)
o 217 replies, 17 views, last post: 07:00 PM, 15-05-2001 by BJ
o http://forums.cpfc.org/showthread.php?s=&threadid=8701

Title: "Redundancies" (posted 03-01-2003 by BarryBee)
o 207 replies, 0 views, last post: 11:00 PM, 25-03-2001 by wedgetail
o http://forums.cpfc.org/showthread.php?s=&threadid=7444

Title: "Jordan has seen enough" (posted 03-12-2001 by ruediger)
o 207 replies, 0 views, last post: 03:11 PM, 12-03-2001 by Bintang
o http://forums.cpfc.org/showthread.php?s=&threadid=7195

Title: "Fans Forum" (posted 05-12-2001 by GreatGonzo)
o 198 replies, 24 views, last post: 01:34 PM, 12-05-2001 by GreatGonzo
o http://forums.cpfc.org/showthread.php?s=&threadid=8660

Title: "Why I'm an eagle" (posted 09-05-2002 by Dave)
o 189 replies, 522 views, last post: 02:51 PM, 18-06-2001 by SAMO*
o http://forums.cpfc.org/showthread.php?s=&threadid=1952

Title: "Supporters of Austin & Harrison" (posted 02-09-2001 by fieldy)
o 164 replies, 0 views, last post: 12:50 AM, 10-02-2001 by Tarby
o http://forums.cpfc.org/showthread.php?s=&threadid=6699

Title: "One word (two if necessary) to describe how you feel at the moment" (posted 04-06-2003 by markholmes1991)
o 160 replies, 12 views, last post: 10:31 PM, 30-04-2001 by Mr_Optimistic
o http://forums.cpfc.org/showthread.php?s=&threadid=8259

Title: "Alan Smith - a correction" (posted 04-08-2002 by James)
o 158 replies, 5 views, last post: 02:58 PM, 20-04-2001 by Wandering Seagull
o http://forums.cpfc.org/showthread.php?s=&threadid=7909

Title: "Jordan's latest folly?" (posted 02-08-2001 by James)
o 158 replies, 0 views, last post: 11:39 PM, 08-02-2001 by JohnA
o http://forums.cpfc.org/showthread.php?s=&threadid=6694


tubedogg 06-22-2001 09:08 AM

Double-check that you have "Only include threads that have been started or replied to since this date?" set to Yes. It is set to No by default.


All times are GMT. The time now is 03:57 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.01489 seconds
  • Memory Usage 1,748KB
  • 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
  • (5)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