Who is watching a page - Wikitech-l - lists.wikimedia.org

List overview All Threads
Download

Who is watching a page

Trunk changes needing review

Re: [Wikitech-l] [MediaWiki-CVS]...

Paul Grinberg

10 Oct 2007 10 Oct '07

1:45 p.m.

It is possible to display the _number_of_watching_users_ in the footer of every page. However, as an admin of my wiki, I have received numerous requests to also somehow dislay the WHO in addition to the HOW_MANY. Is there an existing hook/extension/feature of the wiki to extract and display that information? Thanks, Paul.

Reply

Show replies by date

Andrew Garrett

10 Oct 10 Oct

9:50 p.m.

On 10/11/07, Paul Grinberg <gri6507(a)yahoo.com> wrote:

It is possible to display the _number_of_watching_users_ in the footer of every page. However, as an admin of my wiki, I have received numerous requests to also somehow dislay the WHO in addition to the HOW_MANY. Is there an existing hook/extension/feature of the wiki to extract and display that information?

It is, of course, possible. However, it has not been implemented because it is objectionable from a privacy perspective. The SQL Query you will require is: SELECT wl_user FROM watchlist WHERE wl_page=page_id where page_id is, obviously, the page_id of the page of interest. -- Andrew Garrett

Reply

Rob Church

12 Oct 12 Oct

10:45 a.m.

On 11/10/2007, Andrew Garrett <andrew(a)epstone.net> wrote:

On 10/11/07, Paul Grinberg <gri6507(a)yahoo.com> wrote:

It is possible to display the _number_of_watching_users_ in the footer of every page. However, as an admin of my wiki, I have received numerous requests to also somehow dislay the WHO in addition to the HOW_MANY. Is there an existing hook/extension/feature of the wiki to extract and display that information?

It is, of course, possible. However, it has not been implemented because it is objectionable from a privacy perspective. The SQL Query you will require is: SELECT wl_user FROM watchlist WHERE wl_page=page_id where page_id is, obviously, the page_id of the page of interest.

SELECT user_name FROM watchlist LEFT JOIN user ON wl_user = user_id WHERE wl_page = <page_id> Rob Church

Reply

Paul Grinberg

5:24 p.m.

Rob Church <robchur@...> writes:

On 11/10/2007, Andrew Garrett <andrew@...> wrote: > On 10/11/07, Paul Grinberg <gri6507@...> wrote: > > It is possible to display the _number_of_watching_users_ in the footer of

every

> > page. However, as an admin of my wiki, I have received numerous requests

to also

> > somehow dislay the WHO in addition to the HOW_MANY. Is there an existing > > hook/extension/feature of the wiki to extract and display that

information?

It is, of course, possible. However, it has not been implemented because it is objectionable from a privacy perspective. The SQL Query you will require is: SELECT wl_user FROM watchlist WHERE wl_page=page_id where page_id is, obviously, the page_id of the page of interest.

SELECT user_name FROM watchlist LEFT JOIN user ON wl_user = user_id WHERE wl_page = <page_id> Rob Church

What version of wiki is this for? I am running 1.9.3 and my watchlist table only has mysql> show columns in wiki_watchlist; +--------------------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+-----------------+------+-----+---------+-------+ | wl_user | int(5) unsigned | NO | PRI | | | | wl_namespace | int(11) | NO | PRI | 0 | | | wl_title | varchar(255) | NO | PRI | | | | wl_notificationtimestamp | varchar(14) | YES | | NULL | | +--------------------------+-----------------+------+-----+---------+-------+ in other words, I don't have "wl_page".

Reply

Rob Church

5:59 p.m.

On 12/10/2007, Paul Grinberg <gri6507(a)yahoo.com> wrote:

Rob Church <robchur@...> writes:

On 11/10/2007, Andrew Garrett <andrew@...> wrote: > On 10/11/07, Paul Grinberg <gri6507@...> wrote: > > It is possible to display the _number_of_watching_users_ in the footer of

every

> > page. However, as an admin of my wiki, I have received numerous requests

to also

> > somehow dislay the WHO in addition to the HOW_MANY. Is there an existing > > hook/extension/feature of the wiki to extract and display that

information?

It is, of course, possible. However, it has not been implemented because it is objectionable from a privacy perspective. The SQL Query you will require is: SELECT wl_user FROM watchlist WHERE wl_page=page_id where page_id is, obviously, the page_id of the page of interest.

SELECT user_name FROM watchlist LEFT JOIN user ON wl_user = user_id WHERE wl_page = <page_id> Rob Church

What version of wiki is this for? I am running 1.9.3 and my watchlist table only has mysql> show columns in wiki_watchlist; +--------------------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+-----------------+------+-----+---------+-------+ | wl_user | int(5) unsigned | NO | PRI | | | | wl_namespace | int(11) | NO | PRI | 0 | | | wl_title | varchar(255) | NO | PRI | | | | wl_notificationtimestamp | varchar(14) | YES | | NULL | | +--------------------------+-----------------+------+-----+---------+-------+ in other words, I don't have "wl_page".

Ah, right, both Andrew and I need a good slapping, then, and a re-read of the schema file. ;) SELECT user_name FROM watchlist LEFT JOIN user ON wl_user = user_id WHERE wl_namespace = <namespace> AND wl_title = <title> The namespace and title can be gotten from a Title object using Title::getNamespace() and Title::getDBkey(). Rob Church

Reply

Paul grinberg

6:57 p.m.

Many thanks! If interested, please see http://www.mediawiki.org/wiki/Extension:WhoIsWatching for implementation.

Reply

Paul grinberg

6:05 p.m.

What version of wiki is this for? I am running 1.9.3 and my watchlist table only has mysql> show columns in wiki_watchlist; +--------------------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------------+-----------------+------+-----+---------+-------+ | wl_user | int(5) unsigned | NO | PRI | | | | wl_namespace | int(11) | NO | PRI | 0 | | | wl_title | varchar(255) | NO | PRI | | | | wl_notificationtimestamp | varchar(14) | YES | | NULL | | +--------------------------+-----------------+------+-----+---------+-------+ in other words, I don't have "wl_page".

I just confirmed that my database layout is correct for v1.9 (see http://www.mediawiki.org/wiki/Watchlist_table). So confusion still persists; which column/table are you talking about? Thanks in advance, Paul

Reply

Casey Brown

6:11 p.m.

They understand that, they just forgot the new schema. See Rob's previous e-mail (where he talks him and Andrew neeeding a slapping) where he outlines a query that should work. On 10/12/07, Paul grinberg <gri6507(a)yahoo.com> wrote:

What version of wiki is this for? I am running 1.9.3 and my watchlist

table

only has mysql> show columns in wiki_watchlist;

+--------------------------+-----------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default |

Extra |

+--------------------------+-----------------+------+-----+---------+-------+

| wl_user | int(5) unsigned | NO | PRI |

| |

| wl_namespace | int(11) | NO | PRI | 0

| |

| wl_title | varchar(255) | NO | PRI |

| |

| wl_notificationtimestamp | varchar(14) | YES | |

NULL | |

+--------------------------+-----------------+------+-----+---------+-------+

> in other words, I don't have "wl_page".

I just confirmed that my database layout is correct for v1.9 (see http://www.mediawiki.org/wiki/Watchlist_table). So confusion still persists; which column/table are you talking about? Thanks in advance, Paul _______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l

-- Casey Brown Cbrown1023 --- Note: This e-mail address is used for mailing lists. Personal emails sent to this address will probably get lost.

Reply

6079

days inactive

6081

days old

wikitech-l@lists.wikimedia.org

Manage subscription

7 comments

4 participants

tags (0)

participants (4)

Andrew Garrett
Casey Brown
Paul Grinberg
Rob Church