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.