Rev Simon Rumble wrote:
London has just had someone enter a zillion
categories:
http://london.openguides.org/index.cgi?id=Garden_Centre_At_Oriental_City%2C…
I think we need a way to limit this, otherwise you end up with a zillion
stubs floating around.
I have a radical proposal. The basis of it is "What good is a default
autocreated category or locale with no nodes?".
Since the answer is "not a lot", why don't we just delete them?
This could be run as a cron job, once a night. The SQL shouldn't be that
difficult (though the syntax for a left outer join is probably different
between each DB variant we support).
We probably need a way of tagging the content to say that this is an
autocreated node, untouched by human hands, or we could just check the
content.
We probably need to delete from node and from content, as these tables
should be kept in sync.
My £0.02 before I go to sleep.
Ivor.