For clarification, you mean category pages with categories on them?
On Apr 9, 2005 4:06 PM, Richard Holton <richholton(a)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.