Move Specific Threads from Trash

[Dima]

Is it possible, maybe through an sql query, to move specific threads from one section (the 'Trash') into another section.

The scenario is alot of threads, into the hundreds, were incorrectly moved to the trash. I have manually gone through and moved 300+ threads back however thats barely made a dint in the total. I'm hoping there is some way to move threads moved by a certain user that were trashed on a certain day into another section.

Hope its not a difficult task. Otherwise my only option is manually moving them. Thanks.

[Dima]

No one? Can anyone point me in the right direction. Where in the database does it store the user that moved the thread and time/date etc?

[Lynne]

I believe the only place that information is stored is in the moderator log. The table is called "moderatorlog" and it has such columns as dateline, userid, threadid, postid, action, etc. As you have found, there is no way to mass move threads by picking all threads "moved by moderator xyz". I'm not great at writing these sort of queries, so I'm not gonna even try it.

[Dima]

Thanks a ton. Do you know how the dateline relates to a time/date? i.e. 1211033315 in dateline is 00:08, 18th May 2008 when viewed on the forum. If i find out that i may be able to work something out.

edit: Nevermind really (although it would be handy in the future to know). I have found the right query to display all those threads that were moved by the specific user between those dates. Now i just need to figure out how to move those threads back using another query.


Edit2: Alright ive figure out the queries to show the threads. Would the below command work to change which forum they belong to? (bear in mind i have limited SQL knowledge and that knowledge doesnt involve vbulletin etc.)

update thread set forumid = (new forumid) where threadid in (select threadid from moderatorlog where userid = 3722 and dateline > 1203261021 and dateline < 1203419415)

[Lynne]

Here's a page to convert your unixtimestamp (the dateline column) into a regular date: http://www.converteverything.com/con.../unix_time.htm