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 = getMobDroplist
{{#get_db_data:
  | query=dropList <!-- this parameter is used to choose one of the prepared statements -->
db=CalderaLocal
  | data=Result1=mob_groups.name, Result2=mob_droplist.dropId, Result3=mob_droplist.groupId, Result4=mob_droplist.itemId, Result5=item_basic.name, Result6=mob_droplist.itemRate
  |from=mob_droplist
|where=mob_droplist.dropID = 2500
  |data=
DropID=dropId, Type=dropType, Group=groupID, GroupRate=groupRate, ItemID=itemId, ItemRate=itemRate
}}
}}


{| class="wikitable"
{| class="wikitable"
|+ Query Results
|+ Query Results
! Column1 !! Column2 !! Column3 !! Column4 !! Column5 !! Column6
! Drop ID !! Drop Type !! Group ID !! Group Rate !! Item ID !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
{{!}} {{{Result1}}}
{{!}} {{{DropID}}}
{{!}} {{{Result2}}}
{{!}} {{{Type}}}
{{!}} {{{Result3}}}
{{!}} {{{Group}}}
{{!}} {{{Result4}}}
{{!}} {{{GroupRate}}}
{{!}} {{{Result5}}}
{{!}} {{{ItemID}}}
{{!}} {{{Result6}}}
{{!}} {{{ItemRate}}}
}}
}}
|}
|}


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

Revision as of 15:08, 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
Drop ID Drop Type Group ID Group Rate Item ID Item Rate


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