Digital Workshop

Hi you All,

I am working on a Result Board and therefor i made an input screen.
There are 20 lines (text inputs) to set name, and score.
On the display page i make the variables visible for the audience.
Now i would like to sort the outcome (is that english?) so that the highest score is on top etc.
It must run in real time because the score is changing during the game.

Who can help me.


Marian Hausman

This is how I would do it, but I don't think Multi-dimensional Array's are working in Opus at the moment

No multidimensional arrays don't work in Opus but objects can be used in their place.

myCards = new Array()


for (a=0;a<10;a++)
{
myCards[a] = new card(a,String.random(100))
Debug.trace(myCards[a].ordinal+' : ' +myCards[a].rnd+'\n')
}
Debug.trace('\n\n\n')


myCards.sort(sortByRnd)

for (a=0;a<10;a++)
{
Debug.trace(myCards[a].ordinal+' : ' +myCards[a].rnd+'\n')
}

function card(a,b)
{
this.ordinal = a
this.rnd = b
}

function sortByRnd(a, b)
{
var x = a.rnd
var y = b.rnd
return ((x < y) ? -1 : ((x > y) ? 1 : 0));
}

Mack

OK... Let's start to try it. It's a lot of scripting (for a nono like me) but i'll try.
Thanks.


PS
may i ask for help if it's to much for me?


Marian

I think you jumped into the deep end

Yes of course you can ask for help. I'd check the post on Tip For Posting first though:

viewtopic.php?t=3514

Attached is a working example of a scoreboard that returns the top three players and their scores as new results are added as it will probably help to see this working.

Mack

Thanks Mackavi, Your great. Thanks


Marian

Good solution, I needed something similar in a publication that used a database. As I already had a database I just created a table, then in the Opus Publication I wrote the scoreboard to the table and using SQL pulled the scoreboard and ordered by score.

It's an easy way to get it done requiring only a few lines of SQL if you already use a database. I'll dig the code out if anyone wants it.