XoopsModules25x / smallworld

}

// Find worst rated users overall

function Smallworld_worstratedusers()

{

    global $xoopsUser, $xoopsDB;

    $array = 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

function Smallworld_topratedusers()

}

// Find best rated users overall

function Smallworld_topratedusers()

{

    global $xoopsUser, $xoopsDB;

    $array = 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;

}

function smallworld_nextBirthdays()

{