XoopsModules25x / smallworld

/**

 * @return array

 */

function Smallworld_worstratedusers()

{

    global $xoopsUser, $xoopsDB;

    $array   = [];

    $counter = 1;

    $sql     = 'SELECT owner, (';

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

    $sql     .= ') AS total';

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

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

    $result  = $xoopsDB->queryF($sql);

    while ($row = $xoopsDB->fetchArray($result)) {

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

        $array[$counter]['img']       = smallworld_getAvatarLink($row['owner'], Smallworld_Gravatar($row['owner']));

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

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

        $array[$counter]['user_link'] = "<a href = '" . XOOPS_URL . '/modules/smallworld/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()

{

    global $xoopsUser, $xoopsDB;

    $array   = [];

    $counter = 1;

    $sql     = 'SELECT owner, (';

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

    $sql     .= ') AS total';

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

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

    $result  = $xoopsDB->queryF($sql);

    while ($row = $xoopsDB->fetchArray($result)) {

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

        $array[$counter]['img']       = smallworld_getAvatarLink($row['owner'], Smallworld_Gravatar($row['owner']));

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

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

        $array[$counter]['user_link'] = "<a href = '" . XOOPS_URL . '/modules/smallworld/userprofile.php?username=' . $array[$counter]['user'] . "'>";

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

        ++$counter;

    }

    return $array;

}

/**

 * @return array