The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
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?? ![]() |
#2
|
||||
|
||||
![]()
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? |
#3
|
|||
|
|||
![]()
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? |
#4
|
||||
|
||||
![]()
well, just look into phpmyadmin and look which tables have a userid field, you have to update each of these tables
![]() |
#5
|
|||
|
|||
![]()
xenon
is that right? PHP Code:
|
#6
|
||||
|
||||
![]() Quote:
|
#7
|
||||
|
||||
![]()
yes it's right
![]() that's why i said i wouldn't do it, it just takes so long to find the right tables ![]() |
#8
|
|||
|
|||
![]()
it works great
![]() by the way, any one know if vbulletin 3.0 changes will include some changes in the database tables?? |
#9
|
||||
|
||||
![]()
some?
you can expect a lot changes.... /me fears the update of some hacks ^^ |
#10
|
|||
|
|||
![]()
even i :ermm:
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|