Previous Thread
Next Thread
Print Thread
Rate Thread
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.

Sponsored Links
Entire Thread
Subject Posted By Posted
SQL to move threads in bulk? Myke 10/02/2003 7:05 AM
Re: SQL to move threads in bulk? JoshPet 10/02/2003 7:37 AM
Re: SQL to move threads in bulk? Myke 10/02/2003 7:44 AM
Re: SQL to move threads in bulk? Myke 10/02/2003 8:00 AM
Re: SQL to move threads in bulk? Dave_L_dup1 10/02/2003 7:01 PM
Re: SQL to move threads in bulk? JoshPet 10/02/2003 7:22 PM

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
Bill B
Bill B
Issaquah, WA
Posts: 87
Joined: December 2001
Forum Statistics
Forums63
Topics37,575
Posts293,932
Members13,824
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online 961
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 0
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,835
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)