XoopsModules25x / efqdirectory

 * @param     $filter_arr

 * @return int|void

 */

function mod_search_count($queryarray, $andor, $limit, $offset = 0, $filter_arr)

{

    global $xoopsDB, $eh;

    $count = 0;

    $sql = 'SELECT COUNT(DISTINCT i.itemid) FROM '

           . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_data')

           . ' d, '

           . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_items')

           . ' i LEFT JOIN '

           . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_item_text')

           . " t ON (i.itemid=t.itemid) WHERE d.itemid=i.itemid AND i.status='2'";

    // because count() returns 1 even if a supplied variable

    // is not an array, we must check if $queryarray is really an array

    if (is_array($queryarray) && $count = count($queryarray)) {

        $sql .= " AND ((d.value LIKE '%$queryarray[0]%' OR i.title LIKE '%$queryarray[0]%' OR t.description LIKE '%$queryarray[0]%')";

        for ($i = 1; $i < $count; ++$i) {

            $sql .= " $andor ";

            $sql .= "(d.value LIKE '%$queryarray[$i]%' OR i.title LIKE '%$queryarray[$i]%' OR t.description LIKE '%$queryarray[$i]%')";

        }

        $sql .= ') ';

    }

    $result = $xoopsDB->query($sql) or $eh->show('0013');

    list($count) = $xoopsDB->fetchRow($result);

    return $count;

}

/**

 * @param int $dtypeid

 * @param int $offset

 * @return int|void

 */

function mod_search_count($queryarray, $andor, $limit, $offset = 0)

{

    global $xoopsDB, $eh;

    $count = 0;

    $sql   = 'SELECT COUNT(DISTINCT i.itemid) FROM '

             . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_data')

             . ' d, '

             . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_items')

             . ' i LEFT JOIN '

             . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_item_text')

             . " t ON (i.itemid=t.itemid) WHERE d.itemid=i.itemid AND i.status='2'";

    // because count() returns 1 even if a supplied variable

    // is not an array, we must check if $queryarray is really an array

    if (is_array($queryarray) && $count = count($queryarray)) {

        $sql .= " AND ((d.value LIKE '%$queryarray[0]%' OR i.title LIKE '%$queryarray[0]%' OR t.description LIKE '%$queryarray[0]%')";

        for ($i = 1; $i < $count; ++$i) {

            $sql .= " $andor ";

            $sql .= "(d.value LIKE '%$queryarray[$i]%' OR i.title LIKE '%$queryarray[$i]%' OR t.description LIKE '%$queryarray[$i]%')";

        }

        $sql .= ') ';

    }

    $result = $xoopsDB->query($sql) or $eh->show('0013');

    list($count) = $xoopsDB->fetchRow($result);

    return $count;

}