Changeset 9572 for extensions/ContestResults/maintain.inc.php

Timestamp:

Mar 8, 2011, 1:19:06 PM (13 years ago)

Author:

mistic100

Message:

[extensions] ContestResults 1.3

• Add error and success messages on admin page
• Add Spain (es_ES) thanks to jpr928
• Contest status is automatic and shows remaining days
• More flexibility for description fields
• Compatibility with Piwigo 2.2.0

File:

• extensions/ContestResults/maintain.inc.php (modified) (3 diffs)

extensions/ContestResults/maintain.inc.php

@@ -3 +3 @@
 
 // Configuration par défaut
-define('default_config' , serialize(array(
+define('default_config', serialize(array(
         'menubar_mode' => array(
                 'link' => 0,
@@ -26 +26 @@
                 `date_begin` DATE NOT NULL ,
                 `date_end` DATE NOT NULL ,
-                `status` VARCHAR( 255 ) NOT NULL ,
                 `visible` TINYINT(1) NOT NULL ,
                 `logo` VARCHAR( 255 ) NULL ,
                 `banner` VARCHAR( 255 ) NULL ,
-                `summary` TEXT NULL ,
-                `presentation` TEXT NULL ,
-                `rules` TEXT NULL ,
-                `prices` TEXT NULL ,
-                `final` TEXT NULL ,
+                `description` TEXT NULL ,
                 PRIMARY KEY ( `id` )
         );");
@@ -62 +57 @@
         $field = pwg_query("SHOW COLUMNS FROM `" . $prefixeTable . "contests` LIKE 'presentation_display'");
         if (pwg_db_num_rows($field)) {
-                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` DROP `presentation_display`");
-                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` DROP `rules_display`");
-                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` DROP `prices_display`");
-                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` DROP `final_display`");
+                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` 
+                        DROP `presentation_display`,
+                        DROP `rules_display`,
+                        DROP `prices_display`,
+                        DROP `final_display`;"
+                );
         }
+        
+        // compatibilité avec les versions < 1.3 (suppression option status, regroupement des champs de description)
+        $field = pwg_query("SHOW COLUMNS FROM `" . $prefixeTable . "contests` LIKE 'status'");
+        if (pwg_db_num_rows($field)) {
+                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` DROP `status`");
+                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` ADD `description` TEXT NULL");
+                
+                $contests = pwg_query("SELECT * FROM `" . $prefixeTable . "contests`");
+                while ($contest = pwg_db_fetch_assoc($contests)) {
+                        $new_description = array();
+                        if (!empty($contest['presentation'])) {
+                                $new_description[] = array(
+                                        'name' => 'Presentation[lang=fr]Présentation[/lang][lang=es]Presentación[/lang][lang=lv]Prezentacija[/lang]',
+                                        'content' => $contest['presentation'],
+                                );
+                        }
+                        if (!empty($contest['rules'])) {
+                                $new_description[] = array(
+                                        'name' => 'Rules[lang=fr]Règles[/lang][lang=es]Restricciones[/lang][lang=lv]Noteikumi[/lang]',
+                                        'content' => $contest['rules'],
+                                );
+                        }
+                        if (!empty($contest['prices'])) {
+                                $new_description[] = array(
+                                        'name' => 'Prices[lang=fr]Prix[/lang][lang=es]Precios[/lang][lang=lv]Cenas[/lang]',
+                                        'content' => $contest['prices'],
+                                );
+                        }
+                        if (!empty($contest['final'])) {
+                                $new_description[] = array(
+                                        'name' => 'Conclusion[lang=fr]Conclusion[/lang][lang=es]Conclusión[/lang][lang=lv]Beigsana[/lang]',
+                                        'content' => $contest['final'],
+                                );
+                        }
+                
+                        $new_description = base64_encode(serialize($new_description));
+                        pwg_query("UPDATE `" . $prefixeTable . "contests`
+                                SET description = '". $new_description ."'
+                                WHERE id = ". $contest['id'] .";"
+                        );
+                }
+                
+                pwg_query("ALTER TABLE `" . $prefixeTable . "contests` 
+                        DROP `presentation`,
+                        DROP `rules`,
+                        DROP `prices`,
+                        DROP `final`;"
+                );
+        }
+        
 }