User talk:Merlissimo/Archives/2011

This page is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page.

Death anomalies

Hi Merlissimo, I've submitted another signpost article at Wikipedia:Wikipedia Signpost/2010-09-13/Sister projects about the death anomalies project. Hope you don't mind being named in it again, I wonder if you'd be willing to run an eye over it and maybe add a quote about DE wiki or the way the report runs - I'm guessing that millions of Bios are included in the process. Ϣere SpielChequers 16:16, 7 September 2010 (UTC)

No problem. Perhaps i add something about dewiki tomorrow. Today i added many interwikis to living people born from 1900-1945 by comparing the de and en born categories of the same year. Much work and a lot of clicks, but i added interwikis to many articles not having any interwiki link before. Merl issimo 21:44, 8 September 2010 (UTC)

I've just seen that and it sounds very useful. Would it be possible to use that sort of logic to compile a list of possible Intrawiki links?

Ϣere SpielChequers is wishing you Seasons Greetings! Whether you celebrate your hemisphere's Solstice or Xmas, Eid, Diwali, Hogmanay, Hanukkah, Lenaia, Festivus or even the Saturnalia, this is a special time of year for almost everyone!

Spread the holiday cheer by adding {{subst:User:WereSpielChequers/Dec10/Balloon}} to your friends' talk pages.

My script compares dewiki with another single wiki not on s2/s5 (for s2/s5 i have another script which is much faster and also checks redirects). There are only few incorrect result, but of course you havee to check every hit manually. Every toolserver (having local-infile enabled) user can run it, but it will run some hours. But i don't know if it useful to start at enwiki. Comparing dewiki to enwiki should be much faster as enwiki comparing to dewiki and the same with other wikis. Merl issimo 04:14, 16 December 2010 (UTC)

PeopleInterwikiFinder

#! /bin/sh
#$ -N PeopleInterwikiFinder
#$ -hard
#$ -l sqlprocs-s1=1
#$ -l sqlprocs-s5=1
FL="en"
SQL="USE u_%USER%;
 SELECT CONCAT(ns_name,':') FROM toolserver.namespace WHERE ns_id=14 AND dbname='%FL%wiki_p' INTO @fcatname;
 SELECT CONCAT(db.page_id, '|', dp.page_title, '|', SUBSTRING_INDEX(dp.page_title,'_(',1), '|', REPLACE(TRIM(LEADING @fcatname FROM dcll.ll_title),' ','_'))
  FROM dewiki_p.page dcp
   INNER JOIN dewiki_p.categorylinks dcl ON dcl.cl_to=dcp.page_title
   INNER JOIN dewiki_p.page dp ON dcl.cl_from=dp.page_id
   INNER JOIN dewiki_p.langlinks dcll ON dcp.page_id=dcll.ll_from
   LEFT JOIN dewiki_p.langlinks dpll ON dp.page_id=dpll.ll_from AND dpll.ll_lang='%FL%'
  WHERE dcp.page_title LIKE 'Geboren\_%' AND dcp.page_namespace=14 AND dp.page_namespace=0
   AND dcll.ll_lang='%FL%' AND dpll.ll_from IS NULL;
"
SQL=`echo "$SQL" | sed "s/%USER%/${USER}/g"`
SQL=`echo "$SQL" | sed "s/%FL%/${FL}/g"`
mysql -hdewiki-p.rrdb -wBN -e "$SQL" > /tmp/PeopleInterwikiFinderCrossDb.txt
SQL="USE u_%USER%;
 DROP TABLE IF EXISTS PeopleInterwikiFinderCrossDB;
 CREATE TABLE PeopleInterwikiFinderCrossDB (hid INT, htitle VARCHAR(255), htitle_norm VARCHAR(255), fcat VARCHAR(255), INDEX(htitle_norm), INDEX(fcat)) ENGINE=MyISAM;
 LOAD DATA LOCAL INFILE '/tmp/PeopleInterwikiFinderCrossDb.txt' IGNORE INTO TABLE PeopleInterwikiFinderCrossDB
  FIELDS TERMINATED BY '|' ENCLOSED BY 
  LINES TERMINATED BY '\n'; 
 OPTIMIZE TABLE PeopleInterwikiFinderCrossDB; 
 SELECT CONCAT(hid, '|', htitle, '|', pp.page_id, '|', pp.page_title, '|', fcat)
  FROM PeopleInterwikiFinderCrossDB
  INNER JOIN %FL%wiki_p.page pp ON htitle_norm=SUBSTRING_INDEX(pp.page_title,'_(',1)
  INNER JOIN %FL%wiki_p.categorylinks pcl ON pcl.cl_from=pp.page_id
  LEFT JOIN %FL%wiki_p.langlinks ppll ON pp.page_id=ppll.ll_from AND ppll.ll_lang='de'
 WHERE ppll.ll_from IS NULL
  AND pcl.cl_to=fcat;
 "
SQL=`echo "$SQL" | sed "s/%USER%/${USER}/g"`
SQL=`echo "$SQL" | sed "s/%FL%/${FL}/g"`
mysql -h${FL}wiki-p.userdb -wBN -e "$SQL" > /home/merl/PeopleInterwikiFinder.txt
rm /tmp/PeopleInterwikiFinderCrossDb.txt
SQL="USE u_%USER%;
 DROP TABLE IF EXISTS PeopleInterwikiFinder;
 CREATE TABLE PeopleInterwikiFinder (home_id INT, home_title VARCHAR(255), foreign_id INT, foreign_title VARCHAR(255), home_cat VARCHAR(255)) ENGINE=MyISAM;
 LOAD DATA LOCAL INFILE '/tmp/PeopleInterwikiFinder.txt' IGNORE INTO TABLE PeopleInterwikiFinder
  FIELDS TERMINATED BY '|' ENCLOSED BY 
  LINES TERMINATED BY '\n';
"
mysql -hdewiki-p.userdb -vvv -e "$SQL"
rm /tmp/PeopleInterwikiFinder.txt

Interwiki Removals

I just reverted two massive unjustified interwiki removals by MerlIwBot from the english wikipedia on Computer Graphics and Neon Genesis Evangelion (anime). This bot needs to be reworked or removals need to be stopped. Adam McCormick (talk) 05:48, 18 May 2011 (UTC)

The bot removed these interwiki because the are already connected to Computer graphics (computer science) and Neon Genesis Evangelion. I think the edit in Computer Graphics was correct. E.g. de:Computergrafik has its focus on the subdiscipline of computer science. Most interwikis on Neon Genesis Evangelion belong to the film, so interwikis on other wikipedias must be corrected to Neon Genesis Evangelion (anime). Merl issimo 11:03, 18 May 2011 (UTC)

MerlIwBot at Wikispecies

Just to bring your attention, your bot at Wikispecies is temporary blocked because it was removing contents that are not intended to be removed. Please see this topic and participate in its discussion.

- On behalf of Wikispecies community, OhanaUnited^{Talk page} 04:48, 15 July 2011 (UTC)

Seasons greetings

Ϣere SpielChequers is wishing you Seasons Greetings! Whether you celebrate your hemisphere's Solstice or Xmas, Eid, Diwali, Hogmanay, Hanukkah, Lenaia, Festivus or even the Saturnalia, this is a special time of year for almost everyone!

Spread the holiday cheer by adding {{subst:User:WereSpielChequers/Dec11}} to your friends' talk pages.

Hi Merlissimo, thanks for all your work on the death anomalies project! Ϣere SpielChequers 23:46, 23 December 2011 (UTC)