public static function insertEntry(GWF_User $user, WC_Site $site, $onsitescore, $comment) { $user = GWF_User::getByID($user->getID()); $max = $site->getOnsiteScore(); $perc = $max <= 0 ? 0 : round($onsitescore / $max * 10000); $entry = new self(array('userhist_uid' => $user->getVar('user_id'), 'userhist_date' => time(), 'userhist_sid' => $site->getVar('site_id'), 'userhist_percent' => $perc, 'userhist_onsitescore' => $onsitescore, 'userhist_rank' => WC_RegAt::calcRank($user), 'userhist_totalscore' => $user->getVar('user_level'), 'userhist_comment' => $comment)); if (WECHALL_DEBUG_SCORING) { echo WC_HTML::message('Inserting User History entry...'); } return $entry->insert(); }
public static function insertEntry(GWF_User $user, WC_Site $site, $type, $onsitescore_new = 0, $onsitescore_old = 0, $scoregain = 0, $onsiterank = 0) { $uid = $user->getID(); $user = GWF_User::getByID($uid); $max = $site->getOnsiteScore(); $perc_new = $max <= 0 ? 0 : round($onsitescore_new / $max * 10000); $perc_old = $max <= 0 ? 0 : round($onsitescore_old / $max * 10000); $perc_gain = $perc_new - $perc_old; $options = 0; $data = $user->getUserData(); if (isset($data['WC_NO_XSS'])) { $options |= self::NO_XSS; } $entry = new self(array('userhist_uid' => $uid, 'userhist_date' => time(), 'userhist_sid' => $site->getID(), 'userhist_percent' => $perc_new, 'userhist_onsitescore' => $onsitescore_new, 'userhist_rank' => WC_RegAt::calcExactRank($user), 'userhist_totalscore' => $user->getVar('user_level'), 'userhist_gain_perc' => $perc_gain, 'userhist_gain_score' => $scoregain, 'userhist_type' => $type, 'userhist_onsiterank' => $onsiterank, 'userhist_options' => $options)); if (WECHALL_DEBUG_SCORING) { echo WC_HTML::message('Inserting User History entry...'); } return $entry->insert(); }
foreach ($tVars['linked'] as $data) { $site instanceof WC_Site; $site->setVars($data); $regat->setVars($data); $siteid = $site->getVar('site_id'); // $regat = WC_RegAt::getRegatRow($userid, $siteid); $btn_update = sprintf('<input type="submit" name="update[%s]" value="%s" />', $siteid, $tLang->lang('btn_update')); echo GWF_Table::rowStart(); echo GWF_Table::column($site->displayStatus()); echo GWF_Table::column($site->displayIcon(1.0) . ' ' . $site->displayLink()); echo GWF_Table::column($regat->getVar('regat_challsolved'), 'gwf_num'); echo GWF_Table::column($site->getVar('site_challcount'), 'gwf_num'); echo GWF_Table::column($site->displayAutoUpdate()); echo GWF_Table::column($btn_update); echo GWF_Table::column($regat->getVar('regat_score'), 'gwf_num'); $perc = $regat->getPercent($site->getOnsiteScore()); $color = WC_HTML::getColorForPercent($perc); echo GWF_Table::column(sprintf('<span style="color: #%s">%.02f%%</span>', $color, $perc), 'gwf_num'); echo GWF_Table::column($regat->displayLastDate(), 'gwf_date'); echo GWF_Table::column($regat->displayOnsiteName()); if ($regat->isOnsitenameHidden()) { echo GWF_Table::column(sprintf('<input type="submit" name="showname[%s]" value="%s" />', $siteid, $txtshow)); } else { echo GWF_Table::column(sprintf('<input type="submit" name="hidename[%s]" value="%s" />', $siteid, $txthide)); } // if ($regat->isScored()) { // echo GWF_Table::column(sprintf('<input type="submit" name="scored[%s]" value="%s" />', $siteid, $txtscore)); // } else { // echo GWF_Table::column(sprintf('<input type="submit" name="unscored[%s]" value="%s" />', $siteid, $txtunscore)); // } echo sprintf('<td><input type="submit" name="unlink[%s]" value="%s" /></td>', $siteid, $tLang->lang('btn_unlink'));
public static function fixPercent(WC_Site $site) { return true; $siteid = $site->getID(); $maxscore = $site->getOnsiteScore(); if (false === GDO::table(__CLASS__)->update("regat_solved=regat_onsitescore/{$maxscore} WHERE regat_sid={$siteid}")) { echo GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__)); return false; } return true; }