|
|
Joined: Sep 1999
Posts: 76
Power User
|
Power User
Joined: Sep 1999
Posts: 76 |
I'd like to move every thread from one board to another that matches a certain string in the Subject. The SQL command would be something like:
UPDATE w3t_Posts SET B_Board = 'newboard' WHERE B_Board = 'oldboard' AND B_Subject LIKE '%string%'
But then looking at the domovethreads script I realised it's much more involved than that (need to check favorites, etc). And actually, I realised that if a post within a thread has its subject changed such that it won't match the 'string' then that post won't be moved, resulting in a broken thread.
So, I'm after any suggestions on how to go about moving threads in bulk based on some criteria?
I'm using version 6.2.3.
Cheers.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
Yeah, you can't just move things.... or you'd get strange results for sure.
You'd need a script that would cycle through all the subjects, and when it finds the string you're looking for, move all the threads to the appropriate forum.
Number of threads/posts would need to be adjusted in the w3t_Boards table as well, and as you noticed, there are some other bits (like favorites etc..) that need to be updated.
There is a mass move threads mod here - but you'd have to individually select each thread.
|
|
|
|
Joined: Sep 1999
Posts: 76
Power User
|
Power User
Joined: Sep 1999
Posts: 76 |
Thanks Josh. I'll look into that mod. Individually selecting all the threads and then hitting a fat move button is infinitely more tolerable than having to individually move one thread at a time.
|
|
|
|
Joined: Sep 1999
Posts: 76
Power User
|
Power User
Joined: Sep 1999
Posts: 76 |
Sorry to ask here, since this isn't SQL related anymore, but the mass move mod has been updated for .threads 6.3. Will there be any issues using it for 6.2.3?
|
|
|
|
Joined: Apr 2002
Posts: 1,768
Addict
|
Addict
Joined: Apr 2002
Posts: 1,768 |
It would be better to ask that in the thread for that mod.
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
|
|
|
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.
|
|
Posts: 21,079
Joined: March 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|