rand(), "X.org rulez"));
XDB::execute("UPDATE {$this->_subscriptionTable} as ni
SET ni.hash = {?}
- WHERE ni.uid != {?}",
+ WHERE ni.uid = {?}",
$hash, $user->id());
}
INNER JOIN accounts AS a ON (ni.uid = a.uid)
LEFT JOIN email_options AS eo ON (eo.uid = a.uid)
LEFT JOIN emails AS e ON (e.uid = a.uid AND e.flags='active')
+ LEFT JOIN account_profiles AS ap ON (a.uid = ap.uid AND FIND_IN_SET('owner', ap.perms))
+ LEFT JOIN profile_display AS pd ON (ap.pid = pd.pid)
WHERE ni.last < {?} AND ({$this->subscriptionWhere()}) AND
(e.email IS NOT NULL OR FIND_IN_SET('googleapps', eo.storage))
GROUP BY a.uid";
public function sendToAll()
{
$this->setSent();
- $query = XDB::format($this->getAllRecipients(), $this->id()) . ' LIMIT 60';
+ $query = XDB::format($this->getAllRecipients(), $this->_id) . ' LIMIT 60';
$emailsCount = 0;
while (true) {