SET last = FROM_UNIXTIME({?})
WHERE uid = {?}',
Get::i('read'), S::i('uid'));
SET last = FROM_UNIXTIME({?})
WHERE uid = {?}',
Get::i('read'), S::i('uid'));
}
XDB::execute('INSERT IGNORE INTO watch_promo (uid, promo)
VALUES ' . implode(', ', $to_add));
}
XDB::execute('INSERT IGNORE INTO watch_promo (uid, promo)
VALUES ' . implode(', ', $to_add));
XDB::execute('DELETE FROM watch_promo
WHERE ' . XDB::format('uid = {?}', S::i('uid')) . '
AND promo IN (' . implode(', ', $to_delete) . ')');
XDB::execute('DELETE FROM watch_promo
WHERE ' . XDB::format('uid = {?}', S::i('uid')) . '
AND promo IN (' . implode(', ', $to_delete) . ')');
}
public function addNonRegistered(PlPage &$page, PlUser &$user)
{
XDB::execute('INSERT IGNORE INTO watch_nonins (uid, ni_id)
VALUES ({?}, {?})', S::i('uid'), $user->id());
}
public function addNonRegistered(PlPage &$page, PlUser &$user)
{
XDB::execute('INSERT IGNORE INTO watch_nonins (uid, ni_id)
VALUES ({?}, {?})', S::i('uid'), $user->id());
XDB::execute('DELETE FROM watch_nonins
WHERE uid = {?} AND ni_id = {?}',
S::i('uid'), $user->id());
XDB::execute('DELETE FROM watch_nonins
WHERE uid = {?} AND ni_id = {?}',
S::i('uid'), $user->id());
XDB::execute('UPDATE watch
SET actions = {?}
WHERE uid = {?}', $flags, S::i('uid'));
XDB::execute('UPDATE watch
SET actions = {?}
WHERE uid = {?}', $flags, S::i('uid'));
XDB::execute('UPDATE watch
SET ' . XDB::changeFlag('flags', 'contacts', Env::b('contacts')) . '
WHERE uid = {?}', S::i('uid'));
XDB::execute('UPDATE watch
SET ' . XDB::changeFlag('flags', 'contacts', Env::b('contacts')) . '
WHERE uid = {?}', S::i('uid'));
XDB::execute('UPDATE watch
SET ' . XDB::changeFlag('flags', 'mail', Env::b('mail')) . '
WHERE uid = {?}', S::i('uid'));
XDB::execute('UPDATE watch
SET ' . XDB::changeFlag('flags', 'mail', Env::b('mail')) . '
WHERE uid = {?}', S::i('uid'));