Changeset 715 for downloadDatabase/files/lib/data/downloadDB/DownloadDBData.class.php

Timestamp:

11/13/08 22:03:46 (5 years ago)

Author:

Tatzelwurm

Message:

Last version (1.1.0 pl 1)

Files:

• downloadDatabase/files/lib/data/downloadDB/DownloadDBData.class.php (modified) (5 diffs)

downloadDatabase/files/lib/data/downloadDB/DownloadDBData.class.php

@@ -19 +19 @@
          */
         public function __construct($dataID, $row = null) {
-                if ($dataID != null) {
-                        $sql = "SELECT  *
-                                FROM    wcf".WCF_N."_dldb_data
-                                WHERE   dataID = ".$dataID;
+                if ($dataID !== null) {
+                        // select thread and thread subscription, visit and rating 
+                        $sql = "SELECT          data.* 
+                                                ".(DOWNLOADDB_ENABLE_RATING ? ", data_rating.rating AS userRating" : "")."
+                                FROM            wcf".WCF_N."_dldb_data data
+                                ".(DOWNLOADDB_ENABLE_RATING ? "
+                                LEFT JOIN       wcf".WCF_N."_dldb_rating data_rating
+                                ON              (data_rating.dataID = data.dataID
+                                                AND ".(WCF::getUser()->userID ? "data_rating.userID = ".WCF::getUser()->userID : "data_rating.ipAddress = '".escapeString(WCF::getSession()->ipAddress)."'").")" : "")."
+                                WHERE           data.dataID = ".$dataID;
                         $row = WCF::getDB()->getFirstRow($sql);
                 }
-                        parent::__construct($row);
+                parent::__construct($row);
         }
         
@@ -48 +54 @@
 
                 // delete Preview
-                $this->deletePreview($this->previewFile);
+                if ($this->previewFile) $this->deletePreview($this->previewFile);
 
                 // delete database entry
                 $sql = "DELETE FROM     wcf".WCF_N."_dldb_data
-                                WHERE           dataID = ".$this->dataID;
+                                WHERE   `dataID` =".$this->dataID;
                 WCF::getDB()->sendQuery($sql);
 
+                // delete ratings
+                $sql = "DELETE FROM     wcf".WCF_N."_dldb_rating
+                                WHERE   `dataID` =".$this->dataID;
+                WCF::getDB()->sendQuery($sql);
+                
+                // delete database log
+                $sql = "DELETE FROM     wcf".WCF_N."_dldb_xfer
+                                WHERE   `dataID` =".$this->dataID;
+                WCF::getDB()->sendQuery($sql);
+                
                 // clear Cache
                 $this->resetCache();
@@ -65 +81 @@
         public function deleteFile($fName) {
                 // delete file
-                if(file_exists(RELATIVE_WCF_DIR.DOWNLOADDB_FILE_DIR . intval($this->dataID) . '_' . StringUtil::encodeHTML($fName))){
-                        @unlink(WCF_DIR.DOWNLOADDB_FILE_DIR . $this->dataID . '_' . $fName);
+                if(file_exists(WCF_DIR . DOWNLOADDB_FILE_DIR . intval($this->dataID) . '_' . StringUtil::encodeHTML($fName))){
+                        @unlink(WCF_DIR . DOWNLOADDB_FILE_DIR . $this->dataID . '_' . $fName);
                 } else {
                         @unlink(WCF_DIR . DOWNLOADDB_FILE_DIR . 'Upload-' .$this->dataID . '.' . $this->fileExtension);
@@ -78 +94 @@
         public function deletePreview($fName) {
                 // delete file
-                if(file_exists(RELATIVE_WCF_DIR.DOWNLOADDB_PREVIEW_DIR . $this->dataID . '_' . $fName)){
+                if(file_exists(WCF_DIR . DOWNLOADDB_PREVIEW_DIR . $this->dataID . '_' . $fName)){
                         @unlink(WCF_DIR . DOWNLOADDB_PREVIEW_DIR . $this->dataID . '_' . $fName);
                         @unlink(WCF_DIR . DOWNLOADDB_PREVIEW_DIR . 'thumbnail-' . $this->dataID . '_' . $fName);
@@ -88 +104 @@
         }
         
+        /**
+         * Deletes one Logentry.
+         * @param  integer $xferID
+         */
+        public static function deleteXfer($xferID) {
+                // delete file
+                // delete database entry
+                $sql = "DELETE FROM     wcf".WCF_N."_dldb_xfer
+                                WHERE           xferID = ".$xferID;
+                WCF::getDB()->sendQuery($sql);
+        }
+        
         public static function resetCache() {
                 // reset cache
                 WCF::getCache()->clear(WCF_DIR.'cache/', 'cache.dldbData.php');
                 WCF::getCache()->clear(WCF_DIR.'cache/', 'cache.dldbKat.php');
+        }
+
+        /**
+         * Returns the result of the rating of this download.
+         * 
+         * @return      mixed           result of the rating of this download
+         */
+        public function getRating() {
+                if ($this->ratings > 0 && $this->ratings >= DOWNLOADDB_MIN_RATINGS) {
+                        return $this->rating / $this->ratings;
+                }
+                return false;
+        }
+        
+        /**
+         * Gets the download rating result for template output.
+         *
+         * @return      string          download rating result for template output
+         */
+        public function getRatingOutput() {
+                $rating = $this->getRating();
+                if ($rating !== false) $roundedRating = round($rating, 0);
+                else $roundedRating = 0;
+                $description = '';
+                if ($this->ratings > 0) {
+                        $description = WCF::getLanguage()->get('wcf.dldb.dataset.rate.description', array('$votes' => StringUtil::formatNumeric($this->ratings), '$vote' => StringUtil::formatNumeric($rating)));
+                }
+                
+                return '<img src="'.RELATIVE_WCF_DIR.'icon/downloadDBRating'.$roundedRating.'.png" class="dldbRatingImage" alt="" title="'.$description.'" />';
         }