TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
db=CalderaLocal
db = rfam2
  |from=mob_groups, mob_droplist
  | data=account=rfam_acc,sec=rfamseq_acc,start=seq_start,end=seq_end
|join on=mob_groups.groupid=mob_droplist.groupId
}}
|where=mob_groups.dropid>0 AND mob_groups.dropid<10
  |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
|limit=10
  |data=GroupID=mob_groups.groupid, PoolID=poolid, ZoneID=zoneid, MobName=name, DropID=mob_groups.dropid, ItemID=mob_droplist.itemId
}}
}}


Line 13: Line 11:
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
{{!}} {{{GroupID}}}
{{!}} {{{PoolID}}}
{{!}} {{{ZoneID}}}
{{!}} {{{MobName}}}
{{!}} {{{MobName}}}
{{!}} {{{DropID}}}
{{!}} {{{DropID}}}
{{!}} {{{GroupID}}}
{{!}} {{{ItemID}}}
{{!}} {{{ItemID}}}
{{!}} {{{ItemName}}}
{{!}} {{{ItemRate}}}
}}
}}
|}
|}


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

Revision as of 16:19, 3 August 2023

Error: Incomplete information for this database ID rfam2 (type).
Error: Incomplete information for this database ID rfam2 (user/user file).
Error: Incomplete information for this database ID rfam2 (name).
Error: Incomplete information for this database ID rfam2 (server).
Error: No "from / join on" parameter specified.

|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

}}

Query Results
Group ID Pool ID Zone ID Mob Name Drop ID Item ID