TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
(32 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
db = rfam2
db=Derp
  | data=account=rfam_acc,sec=rfamseq_acc,start=seq_start,end=seq_end
  |from=full_droplist
}}
  |data=
  |data=MobName=mob_groups.name, DropID=mob_droplist.dropId, GroupID=mob_droplist.groupId, ItemID=mob_droplist.itemId, ItemName=item_basic.name, ItemRate=mob_droplist.itemRate
Result1=mobName, Result2=dropID, Result3=groupID, Result4=itemID, Result5=REPLACE(itemName,'_',' '), Result6=itemRate
}}
}}


{| class="wikitable"
{| class="wikitable sortable"
|+ Query Results
|+ Query Results
! Group ID !! Pool ID !! Zone ID !! Mob Name !! Drop ID !! Item ID
! Mob Name !! Drop ID !! Group ID !! Item ID !! Item Name !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
{{!}} {{{MobName}}}
{{!}} {{{Result1}}}
{{!}} {{{DropID}}}
{{!}} {{{Result2}}}
{{!}} {{{GroupID}}}
{{!}} {{{Result3}}}
{{!}} {{{ItemID}}}
{{!}} {{{Result4}}}
{{!}} {{{ItemName}}}
{{!}} {{{Result5}}}
{{!}} {{{ItemRate}}}
{{!}} {{{Result6}}}
}}
}}
|}
|}


{{#clear_external_data:}}
{{#clear_external_data:}}

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