how can i change my userid??

[khaleejy]

hi

lets say that the user of id 2 is banned, so userid 2 return to null
my user id is * and i want to take 2 as my userid

in another words: how can i change my userid from * to some emtpy id??

[Xenon]

it's not as easy, because you have a lot of queries to be run:
[sql]UPDATE user SET userid=2 WHERE userid=*
UPDATE userfield SET userid=2 WHERE userid=*
UPDATE post SET userid=2 WHERE userid=*
UPDATE thread SET postuserid=2 WHERE postuserid=*
UPDATE privatemessage SET userid=2 WHERE userid=*[/sql]
think i've forgotten some have i?

[khaleejy]

thank you xenon

(think i've forgotten some have i?) well if you did then tell me what is it please.. i cant do any thing until im sure of what it will do?

[Xenon]

well, just look into phpmyadmin and look which tables have a userid field, you have to update each of these tables

[khaleejy]

xenon
is that right?

PHP Code:

UPDATE access SET userid=2 WHERE userid=*
UPDATE adminlog SET userid=2 WHERE userid=*
UPDATE announcement SET userid=2 WHERE userid=*
UPDATE attachment SET userid=2 WHERE userid=*
UPDATE calendar_events SET userid=2 WHERE userid=*
UPDATE customavatar SET userid=2 WHERE userid=*
UPDATE moderator SET userid=2 WHERE userid=*
UPDATE pollvote SET userid=2 WHERE userid=*
UPDATE post SET userid=2 WHERE userid=*
UPDATE privatemessage SET userid=2 WHERE userid=*
UPDATE privatemessage SET touserid=2 WHERE touserid=*
UPDATE privatemessage SET fromuserid=2 WHERE fromuserid=*
UPDATE search SET userid=2 WHERE userid=*
UPDATE session SET userid=2 WHERE userid=*
UPDATE subscribeforum SET userid=2 WHERE userid=*
UPDATE subscribethread SET userid=2 WHERE userid=*
UPDATE thread SET postuserid=2 WHERE postuserid=*
UPDATE threadrate SET userid=2 WHERE userid=*
UPDATE user SET userid=2 WHERE userid=*
UPDATE useractivation SET userid=2 WHERE userid=*
UPDATE userfield SET userid=2 WHERE userid=* 


[Martin64]

Originally posted by khaleejy
xenon
is that right?

PHP Code:

UPDATE access SET userid=2 WHERE userid=*
UPDATE adminlog SET userid=2 WHERE userid=*
UPDATE announcement SET userid=2 WHERE userid=*
UPDATE attachment SET userid=2 WHERE userid=*
UPDATE calendar_events SET userid=2 WHERE userid=*
UPDATE customavatar SET userid=2 WHERE userid=*
UPDATE moderator SET userid=2 WHERE userid=*
UPDATE pollvote SET userid=2 WHERE userid=*
UPDATE post SET userid=2 WHERE userid=*
UPDATE privatemessage SET userid=2 WHERE userid=*
UPDATE privatemessage SET touserid=2 WHERE touserid=*
UPDATE privatemessage SET fromuserid=2 WHERE fromuserid=*
UPDATE search SET userid=2 WHERE userid=*
UPDATE session SET userid=2 WHERE userid=*
UPDATE subscribeforum SET userid=2 WHERE userid=*
UPDATE subscribethread SET userid=2 WHERE userid=*
UPDATE thread SET postuserid=2 WHERE postuserid=*
UPDATE threadrate SET userid=2 WHERE userid=*
UPDATE user SET userid=2 WHERE userid=*
UPDATE useractivation SET userid=2 WHERE userid=*
UPDATE userfield SET userid=2 WHERE userid=* 


I'm not Xenon, but yeah, that sounds like all. :nervous:

[Xenon]

yes it's right

that's why i said i wouldn't do it, it just takes so long to find the right tables

[khaleejy]

it works great thanks to xenon and martin

by the way, any one know if vbulletin 3.0 changes will include some changes in the database tables??

[Xenon]

some?

you can expect a lot changes....

/me fears the update of some hacks ^^

[khaleejy]

even i :ermm: