Next club night widget on the home page

[Darren]

Just a quick note that if the next club night it today, it shows the next club night as being in 2 weeks time

 

[TransAmDan]

Okey dokey, thanks for the info. I'll take a look.

This is the code for it.

ob_start();



// %d
$show_count = 4;


$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from >= '%d' || ( dateline_from >= '%d' AND dateline_to < '%d' )) AND title = 'Renegades Club Night' ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$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",date('jS M Y',$event['dateline_from']));
} else {
$format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
}

$output_bits .= sprintf('
<div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a rel="nofollow" href="calendar.php?do=getinfo&e=%d">%s</a></h4>
<p class="cms_widget_post_content">%s</p>
</div>
',$event['eventid'],$event['title'],$format);


}
$output = $output_bits;




ob_end_clean();

 

[sarah]

You just can't get the staff these days

 

[mummyjan]

:help:

Okey dokey, thanks for the info. I'll take a look.

This is the code for it.

Ah right, it all makes sense now NOT !!!

 

[Darren]

They like using sprintf a lot :noidea:

I'm guessing the date stored in the database for the dateline_from and dateline_to are correct, so any chance of adding an

echo "Test".TIMENOW."<br />";

between the $query = .... and $event_get = .... lines. Just interested in seeing what time it thinks now is. All things being correct, all the times should be set to UTC, so the functions should work fine and it would only be an hour out when we're in BST.

Also, any chance of running the sql directly in the database and putting up what it returns (along with the sql statement to compare the times).

 

[Darren]

Hehe, it's pretty easy really. It's just getting information from the database for an event named "Renegades Club Night" which is set to happen in the now or in the future and is a visible event. It then just adds formatting to display the information nicely

 

[Darren]

Just had a thought from looking at the calendar. If it's set purely on date, not date and time, it will do what it's doing as it will take the event as starting at midnight.