X-Spitter: Difference between revisions

Revision as of 08:27, 11 July 2025

Information

Stats

Attribute	Value
Name	X-Spitter
Strength	16666
Defense	100000
Speed	33333
Agility	50000
Stat Scale	0.0052
Max Life	1000
HP Scale	.05
Weakness	piercing
Difficulty Rating	10
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

Error 1054: Unknown column 'I.Codename' in 'SELECT'

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_x_spitter" 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

@@ Line 73: / Line 73: @@
 tables=ZedLoot=ZL,Items=I
 | join on=ZL.Codename=I.Codename
-| fields==CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, 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_x_spitter"
 | order by=ZL.Level DESC
@@ Line 87: / Line 87: @@
 LootTableItem.Codename = Items.Codename,
 LootTableLink.Codename = LootTable.Codename
-| fields==CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, 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_x_spitter"
 |format=table