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=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_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=Items._pageName, 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_undead_corporal" | | where=LootTableLink.LinkCodename="npc_undead_corporal" | ||
|format=table | |format=table |
Revision as of 08:09, 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
Function: CargoSQLQuery::run Query: SELECT `I`.`_pageID` AS `cargo_backlink_page_id_I`,`ZL`.`_pageID` AS `cargo_backlink_page_id_ZL`,=CONCAT('https://www.zed.city/items/', `I`.`Codename`, '.png')=Image AS `zed.city/items/', I.Codename, '.png')=Image`,`I`.`_pageName` AS `Item`,`ZL`.`Qty` AS `Qty`,`ZL`.`Level` AS `Level`,CONCAT(`ZL`.`Chance`, "%") AS `Chance` FROM `cargo__ZedLoot` `ZL` LEFT OUTER JOIN `cargo__Items` `I` ON ((`ZL`.`Codename`=`I`.`Codename`)) WHERE `ZL`.`ZedCodename`="npc_undead_corporal" ORDER BY `ZL`.`Level` DESC LIMIT 5000
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')=Image AS `zed.city/items/', I.Codename, '.png')=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')=Image LIMIT 5000