Undead Corporal: Difference between revisions

From Zed Wiki

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

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '=CONCAT('https://www.zed.city/items/', `I`.`Codename`, '.png')=Image AS `zed....' at line 1

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

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '=CONCAT('https://www.zed.city/items/', I.Codename, '.png')=Image AS `zed.city...' at line 1

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