Mario Kart PC Forum - Advanced search

Everyone with a WR and how many WRs they have:
User ID: 32396, Username: JPG  — 23 WRs
User ID: 48717, Username: Anthcny — 9 WRs
User ID: 6013, Username: Arracheur2Beuteu — 7 WRs
User ID: 3586, Username: Fways — 6 WRs
User ID: 40764, Username: Ahmad Elkhuffash — 6 WRs
User ID: 41425, Username: Hgt — 2 WRs
User ID: 5164, Username: Mudky — 1 WR
User ID: 49980, Username: ﷽ — 1 WR
User ID: 147254, Username: PlsfirehopLETSGOOOWETOOGOOD — 1 WR

Every WR sorted by duration:
SNES Bowser Castle 2: 865 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Donut Plains 2: 790 days, WR set by JPG  (User ID: 32396)
SNES Ghost Valley 3: 602 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Yoshi Falls: 582 days, WR set by JPG  (User ID: 32396)
SNES Choco Island 2: 498 days, WR set by JPG  (User ID: 32396)
SNES Vanilla Lake 2: 479 days, WR set by JPG  (User ID: 32396)
DS Airship Fortress: 473 days, WR set by Hgt (User ID: 41425)
SNES Bowser Castle 3: 432 days, WR set by Mudky (User ID: 5164)
SNES Choco Island 1: 243 days, WR set by Hgt (User ID: 41425)
DS Waluigi Pinball: 208 days, WR set by JPG  (User ID: 32396)
SNES Bowser Castle 1: 164 days, WR set by JPG  (User ID: 32396)
SNES Mario Circuit 3: 164 days, WR set by JPG  (User ID: 32396)
SNES Ghost Valley 2: 164 days, WR set by JPG  (User ID: 32396)
SNES Mario Circuit 2: 159 days, WR set by JPG  (User ID: 32396)
GBA Riverside Park: 156 days, WR set by JPG  (User ID: 32396)
DS Tick-Tock Clock: 148 days, WR set by Fways (User ID: 3586)
DS Peach Gardens: 79 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Yoshi Desert: 68 days, WR set by JPG  (User ID: 32396)
DS Wario Stadium: 61 days, WR set by JPG  (User ID: 32396)
GBA Bowser Castle IV: 51 days, WR set by JPG  (User ID: 32396)
DS Shroom Ridge: 51 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Lakeside Park: 50 days, WR set by JPG  (User ID: 32396)
GBA Ribbon Road: 47 days, WR set by JPG  (User ID: 32396)
GBA Boo Lake: 39 days, WR set by ﷽ (User ID: 49980)
DS Bowser's Castle: 38 days, WR set by PlsfirehopLETSGOOOWETOOGOOD (User ID: 147254)
SNES Donut Plains 3: 35 days, WR set by JPG  (User ID: 32396)
GBA Sunset Wilds: 30 days, WR set by Anthcny (User ID: 48717)
DS Figure 8 Circuit: 26 days, WR set by Arracheur2Beuteu (User ID: 6013)
GBA Sky Garden: 20 days, WR set by Fways (User ID: 3586)
DS Delfino Square: 20 days, WR set by Arracheur2Beuteu (User ID: 6013)
DS DK Pass: 19 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Bowser Castle II: 16 days, WR set by Arracheur2Beuteu (User ID: 6013)
SNES Ghost Valley 1: 15 days, WR set by JPG  (User ID: 32396)
GBA Bowser Castle III: 15 days, WR set by Arracheur2Beuteu (User ID: 6013)
GBA Cheep-Cheep Island: 14 days, WR set by Anthcny (User ID: 48717)
GBA Shy Guy Beach: 12 days, WR set by Anthcny (User ID: 48717)
GBA Rainbow Road: 12 days, WR set by JPG  (User ID: 32396)
SNES Mario Circuit 1: 11 days, WR set by Anthcny (User ID: 48717)
SNES Koopa Beach 2: 11 days, WR set by Arracheur2Beuteu (User ID: 6013)
GBA Peach Circuit: 11 days, WR set by Anthcny (User ID: 48717)
DS Mario Circuit: 11 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Rainbow Road: 11 days, WR set by JPG  (User ID: 32396)
SNES Koopa Beach 1: 7 days, WR set by JPG  (User ID: 32396)
SNES Mario Circuit 4: 7 days, WR set by JPG  (User ID: 32396)
GBA Mario Circuit: 7 days, WR set by JPG  (User ID: 32396)
GBA Cheese Land: 7 days, WR set by Arracheur2Beuteu (User ID: 6013)
DS Luigi's Mansion: 7 days, WR set by JPG  (User ID: 32396)
SNES Donut Plains 1: 5 days, WR set by Fways (User ID: 3586)
GBA Broken Pier: 5 days, WR set by Fways (User ID: 3586)
DS Cheep Cheep Beach: 5 days, WR set by Fways (User ID: 3586)
SNES Vanilla Lake 1: 3 days, WR set by Anthcny (User ID: 48717)
SNES Rainbow Road: 3 days, WR set by Fways (User ID: 3586)
DS Desert Hills: 3 days, WR set by Anthcny (User ID: 48717)
GBA Bowser Castle I: 2 days, WR set by Arracheur2Beuteu (User ID: 6013)
GBA Snow Land: 2 days, WR set by Anthcny (User ID: 48717)
GBA Luigi Circuit: 0 days, WR set by Anthcny (User ID: 48717)

Every username associated with a user ID in a WR:
User ID: 32396, Names: JPG , JPG, JPG , JPG, JPG , JPG , JPG , JPG , JPG , JPG, JPG , JPG , JPG , JPG, JPG, JPG, JPG, JPG, CG_JPG, JPG , JPG , JPG, JPG
User ID: 48717, Names: Anthcny, Anthcny, Anthcny, Anthcny, Anthcny, Anthcny, Anthcny, Anthcny, Anthcny
User ID: 6013, Names: Arracheur2Beuteu, Arracheur2Beuteu, Arracheur2Beuteu, K$, K$£€, K$£€, K$
User ID: 3586, Names: Fways, Fways, Fways, Fways, Fways, Fways
User ID: 40764, Names: Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash
User ID: 41425, Names: Hgt, Hgt
User ID: 5164, Name: Mudky
User ID: 49980, Name: ﷽
User ID: 147254, Name: PlsfirehopLETSGOOOWETOOGOOD

How many WRs and players with WRs each country has:
Spain (es) — 23 WRs, 1 player: JPG
France (fr) — 22 WRs, 3 players: Anthcny, Fways, Arracheur2Beuteu
United Arab Emirates (ae) — 6 WRs, 1 player: Ahmad Elkhuffash
Philippines (ph) — 2 WRs, 1 player: Hgt
Not Specified (None) — 2 WRs, 2 players: ﷽, PlsfirehopLETSGOOOWETOOGOOD
Switzerland (ch) — 1 WR, 1 player: Mudky

Every character used in a WR ranked by how frequently they're used:
— 8 times
— 6 times
— 6 times
— 5 times
— 3 times
— 3 times
— 2 times
— 2 times
— 2 times
— 2 times
— 2 times
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time
— 1 time

Everyone with a WR and how many WRs they have:
User ID: 40764, Username: Ahmad Elkhuffash — 52 WRs
User ID: 49980, Username: 𝔧𝔧 — 2 WRs
User ID: 48717, Username: Anthcny — 1 WR
User ID: 86185, Username: ImJustLimey — 1 WR

Every WR sorted by duration:
SNES Koopa Beach 2: 872 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Mario Circuit: 830 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Donut Plains 3: 815 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Bowser Castle III: 749 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Luigi's Mansion: 740 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Bowser Castle 1: 732 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Sunset Wilds: 732 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Peach Circuit: 711 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Vanilla Lake 1: 604 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Choco Island 1: 586 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Ghost Valley 1: 566 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Shy Guy Beach: 435 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Cheep Cheep Beach: 413 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Tick-Tock Clock: 405 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Mario Circuit 4: 368 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Lakeside Park: 321 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Riverside Park: 308 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Ribbon Road: 296 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Cheep-Cheep Island: 295 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Yoshi Falls: 295 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Peach Gardens: 295 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Bowser Castle I: 294 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Bowser Castle II: 294 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Yoshi Desert: 235 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Delfino Square: 235 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Cheese Land: 192 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Bowser Castle 3: 166 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Sky Garden: 159 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Rainbow Road: 159 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Donut Plains 2: 127 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Rainbow Road: 121 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Desert Hills: 121 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Waluigi Pinball: 112 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Donut Plains 1: 103 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Snow Land: 94 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Mario Circuit: 94 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Luigi Circuit: 93 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Bowser Castle IV: 93 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Boo Lake: 77 days, WR set by 𝔧𝔧 (User ID: 49980)
DS Shroom Ridge: 68 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Vanilla Lake 2: 51 days, WR set by 𝔧𝔧 (User ID: 49980)
SNES Ghost Valley 3: 47 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Ghost Valley 2: 46 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Bowser Castle 2: 38 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Mario Circuit 2: 37 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Rainbow Road: 37 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Airship Fortress: 37 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS Wario Stadium: 37 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Mario Circuit 1: 36 days, WR set by Anthcny (User ID: 48717)
DS Figure 8 Circuit: 35 days, WR set by Ahmad Elkhuffash (User ID: 40764)
DS DK Pass: 35 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Choco Island 2: 34 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Mario Circuit 3: 34 days, WR set by Ahmad Elkhuffash (User ID: 40764)
SNES Koopa Beach 1: 26 days, WR set by ImJustLimey (User ID: 86185)
DS Bowser's Castle: 26 days, WR set by Ahmad Elkhuffash (User ID: 40764)
GBA Broken Pier: 7 days, WR set by Ahmad Elkhuffash (User ID: 40764)

Every username associated with a user ID in a WR:
User ID: 40764, Names: Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash, Ahmad Elkhuffash
User ID: 49980, Names: 𝔧𝔧, Ok Run Ig
User ID: 48717, Name: Anthcny
User ID: 86185, Name: ImJustLimey

How many WRs and players with WRs each country has:
United Arab Emirates (ae) — 52 WRs, 1 player: Ahmad Elkhuffash
Not Specified (None) — 2 WRs, 1 player: 𝔧𝔧
France (fr) — 1 WR, 1 player: Anthcny
Not Specified (mx) — 1 WR, 1 player: ImJustLimey

Every character used in a WR ranked by how frequently they're used:
— 53 times
— 1 time
— 1 time
— 1 time

import datetime
import mkpc_ttdata

def pluralize_word(n: int, singular: str, plural: str) -> str:
   if n == 1:
       return singular
   else:
       return plural
   
data = mkpc_ttdata.ttwrs

name_id_map = {}
characters = {}
countries = {}
dates = {}

map_id: int = 0
for item in data:
   map_id += 1
   for arr in item["list"]:
       if arr[0] == 1:
           country = arr[5]
           if country not in countries:
               countries[country] = {"players": [], "count": 0}
           countries[country]["count"] += 1

           name = arr[1]
           user_id = arr[4]
           if user_id not in name_id_map:
               name_id_map[user_id] = {"names": [], "count": 0}
               countries[country]["players"].append(name)
           name_id_map[user_id]["names"].append(name)
           name_id_map[user_id]["count"] += 1
           
           character = arr[2]
           if character not in characters:
               characters[character] = 0
           characters[character] += 1

           date_str = arr[6]
           record_date = datetime.datetime.strptime(date_str, "%m-%d-%y"
           dates[(map_id, user_id)] = record_date


sorted_user_data = sorted(name_id_map.items(), key=lambda x: x[1]["count"], reverse=True)

print("Everyone with a WR and how many WRs they have:"
for user_id, info in sorted_user_data:
   name = info["names"][0]
   wr_amount = info["count"]
   word = pluralize_word(wr_amount, "WR", "WRs"
   print(f"User ID: {user_id}, Username: {name} — {wr_amount} {word}"


time_since_records = []
current_date = datetime.datetime.now()

for (map_id, user_id), record_date in dates.items():
   time_since_record = (current_date - record_date).days
   player_name = name_id_map[user_id]["names"][0]
   time_since_records.append((map_id, time_since_record, user_id, player_name))

sorted_time_since_records = sorted(time_since_records, key=lambda x: x[1], reverse=True)

print("\nEvery WR sorted by duration:"
for map_id, time_since_record, user_id, player_name in sorted_time_since_records:
   map_name = mkpc_ttdata.map_id_to_name(map_id)
   print(f"{map_name}: {time_since_record} days, WR set by {player_name} (User ID: {user_id})"


print("\nEvery username associated with a user ID in a WR:"

sorted_users = sorted(name_id_map.keys(), key=lambda user_id: len(name_id_map[user_id]["names"]), reverse=True)

for user_id in sorted_users:
   names = name_id_map[user_id]["names"]
   word = pluralize_word(len(names), "Name", "Names"
   print(f"User ID: {user_id}, {word}: {', '.join(names)}"


print("\nHow many WRs and players with WRs each country has:"
sorted_countries = sorted(countries.items(), key=lambda x: x[1]["count"], reverse=True)
for country, info in sorted_countries:
   player_count = len(info["players"])

   player_word = pluralize_word(player_count, "player", "players"
   wr_word = pluralize_word(info['count'], "WR", "WRs"
   country_word = mkpc_ttdata.convert_country_code(country)
   print(f"{country_word} ({country}) — {info['count']} {wr_word}, {player_count} {player_word}: {', '.join(info['players'])}"


sorted_characters = sorted(characters.items(), key=lambda x: x[1], reverse=True)
print("\nEvery character used in a WR ranked by how frequently they're used:"
for character, count in sorted_characters:
   word = pluralize_word(count, "time", "times"
   character_link = character
   if character == "daisy":
       character_link = f""
   else:
       character_link = f""
   
   print(f"{character_link} — {count} {word}"

import requests

def convert_country_code(country_code: str) -> str:
   countries = {
       "es": "Spain",
       "fr": "France",
       "ae": "United Arab Emirates",
       "ph": "Philippines",
       "ch": "Switzerland",
   }

   default_country = "Not Specified"

   return countries.get(country_code, default_country)

def map_id_to_name(needed_map_id) -> str:
   names =  'Mario Circuit 1','Donut Plains 1','Koopa Beach 1','Choco Island 1','Vanilla Lake 1','Ghost Valley 1','Mario Circuit 2','Bowser Castle 1','Donut Plains 2','Bowser Castle 2','Choco Island 2','Mario Circuit 3','Koopa Beach 2','Vanilla Lake 2','Ghost Valley 2','Donut Plains 3','Ghost Valley 3','Mario Circuit 4','Bowser Castle 3','Rainbow Road','Peach Circuit','Shy Guy Beach','Riverside Park','Bowser Castle I','Mario Circuit','Boo Lake','Cheese Land','Bowser Castle II','Luigi Circuit','Sky Garden','Cheep-Cheep Island','Sunset Wilds','Snow Land','Ribbon Road','Yoshi Desert','Bowser Castle III','Lakeside Park','Broken Pier','Bowser Castle IV','Rainbow Road','Figure 8 Circuit','Yoshi Falls','Cheep Cheep Beach','Luigi\'s Mansion','Desert Hills','Delfino Square','Waluigi Pinball','Shroom Ridge','DK Pass','Tick-Tock Clock','Mario Circuit','Airship Fortress','Wario Stadium','Peach Gardens','Bowser\'s Castle','Rainbow Road'
   map_id: int = 0
   map_amount = 56
   for name in names:
       map_id += 1
       if map_id == (map_amount + 1):
           break
       prefix = "DS"
       if map_id <= 40:
           prefix = "GBA"
       if map_id <= 20:
           prefix = "SNES"
       new_name = f"{prefix} {name}"
       if map_id == needed_map_id:
           return new_name
   return "???"

url = "https://mkpc.malahieude.net/api/getTtRanking.php"
data = {
   "cc": 150,
   "count": 1
}

response = requests.post(url, data=data)
if response.status_code == 200:
   ttwrs: str = response.json()
else:
   print("Couldn't get tt data. Status code:", response.status_code)