vb.org Archive - Administrative and Maintenance Tools - Restore Posts and Threads of Deleted User. (New Version)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - Restore Posts and Threads of Deleted User. (New Version) (https://vborg.vbsupport.ru/showthread.php?t=236861)

Quote:

Originally Posted by spillage (Post 2063421)

Since the old usernames are unknown, and I want to move all guest posts to a single usermane, it would appear you're now saying this mod will not do the job.

Am I correct?

The old usernames of the deleted users can be seen under their posts they made or you can see them at the database as well. Anyway, to do what you want, to assign posts of all guests to someone, run this query at your phpmyadmin or from Maintenance->Execute SQL Query in your Acp.

Code:

UPDATE post 

        SET username = 'posterusername'

        WHERE  userid = 0;

But first make a backup of your posts table. Also, change posterusername with the actual username to whom you want to attribute the posts of all guests and if your db tables have a prefix, include it in the query as well.

Let me know if you want to do the same with threads as well.

P.s. At vb.com you asked how to get back posts of deleted users that appear as guests btw and that is exactly what this mod does. Also, before you download and use a mod, it would be best if first you had a good look at the description :)

borbole, the query you just provided is exactly what I asked for over at vB.com

If you would be so kind as to provide the thread query also, that would be appreciated.

Thanks for taking the time to help.
Regards,

Quote:

Originally Posted by spillage (Post 2063795)

For the threads use this query:

Code:

UPDATE thread 

        SET postusername = 'posterusername'

        WHERE  postuserid = 0;

At vb.com from what I could understand at your post it was that you wanted to achive what my mod does. I am sorry for the misunderstanding. Anyway, the above queries will achive what you want. Hope it helps.

Couple more questions sorry.

Say someone has deleted, does that mean all the log information for that person is also gone? I can see that someone has been deleted but going through the admin logs all I get is userid's, how do I compare the userID to name so I can figure out who deleted who?

Is their something else I could be looking for that's easier to look out for?

Quote:

Originally Posted by borbole (Post 2063800)

... I am sorry for the misunderstanding. Anyway, the above queries will achive what you want. Hope it helps.

Thank you again for your time... it is appreciated.

Quote:

Originally Posted by spillage (Post 2063920)

Thank you again for your time... it is appreciated.

No problem. You are welcome.

Loll Borbole! That was an easy one ;)

Tks mate and nominated :)

Quote:

Originally Posted by fxwoody (Post 2083794)

Loll Borbole! That was an easy one ;)

Tks mate and nominated :)

You are welcome. Glad to see that it came in handy to you :)

thanks man, this worked perfectly. much easier than messing around with the database. i just wanted to add a note to everyone though, make sure your new user doesn't have the same user name as your old deleted user or this won't work.

great work, thank you!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01160 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: