View Single Post
  #9  
Old 02-18-2008, 06:44 AM
kmike kmike is offline
 
Join Date: Oct 2002
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Also, I don't truly believe that anybody gained access to the database.
Then how did they selectively deleted the data from some tables and not the others? If they used vBulletin "delete user" feature, all user data would be gone.
You also can check some other secondary tables like 'subscribethread', 'subscribeforum', 'editlog', 'deletionlog', 'moderatorlog', if there are some records with deleted member's userid, it'll be another proof the attackers have a direct access to the database.

I also don't understand your priorities, ignoring the issue of someone messing with your database with malicious purposes is on the verge of light-mindedness. You can't even really tell if your database is still intact! They could have already altered or deleted some small things here and there. I understand that you only found that the member's posts are missing because he's a high profile member and a mod. Who knows how much more data is missing?

Quote:
If anybody has a more simple method of getting all his user information back into the database - possibly step-by-step instructions just in case I happen to get lost - I'd really appreciate that. Really, I would. Thanks!
There's no simple step-by-step instructions for your case because you don't even know what data is missing. But generally you can use my instructions above for all tables containing "userid" field - you can find them by searching mysql-schema.php in your /install/ directory. And then running "LOAD DATA INFILE '<table>.sql' IGNORE INTO <table>" for each data file (note the "IGNORE" keyword, it'll skip the rows with duplicate primary key, i.e. those that already exist in the main database).
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01957 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete