User:Iamacyborg: Difference between revisions
>BotK2 (Replacing sl with il) |
Iamacyborg (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
https://twitter.com/iamacyborg if you need me. | https://twitter.com/iamacyborg if you need me. | ||
{{Query base items | |||
|where=armours.armour = 0 AND armours.energy_shield = 0 AND armours.evasion > 0 {{#if:{{{item_class|}}}|AND items.class="{{{item_class|}}}"|}} | |||
|large=1 | |||
|level=1 | |||
|dex=1 | |||
|ev=1 | |||
|stat=1 | |||
|block={{#ifeq:{{{item_class|}}}|Shields|1|}} | |||
}} |
Revision as of 13:30, 26 August 2021
https://twitter.com/iamacyborg if you need me.
Lua error: Error 1054: Unknown column 'cargo__armours.armour' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__items`.`required_dexterity_range_maximum` AS `items.required_dexterity_range_maximum`,`cargo__items`.`required_dexterity_range_text` AS `items.required_dexterity_range_text`,`cargo__items`.`required_dexterity_range_colour` AS `items.required_dexterity_range_colour`,`cargo__armours`.`evasion_range_maximum` AS `armours.evasion_range_maximum`,`cargo__armours`.`evasion_range_text` AS `armours.evasion_range_text`,`cargo__armours`.`evasion_range_colour` AS `armours.evasion_range_colour`,`cargo__items`.`stat_text` AS `items.stat_text` FROM `cargo__items` LEFT OUTER JOIN `cargo__armours` ON ((`cargo__items`.`_pageID`=`cargo__armours`.`_pageID`)) LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) WHERE (`cargo__items`.`drop_enabled` = true
AND (`cargo__items`.`release_version` IS NULL OR `cargo__items`.`release_version` IS NOT NULL AND `cargo__versions`.`release_date` < 20240531201213 ) AND `cargo__items`.`base_item` IS NULL AND `cargo__items`.`base_item_id` IS NULL AND `cargo__items`.`base_item_page` IS NULL AND (`cargo__armours`.`armour` = 0 AND `cargo__armours`.`energy_shield` = 0 AND `cargo__armours`.`evasion` > 0)) AND `cargo__items`.`_pageNamespace` IN (0,10016) GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000
.