TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
Tag: Reverted
mNo edit summary
 
(84 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#get_db_data:
{{#get_db_data:
  db=CalderaLocal
  db=Derp
  |from=mob_groups
  |from=full_droplist
|join on=mob_droplist.dropId=mob_groups.dropid
|where=mob_groups.zoneid = 1
  |data=
  |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
Result1=mobName, Result2=dropID, Result3=groupID, Result4=itemID, Result5=REPLACE(itemName,'_',' '), Result6=itemRate
}}
}}


{| class="wikitable"
{| class="wikitable sortable"
|+ Query Results
|+ Query Results
! Column1 !! Column2 !! Column3 !! Column4 !! Column5 !! Column6 !! Column7 !! Column8 !! Column9 !! Column10 !! Column11 !! Column12
! Mob Name !! Drop ID !! Group ID !! Item ID !! Item Name !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
Line 19: Line 19:
{{!}} {{{Result5}}}
{{!}} {{{Result5}}}
{{!}} {{{Result6}}}
{{!}} {{{Result6}}}
{{!}} {{{Result7}}}
{{!}} {{{Result8}}}
{{!}} {{{Result9}}}
{{!}} {{{Result10}}}
{{!}} {{{Result11}}}
{{!}} {{{Result12}}}
}}
}}
|}
|}


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

Latest revision as of 00:50, 20 June 2024


Error: Incomplete information for this database ID Derp (type).
Error: Incomplete information for this database ID Derp (user/user file).
Error: Incomplete information for this database ID Derp (name).
Error: Incomplete information for this database ID Derp (server).

Query Results
Mob Name Drop ID Group ID Item ID Item Name Item Rate


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