Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 01-03-2010, 09:44 PM
steven s's Avatar
steven s steven s is offline
 
Join Date: Aug 2004
Location: Greenville, SC
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default forum post widget that needs an evaluation

Could someone please evaluate the coding.
I don't know what I am doing, other than I got it to work.
I'd like to learn where I can improve it.

What it does.
This is used for a calendar of events widget on my CMS homepage.
http://www.nccbmwcca.org
Each event is a forum post that uses a thread prefix 'chapter event' and the title begins with MM/DD/YYYY -.

The script uses today() to find any post starting with today().
It also adds a <br /> between each month.
It's pretty convoluted, in my opinion.

PHP Code:
ob_start();

    
$output_bits '';
    
$today_m date("m");
    
$today_d date("d");
    
$today_y date("Y");
    
$spacer $today_m//used to separate months
  
    
$get_calendarofevents vB::$db->query_read("
        SELECT *
        FROM "
.TABLE_PREFIX."thread
        WHERE prefixid='Chapter_Event' AND LEFT(title, 2) >= 
$today_m AND MID(title, 4, 2) >= $today_d AND MID(title, 7, 4) >= $today_y
        ORDER BY title ASC"
);


      while(
$calendarofevents vB::$db->fetch_array($get_calendarofevents))
{
     
$str substr($calendarofevents[title], 02); //get month of event
 
if ( $str == $spacer )
{
    
$output_bits .='<a target="_blank" href="showthread.php?t='.$calendarofevent[threadid].'">'.$calendarofevents[title].'</a><br />';
}
    else
{
    
$output_bits .='<br /><a target="_blank" href="showthread.php?t='.$calendarofevents[threadid].'">'.$calendarofevents[title].'</a><br />';
}
    
$spacer $str;
}
      
$output $output_bits;
      
ob_end_clean(); 
Thanks!
Reply With Quote
  #2  
Old 01-07-2010, 11:19 PM
steven s's Avatar
steven s steven s is offline
 
Join Date: Aug 2004
Location: Greenville, SC
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I edited the script a bit.
Each thread found starts with MM/DD/YYYY -
I want to find only those threads that have today's date and future in the beginning of the title.

I thought I could create a variable
PHP Code:
$today  date("m/d/Y"); 
and use
PHP Code:
LEFT(title10) >= $today 
as part of my search criteria.
Obviously it does not work.
http://www.nccbmwcca.org

How can I find only from today and future?

PHP Code:
ob_start();
    
$output_bits '';
    
$today  date("m/d/Y");
    
$spacer date("m");
      
    
$get_schedule vB::$db->query_read("
        SELECT *
        FROM "
.TABLE_PREFIX."thread
        WHERE prefixid='Chapter_Event' OR prefixid ='other' AND LEFT(title, 10) >= 
$today
        ORDER BY title ASC"
);

     while(
$schedule vB::$db->fetch_array($get_schedule))
{

     
$str substr($schedule[title], 02); /* get month of event */

/* separates posts by month */     
     
 
if ( $str == $spacer )
{
    
$output_bits .='<a target="_blank" href="showthread.php?t='.$schedule[threadid].'">'.$schedule[title].'</a><br />';
}
    else
{
    
$output_bits .='<br /><a target="_blank" href="showthread.php?t='.$schedule[threadid].'">'.$schedule[title].'</a><br />';
}
    
$spacer $str;
}
/* done */

      
$output $output_bits;
      
ob_end_clean(); 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:09 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03518 seconds
  • Memory Usage 2,192KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete