Undead Corporal: Difference between revisions
No edit summary |
No edit summary |
||
Line 79: | Line 79: | ||
tables=ZedLoot=ZL,Items=I | tables=ZedLoot=ZL,Items=I | ||
| join on=ZL.Codename=I.Codename | | join on=ZL.Codename=I.Codename | ||
| fields | | 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_undead_corporal" | | where=ZL.ZedCodename="npc_undead_corporal" | ||
| order by=ZL.Level DESC | | order by=ZL.Level DESC | ||
Line 93: | Line 93: | ||
LootTableItem.Codename = Items.Codename, | LootTableItem.Codename = Items.Codename, | ||
LootTableLink.Codename = LootTable.Codename | LootTableLink.Codename = LootTable.Codename | ||
| fields | | 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_undead_corporal" | | where=LootTableLink.LinkCodename="npc_undead_corporal" | ||
|format=table | |format=table |
Revision as of 08:28, 11 July 2025
Information
Stats
Attribute | Value |
---|---|
Name | Undead Corporal |
Strength | 2000 |
Defense | 2200 |
Speed | 300 |
Agility | 300 |
Stat Scale | 2 |
Max Life | 500 |
HP Scale | .05 |
Weakness | bladed |
Difficulty Rating | 5 |
Description | No information known |
Standard Loot
Image | Item | Qty | Level | Chance |
---|---|---|---|---|
![]() |
Carp | 3-6 | 21-40 | 5% |
![]() |
Chocolate | 3-6 | 1-20 | 5% |
![]() |
Zed Juice | 1-3 | 1-100 | 100% |
![]() |
M249 | 1 | 1-100 | 5% |
![]() |
Craft Padded Pants | 1 | 1-100 | 20% |
![]() |
Craft Padded Vest | 1 | 1-100 | 20% |
Extra Loot
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_undead_corporal" 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