Search found 341 matches

by alecrust
Tue Sep 06, 2011 11:37 am
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Hi Brf, You gave me this SQL to do that job: update phpbb_users set user_options = 230271; After running that, it set all user's "View Signatures in Posts" to "true". Now this number "32768" is cropping up (which I notice from the beginning of the topic). Does this, in fact, set user's "Enable BBCod...
by alecrust
Tue Sep 06, 2011 11:18 am
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

But making BBCode enabled by default for all members is the only setting I've wanted to change since the beginning of this topic!

Can you let me know what the value should be for this setting in includes/session.php and what SQL I should run to update all users to this setting?
by alecrust
Tue Sep 06, 2011 10:26 am
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Yes, but there also seems to be a separate option when setting your Signature, "Disable BBCode": Untitled-4.png Many of my users seem to have this option checked, despite the default "Enable BBCode" for the board being set to "true". What I'm looking for, as I've been discussing with Brf, is to set ...
by alecrust
Tue Sep 06, 2011 9:41 am
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Hmm, it seems that SQL query in fact just set "Display signatures" to "true" for all my board users.

Is it a different query for just enabling BBCode in their signatures?
by alecrust
Mon Sep 05, 2011 7:43 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

3.0.9, recently updated. It's a bit of a hack job however, been updating and modifying the same core code for years. I'm building a new version of my site in an isolated development environment using a fresh copy of 3.0.9, so this is just an interim solution until that goes live. I'm happy to say in...
by alecrust
Mon Sep 05, 2011 7:00 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Many thanks for all your help Brf, seems to be sorted now.

My default setting in that file was "1919", no idea how it got set to that!
by alecrust
Mon Sep 05, 2011 1:15 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Ah OK, that makes sense.

So I need to ensure that the default is set to 230271 for new user registrations within /includes/functions_user.php, and then run that SQL command to update all user's setting to that value.

Many thanks!
by alecrust
Sun Sep 04, 2011 4:01 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Many thanks for that information.

Is there an SQL query I can run to set the default to "true"?
by alecrust
Sun Sep 04, 2011 3:21 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Is there an option in the ACP to change this? It's causing confusion with members attempting to write BBCode in their signature box and it not working because they haven't enabled it.
by alecrust
Fri Sep 02, 2011 9:53 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Many thanks for your help. I just have one more question! Upon running that query, an abnormal amount of rows were affected (11890 to be precise). I'm starting to wonder if the default setting for "Allow BBCode in Signatures" is set to "false". I can't seem to find it in the ACP though, is this a se...
by alecrust
Fri Sep 02, 2011 9:22 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

So would the SQL query look like this? Don't want to get it wrong!

Code: Select all

update phpbb_users set user_options = user_options | 15;
by alecrust
Fri Sep 02, 2011 8:11 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Can I just confirm that user's signature box "Enable BBCode" option shares this setting?
by alecrust
Fri Sep 02, 2011 6:21 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

Re: SQL for setting "Enable BBCode" to true?

Many thanks! That worked perfectly.
by alecrust
Fri Sep 02, 2011 4:44 pm
Forum: [3.0.x] Support Forum
Topic: SQL for setting "Enable BBCode" to true?
Replies: 37
Views: 1221

SQL for setting "Enable BBCode" to true?

Hi, I was wondering what SQL command I'd need to run to set all user's accounts to "Enable BBCode" by default? Obviously there is the settings in my ACP which is set correctly, and this works for all new users. Many old members have this disabled though, and I'd like to enable it for all users in on...
by alecrust
Fri Sep 02, 2011 1:37 pm
Forum: [3.0.x] MOD Requests
Topic: Subscribe only to new topics in a forum, not to any post?
Replies: 8
Views: 556

Re: Subscribe only to new topics in a forum, not to any post

Precisely. I've opened a more explanatory MOD request here.

Go to advanced search