Файл: adultscript-2.0.3-pro/files/install/upgrade-1.0beta2-to-1.0beta3.php
Строк: 273
<?php
define('_VALID', true);
define('_INSTALL', true);
require '../libraries/bootstrap.php';
require 'functions.php';
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) {
$db->load_file(BASE_DIR.'/install/sqls/asp-1.0beta2-to-asp-1.0beta3.sql');
if ($db->is_error()) {
$errors[] = $db->get_error();
}
if (!$errors) {
$cfg_file = require BASE_DIR.'/config.php';
foreach ($cfg_file as $key => $value) {
if (isset($cfg[$key])) {
unset($cfg[$key]);
}
}
VFolder::create(TMP_DIR.'/cache/language', 0777);
$cfg['language'] = 'en-US';
$db->query("UPDATE #__config
SET config = '".$db->escape(serialize($cfg))."',
config_cache = '".$db->escape(serialize($cfg))."'
WHERE name = '".$db->escape($cfg_file['default'])."'
LIMIT 1");
VF::cache_del('config', 'config');
$db->query("UPDATE #__module
SET status = '0'
WHERE name = '404'
OR name = 'offline'");
$pcfg = file_get_contents(dirname(__FILE__).'/cfgs/premium.cfg.php');
$db->query("INSERT INTO #__module
SET name = 'premium',
description = 'Frontend Premium Video Module',
type = 'extension',
version = '1.0.0',
provider = 'adultscriptpro',
config = '".$db->escape($pcfg)."',
config_cache = '".$db->escape($pcfg)."',
status = '1'");
$pcfg = file_get_contents(dirname(__FILE__).'/cfgs/payment.cfg.php');
$db->query("INSERT INTO #__module
SET name = 'payment',
description = 'Frontend Payment Module',
type = 'extension',
version = '1.0.0',
provider = 'adultscriptpro',
config = '".$db->escape($pcfg)."',
config_cache = '".$db->escape($pcfg)."',
status = '1'");
VF::cache_del('modules', 'config');
$db->query("SELECT menu_id FROM #__menu WHERE name = 'main' LIMIT 1");
if ($db->affected_rows()) {
$menu_id = (int) $db->fetch_field('menu_id');
$db->query("SELECT pos FROM #__menu_links WHERE menu_id = ".$menu_id." ORDER BY pos DESC LIMIT 1");
if ($db->affected_rows()) {
$pos = (int) $db->fetch_field('pos');
$db->query("INSERT INTO #__menu_links
SET menu_id = ".$menu_id.",
name = 'Premium',
title = 'Browse Premium Videos',
link = '/premium/',
type = 'int',
target = 'none',
current = 'premium',
pos = ".($pos+1).",
status = '1',
lang = 'premium'");
$db->query("INSERT INTO #__menu_links
SET menu_id = ".$menu_id.",
name = 'Upload',
title = 'Upload your videos!',
link = '/upload/',
type = 'int',
target = 'none',
current = 'upload',
pos = ".($pos+2).",
status = '1',
lang = 'upload'");
}
}
$langs = array(
'home' => 'home',
'categories' => 'categories',
'videos' => 'video',
'photos' => 'photo',
'community' => 'community',
'forum' => 'forum',
'pornstars' => 'pornstar',
'premium' => 'premium',
'upload' => 'upload',
'add link' => 'link',
'terms and conditions' => 'terms',
'privacy policy' => 'policy',
'DMCA' => 'DMCA',
'faq' => 'faq',
'2257' => '2257'
);
$db->query("SELECT link_id, name
FROM #__menu_links");
$links = $db->fetch_rows();
foreach ($links as $link) {
$name = strtolower($link['name']);
$lang = (isset($langs[$name])) ? $langs[$name] : 'home';
$db->query("UPDATE #__menu_links
SET lang = '".$db->escape($lang)."'
WHERE link_id = ".(int) $link['link_id']."
LIMIT 1");
}
VF::factory('cache')->remove('main_links');
VF::factory('cache')->remove('footer_links');
$db->query("SELECT video_id, title, add_date
FROM #__video");
$videos = $db->fetch_rows();
foreach ($videos as $video) {
$db->query("UPDATE #__video
SET slug = '".$db->escape(prepare_string($video['title'], TRUE))."',
add_time = ".strtotime($video['add_date'])."
WHERE video_id = ".(int) $video['video_id']."
LIMIT 1");
}
$db->query("SELECT album_id, add_date
FROM #__photo_albums");
$albums = $db->fetch_rows();
foreach ($albums as $album) {
$db->query("UPDATE #__photo_albums
SET add_time = ".strtotime($album['add_date'])."
WHERE album_id = ".(int) $album['album_id']."
LIMIT 1");
}
$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.0beta2-to-1.0beta3.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.0beta2-to-1.0beta3.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>
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>