Previous Thread
Next Thread
Print Thread
Rate Thread
#259700 10/01/2003 11:05 PM
Joined: Sep 1999
Posts: 76
M
Myke Offline OP
Power User
OP Offline
Power User
M
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.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
Offline
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
M
Myke Offline OP
Power User
OP Offline
Power User
M
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
M
Myke Offline OP
Power User
OP Offline
Power User
M
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
D
Addict
Offline
Addict
D
Joined: Apr 2002
Posts: 1,768
It would be better to ask that in the thread for that mod.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
Offline
I type Like navaho
Joined: Nov 2001
Posts: 10,369
There's an older post for a 6.2 version under Archived Modifications
https://www.ubbdev.com/forum/showflat.php?Cat=0&Board=beta&Number=84985


Link Copied to Clipboard
Donate Today!
Donate via PayPal

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.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
AllenAyres
AllenAyres
Texas
Posts: 21,079
Joined: March 2000
Forum Statistics
Forums63
Topics37,552
Posts293,830
Members13,842
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online 238
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 5
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,809
Greg Hard 4,625
Top Posters(30 Days)
stell 3
Gizmo 1
Morgan 1
isaac 1
Top Likes Received
isaac 66
Gizmo 12
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2021 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Snapshot build 20201211)
Responsive Width:

PHP: 5.4.45 Page Time: 0.045s Queries: 27 (0.017s) Memory: 3.2964 MB (Peak: 3.6357 MB) Data Comp: Zlib Server Time: 2021-03-07 15:06:19 UTC
Valid HTML 5 and Valid CSS