common-repo.php

Go to the documentation of this file.

<?php
/***********************************************************
 Copyright (C) 2008-2012 Hewlett-Packard Development Company, L.P.

 This library is free software; you can redistribute it and/or
 modify it under the terms of the GNU Lesser General Public
 License version 2.1 as published by the Free Software Foundation.

 This library is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 Lesser General Public License for more details.

 You should have received a copy of the GNU Lesser General Public License
 along with this library; if not, write to the Free Software Foundation, Inc.0
 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
***********************************************************/

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 $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 $Hash", $Path);
  return($Path[0]);
}