SQL query to select threads with no prefix

[TalkPhotography]

I'm writing a small cron job to tinker with a few threads and need to select the ones with no assigned prefix, what would be the SQL argument?

Thanks

[TalkPhotography]

Yup, same here. Knows his onions and isn't afraid to get his hands dirty having a tinker under the bonnet. We've been with them glitch free since they started.

[TalkPhotography]

Well, for those searching for a similar solution, I found a way round it.

Remove ability to give reputation from everyone.
Give 10 points reputation on signup.
Give the PM ability...

[TalkPhotography]

Add my +1 to that GlobalGold recommendation
100 concurrent would suit a VPS fine IMO.

I'm sure they'll help with the vb upgrades too if required.

[TalkPhotography]

Illegal? LOL

I was just about to post in here to say it's against Google's terms etc, and if they find out will likely get you stripped from their listings.

Not sure how it's...

[TalkPhotography]

Thanks very much Steve.

I understand that with multiple usergroups a Yes overrides a No. Is there an option to switch this for one particular usergroup?

Ie create the second...

[TalkPhotography]

How do we disable the PM facility for specific users?

I understand that we can turn PM's off for Registered Users, create a second usergroup with PM facility, and add all users except this...

[TalkPhotography]

Hi Steve

Many thanks for the reply. At least I know for definite, it's not a feature (although it should be! )

Will check at vb.org

[TalkPhotography]

Hi

Forgive me if this is a very simple question and easily (or indeed already) answered, but a search doesn't prove very conclusive for me.

Our moderators are all Super Moderators,...

[TalkPhotography]

In the forum editor, what is entered next to 'Forum Link' (3rd field down)

[TalkPhotography]

Do you mean you want to reset their post count to ACTUAL posts?
IE After you've deleted/pruned some posts, you want to recount?

If so, admin panel > Maintenance > Update Counters...

[TalkPhotography]

I've only experience of one of those hosts, the one we are with now, GlobalGold.

When I was looking round I had similar experience with US hosts, as you have with UK hosts.

...

[TalkPhotography]

Same as us. We switched to GlobalGold after speaking with Tim just over a year ago, and we haven't looked back. I'd heartily recommend them

Just had a look at your forum and we're of...

[TalkPhotography]

www.globalgold.co.uk gets my vote too. They host our forum, and host it very well IMO....
Speed / reliability is always top notch....

[TalkPhotography]

Theyre spot on IMO. They host our Photography Forum for us, and we' couldn't be happier.

Any problems (which have been very very few) have been rectified quickly.

Our forum is...

[TalkPhotography]

Another vote for GlobalGold here. We're with them. Have been for nearly a year. Helpful, friendly, and damn good uptimes

www.talkphotography.co.uk
11.5k Members, 300-350 online...

[TalkPhotography]

VPS Xpress ...

[TalkPhotography]

I can fully recommend our host, GlobalGold.

We made the switch to them 9 months ago, and haven't looked back since.
Great service, good competitive pricing, and whats equally as important,...

[TalkPhotography]

Thanks very much Wayne. I don't think it warrants an official suggestion

Thanks Lynne, it looks like that plugin will serve our needs perfectly.

[TalkPhotography]

...To have the RSS feed manager post the articles as replies to a specified existing thread, instead of creating a new thread each time?

Thanks