Alphabetising

[zpanel]

Alphabetising

[TGates71]

This is a good suggestion ;) I thought it was fixed a while back, but I noticed too that it is not. Should be very easy to do too, just need to add ASC at the end of the DB query.

[stokes84]

@TGates71 is right this is pretty easy for someone that has some time to run through the module controllers real quick (or possibly a higher level solution somewhere?).

Fore example in the MySQL Database list @ /etc/zpanel/panel/modules/mysql_databases/code/controller.ext.php on line 41 you have the query...

$sql = "SELECT * FROM x_mysql_databases WHERE my_acc_fk=:uid AND my_deleted_ts IS NULL";

Just toss ORDER BY my_name_vc at the end. ``my_name_vc` is the key here to organize from you can find your key for each module easily using phpMyAdmin if needed. So our finished product that'll we'll want in line 41 is...

$sql = "SELECT * FROM x_mysql_databases WHERE my_acc_fk=:uid AND my_deleted_ts IS NULL ORDER BY my_name_vc";

and boom, you got a sorted list. You can also probably bust out php's asort on this too but MySQL is optimized to do tasks like this.

[zHostingSolutions]

Package Manager is also not alphabetizing. I think it's the last thing that I recently found. I'm not sure.