public static function getListByOrder($akCategoryHandle = 'collection', $filters = array()) {
     $db = Loader::db();
     $q = 'select akID from AttributeKeys inner join AttributeKeyCategories on AttributeKeys.akCategoryID = AttributeKeyCategories.akCategoryID where akCategoryHandle = ?';
 
      foreach($filters as $key => $value) {
         $q .= ' and ' . $key . ' = ' . $value . ' ';
      }
      $r = $db->Execute($q, array($akCategoryHandle));
 
 
      $list = array();
      $listOrder = array();
      $txt = Loader::helper('text');
      $className = $txt->camelcase($akCategoryHandle);
      while ($row = $r->FetchRow()) {
         $c1 = $className . 'AttributeKey';
         $c1a = call_user_func_array(array($c1, 'getByID'), array($row['akID']));
         if (is_object($c1a)) {
            $list[] = $c1a;
            //jd edits
            $qOrder = 'SELECT akOrder FROM AttributeKeysOrder WHERE akID = ? LIMIT 1';
            $rOrder = $db->Execute($qOrder, array($c1a->akID));
            $row = $rOrder->FetchRow();
            if($row['akOrder'] == true) {
               $listOrder[] = $row['akOrder'];
            } else {
               $listOrder[] = 0;
            }
            //end edits
 
         }
      }
      $r->Close();
      array_multisort($listOrder, $list);
      return $list;
   }
 

 
<?php 
defined('C5_EXECUTE') or die(_("Access Denied."));
$canRead = true;
$ch = Page::getByID($_REQUEST['cID']);
$path = $ch->getCollectionPath();
if (strpos($path, '/dashboard') === 0) {
   $cp = new Permissions($ch);
   if ($cp->canRead()) {
      $canRead = true;
   }
}
 
if (!$canRead) {
   die(_("Access Denied."));
}
 
// this should be cleaned up.... yeah
$db = Loader::db();
// update order of collections
//Loader::model('user_attributes');
$uats = $_REQUEST['akOrder'];
$ak = explode(",", $uats);
 
if (is_array($ak)) {
   $myarray = array();
   $qOrder = 'SELECT akID FROM AttributeKeysOrder';
   $rOrder = $db->Execute($qOrder);
   while ($row = $rOrder->FetchRow()) {
      $myarray[] = $row['akID'];
   }
 
   print_r($myarray);
   for($i=0; $i<count($ak); $i++) {
      $clean_ak = str_replace("akID_", "", $ak[$i]);
      //print_r($clean_ak);
 
      if (in_array($clean_ak, $myarray)) {
         $qOrder = 'UPDATE AttributeKeysOrder SET akOrder = ?  WHERE akID = ? LIMIT 1';
         $rOrder = $db->Execute($qOrder, array($i, $clean_ak));
      } else {
         $qOrder = 'INSERT INTO AttributeKeysOrder (akOrder, akID) VALUES (?, ?)';
         $rOrder = $db->Execute($qOrder, array($i, $clean_ak));
      }
 
   }
}