TestPage: Difference between revisions

From FFXI-Caldera Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
Tag: Reverted
mNo edit summary
 
(79 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 = 1 and mob_droplist.dropID = 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, Result14=mob_droplist.dropType, Result15=mob_droplist.groupId, Result16=mob_droplist.groupRate, Result17=mob_droplist.itemId, Result18=mob_droplist.itemRate
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 !! Column13 !! Column 14 !! Column 15 !! Column 16 !! Column 17 !! Column 18
! Mob Name !! Drop ID !! Group ID !! Item ID !! Item Name !! Item Rate
{{#for_external_table:|
{{#for_external_table:|
{{!}}-
{{!}}-
Line 18: Line 19:
{{!}} {{{Result5}}}
{{!}} {{{Result5}}}
{{!}} {{{Result6}}}
{{!}} {{{Result6}}}
{{!}} {{{Result7}}}
{{!}} {{{Result8}}}
{{!}} {{{Result9}}}
{{!}} {{{Result10}}}
{{!}} {{{Result11}}}
{{!}} {{{Result12}}}
{{!}} {{{Result13}}}
{{!}} {{{Result14}}}
{{!}} {{{Result15}}}
{{!}} {{{Result16}}}
{{!}} {{{Result17}}}
{{!}} {{{Result18}}}
}}
}}
|}
|}


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