PHP ReadFileData Examples

Example #1

File: 2.1.0.php Project: juliogallardo1326/proc

<?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);
}

Example #2

File: admin.update.php Project: juliogallardo1326/proc

@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);