Frenzied Bloater: Difference between revisions
No edit summary |
No edit summary |
||
| Line 67: | Line 67: | ||
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_frenzied_bloater" | | where=ZL.ZedCodename="npc_frenzied_bloater" | ||
| order by=ZL.Level DESC | | order by=ZL.Level DESC | ||
| Line 81: | Line 81: | ||
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_frenzied_bloater" | | where=LootTableLink.LinkCodename="npc_frenzied_bloater" | ||
|format=table | |format=table | ||
Revision as of 08:27, 11 July 2025
Information
Stats
| Attribute | Value |
|---|---|
| Name | Frenzied Bloater |
| Strength | 13649 |
| Defense | 81897 |
| Speed | 27299 |
| Agility | 40948 |
| Stat Scale | 0.00313 |
| Max Life | 1000 |
| HP Scale | .01 |
| Weakness | rifle |
| Difficulty Rating | 9 |
| Description | No information known |
Standard Loot
| Image | Item | Qty | Level | Chance |
|---|---|---|---|---|
 |
Chocolate | 3-6 | 1-20 | 100% |
 |
Zed Juice | 3-6 | 1-100 | 100% |
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_frenzied_bloater" 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