TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
Tag: Reverted
No edit summary
Tag: Manual revert
Line 1: Line 1:
{{#get_db_data: db = MultiQuery
{{#get_db_data:
  | query=sequences <!-- this parameter is used to choose one of the prepared statements -->
db=CalderaLocal
  | parameters=2 <!-- this parameter is used to substitute question marks in the prepared statement -->
  |from=mob_groups, mob_droplist
  | data=MobName=mobgroup.name, DropID=dropId, GroupID=groupId, ItemID=itemId, ItemName=item.name, ItemRate=itemRate
  |where=mob_groups.dropid=2
|limit=10
  |data=
GroupID=mob_groups.groupid, PoolID=mob_groups.poolid, ZoneID=zoneid, MobName=name, DropID=mob_groups.dropid, ItemID=mob_droplist.itemId
}}
}}


{| class="wikitable"
{| class="wikitable"
|+ Query Results
|+ Query Results
! Mob Name !! Drop ID !! GroupID !! ItemID !! Item Name !! Item Rate
! Group ID !! Pool ID !! Zone ID !! Mob Name !! Drop ID !! Item ID
{{#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:55, 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 Zone ID Mob Name Drop ID Item ID


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