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

Exellent! Just what I needed! Brilliant work!

Thanks N9ne:)

very nice indeed.. I will install tonight

thnx

You have released a total package, I will be suprised if this hack doesn't get a million installs :p

Count me in. Thanks N9ne.

Nice stuff, I will have to look into this hack. ;)

[high]* Velocd clicks install[/high]

Very elite hack. :)

Thanks,

Mark

Grr.. this hack comes out right after my database crashed. My backup was only half completed (timed out) XD Very nice though.

Create backup is good but other features.....hehee it's best to do it via phpmyadmin. one wrong mouse click can erase all.

True;)

Nice hack N9ne...Shame I won't be able to test it out:(

Satan

Will this work with 2.2.9?

I shouldn't see why not.

Nice work N9ne. I'll install this soon :cool:.

nice hack

Very nice idea. This is a very touchy hack so it will be interesting to see the bugs flood in ;)

- miSt

After doing the install I am getting this error when trying to log into my vB admin:

Parse error: parse error, unexpected $ in /home/virtual/site4/fst/var/www/html/madden/forums/admin/index.php on line 346

Not sure what it causing it...I didn't edit anything but what the file said...

hmm I can't create a backup with your hack.

I get the message "Backup complete.", but nothing is in the folder.

I have full SSH access and can manually create a dump via mysqldump.

what could be wrong ?

regards,
Schorsch

Could you post line 346 for us? I am guessing you have an extra $ in that line of code

[high]* Link14716 installs. :)
[/high]

Good job N9ne.

You mentioned a WINDOWS host.....will this work on a host that is powered by UNIX?

I mentioned that it might not work on a windows server. It should work on unix systems though.

AllMadden: Please post the code on and around that line.

Schorsch: What are the details of your server? What is the OS being used? Try executing this command from an SSH window on your server:

mysqldump --opt -uDBUSERNAME -pDBPASSWORD DBNAME > /path/to/backup/file.sql

Tell me if that works.

How can I make it so that I automatically have the folder I want my backups to go in remembered? I tried placing it in the code, but it didn't work... ideas?

Open maincontrol.php

Find:
Replace with:
Change the path, and it should work.

I use SuSE Linux 8.1

the mysqldump command works without problems (used this many times before).

Well I'm really no expert on SSH/telnet or servers...so I guess the problem is out of my hands, and I suppose that's a feature you won't be able to use, until I somehow figure out a way to make it work. Sorry :(.

awesome!!!!!!!!!!! I've been waiting for something like this for a long time
thx!

Any screenie? ;)

look in the zip file

hehe no problem :). I'm glad there's quite a bit of enthusiasm for this hack, version 1.1 may be on its way soon though, with some fixes.

great! many thanx!

Sorry I didn't post the line of code...I fixed that.

But I do have another question. Where does the maincontrol.php go? forums/admin/ ?

I put it there and the options didn't show up in the admin cp (unless I am just blind and don't see them.

Upload maincontrol.php to your admin directory. Make sure you've made the modifications to admin/index.php to make it show in the navigation.

nice hack! Works lovely. Tnx

great hack - absolutely perfect. thanks n9ne

tina

Please click install Tina :)

I Have it installed ok, but having problems doing a backup.

Is it the case that it will only backup to a location on the same server? Or will it backup to your local machine?

If it will only do it to the server would someone mind posting an example of a path so I know what to try.

I ain't to hot on linux :ermm:

Thanks in advance.

Brian

If you have cPanel, most likely the path will be something like:

/home/YOURACCTUSERNAME/public_html/these_are_folders_viewable_by_the_world

And you are correct in saying that they will only backup to the server. It will create a file on your server which you can then download to your local machine.

for which I should delete the Threads and Postings I don't understand

regards,
greetz subu1

Very nice hack indeed. I'm not going to use it since i like doing everything myself, but i suggest adding an option to replace

mysqldump --opt
with
mysqldump --add-drop-table --all

since some servers might have restrictions on locking tables.
EDIT: By the way, it is guaranteed not going to work on a windows server, since the sytaxes for mysqldump and mysql are different.

Any idea what the path would be for a plesk server?

Thanks

Brian