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

Timestamp:

Mar 17, 2011, 8:25:13 PM (13 years ago)

Author:

mistic100

Message:

[extensions] Contest Results

• New bloc for PWG Stuffs
• Use new admin links and javascript implementation
• Distinguish pending and running contests (both pending before)

File:

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

extensions/ContestResults/maintain.inc.php

@@ -14 +14 @@
         'menubar_block' => array(
                 'number' => 5
-        )
+        ),
+        'truncate_summary' => 350,
 )));
 
-// Installtion
+// Installation
 function plugin_install() {
         global $prefixeTable;
@@ -29 +30 @@
                 `logo` VARCHAR( 255 ) NULL ,
                 `banner` VARCHAR( 255 ) NULL ,
+                `summary` TEXT NULL ,
                 `description` TEXT NULL ,
                 PRIMARY KEY ( `id` )
-        );");
+        ) DEFAULT CHARSET=utf8;");
         
         pwg_query("CREATE TABLE `" . $prefixeTable . "contests_results` (
@@ -40 +42 @@
                 `comment` TEXT NULL,
                 UNIQUE ( `image_id` , `contest_id` )
-        );");
+        ) DEFAULT CHARSET=utf8;");
         
         pwg_query("INSERT INTO " . CONFIG_TABLE . "(param,value,comment) VALUES('ContestResults', '" . default_config . "', 'Parametres du plugin ContestResults');");
@@ -49 +51 @@
         global $conf, $prefixeTable;
 
-        // compatibilité avec les versions < 1.1 (ajout d'une entrée de configuration)
-        if (!isset($conf['ContestResults'])) {
-                pwg_query("INSERT INTO " . CONFIG_TABLE . "(param,value,comment) VALUES('ContestResults', '" . default_config . "', 'Parametres du plugin ContestResults');");
-        }
-        
-        // compatibilité avec les versions < 1.2 (suppression option d'affichage)
-        $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`,
-                        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`;"
-                );
-        }
-        
+        include('include/compatibility.inc.php');
 }