Just logged in as a test user and had no trouble posting twice in a matter of seconds, bypassing the flood check.

What would be the query to blank out that setting for all users? Just ending the query with... = '-1';" as opposed to = '-1';" ?

This would be for users which don't have a setting (which is none, since you ran it before):


This would be for ALL users, regardless of if it's set or not:


If you want the field to be blank, just update '-1' to ''.

Sorry, I meant to say: = '(nothing between the quotes)';" as opposed to = '-1';"

I guess I now have it set to -1 because when I ran that query again earlier for a second time it wouldn't change any rows, even though in the CP users still show up with a blank setting.

So how can I blank out the setting now? Is it safe to run a query with just '' to wipe out whatever setting I created?

Yes it'd be safe to run the query.

I'm finding on my forums that i hvae some users who are '-1' and some who are ''; i'm thinking that When created they are created with '' and when they update their profile for the first time, it's changed to '-1'... I have nothing to back this, but it makes sense why one or two "new" users are '-1' whereas 20 other new users are ''...

I'm curious what the proper setting is :glances at rick:

Well I'm curious what's going on, cause I...:

- ran the query to change the setting to "-1" for all users
- checked up on random users in the admin CP only to see that the setting was still blank for each of them
- ran the query again only to see that no rows were affected (so seemingly all were changed to -1 even though the admin CP... still showed them as blank?)
- logged in using a regular (non-admin, non-mod) account only to post two posts in 15 seconds, bypassing the admin setting of 180