The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
Hi All,
I went into the admin control panel and removed a user, but kept the posts he made. In the "Thread Starter" column of the posts, his name remains linked to a now non-exsistant user ID: http://www.domain.com/forum/member.php?action=getinfo&userid=238 Is there anyway way to undo that so it is unlinked, as if he were only a guest who posted? Many thanks, Alex |
#2
|
||||
|
||||
![]()
Run this query:
Code:
UPDATE thread SET postuserid=0 WHERE postusername='hisUserName'; |
#3
|
|||
|
|||
![]()
Sounds like just what I need! Where do I run that? From the admin panel? Thanks a million, Firefly
![]() ![]() ![]() ![]() ![]() ![]() |
#4
|
|||
|
|||
![]()
Run it from phpmyadmin.
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|