Page 1 of 1
Online score, extra columns and sortable tables.
Posted: Sat Jan 26, 2008 6:53 pm
by Lieven
It would be nice if the online scores summary tables also display the
number of blocks
number of total lines
blocks/minute
number of flushes
start level
etc.. (as many as possible, as long as it fits on a normal screen)
And then make the table sortable, eg
http://www.workingwith.me.uk/articles/s ... le_sorting
Re:Online score, extra columns and sortable tables
Posted: Sat Jan 26, 2008 7:25 pm
by jlp_38
Lieven wrote:
It would be nice if the online scores summary tables also display the
number of blocks
number of total lines
number of flushes
start level
It can be done.
blocks/minute
Unfortunately, this info is not yet in the DB. So each replay file
has to be analyzed in order to provide the info. I have to add
this field to the DB. But it will require time.
etc.. (as many as possible, as long as it fits on a normal screen)
And then make the table sortable, eg
http://www.workingwith.me.uk/articles/s ... le_sorting[/quote]
Thanks for the tip, I will have a look at this script...<br><br>Post edited by: jlp_38, at: 2008/01/26 20:29
Re:Online score, extra columns and sortable tables.
Posted: Sat Jan 26, 2008 7:48 pm
by Herc
using that javascript table sorting code will be difficult.. to use it , you would need to load all scores of a certain mode - and that can get HUGE! another problem would be that for some users javascript might not be available or too slow...
so i would suggest to make 2 versions of the highscoretable:
* basic
* advanced
advanced table could then be complete (i.e. loading all probably thousends of scores and sort with javascript) or a subset and then reload from db of sorting by another criteria.
Re:Online score, extra columns and sortable tables
Posted: Sat Jan 26, 2008 8:03 pm
by jlp_38
Yes, you\'re right. The DB will do the job much better than
javascript (or even php). I\'m working on this.
I\'ll try to add the bpm too.
Re:Online score, extra columns and sortable tables
Posted: Sat Jan 26, 2008 10:34 pm
by jlp_38
I updated the online score page, now it is possible to sort by name,lines,flush,date, Ex:
Flat Fun page.
I\'ll add other fields tomorrow.
Lot\'s of professional work today, I\'m in standby :(
Re:Online score, extra columns and sortable tables
Posted: Sat Jan 26, 2008 10:42 pm
by Lieven
This is so cool; thanks a lot!
Awaiting more fields :)
by the way:
37 Jake 129551 56 19
with 19 flushes! exploits the randomizer bug in version 2.3; but only after 1000 or so blocks. Not sure if the 15 flush game is for real.<br><br>Post edited by: Lieven, at: 2008/01/27 00:07
Re:Online score, extra columns and sortable tables
Posted: Sat Jan 26, 2008 11:18 pm
by jlp_38
OK,
Score 806 deleted, thanks :)
Re:Online score, extra columns and sortable tables
Posted: Sun Jan 27, 2008 4:02 am
by jlp_38
I added a new BPM field :)
I think this is enough for the default table.
I\'ll add a more detailed table soon.