Forum

$request = "SELECT ".
            $args['id_search']." AS `id_search`,
            p.id AS `id_content`,
            p.title AS `title`,
            ( 2 * MATCH(p.title) AGAINST('".$args['search']."') + MATCH(p.contents) AGAINST('".$args['search']."') ) / 3 * " . $weight . " AS `relevance`,
            CONCAT('" . PATH_TO_ROOT . "/pages/pages.php?title=',p.encoded_title) AS `link`,
            p.auth AS `auth`
            FROM " . PREFIX . "pages p
            WHERE ( MATCH(title) AGAINST('".$args['search']."') OR MATCH(contents) AGAINST('".$args['search']."') )".$auth_cats
            .$Sql->limit(0, PAGES_MAX_SEARCH_RESULTS);
 

$request = "SELECT ".
            $args['id_search']." AS `id_search`,
            p.id AS `id_content`,
            p.title AS `title`,
            MATCH(p.title) AGAINST('".$args['search']."') * " . $weight . " AS `relevance`,
            CONCAT('" . PATH_TO_ROOT . "/pages/pages.php?title=',p.encoded_title) AS `link`,
            p.auth AS `auth`
            FROM " . PREFIX . "pages p
            WHERE ( MATCH(title) AGAINST('".$args['search']."') )".$auth_cats
            .$Sql->limit(0, PAGES_MAX_SEARCH_RESULTS);
 

$request = "SELECT
                                " . $args['id_search'] . " AS id_search,
                     a.id AS id_content,
                     a.title AS title,
                     ( 2 * MATCH(a.title) AGAINST('" . $args['search'] . "') + MATCH(a.contents) AGAINST('" . $args['search'] . "') ) / 3 * " . $weight . " AS relevance, "
                     . $Sql->concat("'" . PATH_TO_ROOT . "/articles/articles.php?id='","a.id","'&cat='","a.idcat") . " AS link
            FROM " . PREFIX . "articles a
            LEFT JOIN " . PREFIX . "articles_cats ac ON ac.id = a.idcat
            WHERE
                a.visible = 1 AND ((ac.aprob = 1 AND ac.auth LIKE '%s:3:"r-1";i:1;%') OR a.idcat = 0)
                AND (MATCH(a.title) AGAINST('" . $args['search'] . "') OR MATCH(a.contents) AGAINST('" . $args['search'] . "'))
            ORDER BY relevance DESC " . $Sql->limit(0, $CONFIG_ARTICLES['nbr_articles_max']);

$request = "SELECT
                                " . $args['id_search'] . " AS id_search,
                     a.id AS id_content,
                     a.title AS title,
                     MATCH(a.title) AGAINST('" . $args['search'] . "') * " . $weight . " AS relevance, "
                     . $Sql->concat("'" . PATH_TO_ROOT . "/articles/articles.php?id='","a.id","'&cat='","a.idcat") . " AS link
            FROM " . PREFIX . "articles a
            LEFT JOIN " . PREFIX . "articles_cats ac ON ac.id = a.idcat
            WHERE
                a.visible = 1 AND ((ac.aprob = 1 AND ac.auth LIKE '%s:3:"r-1";i:1;%') OR a.idcat = 0)
                AND MATCH(a.title) AGAINST('" . $args['search'] . "')
            ORDER BY relevance DESC " . $Sql->limit(0, $CONFIG_ARTICLES['nbr_articles_max']);