[Euskadi]

It's part of a vBulletin script so while it's not 'pure' PHP I'm sure someone au fait with the language will be able to understand it.

Basically it is code which checks a calendar for events, and outputs the following event complete with a countdown timer. The problem is that it seems to overlook an event if it is the following day, for example even though there is an event on the calendar on tomorrow's date, it thinks the next event is the one after that (next weekend).

ob_start();
global $db,$vbulletin;
$event_calendarid="2";
$no_events_message="<div style='width: 100%; text-align: center; font-weight: bold'>TBA</div>";
$today_date = mktime(0, 0, 0, date(date("m")), date((date("d"))),  date(date("y")));
$and=" and dateline_from > '".$today_date."'";

$getevents=$db->query_read("SELECT eventid, title, dateline_from from " . TABLE_PREFIX . "event WHERE calendarid='".$event_calendarid."' $and order by dateline_from ASC LIMIT 2");
$count=1;
if(!$db->num_rows($getevents))
{
echo $no_events_message;
} 
else
{
echo "<script type='text/javascript'>\n";
WHILE ($events=$db->fetch_array($getevents))
{
$event_title=$events['title'];
$event_date = vbdate('U',$events['dateline_from'], false,true,false,true)-vbdate('U');
if($count==1)
{
echo "var CountDownTimer=new CountDown('CountDownToChange',1,'".$event_title."<br />','".$event_date."','ywdhms',1)\n";
}
else
{
echo "CountDownTimer.AddNewEvent('".$event_title."<br />','".$event_date."','ywdhms',".$count.")\n";
}
$count++;
}
}
echo "CountDownTimer.DisplayTime(FormatResults)\n";
echo "</script>\n";
$db->free_result($getevents);
unset($events);
$output=ob_get_contents();
ob_end_clean();

How could I change this so it recognises not only tomorrow's events, but also today's i.e. if there is an events scheduled for today's date, it will display that.

Thanks

[CTphpnwb]

Did you write this code? If you did, why can't you make this simple change?

[Euskadi]

CTphpnwb, on 10 February 2012 - 09:51 AM, said:

Did you write this code? If you did, why can't you make this simple change?

Uh, no I didn't.. that's why I'm asking for help?

[CTphpnwb]

This forum is for people looking to learn more about writing PHP code. If you want code written for you then you should try the Post a Job forum.

[Euskadi]

CTphpnwb, on 10 February 2012 - 10:18 AM, said:

This forum is for people looking to learn more about writing PHP code. If you want code written for you then you should try the Post a Job forum.

As I'm sure you can see, the code is already written. I'm asking for help understanding it so I can solve my problem.

Thanks once again for your helpful input.

[CTphpnwb]

As I'm sure you've read, the rules of the forum require that you show some effort. You need to do more than post code you didn't write. Show us what you've tried, and why you think it hasn't worked.

[e_i_pi]

Euskadi, on 11 February 2012 - 06:12 PM, said:

...I'll go elsewhere

My first suggestion would be the vBulletin forums.

This post has been edited by e_i_pi: 11 February 2012 - 02:02 PM

[JackOfAllTrades]

I've hidden your profanity-laden reply. Note in the future that when you're working with a third-party product such as vBulletin you're always likely to get better help at the source, to which the brilliant e_i_pi has pointed you. The majority of us have no earthly idea how some proprietary function like vbdate() works, which seems pivotal to your issue.

[e_i_pi]

He could have, of course, had a cursory glance at the code and changed this line:

$and=" and dateline_from > '".$today_date."'";

...to this...

$and=" and dateline_from >= '".$today_date."'";

...but I guess that would have been asking a bit much of his precious time.