![[logo.png]](/+download/logo.png){kind=logo}
Pages that are linked by noone
Would be nice to have a page (maybe /+orphan) that would list all my orphan pages.
The SQL command for that is:
SELECT title FROM titles WHERE title NOT IN (SELECT DISTINCT(target) FROM links)
Pages that are linked but not existing
Would be nice to have a page for my internal links where the page has not been created (yet). (maybe /+dead)
The SQL command for that is:
SELECT DISTINCT(target) FROM links WHERE target NOT IN (SELECT title FROM titles)
Should I run into implementation or … do you prefer to do it yourself … or maybe you'r not interested ?
Orphaned pages and wanted pages are on my todo list since several months, just – you know… If you feel like working on it, please go ahead. I hope to have some time on the weekend to either review your patch or implement it myself. I guess you'd generalize the page_index function from the search, to work on any iterable (and with any message), then use it, together with apropriate iterator generators in WikiSearch class and methods on the Wiki object to make /+orphaned and /+wanted pages (it's a little more traditional than 57005). I also want to add a separate /+index and a /+sister for the WikiSister protocol. At least that's my plan. – Radomir Dopieralski
I overestimated my available time in this Christmas period … I won't make it before next year I guess … Fell free to give it a spin.
I think my SQL command for the +wanted pages is not enough as one might like to have it sorted by wantedness though. – Ben
Implemented, now I need some tests. – Radomir Dopieralski