Online score, extra columns and sortable tables.

Discuss about Blockout II from Jean-Luc, post your feature requests etc.

Online score, extra columns and sortable tables.

Postby Lieven » Sat Jan 26, 2008 6:53 pm

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
Lieven
 
Posts: 55
Joined: Sun Aug 05, 2007 6:31 am

Re:Online score, extra columns and sortable tables

Postby jlp_38 » Sat Jan 26, 2008 7:25 pm

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
jlp_38
 
Posts: 264
Joined: Tue Jun 26, 2007 9:09 am

Re:Online score, extra columns and sortable tables.

Postby Herc » Sat Jan 26, 2008 7:48 pm

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.
User avatar
Herc
 
Posts: 165
Joined: Sun May 20, 2007 12:54 pm

Re:Online score, extra columns and sortable tables

Postby jlp_38 » Sat Jan 26, 2008 8:03 pm

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.
jlp_38
 
Posts: 264
Joined: Tue Jun 26, 2007 9:09 am

Re:Online score, extra columns and sortable tables

Postby jlp_38 » Sat Jan 26, 2008 10:34 pm

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 :(
jlp_38
 
Posts: 264
Joined: Tue Jun 26, 2007 9:09 am

Re:Online score, extra columns and sortable tables

Postby Lieven » Sat Jan 26, 2008 10:42 pm

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
Lieven
 
Posts: 55
Joined: Sun Aug 05, 2007 6:31 am

Re:Online score, extra columns and sortable tables

Postby jlp_38 » Sat Jan 26, 2008 11:18 pm

OK,
Score 806 deleted, thanks :)
jlp_38
 
Posts: 264
Joined: Tue Jun 26, 2007 9:09 am

Re:Online score, extra columns and sortable tables

Postby jlp_38 » Sun Jan 27, 2008 4:02 am

I added a new BPM field :)
I think this is enough for the default table.
I\'ll add a more detailed table soon.
jlp_38
 
Posts: 264
Joined: Tue Jun 26, 2007 9:09 am


Return to Blockout II

Who is online

Users browsing this forum: No registered users and 2 guests