How to list domains in alphabetical order?

[torreschrist]

I would like to have the option to list my domains in alphabetical order. What files have to be modified to accomplish that?
EHCP 0.30.9.
Ubuntu 12.04.

Restored from old drupal forum, for user uid:6843 username:torreschrist
You may reset your password to access your new account here.

[ehcpdeveloper]

if you talk about link: /?op=listselectdomain

open classapp.php,
find function getDomains($filt=''){

just before return, add:
$q.=" order by domainname";

save, thats it.
should this be the default in ehcp ? what you think ?

Restored from old drupal forum, for user uid:6843 username:torreschrist
You may reset your password to access your new account here.

[torreschrist]

Yes I think that it should be the default in ehcp as it makes it easier to locate domains when you have a large number of them in one server.

Also, I did what you suggested but got the following error:

err: query: select * from domainsorder by domainname (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'by domainname' at line 1)

Is there something I'm missing? Do I have to write anything in MySQL?
(sorry for my ignorance, I am currently trying to learn more php and MySQL).

Thank you for your prompt assistance!

Restored from old drupal forum, for user uid:1 username:ehcpdeveloper
You may reset your password to access your new account here.

[torreschrist]

Was able to figure out the error. I was inputing that line as a new one but just added it like this and it worked. Thank you again for all your help.

function getDomains($filt=''){
$domtable=$this->conf['domainstable']['tablename'];
$q="select * from $domtable order by domainname";
if($filt<>'')$q.=" where $filt";
#echo "$q\n";
return $this->query($q);

Restored from old drupal forum, for user uid:6843 username:torreschrist
You may reset your password to access your new account here.

[ehcpdeveloper]

this should be more correct:
<code>
function getDomains($filt=''){
$domtable=$this->conf['domainstable']['tablename'];
$q="select * from $domtable";
if($filt<>'')$q.=" where $filt";
#echo "$q\n";
$q.=" order by domainname";
return $this->query($q);
}

Because, your code would fail if a domain is searched.
I made this default in my local copy too, I will release it as ehcp_yeni.tgz soon.

So, thank you for your suggestion.

Restored from old drupal forum, for user uid:6843 username:torreschrist
You may reset your password to access your new account here.