search

wesnoth / wesnoth-multiplayer-data-dashboard

This is a dashboard that allows you to query and visualize data that the Wesnoth Project collects about multiplayer games played on the official server.
2 stars 0 forks source link

Request For Replay Link/Title from dashboard-exported CSV data #3

Closed MapDesignerOfHiveWorkshop closed 1 week ago

MapDesignerOfHiveWorkshop commented 11 months ago

Hello,

May I ask for replay link in the dashboard CSV data sheet exported through the given filters?

max-torch commented 6 months ago

The solution for having clickable links inside of Dash DataTable is to embed Markdown inside of the table and use the Markdown syntax for a link.

https://community.plotly.com/t/clickable-link-dash-datatable/54961/3

Possible solution for generating the download URL would be, from the query, to use the Start Date field to extract the year, month, and day; and then the name field for the game name; and then concatenate strings as needed:

f"{base_url}/{year}/{month}/{day}/{game_name}.bz2"
soliton- commented 6 months ago

This is how the game constructs the URL: https://github.com/wesnoth/wesnoth/blob/479ccc7fdf6ded23fc332b40ba73930b55855534/src/server/common/dbconn.cpp#L143-L149

max-torch commented 1 week ago

We will not focus on this for now because some kind of secure Markdown parsing logic needs to be written to get this to work.