Re: [xmoto-dev] svn 1404 : merged benetnash with trunk

[Janek Polak <benetnash@xxxxxxxxxxxxxx>]

Dnia Mon, 30 Apr 2007, nadenislamarre@xxxxxxx naskrobal
> - about this comment
> /* unfortunately because of differences betw->setClicked(false);een finishTime
> in webhighscores and replays table (one is rounded to 0.01s and other to 0.001s)
> and lack of math functions in sqlite we cannot make it with just one smart query
> :( */
> i don't understand because just after, you have only one query.
> can you write which sqlite math function is required so that we can update
> easierly once it will exist
> for the current existing one : http://sqlite.org/lang_expr.html (min, max,
> round)
> for information, in webhighscores you have the web highscore (minute on 2
> numbers, sec on 2 numbers, hundread on 2 numbers) ; this value is rounded when a
> highscore is received by the webserver. in the replay tab, you've the real time
> (precision is the one of the float type)

Today morning I've invented that this floating point differences can be
removed by changeing (replay_time < highscore_time) to (replay_time -
highscore_time < -0.01). I'm not perfectly sure if it works, but this
solution looks fine. I left comment in case someone invent something
better. 

> - about the query :
> I would prefer you put it into one function for example
> UploadAllHighscores
> because the GameMenu.cpp must not become bigger.
> 

Ok, but tommorow. Today I have troubles with my computer...

> - about this expression
> ("Upload all replays on the website of highscores (experimental)")
> Why is it experimental ? is there a case in which it doesn't work ?
> 
I'm not 100% sure if my query works as I want to. I have always trouble
with SQL, so I could do something wrong. Of course any mistake in query
won't destroy anything but I want to be secured in case of some faults.

> - about BikePlayer.cpp and BikePlayer.h
> i want you revert these changes ; i won't the biker behavior change for the
> moment, then, please don't modify it please.
>

Ok, no problem.

Best Regards
Janek Polak

-- 
Janek Polak
WWW: http://www.icpnet.pl/~benetnash  GnuPG: 6A1E7B75
GG: 2852217  Jabber: benetnash@xxxxxxxxxxxxx

Attachment: pgpYbvPdM0i_Z.pgp
Description: PGP signature