3 * Accessor and mutator for watchlist entries.
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
25 * Representation of a pair of user and title for watchlist entries.
31 * Constant to specify that user rights 'editmywatchlist' and
32 * 'viewmywatchlist' should not be checked.
35 const IGNORE_USER_RIGHTS
= 0;
38 * Constant to specify that user rights 'editmywatchlist' and
39 * 'viewmywatchlist' should be checked.
42 const CHECK_USER_RIGHTS
= 1;
44 var $mTitle, $mUser, $mCheckRights;
45 private $loaded = false, $watched, $timestamp;
48 * Create a WatchedItem object with the given user and title
49 * @since 1.22 $checkRights parameter added
50 * @param $user User: the user to use for (un)watching
51 * @param $title Title: the title we're going to (un)watch
52 * @param $checkRights int: Whether to check the 'viewmywatchlist' and 'editmywatchlist' rights.
53 * Pass either WatchedItem::IGNORE_USER_RIGHTS or WatchedItem::CHECK_USER_RIGHTS.
54 * @return WatchedItem object
56 public static function fromUserTitle( $user, $title, $checkRights = WatchedItem
::CHECK_USER_RIGHTS
) {
57 $wl = new WatchedItem
;
60 $wl->mCheckRights
= $checkRights;
69 protected function getTitle() {
73 /** Helper to retrieve the title namespace */
74 protected function getTitleNs() {
75 return $this->getTitle()->getNamespace();
78 /** Helper to retrieve the title DBkey */
79 protected function getTitleDBkey() {
80 return $this->getTitle()->getDBkey();
82 /** Helper to retrieve the user id */
83 protected function getUserId() {
84 return $this->mUser
->getId();
88 * Return an array of conditions to select or update the appropriate database
93 private function dbCond() {
95 'wl_user' => $this->getUserId(),
96 'wl_namespace' => $this->getTitleNs(),
97 'wl_title' => $this->getTitleDBkey(),
102 * Load the object from the database
104 private function load() {
105 if ( $this->loaded
) {
108 $this->loaded
= true;
110 // Only loggedin user can have a watchlist
111 if ( $this->mUser
->isAnon() ) {
112 $this->watched
= false;
116 # Pages and their talk pages are considered equivalent for watching;
117 # remember that talk namespaces are numbered as page namespace+1.
119 $dbr = wfGetDB( DB_SLAVE
);
120 $row = $dbr->selectRow( 'watchlist', 'wl_notificationtimestamp',
121 $this->dbCond(), __METHOD__
);
123 if ( $row === false ) {
124 $this->watched
= false;
126 $this->watched
= true;
127 $this->timestamp
= $row->wl_notificationtimestamp
;
133 * @param $what string: 'viewmywatchlist' or 'editmywatchlist'
135 private function isAllowed( $what ) {
136 return !$this->mCheckRights ||
$this->mUser
->isAllowed( $what );
140 * Is mTitle being watched by mUser?
143 public function isWatched() {
144 if ( !$this->isAllowed( 'viewmywatchlist' ) ) {
149 return $this->watched
;
153 * Get the notification timestamp of this entry.
155 * @return false|null|string: false if the page is not watched, the value of
156 * the wl_notificationtimestamp field otherwise
158 public function getNotificationTimestamp() {
159 if ( !$this->isAllowed( 'viewmywatchlist' ) ) {
164 if ( $this->watched
) {
165 return $this->timestamp
;
172 * Reset the notification timestamp of this entry
174 * @param $force Whether to force the write query to be executed even if the
175 * page is not watched or the notification timestamp is already NULL.
176 * @param int $oldid The revision id being viewed. If not given or 0, latest revision is assumed.
178 public function resetNotificationTimestamp( $force = '', $oldid = 0 ) {
179 // Only loggedin user can have a watchlist
180 if ( wfReadOnly() ||
$this->mUser
->isAnon() ||
!$this->isAllowed( 'editmywatchlist' ) ) {
184 if ( $force != 'force' ) {
186 if ( !$this->watched ||
$this->timestamp
=== null ) {
191 $title = $this->getTitle();
193 // No oldid given, assuming latest revision; clear the timestamp.
194 $notificationTimestamp = null;
195 } elseif ( !$title->getNextRevisionID( $oldid ) ) {
196 // Oldid given and is the latest revision for this title; clear the timestamp.
197 $notificationTimestamp = null;
199 // See if the version marked as read is more recent than the one we're viewing.
200 // Call load() if it wasn't called before due to $force.
203 if ( $this->timestamp
=== null ) {
204 // This can only happen if $force is enabled.
205 $notificationTimestamp = null;
207 // Oldid given and isn't the latest; update the timestamp.
208 // This will result in no further notification emails being sent!
209 $dbr = wfGetDB( DB_SLAVE
);
210 $notificationTimestamp = $dbr->selectField(
211 'revision', 'rev_timestamp',
212 array( 'rev_page' => $title->getArticleID(), 'rev_id' => $oldid )
214 // We need to go one second to the future because of various strict comparisons
215 // throughout the codebase
216 $ts = new MWTimestamp( $notificationTimestamp );
217 $ts->timestamp
->add( new DateInterval( 'PT1S' ) );
218 $notificationTimestamp = $ts->getTimestamp( TS_MW
);
220 if ( $notificationTimestamp < $this->timestamp
) {
221 if ( $force != 'force' ) {
224 // This is a little silly…
225 $notificationTimestamp = $this->timestamp
;
231 // If the page is watched by the user (or may be watched), update the timestamp on any
233 $dbw = wfGetDB( DB_MASTER
);
234 $dbw->update( 'watchlist', array( 'wl_notificationtimestamp' => $notificationTimestamp ),
235 $this->dbCond(), __METHOD__
);
236 $this->timestamp
= null;
240 * Given a title and user (assumes the object is setup), add the watch to the
244 public function addWatch() {
245 wfProfileIn( __METHOD__
);
247 // Only loggedin user can have a watchlist
248 if ( wfReadOnly() ||
$this->mUser
->isAnon() ||
!$this->isAllowed( 'editmywatchlist' ) ) {
249 wfProfileOut( __METHOD__
);
253 // Use INSERT IGNORE to avoid overwriting the notification timestamp
254 // if there's already an entry for this page
255 $dbw = wfGetDB( DB_MASTER
);
256 $dbw->insert( 'watchlist',
258 'wl_user' => $this->getUserId(),
259 'wl_namespace' => MWNamespace
::getSubject( $this->getTitleNs() ),
260 'wl_title' => $this->getTitleDBkey(),
261 'wl_notificationtimestamp' => null
262 ), __METHOD__
, 'IGNORE' );
264 // Every single watched page needs now to be listed in watchlist;
265 // namespace:page and namespace_talk:page need separate entries:
266 $dbw->insert( 'watchlist',
268 'wl_user' => $this->getUserId(),
269 'wl_namespace' => MWNamespace
::getTalk( $this->getTitleNs() ),
270 'wl_title' => $this->getTitleDBkey(),
271 'wl_notificationtimestamp' => null
272 ), __METHOD__
, 'IGNORE' );
274 $this->watched
= true;
276 wfProfileOut( __METHOD__
);
281 * Same as addWatch, only the opposite.
284 public function removeWatch() {
285 wfProfileIn( __METHOD__
);
287 // Only loggedin user can have a watchlist
288 if ( wfReadOnly() ||
$this->mUser
->isAnon() ||
!$this->isAllowed( 'editmywatchlist' ) ) {
289 wfProfileOut( __METHOD__
);
294 $dbw = wfGetDB( DB_MASTER
);
295 $dbw->delete( 'watchlist',
297 'wl_user' => $this->getUserId(),
298 'wl_namespace' => MWNamespace
::getSubject( $this->getTitleNs() ),
299 'wl_title' => $this->getTitleDBkey(),
302 if ( $dbw->affectedRows() ) {
306 # the following code compensates the new behavior, introduced by the
307 # enotif patch, that every single watched page needs now to be listed
308 # in watchlist namespace:page and namespace_talk:page had separate
309 # entries: clear them
310 $dbw->delete( 'watchlist',
312 'wl_user' => $this->getUserId(),
313 'wl_namespace' => MWNamespace
::getTalk( $this->getTitleNs() ),
314 'wl_title' => $this->getTitleDBkey(),
318 if ( $dbw->affectedRows() ) {
322 $this->watched
= false;
324 wfProfileOut( __METHOD__
);
329 * Check if the given title already is watched by the user, and if so
330 * add watches on a new title. To be used for page renames and such.
332 * @param $ot Title: page title to duplicate entries from, if present
333 * @param $nt Title: page title to add watches on
335 public static function duplicateEntries( $ot, $nt ) {
336 WatchedItem
::doDuplicateEntries( $ot->getSubjectPage(), $nt->getSubjectPage() );
337 WatchedItem
::doDuplicateEntries( $ot->getTalkPage(), $nt->getTalkPage() );
341 * Handle duplicate entries. Backend for duplicateEntries().
348 private static function doDuplicateEntries( $ot, $nt ) {
349 $oldnamespace = $ot->getNamespace();
350 $newnamespace = $nt->getNamespace();
351 $oldtitle = $ot->getDBkey();
352 $newtitle = $nt->getDBkey();
354 $dbw = wfGetDB( DB_MASTER
);
355 $res = $dbw->select( 'watchlist', 'wl_user',
356 array( 'wl_namespace' => $oldnamespace, 'wl_title' => $oldtitle ),
357 __METHOD__
, 'FOR UPDATE'
359 # Construct array to replace into the watchlist
361 foreach ( $res as $s ) {
363 'wl_user' => $s->wl_user
,
364 'wl_namespace' => $newnamespace,
365 'wl_title' => $newtitle
369 if ( empty( $values ) ) {
375 # Note that multi-row replace is very efficient for MySQL but may be inefficient for
376 # some other DBMSes, mostly due to poor simulation by us
377 $dbw->replace( 'watchlist', array( array( 'wl_user', 'wl_namespace', 'wl_title' ) ), $values, __METHOD__
);