Mod Name / Version: Mass Threads Move for 6.3 & 6.4
Description: This modification and enclosed scripts will allow admins/moderators to move multiple threads from one forum to another . This includes unapproved posts.
Working Under: UBB.Threads 6.3 & 6.4
Mod Status: Beta
Any pre-requisites: none
Author(s): JustDave
Date: 06/14/03
Credits: JoshPet minor update to instructions for 6.3
New Files: viewmovethreads.php, doviewmovethreads.php
Database Altered: none
Info/Instructions: This is really JustDave's work - just minor tweak to the instructions for 6.3. <img src="/forum/images/graemlins/smile.gif" alt="" />
Disclaimer: Please backup every file that you intend to modify. If the modification modifies the database, it's a good idea to backup your database before doing so.
Note: If you modify your UBB.Threads code, you may be giving up your right for "official" support from Infopop.If you need official support, you'll need to restore unmodified files.
I know sometimes we're not much help..... but I guess at least if others say they know it works under 6.3 then you know to double check instructions. I've installed things and stared at them until I was blue.... only to finally find what I did wrong.
I'm having some problems running this one too. If I select two posts, I'm only seeing the first one get moved. I haven't finished looking at it, but the update seems to do the correct "OR". One thing I did find was that $oldboard was not getting set in doviewmovethreads, and only the updating for the new boards was getting run.
Okay, I found why the last thread isn't moved, here is an example:
UPDATE w3t_Posts SET B_Board = 'website' WHERE B_Main = '1569' OR B_Main = '35731' AND B_Board = '' ;
The precedence of AND and OR makes it: B_Main = '1569 OR (B_Main = '35731' AND B_Board = '') which is all except the last one. I fixed it by adding parens around the WHERE $Formatted_q in the UPDATE. Of course it doen't move posts now becasue of $oldbard not being set, so on to that...
Normal functionality in Threads is that a moderator can move posts to any forum that they can WRITE to. They don't have to be moderators in the forum they are moving TO. The move function in threads works the same way. Thus the moderator of a forum can move posts OUT of their forum to the correct forum.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.