mass move closed threads

[yzztik]

In my help forum, we close threads as soon as their question is answered to cut down on spamming. I wonder if there is a way to mass move these threads to another forum based on their closed status because when you use the built in mass move feature of CB you can't tell which threads it pulls up are closed or openned or stuck any of that.

So is there a hack, or could someone be so kind as to write one, that lets you specify additional fields to base your mass move on and displays the threads accordingly when viewing the results?

So for example, when entering the parameters for the mass move search, I would like to be able to specify:
- number of days since last post
- include stuck threads toggle
- include closed threads toggle
- include openned threads toggle

Then when it displays the results for you to confirm what you want to move, it would be nice if it displayed the following info somehow about each thread:
- is it closed or open
- is it stuck
- date started
- date of last post

Thanks to anyone who can assist me or point me in the right direction

[Logician]

an SQL command can help:
[sql]
UPDATE thread SET forumid=X WHERE forumid!=X AND open=0
[/sql]
(Replace X with your forumid where your threads will be moved.)

Please Notice:
1- I havent test it out and considering the powerful effects of such a query, please apply it to your test board first or backup your board before using it! I dont accept responsibility although I believe it will work without any problems.
2- This will move ALL your closed threads into that forum, if you want to exlude some in a forum Y add " forumid!=Y AND " after "forumid!=X AND".

Considering the fact that it works, you can trigger it inside your vb files like:

PHP Code:

$DB_site->query("UPDATE thread SET forumid=X WHERE forumid!=X AND open=0
"); 


If you add this line to your vbulletin files, it will automatically run when that file is run. For example you might consider putting it in register.php and whenever a new user registers, your threads will be moved too..

[yzztik]

Thanks for your reply ...

However I am looking for something that can run on demand when I invoke it not automatically upon loading a page. Basically what I am looking for is a customized version of the mass move feature so I could specify which forum to move threads from or do all, etc.

[yzztik]

anyone at all? I could swear I had found a similar hack on here at one point but now i cannot seem to find it. Anyone know were it went or did I dream it?