User:Bennie/Project

Idea
There must be a checker for items and creatures. This can be done to Special:Export pages in XML format and then use XPath or XQuery to iterate through it (and Mediawiki's API can be even used to perform automatic edits).

Logic
itemN --> droppedby = creature1, creature2, ..., creatureN

creatureN --> loot = item1, item2, ..., itemN

First way of looking at it (if an item is dropped by a creature, the creature must list this item as loot too)

SQL intepretation (actually this just selects the items which fulfill the requirement, which we want to empose):

select items.itemName from items, creatures where items.itemName = creatures.loot.itemName and items.droppedby.creatureName contains creatures.creatureName and creatures.loot.itemName contains items.itemName

Example: IF items.Honeycomb has items.Honeycomb.droppedby.Wasp THEN creatures.Wasp.loot[] must contain creatures.Wasp.loot.Honeycomb

Second way of looking at it (if a creature has an item as loot, the item must be dropped by this creature as well)

Example: IF creatures.Wasp has creatures.Wasp.loot.Honeycomb THEN items.Honeycomb.droppedby[] must contain items.Honeycomb.droppedby.Wasp