Hi. Is there a way to get caterization edits data from more than month ago? I found the last month in recentchanges SQL table, but that's all. I need to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron)
Hi,
What I would do is is use the categorylinks table [1] to extract a timestamp that can then be used to search for a particular revision. Filtering by user ID is then trivial.
Strainu
[1] https://m.mediawiki.org/wiki/Special:MyLanguage/Manual:categorylinks_table
Pe vineri, 13 iulie 2018, יגאל חיטרון khitron@post.bgu.ac.il a scris:
Hi. Is there a way to get caterization edits data from more than month ago? I found the last month in recentchanges SQL table, but that's all. I need to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron) _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Thank you very much. Unfortunately, it does not help. Most of the edits are not on pages, that were inserted into category, but on templates, and it takes time to update, so timestamps do not fit. And anywhere, if some page was added to category, and now it's not there, it would not help. Thanks again. Igal
2018-07-17 6:50 GMT+03:00 Strainu strainu10@gmail.com:
Hi,
What I would do is is use the categorylinks table [1] to extract a timestamp that can then be used to search for a particular revision. Filtering by user ID is then trivial.
Strainu
[1] https://m.mediawiki.org/wiki/Special:MyLanguage/Manual:categorylinks_table
Pe vineri, 13 iulie 2018, יגאל חיטרון khitron@post.bgu.ac.il a scris:
Hi. Is there a way to get caterization edits data from more than month
ago?
I found the last month in recentchanges SQL table, but that's all. I need to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron) _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
I would hack a Pywikibot script which goes through that user's edits, let it run and go to sleep while it works. Not a quick method, but does the job.
2018-07-17 16:39 GMT+02:00 יגאל חיטרון khitron@post.bgu.ac.il:
Thank you very much. Unfortunately, it does not help. Most of the edits are not on pages, that were inserted into category, but on templates, and it takes time to update, so timestamps do not fit. And anywhere, if some page was added to category, and now it's not there, it would not help. Thanks again. Igal
2018-07-17 6:50 GMT+03:00 Strainu strainu10@gmail.com:
Hi,
What I would do is is use the categorylinks table [1] to extract a timestamp that can then be used to search for a particular revision. Filtering by user ID is then trivial.
Strainu
categorylinks_table
Pe vineri, 13 iulie 2018, יגאל חיטרון khitron@post.bgu.ac.il a scris:
Hi. Is there a way to get caterization edits data from more than month
ago?
I found the last month in recentchanges SQL table, but that's all. I
need
to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron) _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
😱 Thank you. Igal
2018-07-17 18:07 GMT+03:00 Bináris wikiposta@gmail.com:
I would hack a Pywikibot script which goes through that user's edits, let it run and go to sleep while it works. Not a quick method, but does the job.
2018-07-17 16:39 GMT+02:00 יגאל חיטרון khitron@post.bgu.ac.il:
Thank you very much. Unfortunately, it does not help. Most of the edits are not on pages, that were inserted into category, but on templates, and it takes time to
update,
so timestamps do not fit. And anywhere, if some page was added to
category,
and now it's not there, it would not help. Thanks again. Igal
2018-07-17 6:50 GMT+03:00 Strainu strainu10@gmail.com:
Hi,
What I would do is is use the categorylinks table [1] to extract a timestamp that can then be used to search for a particular revision. Filtering by user ID is then trivial.
Strainu
categorylinks_table
Pe vineri, 13 iulie 2018, יגאל חיטרון khitron@post.bgu.ac.il a
scris:
Hi. Is there a way to get caterization edits data from more than
month
ago?
I found the last month in recentchanges SQL table, but that's all. I
need
to find pages that were added by specific user to specific category, doesn't matter when. Thank you. Igal (User:IKhitron) _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
-- Bináris _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
wikitech-l@lists.wikimedia.org