Template:Blog/Content: Difference between revisions
From A3! Wiki
Tag: Rollback |
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}} | |||
= | |||
'''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= }}