Hi,
Are the values in the columns pr_id and log_id equivalent? I'm trying to select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Thanks!
Xavier Vinyals Mirabent, 12/09/2013 20:01:
Are the values in the columns pr_id and log_id equivalent? I'm trying to select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Why doesn't https://www.mediawiki.org/wiki/Manual:Page_restrictions_table#pr_page + https://www.mediawiki.org/wiki/Manual:Logging_table#log_page work?
Nemo
I'd like to merge those by edit, not by page. Also, it looks like pr_page only contains those currently protected, I'd like to have all protection status changes, which may include pages not currently protected.
2013/9/12 Federico Leva (Nemo) nemowiki@gmail.com
Xavier Vinyals Mirabent, 12/09/2013 20:01:
Are the values in the columns pr_id and log_id equivalent? I'm trying to
select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Why doesn't <https://www.mediawiki.org/**wiki/Manual:Page_restrictions_** table#pr_pagehttps://www.mediawiki.org/wiki/Manual:Page_restrictions_table#pr_page>
- <https://www.mediawiki.org/**wiki/Manual:Logging_table#log_**pagehttps://www.mediawiki.org/wiki/Manual:Logging_table#log_page>
work?
Nemo
El 12/09/13 20:01, Xavier Vinyals Mirabent escribió:
Hi,
Are the values in the columns pr_id and log_id equivalent? I'm trying to select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Thanks!
Xavi
The table logging does specify the protection applied (for recent protections, time ago it didn't). Look at log_params.
Thanks, Platonides! Do you know when did this started being applied?
2013/9/12 Platonides platonides@gmail.com
El 12/09/13 20:01, Xavier Vinyals Mirabent escribió:
Hi,
Are the values in the columns pr_id and log_id equivalent? I'm trying to select all changes in editing protection status for Wikipedia articles but the table Page_restrictions doesn't contain a time stamp, and the table logging doesn't specify the kind of protection so I'm trying to join them somehow...
Thanks!
Xavi
The table logging does specify the protection applied (for recent protections, time ago it didn't). Look at log_params.
On 13/09/13 21:56, Xavier Vinyals Mirabent wrote:
Thanks, Platonides! Do you know when did this started being applied?
A quick check suggests September 2008:
[enwiki_p]> select log_type, log_action, log_timestamp from logging_logindex where log_type='protect' and log_action ='protect' and log_params <> '' order by log_timestamp asc limit 20; +----------+------------+----------------+ | log_type | log_action | log_timestamp | +----------+------------+----------------+ | protect | protect | 20080920052314 | | protect | protect | 20080920052916 | | protect | protect | 20080920053150 | | protect | protect | 20080920053508 | | protect | protect | 20080920053722 |
...
xmldatadumps-l@lists.wikimedia.org