Файл: adultscript-2.0.3-pro/files/install/upgrade-1.0rc1-to-1.0rc2.php
Строк: 206
<?php
define('_VALID', true);
define('_INSTALL', true);
require '../libraries/bootstrap.php';
require 'functions.php';
set_time_limit(0);
error_reporting(E_ALL);
ini_set('display_errors', 1);
if (ini_get('date.timezone') == '') {
date_default_timezone_set('Europe/Helsinki');
}
$uri = get_uri();
define('INSTALL_URL', BASE_URL.'/install');
$errors = array();
$finished = false;
$test = VF::factory('test');
$required = $test->get_required_results();
$optional = $test->get_optional_results();
$recommended = $test->get_recommended_results();
if (isset($_POST['submit-upgrade'])) {
require INSTALL_DIR.'/db.php';
$cfg = VF::cfg('core.config');
$db = new VInstall_db($cfg['db_host'], $cfg['db_name'], $cfg['db_username'], $cfg['db_password'], $cfg['db_prefix']);
if ($db->is_error()) {
$errors[] = $db->get_error();
}
if (!$errors) {
if (!$errors) {
$db->query("ALTER TABLE `#__video` ADD `view_time` int(11) unsigned NOT NULL default '0'");
$db->query("ALTER TABLE `#__video` ADD KEY `status_view_time` (`status`, `view_time`)");
$db->query("SELECT *
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = '".VF::cfg_item('db_name')."'
AND TABLE_NAME = '#__server'
AND COLUMN_NAME = 'ftp_root'");
if (!$db->affected_rows()) {
$db->query("ALTER TABLE `#__server` ADD `ftp_root` int(5) unsigned NOT NULL default '21'");
}
$db->query("DROP TABLE IF EXISTS `#__video_queue`");
$db->query("CREATE TABLE `#__video_queue` (
`start_time` int(11) unsigned NOT NULL DEFAULT '0',
KEY `start_time` (`start_time`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8");
$db->query("DROP TABLE IF EXISTS `#__video_upload`");
$db->query("CREATE TABLE `#__video_upload` (
`video_id` int(11) unsigned NOT NULL default '0',
`size` int(11) unsigned NOT NULL default '0',
`ext` varchar(4) NOT NULL default '',
PRIMARY KEY (`video_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Mobile Header', adv_group_slug = 'mobile-header', adv_group_desc = 'Mobile Header Advertising'");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Mobile Footer', adv_group_slug = 'mobile-footer', adv_group_desc = 'Mobile Footer Advertising'");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Mobile Video View', adv_group_slug = 'mobile-video-view', adv_group_desc = 'Mobile Video View Advertising'");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Mobile Photo View', adv_group_slug = 'mobile-photo-view', adv_group_desc = 'Mobile Photo View Advertising'");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Mobile Pornstar View', adv_group_slug = 'mobile-pornstar-view', adv_group_desc = 'Mobile Pornstar View Advertising'");
$db->query("INSERT INTO #__adv_groups SET adv_group_name = 'Video Category Square', adv_group_desc = 'Video Category Square Advertising', adv_group_slug = 'video-category-square'");
$finished = TRUE;
}
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html lang="en">
<head>
<title>Adult Script Pro Installation</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="<?php echo INSTALL_URL ?>/css/style.css?v1" type="text/css" media="all" />
<script type="text/javascript">
var base_url = "<?php echo BASE_URL; ?>";
</script>
</head>
<script type="text/javascript" src="<?php echo INSTALL_URL; ?>/js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
$("img[id^='help_']").click(function() {
var id = $(this).attr('id').match(/help_(.*)/)[1];
if ($("p[id='test_" + id + "']").is(':visible')) {
$("p[id='test_" + id + "']").slideUp();
} else {
$("p[id='test_" + id + "']").slideDown();
}
});
});
</script>
<body>
<div id="container">
<?php if (!$finished): ?>
<?php if ($errors): ?>
<div class="errors">
<?php foreach ($errors as $error): ?>
<span><?php echo htmlspecialchars($error),'<br />'; ?></span>
<?php endforeach; ?>
</div>
<?php endif; ?>
<div class="left width-475">
<h2>Testing Requirements</h2>
<div class="box-content">
<h3>Required Items</h3>
<?php foreach ($required as $id => $values): if (!isset($values['system'])): ?>
<span class="key"><?php if ($values['status'] !== true): echo '<strong>'; endif; ?><?php echo htmlspecialchars($values['message']); ?><?php if ($values['status'] !== true): echo '</strong>'; endif; ?></span>
<span class="value">
<?php if ($values['status'] === true): ?>
<img src="<?php echo INSTALL_URL; ?>/images/accept.png" alt="accept.png" />
<?php else: ?>
<img src="<?php echo INSTALL_URL; ?>/images/help.png" id="help_<?php echo $id; ?>" class="help" alt="help.png" />
<?php if (isset($values['warning']) && $values['warning'] == '1'): ?>
<img src="<?php echo INSTALL_URL; ?>/images/error.png" alt="error.png" />
<?php else: ?>
<img src="<?php echo INSTALL_URL; ?>/images/delete.png" alt="delete.png" />
<?php endif; endif; ?>
</span>
<div class="clear"></div>
<p id="test_<?php echo $id; ?>" style="display: none;"><?php echo htmlspecialchars($values['error']); ?></p>
<?php endif; endforeach; ?>
<h3>Required PHP Settings</h3>
<?php foreach ($recommended as $id => $values): if (!isset($values['system'])): ?>
<span class="key"><?php if ($values['status'] !== true): echo '<strong>'; endif; ?><?php echo htmlspecialchars($values['message']); ?><?php if ($values['status'] !== true): echo '</strong>'; endif; ?></span>
<span class="value">
<?php if ($values['status'] === true): ?>
<img src="<?php echo INSTALL_URL; ?>/images/accept.png" alt="accept.png" />
<?php else: ?>
<img src="<?php echo INSTALL_URL; ?>/images/help.png" id="help_<?php echo $id; ?>" class="help" alt="help.png" />
<?php if ($values['warning'] == '1'): ?>
<img src="<?php echo INSTALL_URL; ?>/images/error.png" alt="error.png" />
<?php else: ?>
<img src="<?php echo INSTALL_URL; ?>/images/delete.png" alt="delete.png" />
<?php endif; endif; ?>
</span>
<div class="clear"></div>
<p id="test_<?php echo $id; ?>" style="display: none;"><?php echo htmlspecialchars($values['error']); ?></p>
<?php endif; endforeach; ?>
<h3>Optional Items</h3>
<?php foreach ($optional as $id => $values): if (!isset($values['system'])): ?>
<span class="key"><?php if ($values['status'] !== true): echo '<strong>'; endif; ?><?php echo htmlspecialchars($values['message']); ?><?php if ($values['status'] !== true): echo '</strong>'; endif; ?></span>
<span class="value">
<?php if ($values['status'] === true): ?>
<img src="<?php echo INSTALL_URL; ?>/images/accept.png" alt="accept.png" />
<?php else: ?>
<img src="<?php echo INSTALL_URL; ?>/images/help.png" id="help_<?php echo $id; ?>" class="help" alt="help.png" />
<img src="<?php echo INSTALL_URL; ?>/images/error.png" alt="error.png" />
<?php endif; ?>
</span>
<div class="clear"></div>
<p id="test_<?php echo $id; ?>" style="display: none;"><?php echo htmlspecialchars($values['error']); ?></p>
<?php endif; endforeach; ?>
<form name="test-form" method="post" action="<?php echo BASE_URL; ?>/install/upgrade-1.0rc1-to-1.0rc2.php?a=test">
<div class="submit">
<input name="submit-test" type="submit" id="submit-test" class="submit" value="Run Tests Again" />
</div>
</form>
</div>
</div>
<div class="right width-475">
<h2>Upgrade Options</h2>
<div class="box-content">
<form id="upgrade-form" method="post" action="<?php echo BASE_URL; ?>/install/upgrade-1.0rc1-to-1.0rc2.php?a=upgrade">
<div class="submit">
<input name="submit-upgrade" type="submit" id="submit-upgrade" class="submit" value="Upgrade >"<?php if ($test->is_error() === true): echo ' disabled="1"'; endif; ?> />
</div>
</form>
</div>
</div>
<div class="clear"></div>
<?php else: ?>
<div class="box">
<h1>Congratulations! Adult Script Pro has been upgraded!</h1>
<br /><i>This upgrade contains a few important configuration changes. Please login to your site's Administration Panel
and reconfigure the scripts: forum config (you just need to save the current settings).</i><br /></ br>
Click on the 'Site' button to view your site or 'Administrator' button to configure installed upgrades!
<div class="links">
<a href="<?php echo BASE_URL; ?>">Site</a>
<a href="<?php echo ADMIN_URL; ?>/index.php">Administrator Panel</a>
</div>
<div class="install">
Please completly remove the installation directory (/install). This is a security feature!
</div>
</div>
<?php endif; ?>
</div>
</body>
</html>