/** * debug only, stripped version of Foretag.saveAndEndForetagsTavling() * only printout */ function saveAndEndForetagsTavling_krillo_debug() { $emailName = "Tavling avslutad - tisdag"; global $db; $sql = 'SELECT a.id FROM mm_medlem a, mm_foretagsnycklar b, mm_foretag c WHERE a.id = b.medlem_id AND b.foretag_id = c.id AND a.epostBekraftad = 1 AND UNIX_TIMESTAMP(c.startDatum) >= ' . (time() - (Foretag::TAVLINGSPERIOD_DAGAR + 3) * 86400) . ' AND UNIX_TIMESTAMP(c.startDatum) < ' . (time() - Foretag::TAVLINGSPERIOD_DAGAR * 86400); $unixtimestamp_first = time() - (Foretag::TAVLINGSPERIOD_DAGAR + 3) * 86400; $unixtimestamp_second = time() - Foretag::TAVLINGSPERIOD_DAGAR * 86400; echo "unixtimestamp_first : " . $unixtimestamp_first . " | " . date("Y-m-d", $unixtimestamp_first) . "<br/>"; echo "unixtimestamp_second : " . $unixtimestamp_second . " | " . date("Y-m-d", $unixtimestamp_second) . "<br/><br/>"; $slutDatum = date("Y-m-d", time()); $slutDatum = Misc::dateToTimestamp($slutDatum); $tavling = new Tavling('0000-00-00'); $save = array(); foreach ($db->valuesAsArray($sql) as $user) { $medlem = Medlem::loadById($user); if (isset($medlem)) { $slutVecka = strftime("%V", $slutDatum); $foretagsSlutVecka = strftime("%V", Misc::dateToTimestamp($medlem->getForetag()->getSlutdatum())); echo "{$slutVecka}: " . $slutVecka . " | " . "{$foretagsSlutVecka}: " . $foretagsSlutVecka . "<br>"; if (Misc::isEmail($medlem->getEpost(), false) && $medlem->getForetag() && $medlem->getLag()) { //self::logEmailSend(false, $emailName, "try", $medlem); echo " " . $medlem->getForetag()->getNamn() . " " . $medlem->getForetag()->getNamn() . " | epost: " . $medlem->getEpost() . "<br/>"; } } } }
function isEmailAdvanced($label, $value, $msg = NULL, $error_level = TRUE) { //Debug::text('Raw Email: '. $value, __FILE__, __LINE__, __METHOD__, $this->verbosity); if (Misc::isEmail($value, TRUE, $error_level) === TRUE) { return TRUE; } $this->Error($label, $msg, $value); return FALSE; }
public function setEpost($epost) { if ($this->getId()) { Security::demand(USER, $this); } global $db; if (!Misc::isEmail($epost)) { throw new MedlemException("Ogiltig e-postadress", -3); } if ($this->getId()) { $sql = "SELECT epost FROM " . $this->getTable() . " WHERE epost = '" . Security::secure_data($epost) . "' "; if ($this->getId()) { $sql .= "AND id <> " . $this->getId(); } if ($db->value($sql) != "") { throw new MedlemException("E-postadressen är upptagen", -6); } } $this->epost = $epost; // TODO: Bekräfta epost }
<?php require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php"; if (isset($_POST['email'])) { $sendMails = array(); $faultyMails = array(); $mailExistsAsMember = array(); $mailExistsAsTip = array(); $maxBatchSize = 5; $currentBatchCount = 0; foreach ($_POST['email'] as $email) { $count = 0; if (!empty($email) && Misc::isEmail($email)) { $count = $db->allValuesAsArray('select id, anamn as username from mm_medlem where epost = "' . mysql_real_escape_string(trim($email)) . '" limit 1;'); if (empty($count)) { $count = $db->nonquery('select * from mm_inbjudningar where epost = "' . mysql_real_escape_string($email) . '" limit 1;'); if ($count == 0) { $sendMails[] = $email; } else { $mailExistsAsTip[] = $email; } } else { foreach ($count as $key => $value) { $mailExistsAsMember[] = $arrayName = array('email' => $email, 'id' => $count[$key]['id'], 'username' => $count[$key]['username']); } } } else { if (!empty($email)) { $faultyMails[] = $email; } }