This day in History??

[oldfan]

im adding a bunch of tour dates to my calendar and like them to be displayed in a sidebar block.
Not upcoming dates, put just the day like this day in history?

[oldfan]

im adding a bunch of tour dates to my calendar and like them to be displayed in a sidebar block.
Not upcoming dates, put just the day like this day in history?

ob_start();
global $db,$vbulletin;

function get_string_between($string, $start, $end){
$chunk = explode($start, $string, 2);
if(count($chunk)==1) return "1";
$chunk = explode($end, $chunk[1], 2);
if(count($chunk)==1) return "";
return $chunk[0];
}

$mydate = mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$show_count = 10;
$query = sprintf(" SELECT * FROM ".TABLE_PREFIX."event
WHERE visible = 1
AND (dateline_from >= '$mydate' || (dateline_from >= '$mydate' AND dateline_to <= '$mydate' ) || ('$mydate' BETWEEN dateline_from AND dateline_to))
ORDER BY dateline_from ASC LIMIT $show_count");

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true));
} else {
$format = sprintf("%s to %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true),vbdate('jS M Y',$event['dateline_to'],false,true,false,true));
}


$gfx = get_string_between($event['event'], "[IMG]", "[/IMG]");

if($gfx == "1"){
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://metallifukinca.com/forum/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$event['title'],$format);
}
else
{
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<img src="%s" width="25" height="25" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/>
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://metallifukinca.com/forum/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$gfx,$event['title'],$format);
}
}
$output = $output_bits;

ob_end_clean();

is there a way for this code to only pull for upcoming this days in history?

[oldfan]

anyway to get this to show IE: april 15, 2023, april 15, 2022, april 15, 2021 on so on?

[oldfan]

Bumper

[glennrocksvb]

Try using this SQL query:

$query = sprintf("SELECT * FROM " . TABLE_PREFIX . "event
    WHERE visible = 1
    AND (
       (
            MONTH(FROM_UNIXTIME(dateline_from)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_from)) = DAY(NOW())
       )
       OR
       (
            MONTH(FROM_UNIXTIME(dateline_to)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_to)) = DAY(NOW())
       )​
    )
    ORDER BY dateline_from ASC LIMIT $show_count");​  

The above query checks if the event From or To date's month and day are the same as the current month and day.

[oldfan]

thanks, but I got server error 500.
I had to turn block off, to correct it

syntax error, unexpected '&', expecting end of file on line 25 in /home/james/public_html/forum/includes/block/html.php(95) : eval()'d code
#0 /home/james/public_html/forum/includes/class_block.php(130): vB_BlockType_Html->getData()
#1 /home/james/public_html/forum/includes/class_block.php(1088): vB_Block->getBlockHTML()
#2 /home/james/public_html/forum/includes/class_block.php(1101): vB_BlockManager->getBlockHTML(4, Array)
#3 /home/james/public_html/forum/forum.php(649): vB_BlockManager->getSidebarHTML()
#4 {main}

[glennrocksvb]

Did the error not come up before this change? Just trying to see if the error is caused by this change or not to localize where the error is coming from.

[oldfan]

pretty sure im adding it to right place

syntax error, unexpected '&', expecting end of file on line 25 in /home/james/public_html/forum/includes/block/html.php(95) : eval()'d code
#0 /home/james/public_html/forum/includes/class_block.php(130): vB_BlockType_Html->getData()
#1 /home/james/public_html/forum/includes/class_block.php(1088): vB_Block->getBlockHTML()
#2 /home/james/public_html/forum/includes/class_block.php(1101): vB_BlockManager->getBlockHTML(4, Array)
#3 /home/james/public_html/forum/includes/class_bootstrap.php(564) : eval()'d code(212): vB_BlockManager->getSidebarHTML()
#4 /home/james/public_html/forum/includes/class_bootstrap.php(564): eval()
#5 /home/james/public_html/forum/includes/class_core.php(4391): vB_Bootstrap->process_templates()
#6 /home/james/public_html/forum/includes/class_core.php(4349): vB_Template->__construct('vsa_onlinecount...')
#7 /home/james/public_html/forum/global.php(29) : eval()'d code(66): vB_Template::create('vsa_onlinecount...')
#8 /home/james/public_html/forum/global.php(29): eval()
#9 /home/james/public_html/forum/calendar.php(122): require_once('/home/james/pub...')
#10 {main}

[oldfan]

this is what i added

ob_start();
global $db,$vbulletin;

function get_string_between($string, $start, $end){
$chunk = explode($start, $string, 2);
if(count($chunk)==1) return "1";
$chunk = explode($end, $chunk[1], 2);
if(count($chunk)==1) return "";
return $chunk[0];
}

$mydate = mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$show_count = 10;
$query = sprintf("SELECT * FROM " . TABLE_PREFIX . "event
WHERE visible = 1
AND (
(
MONTH(FROM_UNIXTIME(dateline_from)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_from)) = DAY(NOW())
)
OR
(
MONTH(FROM_UNIXTIME(dateline_to)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_to)) = DAY(NOW())
)
)
ORDER BY dateline_from ASC LIMIT $show_count");
$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true));
} else {
$format = sprintf("%s to %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true),vbdate('jS M Y',$event['dateline_to'],false,true,false,true));
}


$gfx = get_string_between($event['event'], "[IMG]", "[/IMG]");

if($gfx == "1"){
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://metallifukinca.com/forum/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$event['title'],$format);
}
else
{
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<img src="%s" width="25" height="25" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/>
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://metallifukinca.com/forum/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$gfx,$event['title'],$format);
}
}
$output = $output_bits;

ob_end_clean();

[oldfan]

Did the error not come up before this change? Just trying to see if the error is caused by this change or not to localize where the error is coming from.

after I added code

[glennrocksvb]

What code editor are you using? There seems to be invisible characters found in the added code. When I copied your code and pasted and saved it in Visual Studio Code editor, I see this:



When I removed those invisible characters, the syntax error in line 28 went away.

[glennrocksvb]

Btw, you can use the [PHP] or [CODE] BBCode tags instead of [QUOTE] when posting code to preserve the indentation and make the code readable.

[oldfan]

What code editor are you using? There seems to be invisible characters found in the added code. When I copied your code and pasted and saved it in Visual Studio Code editor, I see this:



When I removed those invisible characters, the syntax error in line 28 went away.

i just open it up on notepad lol
ill download your editor and see if that works

[oldfan]

i used the editor and got this error

This page isn’t working


metallifukinca.com is currently unable to handle this request.

HTTP ERROR 500

and this is the code i imputted

ob_start();
global $db,$vbulletin;

function get_string_between($string, $start, $end){
    $chunk = explode($start, $string, 2);
    if(count($chunk)==1) return "1";
    $chunk = explode($end, $chunk[1], 2);
    if(count($chunk)==1) return "";
    return $chunk[0];
}

$mydate =  mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$show_count = 10;

$query = sprintf("SELECT * FROM " . TABLE_PREFIX . "event    WHERE visible = 1    AND (       (            MONTH(FROM_UNIXTIME(dateline_from)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_from)) = DAY(NOW())       )       OR       (            MONTH(FROM_UNIXTIME(dateline_to)) = MONTH(NOW()) AND DAY(FROM_UNIXTIME(dateline_to)) = DAY(NOW())       )    )    ORDER BY dateline_from ASC LIMIT $show_count");




$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

     if($event['dateline_to'] == 0 )
     {
         $format = sprintf("On %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true));
     } else {
         $format = sprintf("%s to %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true),vbdate('jS M Y',$event['dateline_to'],false,true,false,true));
     }


$gfx = get_string_between($event['event'], "[IMG]", "[/IMG]");

if($gfx == "1"){
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://test.com/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$event['title'],$format);
}
else
{
$output_bits .= sprintf('<div class = "cms_widget_post_bit"><a href="calendar.php?do=getinfo&e=%d">
<img src="%s" width="25" height="25" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/>
<h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>
<BR/>
<center><img src="http://test.com/images/misc/hz-line.png" alt="Upcoming Event" ;"></center>
</div>
<BR/>',$event['eventid'],$gfx,$event['title'],$format);
}
}
$output = $output_bits;

ob_end_clean();​  

[glennrocksvb]

What's the detailed error stack trace in the server error logs?