Changeset 11794 for extensions/Copyrights/batch_single.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/batch_single.php (modified) (4 diffs)

extensions/Copyrights/batch_single.php

@@ -24 +24 @@
                 <td>
                         <select id="copyright-{$element.ID}" name="copyright-{$element.ID}">
-                                <option value="0">--</option>
+                                <option value="">--</option>
                                 {html_options options=$CRoptions selected=$CRcopyrights[$element.ID]}
                         </select>
@@ -48 +48 @@
                 FROM %s
                 WHERE `visible`<>0
+                ORDER BY cr_id ASC
                 ;',
                 COPYRIGHTS_ADMIN);
@@ -92 +93 @@
                                 COPYRIGHTS_MEDIA, implode(',', $collection));
                         pwg_query($query);
-    }
+                }
 
                 // Add all copyrights to an array
@@ -100 +101 @@
                         $crID = pwg_db_real_escape_string($_POST['copyright-'.$image_id]);
 
-                        array_push(
-                                $edits,
-                                array(
-                                        'media_id' => $image_id,
-                
-                'cr_id' => $crID,
-                                )
+                        // If you assign no copyright, dont put them in the table
+                        if ($crID != '') {
+                                array_push(
+                                        $edits,
+                                        array(
+                                                'media_id' => $image_id,
+                                                'cr_id' => $crID,
+                                        )
+                                );
+                        }
+                }
+
+                if (count($edits) > 0) {
+                        // Insert the array to the database
+                        mass_inserts(
+                                COPYRIGHTS_MEDIA,        // Table name
+                                array_keys($edits[0]),   // Columns
+                                $edits                   // Data
                         );
-    }
-
-                // Insert the array to the database
-                mass_inserts(
-                        COPYRIGHTS_MEDIA,        // Table name
-                        array_keys($edits[0]),   // Columns
-                        $edits                   // Data
-                );
+                }
         }
 }