function warchall1createEMailB(WC_Challenge $chall, GDO_Database $db2, $eusername)
{
if (false === $db2->queryWrite("DELETE FROM gwf_audit_mails WHERE am_username='******'")) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
if ($db2->affectedRows() == 1) {
return GWF_HTML::message('Warchall', $chall->lang('msg_nomails'));
}
$user = GWF_Session::getUser();
if ('' === ($email = $user->getValidMail())) {
return GWF_HTML::error('Warchall', $chall->lang('err_no_mail'));
}
$eemail = GDO::escape($email);
if (false === $db2->queryWrite("REPLACE INTO gwf_audit_mails VALUES('{$eusername}', '{$eemail}')")) {
return GWF_HTML::err('ERR_DATABASE', array(__FILE__, __LINE__));
}
return GWF_HTML::message('Warchall', $chall->lang('msg_mail'));
}
private function getUserStuff(array $row, GDO_Database $db, $bits)
{
$back = new GWF_User($row);
$regat = GWF_TABLE_PREFIX . 'wc_regat';
$uid = $row['user_id'];
$query = "SELECT regat_sid, regat_solved FROM {$regat} WHERE regat_uid={$uid} AND regat_tagbits&{$bits} AND regat_options&4=0";
if (false === ($result = $db->queryRead($query))) {
return $back;
}
while (false !== ($row = $db->fetchRow($result))) {
$back->setVar('site_' . $row[0], $row[1]);
}
$db->free($result);
return $back;
}