Wikipedia:WikiProject Interlanguage Links/Scripts: Difference between revisions

Revision as of 14:41, 20 August 2007

Latest revision as of 14:25, 26 August 2007

(One intermediate revision by the same user not shown)

Line 69:

AND a.to_lang = 'en'

AND b.from_lang IS NULL;

// Interlanguage links to pages that do not exist

// en -> fr only

INSERT INTO suggestions

SELECT a.from_lang, a.from_title, a.to_lang, a.to_title

FROM inter a

INNER JOIN en.page f

ON f.page_title = a.from_title

AND f.page_namespace = 0

AND f.page_is_redirect = 0

LEFT JOIN fr.page t

ON t.page_title = a.to_title

AND t.page_namespace = 0

WHERE a.from_lang = 'en'

AND a.to_lang = 'fr'

AND t.page_title IS NULL

// Interlanguage links to redirects

Line 98 ⟶ 115:

DECLARE sug_pos, sug_base, done INT;

DECLARE ftitle, ttitle VARCHAR(255);

DECLARE sug CURSOR FOR SELECT DISTINCT from_title, to_title FROM suggestions WHERE from_lang = flang AND to_lang = tlang;

DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET done = 1;