The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
Double Damn!
I have on my site homepage a section where it displays the next episode of "Dark Angel" that is going to air, along with the time and a link to the episodes info in the episode guide.
The problem is that its stored on a US server, and I want to make it so that the time is offset by 5 hours so that the next episode shows up as soon as the current one is over. So with Dark Angel finishing at 10PM over here, at 10PM I want it to switch to the next episode in the table, rather than switching at 2am when its 10PM in the US. I managed to do this before somewhere but I deleted the damn file the other day and all I remember is I used DATE_ADD() to add on the offset amount of hours to the time so that it would change at the right time. Code:
"SELECT *, DATE_FORMAT(start,'%b-%d-%Y') as startdate, TIME_FORMAT(start,'%h:%i %p') as starttime, DATE_ADD(start, INTERVAL 5 HOUR) FROM ep_airdates WHERE ((stationID='1') AND (start > NOW())) ORDER BY start ASC LIMIT 1" Can anyone tell me what I am doing wrong please Matt |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|