TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 6: Line 6:
AND mob_droplist.md_dropId = mob_groups.mg_dropid
AND mob_droplist.md_dropId = mob_groups.mg_dropid
AND item_basic.ib_itemid = mob_droplist.md_itemId
AND item_basic.ib_itemid = mob_droplist.md_itemId
  |order by=md_dropId, md_groupId
  |order by=md_dropId, md_groupId, md_itemId
  |data=
  |data=
Result1=mg_name, Result2=md_dropID, Result3=md_groupID, Result4=md_itemId, Result5=REPLACE(ib_name,'_',' '), Result6=md_itemRate
Result1=mg_name, Result2=md_dropID, Result3=md_groupID, Result4=md_itemId, Result5=REPLACE(ib_name,'_',' '), Result6=md_itemRate

Revision as of 17:30, 3 August 2023

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

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