Template:Test
Melee Weapons
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT(CASE WHEN Image2 IS NULL THEN CONCAT('File:', Image, '') ELSE CONCAT('File:', Image, '', '<br>File:', Image2, '') END) AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,`BaseDPS` AS `BaseDPS` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Melee Weapon" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Ranged Weapons
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT(CASE WHEN Image2 IS NULL THEN CONCAT('File:', Image, '') ELSE CONCAT('File:', Image, '', '<br>File:', Image2, '') END) AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,`BaseDPS` AS `BaseDPS` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Ranged Weapon" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Shields
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT('File:', Image, '') AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,`BaseBlockDamage` AS `BaseBlockDamage`,`BaseAbsorbedDamage` AS `BaseAbsorbedDamage` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Shield" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Traps & Turrets
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT('File:', Image, '') AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,CONCAT(CASE WHEN BaseDPS IS NULL AND BaseHit IS NULL THEN "N/A" WHEN BaseDPS IS NULL THEN CONCAT(BaseHit, ' damage') WHEN BaseHit IS NULL THEN CONCAT(BaseDPS, ' DPS') ELSE CONCAT(BaseDPS, ' DPS<br>', BaseHit, ' damage') END) AS `Base Damage`,CONCAT(CASE WHEN BaseDoTDPS IS NULL THEN "N/A" WHEN Duration THEN CONCAT(BaseDoTDPS, ' DPS<br>', Duration) ELSE CONCAT(BaseDoTDPS, ' DPS') END) AS `Base Damage over Time`,`Recharge` AS `Base Cooldown` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Deployable" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Grenades
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT('File:', Image, '') AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,CONCAT(CASE WHEN BaseDPS IS NULL AND BaseHit IS NULL THEN "N/A" WHEN BaseDPS IS NULL THEN CONCAT(BaseHit, ' damage') WHEN BaseHit IS NULL THEN CONCAT(BaseDPS, ' DPS') ELSE CONCAT(BaseDPS, ' DPS<br>', BaseHit, ' damage') END) AS `Base Damage`,CONCAT(CASE WHEN BaseDoTDPS IS NULL THEN "N/A" WHEN Duration THEN CONCAT(BaseDoTDPS, ' DPS<br>', Duration) ELSE CONCAT(BaseDoTDPS, ' DPS') END) AS `Base Damage over Time`,`Recharge` AS `Base Cooldown` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Grenade" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Powers
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT('File:', Image, '') AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,CONCAT(CASE WHEN BaseDPS IS NULL AND BaseHit IS NULL THEN "N/A" WHEN BaseDPS IS NULL THEN CONCAT(BaseHit, ' damage') WHEN BaseHit IS NULL THEN CONCAT(BaseDPS, ' DPS') ELSE CONCAT(BaseDPS, ' DPS<br>', BaseHit, ' damage') END) AS `Base Damage`,CONCAT(CASE WHEN BaseDoTDPS IS NULL THEN "N/A" WHEN Duration THEN CONCAT(BaseDoTDPS, ' DPS<br>', Duration) ELSE CONCAT(BaseDoTDPS, ' DPS') END) AS `Base Damage over Time`,`Recharge` AS `Base Cooldown` FROM `cargo__Items` WHERE `cargo__Items`.`Type`="Power" AND `cargo__Items`.`RemovedContent`="0" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Removed items
Powers
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,CONCAT('File:', Image, '') AS `Icon`,CONCAT(CASE WHEN RiseoftheGiantExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=RotG', '}}') WHEN BadSeedExclusive="1" THEN CONCAT('', _pageName, '', '{{efn|', 'name=TBS', '}}') ELSE CONCAT('', Name, '') END) AS `Name`,CONCAT('{{Stat|', Scaling, '}}') AS `Scaling`,`Description` AS `Description`,`BlueprintLocation` AS `BlueprintLocation`,CONCAT(CASE WHEN BaseDPS IS NULL AND BaseHit IS NULL THEN "N/A" WHEN BaseDPS IS NULL THEN CONCAT(BaseHit, ' damage') WHEN BaseHit IS NULL THEN CONCAT(BaseDPS, ' DPS') ELSE CONCAT(BaseDPS, ' DPS<br>', BaseHit, ' damage') END) AS `Base Damage`,CONCAT(CASE WHEN BaseDoTDPS IS NULL THEN "N/A" WHEN Duration THEN CONCAT(BaseDoTDPS, ' DPS<br>', Duration) ELSE CONCAT(BaseDoTDPS, ' DPS') END) AS `Base Damage over Time`,`Recharge` AS `Base Cooldown`,`RemoveVersion` AS `RemoveVersion` FROM `cargo__Items` WHERE `cargo__Items`.`RemovedContent`="1" ORDER BY `cargo__Items`.`ItemID` LIMIT 2000
Notes
Cite error: <ref>
tag with name "RotG" defined in <references>
has group attribute "lower-alpha" which does not appear in prior text.
<ref>
tag with name "TBS" defined in <references>
has group attribute "lower-alpha" which does not appear in prior text.1 | 2 | 3 |
---|---|---|
a | b | c |
d | e | f |
a | b | c |
a | b | c |
a | b | c |
Spoiler alert!