The Sonic Center

Sonic Central => Competition Central => Topic started by: Rolken on May 29, 2004, 04:57:23 pm

Title: READ: Sonic Advance 3 Rankings
Post by: Rolken on May 29, 2004, 04:57:23 pm
This poll decides how the rankings work henceforth and forever.
Title: READ: Sonic Advance 3 Rankings
Post by: Rolken on May 29, 2004, 06:45:25 pm
OK, looks like the poll isn't very decisive. So if anybody wants to take up the soapbox and tell us why it should be a certain way, go straight ahead. I don't think SM plays it and I don't know enough about it yet to make a good judgment.
Title: READ: Sonic Advance 3 Rankings
Post by: Taco on May 29, 2004, 07:01:26 pm
Honestly,

I think that the best way to do this would be by team name (unbreakable bond, etc)

simply because of this

If you have it organized by leader, and have any partner you want, then most of the times will be around the same, because there are some major advantages one character might have to another. tails and cream can fly, knuckles can fly, and sonic can run

so look at it this way

Route99 Act 1
sonic
tails
knuckes
cream
amy

say the level was a running level. then the times would probably be the same, because the partner system would end up like this

sonic, tails
tails, sonic
knuckles, sonic
cream, sonic
amy, sonic

now say that the level was perhaps a flying level

then the system might end up like this

sonic, tails
tails, sonic
knuckles, tails
cream, sonic
amy, tails

I cant really say who the player would choose if they were the flying type, but youg get what I'm saying

I believe the other way is better

Route99
sonic tails
sonic knuckles
cream amy
forgot this team
ok

if this was the case, it would work out much better, because the teams are set up pretty evenly. If everyone could just FLY through the level, it would make it much easier, but this obviously isn't the case. it makes it even and fair, and you can still make a decision, deciding on who the leader is, and who the partner is of the two characters

as for ok, ok is kind of like your lucky break. You simply just choose anyone combo you want.

so I dont know about you, but this looks like it will be alot more fun and challening if we have it set up this way, rather then everybody can almost fly or run at superfast speed or swim really fast underwater, etc

this way, not everyone will be able to fly, or run super fast, or swim fast underwater, and this calls for different techniques and routes to be used, making time attacking alot more fun instead of dull. besides, once you unlock the path for one team, you most likely wont be able to use the same path with another team, while as if you were doing it by leader, everyone would probably be able to take that path, at a SLIGHTLY different pace

ok, well that's my opinion. I'm a horrible organizer, so let me know if you didn't understand anything. :)
Title: READ: Sonic Advance 3 Rankings
Post by: SprintGod on May 29, 2004, 07:28:58 pm
The problem with team names is that even something as minor as switching the characters around results in significant changes.

I'd prefer it if:
# When submitting a time, you specify the Level, the Characters used, and the Time.
# The main table displays all the times, basically ignoring the characters used.
# 20 more tables that show times for each pair of characters (basically filtering the main table so it doesn't show certain times)
# Maybe a few more that depend on Team Names, Lead Characters or Following Characters

The main table would be the major factor in deciding rankings (e.g. having all the fastest times gets you 50%)
The rest of the game % can then be split across the rest. (or maybe they could be worthless in terms of ranking, but the ability to filter the main table to show only certain character groups would still be quite valuable)

That way people will be mostly competing for the fastest overall times, but you still get credit if you set a record for a certain character combination.
Title: READ: Sonic Advance 3 Rankings
Post by: SadisticMystic on May 29, 2004, 11:22:56 pm
Quote
# 20 more tables that show times for each pair of characters (basically filtering the main table so it doesn't show certain times)
# Maybe a few more that depend on Team Names, Lead Characters or Following Characters

That way people will be mostly competing for the fastest overall times, but you still get credit if you set a record for a certain character combination.
Explain how this is at all feasible.
Title: READ: Sonic Advance 3 Rankings
Post by: SprintGod on May 29, 2004, 11:26:59 pm
Filters.

Instead of having several tables, you simply use the complete table with bits missing.

Making the filtered tables apply to rankings would be difficult though... Probably not worth the effort.
Title: READ: Sonic Advance 3 Rankings
Post by: Rolken on May 30, 2004, 12:02:58 am
It's easy for you to say "filters" as a theoretical construct, but that has no relation to the actual database structure. To implement such a thing would require rewrites of large portions of the code.

That doesn't mean it's out of the question, though; good ideas are worth spending time to put into practice. However, I don't think anyone else wants it. First of all, it's just too much, and secondly, if any credit at all were given there'd surely be competition for it, and newbies wouldn't stand much more of a chance anyway - they'd just have an overwhelming number of fields to fill, while the top five or six players would get bigger portions of records  instead of the top two or three taking it. Any "weak" table would surely be snapped up by one of the more regular players.

I'm leaning towards basing on teams at the moment...
Title: READ: Sonic Advance 3 Rankings
Post by: Shadow Wedge on May 30, 2004, 02:48:40 pm
I don't think that team name would work too well, as there are so few teams and changing the lead and secondary characters can change the path you take a lot...
Having twenty different categories makes it boring because the secondary character may not change how one plays the level very much... Plus there would be too many categories per level. (There's what, four levels per zone? That's 4 * 20 * 7 + 1 = 561 different categories... I don't think anyone would have the patience for that...)
Basing it off of lead character cuts down on the number of categories (4 * 5 * 7 + 1 = 141) and would simplify the choices... It would make it more interesting to find a good combination that takes advantage of the level, but one wouldn't have to use every single combination to get a high spot on the board either total or for the level...
That's my two cents...

Summary: I'd rather it was based off of the lead character.
Title: READ: Sonic Advance 3 Rankings
Post by: Ghost on May 30, 2004, 04:33:53 pm
Quote
Explain how this is at all feasible

this is hard to understand if you dont know database but can be like this:

_game class table_
database id
game name - sonic1, sonicadvance3...
competition class (link competition class table database id)

_competition class table_
database id
competition name - time, freestyle, rings...
level class (link level class table database id)

_level class table_
database id
level name
character class (link character class table database id)

_character class table_
database id
character name - any, sonic, sonic and tails...
score class (link score class table database id)

_score class table_
database id
score number
date number
player class (link player class table database id)

_player class table_
database id
player name
player data1
player data2
etc.

this is very easy with many-to-one links and lines only but can have better but harder structure with many-to-many links and circles.

then if new competition can add in competition class table and links are there already. if you want to have more characters can add in character class table and links are there already.

can also have table for numbers from other numbers to save server from thinking about too many numbers but this is obvious.

then this "filters" idea is not theoretical at all, only a SQL query away!
Title: READ: Sonic Advance 3 Rankings
Post by: Rolken on May 30, 2004, 07:37:30 pm
I'm not entirely catching your drift, but I think that's pretty much how the database works now. The main problem is that at present there aren't allowances made for a time to be in multiple competitions with multiple rankings.

In response to Shadow... there are slim chances of 561 divisions being added. I think it's basically a choice between by lead character or team name. So the question is, what makes one better than the other?

I think you underestimate the amount to which a partner affects your strategy. NintenDan or the others could probably talk about it more skillfully than I, but the basic gist is, if a level is done better with a flying partner, you'll always use a flying partner; if better with a speed partner, you'll always use a speed partner. So, rather than everyone always using the same partner, better to enforce diversity of partners in a few divisions and then let the player have his pick of all the other characters in another division.

But then there's the fact that, for example, in a Sonic+Tails combo, Sonic may always be chosen as the lead character, leaving some characters essentially unused.

Can someone post what the different teams are? S+T, S+K, C+R, S+R, and OK?
Title: READ: Sonic Advance 3 Rankings
Post by: CosmicFalcon on May 31, 2004, 05:43:27 pm
Quote
Can someone post what the different teams are? S+T, S+K, C+R, S+R, and OK?
Unbreakable Bond: Sonic and Tails
Fighting Buddies: Sonic and Knuckles
Lovely Couple: Sonic and Amy
Team Jubilee: Amy and Cream
OK: Everything else.

Of course, there are so few teams that you could in theory make up one or two for the purposes of Sonic Center only.
Title: READ: Sonic Advance 3 Rankings
Post by: DJ Koopa on May 31, 2004, 09:21:08 pm
few? there's only 10 combos! but if you need somemore teams...

Unbreakable Bond: Sonic+Tails
Fighting Buddies: Sonic+Knuckles
Fast Food: Sonic+Cream
Lovely Couple: Sonic+Amy
Flying Fists: Tails+Knuckles
Young Flyers: Tails+Cream
OK: Tails+Amy
BitterSweet: Knuckles+Cream
Pink Fury: Amy+Knuckles
Team Jubilee: Cream+Amy
Title: READ: Sonic Advance 3 Rankings
Post by: Shadow Wedge on June 01, 2004, 09:56:37 am
Hmmm... Turbos' idea looks good... But...

Tails + Amy: Sonic's Sidekicks (???)
Title: READ: Sonic Advance 3 Rankings
Post by: Sonichero on June 15, 2004, 02:13:57 pm
Quote
OK: Tails+Amy

I have got a good name "girl prower"
Title: READ: Sonic Advance 3 Rankings
Post by: yse on June 20, 2004, 03:24:01 am
I personally prefer NintenDan's idea of OK being a lucky break. Besides, 10 combos per act is far too many, even 5 is pushing it (sort of). It was fair enough for Advance 2...

Here's an idea I just thought up: Divide them into Sonic, Tails, Knuckles, Cream, Amy, but your best time can be with them as leader or partner.

Example: Your top 5 times on any given level are these:

1. 0:40.35 - S&T
2. 0:40.38 - S&K
3. 0:52.10 - T&C
4. 1:01.99 - K&A
5. 1:03.53 - C&A

Your records would be something like this:

Sonic - 0:40.35
Tails - 0:40.35
Knuckles - 0:40.38
Cream - 0:52.10
Amy - 1:01.99

Thoughts?
Title: READ: Sonic Advance 3 Rankings
Post by: DJ Koopa on June 22, 2004, 10:36:41 am
I still say uni-division... like Knuckles Chaotix
Title: READ: Sonic Advance 3 Rankings
Post by: Taco on June 22, 2004, 07:46:23 pm
well, as long as it's not by leader, then I'm happy

seriously, if the best job for a level was speed, then everyone could just choose sonic as their partner (Doesn't sonic do the same thing more or less for all of the character [speed them up with the R button?]?)

^That was confusing...with the ([]) and all!
Title: READ: Sonic Advance 3 Rankings
Post by: Shadow Wedge on June 30, 2004, 10:44:25 am
Ya, maybe just uni-division it??? It's getting kinda annoying, not being able to submit times...
Title: READ: Sonic Advance 3 Rankings
Post by: Zealous on July 05, 2004, 04:27:45 pm
Maybe the best idea would be to ignore the team combo altogether.

The Time Attack mode wasn't made to hold records for specific teams, it's all just slapped onto one page regardless of the characters used. To divide by leader would be possible, because it tells you which characters used, but 'twould be a hassle BECAUSE once you made another record, some other record would be wiped out, and say you hadn't submit it to TSC yet?

I think there should be no character divisions--but maybe an option to show which characters used, for a reference to the other players.
Title: READ: Sonic Advance 3 Rankings
Post by: Zealous on July 05, 2004, 04:29:22 pm
What do you all think?  :lol:
Title: READ: Sonic Advance 3 Rankings
Post by: SadisticMystic on July 05, 2004, 04:48:34 pm
Quote
I think there should be no character divisions--
Agreed.

Quote
but maybe an option to show which characters used, for a reference to the other players.

It's called the Comment Box.
Title: READ: Sonic Advance 3 Rankings
Post by: Jeffery Mewtamer on July 05, 2004, 09:22:54 pm
I agree with the idea of uni-division. Time Trials would just be to confusing any other way.
Title: READ: Sonic Advance 3 Rankings
Post by: Taco on July 05, 2004, 10:17:23 pm
ya, I guess unidivision works

except all my records are worthless now :P

Oh well, last post for a month! YAY!
Title: READ: Sonic Advance 3 Rankings
Post by: General Throatstomper on July 06, 2004, 10:19:54 am
I know that this will sound weird, and I can't really explain it that well, but what if there were 5 submission boxes for each level, and you could post your top 5 times for that level or boss, and say person X had a good time for level X as a certain pairing, but not as good as the record achieved by a different pairing, it would count if it beat the Second best time of the other person as the next spot on the submission list. That way, different combinations still get weight in the levels/bosses, even if they aren't the best option, but you don't have to meticulously submit times for every single pairing.
Title: READ: Sonic Advance 3 Rankings
Post by: Shadow Wedge on July 14, 2004, 10:09:41 am
I suggest that we just put it to Unidivision so that other people can submit times...

Edit: If it works for Knuckles Chaotix, it will work for this.

Edit2: I agree with not using the formation type too. (see below)
Title: READ: Sonic Advance 3 Rankings
Post by: Chaos Angel 73 on July 22, 2004, 06:24:03 pm
I agree with unidivision. Read my sig (if it comes up on this post). It'll show you why.
Hee hee hee...
Title: READ: Sonic Advance 3 Rankings
Post by: General Throatstomper on July 25, 2004, 11:11:08 pm
I have a better idea. We could do it based on formation (the formations are shown in the Top-left hand corner) so that the 3 types are covered, and given equal weight. That way, one combination isn't used as the only way to get a record. The 3 types are Power, Speed, and Fly.
Title: READ: Sonic Advance 3 Rankings
Post by: Sonichero on July 26, 2004, 10:06:49 am
Nope the best way is still uni-devision because the game has a uni-devision then so should the site
Title: READ: Sonic Advance 3 Rankings
Post by: DJ Koopa on July 26, 2004, 11:52:52 am
Won't work. Anyone paired up with Sonic is Speed
Anyone paired up with Knuckles besides Sonic is Power
Tails and Cream are Flying
and Amy has no trait.
Title: READ: Sonic Advance 3 Rankings
Post by: Chaos Angel 73 on July 26, 2004, 04:50:50 pm
So what? Chances are someone's gonna wind up setting a record with Amy as primary character. Most likely to get past those infernal breakable walls. Traits don't matter, either. It may be evident what traits benefit what zone when more records are set, but otherwise traits are ignorable as far as I'm concerned. I don't look to see which trait I'm using before I enter a zone:

OMGWTFLOLBBQ! I UZ3D T3H FLY1NG 1NST34D 0F T3H SP33D!!!11! ROTFLMFAO!

I could care less. No one cares what trait is used as long as it sets a decent record, correct? Therefore, unidivision should be used for time attack records.
Title: READ: Sonic Advance 3 Rankings
Post by: DJ Koopa on July 27, 2004, 11:39:26 am
....Thank you Capt. Obvious
Title: READ: Sonic Advance 3 Rankings
Post by: Chaos Angel 73 on July 27, 2004, 04:15:39 pm
Your welcome, good citizen! CAPT. OBVIOUS... AWAYYYYYYYYYY!
Title: READ: Sonic Advance 3 Rankings
Post by: gbagcn on August 03, 2004, 09:18:43 pm
I think there should be 2 categories. One for sonic and tails and one for everyone else. If you don't include sonic and tails team by itself for the rankings it isn't really fair to the people who already submitted times for it.
Title: READ: Sonic Advance 3 Rankings
Post by: SadisticMystic on August 03, 2004, 09:27:24 pm
How about just change the name of the division and keep what's there and no one has to worry about losing anything.
Title: READ: Sonic Advance 3 Rankings
Post by: Sonichero on August 09, 2004, 03:36:13 pm
pleeeeeease put the uni-devision up as I have some low times to summit

e.g. cyber track 3: tails and amy 1:59:03
Title: READ: Sonic Advance 3 Rankings
Post by: gbagcn on August 25, 2004, 01:45:53 pm
I have a suggestion for a new division in sonic advance 3. This division would include teams that couldn't fly or tag action high jump. This would mean tails and cream could not be the leader and tails and amy could not be the partner. The reason I like this idea is because it would require new paths to be found for many levels since there are so many shortcuts involving tag action high jumps or flying.

There should also be some sort of freestyle mode where you can submit times for any team in any level. This is best left in freestyle so that way everyone doesn't have to play each level 20 times to get a good rank and allows people who like a specific team to get records.