[Mod] Maintenance Page - Set from Admin Control panel

[ch€ri{Bi}²]

it work on all pages but not on the index.php

 : what happens if you make the modification on the two files? ( you can try to write the same code on index.php and page_header.php  )

[JensF]

Hi,

i have do it in both files but no effect....

[Flo2005]

When I´ll use this MOD with my backup-tool (MySqlDumper), the site should close automatically.

What SQL command I have to use to switch the site on/off  :

[TheOracle]

What SQL command I have to use to switch the site on/off

In your SQL's settings table, you can manually switch the value to the previous / next one to put your site under maintenance if you do not see it under your ACP - > Settings page.

[Flo2005]

THX I know this one.

This part should work automatic:

Before database-backup runs, the script should set maintenance page on (command before dump).
When backup is complete, the script should set maintenance page off (command after dump).

Now I search for the SQL command which I have to add to the script.

Like PphBB -> disable board

Code: [Select]

UPDATE `phpbb_config` set config_value=1 where config_name='board_disable'
Something like this...

[TheOracle]

Ah ! now I know what you're looking for to do.

Very well, create a PHP filename called : maintenance_update.php

and add this little content in :

Code: [Select]


<?php

define('GET_CACHES', 1);
define('ROOT_PATH', './');
include(ROOT_PATH.'global.php');
require(ROOT_PATH.'includes/sessions.php');
$user_access = get_permission();

if ($user_info['user_level'] == ADMIN) {

$sql = "

UPDATE ".SETTINGS_TABLE."
SET setting_value = '1'
WHERE setting_name = 'maintenance'

";

$result = $site_db->query($sql);

if ($result) {
echo "Field Updated Successfully.";
} else {
echo "Failed to update field.";
} ###### End of if statement.
} else {
show_error_page($lang['no_permission']);
} ###### End of if statement.
?>


Then, upload the PHP file to your 4images's root folder and execute the file.

Note: Make sure you login as ADMIN from your album before executing this file (for security reasons).

[TheOracle]

Update: I have just modified my post above due to a slight mistake.

[Flo2005]

I think that´s more than I need I´ll try it!

Thanks!

Edit: It works

I´ve changed the code above

To turn maintenance on

Code: [Select]

UPDATE `4images_settings` set setting_value=1 where setting_name='maintenance'
To turn maintenance off

Code: [Select]

UPDATE `4images_settings` set setting_value=0 where setting_name='maintenance'
Now, my site is during the backup under construction and after the backup it´s available.

[TheOracle]

To turn off, don't you mean :

Code: [Select]


UPDATE `4images_settings` set setting_value=0 where setting_name='maintenance'


?

[Flo2005]

  oops - You´ve got it!

I´ve corrected my post above...

[TheOracle]

Excellent. Now, it's clear. Thanks for your inputs.

[graficalicus]

works well in IE, but opens a local page in Firefox -

does anyone know why?

thanks in advance -

[scubaj]

Great MOD.  Only one potential problem.....  If I logout as admin or close the browser by mistake without turning the maintenance page back off I'm stuck!  Would be great if there was an admin login box that could be inserted on the "Closed for Maintenance" page so I can get back in. Anyone have any ideas on this?

[piyda]

Download links is not working...

Please help! I really need this mod!

Thanks!

[manurom]

Hello;
the file seems to be here: install_MainP.zip