XoopsModules25x / smallworld

/**

 * @return array

 */

function smallworld_worstratedusers()

{

    $swUserHandler = Helper::getInstance()->getHandler('SwUser');

    $array   = [];

    $counter = 1;

    $sql     = 'SELECT owner, (';

    $sql     .= 'sum( up ) - sum( down )';

    $sql     .= ') AS total';

    $sql     .= ' FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_vote') . '';

    $sql     .= ' GROUP BY owner ORDER by total ASC LIMIT 5';

    $result  = $GLOBALS['xoopsDB']->queryF($sql);

    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $array[$counter]['counter']   = $counter;

        $array[$counter]['img']       = $swUserHandler->getAvatarLink($row['owner'], $swUserHandler->gravatar($row['owner']));

        $array[$counter]['user']      = $GLOBALS['xoopsUser']->getUnameFromId($row['owner']);

        $array[$counter]['rating']    = $row['total'];

        $array[$counter]['user_link'] = "<a href = '" . Helper::getInstance()->url('userprofile.php?username=' . $array[$counter]['user']) . "'>";

        $array[$counter]['user_link'] .= $array[$counter]['user'] . ' (' . $array[$counter]['rating'] . ')</a>';

        ++$counter;

    }

    return $array;

}

// Find best rated users overall

/**

/**

 * @return array

 */

function smallworld_topratedusers()

{

    $swUserHandler = Helper::getInstance()->getHandler('SwUser');

    $array   = [];

    $counter = 1;

    $sql     = 'SELECT owner, (';

    $sql     .= 'sum( up ) - sum( down )';

    $sql     .= ') AS total';

    $sql     .= ' FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_vote') . '';

    $sql     .= ' GROUP BY owner ORDER by total DESC LIMIT 5';

    $result  = $GLOBALS['xoopsDB']->queryF($sql);

    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $array[$counter]['counter']   = $counter;

        $array[$counter]['img']       = $swUserHandler->getAvatarLink($row['owner'], $swUserHandler->gravatar($row['owner']));

        $array[$counter]['user']      = $GLOBALS['xoopsUser']->getUnameFromId($row['owner']);

        $array[$counter]['rating']    = $row['total'];

        $array[$counter]['user_link'] = "<a href = '" . Helper::getInstance()->url('userprofile.php?username=' . $array[$counter]['user']) . "'>";

        $array[$counter]['user_link'] .= $array[$counter]['user'] . ' (' . $array[$counter]['rating'] . ')</a>';

        ++$counter;

    }

    return $array;

}

/**

 * @return array