die("Access denied");
}
if ($_SESSION['member']['gid'] == _ACL_REMOTE_CONTENT_) {
header('Location: /adm/productadd/');
exit;
}
$Page = new Page();
$Products = new Products();
if (isset($_POST['name_index_status'])) {
require_once $GLOBALS['PATH_model'] . 'morphy.functions.php';
$count = $Products->GetCountNameIndex();
$total = 0;
foreach ($count as $value) {
$i = $value['id_product'];
$name = $Products->GetName($i);
$name_index = Words2BaseForm($name);
$Products->Morphy($i, $name_index);
$total++;
}
echo "<script>alert('Обработано записей: " . $total . ".');window.location.replace('" . $GLOBALS['URL_base'] . "adm');</script>";
}
// Пересчитать цены поставщиков по новому курсу
if (isset($_POST['kurs']) && isset($_POST['kurs_griwni'])) {
if ($Products->UpdatePriceSupplierAssortiment($_POST['kurs_griwni'])) {
echo "<script>alert('Цены пересчитаны');window.location.replace('" . $GLOBALS['URL_base'] . "adm');</script>";
} else {
echo "<script>alert('Что-то пошло не так');</script>";
}
}
if (isset($GLOBALS['REQAR'][1]) && $GLOBALS['REQAR'][1] == 'random_seo_text') {
$Seo = new Seo();
ini_set('display_errors', '1');
setlocale(LC_ALL, 'ru_RU');
require_once 'morphy.functions.php';
if (!isset($_POST['host']) || !isset($_POST['user']) || !isset($_POST['password'])) {
echo <<<HTML
<form action="update.php" method="POST" >
<input type="text" name="host" value="localhost">
<input type="text" name="user" value="root">
<input type="text" name="password" value="">
<input type="submit">
</form>
HTML;
} else {
mysql_connect($_POST['host'], $_POST['user'], $_POST['password']) or die('Database: Failed to connect. Check your credentials.');
mysql_set_charset('utf-8');
mysql_select_db('xtorg_db') or die('Failed to select database');
$min = 58000;
$qry = "SELECT MAX(id_product) FROM xt_product";
$result = mysql_fetch_array(mysql_query($qry)) or die(mysql_error());
$max = 58250;
$total = 0;
for ($i = $min; $i <= $max; $i++) {
$qry = "SELECT name FROM xt_product WHERE id_product='{$i}'";
$name = mysql_fetch_array(mysql_query($qry));
$name_index = Words2BaseForm($name[0]);
$qry = "UPDATE xt_product SET name_index='{$name_index}' WHERE id_product='{$i}'";
mysql_query($qry);
$total++;
}
echo "<br>{$total} records processed<br>";
}