5 /* static */ function &fromUserTitle( &$user, &$title ) {
9 $wl->id
= $user->getId();
10 $wl->ns
= $title->getNamespace() & ~
1;
11 $wl->ti
= $title->getDBkey();
12 $wl->eti
= wfStrencode( $wl->ti
);
18 return "$wgDBname:watchlist:user:$this->id:page:$this->ns:$this->ti";
23 # Pages and their talk pages are considered equivalent for watching;
24 # remember that talk namespaces are numbered as page namespace+1.
26 $key = $this->watchKey();
27 $iswatched = $wgMemc->get( $key );
28 if( $iswatched !== false ) return $iswatched;
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);
33 $wgMemc->set( $key, $iswatched );
39 # REPLACE instead of INSERT because occasionally someone
40 # accidentally reloads a watch-add operation.
41 $sql = "REPLACE INTO watchlist (wl_user, wl_namespace,wl_title) VALUES ($this->id,$this->ns,'$this->eti')";
42 $res = wfQuery( $sql, DB_WRITE
);
43 if( $res === false ) return false;
46 $wgMemc->set( $this->watchkey(), 1 );
50 function removeWatch()
52 $sql = "DELETE FROM watchlist WHERE wl_user=$this->id AND wl_namespace=$this->ns AND wl_title='$this->eti' LIMIT 1";
53 $res = wfQuery( $sql, DB_WRITE
);
54 if( $res === false ) return false;
57 $wgMemc->set( $this->watchkey(), 0 );
61 /* static */ function duplicateEntries( $ot, $nt ) {
62 global $wgMemc, $wgDBname;
63 $oldnamespace = $ot->getNamespace() & ~
1;
64 $newnamespace = $nt->getNamespace() & ~
1;
65 $oldtitle = $ot->getDBkey();
66 $newtitle = $nt->getDBkey();
67 $eoldtitle = wfStrencode( $oldtitle );
68 $enewtitle = wfStrencode( $newtitle );
70 $sql = "SELECT wl_user FROM watchlist
71 WHERE wl_namespace={$oldnamespace} AND wl_title='{$eoldtitle}'";
72 $res = wfQuery( $sql, DB_READ
, $fname );
73 if( $s = wfFetchObject( $res ) ) {
74 $sql = "REPLACE INTO watchlist (wl_user,wl_namespace,wl_title)
75 VALUES ({$s->wl_user},{$newnamespace},'{$enewtitle}')";
76 $key = "$wgDBname:watchlist:user:$s->wl_user:page:$newnamespace:$newtitle";
77 $wgMemc->set( $key, 1 );
78 while( $s = wfFetchObject( $res ) ) {
79 $sql .= ",({$s->wl_user},{$newnamespace},'{$enewtitle}')";
80 $key = "$wgDBname:watchlist:user:$s->wl_user:page:$newnamespace:$newtitle";
81 $wgMemc->set( $key, 1 );
83 $res = wfQuery( $sql, DB_WRITE
, $fname );
84 if( $res === false ) return false; # db error?