upgrade.php

<?php

// include class.secure.php to protect this file and the whole CMS!
if (defined('WB_PATH')) {	
	include(WB_PATH.'/framework/class.secure.php'); 
} elseif (file_exists($_SERVER['DOCUMENT_ROOT'].'/framework/class.secure.php')) {
	include($_SERVER['DOCUMENT_ROOT'].'/framework/class.secure.php'); 
} else {
	$subs = explode('/', dirname($_SERVER['SCRIPT_NAME']));	$dir = $_SERVER['DOCUMENT_ROOT'];
	$inc = false;
	foreach ($subs as $sub) {
		if (empty($sub)) continue; $dir .= '/'.$sub;
		if (file_exists($dir.'/framework/class.secure.php')) { 
			include($dir.'/framework/class.secure.php'); $inc = true;	break; 
		} 
	}
	if (!$inc) trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR);
}
// end include class.secure.php


require_once(WB_PATH.'/framework/functions.php');


// see if LibraryAdmin is listed in 'addons' table
$la_installed = ($query_addons = $database->query("SELECT `version` FROM `".TABLE_PREFIX."addons` WHERE `directory` = 'libraryadmin'"));
if (!$la_installed) {
	echo "LibraryAdmin not detected.";
} else {
	$la_settings = $query_addons->fetchRow();
}

// see if jQuery Initial Library is listed in 'addons' table
if (!($query_addons = $database->query("SELECT `version` FROM `".TABLE_PREFIX."addons` WHERE `directory` = 'lib_jquery'"))) {
	echo "jQuery Initial Library not detected.";
} else {
	$lj_settings = $query_addons->fetchRow();

	if (($lj_settings['version'] >= 1.2) && $la_installed) {
		// copy *.jquery presets to /modules/lib_jquery/presets
		$src = WB_PATH.'/modules/yaig/presets';
		$dst = WB_PATH.'/modules/lib_jquery/presets';
		
		$dir = opendir($src);
		
		while(false !== ( $file = readdir($dir)) ) {
			if (( $file != '.' ) && ( $file != '..' ) && (!is_dir($src . '/' . $file))) {
				copy($src . '/' . $file, $dst . '/' . $file);
			}
		}
		closedir($dir);
	} else {
		echo "jQuery Initial Library too old and/or LibraryAdmin not installed!";
	}
}


// get module version from 'addons' table
if (!($query_addons = $database->query("SELECT `version` FROM `".TABLE_PREFIX."addons` WHERE `directory` = 'yaig'"))) {
	exit("ERROR: ".mysql_error());
}
$yaig_settings = $query_addons->fetchRow();


// UPGRADE to 0.8.4
if ($yaig_settings['version'] < '0.8.4') {
	if ($database->query("ALTER TABLE `".TABLE_PREFIX."mod_yaig_settings` ADD `random_order` TINYINT NOT NULL DEFAULT '0' AFTER `appearance`")) {
		echo "<p>Database Update successful</p>";
	} else {
		echo "ERROR: ".mysql_error();
	}
	if ($database->query("ALTER TABLE `".TABLE_PREFIX."mod_yaig_settings` ADD `nolink` TINYINT NOT NULL DEFAULT '0' AFTER `appearance`")) {
		echo "Database Update successful";
	} else {
		echo "<p>ERROR: ".mysql_error()."</p>";
	}
}

// UPGRADE to 0.8.6
if ($yaig_settings['version'] < '0.8.6') {
	if ($database->query("ALTER TABLE `".TABLE_PREFIX."mod_yaig_settings` ADD `lightbox_effect` VARCHAR(25) NOT NULL AFTER `show_filenames`")) {
		echo "<p>Database Update successful</p>";
	} else {
		echo "ERROR: ".mysql_error();
	}
}

?>