Undead Chicken: Difference between revisions

From Zed Wiki

No edit summary
No edit summary
Line 49: Line 49:
tables=ZedLoot=ZL,Items=I
tables=ZedLoot=ZL,Items=I
| join on=ZL.Codename=I.Codename
| join on=ZL.Codename=I.Codename
| fields==CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, I._pageName=Item, ZL.Qty, ZL.Level, CONCAT(ZL.Chance, "%")=Chance
| fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image, I._pageName=Item, ZL.Qty, ZL.Level, CONCAT(ZL.Chance, "%")=Chance
| where=ZL.ZedCodename="npc_easter_chicken"
| where=ZL.ZedCodename="npc_easter_chicken"
| order by=ZL.Level DESC
| order by=ZL.Level DESC
Line 63: Line 63:
LootTableItem.Codename = Items.Codename,
LootTableItem.Codename = Items.Codename,
LootTableLink.Codename = LootTable.Codename
LootTableLink.Codename = LootTable.Codename
| fields==CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, LootTableLink.Level, LootTable._pageName=Table, CONCAT(LootTableLink.Chance, "%")=Chance
| fields=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image, Items._pageName=Item, LootTableLink.Level, LootTable._pageName=Table, CONCAT(LootTableLink.Chance, "%")=Chance
| where=LootTableLink.LinkCodename="npc_easter_chicken"
| where=LootTableLink.LinkCodename="npc_easter_chicken"
|format=table
|format=table

Revision as of 08:27, 11 July 2025


Information

Stats

Attribute Value
Name Undead Chicken
Strength 5
Defense 5
Speed 10
Agility 10
Stat Scale 0
Max Life 100
HP Scale 0
Weakness blunt
Difficulty Rating 1
Description No information known


Standard Loot

No results


Extra Loot

Error 1054: Unknown column 'I.Codename' in 'SELECT'

Function: CargoSQLQuery::run Query: SELECT `cargo__LootTableLink`.`_pageID` AS `cargo_backlink_page_id_LootTableLink`,`cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__LootTableItem`.`_pageID` AS `cargo_backlink_page_id_LootTableItem`,`cargo__LootTable`.`_pageID` AS `cargo_backlink_page_id_LootTable`,CONCAT('https://www.zed.city/items/', I.Codename, '.png') AS `Image`,`cargo__Items`.`_pageName` AS `Item`,`cargo__LootTableLink`.`Level` AS `Level`,`cargo__LootTable`.`_pageName` AS `Table`,CONCAT(`cargo__LootTableLink`.`Chance`, "%") AS `Chance` FROM `cargo__LootTableLink` LEFT OUTER JOIN `cargo__LootTable` ON ((`cargo__LootTableLink`.`Codename`=`cargo__LootTable`.`Codename`)) LEFT OUTER JOIN `cargo__LootTableItem` ON ((`cargo__LootTable`.`Codename`=`cargo__LootTableItem`.`LootTableCodename`)) LEFT OUTER JOIN `cargo__Items` ON ((`cargo__LootTableItem`.`Codename`=`cargo__Items`.`Codename`)) WHERE `cargo__LootTableLink`.`LinkCodename`="npc_easter_chicken" ORDER BY `cargo__LootTableLink`.`_pageID`,`cargo__Items`.`_pageID`,`cargo__LootTableItem`.`_pageID`,`cargo__LootTable`.`_pageID`,CONCAT('https://www.zed.city/items/', I.Codename, '.png') LIMIT 5000