<?php $RunSql = false; RunSqlArr(PrepareQueries(ReadFileData(SELF . "/update/2.1.0/2.1.0.sql"))); $Query = "SELECT ID FROM " . PFX . "_tracker_client"; $Sql = new Query($Query); while ($Row = $Sql->Row()) { $Query = "ALTER TABLE `" . PFX . "_tracker_" . $Row->ID . "_stat_click` ADD `FRAUD` enum('0','1') NOT NULL DEFAULT '0' AFTER `SOURCE_HOST_ID`"; $Db->Query($Query); $Query = "ALTER TABLE `" . PFX . "_tracker_" . $Row->ID . "_stat_sale` ADD `ADDITIONAL` text NOT NULL AFTER `CUSTOM_ORDER_ID`"; $Db->Query($Query); $Query = "ALTER TABLE `" . PFX . "_tracker_" . $Row->ID . "_stat_click` ADD INDEX `FRAUD` (`FRAUD`)"; $Db->Query($Query); }
@closedir($D); if (count($UpdatesArr) > 0) { sort($UpdatesArr); $UpdatesAvail = count($UpdatesArr); $FirstUpdate = $UpdatesArr[0]; } $SubTitle = $Lang['UpdatesAvail'] . $UpdatesAvail; if ($Run && $FirstUpdate && !$nsUser->DEMO) { if (@file_exists(SELF . "/update/{$FirstUpdate}/{$FirstUpdate}.php")) { include_once SELF . "/update/{$FirstUpdate}/{$FirstUpdate}.php"; } else { $RunSql = true; } if ($RunSql && @file_exists(SELF . "/update/{$FirstUpdate}/{$FirstUpdate}.sql")) { $Logs->ClearError(); RunSqlArr(PrepareQueries(ReadFileData(SELF . "/update/{$FirstUpdate}/{$FirstUpdate}.sql"))); if ($Logs->HaveErr() && !$Silent) { $UseRedir = false; $UpdateVersion = false; } } if ($UpdateVersion) { $CurVersion = $FirstUpdate; $CurVersionArr = explode(".", $CurVersion); if (count($CurVersionArr) == 2) { $CurVersion = $FirstUpdate . ".0"; } else { $CurVersion = $FirstUpdate; } $Query = "UPDATE " . PFX . "_system_product SET VERSION='{$CurVersion}' WHERE ID=" . $nsProduct->ID; $Db->Query($Query);