UPDATE_SCRIPT__MOD_ARCHIVE_FOR_THREADS.php

<?php



// require 'inc/config.php';
// require 'inc/config_instance.php';
require 'inc/functions.php';


global $config;

// Check so only ADMIN can run script
check_login(true);
if (!$mod || $mod['type'] != ADMIN)
    die("You need to be logged in as admin");



// Set timelimit to what it is for rebuild
@set_time_limit($config['mod']['rebuild_timelimit']);


$page['title'] = 'Updating Database - MOD Archive for Threads';


$step = isset($_GET['step']) ? round($_GET['step']) : 0;

switch($step)
{
    default:
    case 0:
        $page['body'] = '<p style="text-align:center">You are about to update the database to allow MOD archive for threads.</p>';
        $page['body'] .= '<p style="text-align:center"><a href="?step=2">Click here to update database entries.</a></p>';
    break;
	case 2:
		$page['body'] = '<p style="text-align:center">Database have been updated.</p>';

		$sql_errors = "";
		$file_errors = "";

		// Update posts_* table to archive function
		// Get list of boards	
		$boards = listBoards();
		foreach ($boards as &$_board) {

			$query = sprintf("ALTER TABLE `archive_%s` ADD `mod_archived` INT(1) NOT NULL AFTER `featured`", $_board['uri']);
			query($query) or $sql_errors .= sprintf("<li>Updated Archive DB for %s<br/>", $_board['uri']) . db_error() . '</li>';

			$_board['dir'] = sprintf($config['board_path'], $_board['uri']);

			// Create Mod Archive threads Folders
			if (!file_exists($_board['dir'] . $config['dir']['mod_archive']))
				@mkdir($_board['dir'] . $config['dir']['mod_archive'], 0777)
					or $file_errors .= "Couldn't create " . $_board['dir'] . $config['dir']['mod_archive'] . ". Check permissions.<br/>";
			if (!file_exists($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['img']))
				@mkdir($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['img'], 0777)
					or $file_errors .= "Couldn't create " . $_board['dir'] . $config['dir']['feamod_archivetured'] . $config['dir']['img'] . ". Check permissions.<br/>";
			if (!file_exists($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['thumb']))
				@mkdir($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['thumb'], 0777)
					or $file_errors .= "Couldn't create " . $_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['thumb'] . ". Check permissions.<br/>";
			if (!file_exists($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['res']))
				@mkdir($_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['res'], 0777)
					or $file_errors .= "Couldn't create " . $_board['dir'] . $config['dir']['mod_archive'] . $config['dir']['res'] . ". Check permissions.<br/>";
		}

		if (!empty($sql_errors))
		    $page['body'] .= '<div class="ban"><h2>SQL errors</h2><p>SQL errors were encountered when trying to update the database.</p><p>The errors encountered were:</p><ul>' . $sql_errors . '</ul></div>';
		if (!empty($file_errors))
		    $page['body'] .= '<div class="ban"><h2>File System errors</h2><p>File System errors were encountered when trying to create folders.</p><p>The errors encountered were:</p><ul>' . $file_errors . '</ul></div>';

		break;
}


echo Element('page.html', $page);

?>
<!-- There is probably a much better way to do this, but eh. -->
<link rel="stylesheet" type="text/css" href="stylesheets/style.css" />