Hey,
Is it possible to change my UID to 1?
I have an admin account which is UID 1 but my UID is 6 and I'd like it to be one, is this possible?
URL -
http://theprofiters.com
~Hostpro
AdminCP > Users and Groups > Merge Users >
Goto PHPAdmin ==> select your database ==> select mybb_users table ==>
1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command
update table mybb_users set uid=1 where uid=6;
(2012-06-13, 11:57 AM)Yaldaram Wrote: [ -> ]AdminCP > Users and Groups > Merge Users >
What does merge users do exactly?
Some questions:
Do the post counts merge together?
Which username does it choose from?
What UID would it be if I merge 1 and 6?
Which password would it pick?
etc
~Hostpro
(2012-06-13, 12:46 PM)Hostpro Wrote: [ -> ] (2012-06-13, 11:57 AM)Yaldaram Wrote: [ -> ]AdminCP > Users and Groups > Merge Users >
What does merge users do exactly?
Some questions:
Do the post counts merge together?
Which username does it choose from?
What UID would it be if I merge 1 and 6?
Which password would it pick?
etc
~Hostpro
Have you tried the above procedure that i have given?
By merging the users you wouldn't lose any posts/threads made by any of the two users. However with changing the UID you'll lose many posts as well as come up with broken holes scattered around the forums.
(2012-06-13, 02:37 PM)MJ456 Wrote: [ -> ] (2012-06-13, 12:42 PM)ksr Wrote: [ -> ]Goto PHPAdmin ==> select your database ==> select mybb_users table ==>
1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command
update table mybb_users set uid=1 where uid=6;
if someone is already in user id 1 then how to exchange his user id with own?
just for example, if my user id is 8 and someone is with user id 1, if i will go to user id 1 then how to give him user id 8...meance exchange the both user ids! 
That's exactly what I'm looking for.
As I said, the best way is to "merge" these two users. By merging you wouldn't loose any data.
(2012-06-13, 12:46 PM)Hostpro Wrote: [ -> ]Do the post counts merge together?
Yes.
(2012-06-13, 12:46 PM)Hostpro Wrote: [ -> ]Which username does it choose from?
Every thing is clearly written on the merge page.
(2012-06-13, 12:46 PM)Hostpro Wrote: [ -> ]What UID would it be if I merge 1 and 6?
In your case, UID 6 is a "Source Account" and UID 1 is "Destination Account".
(2012-06-13, 12:46 PM)Hostpro Wrote: [ -> ]Which password would it pick?
After the merge the password would be the same as the password of UID 1
(2012-06-13, 03:47 PM)Hostpro Wrote: [ -> ] (2012-06-13, 02:37 PM)MJ456 Wrote: [ -> ] (2012-06-13, 12:42 PM)ksr Wrote: [ -> ]Goto PHPAdmin ==> select your database ==> select mybb_users table ==>
1)Check if there is any user with UID 1
2)If no one have UID 1, then goto your field and replace your UID with 1 by editing direcly or with the following sql command
update table mybb_users set uid=1 where uid=6;
if someone is already in user id 1 then how to exchange his user id with own?
just for example, if my user id is 8 and someone is with user id 1, if i will go to user id 1 then how to give him user id 8...meance exchange the both user ids!
That's exactly what I'm looking for.
You can temporarily assign a uid(Any uid, check the last registered user's uid and assign one without conflicting to others) for the user having uid '1' and then assaign uid '1' to your account, after that you can assaign back the uid '8' to user.
Just give a try, i am not sure about it.
DON'T FORGET TO BACKUP YOUR SQL DATABASE BEFORE DOING ANY OPERATIONS ON DATABASE.