Template:Jam occurrence leaderboard/query: Difference between revisions

From VNDev Wiki
← Older editNewer edit →
m do it this way?
most of a conversion to use /prop; simplified code
Line 1: Line 1:
{{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}}
{{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 1 2100}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}}
|?#-=jam
|?#-=jam
|?Has {{{for|entries}}}=count
|?Has {{{for|entries}}}=count
Line 13: Line 13:
<!-- The below section calculates the correct rank number by comparing to prior items  -->
<!-- The below section calculates the correct rank number by comparing to prior items  -->
|userparam={{#ifexpr: {{{1}}} = 1 | 1 |  
|userparam={{#ifexpr: {{{1}}} = 1 | 1 |  
     {{#ifexpr: {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }}
     {{#ifexpr: {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{#expr: {{{1}}}-1}} }}
       = {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-2}} }}
       = {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{#expr: {{{1}}}-2}} }}
       | <!--At least two way tie; now test for three way tie-->
       | <!--At least two way tie; now test for three way tie-->
         {{#ifexpr: {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }}
         {{#ifexpr: {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{#expr: {{{1}}}-1}} }}
           = {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-3}} }}
           = {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{#expr: {{{1}}}-3}} }}
           | {{#expr: {{{1}}}-2}} (tie)
           | {{#expr: {{{1}}}-2}} (tie)
           | {{#expr: {{{1}}}-1}} (tie)
           | {{#expr: {{{1}}}-1}} (tie)
         }} <!--end if for three-way tie-->  
         }} <!--end if for three-way tie-->  
       | <!--Not a tie or is first instance of a tie. Now test if tied with next item.-->
       | <!--Not a tie or is first instance of a tie. Now test if tied with next item.-->
         {{#ifexpr: {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{#expr: {{{1}}}-1}} }}
         {{#ifexpr: {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{#expr: {{{1}}}-1}} }}
         = {{#ask: [[Jam occurrence:+]] [[Has end date::<{{{date|Jan 24 2025}}}]] {{#ifeq:{{{vnOnly|}}}|VN-specific jams|[[Is visual novels only::true]]|}} |?Has {{{for|entries}}}#-|format=plainlist|sort=Has {{{for|entries}}}|order=descending|limit=1|link=none|searchlabel=|headers=hide|mainlabel=-|offset={{{1}}} }}
         = {{Jam occurrence leaderboard/prop | date={{{date|}}} | vnOnly={{{vnOnly|}}} | for={{{for}}} | offset={{{1}}} }}
           | {{{1}}} (tie)
           | {{{1}}} (tie)
           | {{{1}}}
           | {{{1}}}

Revision as of 08:32, 25 January 2025

Template:Jam occurrence leaderboard/row-entries

Retrieved from "https://vndev.wiki/index.php?title=Template:Jam_occurrence_leaderboard/query&oldid=4491"