Question about 'Default Language' setting.

[moman]

When I installed vBET, I already had about 18,000 forum users, most of which have not yet set their 'default language' setting in their user CP. I don't want to require this, as it'll result in many tech noobs asking me why the system won't let them view threads.

Thus, my question is this- what MySQL query should I manually run to update all 'Not Set' values to just 'English'?

[vBET]

First of all - when user default language is not set then vBET assumes that it is same as forum default language. So you do not have to set it at all

If you still want to this is the query (NOTE: add table prefix if you use it before table name):

UPDATE user SET vbet_def_lang='en' WHERE vbet_def_lang IS NULL OR vbet_def_lang='';

[moman]

Thanks very much!