The Arcive of Official vBulletin Modifications Site.

kmfdm_kid2000 · #1 02-03-2003, 04:58 AM

Recently, someone thought it was cute to delete 2 of my more prominant users somehow using MY account in the Admin CP. I have an SQL back up from Friday, which is only 2 days old, it's pretty recent. How can I restore these 2 users using PHPMyAdmin from that back up?? I ran the querries to restore them in the User Table, but what else do I have to run? All of their posts are still set to guest, and I can't access their accounts in my Admin CP...

Any help I would REALLY appreciate. Code hacks are one thing, but when someone hacks your Admin account like that, it makes you feel kinda violated you know... :ermm:

zajako · #2 02-03-2003, 06:50 AM

Find the userfield rows that have their userid's then copy those. it should work after that.

kmfdm_kid2000 · #3 02-03-2003, 07:05 AM

Yeah, I Figured that out...What I'm going to do is add all of the new SQL from the Post Table, merge it with the old data as a new file, because the old SQL has the User ID#'s for those posts, and it'll include all of the NEW posts...This is gonna be a HUGE querry, I'll break it up into bits...

Link14716 · #4 02-03-2003, 10:36 AM

[sql]UPDATE post SET userid='newuserid' WHERE username='username';[/sql]

Just fill in the userid of one of them, the username of the same member, run it, and repeat. Then, just update the counters.

filburt1 · #5 02-03-2003, 01:54 PM

Then protect your forums by changing your password, .htaccessing your admin and mod CPs, securing phpMyAdmin, FTP, SSH, CPanel, and Telnet, and banning the hell out of the user who hacked your board while reporting him to his ISP.

kmfdm_kid2000 · #6 02-04-2003, 01:58 AM

Can you tell me how I can secure my Admin and Mod CP's with .htaccess??

Also, I have one user almost fully restored, but I'm entering the UserID into the Post table for post made by him and that have user ID# 0...

Is there a querry that i can run to say "In Post Table, make all posts with Username slamedsilver that contain User ID# 0 into User ID#16"?? It's very tedious using PHPMyAdmin to MANUALLY edit the user ID# of 500 more posts

mr e · #7 02-04-2003, 03:28 AM

cant u just do

[sql]UPDATE post SET userid='16' WHERE username='slamedsilver'[/sql]

kmfdm_kid2000 · #8 02-04-2003, 03:46 AM

Quote:

Originally posted by mr e
cant u just do

[sql]UPDATE post SET userid='16' WHERE username='slamedsilver'[/sql]

OMG, That did the trick, YOU'RE AWESOME DUDE!!!

007 · #9 02-10-2003, 12:16 PM

is there any way to see usernames in phpMyAdmin?? i have to do something like this too, but i need to make sure I don't screw something up... ive heard horror stories of entire databases just gone...

PHP Code:


			
UPDATE post SET userid='16' WHERE username='slamedsilver'

say i have userid=0 for multiple names? as far as i know these names aren't registered (it was a post only import) and somehow i heard it was possible to create these users from this somehow? anyone got any ideas? also how to you restore from a backed up database? i accidedtally clicked index on useractivationid and so far haven't noticed any problems but i dunno yet. or maybe how would i un-index this? any help would be appreciated.

Martin64 · #10 02-10-2003, 12:32 PM

Although this doesn't secure your Admin/Mod CP, I can really recommend this hack by FireFly, called "Get an e-mail if someone is trying to access your Admin CP (With IP address)"

https://vborg.vbsupport.ru/showthrea...threadid=32707

If you wish to .htaccess your directories with a password, I recommend taking a look at this site:

http://www.webmaster-toolkit.com/hta...enerator.shtml

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05060 seconds Memory Usage 2,255KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory 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 pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!