The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Vbulletin calendar sql for single day
I'm looking to add a capture of "todays events" from my forum calendar to my site home page. I'm able to query the sql for one-off events no problem, but I don't quite understand how the other fields are used to cope with recurring events.
Something like this shows event id & title for the single day events Code:
select eventid, title, date_format(from_unixtime(dateline_from + 86400),"%c-%d-%Y") as start, dateline_to as to_days, IF (dateline_to = 0, 1, 0) as singleday from event WHERE to_days(from_unixtime(dateline_from)) = (to_days(curdate()) -1) order by eventid desc |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|