2017-12-11, 08:43 PM
Hi, how to sort prefixes by ID, not by name?
![[Image: Capture2.png]](https://camo.mybb.com/3c40ff9a9a3a7d6a063efa9b79946fd7d2a42f46/68747470733a2f2f7468756d622e6962622e636f2f6974423643772f43617074757265322e706e67)
![[Image: Capture1.jpg]](https://camo.mybb.com/42a773387525f286b0482e29a0be16c385f2c11b/68747470733a2f2f7468756d622e6962622e636f2f6738454d65622f43617074757265312e6a7067)
2017-12-11, 08:57 PM
My guess is that you have to change the core code to use a different sortby option.
You might get away with just editing how the cache is stored.
inc/class_datacache.php
$query = $db->simple_select("threadprefixes", "*", "", array('order_by' => 'prefix', 'order_dir' => 'ASC'));
Change that to sort by pid then rebuild the cache and see if that does it for you.
You might get away with just editing how the cache is stored.
inc/class_datacache.php
$query = $db->simple_select("threadprefixes", "*", "", array('order_by' => 'prefix', 'order_dir' => 'ASC'));
Change that to sort by pid then rebuild the cache and see if that does it for you.
2017-12-11, 09:48 PM
(2017-12-11, 08:57 PM)labrocca Wrote: [ -> ]My guess is that you have to change the core code to use a different sortby option.
You might get away with just editing how the cache is stored.
inc/class_datacache.php
$query = $db->simple_select("threadprefixes", "*", "", array('order_by' => 'prefix', 'order_dir' => 'ASC'));
Change that to sort by pid then rebuild the cache and see if that does it for you.
Tank you! Working fine!
$query = $db->simple_select("threadprefixes", "*", "", array('order_by' => 'pid', 'order_dir' => 'ASC'));