scoreboard | CRG Derby Scoreboard

I have a table called scoreboard and I want to fetch two player above and below based on rank for the arbitrary player.

For example, The given table contains the name and rating.

For a given player Zephrus, I need to show below records. Two above him and two below.

How can I achieve this? I got to know how to find rank using the rank window function in PostgreSQL but not sure how do I achieve two above and two below for a given player effectively.

I seen similar posts but nothing was really close to how I'm doing things so I made another post. I'm building a scoreboard for a map I'm making in VRChat and in case someone is not familiar with how that goes, VRChat limits what people can do with C# so I can't use lists, dictionaries, or do convenient things like import the System library and use Array.Sort() or Array.Reverse() and so on.

I used my own sorting method to get an array of player scores in descending order but the original index positions of the scores is important to keep consistent with the array of players ID's. So I need to know where the current score index was in relation to where it is after being sorted. for example {10, 20, 30, 40, 15} would be sorted {40, 30, 20, 15, 10} and I need reference to where the original order of scores are now in the sorted array, so I would make a indexSorted array that I need to give me back {3, 2, 1, 4, 0}

I'm now working on the nested for loop to get that data for me. So I keep the original array and make a copy so that I can compare array elements against each other to get the data. It seems to be working for the most part but I'm having a slight issue. The following code uses test data so I can get the algorithm working first before I implement it into my map and for the convenience of replicating my code and trying to help me figure out what's going wrong.

Output of indexSorted array: {4, 3, 1, 2, -1, 5} -1 indicates there was an issue in the loop but the logic seems to make sense to me so I can't figure out what it's doing wrong. indexSorted keeps track of index's already checked so I don't want to populate the array with any positive integer or 0

I'm trying to create a scoreboard using phaser3. It creates the board when I do the following in create function:

I'm making a tic-tac-toe game in python and right now I'm designing the GUI using Tkinter. The problem is that when I add 3 X's or O's to a row, the height of the button shrinks. I've played around with (i)padx and (i)pady and changing the font size, but nothing I've done has solved the issue. Anyone know how to fix this?

Here when the player types '!start', he will be added to the scoreboard dictionary.

I would like to embed sliderInput() widgets directly in a row in a DT table.

My problem is different to this: Shiny widgets in DT Table, since it uses an existing data frame (not based purely on user input).

The desired table (see picture below) shows a composite index (column "Index", column 4) that reflects the labor market situation of youth in several countries based on certain indicators (e.g. unemployment rate). Indicators are grouped into four dimensions. The (sub-)index values by dimension are shown in columns 6-9. The four sliderInput()s in the left panel allow giving different weights to each of the four dimensions ("0" for muting it, "3" as the highest weight). Changing the sliderInput() triggers a recalculation of the aggregate index with the result of the corresponding "Weighted Index" being shown in column 5.

To show the user more intuitively to which column which sliderInput() belongs, I would like to place them directly in the table in the respective column (e.g. the sliderInput() for the dimension "Activity State" in column 6) in a row below the header. I marked the places red in the.png below. Therefore, it may be better to use a selectInput widget).

I'd be very grateful if anyone could give me a hint how to achieve this?

The header of the table was created using the package htmltools (see code below), which may complicate things.

Note that, besides the ui and sever part, the code below contains a minimal example of my data frame and a helper function that recalculates the index based on user input.

Code to reproduce problem:

Users can re-submit results for the competition and it updates the results on the scoreboard, however, it also creates a save of the result for the "Way back when" feature of being able to view results previously to see improvements of scores.

The issue I have is that duplicate entries exist for certain months, the only thing that changes in the database is the primary key id, the created_at and updated_at. If the column values: discipline_n wheren is one through six are all the same as any others should not be queried, ie:

I want to do something like this: