Operator: multichill ( talk)
Automatic or Manually Assisted: Automatic (supervised)
Programming Language(s): python
Function Summary: Add commonscat to categories.
Edit period(s) (e.g. Continuous, daily, one time run): First a couple of long runs to add the template, after that every once in a while
Edit rate requested: about 6 edits per minute
Already has a bot flag (Y/N): Y
Function Details: Commonscat ( Template:Commonscat ( | talk | history | links | watch | logs)) is a template to navigate from a wikipedia category/article to a related category at commons. I would like to add this template to a lot of categories. This has two advantages.
It's like an interwiki. But not between two languages, but to get from wikipedia to commons. I'm planning to do it the same way as i've done it at the nl wikipedia. I will cycle through these steps
- multichill ( talk) 14:13, 10 April 2008 (UTC) reply
Presuming that that task is okay by the community, I don't see any issues. — Werdna talk 01:22, 13 April 2008 (UTC) reply
Other templates exist for the same linking. Do you have a list to avoid duplication? If you have that in place, I would be OK with a 50-edit trial in category space. In article space, where will you put the commonscat template? What if there is no external links section? Can you point to anything showing this is desired in article space by at least one project? Gimmetrow 20:54, 14 April 2008 (UTC) reply
Categories, Gimmetrow, not articles. — Werdna talk 02:56, 15 April 2008 (UTC) reply
SELECT DISTINCT langpage.page_title AS langcat
FROM page AS langpage
JOIN commonswiki_p.page AS cpage ON langpage.page_title=cpage.page_title
WHERE langpage.page_namespace=14 AND langpage.page_is_redirect=0
AND NOT EXISTS (SELECT * FROM templatelinks WHERE tl_from=langpage.page_id AND (tl_title='Commons_cat' OR tl_title='Commonscat' OR tl_title='Commons' OR tl_title='Sisterlinks' OR tl_title='Commonscat1A' OR tl_title='Commoncats' OR tl_title='Commonscat4Ra' OR tl_title='Commonscat1' OR tl_title='Sistercommons' OR tl_title='Commonscat-inline' OR tl_title='Sisterlinkswp'))
AND NOT EXISTS (SELECT * FROM commonswiki_p.page AS cpage2 JOIN commonswiki_p.categorylinks ON cpage2.page_id=commonswiki_p.categorylinks.cl_from WHERE cpage.page_id=cpage2.page_id AND commonswiki_p.categorylinks.cl_to='Category_redirects')
AND cpage.page_namespace=14 AND cpage.page_is_redirect=0
Approved. Gimmetrow 18:47, 14 May 2008 (UTC) reply
Operator: multichill ( talk)
Automatic or Manually Assisted: Automatic (supervised)
Programming Language(s): python
Function Summary: Add commonscat to categories.
Edit period(s) (e.g. Continuous, daily, one time run): First a couple of long runs to add the template, after that every once in a while
Edit rate requested: about 6 edits per minute
Already has a bot flag (Y/N): Y
Function Details: Commonscat ( Template:Commonscat ( | talk | history | links | watch | logs)) is a template to navigate from a wikipedia category/article to a related category at commons. I would like to add this template to a lot of categories. This has two advantages.
It's like an interwiki. But not between two languages, but to get from wikipedia to commons. I'm planning to do it the same way as i've done it at the nl wikipedia. I will cycle through these steps
- multichill ( talk) 14:13, 10 April 2008 (UTC) reply
Presuming that that task is okay by the community, I don't see any issues. — Werdna talk 01:22, 13 April 2008 (UTC) reply
Other templates exist for the same linking. Do you have a list to avoid duplication? If you have that in place, I would be OK with a 50-edit trial in category space. In article space, where will you put the commonscat template? What if there is no external links section? Can you point to anything showing this is desired in article space by at least one project? Gimmetrow 20:54, 14 April 2008 (UTC) reply
Categories, Gimmetrow, not articles. — Werdna talk 02:56, 15 April 2008 (UTC) reply
SELECT DISTINCT langpage.page_title AS langcat
FROM page AS langpage
JOIN commonswiki_p.page AS cpage ON langpage.page_title=cpage.page_title
WHERE langpage.page_namespace=14 AND langpage.page_is_redirect=0
AND NOT EXISTS (SELECT * FROM templatelinks WHERE tl_from=langpage.page_id AND (tl_title='Commons_cat' OR tl_title='Commonscat' OR tl_title='Commons' OR tl_title='Sisterlinks' OR tl_title='Commonscat1A' OR tl_title='Commoncats' OR tl_title='Commonscat4Ra' OR tl_title='Commonscat1' OR tl_title='Sistercommons' OR tl_title='Commonscat-inline' OR tl_title='Sisterlinkswp'))
AND NOT EXISTS (SELECT * FROM commonswiki_p.page AS cpage2 JOIN commonswiki_p.categorylinks ON cpage2.page_id=commonswiki_p.categorylinks.cl_from WHERE cpage.page_id=cpage2.page_id AND commonswiki_p.categorylinks.cl_to='Category_redirects')
AND cpage.page_namespace=14 AND cpage.page_is_redirect=0
Approved. Gimmetrow 18:47, 14 May 2008 (UTC) reply