Антон Самарин

 
if (!$string){ $string = 'untitled'; }
        if (is_numeric($string)){ $string .= 'untitled'; }
 
        return mb_substr($string, 0, 40);

/**
 * Обрезает строку по заданному кол-ву символов
 * @return str
 */
function crop($string, $length = 250, $etc = ''){
 
    if ($length == 0) { return ''; }
 
    $string = str_replace("\n", ' ', strip_tags($string));
 
    if (mb_strlen($string) > $length){
 
        $length -= min($length, mb_strlen($etc));
        $string = preg_replace('/\s+?(\S+)?$/u', '', mb_substr($string, 0, $length+1));
 
        return mb_substr($string, 0, $length) . $etc;
 
    } else {
        return $string;
    }

public function getItemNav($item_id, $cat_id) {
 
        $ordering = $this->inDB->get_field('cms_shop_items_cats', "item_id={$item_id} AND category_id={$cat_id}", 'ordering');
 
        $sql = "SELECT i.id as id, i.seolink as seolink, ic.ordering as ordering, i.title as title
                FROM cms_shop_items i, cms_shop_items_cats ic
                WHERE ic.item_id = i.id AND i.published = 1
                  AND ic.category_id = {$cat_id}
                  AND (ic.ordering < {$ordering} OR ic.ordering > {$ordering})
                LIMIT 2";
 
        $result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)){ return false; }
 
        $items = array();
        $nav = array();
 
        while($item = $this->inDB->fetch_assoc($result)){
            if($item['ordering'] == $ordering-1){
                $nav['prev'] = $item;
            } else {
                $nav['next']= $item;
            }
        }
 
        return $nav;
 
    }

public function getItemNav($id, $price) {
 
        $ordering = $this->inDB->get_field('cms_shop_items', "id={$id} AND price={$price}", 'price');
        $sql = "SELECT id, seolink, title, price
                FROM cms_shop_items
                WHERE published = 1
                  AND (price < {$ordering} OR price > {$ordering})
                LIMIT 2";
        $result = $this->inDB->query($sql);
 
        if (!$this->inDB->num_rows($result)){ return false; }
 
        $items = array();
        $nav = array();
 
        while($item = $this->inDB->fetch_assoc($result)){
            if($item['price'] == $ordering-1){
                $nav['prev'] = $item;
            } else {
                $nav['next']= $item;
            }
        }
 
        return $nav;
 
    }

$sql = "SELECT DISTINCT con.*,
                       cat.title cat_title,
                       cat.seolink as cat_seolink
                FROM cms_shop_items con, cms_shop_cats cat
                WHERE MATCH(con.title, con.shortdesc, con.description) AGAINST ('$query' IN BOOLEAN MODE) AND con.category_id = cat.id AND con.published=1";

$sql = "SELECT DISTINCT con.*,
                       cat.title cat_title,
                       cat.seolink as cat_seolink
                FROM cms_shop_items con, cms_shop_cats cat
                WHERE MATCH(con.title, con.shortdesc, con.description) AGAINST ('$query' IN BOOLEAN MODE) AND con.category_id = cat.id AND con.published=1
                ORDER BY con.price ASC";