Question regarding table.sort

[plamalice]

Hi, im pretty new to lua. Just coded an addon but im having trouble with the sorting function.

I have a table built like this :

PlayerDB = { name, class, level }

PlayerDB.name = { "name1", "name2", "name3" }
PlayerDB.class = { "Hunter", "Priest", "Mage" }
PlayerDB.level = { "30", "20", "10" }

now, if i use the table.sort function on PlayerDB.level, the values get sorted in-place of the current values. name and class though will remain unsorted.

Basically, what im trying to figure out, is if there is a way of table.sort returning me the sorting order (what original index is now index 1,2,3). So that i can then sort the other fields accordingly.

Or is my only option to code my own sorting function ?

[wereHamster]

wouldn't be a better design look like:

PlayerDB = {
   { name = "name1", class = "class1", level = 30 }
   { name = "name2", class = "class2", level = 40 }
   { name = "name3", class = "class3", level = 50 }
}

table.sort(PlayerDB,
   function(leftEntry, rightEntry)
      return leftEntry.level < rightEntry.level
   end
)

[plamalice]

That's exactly what i needed. Thank you

Gonna give it a try later...

Update : Made the changes. Working great. thanks for the help