Welcome Center => Beef => Topic started by: creamy on August 21, 2004, 12:39:43 pm
Title: Why cant I summit sonic R records?
Post by: creamy on August 21, 2004, 12:39:43 pm
For some strange reason I cant submit any of my times for sonic R when I try to submit them it just says
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND e.creation='SUBMIT' GROUP BY e.class ORDER BY l.level_order
does anyone know what this means? <_<
Title: Why cant I summit sonic R records?
Post by: Rolken on August 21, 2004, 08:53:47 pm
It works for me... do the other games work for you?
Title: Why cant I summit sonic R records?
Post by: creamy on August 22, 2004, 02:50:56 am
yes they do
Title: Why cant I summit sonic R records?
Post by: Sonichero on August 30, 2004, 06:35:52 am
sonic battle Submissions dont seem to work either it comes up with the same error as the sonic R Submissions :(
Title: Why cant I summit sonic R records?
Post by: sonicam on August 30, 2004, 07:23:34 pm
Quote
sonic battle Submissions dont seem to work either it comes up with the same error as the sonic R Submissions :(
[snapback]4389[/snapback]
Sonic Battle submissions don't work for me either.
Title: Why cant I summit sonic R records?
Post by: Bilan on August 31, 2004, 05:50:23 pm
Sonic R wont work for me either =(
Title: Why cant I summit sonic R records?
Post by: Sonichero on September 03, 2004, 01:48:58 pm
oh yeah and sonic drift dont seem to work either :(
Title: Why cant I summit sonic R records?
Post by: SadisticMystic on September 03, 2004, 03:05:48 pm
I think I've got it.
What's the one thing Sonic R, Sonic Battle, and Sonic Drift all have in common?
The lack of a division 0.
Maybe the current code requires that the game have a division 0 in order to accept submissions.
Title: Why cant I summit sonic R records?
Post by: Bilan on September 03, 2004, 04:12:01 pm
...so you can fix that, right? *will probably find out now that its already been fixed*
EDIT: So....thats a no?
Title: Why cant I summit sonic R records?
Post by: Bilan on September 07, 2004, 03:09:49 am
I had a think about this and couldn't you solve this problem for Sonic Drift 1 & 2 and Sonic R by adding another division, even if noone submits for it.
You could use Rings for all of them, just see how many Rings you can finish the race with, although with Sonic R that'd have to be at the end of a 3 lap race.
I had a second idea for Sonic R for an extra division.
Make them into 'Grand Prix' and 'Time Attack'
Grand Prix mode is when you can collect Rings in the races, and you'd post fastest Lap times and Course Records.
Time Attack mode has no Rings, but it does have a mirrored track option, as well as Balloons and Tag.
I dunno if anyone else'll think thats a good idea but thats just my 2 cents.
Title: Why cant I summit sonic R records?
Post by: SadisticMystic on September 07, 2004, 04:24:56 pm
Rings wouldn't fix the problem since that's division 9, not 0.
Title: Why cant I summit sonic R records?
Post by: Bilan on September 07, 2004, 04:26:34 pm
Then whats Divison 0?..
Title: Why cant I summit sonic R records?
Post by: sonicam on September 08, 2004, 06:54:51 pm
I was thinking maybe a Time Division could be added for Sonic Battle but i don't know if that is Division 0, so what is this division?
Title: Why cant I summit sonic R records?
Post by: Rolken on September 09, 2004, 12:15:52 am
Um... there shouldn't be ANY category 0s anymore. o.o; I upped them all by one... unless you mean what it really refers to as divisions.
sonicam, what levels/divs should be in a Sonic Battle time category? I don't know.
Title: Why cant I summit sonic R records?
Post by: sonicam on September 09, 2004, 01:18:08 am
Just the Battle Time. In Challenge Mode, after each Battle, you are given a results screen, and in the results screen there is a time record that tells you how long you took to finish the battle. I was thinking, you could divide the Time Division for each individual Character, with each of thier three Difficulty Levels and in each difficulty level, you would have each of the 5 battles. Here is an example since i know that was pretty confusing:
Character: Sonic: Total Time for Sonic's Level 1-3(it doesn't give you a time on the Challenge Mode character select, nor is there any place in the Records to be shown, this would just be calculated like all the other games calculate it's Time Attack records combined for a particular character)
Level 1: Total Time would be calculated here, like it is done with most Time Attack games(Total Time for Sonic's Level 1)(again, it isn't shown anywhere, it will just be a calculation of all the Battle Times for Level 1)
You'd do the same thing for all the other characters. This is maybe alot, but still, i'd be cool to compete for time in Sonic Battle.
Rolken, if that was overly confusing(i tend to make simple things more difficult), please tell me, and sorry in advance if it is.
Title: Why cant I summit sonic R records?
Post by: Bilan on September 10, 2004, 05:16:57 pm
Meh...Sonic Jam doesn't work either
Title: Why cant I summit sonic R records?
Post by: Rolken on September 15, 2004, 12:29:39 am
OK, I finally tracked down and fixed this problem. It had to do with the HTML and PHP not passing data to each other that they should've. Sorry, guys. :P
Title: Why cant I summit sonic R records?
Post by: Bilan on September 15, 2004, 03:01:47 am
YAY! Thanks Rolko! =)
Title: Why cant I summit sonic R records?
Post by: sonicam on September 16, 2004, 12:28:05 am
Thanx Rolken!
Also, what do you think of the Time Division idea for Sonic Battle, Rolken?