Site
Home / Forum / General Discussion / [Concept] Team page redesign & Statistics
Home / Forum / General Discussion / [Concept] Team page redesign & Statistics
[Concept] Team page redesign & Statistics |
| Posted: 24 May 2020 20:29 | |||
 zag  Posts: 3,515 Joined: 2020 | Hi Zag, Following the (see full resolution here) On the next posts (for a better reading/finding/quoting) you will find a detailed explanation for each one. Hope you liked! | ||
 | |||
| Posted: 24 May 2020 20:30 | |||
zag Posts: 3,515 Joined: 2020 | The previous screenshot is the info displayed by clicking on the "Team Info" or the by default view which has the next new features: - New schedule design - New stadium logo art - Competitions list changed into league logos - Display all current season jerseys - New social media box Let's see some of them on detail: - New social media box Taking advantage that we have already entered Instagram official team accounts, this box inserts the last 9 posts on this box and group all social media links on the right. | ||
| |||
| Posted: 24 May 2020 20:30 | |||
zag Posts: 3,515 Joined: 2020 | Now it's time to click into "ROSTER & COACH" in the navigation bar: (see full resolution here) As you can see "schedule" is still displayed, but "Team Info" has been changed by displaying roster & staff member info. "Roster & Coach" section includes the next new features: - New card view - New year/season selector - New staff section - New staff section Now head coach (changed the "manager" name into this other one) is displayed together with the rest of the team members and added also the availabity to add assistant coaches (this new option should be added to the edit/creation player page). | ||
| |||
| Posted: 24 May 2020 20:30 | |||
zag Posts: 3,515 Joined: 2020 | Now it's time to click into "STATISTICS" in the navigation bar: see the post here) Also you will see an option to "Add Stats". This will come in a new concept that I'm working on | ||
| |||
| Posted: 24 May 2020 20:31 | |||
zag Posts: 3,515 Joined: 2020 | ...and the last one! Now it's time to click into "ARTWORK" in the navigation bar: (see full resolution here) On this section can be found some new arts: - Mobile Wallpapers: First pic will be the one used as header in the left side on the "Schedule Section" - Alternate Badge: Some teams have official alternate badges/crests and now it could be uploaded to the team page - Mobile Wallpapers | ||
| |||
| Posted: 24 May 2020 21:00 | |||
zag Posts: 3,515 Joined: 2020 | Thanks as always, a lot to take in but I like the general direction. There is so much data on there its difficult to find a good way to navigate it all. I want to maintain the sites simplicity but also have all the stats for nerds as well I wonder if we can somehow theme each teams site to be their shirt colour as well as you have done here. | ||
| |||
| Posted: 24 May 2020 21:07 | |||
zag Posts: 3,515 Joined: 2020 | I'm a complete freaky of statistics | ||
| |||
| Posted: 24 May 2020 21:21 | |||
zag Posts: 3,515 Joined: 2020 | If you can work out a plan for this I’d be interested in seeing it in the football api | ||
| |||
| Posted: 24 May 2020 21:43 | |||
zag Posts: 3,515 Joined: 2020 | If you can work out a plan for this I’d be interested in seeing it in the football api If this concept gets implemented, I can work on providing de Hex color codes. For example, the one I used on this was #2a1d48 | ||
| |||
| Posted: 25 May 2020 08:43 | |||
zag Posts: 3,515 Joined: 2020 | Maybe adding a new field on the team edit page named "Hex color code" could help | ||
| |||
| Posted: 25 May 2020 11:30 | |||
zag Posts: 3,515 Joined: 2020 | I'm all for this, looks great with the team colours especially. I'm a little sceptical on how well stats can be kept up to date with the current amount of active editors. If we're adding in new fields may I suggest adding 'location coordinates,' such as '53.916543, -3.024879' which would return an exact location on Google Maps, would be good information to record to then work out distances between teams. | ||
| |||
| Posted: 25 May 2020 14:56 | |||
zag Posts: 3,515 Joined: 2020 | I should be no prob, as the huge nr of events on the db are related to soccer and stats are available through the new importer. For basketball events, I'll be in love to add them! | ||
| |||
| Posted: 26 May 2020 08:39 | |||
zag Posts: 3,515 Joined: 2020 | Yeh stats are great to see and many people like them, but we do have to think about the data. Sounds like something that should be automated but i'm open to manually adding them once a players career finishes or maybe the season finishes. I will have a think how to make it possible. | ||
| |||
| Posted: 26 May 2020 17:57 | |||
zag Posts: 3,515 Joined: 2020 | I will have a think how to make it possible. The site that I was planning to use to enter stats is sports-reference.com which publish the stats for: - NBA - College Basketball - MLB - NFL - College American Football - NHL Also has stats for soccer, but I think that won't be needed as the new/second importer already provide us this info. First issue that I see in uploading the info in an automated way is that our events are on UTC dates (with +1h in summer period) and on the site are on local ones. This may cause issues linking events with close dates and same teams (I'm thinking on NBA play-offs events or MLB events which can play 3 games in a row the same teams on consecutive local days). Second issue that we may have will be the way the players are named on the source site versus our naming (I'm think on players with special characters or with "short names/nicknames) The idea that I have in my mind to enter the stats was directly into the event page (first issue solved) and then, to have the option of enter them manually or by uploading a CSV file (sports-reference allows to generate CSVs for each team) where we can always provide correct player names in case of differences (second issue solved). Also I have to mention that following this way of uploading stats will let us to be able to spread the stats to all pages. On this design, we see the ones related to team, but entering the data linked to our events, will let us show also stats in players page, leagues pages and even globaly by sport. | ||
| |||
| Posted: 26 May 2020 20:54 | |||
zag Posts: 3,515 Joined: 2020 | Nice! Yes CSV data is easy enough to import. | ||
| |||
| Posted: 26 May 2020 21:49 | |||
zag Posts: 3,515 Joined: 2020 | Is there any update on passing football stats through the api from api-football? I’m currently using their free tier to collect stats but I’m limited to 100 calls a day | ||
| |||
| Posted: 26 May 2020 23:21 | |||
zag Posts: 3,515 Joined: 2020 | Not yet, thats definitly one for later on. Same with Odds. | ||
| |||
| Posted: 27 May 2020 06:12 | |||
zag Posts: 3,515 Joined: 2020 | Here you can see an example related to this event (https://www.thesportsdb.com/event/648657) for testing: Atlanta Hawks Stats: | ||
| |||
| Posted: 27 May 2020 19:12 | |||
zag Posts: 3,515 Joined: 2020 | In terms of data storage, I suggest to define the next fields: - Sport - League - Season - Event - Team - Player - Stats 1 - Stats 2 - Stats 3 ... So using the previous example of stats and using Maurice Harkless as an example player, it should be stored like this his stats: - Sport: Basketball - League: 4387 - Season: 2019-2020 - Event: 648657 - Team: 134862 - Player: 34165838 - Starter: Yes - Minutes Played: 40:53 - Field Goals: 6 - Field Goal Attempts: 13 - Field Goal Percentage .462 - 3-Point Field Goals: 0 - 3-Point Field Goal Attempts: 4 - 3-Point Field Percentage: .000 - Free Throws: 2 - Free Throw Attempts: 3 - Free Throw Percentage: .667 - Offensive Rebounds: 1 - Defensive Rebounds: 1 - Total Rebounds: 6 - Assists: 6 - Steals: 1 - Blocks: 0 - Turnovers: 1 - Personal Fouls: 3 - Points 14 - Plus/Minus: +10 | ||
| |||
| Posted: 28 May 2020 08:56 | |||
zag Posts: 3,515 Joined: 2020 | Thanks yes thats useful. Storing the stats in an extensible and scalable way is a good start. | ||
| |||
| Posted: 02 Jun 2020 11:11 | |||
zag Posts: 3,515 Joined: 2020 | Concept for the add/edit stats page: (see full resolution here) | ||
| |||
| Posted: 02 Jun 2020 11:22 | |||
zag Posts: 3,515 Joined: 2020 | I don't know much about basketball statistic so forgive me if I'm incorrect. Could some of the stats, like percentages, pts, diff, be deduced from other data that's being input? | ||
| |||
| Posted: 02 Jun 2020 11:36 | |||
zag Posts: 3,515 Joined: 2020 | I don't know much about basketball statistic so forgive me if I'm incorrect. Could some of the stats, like percentages, pts, diff, be deduced from other data that's being input? I added all the fields that can be uploaded by downloading the CSV files from sports-reference without manipulate them, but of course, the next fields can be deduced if applying formulas: FG% - 3P% - FT% - TRB - PTS | ||
|
Who is Online? In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm | About Us Discussion forum for TheSportsDB.com site and related topics | Rules - Be Polite - Respect other users - Always post log files with issues - Try to be helpful - No Piracy discussion |