How do i change user my admin userID from 103 to 1 (default)

[ntloc]

Could someone show me how to change my admin userID from 103 to 1 or 0(whichever is default). Appreciate it lots.

LN

[Michael Morris]

You can't - really -

What you can do is change the password and name of account number #1 and take it over from whoever has it - but if you do that all posts made under that account will be attributed to you.

The only other way to do it is to start anew.

[ntloc]

well, the ID #1 use to be my userid but when I convert to vbulletin, i deleted it by mistake and now my userid is 103 and there's no body that has userid 1 either. And my forums right now is growing kinda big so start anew is not an posible option for me. Do you guy have anymore idea like run a query or something to change it.

[Xenon]

a dirty way:

create a new Admin user from within your acp

then with phpmyadmin or another sql surface
UPDATE user SET userid = 1 WHERE userid = newuserid
UPDATE userfield SET userid = 1 WHERE userid = newuserid
UPDATE usertextfield SET userid = 1 WHERE userid = newuserid

that way you got a new admin user with the userid 1.
after that, just use the build in user merge system to merge your already existing account into the new user with the id 1

[Zachery]

Could someone show me how to change my admin userID from 103 to 1 or 0(whichever is default). Appreciate it lots.

LN
It doesnt really matter, the userid is irrevealnt.

[KW802]

I'm curious.... why the concern about what the user ID is? Do you have hacks or something hard-coded based upon the user ID or something?

[Xenon]

it may just look better, and for fast testing purposes it's often easier to use easy rememberable userids :)

[ntloc]

it may just look better, and for fast testing purposes it's often easier to use easy rememberable userids :)

Xenon is right. Make it default make everything easier. Oh and by the way Xenon, the query doesn't work. It's giving me error.


UPDATE user SET userid = 1 WHERE userid = newuserid ;
UPDATE userfield SET userid = 1 WHERE userid = newuserid ;
UPDATE usertextfield SET userid = 1 WHERE userid = newuserid ;


LN

[Zachery]

UserID 1 is just the installers USERID this does not mean they are the default admin in all times :)

[miz]

Xenon is right. Make it default make everything easier. Oh and by the way Xenon, the query doesn't work. It's giving me error.


UPDATE user SET userid = 1 WHERE userid = newuserid ;
UPDATE userfield SET userid = 1 WHERE userid = newuserid ;
UPDATE usertextfield SET userid = 1 WHERE userid = newuserid ;


LN


did you replaced newyserid with id you want ?