vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   NEED HELP...USER deleted (https://vborg.vbsupport.ru/showthread.php?t=236943)

IRANCITY 02-26-2010 02:20 PM

NEED HELP...USER deleted
 
hi dear
my user acc deleted i need to restore here user
what am i doing?
i cant restore full site info.... i just need to restore this user ,,,,, it have 10000 post
help me

borbole 02-26-2010 04:23 PM

Quote:

Originally Posted by IRANCITY (Post 1992030)
hi dear
my user acc deleted i need to restore here user
what am i doing?
i cant restore full site info.... i just need to restore this user ,,,,, it have 10000 post
help me

Have the user to register again and then you can do that with my mod. It is for vb 4 but if you remove the version from depency at the xml file it will work on vb 3X as well.

https://vborg.vbsupport.ru/showthread.php?t=236861

Or you can do it manually by doing the following.

After the user is registered again, go to the phpmyadmin in the cp of your host, select the database name that your forum resides on and at the SQL tab run the following query:

Code:

UPDATE post SET userid='newusersid' WHERE username='exusername';
And replace the uid and username accordingly.

Then as last but not least, go to: Admin CP -> Maintenance -> Update Counters and run the Rebuild Thread Information, Rebuild Forum Information, Update User Names, Update Post Counts.

Note, before you run the last option ( Update Post Counts), read the description under the title.

Hope it helps.

IRANCITY 02-26-2010 05:40 PM

tanx
i install ur product but i cant found it on admincp
my vbulletin ver is 3.8

borbole 02-26-2010 05:56 PM

You can find the mod settings at: Settings-Options-Message Posting and Editing Options.

But if you will have any more questions related to the mod I think it is best to post them at the mod''s thread better.

Let me know how it will go.

IRANCITY 02-27-2010 07:26 AM

Greats
Tank uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

Marco van Herwaarden 02-27-2010 09:51 AM

Quote:

Originally Posted by borbole (Post 1992121)
Or you can do it manually by doing the following.

After the user is registered again, go to the phpmyadmin in the cp of your host, select the database name that your forum resides on and at the SQL tab run the following query:

Code:

UPDATE post SET userid='newusersid' WHERE username='exusername';
And replace the uid and username accordingly.

Then as last but not least, go to: Admin CP -> Maintenance -> Update Counters and run the Rebuild Thread Information, Rebuild Forum Information, Update User Names, Update Post Counts.

Note, before you run the last option ( Update Post Counts), read the description under the title.

Hope it helps.

Updating posts is not enough. What about threads? PM's? etc..

The only secure way of doing this would really be to restore the database.

borbole 02-27-2010 01:54 PM

Quote:

Originally Posted by Marco van Herwaarden (Post 1992695)
Updating posts is not enough. What about threads? PM's? etc..

The only secure way of doing this would really be to restore the database.

Yes, that would update only posts as I stated above. But that is the fasted way in my opinon. Because if he would restore a previous backup, then he would loose all the other posts, topics, new members etc that were accuqired after that backup was made. At least that is how I see it. The OP can do as he sees fit :)


All times are GMT. The time now is 12:31 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01440 seconds
  • Memory Usage 1,726KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete