Site
Home / Forum / General Discussion / Cannot Add Season to AEW

Cannot Add Season to AEW


Posted: 04 Apr 2022 18:44
JayBird

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
curswine


Posts: 935
Joined: 2020

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?


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
JayBird

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
JayBird

Posts: 59
Joined: 2022

Looking good so far. Will Smackdown be added to 2006 / 2007?

Posted: 14 Apr 2022 22:49
curswine


Posts: 935
Joined: 2020

Looking good so far. Will Smackdown be added to 2006 / 2007?

I'll make it a priority for tomorrow.

Posted: 15 Apr 2022 10:34
curswine


Posts: 935
Joined: 2020

Raw and Smackdown added for 2016 and 2017.

zag
Posted: 15 Apr 2022 15:52
JayBird

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

Showing 25 to 35 (Total: 35)