$order = 'sid'; } $torder = $torder == 1 ? 'ASC' : 'DESC'; $order .= ' ' . $torder; /* WHERE */ $where = "WHERE sid <> 20000000 AND sid <> 2000000000 AND plugin_id = {$plugin_id}"; if ($category_id != '') { $where .= " AND category_id='{$category_id}'"; } if ($subcategory_id != '') { $where .= " AND subcategory_id='{$subcategory_id}'"; } if (!empty($search)) { $search = mb_detect_encoding($search . " ", 'UTF-8,ISO-8859-1') == 'UTF-8' ? Util::utf8entities($search) : $search; $search = escape_sql($search, $conn); $pids = Plugin_sid::get_sids_by_category($conn, $plugin_id, $search, $subcategory_id); $p_list = implode(",", $pids); $p_list = empty($p_list) ? "''" : $p_list; $where .= " AND (name like '%{$search}%' OR sid='{$search}' OR category_id in ({$p_list})) "; } /* LIMIT */ $limit = "LIMIT {$from}, {$maxrows}"; $results = array(); if ($plugin_list = Plugin_sid::get_list($conn, "{$where} ORDER BY {$order} {$limit}")) { $total = $plugin_list[0]->get_foundrows(); if ($total == 0) { $total = count($plugin_list); } foreach ($plugin_list as $plugin) { $_res = array(); $plugin_id = $plugin->get_plugin_id();