arcadeicons
Member
I need to create a scoreboard for my web site that will show the results of a league as scores are entered. Our (Arcade Gaming) leagues involve playing various different games in a tournament and awarding points based on the players ranking by score for each game.
I've looked at the pivot plugin but it doesn't seem like it 's going to help creating actual visualizations.
I have all of my score in my table already _submit_score
id
create_time
created_by
collectiontype
gameID
gamescore
player
eventID
playerID
userID
date_time
sim_players
tournID
I need to create a pivot visualization with:
- X-Axis - Game names
- Y-Axis - Ranking
- Cells - Concatenated info containing the player name, avatar and their single highest score only for that particular game. (Players will play the same game many times during a tournament)
I also need to do some math in the background that assigns points per player per game based on their rank position per game rather than their actual score (yep I know this is a separate function)
I'd hoped there would be some handy dandy wizz-bang Joomla plugin that would help me achieve this with my tiny knowledge of SQL but I haven't found anything so far.
website is here if seeing it helps make more sense http://www.ArcadeIcons.com
I've looked at the pivot plugin but it doesn't seem like it 's going to help creating actual visualizations.
I have all of my score in my table already _submit_score
id
create_time
created_by
collectiontype
gameID
gamescore
player
eventID
playerID
userID
date_time
sim_players
tournID
I need to create a pivot visualization with:
- X-Axis - Game names
- Y-Axis - Ranking
- Cells - Concatenated info containing the player name, avatar and their single highest score only for that particular game. (Players will play the same game many times during a tournament)
I also need to do some math in the background that assigns points per player per game based on their rank position per game rather than their actual score (yep I know this is a separate function)
I'd hoped there would be some handy dandy wizz-bang Joomla plugin that would help me achieve this with my tiny knowledge of SQL but I haven't found anything so far.
website is here if seeing it helps make more sense http://www.ArcadeIcons.com