xenforo - Icewind Staff Display Order

[Blasteh]

Hello,
Does anyone know how to change Icewind Staff's display order? Right now it's displaying by username, as in the picture below shows, J comes before T. I'm wanting it to order by the user's ID (my ID is 1, Jai's ID is 2) instead of the username itself. Even an EXTRA.CSS code will do really.

You must be registered for see links

 

[Ecko]

Go find the SQL query that is pulling that info and change/add the right ORDER BY

 

[Blasteh]

Go find the SQL query that is pulling that info and change/add the right ORDER BY

I checked all the files, I can't seem to find that SQL Query. Any idea where it could be? I checked library/Icewind/Staff files.

 

[Ecko]

No, but sounds like it is in Icewind/Staff/Model/

 

[Blasteh]

No, but sounds like it is in Icewind/Staff/Model/

Mind checking it out? I'm stumped. Much appreciated.

You must be registered for see links

 
I'm guessing it's to due with this?
public function prepareUserOrderOptions(array &$fetchOptions, $defaultOrderSql = '')
{
$choices = array(
'username' => 'user.username'
);
return $this->getOrderByClause($choices, $fetchOptions, $defaultOrderSql);
}

If so, how would I properly change it?

 

[Ecko]

idk, contact the author of this plugin

 

[Weasel]

Mind checking it out? I'm stumped. Much appreciated.

You must be registered for see links

 
I'm guessing it's to due with this?
public function prepareUserOrderOptions(array &$fetchOptions, $defaultOrderSql = '')
{
$choices = array(
'username' => 'user.username'
);
return $this->getOrderByClause($choices, $fetchOptions, $defaultOrderSql);
}

If so, how would I properly change it?

In the pastebin code you posted, on line 14, change user.username to user.id

 

[Blasteh]

In the pastebin code you posted, on line 14, change user.username to user.id

Ah, that fixed it. It's not "user.id" it's "user.user_id", thanks Wess!

 

[Weasel]

Ah, that fixed it. It's not "user.id" it's "user.user_id", thanks Wess!

No problem. Wasn't too sure about the column name. If you don't mind marking my answer as "best answer", that would be great.