This is a web app to see stats from Jedi Knight: Jedi Academy Mod jaPRO.
License: MIT License
update cache only when localduel or localrun is updated etc..
It should have a dropdown filter to pick which style to graph, or it should graph all at once with different line colors.
It should also smooth the lines maybe?
Duel list panel should have a player filter just like the race list panel does.
(When page is loaded?), Server check if last update was within X time, and if so auto update.
(When page is loaded?) Client check if last update was more than Y time ago, if so draw update button. Otherwise gray button out and print "up to date".
Update button needs to reload the datatables with the new json
If last update was less than Y time ago, draw last update time and make update button clickable.
X= 6 hours?
Y= 1 minute?
longshot - it should reload the tables/charts instead of the whole page
the website scores get desyncd (they seem to always be lower than the ingame ones).
its a problem with the website or stat API i think. ingame is correct and does not change when rebuilt.
maybe a problem with last_update column somewhere.
remaking the web race DB fixes the problem.
its not a problem with the # of rows (its the same before and after remake). but some of the contents (rank/season_rank/entries/season_entries) are getting desyncd somehow?
4 buttons: all, last week, last 3 months, last year
Each button sets start_time POST var (0, -7, -90, -365) and requeries getJSON.
buttons are now there, but they dont get valid json or they are not able to update the table?
Remove duel_count JSON since we already have that relevant data (username, count) in the duel_rank json. Adapt the chart to use the existing ladder_duel_rank json.
Racerank filter dropdown should be set to "-1 All Styles" on pageload and the table should be filtered to that on pageload if possible
Need to manage the template palette color on config.inc.php.
The style and user dropdowns can get their values from the existing raceranks json data, the map dropdown will have to use a new json from a new query
They should update filterPlayer, filterMap, filterStyle vars
On select/change, they should requery getJSON
This lets us have a fast pageload (only load recent races to .json) but also have every option for filtering, and when a filter is applied a new query will be done.
This would replace the existing dropdown filters in race_list
Ideally the new dropdowns would use live-search https://silviomoreto.github.io/bootstrap-select/examples/
Once a map is selected, change sort order to 1st column (rank) instead of end_time
end_time, etc
using APNG? or WebM with matching background color.
Add a player section to see all of the players stats.
The stats of guns section does not seems to show correctly, need to show up gun name and not his id.
so website can get .db info from external gameserver
update button and last update time text should exist on - race, player, and duel pages
if last update time is >6 hours(?), auto update
otherwise only update when button is pressed
dont allow update from button press if last update was within 1 minute
when button is pressed, update (race page updates race table, etc)
player page updates everything
store last_update_time for localduel (end_time), and localaccount (lastlogin)
only get rows since last updatetime for localduel/localaccount
for localrun, get all rows since races affect other race scores (or store last_update_time in the localrun row and compare to that?)
either be aware of race duplicates when updating or just insert then cleanup duplicates at very end
when races are updated, create race_rank query cache
when duels are updated, create duel_rank query cache
use json compression
not sure why
Most items with decimal places should be rounded to 2 decimal digits, but only if needed. For example, 5 instead of 5.00.
The filter change should apply to recent duels, duel ranks, and the pie chart. So that only duels of the selected type are shown.
Remove the style filter boxes from inside the panels on the race page and move it to the top of page. It should then apply to all panels on the page (race list, race ranks, pie chart).
RaceStyle/DuelType filter dropdowns should be sorted by their style, not alphabetically. Remove the #- prefix from Style filter.
This way we can sort by it properly. Before we do this though I have to fix the rank calculation in the japro mod, which might be hard.
To be displayed on players profile page
Cumulative awards ?
100 duels won, etc
Race awards
Completed a-mountain
completed dash1 in under 9.6 seconds, etc....
Also remove lengthchange option from race rank table
The code is there, the background image just needs to be formatted properly so it looks less ugly..
all the racepack5/6 courses
and redo a bunch of the images that are just the door textures
Need a Dashboard to show general server stats with some charts.
td align=right
etc
the code in drawCallback messes up, it used to work though?
seems to work if the table is from localstorage, but not if the table is from ajax?
But we also have to keep the functionality of the dropdown filters. So maybe there is a way to just make them hidden?
This would replace the style filter box from inside the race list panel since we are moving that to the top of page.
typo somewhere?
with servertracker for japro servers, using paratracker (http://pt.dogi.us/?ip=162.248.89.208&port=29070&skin=JSON&filterOffendingServerNameSymbols=true&displayGameName=true&enableAutoRefresh=true&levelshotsEnabled=true&enableGeoIP=true) (.json?) or https://github.com/kohabi/quake-query
mostly works but the image doesnt take up the whole page
bootstrap wrapper/container-fluid , needs to be full page height(?)
caused by the align-right of duration
not sure how it should look
All other columns seem to be syncd.
Tested with select sum(entries) from both, gives different values (webserver has lower number). Can't replicate ATM. Does not seem to happen after a webserver DB wipe and refresh.
Also even with identical data, mysql seems to calculate the dftoprank score column differently?
to replicate: clear web DB, get up to date race stats from gameserver. Check the race_rank table and also run the race_rank query n sqlite on the gameserver data and the numbers will be different.
but work fine for season 2 and all seasons?
Add "All" option to dropdowns in racelist. Or have a way to clear filter selection. On race pageload, default option should be "All" option or unfiltered.
Something like the live-search option here
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.
