Frenzied Spitter: Difference between revisions
No edit summary |
No edit summary |
||
| Line 55: | Line 55: | ||
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_frenzied_spitter" | | where=ZL.ZedCodename="npc_frenzied_spitter" | ||
| order by=ZL.Level DESC | | order by=ZL.Level DESC | ||
| Line 69: | Line 69: | ||
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_frenzied_spitter" | | where=LootTableLink.LinkCodename="npc_frenzied_spitter" | ||
|format=table | |format=table | ||
Revision as of 08:09, 11 July 2025
Information
Stats
| Attribute | Value |
|---|---|
| Name | Frenzied Spitter |
| Strength | 9297 |
| Defense | 55783 |
| Speed | 18594 |
| Agility | 27891 |
| Stat Scale | 0.00544 |
| Max Life | 1000 |
| HP Scale | .01 |
| Weakness | piercing |
| Difficulty Rating | 9 |
| Description | No information known |
Standard Loot
{{#cargo_query: tables=ZedLoot=ZL,Items=I | join on=ZL.Codename=I.Codename | 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_frenzied_spitter" | order by=ZL.Level DESC | format=table }}
Extra Loot
{{#cargo_query: tables=LootTableItem,LootTable,Items,LootTableLink | join on = LootTable.Codename = LootTableItem.LootTableCodename, LootTableItem.Codename = Items.Codename, LootTableLink.Codename = LootTable.Codename | 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_frenzied_spitter" |format=table }}