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.)
Code:
update thread set forumid = (new forumid) where threadid in (select threadid from moderatorlog where userid = 3722 and dateline > 1203261021 and dateline < 1203419415)
05-17-2008, 01:12 PM
Hybrid Mode
