Last modified: 2014-01-03 15:36:36 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-34. Summary: IP discussion pages on it.wiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: (none) ------------------------------------------------------------------------------- From: Incola <diegmonti@gmail.com> Date: Thu, 31 Jul 2008 10:07:25 ------------------------------------------------------------------------------- On it.wiki we need a list of the IP discussion pages, for insert a template with a bot, but there isn't a dump available. That is the query: SELECT CONCAT( "# [[Discussioni_utente:", page_title, "]]" ) FROM page LEFT JOIN revision ON page_latest = rev_id WHERE page_namespace = 3 AND page_title REGEXP '^[[:digit:]]{1,3}([.][[:digit:]]{1,3}){3}$' AND rev_timestamp < '20080701000000' AND page_id NOT IN ( SELECT cl_from FROM categorylinks WHERE cl_to = 'IP_NOTI' OR cl_to = 'Vandali_recidivi' OR cl_to = 'Open_proxy' OR cl_to = 'TOR_exit_node') AND page_id NOT IN ( SELECT tl_from FROM templatelinks WHERE tl_title = 'BenvenutoIP') ORDER BY rev_timestamp; Thank you.
------------------------------------------------------------------------------- From: Pietrodn <powerpdn@gmail.com> Date: Sat, 02 Aug 2008 14:39:33 ------------------------------------------------------------------------------- I updated the designated itwiki page: http://it.wikipedia.org/wiki/Wikipedia:Elenchi_generati_offline/Discussioni_utenti_anonimi
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: (none) CC list: powerpdn@gmail.com