Cannot Add Season to AEW |
Posted: 04 Apr 2022 18:44 | |||
Posts: 59 Joined: 2022 | Thanks both. @curwise, no worries mate. I think the one big issue i have had is ordering. I have had to write SQL scripts to put everything in order, so I know which is the last Smackdown before the PPV and the RAW After. Is there a way in that scraper to index (add the number from 1 to 116) so when you pull down the data, the episodes are in the right order? Thanks again FYI 1993 looks great zag | ||
Posted: 04 Apr 2022 21:04 | |||
Posts: 935 Joined: 2020 | Is there a way in that scraper to index (add the number from 1 to 116) so when you pull down the data, the episodes are in the right order? I'm not 100% sure what you mean, you want the rounds to be listed in numerical order? I don't see why they couldn't be, round numbers are pretty arbitrary for the wrestling events. The problem would be there are only 99 round numbers currently, so that would need to be upped. Can dates not work as an index for a sql db? I've added all the Raws for years which had none listed (1994-1999), (2004-2015), (2018-2019), and also updated all 2022 events. zag | ||
Posted: 05 Apr 2022 21:06 | |||
zag Posts: 3,511 Joined: 2020 | Assuming we have all the events imported then anyone can change the round numbers by editing the event. I suggest just doing them in sequence. This will also help the Kodi scraper. I've updated the round selector to go up to 199, hopefully that is enough EDIT: Just looked at the event archive, looking awesome! EDIT2: Give me a few hours and let me look into a "Auto round numbering feature" for moderators | ||
Posted: 05 Apr 2022 21:23 | |||
zag Posts: 3,511 Joined: 2020 | So I did a nice little Auto Round Update feature (but probably only for me as it can be quite dangerous!!) How does this look? https://www.thesportsdb.com/season.php?l=4444&s=1993&all=1 | ||
Posted: 06 Apr 2022 21:31 | |||
Posts: 59 Joined: 2022 | @Zag - Exactly that. Now when it is scraped by KODI and put into the TV Series you now watch everything in order (like any TV Series). @Curwise FYI ^ zag, curswine | ||
Posted: 06 Apr 2022 21:52 | |||
zag Posts: 3,511 Joined: 2020 | Great I cleaned up 2001 and 2002 so it probably needs and import in the correct naming. But otherwise looking really good now. I've also run the round batch updater on all WWE years. EDIT 2017 and 2016 also need importing. curswine | ||
Posted: 14 Apr 2022 21:51 | |||
Posts: 59 Joined: 2022 | Looking good so far. Will Smackdown be added to 2006 / 2007? | ||
Posted: 14 Apr 2022 22:49 | |||
Posts: 935 Joined: 2020 | I'll make it a priority for tomorrow. | ||
Posted: 15 Apr 2022 10:34 | |||
Posts: 935 Joined: 2020 | Raw and Smackdown added for 2016 and 2017. zag | ||
Posted: 15 Apr 2022 15:52 | |||
Posts: 59 Joined: 2022 | Thanks mate | ||
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 |