PHP Fatal函数代码示例

function execONVIF($cmd)
{
    exec(escapeshellcmd(ZM_PATH_BIN . "/zmonvif-probe.pl {$cmd}"), $output, $status);
    if ($status) {
        Fatal("Unable to probe network cameras, status is '{$status}'");
    }
    return $output;
}

/**
 * \brief get all the licenses for a single file or uploadtree
 * 
 * \param $agent_pk - agent id
 * \param $pfile_pk - pfile id, (if empty, $uploadtree_pk must be given)
 * \param $uploadtree_pk - (used only if $pfile_pk is empty)
 * \param $uploadtree_tablename
 * \param $duplicate - get duplicated licenses or not, if NULL: No, or Yes
 *
 * \return Array of file licenses   LicArray[fl_pk] = rf_shortname if $duplicate is Not NULL
 * LicArray[rf_pk] = rf_shortname if $duplicate is NULL
 * FATAL if neither pfile_pk or uploadtree_pk were passed in
 */
function GetFileLicenses($agent, $pfile_pk, $uploadtree_pk, $uploadtree_tablename = 'uploadtree', $duplicate = "")
{
    global $PG_CONN;
    if (empty($agent)) {
        Fatal("Missing parameter: agent", __FILE__, __LINE__);
    }
    if ($uploadtree_pk) {
        /* Find lft and rgt bounds for this $uploadtree_pk  */
        $sql = "SELECT lft, rgt, upload_fk FROM {$uploadtree_tablename}\n                   WHERE uploadtree_pk = {$uploadtree_pk}";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
        $row = pg_fetch_assoc($result);
        $lft = $row["lft"];
        $rgt = $row["rgt"];
        $upload_pk = $row["upload_fk"];
        pg_free_result($result);
        $agentIdCondition = $agent != "any" ? "and agent_fk={$agent}" : "";
        /* Strip out added upload_pk condition if it isn't needed */
        if ($uploadtree_tablename == "uploadtree_a" or $uploadtree_tablename == "uploadtree") {
            $UploadClause = "upload_fk={$upload_pk} and ";
        } else {
            $UploadClause = "";
        }
        /*  Get the licenses under this $uploadtree_pk*/
        $sql = "SELECT distinct(rf_shortname) as rf_shortname, rf_pk as rf_fk, fl_pk\n              from license_file_ref,\n                  (SELECT distinct(pfile_fk) as PF from {$uploadtree_tablename} \n                     where {$UploadClause} lft BETWEEN {$lft} and {$rgt}) as SS\n              where PF=pfile_fk {$agentIdCondition}\n              order by rf_shortname asc";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
    } else {
        Fatal("Missing function inputs", __FILE__, __LINE__);
    }
    $LicArray = array();
    if ($duplicate) {
        while ($row = pg_fetch_assoc($result)) {
            $LicArray[$row['fl_pk']] = $row['rf_shortname'];
        }
    } else {
        // do not return duplicated licenses
        while ($row = pg_fetch_assoc($result)) {
            $LicArray[$row['rf_fk']] = $row['rf_shortname'];
        }
    }
    pg_free_result($result);
    return $LicArray;
}

/**
 * \brief get all the copyright for a single file or uploadtree
 * 
 * \param $agent_pk - agent id
 * \param $pfile_pk - pfile id, (if empty, $uploadtree_pk must be given)
 * \param $uploadtree_pk - (used only if $pfile_pk is empty)
 * \param $type - copyright statement/url/email
 * 
 * \return Array of file copyright CopyrightArray[ct_pk] = copyright.content
 * FATAL if neither pfile_pk or uploadtree_pk were passed in
 */
function GetFileCopyrights($agent_pk, $pfile_pk, $uploadtree_pk, $type)
{
    global $PG_CONN;
    if (empty($agent_pk)) {
        Fatal("Missing parameter: agent_pk", __FILE__, __LINE__);
    }
    // if $pfile_pk, then return the copyright for that one file
    if ($pfile_pk) {
        $sql = "SELECT ct_pk, content \n              from copyright\n              where pfile_fk='{$pfile_pk}' and agent_fk={$agent_pk};";
        $result = pg_query($PG_CONN, $sql);
        DBCheckResult($result, $sql, __FILE__, __LINE__);
    } else {
        if ($uploadtree_pk) {
            // Find lft and rgt bounds for this $uploadtree_pk
            $sql = "SELECT lft, rgt, upload_fk FROM uploadtree\n                   WHERE uploadtree_pk = {$uploadtree_pk}";
            $result = pg_query($PG_CONN, $sql);
            DBCheckResult($result, $sql, __FILE__, __LINE__);
            $row = pg_fetch_assoc($result);
            $lft = $row["lft"];
            $rgt = $row["rgt"];
            $upload_pk = $row["upload_fk"];
            pg_free_result($result);
            $typesql = '';
            if ($type && "all" != $type) {
                $typesql = "and type = '{$type}'";
            }
            //  Get the copyright under this $uploadtree_pk
            $sql = "SELECT ct_pk, content from copyright ,\n                  (SELECT distinct(pfile_fk) as PF from uploadtree\n                     where upload_fk={$upload_pk}\n                       and uploadtree.lft BETWEEN {$lft} and {$rgt}) as SS\n              where PF=pfile_fk and agent_fk={$agent_pk} {$typesql};";
            $result = pg_query($PG_CONN, $sql);
            DBCheckResult($result, $sql, __FILE__, __LINE__);
        } else {
            Fatal("Missing function inputs", __FILE__, __LINE__);
        }
    }
    $CopyrightArray = array();
    while ($row = pg_fetch_assoc($result)) {
        $CopyrightArray[$row['ct_pk']] = $row["content"];
    }
    pg_free_result($result);
    return $CopyrightArray;
}

function dbError($sql)
{
    Fatal("SQL-ERR '" . mysql_error() . "', statement was '" . $sql . "'");
}

function Main($argv)
{
    if (count($argv) == 1) {
        BenchPrintHelp($argv[0]);
        return 0;
    }
    $mode = null;
    $files = array();
    $locals = array();
    // parse arguments
    $force_reindex = false;
    $view_results = false;
    $unlink_run = false;
    for ($i = 1; $i < count($argv); $i++) {
        $opt = $argv[$i];
        if (substr($opt, 0, 2) == '--') {
            $values = explode('=', substr($opt, 2), 2);
            if (count($values) == 2) {
                $locals[$values[0]] = $values[1];
            }
        } else {
            if ($opt[0] == '-' && $i < count($argv) - 1) {
                $locals[substr($opt, 1)] = $argv[++$i];
            } else {
                if ($mode) {
                    $files[] = $opt;
                } else {
                    switch ($opt) {
                        case 'b':
                        case 'benchmark':
                            $mode = 'benchmark';
                            break;
                        case 'bb':
                            $mode = 'benchmark';
                            $force_reindex = true;
                            break;
                        case 'bv':
                            $mode = 'benchmark';
                            $view_results = true;
                            break;
                        case 'bbv':
                            $mode = 'benchmark';
                            $force_reindex = true;
                            $view_results = true;
                            break;
                        case 'c':
                        case 'compare':
                            $mode = 'compare';
                            break;
                        case 't':
                        case 'try':
                            $mode = 'benchmark';
                            $view_results = true;
                            $unlink_run = true;
                            break;
                        case 'v':
                        case 'view':
                            $mode = 'view';
                            break;
                        default:
                            Fatal("unknown mode '{$opt}' (run bench.php without arguments for help)");
                    }
                }
            }
        }
    }
    global $g_locals;
    PublishLocals($locals, true);
    require_once "helpers.inc";
    // run the command
    if ($mode == 'benchmark') {
        if (count($files) == 0) {
            $avail = AvailableBenchmarks();
            if ($avail) {
                $avail = " ({$avail})";
            }
            Fatal("benchmark command requires a benchmark name{$avail}");
        }
        if (count($files) != 1) {
            Fatal("benchmark command requires exactly one name");
        }
        $path = "bench/{$files['0']}.xml";
        if (!is_readable($path)) {
            Fatal("benchmark scenario '{$path}' is not readable");
        }
        $res = sphBenchmark($files[0], $g_locals, $force_reindex);
        if (!$res) {
            return 1;
        }
        if ($view_results) {
            sphTextReport(sphCompare(array("{$res}.bin", "{$res}.bin")));
        }
        if ($unlink_run) {
            printf("\nunlinked %s\n", $res);
            unlink("{$res}.bin");
            unlink("{$res}.searchd.txt");
        }
    } else {
        if ($mode == 'compare') {
            switch (count($files)) {
//.........这里部分代码省略.........

# Only one request can open the session file at a time, so let's close the session here to improve concurrency.
# Any file/page that uses the session must re-open it.
session_write_close();
if (isset($_REQUEST['request'])) {
    foreach (getSkinIncludes('ajax/' . $request . '.php', true, true) as $includeFile) {
        if (!file_exists($includeFile)) {
            Fatal("Request '{$request}' does not exist");
        }
        require_once $includeFile;
    }
    return;
} else {
    if ($includeFiles = getSkinIncludes('views/' . $view . '.php', true, true)) {
        foreach ($includeFiles as $includeFile) {
            if (!file_exists($includeFile)) {
                Fatal("View '{$view}' does not exist");
            }
            require_once $includeFile;
        }
        // If the view overrides $view to 'error', and the user is not logged in, then the
        // issue is probably resolvable by logging in, so provide the opportunity to do so.
        // The login view should handle redirecting to the correct location afterward.
        if ($view == 'error' && !isset($user)) {
            $view = 'login';
            foreach (getSkinIncludes('views/login.php', true, true) as $includeFile) {
                require_once $includeFile;
            }
        }
    }
    // If the view is missing or the view still returned error with the user logged in,
    // then it is not recoverable.

 $format = $_REQUEST['format'];
 switch ($format) {
     case 'text':
         $exportExt = "txt";
         break;
     case 'tsv':
         $exportExt = "tsv";
         break;
     case 'html':
         $exportExt = "html";
         break;
     case 'xml':
         $exportExt = "xml";
         break;
     default:
         Fatal("Unrecognised log export format '{$format}'");
 }
 $exportFile = "zm-log.{$exportExt}";
 $exportPath = "temp/zm-log-{$exportKey}.{$exportExt}";
 header("Pragma: public");
 header("Expires: 0");
 header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
 header("Cache-Control: private", false);
 // required by certain browsers
 header("Content-Description: File Transfer");
 header('Content-Disposition: attachment; filename="' . $exportFile . '"');
 header("Content-Transfer-Encoding: binary");
 header("Content-Type: application/force-download");
 header("Content-Length: " . filesize($exportPath));
 readfile($exportPath);
 exit(0);

# Only one request can open the session file at a time, so let's close the session here to improve concurrency.
# Any file/page that uses the session must re-open it.
session_write_close();
if (isset($_REQUEST['request'])) {
    foreach (getSkinIncludes('ajax/' . $request . '.php', true, true) as $includeFile) {
        if (!file_exists($includeFile)) {
            Fatal("Request '{$request}' does not exist");
        }
        require_once $includeFile;
    }
    return;
} else {
    if ($includeFiles = getSkinIncludes('views/' . $view . '.php', true, true)) {
        foreach ($includeFiles as $includeFile) {
            if (!file_exists($includeFile)) {
                Fatal("View '{$view}' does not exist: " . $includeFile);
            }
            require_once $includeFile;
        }
        // If the view overrides $view to 'error', and the user is not logged in, then the
        // issue is probably resolvable by logging in, so provide the opportunity to do so.
        // The login view should handle redirecting to the correct location afterward.
        if ($view == 'error' && !isset($user)) {
            $view = 'login';
            foreach (getSkinIncludes('views/login.php', true, true) as $includeFile) {
                require_once $includeFile;
            }
        }
    }
    // If the view is missing or the view still returned error with the user logged in,
    // then it is not recoverable.

    }
} else {
    // Not so simple version
    if (!function_exists("imagecreatefromjpeg")) {
        Warning("The imagecreatefromjpeg function is not present, php-gd not installed?");
    }
    if (!$errorText) {
        if (!($image = imagecreatefromjpeg(ZM_DIR_EVENTS . '/' . $path))) {
            $errorText = "Can't load image";
            $error = error_get_last();
            Error($error['message']);
        }
    }
    if ($errorText) {
        if (!($image = imagecreatetruecolor(160, 120))) {
            $error = error_get_last();
            Error($error['message']);
        }
        if (!($textColor = imagecolorallocate($image, 255, 0, 0))) {
            $error = error_get_last();
            Error($error['message']);
        }
        if (!imagestring($image, 1, 20, 60, $errorText, $textColor)) {
            $error = error_get_last();
            Error($error['message']);
        }
        Fatal($errorText . " - " . $path);
    }
    imagejpeg($image);
    imagedestroy($image);
}

function _extractDatetimeRange(&$node, &$minTime, &$maxTime, &$expandable, $subOr)
{
    $pruned = $leftPruned = $rightPruned = false;
    if ($node) {
        if (isset($node['left']) && isset($node['right'])) {
            if ($node['data']['type'] == 'cnj' && $node['data']['value'] == 'or') {
                $subOr = true;
            } elseif (!empty($node['left']['data']['dtAttr'])) {
                if ($subOr) {
                    $expandable = false;
                } elseif ($node['data']['type'] == 'op') {
                    if ($node['data']['value'] == '>' || $node['data']['value'] == '>=') {
                        if (!$minTime || $minTime > $node['right']['data']['sqlValue']) {
                            $minTime = $node['right']['data']['value'];
                            return true;
                        }
                    }
                    if ($node['data']['value'] == '<' || $node['data']['value'] == '<=') {
                        if (!$maxTime || $maxTime < $node['right']['data']['sqlValue']) {
                            $maxTime = $node['right']['data']['value'];
                            return true;
                        }
                    }
                } else {
                    Fatal("Unexpected node type '" . $node['data']['type'] . "'");
                }
                return false;
            }
            $leftPruned = _extractDatetimeRange($node['left'], $minTime, $maxTime, $expandable, $subOr);
            $rightPruned = _extractDatetimeRange($node['right'], $minTime, $maxTime, $expandable, $subOr);
            if ($leftPruned && $rightPruned) {
                $pruned = true;
            } elseif ($leftPruned) {
                $node = $node['right'];
            } elseif ($rightPruned) {
                $node = $node['left'];
            }
        }
    }
    return $pruned;
}

     if ($ctrlCommand) {
         $socket = socket_create(AF_UNIX, SOCK_STREAM, 0);
         if ($socket < 0) {
             Fatal("socket_create() failed: " . socket_strerror($socket));
         }
         $sockFile = ZM_PATH_SOCKS . '/zmcontrol-' . $monitor['Id'] . '.sock';
         if (@socket_connect($socket, $sockFile)) {
             $options = array();
             foreach (explode(" ", $ctrlCommand) as $option) {
                 if (preg_match('/--([^=]+)(?:=(.+))?/', $option, $matches)) {
                     $options[$matches[1]] = $matches[2] ? $matches[2] : 1;
                 }
             }
             $optionString = jsonEncode($options);
             if (!socket_write($socket, $optionString)) {
                 Fatal("Can't write to control socket: " . socket_strerror(socket_last_error($socket)));
             }
             socket_close($socket);
         } else {
             $ctrlCommand .= " --id=" . $monitor['Id'];
             // Can't connect so use script
             $ctrlOutput = exec(escapeshellcmd($ctrlCommand));
         }
     }
 } elseif ($action == "settings") {
     $args = " -m " . escapeshellarg($mid);
     $args .= " -B" . escapeshellarg($_REQUEST['newBrightness']);
     $args .= " -C" . escapeshellarg($_REQUEST['newContrast']);
     $args .= " -H" . escapeshellarg($_REQUEST['newHue']);
     $args .= " -O" . escapeshellarg($_REQUEST['newColour']);
     $zmuCommand = getZmuCommand($args);

 /**
  * \brief This function returns the output html
  */
 function Output()
 {
     global $PG_CONN;
     global $Plugins;
     if ($this->State != PLUGIN_STATE_READY) {
         return 0;
     }
     $V = "";
     $folder_pk = GetParm("folder", PARM_INTEGER);
     $Upload = GetParm("upload", PARM_INTEGER);
     // upload_pk to browse
     $Item = GetParm("item", PARM_INTEGER);
     // uploadtree_pk to browse
     /* check permission if $Upload is given */
     if (!empty($Upload)) {
         $UploadPerm = GetUploadPerm($Upload);
         if ($UploadPerm < PERM_READ) {
             $text = _("Permission Denied");
             echo "<h2>{$text}<h2>";
             return;
         }
     }
     /* kludge for plugins not supplying a folder parameter.
      * Find what folder this upload is in.  Error if in multiple folders.
      */
     if (empty($folder_pk)) {
         if (empty($Upload)) {
             $folder_pk = GetUserRootFolder();
         } else {
             /* Make sure the upload record exists */
             $sql = "select upload_pk from upload where upload_pk={$Upload}";
             $result = pg_query($PG_CONN, $sql);
             DBCheckResult($result, $sql, __FILE__, __LINE__);
             if (pg_num_rows($result) < 1) {
                 echo "This upload no longer exists on this system.";
                 return;
             }
             $sql = "select parent_fk from foldercontents where child_id={$Upload} and foldercontents_mode=2";
             $result = pg_query($PG_CONN, $sql);
             DBCheckResult($result, $sql, __FILE__, __LINE__);
             if (pg_num_rows($result) > 1) {
                 Fatal("Upload {$Upload} found in multiple folders.", __FILE__, __LINE__);
             }
             if (pg_num_rows($result) < 1) {
                 Fatal("Upload {$Upload} missing from foldercontents.", __FILE__, __LINE__);
             }
             $row = pg_fetch_assoc($result);
             $folder_pk = $row['parent_fk'];
             pg_free_result($result);
         }
     }
     $Folder = $folder_pk;
     $Show = 'detail';
     // always use detail
     switch ($this->OutputType) {
         case "XML":
             break;
         case "HTML":
             /************************/
             /* Show the folder path */
             /************************/
             $uploadtree_tablename = "";
             if (!empty($Item)) {
                 /* Make sure the item is not a file */
                 $sql = "SELECT ufile_mode, upload_fk FROM uploadtree WHERE uploadtree_pk = '{$Item}';";
                 $result = pg_query($PG_CONN, $sql);
                 DBCheckResult($result, $sql, __FILE__, __LINE__);
                 $row = pg_fetch_assoc($result);
                 pg_free_result($result);
                 $Upload = $row['upload_fk'];
                 $UploadPerm = GetUploadPerm($Upload);
                 if ($UploadPerm < PERM_READ) {
                     $text = _("Permission Denied");
                     echo "<h2>{$text}<h2>";
                     return;
                 }
                 if (!Iscontainer($row['ufile_mode'])) {
                     /* Not a container! */
                     $View =& $Plugins[plugin_find_id("view")];
                     if (!empty($View)) {
                         return $View->ShowView(NULL, "browse");
                     }
                 }
                 $V .= "<font class='text'>\n";
                 $uploadtree_tablename = GetUploadtreeTableName($row['upload_fk']);
                 $V .= Dir2Browse($this->Name, $Item, NULL, 1, "Browse", -1, '', '', $uploadtree_tablename) . "\n";
             } else {
                 if (!empty($Upload)) {
                     $V .= "<font class='text'>\n";
                     $uploadtree_tablename = GetUploadtreeTableName($Upload);
                     $V .= Dir2BrowseUpload($this->Name, $Upload, NULL, 1, "Browse", $uploadtree_tablename) . "\n";
                 } else {
                     $V .= "<font class='text'>\n";
                 }
             }
             /******************************/
             /* Get the folder description */
//.........这里部分代码省略.........

function sendControlCommand($mid, $command)
{
    // Either connects to running zmcontrol.pl or runs zmcontrol.pl to send the command.
    $socket = socket_create(AF_UNIX, SOCK_STREAM, 0);
    if ($socket < 0) {
        Fatal("socket_create() failed: " . socket_strerror($socket));
    }
    $sockFile = ZM_PATH_SOCKS . '/zmcontrol-' . $mid . '.sock';
    if (@socket_connect($socket, $sockFile)) {
        $options = array();
        foreach (explode(" ", $command) as $option) {
            if (preg_match('/--([^=]+)(?:=(.+))?/', $option, $matches)) {
                $options[$matches[1]] = $matches[2] ? $matches[2] : 1;
            }
        }
        $optionString = jsonEncode($options);
        if (!socket_write($socket, $optionString)) {
            Fatal("Can't write to control socket: " . socket_strerror(socket_last_error($socket)));
        }
        socket_close($socket);
    } else {
        if ($command != 'quit') {
            $command .= ' --id=' . $mid;
            // Can't connect so use script
            $ctrlOutput = exec(escapeshellcmd($command));
        }
    }
}

function exportEvents($eids, $exportDetail, $exportFrames, $exportImages, $exportVideo, $exportMisc, $exportFormat)
{
    if (canView('Events') && !empty($eids)) {
        $export_root = "zmExport";
        $export_listFile = "zmFileList.txt";
        $exportFileList = array();
        $html_eventMaster = '';
        if (is_array($eids)) {
            foreach ($eids as $eid) {
                $exportFileList = array_merge($exportFileList, exportFileList($eid, $exportDetail, $exportFrames, $exportImages, $exportVideo, $exportMisc));
            }
        } else {
            $eid = $eids;
            $exportFileList = exportFileList($eid, $exportDetail, $exportFrames, $exportImages, $exportVideo, $exportMisc);
        }
        // create an master image slider
        if ($exportImages) {
            if (!is_array($eids)) {
                $eids = array($eids);
            }
            $monitorPath = 'events/';
            $html_eventMaster = 'zmEventImagesMaster_' . date('Ymd_His') . '.html';
            if (!($fp = fopen($monitorPath . "/" . $html_eventMaster, "w"))) {
                Fatal("Can't open event images export file '{$html_eventMaster}'");
            }
            fwrite($fp, exportEventImagesMaster($eids));
            fclose($fp);
            $exportFileList[] = $monitorPath . "/" . $html_eventMaster;
        }
        $listFile = "temp/" . $export_listFile;
        if (!($fp = fopen($listFile, "w"))) {
            Fatal("Can't open event export list file '{$listFile}'");
        }
        foreach ($exportFileList as $exportFile) {
            fwrite($fp, "{$exportFile}\n");
        }
        fclose($fp);
        $archive = "";
        if ($exportFormat == "tar") {
            $archive = "temp/" . $export_root . ".tar.gz";
            @unlink($archive);
            $command = "tar --create --gzip --file={$archive} --files-from={$listFile}";
            exec(escapeshellcmd($command), $output, $status);
            if ($status) {
                Error("Command '{$command}' returned with status {$status}");
                if ($output[0]) {
                    Error("First line of output is '" . $output[0] . "'");
                }
                return false;
            }
        } elseif ($exportFormat == "zip") {
            $archive = "temp/zm_export.zip";
            $archive = "temp/" . $export_root . ".zip";
            @unlink($archive);
            $command = "cat " . escapeshellarg($listFile) . " | zip -q " . escapeshellarg($archive) . " -@";
            //cat zmFileList.txt | zip -q zm_export.zip -@
            //-bash: zip: command not found
            exec($command, $output, $status);
            if ($status) {
                Error("Command '{$command}' returned with status {$status}");
                if ($output[0]) {
                    Error("First line of output is '" . $output[0] . "'");
                }
                return false;
            }
        }
        //clean up temporary files
        if (!empty($html_eventMaster)) {
            unlink($monitorPath . '/' . $html_eventMaster);
        }
    }
    return $archive;
}

/**
 * \brief Check if a bucket_pk is found in a tree 
 * for a given nomos and bucket agent.
 * 
 * \param  $bucket_pk
 * \param  $uploadtree_pk  
 * 
 * \return True if bucket_pk is found in the tree
 *   False if not
 */
function BucketInTree($bucket_pk, $uploadtree_pk)
{
    global $PG_CONN;
    $BuckArray = array();
    if (empty($bucket_pk) || empty($uploadtree_pk)) {
        Fatal("Missing parameter: bucket_pk: {$bucket_pk}, uploadtree_pk: {$uploadtree_pk}<br>", __FILE__, __LINE__);
    }
    /* Find lft and rgt bounds for this $uploadtree_pk  */
    $sql = "SELECT lft,rgt, upload_fk FROM uploadtree WHERE uploadtree_pk = {$uploadtree_pk}";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) < 1) {
        pg_free_result($result);
        return False;
    }
    $row = pg_fetch_assoc($result);
    $lft = $row["lft"];
    $rgt = $row["rgt"];
    $upload_fk = $row["upload_fk"];
    pg_free_result($result);
    /* search for bucket in tree */
    $sql = "SELECT bucket_fk from bucket_file, \n            (SELECT distinct(pfile_fk) as PF from uploadtree \n               where uploadtree.lft BETWEEN {$lft} and {$rgt} and upload_fk='{$upload_fk}') as SS\n          where PF=pfile_fk and bucket_fk='{$bucket_pk}' limit 1";
    $result = pg_query($PG_CONN, $sql);
    DBCheckResult($result, $sql, __FILE__, __LINE__);
    if (pg_num_rows($result) == 0) {
        $rv = False;
    } else {
        $rv = True;
    }
    pg_free_result($result);
    return $rv;
}