peppy

# noinspection SqlResolveForFile

-- Partitioned by (preserve)

DROP TABLE IF EXISTS `partitioned_solo_scores`;

-- existing structure on production
CREATE TABLE `partitioned_solo_scores` (
                               `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                               `user_id` int unsigned NOT NULL,

peppy

osu! community meeting (2021-09-19)

When and where

Meeting held in the official osu!dev discord in voice chat at 01:00 UTC.
Discord link: https://discord.gg/ppy
Full VOD: https://www.youtube.com/watch?v=-LjNll8VYTM

Hosts

peppy

using System;
using System.Collections.Generic;
using System.Runtime.InteropServices;
using System.Text;

namespace osu.Helpers
{
    class WindowsKey
    {
        private delegate int LowLevelKeyboardProcDelegate(int nCode, int wParam, ref KBDLLHOOKSTRUCT lParam);

peppy

using System;
using System.Collections.Generic;
using System.Linq;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Running;
using Realms;

namespace RealmPerformanceTest
{
    internal static class Program

peppy

{include file="header.tpl" title="Welcome"}
<h1>Welcome to osu!, {$user.username}!</h1>

<div class='paddingboth'>
	<div style='float:right'>
		<img src='{$STATIC_SERVER}/images/welcome.png' style='padding-right: 5px'/>
	</div>
	<div>Here are a few resources to help you start your journey:</div>
	<ul>
		<li><a href="/forum/viewtopic.php?f=14&t=5456">Beginner Training</a> - hand-picked beatmaps to get you started.</li>

peppy

Thanks for following along! This is a tagged release ($BUILD_ID). For more information check out the osu! changelog page and dev blog.

peppy

List<double> result = GetErrorStatisticsArray(score.HitErrors);

hint = String.Format("Accuracy:\nError: {0:0.00}ms - {1:0.00}ms avg\nUnstable Rate: {2:0.00}\n", result[0], result[1], result[4] * 10, result[6], result[5]);

// input is a list of (user_hit_time - correct_time)
internal List<double> GetErrorStatisticsArray(List<int> list)
{
    if (list == null || list.Count == 0)
        return null;
    List<double> result = new List<double>(4);

peppy

03:38 < ZenZenFTW> did someone just sneeze?
04:10 < Ascendrio> I just hear a sneeze
04:15 < Bruschetta> I entered a map and heard a sneeze from the game
04:23 < Bruschetta> my osu just sneezed again rEE
04:23 < FurryTrash> my osu! doesn't sneeze?
06:12 < Narukiko> did i just hear a sneeze?
06:12 < Narukiko> sneeze in-game?
06:47 < Cielo_Day> did i just a hear someone sneeze or..?
07:37 < -4ourth-> someone sneezed in the game
07:58 < XeRoHD> does anyone get this sneeze sound effect when someone starts a beatmap?

peppy

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Humanizer;

namespace metadata
{

peppy

INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('A1', 'Anonymous Proxy', 26541697520, 241879, 594, 17679, 0, 0);
INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('A2', 'Satellite Provider', 65226890, 2222, 14, 0, 0, 0);
INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('AD', 'Andorra', 13678792724, 116117, 221, 16980, 0, 0);
INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('AE', 'United Arab Emirates', 1046119820081, 8190611, 8381, 1047573, 1, 1);
INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('AF', 'Afghanistan', 716275055, 6943, 23, 1399, 0, 0);
INSERT INTO osu.osu_countries (acronym, name, rankedscore, playcount, usercount, pp, display, shipping_rate) VALUES ('AG', 'Anti