public function notifyNewArgument(Question $q, Argument $a) { global $sDB, $sTimer, $sTemplate; $sTimer->start("notifyNewArgument"); $res = $sDB->exec("SELECT `notifications`.`userId`, `notifications`.`flags`, `users`.`email`, `users`.`userName` FROM `notifications`\n LEFT JOIN `users` ON `users`.`userId` = `notifications`.`userId`\n WHERE `questionId` = '" . i($q->questionId()) . "';"); while ($row = mysql_fetch_object($res)) { // no notifications for our own arguments. /*if($a->userId() == $row->userId) { continue; }*/ $uId = new BaseConvert($row->userId); $qId = new BaseConvert($q->questionId()); $profileUrl = $sTemplate->getShortUrlBase() . "u" . $uId->val(); $unfollowUrl = $sTemplate->getShortUrlBase() . "f" . $qId->val(); $url = $a->shortUrl(); if (!SHORTURL_BASE) { $profileUrl = $sTemplate->getRoot() . "user/" . $row->userId . "/"; $unfollowUrl = $sTemplate->getRoot() . "unfollow.php?qId=" . $q->questionId(); $url = $a->fullurl(); } $subject = $sTemplate->getString("NOTIFICATION_NEW_ARGUMENT_SUBJECT"); $message = $sTemplate->getString("NOTIFICATION_NEW_ARGUMENT_BODY", array("[USERNAME]", "[AUTHOR]", "[URL]", "[QUESTION]", "[ARGUMENT]", "[UNFOLLOW_URL]", "[PROFILE_URL]"), array($row->userName, $a->author(), $url, $q->title(), $a->headline(), $unfollowUrl, $profileUrl)); $this->sendMail($row->email, "", $subject, $message); } $sTimer->stop("notifyNewArgument"); }