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; }