pathCast
Log in

Difference between revisions of "pathCast"

From pathCast
Line 3: Line 3:
 
<table style="width:100%"><tr><td style="background-color:#ffffff; width:44%">{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
<table style="width:100%"><tr><td style="background-color:#ffffff; width:44%">{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{#cargo_query:
 
{{#cargo_query:
tables=pathCast,pathCastBanners
+
tables=pathCast,pathCastFiles
|join on=pathCast._pageName=pathCastBanners.pathCast
+
|join on=pathCast._pageName=pathCastFiles.pathCast
 
|fields=
 
|fields=
 
,pathCast._pageName
 
,pathCast._pageName
 
,pathCast.title
 
,pathCast.title
,pathCastBanners._pageTitle
+
,pathCastFiles._pageTitle
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0  
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1
Line 46: Line 46:
 
{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{text|'''Upcoming lecture'''|||6|}}<br><br>
 
{{#cargo_query:
 
{{#cargo_query:
tables=pathCast,pathCastBanners
+
tables=pathCast,pathCastFiles
|join on=pathCast._pageName=pathCastBanners.pathCast
+
|join on=pathCast._pageName=pathCastFiles.pathCast
 
|fields=
 
|fields=
 
,pathCast._pageName
 
,pathCast._pageName
 
,pathCast.title
 
,pathCast.title
,pathCastBanners._pageTitle
+
,pathCastFiles._pageTitle
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0  
+
|where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1

Revision as of 18:33, 9 September 2020