Changeset 834

Timestamp:

03/22/09 19:12:14 (4 years ago)

Author:

MDMAN

Message:

JGS - Exporter.class bugfix

Files:

• de.mdman.importer/de.wbb-security.database.importer.jgsdb.30x/files/lib/data/database/importer/JGSDatenbank30xExporter.class.php (modified) (1 diff)

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

@@ -188 +188 @@
                 $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)) {
-                        if(file_exists($this->settings['sourcePath']."jgs_db_bilder/bild-".$row['zeit']."-".$row['id'].".jpg")) {
-                                $this->getImporter()->importThumbnail("t".$row['id'],"i".$row['eintrags_id'],$this->settings['sourcePath']."jgs_db_bilder/bild-".$row['zeit']."-".$row['id'].".jpg","",$row['userid']);
+                        $row2 = $this->getDB()->getFirstRow("SELECT * FROM ".$this->dbPrefix."bb".$this->settings['dbNumber']."_jgs_db_bilder WHERE eintrags_id = ".$row['eintrags_id']." ORDER BY id ASC");
+                        if(file_exists($this->settings['sourcePath']."jgs_db_bilder/bild-".$row2['zeit']."-".$row2['id'].".jpg")) {
+                                $this->getImporter()->importThumbnail("t".$row2['id'],"i".$row2['eintrags_id'],$this->settings['sourcePath']."jgs_db_bilder/bild-".$row2['zeit']."-".$row2['id'].".jpg","",$row['userid']);
                         }
                 }