imported>Topbanana at 17:46, 25 January 2010

2010-01-25T17:46:39Z

New page

{{historical}}

This page describes a subscript used in the [[User:Topbanana/Reports/Scripts/Create Link Analysis Database|creation of a link analysis database]].

You'll need to generate the whole thing yourself, it's too large to sensibly store here. 400 repeats definately catches all links as of June 2004.

----
<pre>
<nowiki>
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 2, art.art_id, s2.pos+1, locate( '<!--', art_text, start ) + 4 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 2 AND locate( '<!--', art_text, start ) > 0 AND s2.pos = 1;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 2, art.art_id, s2.pos+1, locate( '<!--', art_text, start ) + 4 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 2 AND locate( '<!--', art_text, start ) > 0 AND s2.pos = 2;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 2, art.art_id, s2.pos+1, locate( '<!--', art_text, start ) + 4 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 2 AND locate( '<!--', art_text, start ) > 0 AND s2.pos = 3;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 2, art.art_id, s2.pos+1, locate( '<!--', art_text, start ) + 4 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 2 AND locate( '<!--', art_text, start ) > 0 AND s2.pos = 4;
INSERT INTO special_text ( special_id, art_id, pos, start ) SELECT 2, art.art_id, s2.pos+1, locate( '<!--', art_text, start ) + 4 FROM special_text s2 JOIN art on s2.art_id = art.art_id WHERE s2.special_id = 2 AND locate( '<!--', art_text, start ) > 0 AND s2.pos = 5;
</nowiki>
</pre>
----
... and repeat as necessary, increasing 'pos' each time.

User:Topbanana/Reports/Scripts/extract HTML comment.sql - Revision history

imported>Topbanana at 17:46, 25 January 2010