TestPage: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=CalderaLocal | db=CalderaLocal | ||
|from=mob_droplist | |from=mob_droplist, mob_groups, item_basic | ||
|where=mob_droplist. | |join on=mob_droplist.dropId = mob_groups.dropid, item_basic.itemid = mob_droplist.itemId | ||
|where=mob_droplist.dropId = 2203 | |||
|order by=mob_groups.name, mob_droplist.groupId | |||
|data= | |data= | ||
MobName = mob_droplist.dropId, | |||
DropID = mob_droplist.dropType, | |||
GroupID = mob_droplist.groupID, | |||
GroupRate = mob_droplist.groupRate, | |||
ItemID = mob_droplist.itemId, | |||
ItemName = item_basic.name, | |||
ItemRate = mob_droplist.itemRate | |||
}} | }} | ||
{| class="wikitable" | {| class="wikitable" | ||
|+ Query Results | |+ Query Results | ||
! | ! Mob Name !! Drop ID !! Group ID !! Group Rate !! Item ID !! Item Name !! Item Rate | ||
|- | {{#for_external_table:| | ||
{{!}}- | |||
{{!}} {{{DropID}}} | |||
{{!}} {{{Type}}} | |||
{{!}} {{{Group}}} | |||
{{!}} {{{GroupRate}}} | |||
{{!}} {{{ItemID}}} | |||
{{!}} {{{ItemName}}} | |||
{{!}} {{{ItemRate}}} | |||
}} | |||
|} | |} | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
Revision as of 19:32, 2 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).
| Mob Name | Drop ID | Group ID | Group Rate | Item ID | Item Name | Item Rate |
|---|