Titoxd@Wikimedia wrote:
If I understand that bug correctly, what users want is
interwiki links to
show up at the bottom of the sidebar, similar to what langlinks do now.
While that is a good idea, I'm not really talking about that... I'm thinking
rather just laying down the architecture, to be able to check the usage of
interwiki links. Interwikis that are never used could be pruned from the
interwiki table, for example. Also, it would help in imports, to know which
"external" pages link to a given page in a particular wiki. Even further,
that idea can be extended to keep track of all wikis that link to our wiki,
within *our* wiki.
That second idea can be accomplished using *another* table. It would look
kind of like this:
mysql> DESCRIBE mw_interwikilinksin;
+------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+-----------------+------+-----+---------+----------------+
| iwn_id | int(8) unsigned | NO | PRI | NULL | auto_increment |
| iwn_prefix | varchar(10) | NO | PRI | NULL | |
| iwn_lang | varchar(10) | NO | PRI | NULL | |
| iwn_from | int(8) unsigned | NO | | 0 | |
| iwn_title | varchar(255) | NO | PRI | NULL | |
+------------+-----------------+------+-----+---------+----------------+
5 rows in set (0.02 sec)
The method behind my madness would be as follows:
* iwn_id: unique primary key.
* iwn_prefix would be the interwiki prefix of the page in the external wiki
(let's call it page A) that is linking to a page in our wiki (page B).
* iwn_lang is the language subdomain of page A, if it exists.
* iwn_from is the title of page A, including namespaces.
* iwn_title is the title of page B. Perhaps we should use page_id, but I'm
not sure.
I guess this should read:
* iwn_title is the title of page A, without namespaces (available at
iwn_prefix).
* iwn_title is the page_id of page B. Perhaps we should use the title.
I'm just asking to try to get the ball rolling.
This seems like a relatively
useful thing, and even if the incoming interwiki links table seems like a
huge mess to implement, the projectlinks (or interwikilinks) table is IMO a
good idea.
Titoxd.
Ack, handling remote incoming links is a madness.
Simply keep out outgoing links. If we're concerned about having to process
all the wikis, make it optionally shared between all the wikis.