Dang, that's cool! I'd like to see the equivelent for Wikipedia.
It works for FireFox, if you have the new VM (v5) from Sun.
ps- your title displays as <touchgraph>.
On Apr 9, 2005 7:13 PM, FxParlant f-x.p@laposte.net wrote:
Hi,
The problem I'm facing, is that I must have in a first query, the pages with their different namespaces(0 or 14) and titles, and in a second one, the links between them.
As you all know, some links are in the "links" table, and some other are in the "categgorylinks" (or am I mistaken).
The problem is that I MUST NOT (unless I want my engine to die) have links from pages who are not mentioned in the first query. Unfortunately most of the links in "categorylinks", as mentioned by Richard, are not yet created in the cur table. Furthermore, it is also very difficult to restrict the pair of links from the "links" table, to be BOTH with namespace=0 or namespace=14.
Nevertheless here is the "result" I could manage, only with the category pages of my site.
http://www.fxparlant.net/Special:Touchgraph (there must be a mistake in the html because the applet fails in Firefox... but works in IE)...just move the first node
Thanks to Jamie and Richard, for their support ... I'm off to bed :D
See you all tomorrow François
Jamie Bliss wrote:
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.
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l