Scripts
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Web Site Management > Scripts
Reload this Page

Moving treads to a difent forum in Vbulletin

Discuss Moving treads to a difent forum in Vbulletin in the Scripts forum on Dev Shed.
Moving treads to a difent forum in Vbulletin Scripts forum discussing topics including building, optimization, and implementation. Discuss which scripting language is best suited to your needs.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old January 24th, 2006, 02:40 PM
alex905 alex905 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2005
Posts: 172 alex905 User rank is Private First Class (20 - 50 Reputation Level)alex905 User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 15 h 50 m 49 sec
Reputation Power: 3
Moving treads to a difent forum
im not sure if this should go into mysql or not so it gos here

my freind has had a vbulitein forum crash and dident backup and since we were both doing the same thing and if i transfered some stuff over noone would notice i though i should help

i do have the patentce to move 500 posts from my guest section manually to his but he is hosted on my sever so i have acces to his mysql so i was wondeing if there was a way i could rip posts in bulk from one section of my froum in this case the guest section via the mysql i have looked at the mysql and have seen that the post stuff is spread over many tables so it would be kinda hard to figer out what i needed. actualy i guess im asking if anyone has ever writen a script to do this or can it be done by query.

also can i change the username all to me to save the confusion of a borad with 40 memebrs haveing posts from people that arnt signed up.

thanks
Reply With Quote
  #2  
Old January 24th, 2006, 02:47 PM
Sepodati's Avatar
Sepodati Sepodati is offline
Banned
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Dec 1999
Location: Afghanistan
Posts: 14,378 Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate Folder
Time spent in forums: 2 Months 3 Weeks 6 Days 22 h 13 m 53 sec
Reputation Power: 1784
Send a message via ICQ to Sepodati Send a message via Yahoo to Sepodati
Dude... there's a spell check button right next to the post button... use it...

---John Holmes...
Comments on this post
Thr3ddy agrees: lol true
LyonHaert agrees: I'll take punctuation over spelling, however.
Reply With Quote
  #3  
Old January 24th, 2006, 02:50 PM
Thr3ddy's Avatar
Thr3ddy Thr3ddy is offline
Harbinger of Harbingers
Dev Shed Novice (500 - 999 posts)
  
Join Date: Jan 2004
Location: Coral Springs, Florida, USA
Posts: 876 Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)  Folding Points: 43981 Folding Title: Beginner FolderFolding Points: 43981 Folding Title: Beginner FolderFolding Points: 43981 Folding Title: Beginner Folder
Time spent in forums: 1 Week 6 Days 46 m 24 sec
Reputation Power: 251
Yeah you could run an update statement on your tables. Im not familiar with vbulletin, but it should be a regular integer column.
Code:
UPDATE mytable SET forumid = "newforumid" WHERE forumid="oldforumid"
__________________
Regards,
Eddy Luten.

Information: C, C++, STL, Boost, OpenMP, Scriptionary, Google
Book of the moment: Design Patterns: Elements of Reusable Object-Oriented Software by Erich Gamma, Richard Helm, Ralph Johnson, John M. Vlissides

This post and all subsequent posts by "Thr3ddy" are licensed under the Creative Commons Attribution United States License 3.0: attribute "Eddy Luten" for any code used which was extracted from "Thr3ddy's" posts.
Reply With Quote
  #4  
Old January 24th, 2006, 03:08 PM
alex905 alex905 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2005
Posts: 172 alex905 User rank is Private First Class (20 - 50 Reputation Level)alex905 User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 15 h 50 m 49 sec
Reputation Power: 3
well that dose help but im still faced with the problem of extracting the data from about 3 different tables


and spell check man thats means i have to move my mouse a extra 3 centimeters to much for me
Reply With Quote
  #5  
Old January 24th, 2006, 03:13 PM
Sepodati's Avatar
Sepodati Sepodati is offline
Banned
Dev Shed God 19th Plane (14000 - 14499 posts)
  
Join Date: Dec 1999
Location: Afghanistan
Posts: 14,378 Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)Sepodati User rank is General 12nd Grade (Above 100000 Reputation Level)  Folding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate FolderFolding Points: 70305 Folding Title: Intermediate Folder
Time spent in forums: 2 Months 3 Weeks 6 Days 22 h 13 m 53 sec
Reputation Power: 1784
Send a message via ICQ to Sepodati Send a message via Yahoo to Sepodati
Well, others can spell check your posts by clicking here.

---John Holmes...
Reply With Quote
  #6  
Old January 24th, 2006, 03:16 PM
alex905 alex905 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2005
Posts: 172 alex905 User rank is Private First Class (20 - 50 Reputation Level)alex905 User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 15 h 50 m 49 sec
Reputation Power: 3
lol lame trick im not sure thats what you call fair play
Reply With Quote
  #7  
Old January 24th, 2006, 03:20 PM
Thr3ddy's Avatar
Thr3ddy Thr3ddy is offline
Harbinger of Harbingers
Dev Shed Novice (500 - 999 posts)
  
Join Date: Jan 2004
Location: Coral Springs, Florida, USA
Posts: 876 Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)Thr3ddy User rank is Captain (20000 - 30000 Reputation Level)  Folding Points: 43981 Folding Title: Beginner FolderFolding Points: 43981 Folding Title: Beginner FolderFolding Points: 43981 Folding Title: Beginner Folder
Time spent in forums: 1 Week 6 Days 46 m 24 sec
Reputation Power: 251
Quote:
Originally Posted by alex905
well that dose help but im still faced with the problem of extracting the data from about 3 different tables


Are there id's linking posts and whatnot you might have? Let's say:

Table A: post with id 33
Table B: post comment id is 21 backlinks to 33

?
Reply With Quote
  #8  
Old January 24th, 2006, 05:48 PM
alex905 alex905 is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Oct 2005
Posts: 172 alex905 User rank is Private First Class (20 - 50 Reputation Level)alex905 User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 1 Day 15 h 50 m 49 sec
Reputation Power: 3
do you mean user ids if so yes otherwie i havent needed to intergrate posts yet.

maybe this will make more sence when im soba maybe
Reply With Quote
  #9  
Old January 24th, 2006, 05:48 PM
SimonGreenhill's Avatar
SimonGreenhill SimonGreenhill is offline
(retired)
Dev Shed God 11th Plane (10000 - 10499 posts)
  
Join Date: Dec 2003
Location: The Laboratory
Posts: 10,101 SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)  Folding Points: 4925 Folding Title: Novice Folder
Time spent in forums: 3 Months 3 Weeks 5 h 49 m 4 sec
Reputation Power: 1331
Facebook
Thread moved. Please post in the appropriate forum next time.

--Simon
Reply With Quote
  #10  
Old January 24th, 2006, 06:31 PM
Axweildr's Avatar
Axweildr Axweildr is offline
CPAN medic ...
Click here for more information.
  
Join Date: Mar 2003
Location: Location: Location:
Posts: 11,284 Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)Axweildr User rank is General 27th Grade (Above 100000 Reputation Level)  Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1Folding Points: 122403 Folding Title: Super Ultimate Folder - Level 1
Time spent in forums: 4 Months 23 h 15 m 30 sec
Reputation Power: 2750
Send a message via Google Talk to Axweildr
Orkut
Simon, where did it come from, and why isn't it on vBulletin's boards??
__________________
--Ax
without exception, there is no rule ...
The great thing about Object Oriented code is that it can make small, simple problems look like large, complex ones


09 F9 11 02
9D 74 E3 5B
D8 41 56 C5
63 56 88 C0
Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. -- Jamie Zawinski
Detavil - the devil is in the detail, allegedly, and I use the term advisedly, allegedly ... oh, no, wait I did ...
Reply With Quote
  #11  
Old January 24th, 2006, 06:35 PM
SimonGreenhill's Avatar
SimonGreenhill SimonGreenhill is offline
(retired)
Dev Shed God 11th Plane (10000 - 10499 posts)
  
Join Date: Dec 2003
Location: The Laboratory
Posts: 10,101 SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)SimonGreenhill User rank is General 5th Grade (Above 100000 Reputation Level)  Folding Points: 4925 Folding Title: Novice Folder
Time spent in forums: 3 Months 3 Weeks 5 h 49 m 4 sec
Reputation Power: 1331
Facebook
1) It came from the Lounge (tm)
2) good question.

--Simon
Reply With Quote
Reply

Viewing: Dev Shed Forums > Web Site Management > Scripts > Moving treads to a difent forum in Vbulletin

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump