vb.org Archive - forum post widget that needs an evaluation

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

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - forum post widget that needs an evaluation (https://vborg.vbsupport.ru/showthread.php?t=232091)

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], 0, 2); //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!

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(title, 10) >= $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], 0, 2); /* 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();

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01050 seconds Memory Usage 1,739KB 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 (4)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: