On Sat, Nov 16, 2002 at 11:22:47AM +0100, Magnus Manske wrote:
No, "broken links" are links to articles that
don't exist at all, not to
"blank" articles.
Correct. I am proposing that there should be no broken links because all
articles are created, even if only blank articles. Periodically a
process could sweep blank articles with nothing linking to them from the
database. For instance,
REMOVE FROM current_articles WHERE ...
A single SQL statement could do it; Ed, can you back me up on this? The
SQL statement would do a complement of the union of article id's in the
link table and the current_articles table to find articles not linked,
and then further narrow it down to articles with NULL text properties.
Then we could drop deleted_articles as well, just set
some "cur_deleted"
tag in "current_articles".
But, you'll be the one to change every line of source code for that, I
guess...
Tonight, I got a vision dancing through my head of an Apache module,
called mod_wiki. I'm investigating it's possibilities.
Jonathan
--
Geek House Productions, Ltd.
Providing Unix & Internet Contracting and Consulting,
QA Testing, Technical Documentation, Systems Design & Implementation,
General Programming, E-commerce, Web & Mail Services since 1998
Phone: 604-435-1205
Email: djw(a)reactor-core.org
Webpage:
http://reactor-core.org
Address: 2459 E 41st Ave, Vancouver, BC V5R2W2