Template:Hxi Drop Rate: Difference between revisions
From HorizonXI Wiki
m (reverting changes) Tag: Manual revert |
(updated template to use the parameter lsb. The parameter asb still functions for backwards compatibility) |
||
| Line 1: | Line 1: | ||
<onlyinclude><includeonly>{{#if:{{#pos:{{{1|}}}|%}}|([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}} HorizonXI Drop Rate|{{{1}}}}}]])|<!-- | <onlyinclude><includeonly>{{#if:{{#pos:{{{1|}}}|%}}|([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}} HorizonXI Drop Rate|{{{1}}}}}]])|<!-- | ||
-->{{#ifeq:{{{asb}}}|false | -->{{#ifeq:{{{lsb|{{{asb}}}}}}|false | ||
| {{Retail Drop Rate|{{{1|}}}|{{{2|}}}}} | | {{Retail Drop Rate|{{{1|}}}|{{{2|}}}}} | ||
| {{#ifexpr:{{{2|0}}} < 25<!-- | | {{#ifexpr:{{{2|0}}} < 25<!-- | ||
sample size smaller than 25: display horizon | sample size smaller than 25: display horizon | ||
-->| <span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2|0}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span> | -->| <span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|{{#if:{{{lsb|}}}|Land Sand Boat|Air Sky Boat}} Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2|0}}}}} %).|{{#expr:{{{lsb|{{{asb}}}}}}*100 round 1}}%|gray}}]])</span> | ||
| {{#ifexpr:{{{2|0}}} < 100<!-- | | {{#ifexpr:{{{2|0}}} < 100<!-- | ||
sample size smaller than 100: indications, display horizon | sample size smaller than 100: indications, display horizon | ||
-->| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | -->| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{lsb|{{{asb}}}}}})*100<!-- | ||
deviation from asb | deviation from asb | ||
-->| <span style="color: red">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. Horizon Drop Rate indicates a deviation but sample size is low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span> <!-- | -->| <span style="color: red">([[HorizonXI:Drop Rate Policy|{{ht|{{#if:{{{lsb|}}}|Land Sand Boat|Air Sky Boat}} Drop Rate. Horizon Drop Rate indicates a deviation but sample size is low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{lsb|{{{asb}}}}}}*100 round 1}}%|gray}}]])</span> <!-- | ||
no deviation from asb | no deviation from asb | ||
-->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span>}}<!-- | -->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|{{#if:{{{lsb|}}}|Land Sand Boat|Air Sky Boat}} Drop Rate. No indication that HorizonXI sample data deviates from that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{lsb|{{{asb}}}}}}*100 round 1}}%|gray}}]])</span>}}<!-- | ||
sample size smaller than 500: indications but display Hxi | sample size smaller than 500: indications but display Hxi | ||
--> | --> | ||
| {{#ifexpr:{{{2}}} < 500 | | {{#ifexpr:{{{2}}} < 500 | ||
| {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{asb}}})*100<!-- | | {{#ifexpr:({{#explode:{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}}|-|1}}) < abs({{{1|0}}}/{{{2}}} - {{{lsb|{{{asb}}}}}})*100<!-- | ||
deviation from asb | deviation from asb | ||
-->| <span style="color: purple">([[HorizonXI:Drop Rate Policy|{{ht|HorizonXI Drop Rate. Horizon Drop Rate indicates a deviation but sample size might still be low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %). - ASB: {{#expr:{{{asb}}}*100 round 1}}%|{{#expr:{{{1|0}}}/{{{2}}}*100 round 1}}%|gray}}]])</span> <!-- | -->| <span style="color: purple">([[HorizonXI:Drop Rate Policy|{{ht|HorizonXI Drop Rate. Horizon Drop Rate indicates a deviation but sample size might still be low: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %). - ASB: {{#expr:{{{lsb|{{{asb}}}}}}*100 round 1}}%|{{#expr:{{{1|0}}}/{{{2}}}*100 round 1}}%|gray}}]])</span> <!-- | ||
no deviation from asb | no deviation from asb | ||
-->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|Air Sky Boat Drop Rate. HorizonXI sample data agrees that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{asb}}}*100 round 1}}%|gray}}]])</span>}}<!-- | -->|<span style="color: gray">([[HorizonXI:Drop Rate Policy|{{ht|{{#if:{{{lsb|}}}|Land Sand Boat|Air Sky Boat}} Drop Rate. HorizonXI sample data agrees that: {{{1|0}}}/{{{2|0}}} ({{#expr:{{{1|0}}} / {{#ifeq:{{{2|1}}}|0|1|{{{2|1}}}}} * 100 round 1}}{{ConfidenceInterval|{{{1|0}}}|{{{2}}}}} %).|{{#expr:{{{lsb|{{{asb}}}}}}*100 round 1}}%|gray}}]])</span>}}<!-- | ||
sample size larger than 500: just display horizon, dont care about ASB | sample size larger than 500: just display horizon, dont care about ASB | ||
-->| ([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}}/{{{2}}}. High data; Drop Rate should be accurate.|{{#expr:{{{1}}} / {{{2}}} * 100 round 1}}%}}]])}}}}}}}}}}</includeonly></onlyinclude> | -->| ([[HorizonXI:Drop Rate Policy|{{ht|{{{1}}}/{{{2}}}. High data; Drop Rate should be accurate.|{{#expr:{{{1}}} / {{{2}}} * 100 round 1}}%}}]])}}}}}}}}}}</includeonly></onlyinclude> | ||
| Line 27: | Line 27: | ||
Parameters | Parameters | ||
<pre> | <pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=|total drops|total kills}} | ||
</pre> | </pre> | ||
* | * lsb is the drop rate, written as a ratio a/b, from the | ||
* Setting | [https://raw.githubusercontent.com/LandSandBoat/server/refs/heads/base/sql/mob_droplist.sql Land Sand Boat Github Repository for drop rates].<small> (A list of all zones can be found [https://github.com/LandSandBoat/server/blob/base/documentation/ZoneIDs.txt here}.)</small> | ||
* ''Note'': The deprecated parameter ''asb'' can still be used to ensure backwards compatibility. It relates to | |||
[https://raw.githubusercontent.com/AirSkyBoat/AirSkyBoat/staging/modules/era/sql/era_mob_droplist.sql drop rates from the Air Sky Boat Github Repository], which was the code base before the [[Rebase|rebase-update of Jan 2026]]. <small>(A list of all zones can be found [https://github.com/AirSkyBoat/AirSkyBoat/blob/staging/documentation/ZoneIDs.txt here]. Although they should be identical to the LSB zone IDs)</small> | |||
* Setting lsb to ''false'' will invoke [[:Template:Retail Drop Rate]]. | |||
*if specifying a percentage value for the first unnamed parameter, then that percentage value will be displayed. Example: | *if specifying a percentage value for the first unnamed parameter, then that percentage value will be displayed. Example: | ||
<pre>{{Hxi Drop Rate|22%}}</pre> | <pre>{{Hxi Drop Rate|22%}}</pre> | ||
| Line 38: | Line 41: | ||
Logic: | Logic: | ||
* if sample size < 25: '''show | * if sample size < 25: '''show lsb''' | ||
* if 25 < sample size < 100: '''show | * if 25 < sample size < 100: '''show lsb''' but hint with red brackets IF difference between horizon droprate and asb is larger than the confidence interval of the sample. | ||
* if 100 < sample size < 500: '''show horizon''' but hint with purple brackets IF difference between horizon droprate and | * if 100 < sample size < 500: '''show horizon''' but hint with purple brackets IF difference between horizon droprate and lsb is larger than the confidence interval of the sample. | ||
* if 500 < sample size: '''show horizon''' | * if 500 < sample size: '''show horizon''' | ||
===Examples=== | ===Examples=== | ||
* no sample returns: | * no sample returns: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|0|0}} | ||
</pre> | </pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|0|0}} | ||
* sample size < 25: | * sample size < 25: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|1|10}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|1|10}} | ||
* 25 < sample size < 100, hxi agrees with | * 25 < sample size < 100, hxi agrees with lsb: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|5|60}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|5|60}} | ||
* 25 < sample size < 100, hxi deviates from | * 25 < sample size < 100, hxi deviates from lsb: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|30|60}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|30|60}} | ||
* 100 < sample size < 500, hxi agrees with | * 100 < sample size < 500, hxi agrees with lsb: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|10|120}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|10|120}} | ||
* 100 < sample size < 500, hxi deviates from | * 100 < sample size < 500, hxi deviates from lsb: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|93|120}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|93|120}} | ||
* 500 < sample size: | * 500 < sample size: | ||
<pre>{{Hxi Drop Rate| | <pre>{{Hxi Drop Rate|lsb=111/1000|312|1500}}</pre> | ||
{{Hxi Drop Rate| | {{Hxi Drop Rate|lsb=111/1000|312|1500}} | ||
==Drop Rate Guidelines== | ==Drop Rate Guidelines== | ||
Revision as of 11:30, 3 February 2026
Usage
Parameters
{{Hxi Drop Rate|lsb=|total drops|total kills}}
- lsb is the drop rate, written as a ratio a/b, from the
Land Sand Boat Github Repository for drop rates. (A list of all zones can be found [https://github.com/LandSandBoat/server/blob/base/documentation/ZoneIDs.txt here}.)
- Note: The deprecated parameter asb can still be used to ensure backwards compatibility. It relates to
drop rates from the Air Sky Boat Github Repository, which was the code base before the rebase-update of Jan 2026. (A list of all zones can be found here. Although they should be identical to the LSB zone IDs)
- Setting lsb to false will invoke Template:Retail Drop Rate.
- if specifying a percentage value for the first unnamed parameter, then that percentage value will be displayed. Example:
{{Hxi Drop Rate|22%}}
(22%)
Logic:
- if sample size < 25: show lsb
- if 25 < sample size < 100: show lsb but hint with red brackets IF difference between horizon droprate and asb is larger than the confidence interval of the sample.
- if 100 < sample size < 500: show horizon but hint with purple brackets IF difference between horizon droprate and lsb is larger than the confidence interval of the sample.
- if 500 < sample size: show horizon
Examples
- no sample returns:
{{Hxi Drop Rate|lsb=111/1000|0|0}}
(11.1%)
- sample size < 25:
{{Hxi Drop Rate|lsb=111/1000|1|10}}
(11.1%)
- 25 < sample size < 100, hxi agrees with lsb:
{{Hxi Drop Rate|lsb=111/1000|5|60}}
(11.1%)
- 25 < sample size < 100, hxi deviates from lsb:
{{Hxi Drop Rate|lsb=111/1000|30|60}}
(11.1%)
- 100 < sample size < 500, hxi agrees with lsb:
{{Hxi Drop Rate|lsb=111/1000|10|120}}
(11.1%)
- 100 < sample size < 500, hxi deviates from lsb:
{{Hxi Drop Rate|lsb=111/1000|93|120}}
(77.5%)
- 500 < sample size:
{{Hxi Drop Rate|lsb=111/1000|312|1500}}
(20.8%)
Drop Rate Guidelines
From Template:Retail Drop Rate
This section describes how the Drop Rate template works. If you are looking for rules and guidelines on use, see HorizonXI:Drop Rate Policy.
- This template is used to collect and present drop rate data. It is intended to collect data from multiple users and keep a running total (new results are added to the existing totals rather than replacing them), thus becoming more accurate over time.
- The drop rate is rounded to the nearest tenth, with a hovertext that displays the exact number of drops and kills and a message describing the data's current reliablity.
- If the data is too low to be considered reliable (less than 25 kills), the drop rate will be colored gray and question marks (???) will be displayed instead of the drop rate. However, the drop rate can still be seen in the hovertext next to the number of drops and kills.
- If the data is low, but not completely unreliable (less than 500 kills), the drop rate will simply be colored gray.
- "100%" can be used as the "total drops" value to automatically display the drop rate as 100%.
