vb.org Archive - How do i change user my admin userID from 103 to 1 (default)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - How do i change user my admin userID from 103 to 1 (default) (https://vborg.vbsupport.ru/showthread.php?t=71183)

ntloc

10-30-2004 08:03 PM

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

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

10-30-2004 08:06 PM

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

10-30-2004 08:11 PM

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

10-30-2004 10:19 PM

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

10-31-2004 02:06 AM

Quote:

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

10-31-2004 02:59 AM

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

10-31-2004 11:40 AM

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

ntloc

10-31-2004 01:09 PM

Quote:

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.

Code:

UPDATE user SET userid = 1 WHERE userid = newuserid ;

UPDATE userfield SET userid = 1 WHERE userid = newuserid ;

UPDATE usertextfield SET userid = 1 WHERE userid = newuserid ;

Zachery

10-31-2004 02:23 PM

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

miz	10-31-2004 03:42 PM

Quote:

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.

Code:

UPDATE user SET userid = 1 WHERE userid = newuserid ;

UPDATE userfield SET userid = 1 WHERE userid = newuserid ;

UPDATE usertextfield SET userid = 1 WHERE userid = newuserid ;

did you replaced newyserid with id you want ?

All times are GMT. The time now is 10:00 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00984 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: