<?php
if( !defined( 'DATALIFEENGINE' ) ) {
header( "HTTP/1.1 403 Forbidden" );
header ( 'Location: ../../../' );
die( "Hacking attempt!" );
}
$config['version_id'] = "12.0";
$config['allow_own_meta'] = '0';
$tableSchema = array();
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_post_pass";
$tableSchema[] = "CREATE TABLE " . PREFIX . "_post_pass (
`id` INT(11) NOT NULL auto_increment,
`news_id` INT(11) NOT NULL default '0',
`password` text NOT NULL,
PRIMARY KEY (`id`),
KEY `news_id` (`news_id`)
) ENGINE=" . $storage_engine . " DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci";
$tableSchema[] = "DROP TABLE IF EXISTS " . PREFIX . "_metatags";
$tableSchema[] = "CREATE TABLE " . PREFIX . "_metatags (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(250) NOT NULL default '',
`title` varchar(200) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`keywords` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=" . $storage_engine . " DEFAULT CHARACTER SET " . COLLATE . " COLLATE " . COLLATE . "_general_ci";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_post_log` ADD `move_cat` VARCHAR(190) NOT NULL DEFAULT ''";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_usergroups` ADD `video_comments` TINYINT(1) NOT NULL DEFAULT '0' , ADD `media_comments` TINYINT(1) NOT NULL DEFAULT '0'";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_category` ADD `fulldescr` TEXT NOT NULL , ADD `disable_search` TINYINT(1) NOT NULL DEFAULT '0'";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_static` ADD `disable_search` TINYINT(1) NOT NULL DEFAULT '0' , ADD `password` TEXT NOT NULL , ADD INDEX `disable_search` (`disable_search`)";
$tableSchema[] = "ALTER TABLE `" . PREFIX . "_post_extras` ADD `disable_search` TINYINT(1) NOT NULL DEFAULT '0', ADD `need_pass` TINYINT(1) NOT NULL DEFAULT '0', ADD INDEX(`disable_search`)";
$tableSchema[] = "UPDATE " . PREFIX . "_usergroups SET `video_comments` = '1', `media_comments` = '1' WHERE id < '3'";
foreach($tableSchema as $table) {
$db->query ($table, false);
}
$handler = fopen(ENGINE_DIR.'/data/config.php', "w");
fwrite($handler, "<?PHP \n\n//System Configurations\n\n\$config = array (\n\n");
foreach($config as $name => $value)
{
fwrite($handler, "'{$name}' => \"{$value}\",\n\n");
}
fwrite($handler, ");\n\n?>");
fclose($handler);
?>