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
[sql]UPDATE user SET userid = 1 WHERE userid = newuserid
UPDATE userfield SET userid = 1 WHERE userid = newuserid
UPDATE usertextfield SET userid = 1 WHERE userid = newuserid[/sql]

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]

Originally Posted by ntloc

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]

Originally Posted by Xenon

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]

Originally Posted by ntloc

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 ?