Comments (7)
Well, it has been some time (busy with exams, went on holiday, had other stuff to do, etc.) but I did something! The configuration format is even more powerful now (almost created an entire programming language 😄), although I think I missed some things still (like the uuid
converter function, coming soon!). I hope it works for at least some of your databases/tables. I tested with these database configurations:
table1 is like your first screenshot (what it looks like in mysql)
uuid | value |
---|---|
uu1 | {"exp": 0.0} |
uu1 | {"money": 42} |
uu2 | {"exp": 1.0} |
table2 is just plain
player | exp | money |
---|---|---|
p1 | 0.0 | 42 |
p2 | 1.0 |
table3 is like your last screenshot
playerID | category | count |
---|---|---|
uu1 | mobs.ReaperMinion | 1 |
uu2 | mobs.Bees | 1 |
This would be a possible configuration file for it:
[ // array of configuration items, each for one database-table combination
{
"database": "db1",
"table": "table1",
"convert": [ // array of conversion operations, performed in-order
["json", "value"], // json command takes a column argument; that column will be converted from json
["uuid", "uuid"], // uuid command also takes a column argument
["rename", "uuid", "player"] // rename command takes two column names
// ("uuid" column will be renamed to "player" here)
]
},
{
"database": "db1",
"table": "table2"
// convert array is optional
},
{
"database": "db1",
"table": "table3",
"convert": [
["key-value", "category", "count"], // key-value unpack takes two columns,
// the value of the first column is the key and will become a column,
// the value of the second column will be its value
["rename", "playerID", "player"] // rename "playerID" column to "player"
]
}
]
In order to merge the different tables into one, every table needs to end up with a "player" column.
Installation should be as easy as uploading the php files and pointing everything to each other. I added a configuration option to the JS part so you can manually set up the URLs like this: (this replaces the ip
and port
config options)
new WebStats({
connection: new Connection({
scores: "path/to/stats.php",
online: "http://ip:port/online.json"
})
// ... rest of config
})
Also, the database.php
file needs the username and password of course.
I hope this is of use to you. If you have trouble with anything, I would be very glad to help! I will write more extensive documentation in the readme soon, as well as work on one or two more converter functions - please let me know if you have other ideas!
from webstats.
Hi, hello! Thanks for opening an issue here!
It sounds like an interesting idea. I think in principle the only thing that would be needed is a PHP script that puts the content of the MySQL database into JSON (and some small fixes). I'm not that experienced in PHP, but I can give it a try (or do you know PHP yourself maybe?)
I'm not sure how you have your database layed out, would you mind sharing how you store the objectives and entries?
from webstats.
Sorry for the delayed response and thank you for your response!
I'm not familiar with any language besides slight Java, as I recently began learning. Although I do wish I could help.
Now considering how each Database can be stored completely differently, I think it might be very challenging to allow for easy configuration.
I attached an example of how one of the Plugins I use, store data.
If there is anything else I can do to assist, please let me know!
from webstats.
No worries!
Thank you for the screenshots, they help me understand it a bit better. It does indeed look to be a bit more challenging than I at first thought, because you can have multiple databases, each with a different layout, and they all have to combine into one table. (adding to that the fact that users are stored by UUID, not playername)
After having thought a bit, I think it can be done with a semi user-configurable setup with a JSON config file, so here is my idea. The following example is for 2 databases with 1 table each, the first one being in the format of your screenshot, the second one would be for when you just have the columns player
, exp
and money
in the database:
[
{
"database": "db1",
"table": "table1",
"key": "uuid",
"columns": ["value"],
"convert": ["uuid", "json"],
"renameColumns": { "uuid": "player" }
},
{
"database": "db2",
"table": "table2",
"key": "player",
"columns": ["exp", "money"]
}
]
There would then be a couple of pre-defined mapping functions (each with the same signature) that convert an entire data row: (it might be better/easier to convert only a single item at a time instead of an entire row, but not sure)
uuid(row, config)
would convert player UUIDs in the keys to usernamesjson(row, config)
would expand a JSON object in the values to multiple columns.
The PHP script would need to combine multiple rows, tables and databases into a single data object.
Example stages of data (using JSON terminology / display) for the first config item in the example above (corresponding to the layout of your screenshot):
- Array of objects, directly from database:
[ {"uuid": "...da", "info_id": 1, "value": "{\"itemMap\": {...}}"}, {"uuid": "...da", "info_id": 2, "value": "{\"exp\": 0.0, ...}"}, {"uuid": "...0f", "info_id": 1, "value": "{\"itemMap\": {...}}"} ]
- After conversion function 1:
uuid
[ {"uuid": "Player1", "info_id": 1, "value": "{\"itemMap\": {...}}"}, {"uuid": "Player1", "info_id": 2, "value": "{\"exp\": 0.0, \"offlineExp\": 0.0}"}, {"uuid": "Player2", "info_id": 1, "value": "{\"itemMap\": {...}}"} ]
- After conversion function 2:
json
[ {"uuid": "Player1", "itemMap": {...}}, {"uuid": "Player1", "exp": 0.0, "offlineExp": 0.0}, {"uuid": "Player2", "itemMap": {...}} ]
- After column renaming
[ {"player": "Player1", "itemMap": {...}}, {"player": "Player1", "exp": 0.0, "offlineExp": 0.0}, {"player": "Player2", "itemMap": {...}} ]
- (combine data from multiple config items (multiple SQL tables/databases) at this point)
- After combining rows with the same keys
[ {"player": "Player1", "itemMap": {...}, "exp": 0.0, "offlineExp": 0.0}, {"player": "Player2", "itemMap": {...}} ]
- After transposing (array of key+columns to object of columns of key+value)
{ "itemMap": { "...da": "[], [], ...", "...0f": "[], [], ..." }, "exp": { "...da": 0.0 } }
- Final output
{ "entries": ["...da", "...0f"], "scores": { "itemMap": ..., "exp": ... } }
For your screenshot, the above configuration should produce the following table. I hope this is about how that data should be displayed? I'm not sure what itemMap
is storing and how to display it though:
Player | itemMap | exp | offlineExp | money | offlineMoney | ... |
---|---|---|---|---|---|---|
Player1 (...da) | [], [], [], [], ... | 0.0 | 0.0 | 0.0 | 0.0 | ... |
Player2 (...0f) | [], [], [], [], ... |
Do you think this would be flexible enough to use for the other plugins you use?
It is quite a challenge which requires some thinking, I'll see what I can do! 😄
Edit: a large part of this is notes to myself, thought I'd include it for completeness
from webstats.
.}} ]
Wow, after reading this, I'm am appalled! You went insane on planning this out! My previous example with itemMap
was a bad example because that stores ItemStacks, which would be ugly to display on a Website.
The configuration certainly seems very flexible and could work with a variety of setups.
I've also included another Databse setup, to provide further usage possibilities:
from webstats.
Woah, thank you so much for all your unbelievable hard work! The format is extremely flexible, and all the effort you put into this is greatly appreciated!
from webstats.
I realised last week that I could just as well have done it in Java, but somehow my brain immediately goes PHP when someone mentions mysql. So, I rewrote it in Java 😁 (and implemented the uuid
converter), which has a couple advantages:
- no need for a separate installation, everything is present in the main plugin
- also no need for a separate config file
- no extra language used -> easier maintenance
- less requests to the Mojang API for UUID to playername conversion (can use the server's
usercache.json
)
I also wrote a small explanation for the conversions in the readme.
Closing this now, but if you have any questions, let me know!
from webstats.
Related Issues (20)
- Expose saved `stats.csv` to web
- In-cell bar graph
- How to create? And step-by-step config generator HOT 14
- Column ordering does not seem to work HOT 2
- Zero-values gives errors or empty cells HOT 8
- TypeError: this.rows.get(...) is undefined HOT 3
- Column unit display improvements
- Warn about soon-to-expire TLS certificate
- Discord webhook does not update HOT 5
- Set icon for Discord Webhook HOT 1
- Webpage show nothing but Compact, hide players and "loading..." HOT 7
- Custom player names and server row improvements HOT 7
- SkinsRestorer integration
- Command to remove stored placeholders for player
- Stats not updating HOT 11
- Question about serve-webpage HOT 1
- Config item to define "empty" text per placeholder
- I don't have any data of players's stats HOT 2
- Automatic TLS certificate renewal using acme.sh
- SkinRestorerAPI not initialized HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 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.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
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.
from webstats.