TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
  db=CalderaLocal
  db=CalderaLocal
  |from=mob_groups, mob_droplist, item_basic
  |from=mob_groups
  |join on=mob_groups.dropid=mob_droplist.dropid, item_basic.itemid=mob_droplist.itemid
  |where=mob_groups.zoneid=1
|where=mob_droplist.dropid=2
  |data=
  |data=
MobName=mob_groups.name,
GroupID=mob_groups.groupid,
DropID=mob_droplist.dropid,
PoolID=mob_groups.poolid,
GroupID=mob_droplist.groupid,
MobName=mob_groups.name
GroupRate=mob_droplist.grouprate,
ItemID=mob_droplist.itemid,
ItemName=item_basic.name,
ItemRate=mob_droplist.itemrate
}}
}}


{| class="wikitable"
{| class="wikitable"
|+ Query Results
|+ Query Results
! Mob Name !! Drop ID !! Group ID !! Group Rate !! Item ID !! Item Name !! Item Rate
! Group ID !! Pool ID !! Mob Name
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
{{!}} {{{GroupID}}}
{{!}} {{{PoolID}}}
{{!}} {{{MobName}}}
{{!}} {{{MobName}}}
{{!}} {{{DropID}}}
{{!}} {{{GroupID}}}
{{!}} {{{GroupRate}}}
{{!}} {{{ItemID}}}
{{!}} {{{ItemName}}}
{{!}} {{{ItemRate}}}
}}
}}
|}
|}


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

Revision as of 01:34, 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
Group ID Pool ID Mob Name


Retrieved from "http://www.ffxi-caldera.net/wiki/index.php?title=TestPage&oldid=22586"