common-repo.php

Go to the documentation of this file.

<?php
/*
 SPDX-FileCopyrightText: © 2008-2012 Hewlett-Packard Development Company, L.P.
 
 SPDX-License-Identifier: LGPL-2.1-only
*/
 
function GetMimeType($Item)
{
  global $PG_CONN;
 
  $Sql = "SELECT mimetype_name
  FROM uploadtree
  INNER JOIN pfile ON pfile_pk = pfile_fk
  INNER JOIN mimetype ON pfile.pfile_mimetypefk = mimetype.mimetype_pk
  WHERE uploadtree_pk = $Item LIMIT 1;";
  $result = pg_query($PG_CONN, $Sql);
  DBCheckResult($result, $Sql, __FILE__, __LINE__);
  if (pg_num_rows($result) > 0) {
    $row = pg_fetch_assoc($result);
    $Meta = $row['mimetype_name'];
  } else {
    $Meta = 'application/octet-stream';
  }
 
  pg_free_result($result);
  return($Meta);
} /* GetMimeType() */
 
function RepPath($PfilePk, $Repo="files")
{
  global $Plugins;
  global $LIBEXECDIR;
  global $PG_CONN;
  if (empty($PG_CONN)) {
    return;
  }
 
  $sql = "SELECT * FROM pfile WHERE pfile_pk = $PfilePk LIMIT 1;";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  $Row = pg_fetch_assoc($result);
  pg_free_result($result);
  if (empty($Row['pfile_sha1'])) {
    return (null);
  }
  $Hash = $Row['pfile_sha1'] . "." . $Row['pfile_md5'] . "." . $Row['pfile_size'];
  exec("$LIBEXECDIR/reppath $Repo ".escapeshellarg($Hash), $Path);
  return($Path[0]);
} // RepPath()
 
function RepPathItem($Item, $Repo="files")
{
  global $LIBEXECDIR;
  global $PG_CONN;
  if (empty($PG_CONN)) {
    return;
  }
 
  $sql = "SELECT * FROM pfile INNER JOIN uploadtree ON pfile_fk = pfile_pk
    WHERE uploadtree_pk = $Item LIMIT 1;";
  $result = pg_query($PG_CONN, $sql);
  DBCheckResult($result, $sql, __FILE__, __LINE__);
  $Row = pg_fetch_assoc($result);
  pg_free_result($result);
  if (empty($Row['pfile_sha1'])) {
    return (null);
  }
  $Hash = $Row['pfile_sha1'] . "." . $Row['pfile_md5'] . "." . $Row['pfile_size'];
  exec("$LIBEXECDIR/reppath $Repo ".escapeshellarg($Hash), $Path);
  return($Path[0]);
}