Jimmy Wales wrote:
Here's a table to show what I mean:
restr_user restr_article restr_num
Jimbo Wales - Oregon - 3 # Jimbo throttled on this article Jimbo Wales - Cats - 0 # Jimbo per-article banned
- DNA - 1 # everyone throttled here- Judaism - 0 # same as protectedWik - * - 3 # Wik throttled everywhere Plautus - * - 0 # Plautus banned
* - * - 0 # Mwahahahaa! ;-)
Seriously:
This smells a bit of database problems. In order to determine if someone can edit an article, you would have to:
- query this table you've suggested: SELECT restr_num FROM retrictions WHERE restr_user IN ('User Name', '*') AND restr_article IN ('Article title', '*')
- query both cur and old to see how often they have already edited it: SELECT COUNT(*) FROM cur WHERE cur_user=$userid AND cur_timestamp < $twentyfourhoursago AND cur_title='Article title' AND cur_namespace=0 SELECT COUNT(*) FROM old WHERE old_user=$userid AND old_timestamp < $twentyfourhoursago AND old_title='Article title' AND old_namespace=0
and then compare.
I'm not saying it can't be done, but I have my suspicion that this is going to slow things down even more.
Timwi