Difference between revisions of "Schedule View"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
.LogRow:last-of-type td:nth-last-child(3) {border-radius:0px 0px 0px 5px} | .LogRow:last-of-type td:nth-last-child(3) {border-radius:0px 0px 0px 5px} | ||
.LogRow:last-of-type td:nth-last-child(1) {border-radius:0px 0px 5px 0px;} | .LogRow:last-of-type td:nth-last-child(1) {border-radius:0px 0px 5px 0px;} | ||
.LogCell:nth-child(odd) { word-wrap:break-word; text-overflow: ellipsis | .LogCell:nth-child(odd) { word-wrap:break-word; white-space: nowrap; text-overflow: ellipsis; overflow: hidden; max-height:1.5em; height:1.5em; display:block;} | ||
}} | }} | ||
{{#get_db_data: | {{#get_db_data: | ||
db=scenesys | db=scenesys | ||
|from= | |from=mush_scene | ||
|data=scheduleId= | |data=scheduleId=scene_id,scheduleTime=date_scheduled,scheduleTitle=title,scheduleDesc=pitch | ||
|where= | |where=date_scheduled > "{{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}}" | ||
|order by= | |order by=date_scheduled ASC | ||
|limit=20 | |limit=20 | ||
}} | }} | ||
Revision as of 22:14, 3 October 2017
For an actual calendar view (which can give you full scene briefings): CLICK HERE!
SCENE TIMES APPEAR IN GMT/UTC. You can use THIS page to help find yourself.
The query SELECT scene_id,date_scheduled,title,pitch FROM `mush_scene` WHERE date_scheduled > "2025-03-14" ORDER BY date_scheduled ASC LIMIT 20 is invalid (Error 1146: Table 'heroes.mush_scene' doesn't exist (localhost) Function: EDConnectorRdbms::fetch Query: SELECT scene_id,date_scheduled,title,pitch FROM `mush_scene` WHERE date_scheduled > "2025-03-14" ORDER BY date_scheduled ASC LIMIT 20 ).
| Title | Time | Description |
|---|