Kukulkan: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 34: | Line 34: | ||
{{#get_db_data: | {{#get_db_data: | ||
db=Derp | db=Derp | ||
|from=mob_droplist, mob_groups, item_basic | |from=mob_droplist, mob_groups, item_basic, item_names | ||
|where=mob_groups.mg_name = '{{PAGENAME}}' | |where=mob_groups.mg_name = REPLACE('{{PAGENAME}}', ' ', '_') | ||
AND mob_droplist.md_dropId = mob_groups.mg_dropid | AND mob_droplist.md_dropId = mob_groups.mg_dropid | ||
AND item_basic.ib_itemid = mob_droplist.md_itemId | AND item_basic.ib_itemid = mob_droplist.md_itemId | ||
AND item_basic.ib_itemid = item_names.in_item_id | |||
|order by=mg_name, md_dropId, md_groupId, md_itemId | |order by=mg_name, md_dropId, md_groupId, md_itemId | ||
|data= | |data= | ||
groupID=md_groupID, itemID=md_itemId, | groupID=md_groupID, itemID=md_itemId, itemDisplayName=in_name, itemSearchName=REPLACE(in_name,' ','_'), itemRate=ROUND(md_itemRate / 10, 1) | ||
}} | }} | ||
| Line 51: | Line 52: | ||
{{!}} {{{groupID}}} | {{!}} {{{groupID}}} | ||
{{!}} {{{itemID}}} | {{!}} {{{itemID}}} | ||
{{!}} [https://www.bg-wiki.com/ffxi/{{{ | {{!}} [https://www.bg-wiki.com/ffxi/{{{itemSearchName|}}} {{{itemDisplayName}}}] | ||
{{!}} [https://www.ffxiah.com/item/{{{itemID|}}} {{ucfirst:{{{ | {{!}} [https://www.ffxiah.com/item/{{{itemID|}}} {{ucfirst:{{{itemDisplayName}}}}}] | ||
{{!}} {{{itemRate}}}% | {{!}} {{{itemRate}}}% | ||
}} | }} | ||
Revision as of 02:52, 8 August 2023
| Location: | Abyssea - Konschtat (H-5) |
| Kukulkan | 
|
| Pop Items | ||||
|---|---|---|---|---|
 |
 |
| ||
| Drops | |||
|---|---|---|---|
| Gear | Items | ||
| Camaraderie Dagger | 15% | Kukulkan's Skin | 10% |
| Manibozho Boots | 15% | Kukulkan's Fang | 100% |
| Shunten Hachimaki | 100% | Kukulkan's Fang | 5% |
| Anguinus Belt | 10% | ||
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).
| Drops | ||||
|---|---|---|---|---|
| Group ID | Item ID | BG Wiki | FFXIAH | Item Rate |