Zugg Software :: View topic - looping a database, and showing the list in order of the %key

Adept Joined: 27 May 2008 Posts: 299

#LOCAL $temp;#LOOPDB @test_list {#ADDKEY $temp %val %key};#SHOWDB $temp

That should work. It reverses the val's and the keys of the dbvar and then they sort correctly automaticly.. This works with the example given, something tells me its a bit more complex than this tho.

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Hmm... Yea, that does work Toxic, but I'm trying to use it inside of an alias, and the output will be used in another window, not in a #say.

Posted: Fri Jun 27, 2008 3:50 pm

%sort(%val) won't do anything - %val is the value of the key for that particular iteration, which is usually a string or number and thus can't be sorted.

You can't sort dbvars. It's that simple - they're hashed now, which makes them much faster, but also means you can't sort them. Practically every other language does the same thing. It's misleading using dbvars with numbers as keys, because they seem to stay in order when they're hashed - if you use strings instead of numbers for keys (say, alice bert charlie) it's much more obvious that the variable isn't maintaining its order. There's almost certainly a way to do what you want without pfaffing about with key order, but to help you with that, we'd need to know the actual problem you're trying to solve. Anyway, with that said:

#local $temp
#loopdb @db {#additem $temp %key}
$temp=%sort($temp)
#forall $temp {#say Key: %i Val: %db(@db,%i)}

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

What follows is 100% untested

From this thread

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

yes Dharkael, sorting numerically! =D

However, I'm getting this error...

illegal token: = zs.param(1)

Adept Joined: 27 May 2008 Posts: 299

that doesn't do anything but show the same order as #SHOWDB @db.

sorting one|two|three|four|five is gonna give you five|four|one|three|two.

Im gonna assume the actual variable your doing this to is your order_list I built for you in the other post. SO in actuality its gonna look like this...

#var order_list {servant=1|female=2|priest=3}

Using Fangs example you would get...
Key: female Val: 2
Key: priest Val: 3
Key: servant Val: 1

Perhaps after doing what I showed you could replace the |'s with line breaks, not sure how that would work, it would also probaly require qouting each item in the string with replace at some point too, maybe subregex could be used to do this.

You would end up with $temp = "1=one"%cr"2=two"%cr"3=three" Again... Not sure that would work, just an idea.

Oo, I got Ninja'd... Twice. But Dhark is right after 9 cmud will screw you, didn't even think about that.

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

went ahead and tried it, and it gives the the "local errstr" message... that means that its working, kinda? lol, tia!

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Yea Toxic, same db var... hehe, your so smart... =]

The reasoning behind this, is that later on, when I start adding and removing mobs from the active script, I'd like to be able to reaarange the order in which the mobs are attacked, and this is just the start of all that, but for now, I'd just like to be able to see the order in which they are being handled. And... Sort it numerically, mostly because thats the order that I understand.

I know that the formatting is very grainular, but I didn't think that it would be this "difficult". I'm actually fine with the code that Toxic gave, just because other areas are VERY large, with a TON of mobs, and any longer, and I'd have to scroll up and down to see the list... Hahahahah!

Adept Joined: 27 May 2008 Posts: 299

One problem, my answer is going to mess up when the number of mobs goes over 9... for instance sorting

var = {1|5|3|6|7|9|10}

is gonna give you {1|10|3|5|6|7|9}

so you might want to look into sorting the $temp var I made with Dhark's answer.

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Gar! There is always a catch! LoL!

Dhark... Don't suppose you know whats wrong with:

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Posted: Fri Jun 27, 2008 5:15 pm

Actually, you *can* sort a database variable. You need to use the #SORT command:

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

Yea, the original post, I noticed that I had created the database wrong, but I went ahead an silently "fixed" that... Hehe... =]

As far as the #SORT .... It isn't sorting it numerically by the %val as to what I'm aiming for... Unless I'm missing a step in there?

Adept Joined: 27 May 2008 Posts: 299

Now just do this...

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

GAR! So close.... LoL!

Adept Joined: 27 May 2008 Posts: 299

hmm then @nsort isnt working correctly, and since its written in lua, your on your own heh.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

The problem Shaun is that you modified your NSort to do no sorting at all.

Magician Joined: 23 Jul 2005 Posts: 334 Location: Chicago

ah, there we go! works great! =D thanks a ton Dharkael! ^^

Posted: Fri Jun 27, 2008 7:48 pm

True, #SORT is only alphabetical, not numerical. I hope to add other sorting options in the future.

Posted: Fri Jun 27, 2008 8:03 pm

If your adding more sort types, could you do one where it would go by the nth word, right or left?

Posted: Fri Jun 27, 2008 8:30 pm

The only built-in type that I am considering is numeric sorting. And then some sort of method to allow a user-defined function to specify the sort order. But this is on the list for the future and not anything soon.