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 |
#2
|
|||
|
|||
or alternatively, which piece of PHP generates the single day view seen inside the context of the forums?
|
#3
|
|||
|
|||
Checking back to see if anyone can help me out with this one. Stumped.
|
#4
|
||||
|
||||
want this as well.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|