Question Mysql question - Offset a value?

[Coume]

Hello,

** I posted this on vbulletin.com but now that I found out about this modification site, I guess here is the right place to post...

I just purchased a vbulletin licence to convert my phpbb forums to a vbulletin one.

Currently, I run 2 boards an English http://www.mythtvtalk.com/forum/ and a German http://de.mythtvtalk.com/forum/ one that share the same user databases, etc. I was pretty happy with this tweak at the time but now, it proves to be very difficult to merge them to create a single vbulletin one...

Anyway, I have a phpbb table with the following columns:

topic_id
forum_id
topic_title
topic_poster
topic_time
topic_views
topic_replies
topic_status
topic_vote
topic_type
topic_first_post_id
topic_last_post_id
topic_moved_id

Is there a way to offset the value of the topic_id field by i.e.: 386 in all records?
Therefore if a record has a topic_id = 34 after the SQL trick it should be replaced by 420.

topic_id = 34 -> 420
topic_id = 35 -> 421
...
topic_id = 5789 -> 6175
etc

Any idea on how to do that in MySQL?

Thanks
Ludo

[Dismounted]

I have no idea why you would need to do this... You can run multiple imports using ImpEx.

[Coume]

Thanks for answering.

btw, I am currently working in a test environment, I can't afford to mess up with my site and data

Strange in the email notification I can see:

UPDATE tablename
SET topic_id = topic_id + 386 Remember, backup first!

but I can't see it reading your post, did you delete this bit?

As my several thousands of de/german and www have similar post_id as they were stored in different tables, I need to offset the german ones by the amount of www ones available to avoid having the German ones overriding the www ones.

www table
post_id = 1
post_id = 2
....
post_id = 125 894
post_id = 125 895
de table
post_id = 1
post_id = 2
....
post_id = 6 704
post_id = 6 705

If I merge the two, the www's post from 1 to 6 705 would get replaced by the German ones, no?

In addition, I also need to update the forum_id as the forum_id =4 on www and on de link to different forums (i.e.: general questions in English and General questions in German), if I merge the two tables without any tweaking when importing the posts, they will all be linked to the wrong forum. So I need to create first, new forums with new IDs in the www one and then replace the old german forum_ids with this new one with something like that I guess:
"UPDATE tablename
SET forum_id = 12
WHERE forum_id = 4"

Does it make sense?

[Marco van Herwaarden]

Running ImpEx first for 1 board, finalise the import, then start with the 2nd import. This should work.

I would not suggest manipulating data unless you are absolutly sure it si the correct way to do this.

[Coume]

Erm, ok.

Let me try that now as I'm in a test environment.

[Dismounted]

Originally Posted by Coume

but I can't see it reading your post, did you delete this bit?

Yes, I did, because I figured that you were trying to do multiple imports, and this is already supported by ImpEx.

[Coume]

Ok, so I have been playing with the multiple imports and it seems to work.

I have some weird behaviour (i.e.: Some very old post from a user become posted under his name, but not linked to a new account created at a later stage by the import?) but overall it works well.

I also have the number of posts and threads that shows correctly in the stats but not the amount of users :?

Threads: 10,639, Posts: 43,173, Members: 0, Active Members: 0
Welcome to our newest member, a

[Marco van Herwaarden]

Make sure you have updated all counters as described in the ImpEx Manual after the import.