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=Caldera
  db=CalderaLocal
  |from=item_mods, item_basic, gear_modifiers
  |from=mob_droplist
  |join on=item_basic.itemid = item_mods.itemId, item_mods.modId = gear_modifiers.modID
  |where=mob_droplist.dropID > 1
  |where=item_basic.itemid > 0
  |data=
|order by=item_mods.itemId, item_mods.modId
DropID=dropId, Type=dropType, Group=groupID, GroupRate=groupRate, ItemID=itemId, ItemRate=itemRate
|data=name=item_basic.name
}}
}}
{| class="wikitable" style="text-align: center";
|+ Query Results
! Drop ID !! Drop Type !! Group ID !! Group Rate !! Item ID !! Item Rate
|-
| {{#external_value:DropID}} || {{#external_value:Type}} || {{#external_value:Group}} || {{#external_value:GroupRate}} || {{#external_value:ItemID}} || {{#external_value:ItemRate}}
|}
{{#clear_external_data:}}

Revision as of 18:18, 2 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
Drop ID Drop Type Group ID Group Rate Item ID Item Rate
Error: no local variable "DropID" has been set. Error: no local variable "Type" has been set. Error: no local variable "Group" has been set. Error: no local variable "GroupRate" has been set. Error: no local variable "ItemID" has been set. Error: no local variable "ItemRate" has been set.