TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
mNo edit summary
 
(63 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, mob_droplist
  |from=full_droplist
|where=mob_groups.dropid=2
|limit=10
  |data=
  |data=
GroupID=mob_groups.groupid, PoolID=mob_groups.poolid, ZoneID=zoneid, MobName=name, Respawn=respawntime, SpawnType=spawntype, DropID=mob_groups.dropid, HP=HP, MP=MP, MinLvl=minLevel, MaxLvl=maxLevel, Allegiance=allegiance, ItemID=mob_droplist.itemId
Result1=mobName, Result2=dropID, Result3=groupID, Result4=itemID, Result5=REPLACE(itemName,'_',' '), Result6=itemRate
}}
}}


{| class="wikitable"
{| class="wikitable sortable"
|+ Query Results
|+ Query Results
! Group ID !! Pool ID !! Zone ID !! Mob Name !! Respawn !! Spawn Type !! Drop ID !! HP !! MP !! Min Level !! Max Level !! Allegiance
! Mob Name !! Drop ID !! Group ID !! Item ID !! Item Name !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
{{!}} {{{GroupID}}}
{{!}} {{{Result1}}}
{{!}} {{{PoolID}}}
{{!}} {{{Result2}}}
{{!}} {{{ZoneID}}}
{{!}} {{{Result3}}}
{{!}} {{{MobName}}}
{{!}} {{{Result4}}}
{{!}} {{{Respawn}}}
{{!}} {{{Result5}}}
{{!}} {{{SpawnType}}}
{{!}} {{{Result6}}}
{{!}} {{{DropID}}}
{{!}} {{{HP}}}
{{!}} {{{MP}}}
{{!}} {{{MinLvl}}}
{{!}} {{{MaxLvl}}}
{{!}} {{{Allegiance}}}
{{!}} {{{ItemID}}}
}}
}}
|}
|}


{{#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"