mambax7 / adslight

    /**

     * @param $sel_id

     */

    public static function updateUserRating($sel_id)

    {

        global $xoopsDB, $xoopsUser, $moduleDirName, $main_lang;

        if (isset($_GET['usid'])) {

            $usid = (int)$_GET['usid'];

        } else {

            $usid = 0;

        }

        $query = 'SELECT rating FROM ' . $xoopsDB->prefix('adslight_user_votedata') . ' WHERE usid=' . $xoopsDB->escape($sel_id) . '';

        //echo $query;

        $voteresult  = $xoopsDB->query($query);

        $votesDB     = $xoopsDB->getRowsNum($voteresult);

        $totalrating = 0;

        while (list($rating) = $xoopsDB->fetchRow($voteresult)) {

            $totalrating += $rating;

        }

        $finalrating = $totalrating / $votesDB;

        $finalrating = number_format($finalrating, 4);

        $query       = 'UPDATE ' . $xoopsDB->prefix('adslight_listing') . " SET user_rating=$finalrating, user_votes=$votesDB WHERE usid=" . $xoopsDB->escape($sel_id) . '';

        //echo $query;

        $xoopsDB->query($query) || exit();

    }

    //updates rating data in itemtable for a given item

    /**

    /**

     * @param $sel_id

     */

    public static function updateItemRating($sel_id)

    {

        global $xoopsDB, $xoopsUser, $moduleDirName, $main_lang;

        if (isset($_GET['lid'])) {

            $lid = (int)$_GET['lid'];

        } else {

            $lid = 0;

        }

        $query = 'SELECT rating FROM ' . $xoopsDB->prefix('adslight_item_votedata') . ' WHERE lid=' . $xoopsDB->escape($sel_id) . '';

        //echo $query;

        $voteresult  = $xoopsDB->query($query);

        $votesDB     = $xoopsDB->getRowsNum($voteresult);

        $totalrating = 0;

        while (list($rating) = $xoopsDB->fetchRow($voteresult)) {

            $totalrating += $rating;

        }

        $finalrating = $totalrating / $votesDB;

        $finalrating = number_format($finalrating, 4);

        $query       = 'UPDATE ' . $xoopsDB->prefix('adslight_listing') . " SET item_rating=$finalrating, item_votes=$votesDB WHERE lid=" . $xoopsDB->escape($sel_id) . '';

        //echo $query;

        $xoopsDB->query($query) || exit();

    }

    /**

     * @param        $sel_id