TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(10 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
  db=Derp
  db=Derp
  |from=mob_droplist, mob_groups, item_basic
  |from=full_droplist
|where=mob_droplist.md_dropId = 2
AND mob_droplist.md_dropId = mob_groups.mg_dropid
AND item_basic.ib_itemid = mob_droplist.md_itemId
|limit=10
  |data=
  |data=
Result1=mg_name, Result2=md_dropID, Result3=md_groupID, Result4=md_itemId, Result5=ib_name, Result6=md_itemRate
Result1=mobName, Result2=dropID, Result3=groupID, Result4=itemID, Result5=REPLACE(itemName,'_',' '), Result6=itemRate
}}
}}


{| class="wikitable"
{| class="wikitable sortable"
|+ Query Results
|+ Query Results
! Column 1 !! Column 2 !! Column 3 !! Column 4
! Mob Name !! Drop ID !! Group ID !! Item ID !! Item Name !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-

Latest revision as of 00:50, 20 June 2024


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