[Eq4bits]

I finally got mine to pull the 'current' date & it's events

FIND:

PHP Code:

ob_start(); 
global $db,$vbulletin; 
$calendarid="1"; 
$per_page = "10"; 


CHANGE TO:

PHP Code:

ob_start();
global $db,$vbulletin;
$mydate =  mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$calendarid="1";
$per_page = "10"; 


FIND:

PHP Code:

$getevents=$db->query_read("SELECT eventid, title, dateline_from from " . TABLE_PREFIX . "event WHERE calendarid='".$calendarid."' $and order by dateline_from ASC LIMIT $per_page"); 


CHANGE TO:

PHP Code:

$getevents=$db->query_read("SELECT * FROM ".TABLE_PREFIX."event WHERE calendarid='".$calendarid."' AND visible= '1' AND (dateline_from >= '$mydate' || (  dateline_from >= '$mydate' AND dateline_to <= '$mydate' )) ORDER BY dateline_from ASC LIMIT $per_page");