Change user id of posts in a phpBB forum

[PJSturgeon]

I have a modified phpBB forum to work with MD-Pro and i have a few weird issues. For some odd reason whenever a new user joins they take a id nu,ber that is available not one after the last, so if i delete user number 5, the next will take his place.

I'm getting round this but what i need now is a way to change every user id with a value of 3 in mdpro_phpbb_posts to have a value of 2.

I realise this will sound rather odd but I just need to know if there are any commands that can do this. If anybody wished to help can they please email me soon.

Thanks, Phil

 

[hvass]

MySQL part is simple

update mdpro_phpbb_posts
set userid=2
where userid=3;

Don't know what MDpro is
I had a quick look at phpBB when I put it in as a demo for a client - in general I was impressed - however, I would not underestimate the task of modifying it especially the data model so changing the userid in one table I would guess will corrupt the database as it is used in many different tables.

You are right this sounds like an odd request.

Play around with the user id at your peril you have been warned.

 

[PJSturgeon]

Nah. I fixed it another way, but thanks anyway.

MD-Pro is a modified form of PostNuke (a CMS system).

The problem was sorted and it seems like i forgott to copy over the CMS's users as well as the phpbb users. Doh!