MySQL version 5.0?

[Smolin]

Has NWNX2 been tested at all under the latest version of MySQL (5.0)?

I ask because I'm having trouble sorting some data for my server. We have a stats page that tracks who's been on recently and for how long total. Works great ... except that MySQL 4.1 doesn't seem to understand decimal places. So "2.0" is more than "120.0" as far as it's concerned.

I can get it to sort properly by using the raw integer, which is set to 10 places, but when I convert it to days, it gives me the problem decribed above. And I'd like have it translated into days: the raw integer is total seconds online, which becomes sort of meaningless at a glance.

From what I gather, MySQL 5.0 supports casting as decimal, which would allow me to left-pad the number, and thereby sort properly.

P.S. I am a total database novice, and am just trying to keep this DB I've inherited working nicely. Any suggestions on how to make this work would be greatly appreciated.