member_search()

Complexity

Conditions	6
Paths	8

Size

Total Lines	29
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

<?php
function member_search($queryarray, $andor, $limit, $offset, $userid)
{
    $sql = 'SELECT * FROM ' . $GLOBALS['xoopsDB']->prefix('users') . ' WHERE level > 0';
    if (0 != $userid) {
        $sql .= " AND uid='0'";
    }
    // because count() returns 1 even if a supplied variable  
    // is not an array, we must check if $querryarray is really an array  
    if (is_array($queryarray) && $count = count($queryarray)) {
        $sql .= " AND ((uname LIKE '%{$queryarray[0]}%' OR name LIKE '%{$queryarray[0]}%')";
        for ($i = 1; $i < $count; $i++) {
            $sql .= " $andor ";
            $sql .= "(uname LIKE '%{$queryarray[$i]}%' OR name LIKE '%{$queryarray[$i]}%')";
        }
        $sql .= ') ';
    }
    $sql .= ' ORDER BY uname,name ASC';

    $result = $GLOBALS['xoopsDB']->query($sql, (int)$limit, (int)$offset);
    $ret    = [];
    $i      = 0;
    while (false !== ($myrow = $GLOBALS['xoopsDB']->fetchArray($result))) {
        $ret[$i]['link']  = '' . XOOPS_URL . "\userinfo.php?uid=" . $myrow['uid'] . '';
        $ret[$i]['title'] = '' . htmlspecialchars($myrow['uname'], ENT_QUOTES | ENT_HTML5) . ' / ' . htmlspecialchars($myrow['name'], ENT_QUOTES | ENT_HTML5) . '';
        $ret[$i]['time']  = '' . $myrow['user_regdate'] . '';
        $ret[$i]['uid']   = '' . $myrow['uid'] . '';
        $i++;
    }
    return $ret;
}