Добавление типа клуба для возможности сортировки

CREATE TABLE IF NOT EXISTS `cms_clubs_cat` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `cat_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=9 ;
 
--
-- Dumping data for table `cms_clubs_cat`
--
 
INSERT INTO `cms_clubs_cat` (`id`, `cat_name`) VALUES
(1, 'Категория 1'),
(2, 'Категория 2'),
(3, 'Категория 3'),
(4, 'Категория 4'),
(5, 'Категория 5'),
(6, 'Категория 6'),
(7, 'Категория 7'),
(8, 'Категория8');

	<tr>
	  <td><strong>{$LANG.SELECT_CLUB_CAT}: </strong></td>
	  <td>
		  <select name="clubcat" id="clubcat" style="width:300px">
			{foreach key=id item=clubcat from=$clubcats}
				<option value="{$clubcat.id}">{$clubcat.cat_name}</option>
			{/foreach}
		  </select>
	  </td>
	</tr>
	<tr>
 

$_LANG['SELECT_CLUB_CAT']              ='Выберите категорию конкурса';

	public function getClubCat($catId) {
		$sql = "SELECT cat_name FROM cms_clubs_cat WHERE id = $catId"; // формируем запрос
		$result = $this->inDB->query($sql);	  // выполняем запрос
		if ($this->inDB->error()) { return false; }	// Контролим ошибки
        if (!$this->inDB->num_rows($result)) { return false; }	// если  результат запроса пуст
		$result = $this->inDB->fetch_assoc($result);	// загружаем в массив результат
		return $result[cat_name];
	}

        $routes[] = array(
                            '_uri'  => '/^clubs\/page\-([0-9]+)$/i',
                            'do'    => 'view',
                            1       => 'page'
                         );

        $routes[] = array(
                            '_uri'  => '/^clubs\/cat([0-9]+)$/i',
                            'do'    => 'viewcat',
                            1       => 'cat_id'
                         );

////////// VIEW ALL CLUBS CAT ////////////////////////////////////////////////////////////////////////////////////////
if ($do=='viewcat'){
 
	//PAGINATION
    $perpage    = isset($cfg['perpage']) ? $cfg['perpage'] : 10;
	$page       = $inCore->request('page', 'int', 1);
	$cat_id       = $inCore->request('cat_id', 'int');
 
	$clubs      = array();
    $clubs_list = $model->getClubsCat($page, $perpage,$cat_id);
 
	$total = 0;
 
	if ($clubs_list){
		foreach ($clubs_list as $club){
			if (!$club['imageurl']) { $club['imageurl'] = 'nopic.jpg'; } else {
				if (!file_exists(PATH.'/images/clubs/small/'.$club['imageurl'])){
					$club['imageurl'] = 'nopic.jpg';
				}
			}
			$clubs[] = $club;
		}
		$total      = $model->getClubsCount();
        $pagination = cmsPage::getPagebar($total, $page, $perpage, '/clubs/page-%page%', array());
	}
 
	$smarty = $inCore->initSmarty('components', 'com_clubs_view.tpl');
	$smarty->assign('pagetitle', $pagetitle);
	$smarty->assign('clubid', $id);
	// Ссылку на создание клуба показываем всем авторизованным
	$smarty->assign('can_create', $inUser->id);
	$smarty->assign('clubs', $clubs);
	$smarty->assign('total', $total);
	$smarty->assign('pagination', $pagination);
	$smarty->display('com_clubs_view.tpl');
 
}
 

        $sql =  "SELECT c.*, (COUNT(uc.user_id)+1) as members, c.pubdate as pubdate
                 FROM cms_clubs c
                 LEFT JOIN cms_user_clubs uc ON uc.club_id = c.id
                 WHERE c.published = 1
                 GROUP BY c.id
                 ORDER BY is_vip DESC, members DESC
                 LIMIT ".(($page-1)*$perpage).", $perpage";

        $sql =  "SELECT c.*, (COUNT(uc.user_id)+1) as members, c.pubdate as pubdate
                 FROM cms_clubs c
                 LEFT JOIN cms_user_clubs uc ON uc.club_id = c.id 
                 WHERE c.published = 1
                 GROUP BY c.id
                 ORDER BY cat_id ASC, is_vip DESC, members DESC
                 LIMIT ".(($page-1)*$perpage).", $perpage";

    public function getCatsList() {
        $cats  = array();
 
        $sql =  "SELECT * FROM cms_clubs_cat";
 
        $rs  = $this->inDB->query($sql) or die(mysql_error());
 
        if (!$this->inDB->num_rows($rs)){ return false;	}
 
        while ($cat = $this->inDB->fetch_assoc($rs)){
            $cats[] = $cat;
        }
 
        $cats = cmsCore::callEvent('GET_CATSLIST', $cats);
 
        return $cats;
    }

    public function getClubName($club_id) {
 
        global $_LANG;
        $sql =  "SELECT *
                 FROM cms_clubs_cat
                 WHERE id = $club_id";
        $result = $this->inDB->query($sql);
        if (!$this->inDB->num_rows($result)){ return false;	}
        $club = $this->inDB->fetch_assoc($result);
        $club = cmsCore::callEvent('GET_CLUB', $club);
        return $club;
    }