TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:
  db=CalderaLocal
  db=CalderaLocal
  |from=mob_groups, mob_droplist, item_basic
  |from=mob_groups, mob_droplist, item_basic
  |join on=mob_groups.dropid=mob_droplist.dropId, item_basic.itemid=mob_droplist.itemId
  |join on=mob_groups.dropid=mob_droplist.dropid, item_basic.itemid=mob_droplist.itemid
  |where=mob_droplist.dropId=2
  |where=mob_droplist.dropid=2
  |data=
  |data=
MobName=mob_groups.name,
MobName=mob_groups.name,
DropID=mob_droplist.dropId,
DropID=mob_droplist.dropid,
GroupID=mob_droplist.groupID,
GroupID=mob_droplist.groupid,
GroupRate=mob_droplist.groupRate,
GroupRate=mob_droplist.grouprate,
ItemID=mob_droplist.itemId,
ItemID=mob_droplist.itemid,
ItemName=item_basic.name,
ItemName=item_basic.name,
ItemRate=mob_droplist.itemRate
ItemRate=mob_droplist.itemrate
}}
}}



Revision as of 01:30, 3 August 2023

Error: Incomplete information for this database ID CalderaLocal (type).
Error: Incomplete information for this database ID CalderaLocal (user/user file).
Error: Incomplete information for this database ID CalderaLocal (name).
Error: Incomplete information for this database ID CalderaLocal (server).

Query Results
Mob Name Drop ID Group ID Group Rate Item ID Item Name Item Rate