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: Reverted
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data: db = getMobDroplist
db=CalderaLocal
  | query=dropList <!-- this parameter is used to choose one of the prepared statements -->
|from=mob_groups, mob_droplist
  | 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
  |where=mob_groups.dropid = 1 and mob_droplist.dropID = 1
  |data=
Result1=mob_groups.groupid, Result2=mob_groups.poolid, Result3=mob_groups.zoneid, Result4=mob_groups.name, Result5=mob_groups.respawntime, Result6=mob_groups.spawntype, Result7=mob_groups.dropid, Result8=mob_groups.HP, Result9=mob_groups.MP, Result10=mob_groups.minLevel, Result11=mob_groups.maxLevel, Result12=mob_groups.allegiance, Result13=mob_droplist.dropId, Result14=mob_droplist.dropType, Result15=mob_droplist.groupId, Result16=mob_droplist.groupRate, Result17=mob_droplist.itemId, Result18=mob_droplist.itemRate
}}
}}


{| class="wikitable"
{| class="wikitable"
|+ Query Results
|+ Query Results
! Column1 !! Column2 !! Column3 !! Column4 !! Column5 !! Column6 !! Column7 !! Column8 !! Column9 !! Column10 !! Column11 !! Column12 !! Column13 !! Column 14 !! Column 15 !! Column 16 !! Column 17 !! Column 18
! Column1 !! Column2 !! Column3 !! Column4 !! Column5 !! Column6
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
Line 18: Line 15:
{{!}} {{{Result5}}}
{{!}} {{{Result5}}}
{{!}} {{{Result6}}}
{{!}} {{{Result6}}}
{{!}} {{{Result7}}}
{{!}} {{{Result8}}}
{{!}} {{{Result9}}}
{{!}} {{{Result10}}}
{{!}} {{{Result11}}}
{{!}} {{{Result12}}}
{{!}} {{{Result13}}}
{{!}} {{{Result14}}}
{{!}} {{{Result15}}}
{{!}} {{{Result16}}}
{{!}} {{{Result17}}}
{{!}} {{{Result18}}}
}}
}}
|}
|}


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

Revision as of 14:31, 3 August 2023

Error: Incomplete information for this database ID getMobDroplist (type).
Error: Incomplete information for this database ID getMobDroplist (user/user file).
Error: Incomplete information for this database ID getMobDroplist (name).
Error: Incomplete information for this database ID getMobDroplist (server).
Error: No "from / join on" parameter specified.

Query Results
Column1 Column2 Column3 Column4 Column5 Column6


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