files.php

Go to the documentation of this file.

<?php
class Files {
    //const CNTTYPE_FILE = -1;      /**< <tt>content.id_type</tt> field value */
    const ICON_SUFFIX = "_icon";
    const THUMB_SUFFIX = "_thumb";
    const SMALL_SUFFIX = "_small";
    const MIDDLE_SUFFIX = "_mid";

    public static function getFilePathFromId($id) {
        global $cfg;

        $sql =  "SELECT f.codename AS codename, c.id_owner AS id_owner " .
                "FROM files AS f LEFT JOIN content AS c ON f.id = c.id " .
                "WHERE (f.id = " . $id . ") AND (c.id_area = " . $cfg->getAreaId() . ")";
        $res = mysql_query($sql);
        if ($res === FALSE) { return ""; }      // not critical

        if (mysql_num_rows($res) > 0) {
            $line = mysql_fetch_assoc($res);    // only one record expected
        }
        mysql_free_result($res);
        if ($line['codename']) {
            return $cfg->getConfig("FILES_ROOTDIR") . $line['id_owner'] . "/" . substr($line['codename'], 0, 1) . "/" . $line['codename'];
        } else {
            return "";
        }
    }

    public static function delete($id) {
        if ($filepath = Files::getFilePathFromId($id)) {
            @unlink($filepath);
            /* if it's an image, also remove resized copies */
            @unlink($filepath . Files::ICON_SUFFIX);
            @unlink($filepath . Files::THUMB_SUFFIX);
            @unlink($filepath . Files::MIDDLE_SUFFIX);
            @unlink($filepath . Files::SMALL_SUFFIX);
        }
    }
}
?>

---