vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   emergency....... need help ASAP (https://vborg.vbsupport.ru/showthread.php?t=71199)

wreck 10-31-2004 10:31 AM
emergency....... need help ASAP
 
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 10-31-2004 10:50 AM
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:

Quote:
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:

PHP Code:
// ****** 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:

PHP Code:
$undeletableusers = '1'; 
This will prevent anyone with admin access to the user section from editing/deleting your acount.

wreck 10-31-2004 10:57 AM
^^^aahhhh excellent thanks alot

wreck 10-31-2004 10:59 AM
argh shoot is that for vb2 or vb3??? im using vb2... i tried using getadmin.php but it didnt work

Brad 10-31-2004 11:02 AM
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:

[sql]UPDATE user SET usergroupid=6 WHERE userid=1[/sql]

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 10-31-2004 11:04 AM
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 10-31-2004 11:05 AM
Thing is, we havent tried the sql query yet...but without it we get this message..

Quote:
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 10-31-2004 11:11 AM
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 Code:
<?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 10-31-2004 11:14 AM
Quote:
Originally Posted by LostStyles
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 10-31-2004 11:15 AM
ive got it.. i run the query and it worked... thanks alot, really really appreciate it

Brad 10-31-2004 11:18 AM
Quote:
Originally Posted by wreck
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 10-31-2004 11:28 AM
argh he deleted alll the posts

Brad 10-31-2004 11:30 AM
You have a backup of the database right? Restore it :)

LostStyles 10-31-2004 11:35 AM
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 10-31-2004 11:39 AM
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/attac...achmentid=8933

Make sure you configure it as so:

PHP Code:
// 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 10-31-2004 11:41 AM
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 10-31-2004 11:47 AM
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 10-31-2004 11:48 AM
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 (vB-germany users click here) 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 10-31-2004 11:53 AM
^^^yeah lol he just changed his email addresse forgetting he needs to keep that email in order to keep the licensed status

wreck 10-31-2004 12:04 PM
lol (this is loststyles) i cant find my activation code :(...and i changed my email so now i cant change it back :(:(

wreck 10-31-2004 12:12 PM
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 10-31-2004 12:13 PM
Quote:
Originally Posted by 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?
The script will support it iirc, just make sure you put in the correct file name with extention.

wreck 10-31-2004 12:16 PM
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 10-31-2004 12:20 PM
<a href="https://vborg.vbsupport.ru/register.php?do=requestemail" target="_blank">https://vborg.vbsupport.ru/regis...o=requestemail</a>


All times are GMT. The time now is 09:29 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.01148 seconds
  • Memory Usage 1,783KB
  • 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
  • (4)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (24)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