Template:Blog/Content: Difference between revisions

From A3! Wiki
Enllyn (talk | contribs)
m Reverted edits by Enllyn (talk) to last revision by Krhs
Tag: Rollback
Yukari25mbcms (talk | contribs)
Try to remove extra space between blog author and blog title
Line 32: Line 32:
|commentchara={{{commentchara|}}}
|commentchara={{{commentchara|}}}
|orderno={{{orderno|}}}
|orderno={{{orderno|}}}
|translator={{{translator|}}}
|translator={{{translator|}}} }}<span id="Blog-{{{number|}}}"></span>{{#switch: {{{type|}}}  
}}<span id="Blog-{{{number|}}}"></span>{{#switch: {{{type|}}}  
| Blog = <!-- CODE FOR BLOGS GOES HERE --> {{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=Blog_List.chara = chara|where=Blog_List.number = {{{number|}}} |limit=1|more results text=|format=template|template=Blog/Container|named args=yes}}
| Blog =
<br><span style="font-size:150%">{{{title|}}}</span><br>
<!-- CODE FOR BLOGS GOES HERE -->
{{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=Blog_List.chara = chara|where=Blog_List.number = {{{number|}}} |limit=1|more results text=|format=template|template=Blog/Container|named args=yes}}
==={{{title|}}}===
'''Viewing Period:''' {{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=IF(ISNULL(Blog_List.enddate) = 1,Blog_List.startdate,CONCAT(Blog_List.startdate,' to ', Blog_List.enddate))|where=Blog_List.number = {{{number|}}} }}
'''Viewing Period:''' {{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=IF(ISNULL(Blog_List.enddate) = 1,Blog_List.startdate,CONCAT(Blog_List.startdate,' to ', Blog_List.enddate))|where=Blog_List.number = {{{number|}}} }}
{{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=IFNULL(CONCAT('<br /><b>Unlock: </b>', Blog_List.unlockby),'') = unlock|where=Blog_List.number = {{{number|}}}|limit=1|more results text=}}
{{#cargo_query: tables=Blog_List, Blog_Content|join on=Blog_List.number = Blog_Content.number|fields=IFNULL(CONCAT('<br /><b>Unlock: </b>', Blog_List.unlockby),'') = unlock|where=Blog_List.number = {{{number|}}}|limit=1|more results text=}}

Revision as of 13:08, 24 April 2021

This template defines the table "Blog_Content". View table.

{{Blog/Content
|number=
|type=Blog/Comment
|title=
|content=
|commentchara=
|orderno=
|translator=
}}