Esempio n. 1
0
        $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();