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.