Created a custom field, having problems

[ludachris]

I created a custom field which is used as an image url. The problem is for some reason now when entering data into that field it's automatically adding [ url ] bbcode around it. It wasn't doing that before. How do I stop it from adding the bbcode?

[ludachris]

Okay, I figured out the issue, it's a setting at the Category level. Can someone tell me what query I could run to change all categories and set it to not parse links? I have hundreds of categories.

[Brian]

First, note that these settings are stored as a bitfield, so running a query to update things would affect quite a few settings, including:

Category is Open For Links
Category is Open For Posts
Allow Ratings
No Follow Links

Apply this password to child categories
Can have password

And then every setting under Link Description, Custom Fields, and Posting Options.



Assuming that it's ok for all of those settings to be the same in each category, then you could mass update them by doing the following:

First, run this query to find out what the value is for the category you have updated and have the options set as you would like:

SELECT options FROM adv_links_categories WHERE catid = X

(replace X there with the catid you want to find the settings value from).

That should return a number, which you will want to make a note of and then run this query:

UPDATE adv_links_categories SET options = Number

Replace 'Number' with the number you got from the first query and that should do the trick.