X-Spitter: Difference between revisions

Revision as of 08:13, 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

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/', `cargo__Items`.`Codename`, '.png')=Ima...' 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/', `cargo__Items`.`Codename`, '.png')=Image AS `zed.city/items/', Items.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_x_spitter" 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/', `cargo__Items`.`Codename`, '.png')=Ima...' 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/', `cargo__Items`.`Codename`, '.png')=Image AS `zed.city/items/', Items.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_x_spitter" ORDER BY `cargo__LootTableLink`.`_pageID`,`cargo__Items`.`_pageID`,`cargo__LootTableItem`.`_pageID`,`cargo__LootTable`.`_pageID`,=CONCAT('https://www.zed.city/items/', `cargo__Items`.`Codename`, '.png')=Image LIMIT 5000

@@ Line 73: / Line 73: @@
 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
+| fields==CONCAT('https://www.zed.city/items/', Items.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/', I.Codename, '.png')=Image, Items._pageName=Item, LootTableLink.Level, LootTable._pageName=Table, CONCAT(LootTableLink.Chance, "%")=Chance
+| fields==CONCAT('https://www.zed.city/items/', Items.Codename, '.png')=Image, Items._pageName=Item, LootTableLink.Level, LootTable._pageName=Table, CONCAT(LootTableLink.Chance, "%")=Chance
 | where=LootTableLink.LinkCodename="npc_x_spitter"
 |format=table