XoopsModules25x / xoopshp

 * @param $options

 * @return array

 */

function b_XHP_completed_show($options)

{

    global $xoopsDB, $xoopsUser, $xoopsConfig;

    $myts      = MyTextSanitizer::getInstance();

    $block     = array();

    $mydirname = $options[3];

    $mymodpath = "modules/$mydirname";

    include "$mymodpath/module_prefix.php";

    $rsl    = $xoopsDB->prefix($module_prefix . '_results');

    $usr    = $xoopsDB->prefix('users');

    $sql    =

        "SELECT count(*) AS completed, $rsl.uid, $usr.uname FROM $rsl INNER JOIN $usr ON $rsl.uid=$usr.uid GROUP BY $rsl.uid HAVING completed >= $options[2] ORDER BY completed $options[0] LIMIT $options[1]";

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

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

        $items              = array();

        $items['completed'] = $myrow['completed'];

        $items['uname']     = $myrow['uname'];

        $items['uid']       = $myrow['uid'];

        $block['items'][]   = $items;

    }

    return $block;

}

/**

 * @param $options

 * @param $options

 * @return array

 */

function b_XHP_ranking_show($options)

{

    global $xoopsDB, $xoopsUser, $xoopsConfig;

    $myts      = MyTextSanitizer::getInstance();

    $block     = array();

    $mydirname = $options[3];

    $mymodpath = "modules/$mydirname";

    include "$mymodpath/module_prefix.php";

    $rsl    = $xoopsDB->prefix($module_prefix . '_results');

    $usr    = $xoopsDB->prefix('users');

    $sql    =

        "SELECT round(avg(score),2) AS average, $rsl.uid, $usr.uname FROM $rsl INNER JOIN $usr ON $rsl.uid=$usr.uid GROUP BY $rsl.uid HAVING average >= $options[2] ORDER BY average $options[0] LIMIT $options[1]";

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

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

        $items            = array();

        $items['average'] = $myrow['average'];

        $items['uname']   = $myrow['uname'];

        $items['uid']     = $myrow['uid'];

        $block['items'][] = $items;

    }

    return $block;

}

/**

 * @param $options