Changeset 11794 for extensions/Copyrights/image.php

Timestamp:

Jul 21, 2011, 11:43:45 AM (13 years ago)

Author:

Mattias

Message:

added support for -1 copyright
added an order by cr_id
the plugin handles deletes (no copyright) better

File:

• extensions/Copyrights/image.php (modified) (1 diff)

extensions/Copyrights/image.php

@@ -44 +44 @@
                 // Get the copyright name, url and description that belongs to the current media_item
                 $query = sprintf('
-                  select name, url, descr
+                  select cr_id, name, url, descr
                   FROM %s NATURAL JOIN %s
                   WHERE media_id = %s
                   AND visible = 1
-      ;',
-      COPYRIGHTS_ADMIN, COPYRIGHTS_MEDIA, $page['image_id']);
+                ;',
+                COPYRIGHTS_ADMIN, COPYRIGHTS_MEDIA, $page['image_id']);
                 $result = pwg_query($query);
-                $row = pwg_db_fetch_row($result);
+                $row = pwg_db_fetch_assoc($result);
                 $name = '';
                 $url = '';
                 $descr = '';
-                if(count($row) > 0) {
-                        $name = $row[0];
-                        $url = $row[1];
-                        $descr = $row[2];
+                if (count($row) > 0) {
+                        if ($row['cr_id'] == -1) {
+                                                $query = sprintf('
+                                                        SELECT name, url, descr
+                                                        FROM %s
+                                                        WHERE cr_id IN (
+                                                                SELECT a.copyright
+                                                                FROM '.$prefixeTable.'images i, '.$prefixeTable.'author_extended a
+                                                                WHERE i.id = %d
+                                                                AND i.author = a.name
+                                                        )
+                                                ;',
+                                                COPYRIGHTS_ADMIN, $page['image_id']);
+                                                $result = pwg_query($query);
+                                                $row = pwg_db_fetch_assoc($result);
+                        }
+                }
+                if (count($row) > 0) {
+                        $name = $row['name'];
+                        $url = $row['url'];
+                        $descr = $row['descr'];
                 }