Main Page: Difference between revisions

From BlazBlue Wiki
m (changed bbdw event tables to calculate event expiration based on dates and times standardized to jst)
m (use images in active events; fixed BBDW active event/gacha's current datetime calc - use 24hr clock when checking time)
Line 100: Line 100:
==Active and Upcoming Events==
==Active and Upcoming Events==
{{#cargo_query:table=BBDW_Events
{{#cargo_query:table=BBDW_Events
|fields=CONCAT('[[',_pagename,'|',nameen,']]')=Event Name
|fields=image2=img,CONCAT('250px')=width,CONCAT(_pagename)=imglink,CONCAT('[[',_pagename,'|',nameen,']] ',startdate,'~',enddate)=caption
,startdate=Start Date,enddate=End Date,featured_chars=Characters with Event Bonus
|where=eventtype='Event' and (((enddate+0) > {{#time:YmdHis|now+8 hours}}) or enddate IS NULL)
|where=eventtype='Event' and (((enddate+0) > {{#time:Ymdhis|now+8 hours}}) or enddate IS NULL)
|group by=_pagename
|group by=_pagename
|order by=startdate
|order by=startdate
|display=table}}
|format=template
|template=Icon
|named args=yes}}


==Active Gacha==
==Active Gacha==
{{#cargo_query:table=BBDW_Events
{{#cargo_query:table=BBDW_Events
|fields=CONCAT('[[',_pagename,'|',nameen,']]')=Gacha Name
|fields=image=img,CONCAT('250px')=width,CONCAT(_pagename)=imglink,CONCAT('[[',_pagename,'|',nameen,']] ',startdate,'~',IF(enddate IS NOT NULL,enddate,''))=caption
,startdate=Start Date,enddate=End Date,featured_chars=Characters on Rate Up
|where=eventtype='Gacha' and (enddate is NULL or ((enddate+0) > {{#time:YmdHis|now+8 hours}}))
|where=eventtype='Gacha' and (((enddate+0) > {{#time:Ymdhis|now+8 hours}}) or enddate IS NULL)
|group by=_pagename
|group by=_pagename
|order by=startdate
|order by=startdate
|display=table}}
|format=template
|template=Icon
|named args=yes}}
</div>
</div>
</div>
</div>

Revision as of 14:03, 1 April 2021