Template:GetMobDrops - Revision history

.mythicangel at 07:50, 21 September 2024

2024-09-21T07:50:28Z

← Older revision		Revision as of 07:50, 21 September 2024
Line 22:		Line 22:
	}} \|}</onlyinclude></includeonly>		}} \|}</onlyinclude></includeonly>

			<!--This would need a while loop on the item from droprates to combine them into the zone name from spawncount. -->
	<onlyinclude><includeonly>		<onlyinclude><includeonly>
	{{#get_db_data:db = spawncount		{{#get_db_data:db = spawncount

2024-09-21T07:46:22Z

← Older revision		Revision as of 07:46, 21 September 2024
Line 35:		Line 35:
	! Zone !! Drops !! Spawns{{#for_external_table:\|<nowiki/>		! Zone !! Drops !! Spawns{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{zoneSpawn}}} {{!}}{{!}} {{{item}}} {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}		{{!}} [[{{{zoneSpawn}}}]] {{!}}{{!}} [[{{{item}}}]] {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}
	}} \|}</onlyinclude></includeonly>		}} \|}</onlyinclude></includeonly>

2024-09-21T07:37:26Z

← Older revision		Revision as of 07:37, 21 September 2024
Line 26:		Line 26:
	{{#get_db_data:db = spawncount		{{#get_db_data:db = spawncount
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data= count=mobcount, ~~zone~~=zonename		\| data= count=mobcount, zoneSpawn=zonename
	}}		}}
	{{#get_db_data:db = droprates		{{#get_db_data:db = droprates
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data=~~zone~~=zoneName,item=itemName,rate=itemRate		\| data=zoneDrop=zoneName,item=itemName,rate=itemRate
	}}<!--		}}<!--
	-->{\| class="mobs horizon-table table-xl"		-->{\| class="mobs horizon-table table-xl"
	! Zone !! Drops !! Spawns{{#for_external_table:\|<nowiki/>		! Zone !! Drops !! Spawns{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{~~zone~~}}} {{!}}{{!}} {{{item}}} {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}		{{!}} {{{zoneSpawn}}} {{!}}{{!}} {{{item}}} {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}
	}} \|}</onlyinclude></includeonly>		}} \|}</onlyinclude></includeonly>

2024-09-21T07:36:34Z

← Older revision		Revision as of 07:36, 21 September 2024
Line 29:		Line 29:
	}}		}}
	{{#get_db_data:db = droprates		{{#get_db_data:db = droprates
	~~\| from=spawncount tbn1, droprates tbn2~~
	~~\| join on=tbn1.zoneName = tbn2.zoneName~~
	~~\| where=mobName={{PAGENAMEE}}~~
	~~\| group by=zoneName~~
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data=zone=zoneName,item=itemName,rate=itemRate		\| data=zone=zoneName,item=itemName,rate=itemRate

2024-09-21T03:47:54Z

@@ Line 20: / Line 20: @@
 {{!}}-
 {{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}%
 }} |}</onlyinclude></includeonly>

2024-02-29T11:45:58Z

← Older revision		Revision as of 11:45, 29 February 2024
Line 1:		Line 1:
	<includeonly><onlyinclude>		<includeonly><onlyinclude>
	{{#get_db_data:db = ~~droprates~~		{{#get_db_data:db = spawncount
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data=~~zone~~=~~zoneName~~,~~item~~=~~itemName,rate=itemRate~~		\| data= mobcount=mobcount, zonename=zonename
	}}<!--		}}<!--
	-->{\| class="wikitable"		-->{\| class="wikitable"
	! ~~zone~~ !! ~~item !! rate~~{{#for_external_table:\|<nowiki/>		! zonename !! mobcount{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
	{{!}} [[{{{~~zone~~}}}]] {{!}}{{!}} {{{~~item~~}}} ~~{{!}}{{!}} {{#expr:{{{rate}}} / 10}}%~~		{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}}
	}}		}}
	\|}<!--		\|}
			<!--
	--><br>		--><br>
	{{#get_db_data:db = ~~spawncount~~		{{#get_db_data:db = droprates
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data= ~~mobcount~~=~~mobcount~~, ~~zonename~~=~~zonename~~		\| data=zone=zoneName,item=itemName,rate=itemRate
	}}<!--		}}<!--
	-->{\| class="wikitable"		-->{\| class="wikitable"
	! ~~zonename~~ !! ~~mobcount~~{{#for_external_table:\|<nowiki/>		! zone !! item !! rate{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{~~zonename~~}}} {{!}}{{!}} {{{~~mobcount~~}}}		{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}%
	}}		}} \|}</onlyinclude></includeonly>
	\|}</onlyinclude></includeonly>

	==Usage==		==Usage==

2024-02-29T11:07:28Z

← Older revision		Revision as of 11:07, 29 February 2024
Line 1:		Line 1:
	<includeonly><onlyinclude>{{#get_db_data:db = droprates		<includeonly><onlyinclude>
			{{#get_db_data:db = droprates
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data=zone=zoneName,item=itemName,rate=itemRate		\| data=zone=zoneName,item=itemName,rate=itemRate
	}}<!--		}}<!--
	-->{\| class="~~horizon-table droppedby table-sm center-col-3~~"		-->{\| class="wikitable"
	! zone !! item !! rate{{#for_external_table:\|<nowiki/>		! zone !! item !! rate{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
Line 11:		Line 12:
	--><br>		--><br>
	{{#get_db_data:db = spawncount		{{#get_db_data:db = spawncount
	\| parameters='{{{mob name\|{{PAGENAMEE}}}}}'		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
	\| data= mobcount=mobcount, zonename=zonename		\| data= mobcount=mobcount, zonename=zonename
	}}<!--		}}<!--
	-->{\| class="~~horizon-table droppedby table-sm center-col-3~~"		-->{\| class="wikitable"
	! zonename !! mobcount{{#for_external_table:\|<nowiki/>		! zonename !! mobcount{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-

2024-02-29T10:51:54Z

← Older revision		Revision as of 10:51, 29 February 2024
Line 11:		Line 11:
	--><br>		--><br>
	{{#get_db_data:db = spawncount		{{#get_db_data:db = spawncount
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters='{{{mob name\|{{PAGENAMEE}}}}}'
	\| data= mobcount=mobcount, zonename=zonename		\| data= mobcount=mobcount, zonename=zonename
	}}<!--		}}<!--

2024-02-29T04:02:49Z

← Older revision		Revision as of 04:02, 29 February 2024
Line 15:		Line 15:
	}}<!--		}}<!--
	-->{\| class="horizon-table droppedby table-sm center-col-3"		-->{\| class="horizon-table droppedby table-sm center-col-3"
	! zonename!! mobcount{{#for_external_table:\|<nowiki/>		! zonename !! mobcount{{#for_external_table:\|<nowiki/>
	{{!}}-		{{!}}-
	{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}}		{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}}

2024-02-29T03:46:56Z

← Older revision		Revision as of 03:46, 29 February 2024
Line 8:		Line 8:
	{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}%		{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}%
	}}		}}
			\|}<!--
			--><br>
	{{#get_db_data:db = spawncount		{{#get_db_data:db = spawncount
	\| parameters={{{mob name\|{{PAGENAMEE}}}}}		\| parameters={{{mob name\|{{PAGENAMEE}}}}}
Line 18:		Line 19:
	{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}}		{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}}
	}}		}}
	\|}
	\|}</onlyinclude></includeonly>		\|}</onlyinclude></includeonly>