How to stop mods closing threads

[chrisrixon]

I have assigned moderators to individual forums (they are registered users not full moderators)

How can I stop them closing and sticking threads?

Thanks

[chrisrixon]

Thanks Lats.

The command i used was:

UPDATE user SET usergroupid=8,usertitle='Banned' WHERE  birthday='01-01-1980';

Did the job nicely ...

[chrisrixon]

Um theres almost 400. I only see an option to delete one at a time ......

[chrisrixon]

I have tightened up joining but the guys are already in.

SQL seems to offer a way to blow them all away with one command.

[chrisrixon]

I have 386 users with birthday 1-1-1980, probably all spammers.

I am familiar with MYSQL.

Can I nobble them with an SQL command?

eg (psuedo code)

UPDATE...

[chrisrixon]

I'm afraid the answer was:

"There are as yet no confirmed and verifiable reports of this happening."

[chrisrixon]

You already posted you have no spam. Good for you. Perhaps they haven't got you on their list.

The point is lots of boards are being spammed. I have been using vB's builtin captcha in fact....

[chrisrixon]

Ok done.

[chrisrixon]

Sadly the vbulletin staff don't seem to be very interested, see:
http://www.vbulletin.com/forum/showthread.php?p=1573643

[chrisrixon]

Did you read the quote in my post: "The remarkable thing is: there was not a single image loaded"

Also I changed to question and answer and it made no difference....

[chrisrixon]

So you're completely confident there isn't a new exploit introduced in 3.7 ?

Have you seen this post:
http://www.vbulletin.com/forum/showp...6&postcount=54
...

[chrisrixon]

>We haven't seen an increase in spam on this site. There are attempts quite often.

Well if I was a spammer and bot writer I wouldn't spam this site

>Chrisixon,...

[chrisrixon]

Is vbulletin looking into this?

Prior to 3.7 no bots. Now lots of bots. A lot of people think 3.7 is vulnerable

Quite a few posters here are fairly sure its an exploit...

[chrisrixon]

OK, done bug report.

[chrisrixon]

Turns out its a bug IMHO in 000.php

In this line

$return_array[$line_no+1]['joindate'] = substr(substr($bits[9], 1), 0, -3); 

I had to change -3 to -2
...