Re-Associate Guest Posts???

[Ian]

Here's what happened:

I accidently deleted my posting username with my admin account so I thought nothing of it and re-created the username only one problem now... All of my old posts now show guest... I know how to manually re-do all 500 posts I had but that would take a long time... Is there a query I could put in that'd do this for me?

[Wayne Luke]

update post set postuserid=NEWUSERID where postuserid=OLDUSERID.

[Ian]

Originally posted by wluke
update post set postuserid=NEWUSERID where postuserid=OLDUSERID.

That didn't quite work...

SQL-query :
update post set postuserid=16 where postuserid=1
MySQL said:
Unknown column 'postuserid' in 'where clause'

Maybe I should make myself a little more clear... My old posts have all turned in guest posts... So in essence, I'd want to do a IF Username = Ian Than userid = 16... It'd be in a different syntax though...

[Kakarot]

Bump! We need an answer....

[Freddie Bingham]

Originally posted by Kakarot
Bump! We need an answer....

Ask at www.vbulletin.org as there is no built in support for restoring guest posts.