Main Control Panel: Including SSH Backup & Restore Through Your AdminCP!

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Main Control Panel Hack, by N9ne \\ Created on March 15th 2003. \\ Copyright N9ne, 2003+.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Description: This hack will add a page to the adminCP. On this page, there are many settings.
You can set which userids can access this page and its options in config.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Options available on page:
- Overwrite database with a backup
- Create backup
- Reset post counts
- Include Administrators?
- Delete 0 posters
- Prune all threads and posts
- Prune all PMs
- Delete all smilies
- Delete all icons
- Delete all custom avatars
- Delete all avatars
- Delete all attachments
- Delete all announcements
- Delete all forums
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
You require SSH or telnet access on your server in order to run this hack. It will be running
mysql < and mysqldump > commands, so they must be installed. This may not work on all
windows systems. If you want to run this on localhost with a windows OS, you will need to add
chdir commands before mysql and mysqldump executions.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Level of hacking: Easy
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Time Taken: 1 minute.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Files to modify:
admin/index.php
admin/adminfunctions.php
admin/config.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Files to upload:
admin/maincontrol.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
In the attached .zip file you can find: A screenshot of some of the options \\ Instructions for installation \\ maincontrol.php

[Pollo]

On a Plesk server, your path to your viewable HTML docs should be:
/home/httpd/vhosts/yourdomain.com/httpdocs

You might want to create a folder below this for backup purposes, such as:
/home/httpd/vhosts/yourdomain.com/forumbackup
-and FTP in to download it to your local machine.

[SemperFidelis]

First up, great hack and thanks for all your efforts in coding it.
Its functions have worked flawlessly.


However, I posted 2 support threads :
https://vborg.vbsupport.ru/showthrea...threadid=52636
and
http://www.vbulletin.com/forum/showt...threadid=72261

And finally, I tracked the issue caused down to this hack and its changes to adminfunctions.php

Replacing this:

 // ###################### Start makeinputcode #######################
 function makeinputcode ($title,$name,$value="",$htmlise=1,$size=35) {
 // makes code for an imput box: first column contains $title
 // second column contains an input box of name, $name and value, $value. $value is "HTMLised"

	if ($htmlise) {
		$value=htmlspecialchars($value);
	}

  echo "<tr class='".getrowbg()."' valign='top'>\n<td><p>$title</p></td>\n<td><p><input type=\"text\" size=\"$size\" name=\"$name\" value=\"$value\"></p></td>\n</tr>\n";
 }

With :

 ###################### Start makeinputcode #######################
function makeinputcode ($title,$name,$value="",$htmlise=1,$size=35) {
 // makes code for an imput box: first column contains $title
 // second column contains an input box of name, $name and value, $value. $value is "HTMLised"
 if ($htmlise) {
  $value=htmlspecialchars($value);
 }
  echo "<tr class='".getrowbg()."' valign='top'>\n<td align='left' valign='middle' width='65%'><p>$title</p></td>\n<td align='right' valign='middle' width='35%'><p><input type=\"text\" size=\"$size\" name=\"$name\" value=\"$value\"></p></td>\n</tr>\n";
 }

Is anyone else experiencing this issue ?
And if so do they have a fix for it ?

[ajk]

This is very nice!

I tried the MySQL backup to reinstall.
This is the path I used:
./admin/backup/vbulletin.11.15.sql

I got a "please check maincontrol path"

Can anybody help out?

I also tried it with the full path: public_html/forums/admin/backup/vbulletin.11.15.sql
That syntax just caused a blank screen in the maincontrol.php window.

My host doesn't let me use /public_html/blah...
BTW, the file I am importing is 147MB.

Thank you!

[Red Blaze]

I guess I get the same thing as ajk.
I have a back up and I want to overwrite the current database.
I give it the fullpath to the .sql file and also gives me what ajk got. I do have the SSH active, so what else is missing?

[gmarik]

Man, if this would be on vB3 ... wow

[o0stephane0o]

Can´t you port it to vb3?

[o0stephane0o]

I guess you can?t