Delete some options in profile

[Kelinen]

Hi,

I want to delete some options in the profile (also in the registration form): Pop Up New PM, BBCode, HTML, Smilies, Language en Board Style.

Also i'd like to delete this in the reply/new topic form:
HTML is OFF
BBCode is ON
Smilies are ON
and also those options:
Disable BBCode in this post
Disable Smilies in this post

I can probably find it on my own, but whats the command in the query window to set all users options like this:

Pop up window on new Private Message: No
Always allow BBCode: Yes
Always allow HTML: No
Always enable Smilies: Yes
Board Language: Dutch
Board Style: Jasidogdotcom

edit:
After some trying:

the only thing i need to know is the command to set all the users languages on Dutch.

Thanks.

[Patrick]

Hello Kelinen,

Glad that you were able to sort a lot of that out.

What does the name of the Dutch language pack look like under in the database? For example, in my database, English looks like "english" (without the quotes). Is it "dutch"? Is it "nl"?

As an example, if it is simply "dutch" - then this should do the trick:

Code: Select all

UPDATE phpbb_users SET user_lang = "dutch"

If it's not "dutch", then you would change it to whatever the Dutch language pack looks like in the database.

I hope that this helps.

Thanks,

Patrick

[Kelinen]

Thanks, it was dutch indeed.

[Patrick]

Awesome.

Patrick