For clarification, you mean category pages with categories on them?
On Apr 9, 2005 4:06 PM, Richard Holton richholton@gmail.com wrote:
Ok. First you'll need to create the new table. Something like:
CREATE TABLE foo ( foo_from int unsigned NOT NULL default 0, foo_to int unsigned NOT NULL default 0, UNIQUE KEY foo_from (foo_from ,foo_to), KEY (foo_to) );
Then, fill in the new table from what already exists in CategoryLinks and Cur
INSERT INTO foo (foo_from, foo_to) SELECT cl_from, cur_id FROM categoryLinks, cur WHERE cur_namespace=14 AND cur_title = cl_to
This (in effect) takes each record in the categoryLinks table and finds the matching record in cur based on a match between cur_title and cl_to. If the resulting record in cur is also from namespace 14, then it takes the cl_from in categoryLinks and the cur_id from cur and writes those as a record to the new "foo" database.
Would [[:Category:Foo]] type links be included in this? (This makes a normal link to the page Category:Foo).
-- Jamie ------------------------------------------------------------------- http://endeavour.zapto.org/astro73/ Thank you to JosephM for inviting me to Gmail! Have lots of invites. Gmail now had 2GB.