Changeset 836

Timestamp:

03/22/09 20:32:44 (4 years ago)

Author:

MDMAN

Message:

JGS - Exporter.class updated to Version 1.0.0

Location:

de.mdman.importer/de.wbb-security.database.importer.jgsdb.30x

Files:

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

de.mdman.importer/de.wbb-security.database.importer.jgsdb.30x/files/lib/data/database/importer/JGSDatenbank30xExporter.class.php

@@ -30 +30 @@
                 'files' => 1, 
                 'links' => 1, 
-                'optionals' => 0, 
+                'optionals' => 1, 
                 'thumbnails' => 1,
                 'activation' => 1
@@ -135 +135 @@
          */
         public function countOptionals() {
-                return 0;
+                $row = $this->getDB()->getFirstRow("SELECT COUNT(*) AS `count` FROM ".$this->dbPrefix."bb".$this->settings['dbNumber']."_jgs_db_bilder AS `f` LEFT JOIN ".$this->dbPrefix."bb".$this->settings['dbNumber']."_jgs_db_eintrag AS `u` ON (u.id = f.eintrags_id)");
+                return $row['count'];
         }
         
@@ -204 +205 @@
                                 $this->getImporter()->importFile("f".$row['id'],"i".$row['eintrags_id'],$this->settings['sourcePath']."jgs_db_download/download-".$row['zeit']."-".$row['id'].".".$row['datei_endung']."",$row['datei_name'].".".$row['datei_endung'],"",$row['userid']);
                         }
-                }
-                
+                }               
         }
         
@@ -222 +222 @@
          */
         public function exportOptionals($offset,$limit) {
-                //nothing
+
+                require_once(WCF_DIR.'lib/data/message/attachment/AttachmentsEditor.class.php');
+                        
+                $result = $this->getDB()->sendQuery("SELECT f.*, u.userid FROM ".$this->dbPrefix."bb".$this->settings['dbNumber']."_jgs_db_bilder AS `f` LEFT JOIN ".$this->dbPrefix."bb".$this->settings['dbNumber']."_jgs_db_eintrag AS `u` ON (u.id = f.eintrags_id)",$limit,$offset);
+                while($row = $this->getDB()->fetchArray($result)) {
+                
+                        $source = $this->settings['sourcePath']."jgs_db_bilder/bild-".$row['zeit']."-".$row['id'].".jpg";
+                        if(file_exists($source)) {
+                        
+                                $attachmentName = $row['bild_name'].".jpg";
+                        
+                                $item = $this->getImporter()->getImportKey("i".$row['eintrags_id']); 
+
+                                $attachment = array(
+                                        "attachmentSize" => filesize($source),
+                                        "sha1Hash" => sha1_file($source),
+                                        "fileType" => "image/jpeg",
+                                        "isBinary" => 1,
+                                        "isImage" => 1,
+                                        "messageID" => $item['value'],
+                                        "messageType" => "database",
+                                        "packageID" => PACKAGE_ID,
+                                        "idHash" => StringUtil::getRandomID(),
+                                        "userID" => $row['userid'],
+                                        "uploadTime" => $row['zeit']
+                                );
+
+                                $attachment['attachmentID'] = AttachmentsEditor::insert($attachmentName, $attachment);
+                                $attachment['attachmentName'] = $attachmentName;
+                                $attachment['attachment'] = WCF_DIR.'attachments/attachment-'.$attachment['attachmentID'];
+                                $attachment['attachmentExtension'] = 'jgp';
+                                
+                                @copy($source,$attachment['attachment']);
+                                
+                                AttachmentsEditor::saveThumbnail($attachment);
+                        } 
+                }
         }
         

de.mdman.importer/de.wbb-security.database.importer.jgsdb.30x/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>