includes/WatchedItem.php

   1 <?php
   2
   3 class WatchedItem {
   4
   5         /* static */ function &fromUserTitle( &$user, &$title ) {
   6                 $wl = new WatchedItem;
   7                 $wl->mUser =& $user;
   8                 $wl->mTitle =& $title;
   9                 $wl->id = $user->getId();
  10                 $wl->ns = $title->getNamespace() & ~1;
  11                 $wl->ti = $title->getDBkey();
  12                 $wl->eti = wfStrencode( $wl->ti );
  13                 return $wl;
  14         }
  15
  16         function watchKey() {
  17                 global $wgDBname;
  18                 return "$wgDBname:watchlist:user:$this->id:page:$this->ns:$this->ti";
  19         }
  20
  21         function isWatched()
  22         {
  23                 # Pages and their talk pages are considered equivalent for watching;
  24                 # remember that talk namespaces are numbered as page namespace+1.
  25                 global $wgMemc;
  26                 $key = $this->watchKey();
  27                 $iswatched = $wgMemc->get( $key );
  28                 if( is_integer( $iswatched ) ) return $iswatched;
  29
  30                 $sql = "SELECT 1 FROM watchlist WHERE wl_user=$this->id AND wl_namespace=$this->ns AND wl_title='$this->eti'";
  31                 $res = wfQuery( $sql, DB_READ );
  32                 $iswatched = (wfNumRows( $res ) > 0) ? 1 : 0;
  33                 $wgMemc->set( $key, $iswatched );
  34                 return $iswatched;
  35         }
  36
  37         function addWatch()
  38         {
  39                 $fname = "WatchedItem::addWatch";
  40                 # REPLACE instead of INSERT because occasionally someone
  41                 # accidentally reloads a watch-add operation.
  42                 $dbw =& wfGetDB( DB_WRITE );
  43                 $dbw->replace( 'watchlist', array(array('wl_user', 'wl_namespace', 'wl_title')),
  44                   array(
  45                     'wl_user' => $this->id,
  46                         'wl_namespace' => $this->ns,
  47                         'wl_title' => $this->eti,
  48                   ), $fname );
  49
  50                 global $wgMemc;
  51                 $wgMemc->set( $this->watchkey(), 1 );
  52                 return true;
  53         }
  54
  55         function removeWatch()
  56         {
  57                 $sql = "DELETE FROM watchlist WHERE wl_user=$this->id AND wl_namespace=$this->ns AND wl_title='$this->eti'";
  58                 $res = wfQuery( $sql, DB_WRITE );
  59                 if( $res === false ) return false;
  60
  61                 global $wgMemc;
  62                 $wgMemc->set( $this->watchkey(), 0 );
  63                 return true;
  64         }
  65
  66         /* static */ function duplicateEntries( $ot, $nt ) {
  67                 $fname = "WatchedItem::duplicateEntries";
  68                 global $wgMemc, $wgDBname;
  69                 $oldnamespace = $ot->getNamespace() & ~1;
  70                 $newnamespace = $nt->getNamespace() & ~1;
  71                 $oldtitle = $ot->getDBkey();
  72                 $newtitle = $nt->getDBkey();
  73                 $eoldtitle = wfStrencode( $oldtitle );
  74                 $enewtitle = wfStrencode( $newtitle );
  75
  76                 $sql = "SELECT wl_user FROM watchlist
  77                         WHERE wl_namespace={$oldnamespace} AND wl_title='{$eoldtitle}'";
  78                 $res = wfQuery( $sql, DB_READ, $fname );
  79                 if( $s = wfFetchObject( $res ) ) {
  80                         $sql = "REPLACE INTO watchlist (wl_user,wl_namespace,wl_title)
  81                                 VALUES ({$s->wl_user},{$newnamespace},'{$enewtitle}')";
  82                         $key = "$wgDBname:watchlist:user:$s->wl_user:page:$newnamespace:$newtitle";
  83                         $wgMemc->set( $key, 1 );
  84                         while( $s = wfFetchObject( $res ) ) {
  85                                 $sql .= ",({$s->wl_user},{$newnamespace},'{$enewtitle}')";
  86                                 $key = "$wgDBname:watchlist:user:$s->wl_user:page:$newnamespace:$newtitle";
  87                                 $wgMemc->set( $key, 1 );
  88                         }
  89                         $res = wfQuery( $sql, DB_WRITE, $fname );
  90                         if( $res === false ) return false; # db error?
  91                 }
  92                 return true;
  93         }
  94
  95
  96 }
  97
  98 ?>