public function onLinkSiteAfterMail(WC_Site $site, GWF_User $user, $onsitename)
{
if (WC_Freeze::isUserFrozenOnSite($user->getID(), $site->getID())) {
return $this->module->error('err_site_ban', array($site->displayName()));
}
if ($site->isUserLinked($user)) {
return $this->module->error('err_already_linked', array($site->displayName()));
}
$siteid = $site->getVar('site_id');
$userid = $user->getVar('user_id');
if (false !== WC_RegAt::getUserByOnsiteName($onsitename, $siteid)) {
return $this->module->error('err_already_linked2', array(GWF_HTML::display($onsitename), $site->displayName()));
}
$options = 0;
$options |= $site->isDefaultHidden() ? WC_RegAt::HIDE_SITENAME : 0;
$regat = new WC_RegAt(array('regat_uid' => $userid, 'regat_sid' => $siteid, 'regat_onsitename' => $onsitename, 'regat_onsitescore' => 0, 'regat_challcount' => $site->getVar('site_challcount'), 'regat_options' => $options, 'regat_langid' => $site->getLangID(), 'regat_tagbits' => $site->getTagBits(), 'regat_linkdate' => GWF_Time::getDate(GWF_Date::LEN_DAY)));
if (false === $regat->insert()) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
if (false === $site->increase('site_linkcount', 1)) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
$error = $site->onUpdateUser($user, true, true);
if (false === ($regat2 = WC_RegAt::getRegatRow($userid, $siteid))) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
require_once GWF_CORE_PATH . 'module/WeChall/WC_FirstLink.php';
if (false === WC_FirstLink::insertFirstLink($user, $site, $onsitename, $regat2->getOnsiteScore())) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
return $error->display($this->module->lang('btn_linked_sites')) . $this->module->message('msg_site_linked', array($site->displayName()));
}
private function getRankedUsers(WC_Site $site, $from, $ipp)
{
$db = gdo_db();
$sid = $site->getVar('site_id');
$bits = $site->getTagBits();
$users = GWF_TABLE_PREFIX . 'user';
$regat = GWF_TABLE_PREFIX . 'wc_regat';
$query = "SELECT user_id, user_name, user_countryid, user_level, regat_solved, regat_onsiterank, regat_score " . "FROM {$regat} " . "JOIN {$users} ON user_id=regat_uid " . "WHERE regat_sid={$sid} AND regat_options&4=0 " . "ORDER BY regat_solved DESC, user_level DESC " . "LIMIT {$from}, {$ipp}";
if (false === ($result = $db->queryRead($query))) {
return array();
}
$back = array();
while (false !== ($row = $db->fetchAssoc($result))) {
$back[] = $this->getUserStuff($row, $db, $bits);
}
$db->free($result);
return $back;
}
