TimelineData - Revision history

K'del at 20:44, 12 November 2015

2015-11-12T20:44:02Z

K'del at 20:43, 12 November 2015

2015-11-12T20:43:14Z

Bot at 06:21, 9 November 2015

2015-11-09T06:21:55Z

Bot at 06:07, 9 November 2015

2015-11-09T06:07:10Z

Bot at 06:03, 9 November 2015

2015-11-09T06:03:34Z

Bot: Protected "TimelineData" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))

2015-06-29T07:10:21Z

Protected "TimelineData" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))

K'del at 01:57, 27 June 2015

2015-06-27T01:57:01Z

K'del: Created page with "{{#get_db_data: db=norcon |from=timeline INNER JOIN chars_subareas |where=timeline.area != 'MINE' AND timeline.bit != '0' AND timeline.area='BDW' |data=era=era,yy=y..."

2015-06-27T00:44:19Z

Created page with "<noinclude>{{#get_db_data: db=norcon |from=timeline INNER JOIN chars_subareas |where=timeline.area != 'MINE' AND timeline.bit != '0' AND timeline.area='BDW' |data=era=era,yy=y..."

New page

<noinclude>{{#get_db_data:
db=norcon
|from=timeline INNER JOIN chars_subareas
|where=timeline.area != 'MINE' AND timeline.bit != '0' AND timeline.area='BDW'
|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=area}}

{{#store_external_table:Timeline
|era={{{era}}}
|yy={{{yy}}}
|mm={{{mm}}}
|dd={{{dd}}}
|item={{{item}}}
|link={{{link}}}
|area={{{area}}}
}}</noinclude>

@@ Line 15: / Line 15: @@
 |name={{{area2}}} I10.{{{yy}}}.{{{mm}}}.{{{dd}}}
 |bb={{{bb}}}
 }}</noinclude>

@@ Line 15: / Line 15: @@
 |name={{{area2}}} I10.{{{yy}}}.{{{mm}}}.{{{dd}}}
 |bb={{{bb}}}
 }}</noinclude>

@@ Line 3: / Line 3: @@
 |from=timeline INNER JOIN chars_subareas ON timeline.area = chars_subareas.subarea
 |where=timeline.area != 'MINE' AND timeline.bit != '0'
-|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=chars_subareas.fullarea,area2=area, bb=bb}}
+|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=chars_subareas.fullarea,area2=area,bb=bb}}
 {{#store_external_table:Timeline

@@ Line 3: / Line 3: @@
 |from=timeline INNER JOIN chars_subareas ON timeline.area = chars_subareas.subarea
 |where=timeline.area != 'MINE' AND timeline.bit != '0'
-|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=chars_subareas.fullarea,area2=area}}
+|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=chars_subareas.fullarea,area2=area, bb=bb}}
 {{#store_external_table:Timeline
@@ Line 14: / Line 14: @@
 |area={{{area}}}
 |name={{{area2}}} I10.{{{yy}}}.{{{mm}}}.{{{dd}}}
 }}</noinclude>

← Older revision	Revision as of 07:10, 29 June 2015
(No difference)

@@ Line 1: / Line 1: @@
 <noinclude>{{#get_db_data:
 db=norcon
-|from=timeline INNER JOIN chars_subareas
+|from=timeline INNER JOIN chars_subareas ON timeline.area = chars_subareas.subarea
-|where=timeline.area != 'MINE' AND timeline.bit != '0' AND timeline.area='BDW'
+|where=timeline.area != 'MINE' AND timeline.bit != '0'
-|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=area}}
+|data=era=era,yy=yy,mm=mm,dd=dd,item=item,link=link,area=chars_subareas.fullarea}}
 {{#store_external_table:Timeline