TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
  db=CalderaLocal
  db=CalderaLocal
  |from=mob_droplist
  |from=mob_droplist, mob_groups, item_basic
  |where=mob_droplist.dropID = 2500
  |where=
mob_droplist.dropId=2203 and
mob_droplist.dropId=mob_groups.dropid and
item_basic.itemid=mob_droplist.itemId
|order by=mob_groups.name, mob_droplist.groupId
  |data=
  |data=
DropID=dropId, Type=dropType, Group=groupID, GroupRate=groupRate, ItemID=itemId, ItemRate=itemRate
MobName=mob_groups.name,
DropID=mob_droplist.dropId,
GroupID=mob_droplist.groupID,
GroupRate=mob_droplist.groupRate,
ItemID=mob_droplist.itemId,
ItemName=item_basic.name,
ItemRate=mob_droplist.itemRate
}}
}}


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

Revision as of 00:37, 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
Mob Name Drop ID Group ID Group Rate Item ID Item Name Item Rate