CharactersTest - Revision history

Bot at 07:13, 27 January 2016

2016-01-27T07:13:48Z

2016-01-27T07:12:37Z

2015-06-29T07:09:38Z

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

2015-06-10T02:04:36Z

2015-06-09T22:27:01Z

2015-04-27T21:55:41Z

2015-04-21T04:42:03Z

2015-04-11T07:06:59Z

2015-04-06T10:41:24Z

2015-04-06T10:32:27Z

@@ Line 2: / Line 2: @@
 db=norcon
 |from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
 |data=name=name,rank=rank,status=chars_status.status,craft=chars_crafts.craft,subarea=chars_subareas.fullarea
 }}

@@ Line 2: / Line 2: @@
 db=norcon
 |from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
 |data=name=name,rank=rank,status=chars_status.status,craft=chars_crafts.craft,subarea=chars_subareas.fullarea
 }}

@@ Line 2: / Line 2: @@
 db=norcon
 |from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
-|where=chars.status='4'
+|where=chars.status='4' or chars.wiki='1'
 |data=name=name,rank=rank,status=chars_status.status,craft=chars_crafts.craft,subarea=chars_subareas.fullarea
 }}

@@ Line 2: / Line 2: @@
 db=norcon
 |from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
 |data=name=name,rank=rank,status=chars_status.status,craft=chars_crafts.craft,subarea=chars_subareas.fullarea
 }}

@@ Line 1: / Line 1: @@
 __NOCACHE__{{#get_db_data:
 db=norcon
-|from=chars INNER JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
+|from=chars LEFT JOIN `chars_ranks` on chars.rankid = chars_ranks.id INNER JOIN `chars_status` on chars.status = chars_status.id LEFT JOIN `chars_crafts` on chars.craftid = chars_crafts.id INNER JOIN `chars_subareas` on chars.subareaid = chars_subareas.id
 |data=name=name,rank=rank,status=chars_status.status,craft=chars_crafts.craft,subarea=chars_subareas.fullarea
 }}

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

@@ Line 14: / Line 14: @@
 {{#for_external_table:<nowiki/>
 {{!}}-
-{{!}} [[{{{name}}}]]
+{{!}} [[Character::{{{name}}}]]
 {{!}} {{{rank}}}
 {{!}} {{{status}}}