wvk-performance
06-20-2008, 01:22 PM
Hello,
This might not be the best place to put it but I have no idea where to put it elsewhere.
Here is a "little" introduction to a project I want to start with:
When I return from a race meeting i often get a print out of the results, or got them as an .xls file.
This is usefull to keep track of your own performance, but after a while you forget little details.
little details like: Why did i make a laptime of 15.6 on lap 32 while the previous 4 are in the 14.8 region... as are the next 6??
Did I hit traffic? if so, who was blocking me?
These things are easy to forget if you review the results 2 months after the event.
I know flash can work with mySQL and it is easy to import an xls file into mysql.
Is it theirfor possible to make a flashmovie where in the background I have the layout of any given track, with a little line over it which repesents the ideal racing line and over that line are moving some colored dots/squares/triangles/whatevers that represents my car, or the car of somebody else... and they move with a variable speed, because the speed it taken from the database (laptime of that lap) and that the next lap it runs comes from the next lap entry out of the database.
For instance:
I made a lap of 14.0 in lap 22, and in lap 23 i made a time of 14.1 etc etc. and that that something which represents my car moves over the ideal racingline with the same time as I made with my racing car.
If I can make it for one car it would not be so worthwhile, but it has to be with 10 cars.
In this way I can see why I made a slow lap, and who's to blame ;-)
The reason I wan't to make it in flash and with mySQL is that I can acces it anywhere in the world, so I don't need my own PowerBook with me every time.
I such a system do-able with Flash MX 2004??
And where should I start?
Regards,
Peter
This might not be the best place to put it but I have no idea where to put it elsewhere.
Here is a "little" introduction to a project I want to start with:
When I return from a race meeting i often get a print out of the results, or got them as an .xls file.
This is usefull to keep track of your own performance, but after a while you forget little details.
little details like: Why did i make a laptime of 15.6 on lap 32 while the previous 4 are in the 14.8 region... as are the next 6??
Did I hit traffic? if so, who was blocking me?
These things are easy to forget if you review the results 2 months after the event.
I know flash can work with mySQL and it is easy to import an xls file into mysql.
Is it theirfor possible to make a flashmovie where in the background I have the layout of any given track, with a little line over it which repesents the ideal racing line and over that line are moving some colored dots/squares/triangles/whatevers that represents my car, or the car of somebody else... and they move with a variable speed, because the speed it taken from the database (laptime of that lap) and that the next lap it runs comes from the next lap entry out of the database.
For instance:
I made a lap of 14.0 in lap 22, and in lap 23 i made a time of 14.1 etc etc. and that that something which represents my car moves over the ideal racingline with the same time as I made with my racing car.
If I can make it for one car it would not be so worthwhile, but it has to be with 10 cars.
In this way I can see why I made a slow lap, and who's to blame ;-)
The reason I wan't to make it in flash and with mySQL is that I can acces it anywhere in the world, so I don't need my own PowerBook with me every time.
I such a system do-able with Flash MX 2004??
And where should I start?
Regards,
Peter