AL\Common\DAO\DumpDAO

Complexity

Total Complexity

22

Size/Duplication

Total Lines	196
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	2	1
C	addDumpToMedia()	0	111	17
A	getAllDumpsFromMedia()	0	27	2
A	deleteDumpFromMedia()	0	11	1
A	getFormats()	0	6	1

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Dump/Dump.php" ;
require_once __DIR__."/../Model/User/User.php" ;
require_once __DIR__."/../../vendor/autoload.php";

/**
 * DAO for Dump
 */
class DumpDAO {
    private $mysqli;

    const FORMAT_STX = 'STX';
    const FORMAT_MSA = 'MSA';
    const FORMAT_RAW = 'RAW';
    const FORMAT_SCP = 'SCP';

    public function __construct($mysqli) {
        $this->mysqli = $mysqli;
    }

    /**
     * Get all the formats
     * @return String[] A list of formats
     */
    public function getFormats() {
        return array(
            DumpDAO::FORMAT_STX,
            DumpDAO::FORMAT_MSA,
            DumpDAO::FORMAT_RAW,
            DumpDAO::FORMAT_SCP
        );
    }

     /**
     * Add a dump to a media
     *
     * @param int media_id

The type AL\Common\DAO\media_id was not found. Maybe you did not declare it correctly or list all dependencies?

     * @param varchar format
     * @param varchar file name

The type AL\Common\DAO\file was not found. Maybe you did not declare it correctly or list all dependencies?

     * @param text info

The type AL\Common\DAO\info was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    public function addDumpToMedia(
        $media_id,
        $format,
        $file_name,
        $tempfilename,
        $info,
        $game_file_temp_path,
        $game_file_path,
        $filesize
    ) {
        //check the extension of the file, is it zipped or not?
        $file_ext = strrchr($file_name, ".");
        $file_ext = explode(".", $file_ext);
        $file_ext = strtolower($file_ext[1]);

        // If it is ZIP, do all the zippidy zip stuff
        if ($file_ext == 'zip') {
            // Time for zip magic
            $zip = new \PclZip("$tempfilename");

The type PclZip was not found. Maybe you did not declare it correctly or list all dependencies?

            // Obtain the contentlist of the zip file.
            if (($list = $zip->listContent()) == 0) {
                die("Error : " . $zip->errorInfo(true));

Using exit here is not recommended.

            }

            // Get the filename from the returned array
            $filename = $list[0]['filename'];

            // Split the filename to get the extention
            $ext = strrchr($filename, ".");

            // Get rid of the . in the extention
            $ext = explode(".", $ext);

            // convert to lowercase just incase....
            $ext = strtolower($ext[1]);

            // check if the extention is valid.
            if ($ext == "stx" || $ext == "msa" || $ext == "st"  || $file_ext == "scp") { // pretty isn't it? ;)
            } else {
                exit("Try uploading a diskimage type that is allowed, like stx or msa not $ext");

Using exit here is not recommended.

            }
        } else {
            if ($file_ext == "stx" || $file_ext == "msa" ||
                $file_ext == "st" || $file_ext == "scp") { // pretty isn't it? ;)
            } else {
                exit("Try uploading a diskimage type that is allowed $file_ext");

Using exit here is not recommended.

            }
        }

        // create a timestamp for the date of upload
        $timestamp = time();

        $stmt = \AL\Db\execute_query(

The assignment to $stmt is dead and can be removed.

            "DumpDAO: addDumptoMedia",
            $this->mysqli,
            "INSERT INTO dump (`media_id`, `format`, `info`, `date`, `size`, user_id ) VALUES (?, ?, ?, ?, ?, ?)",
            "issiii", $media_id, $format, $info, $timestamp, $filesize, $_SESSION['user_id']
        );

        //get the new dump id
        $new_dump_id = $this->mysqli->insert_id;

        if ($file_ext == 'zip') {
            // Time to unzip the file to the temporary directory
            $archive = new \PclZip("$tempfilename");

            if ($archive->extract(PCLZIP_OPT_PATH, "$game_file_temp_path") == 0) {

The constant AL\Common\DAO\PCLZIP_OPT_PATH was not found. Maybe you did not declare it correctly or list all dependencies?

                die("Error : " . $archive->errorInfo(true));

Using exit here is not recommended.

            }

            // rename diskimage to increment number
            rename("$game_file_temp_path$filename", "$game_file_temp_path$new_dump_id.$ext")

The variable $filename does not seem to be defined for all execution paths leading up to this point.

The variable $ext does not seem to be defined for all execution paths leading up to this point.

                or die("couldn't rename the file");

Using exit here is not recommended.

        } else {
            $file_data = rename("$tempfilename", "$game_file_temp_path$new_dump_id.$file_ext");

The assignment to $file_data is dead and can be removed.

        }

        //Time to rezip file and place it in the proper location.
        $archive = new \PclZip("$game_file_path$new_dump_id.zip");
        if ($file_ext == 'zip') {
            $v_list  = $archive->create("$game_file_temp_path$new_dump_id.$ext", PCLZIP_OPT_REMOVE_ALL_PATH);

The constant AL\Common\DAO\PCLZIP_OPT_REMOVE_ALL_PATH was not found. Maybe you did not declare it correctly or list all dependencies?

        } else {
            $v_list  = $archive->create("$game_file_temp_path$new_dump_id.$file_ext", PCLZIP_OPT_REMOVE_ALL_PATH);
        }
        if ($v_list == 0) {
            die("Error : " . $archive->errorInfo(true));

Using exit here is not recommended.

        }

        // Time to do the safeties, here we do a sha512 file hash that we later enter into
        // the database, this will be used in the download function to check everytime the file
        // is being downloaded... if the hashes don't match, then datacorruption have changed the file.
        $crc = openssl_digest("$game_file_path$new_dump_id.zip", 'sha512');

        $stmt = \AL\Db\execute_query(
            "DumpDAO: addDumptoMedia",
            $this->mysqli,
            "UPDATE dump SET sha512 = ? WHERE id = ?",
            "si", $crc, $new_dump_id
        );

        // Chmod file so that we can backup/delete files through ftp.
        chmod("$game_file_path$new_dump_id.zip", 0777);

        // Delete the unzipped file in the temporary directory
        if ($file_ext == 'zip') {
            unlink("$game_file_temp_path$new_dump_id.$ext");
        } else {
            unlink("$game_file_temp_path$new_dump_id.$file_ext");
        }
        $stmt->close();
    }

    /**
     * Get all dumps from media
     *
     * @return \AL\Common\Model\Dump\Dump[] An array of dumps
     */
    public function getAllDumpsFromMedia($media_id) {
        $stmt = \AL\Db\execute_query(
            "DumpDAO: getAllDumpsFromMedia",
            $this->mysqli,
            "SELECT id, format, sha512, date, size, info, dump.user_id, users.userid FROM dump
            LEFT JOIN users ON (users.user_id = dump.user_id)
            WHERE media_id = ?",
            "i", $media_id
        );

        \AL\Db\bind_result(
            "DumpDAO: getAllDumpsFromMedia",
            $stmt,
            $id, $format, $sha512, $date, $size, $info, $user_id, $userid

The variable $sha512 seems to be never defined.

The variable $size seems to be never defined.

The variable $info seems to be never defined.

The variable $format seems to be never defined.

The variable $user_id seems to be never defined.

The variable $date seems to be never defined.

The variable $userid seems to be never defined.

        );

        $dump = [];
        while ($stmt->fetch()) {
            $dump[] = new \AL\Common\Model\Dump\Dump(
                $id, $media_id, $format, $sha512, $date, $size, $info,
                new \AL\Common\Model\User\User($user_id, $userid, null, null, null, null, null)
            );
        }

        $stmt->close();

        return $dump;
    }

      /**
     * delete a dump from a media
     *
     * @param int dump_id

The type AL\Common\DAO\dump_id was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    public function deleteDumpFromMedia($dump_id, $game_file_path) {
        $stmt = \AL\Db\execute_query(
            "DumpDAO: deleteDumpFromMedia",
            $this->mysqli,
            "DELETE FROM dump WHERE id = ?",
            "i", $dump_id
        );

        unlink("$game_file_path$dump_id.zip");

        $stmt->close();
    }
}