27 replies to this topic

[Vince]

File Name: Change Member ID 2.2
File Submitter: Vadim88
File Submitted: 21 Oct 2006
File Category: IP.Board v2.2.x Mods

Mod Desription:

with this mod u could change member id securly and easly, just type in the current id and the new id and thats all.
the mod was coded as a component so there is no files edits required at all!!
just upload one file, import an xml file and thats all.

Files Uploaded:
sources/components_acp/changeid.php To sources/components_acp/


General Info:
1 Component Added

Click here to download this file

[Nightwisher]

Thanks a lot nice tool  !

Working great !

[Vince]

glad u liked it.

[HarryTorta]

Hello,

This is what I've been looking for but when i tried it i lost my blog and gallery.

I reversed it ok by switching back but is there a way to change the member ID and keep their blog and gallery as well?

Thanks in advance.

-Daniel

[Vince]

i will add those updates of the blog and gallery for 2.5 version for ipb 2.2.1 it will include both update the id of the blog and gallery and a few other mods like arcade, store, rpg and i will see what else.

[Yammii]

I really like this tool, I've been looking for something like this for a while.  I'm the Creator/Admin of my board but by mistake at the very beginning, I erased the first account...  So anyhow, my ID # is set to 2!  I was crazy to change this to 1!  With this tool I was able to do it, however, I lost some of my posts in the process...  In my profile, all my "FRIENDS" were gone, my personal picture was gone, among other things so I reverted back to the #2 and I got everything back...

Can this glitch be fixed?  

[kulvn]

Is it still work with IPB 2.2.2?
Every time i try to change a member id, it returns: "We could not match that ID in the members database"!

[Friction]

Ever since I installed this, all my members have 10 added to their member number. So for eg if someone registers as member number 9 it will show as number 19.

[kidofthecentury]

Thanks a lot

[salubadsha]

I really like this tool, I've been looking for something like this for a while.  I'm the Creator/Admin of my board but by mistake at the very beginning, I erased the first account...  So anyhow, my ID # is set to 2!  I was crazy to change this to 1!  With this tool I was able to do it, however, I lost some of my posts in the process...  In my profile, all my "FRIENDS" were gone, my personal picture was gone, among other things so I reverted back to the #2 and I got everything back...

Can this glitch be fixed?  

I'm assuming that when you change the member id using this mod, it only make the changes in the ibf_member tables in your database. So for all the other tables, e.g. ibf_posts you didn't change your member id for example 2 to 1. When the query pull out data from ibp_posts table and it checks whether member id =2 exists. If it does it would assign that post to whoever is the owner of that id, otherwise it will be just blank. maybe in your case the person who had id 3 before and now have user id 2 is getting all your posts and other things.

this is a troublesome process, in order to fix everything and make proper changes, you'll have to change the user ids from previous to current in all the tables. And then you'll also have to reset the auto-increment counter (user id counter) in ibf_member table by running a mySQL query, obviously manually in phpMyAdmin.

Ever since I installed this, all my members have 10 added to their member number. So for eg if someone registers as member number 9 it will show as number 19.

you need to reset the auto-increment counter (user id counter) in ibf_member table.

[Adriano Faria]

It's really important! The topics/posts/comments, etc, go to new member id ?

[Friction]

you need to reset the auto-increment counter (user id counter) in ibf_member table.

How do I do that?

[Vince]

You can reset an auto_increcment column without first emptying it.

[Friction]

But how do I reset it?

[Vince]

let me fix my sentence....

"You Can't reset an auto_increcment column without first emptying it. "

[Friction]

So you're saying that I can't reset it without first deleting all members? Could you please spell it out for me, I don't understand what you mean by "empty it".

[Vince]

you need to empty the ibf_members table from all of it's content to reset the id's count to start from 1 again.

[salubadsha]

yeh, emptying the whole table out is one way but the easiest way is to run following Query phpMyAdmin
ALTER TABLE ibf_member AUTO_INCREMENT = number  (Note: the number = the next number you want to start your new entry with)

Edited by salubadsha, 16 April 2007 - 08:45 PM.

[almac]

posted " how do i get root user 1 details changed over to new account number and i become new root user 1 without inheriting all his history. tried changing him to new member number and changed mine to user 1 in phpmyadmin but i just ended up with all his posts history under my name!"

and got the answer http://www.invisionmodding.com/index.php?showtopic=14511

but after running it it only seems to have did what i did through phpmyadmin I really want the original no 1 user to take on a new account number and retaining all his posts and history.
Similarly i asign myself number 1 transferring al my posts and history.
all my posts and history

is this not posible?

[Nightwisher]

Its great mod and works also in 2.3.1 board !

Thanks coder !