Changeset 835

Timestamp:

03/22/09 20:24:04 (4 years ago)

Author:

MDMAN

Message:

IT4All - Exporter.class updated to Version 1.0.0

Location:

de.mdman.importer/de.wbb-security.database.importer.it4allfb.11x

Files:

• files/lib/data/database/importer/IT4AllFilebase11xExporter.class.php (modified) (6 diffs)
• package.xml (modified) (2 diffs)

de.mdman.importer/de.wbb-security.database.importer.it4allfb.11x/files/lib/data/database/importer/IT4AllFilebase11xExporter.class.php

@@ -2 +2 @@
 
 require_once(WCF_DIR.'lib/data/database/importer/AbstractDatabaseExporter.class.php');
-
 
 /**
@@ -30 +29 @@
                 'files' => 1, 
                 'links' => 1, 
-                'optionals' => 0, 
+                'optionals' => 1, 
                 'thumbnails' => 1,
                 'activation' => 1
@@ -135 +134 @@
          */
         public function countOptionals() {
-                return 0;
+                $row = $this->getDB()->getFirstRow("SELECT COUNT(u.upload_id) AS `count` FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_fileuploads AS `u` LEFT JOIN ".$this->dbPrefix."fp".$this->settings['dbNumber']."_files AS `f` ON (u.file_id = f.file_id) WHERE u.upmode = 'screen'");
+                return $row['count'];
         }
         
@@ -183 +183 @@
                 }
                 
-                $result = $this->getDB()->sendQuery("SELECT d.*,u.username FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_files AS `d` LEFT JOIN ".$this->dbPrefix."bb".$this->settings['dbNumber']."_users AS `u` ON (u.userid = d.userid)",$limit,$offset);
+                $result = $this->getDB()->sendQuery("SELECT d.*,u.username FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_files AS `d` LEFT JOIN ".$this->dbPrefix."bb".$this->settings['dbNumber']."_users AS `u` ON (u.userid = d.userid) ORDER BY `timest` ASC",$limit,$offset);
                 while($row = $this->getDB()->fetchArray($result)) {
                         
@@ -206 +206 @@
                 while($row = $this->getDB()->fetchArray($result)) {
                         //get first thumbnail from each file
-                        $result = $this->getDB()->sendQuery("SELECT * FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_fileuploads WHERE file_id = '".$row['file_id']."' ORDER BY upload_id ASC LIMIT 1,1");
-                        while ($row2 = $this->getDB()->fetchArray($result)) {
-                                if(file_exists($this->settings['sourcePath']."files/".$row2['upload_id']."_screen_".$row2['encode'].".".$row2['ext'])) {
-                                        $this->getImporter()->importThumbnail("t".$row2['upload_id'],"i".$row2['file_id'],$this->settings['sourcePath']."files/".$row2['upload_id']."_screen_".$row2['encode'].".".$row2['ext'],"",$row['userid']);
-                                }
-                        }
-                }
-        }
-        
-        /**
-         * @see AbstractDatabaseExporter::exportScreenshots();
-         */
-        public function exportScreenshots($offset,$limit) {
-                //look for the Screenshots
-                $sql = "SELECT f.*, u.file_id, u.userid FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_fileuploads AS `f` LEFT JOIN ".$this->dbPrefix."fp".$this->settings['dbNumber']."_files AS `u` ON (u.file_id = f.file_id) WHERE f.upmode = 'screen' LIMIT 2";
-                //$result = $this->getDB()->sendQuery($sql,$limit,$offset);
-                
-                 // file_id = itemID
-                 // upload_id = Bild_ID / Datei-ID
+                        $row2 = $this->getDB()->getFirstRow("SELECT * FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_fileuploads WHERE file_id = '".$row['file_id']."' AND upmode='screen' ORDER BY upload_id ASC");
+                        if(file_exists($this->settings['sourcePath']."files/".$row2['upload_id']."_screen_".$row2['encode'].".".$row2['ext'])) {
+                                $this->getImporter()->importThumbnail("t".$row2['upload_id'],"i".$row2['file_id'],$this->settings['sourcePath']."files/".$row2['upload_id']."_screen_".$row2['encode'].".".$row2['ext'],"",$row['userid']);
+                        }
+                }
         }
         
@@ -253 +239 @@
          */
         public function exportOptionals($offset,$limit) {
-                //nothing
+
+                require_once(WCF_DIR.'lib/data/message/attachment/AttachmentsEditor.class.php');
+
+                $result = $this->getDB()->sendQuery("SELECT f.*, u.file_id, u.userid FROM ".$this->dbPrefix."fp".$this->settings['dbNumber']."_fileuploads AS `f` LEFT JOIN ".$this->dbPrefix."fp".$this->settings['dbNumber']."_files AS `u` ON (u.file_id = f.file_id) WHERE f.upmode = 'screen'",$limit,$offset);
+                while($row = $this->getDB()->fetchArray($result)) {
+                
+                        $source = $this->settings['sourcePath']."files/".$row['upload_id']."_screen_".$row['encode'].".".$row['ext'];
+                
+                        if(file_exists($source)) {
+                        
+                                $attachmentName = $row['name'].".".$row['ext'];
+                        
+                                $item = $this->getImporter()->getImportKey("i".$row['file_id']); 
+
+                                $attachment = array(
+                                        "attachmentSize" => filesize($source),
+                                        "sha1Hash" => sha1_file($source),
+                                        "fileType" => $row['mime'],
+                                        "isBinary" => 1,
+                                        "isImage" => 1,
+                                        "messageID" => $item['value'],
+                                        "messageType" => "database",
+                                        "packageID" => PACKAGE_ID,
+                                        "idHash" => StringUtil::getRandomID(),
+                                        "userID" => $row['userid'],
+                                        "uploadTime" => $row['upload_time']
+                                );
+                                
+                                $attachment['attachmentID'] = AttachmentsEditor::insert($attachmentName, $attachment);
+                                $attachment['attachmentName'] = $attachmentName;
+                                $attachment['attachment'] = WCF_DIR.'attachments/attachment-'.$attachment['attachmentID'];
+                                $attachment['attachmentExtension'] = $row['ext'];
+                                
+                                @copy($source,$attachment['attachment']);
+                                
+                                AttachmentsEditor::saveThumbnail($attachment);
+                        }
+                        
+                }
         }
         

de.mdman.importer/de.wbb-security.database.importer.it4allfb.11x/package.xml

@@ -7 +7 @@
                 <standalone>0</standalone>
                 <isUnique>1</isUnique>
-                <version>1.0.0 RC 2</version>
+                <version>1.0.0</version>
                 <plugin>de.wbb-security.database</plugin>
-                <date>2009-03-21</date>
+                <date>2009-03-22</date>
         </packageInformation>
 
@@ -33 +33 @@
         </instructions>
         
-        <instructions type="update" fromversion="1.0.0 RC 1">
+        <instructions type="update" fromversion="1.0.0 RC *">
                 <files>files.tar</files>
         </instructions>