User:Messing with data/Sandbox: Difference between revisions

Some calendar test
 
Some styling and additional tables
 
Line 1: Line 1:
{{#cargo_compound_query:
{{#cargo_compound_query:
|tables=EventPeriods;where=Server='CN';fields=Title,Start,End,Event=_pageName,CONCAT('#4b884b')=color,Comment=description;text color=white;name=Title;start=Start;end=End
|tables=EventPeriods;where=Server='CN';fields=CONCAT(Title,' (CN)')=Title,Start,End,Event=_pageName,CONCAT('#4b884b')=color,Comment=description;text color=white;name=Title;start=Start;end=End
|tables=EventPeriods;where=Server='JP';fields=CONCAT(Title,' (JP)')=Title,Start,End,Event=_pageName,CONCAT('#4b4b88')=color,Comment=description;text color=white;name=Title;start=Start;end=End
|tables=EventPeriods;where=Server='EN';fields=CONCAT(Title,' (EN)')=Title,Start,End,Event=_pageName,CONCAT('#884b4b')=color,Comment=description;text color=white;name=Title;start=Start;end=End
|format=calendar}}
|format=calendar}}