mambax7 / adslight

/**

 * @param $sel_id

 */

function updateUrating($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 user

/**

/**

 * @param $sel_id

 */

function updateIrating($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