emergency....... need help ASAP

[wreck]

one of the admins on my forum messed me about, and i basically cant get onto admin panel.... he closed the site, and has de-adminned me or banned me im not sure..... but i cant get onto my admin cpanel.... how can i get accesse back

[Brad]

Upload the tools.php file from the vBulletin zip (its in the do_not_upload folder) to your forums root directory. Call it via your browser, you'll see this at the bottom of the page:

Reset admin access for a user

This will allow you to update your acount back to admin status, once you have done that delete the file from the server. If you leave it on there anyone can run it and become admin, or use the other utilitys in that file.

After you are back in the admin cp demote the admin in question (obviously not worthy of such power right?). To prevent this from happening again edit you config.php file at this line:

// ****** UNDELETABLE / UNALTERABLE USERS ******
// The users specified here will not be deletable or alterable from the control panel by any users.
// To specify more than one user, separate userids with commas.
$undeletableusers = '';

Key in your userid as so:


$undeletableusers = '1';

This will prevent anyone with admin access to the user section from editing/deleting your acount.

[wreck]

^^^aahhhh excellent thanks alot

[wreck]

argh shoot is that for vb2 or vb3??? im using vb2... i tried using getadmin.php but it didnt work

[Brad]

vB3, for vB2 you have to use getadmin.php.

getadmin.php should work...if you can't get it to run, run this query on your database:

UPDATE user SET usergroupid=6 WHERE userid=1

Change the number 1 in the query to match your userid.

Are you sure your acount wasn't deleted!?

If all else fails, contact offical support, they will be able to get you back in quickly.

[wreck]

it could have been then... i have no idea like i say, he has closed the forum and i cant login to admin cp so i cant find out really.... actually let me check the database and ill let you know

[LostStyles]

Thing is, we havent tried the sql query yet...but without it we get this message..


Warning: Cannot modify header information - headers already sent by (output started at /home/rapcentr/public_html/forum123/admin/getadmin.php:3) in /home/rapcentr/public_html/forum123/admin/functions.php on line 1602

do you recommend we do the sql query?

thanks.

[Brad]

If you want you can try to steal his acount, edit $password and $userid in the code below, paste in a text editor, save as 'steal_acount.php'.

Upload to your server, run, delete.

<?php

// steal acount of rouge admin
require_once('./global.php');

// Change this to the password you want the acount to use
$password = 'password';

// Change this to the userid of the acount you want to steal
$userid = '2';

// hashes password..
$password = md5($password);

// Update acount
$DB_site->query("UPDATE user SET password=$password WHERE userid=$userid");

echo('Acount should have been stolen, try to log in to the control panel with it');

?>

[Brad]

Thing is, we havent tried the sql query yet...but without it we get this message..



do you recommend we do the sql query?

thanks.
Yea go ahead and do the query, beats de-bugging the age old header error when you can just by-pass it by running the query by hand.

[wreck]

ive got it.. i run the query and it worked... thanks alot, really really appreciate it

[Brad]

ive got it.. i run the query and it worked... thanks alot, really really appreciate it
No problem, just make sure you get rid of him before it happens again, you might want to have all of your staff change their passwords aswell. :)

vB3 is alot better when it comes to the admin cp as you can restrict admins to certain area's of it and prevent them from editing other admin acounts. Good luck, hope he did'nt do anything like prune all of your posts.

[wreck]

argh he deleted alll the posts

[Brad]

You have a backup of the database right? Restore it :)

[LostStyles]

yes, we have a backup...but everytime i try to restore it...my browser seems to crash...i try through the cpanel..that i get from my host...is there any other way? or is that the only way?

thanx

[Brad]

Ah, its to big to upload in one shot, do you have telnet access?

If not use this script, it'll restore it in sections to prevent the timeout errors.

http://www.vbulletin.com/forum/attachment.php?attachmentid=8933

Make sure you configure it as so:

// THIS SCRIPT IS PROVIDED AS IS, NO RESPONSIBILITY FOR ANYTHING

// USAGE:

// 1. Adjust the database configuration in this file
// 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
// 3. Create the working directory (e.g. dump) on your web-server
// 4. Give the scripts writing permissions on the working directory (set permissions to 777 on a Linux
// based system) if you want to upload the dump files from the web-browser
// 5. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
// 6. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
// 7. BigDump will start the next import session automatically if you enable the JavaScript
// 8. Wait for the script to finish
// 9. Remove your dump files from the web-server

// If Timeout errors still occure you may need to adjust the $linepersession setting in this file

// Database configuration

$db_server="localhost";
$db_name="";
$db_username="";
$db_password="";


// Other Settings

$filename=""; // Specify the dump filename to suppress the file selection dialog
$linespersession=3000; // Lines to be executed per one import session
$delaypersession=0; // You can specify a sleep time in milliseconds after each session
// Works only if JavaScript is activated. Use to reduce server overrun

[LostStyles]

i see, so basically, what i do is change things like db_name: what it is... etc..

but the $filename=""; Is that the filename of what the database is called yes?

and where do i upload this file to to run it from?

[Brad]

Upload it to anywhere on your webserver, I recomend making a new folder for it.

Make this folder in your public_html directory:

/mysqldump/

Upload the configured bigdump.php file and your .sql backup to that folder. You'll set $filename to the name of the .sql file, for example $filename="dump.sql";

Yes you need to configure the $db vars as you did when you installed vBulletin.

[Brad]

Also I don't know why but your licensed status just changed...


LostStyles,

You are currently showing up as unlicensed. To be able to download hacks and/or receive support here at vBulletin.org, we ask you to please click here (http://www.vbulletin.com/members/membersupport_priority.php) (vB-germany users click here (http://www.vbulletin-germany.com/members/forums.php)) and enter your email address, to show us that you are licensed.

You will need to use your customer number and password (which will be in the email you got when you paid for your license) to access that page. Please note that your email is case sensitive. The update of your account may take up to one hour.

Thank you.

[wreck]

^^^yeah lol he just changed his email addresse forgetting he needs to keep that email in order to keep the licensed status

[wreck]

lol (this is loststyles) i cant find my activation code :(...and i changed my email so now i cant change it back :(:(

[wreck]

when you say a .sql file, mine is a .gz file, i made the backup through the CPanel of my host will i have to change anything in order for it to work?

[Brad]

when you say a .sql file, mine is a .gz file, i made the backup through the CPanel of my host will i have to change anything in order for it to work?
The script will support it iirc, just make sure you put in the correct file name with extention.

[wreck]

okay man, thanks a lot, hopefully this will work :) as for my loststyles account, erm...i dont know what to do about it now...lol

[Brad]

<a href="https://vborg.vbsupport.ru/register.php?do=requestemail" target="_blank">https://vborg.vbsupport.ru/regis...o=requestemail</a>