Reactivating Guests?

[Nelson58]

Is there any way at all to reactivate Guest accounts?

Someone is banned, and you decide to let them back and want to reactivate their account. Any way to do that?

Or at least merge them into a new account? (Can't do that using the merge function now).

Thanks!

Nelson

[BigAl205]

Originally Posted by Allthumbz

Is there any way at all to reactivate Guest accounts?

Someone is banned, and you decide to let them back and want to reactivate their account. Any way to do that?

Or at least merge them into a new account? (Can't do that using the merge function now).

Thanks!

Nelson

How did you ban a guest? Do you have a usergroup called "guest"? If the person was a user or waiting for confirmation, you should be able to go in and change their primary usergroup back to "Unregistered/ Not Logged In"...unless I'm missing something.

[Nelson58]

Someone is a registered user and you ban them, then they become a guest.

Later on, they rejoin- you want to reactivate them, change Guest to Registered. No Group named Guest, but all their posts are there as Guest. Any way to restore things?

Nelson
www.Hobby-Machinist.com

[Brandon Sheley]

Originally Posted by Allthumbz

Someone is a registered user is banned and deleted and you ban them, then they become a guest.

I fixed this for you.
Simply banning a user doesn't make their account a "guest"
And to answer your question, it's going to be very hard to associate those post with a new user again since the member ID is destroyed.

[Nelson58]

Their posts show

John Smith
Guest

So the system STILL has a record of their name SOMEWHERE.

Any way to restore this or even merge it if they return with a new ID?

Thanks,

Nelson

[Brandon Sheley]

Originally Posted by Allthumbz

Their posts show

John Smith
Guest

So the system STILL has a record of their name SOMEWHERE.

Any way to restore this or even merge it if they return with a new ID?

Thanks,

Nelson

Not exactly
What I'm talking about is if you click my name, you'll see my ID is 80028
Those guest post have no ID now, so there is no way to associate them to an account.
You would need to make a new account, then go into the database and assign those post to that new ID.

[Nelson58]

Originally Posted by Brandon Sheley

Not exactly
What I'm talking about is if you click my name, you'll see my ID is 80028
Those guest post have no ID now, so there is no way to associate them to an account.
You would need to make a new account, then go into the database and assign those post to that new ID.

Not exactly.
The system STILL lists them as users even though they get listed as guests because they cannot register under their old ID. Their old ID is allocated somewhere. I would love t0o tweak the database to make this ID active again if possible, and if their posts have NOT been un-attributed to them (which I suspect), then they would have them back.

I suspect that the links in the database are NEVER actually broken. All that happens is that the user is listed as a Guest. I want to tweak the database to change that.

If that cannot happen, then your way. Create a new ID and attribute their Guest posts to it as you say. How would you do that?

Right now, you CANNOT create a new account and MERGE the posts from the new account with the GUEST posts using the system post-merge or user-merge functions.

And this is what I want to do.

Thanks.
Nelson
www.Hobby-Machinist.com

[Brandon Sheley]

Alright man, do what you want then..

I've answered your question, it's not an easy thing to assocate "guest" accounts with real accounts.

more info: https://www.vbulletin.com/forum/show...d-account-name
also: https://www.google.com/search?q=asso...h+new+accounts

[Nelson58]

Anyone else have any ideas of HOW to do this?

Thanks!


Nelson
www.Hobby-Machinist.com

[Nelson58]

Will these queries restore threads and IDs of deleted users in 4.2 PL3?

If you want to do it manually, here are the queries. For the posts:

Code:
UPDATE post
SET userid = x
WHERE username = 'oldusername';
For threads:

Code:
UPDATE thread
SET postuserid = x
WHERE postusername = 'oldusername';

Replace x with the user id of the member whose posts and threads you want to reassign and oldusername with the username of the deleted user. Also if you are using a prefix for your db tables, then append it to the table names in the queries above. Hope it helps.