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

Timestamp:

Feb 13, 2011, 11:12:58 AM (13 years ago)

Author:

mistic100

Message:

ContestResults :

• Code revision
• Add Letton (lv_LV) language, thanks to Aivars Baldone
• Delete display options
• Fix languages bugs
• Improve public appearence

File:

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

extensions/ContestResults/maintain.inc.php

@@ -2 +2 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
+// Configuration par défaut
 define('default_config' , serialize(array(
         'menubar_mode' => array(
@@ -16 +17 @@
 )));
 
-function plugin_install(){
+// Installtion
+function plugin_install() {
         global $prefixeTable;
 
-        $query = "CREATE TABLE `" . $prefixeTable . "contests` (
+        pwg_query("CREATE TABLE `" . $prefixeTable . "contests` (
                 `id` INT NOT NULL AUTO_INCREMENT ,
                 `name` VARCHAR( 255 ) NOT NULL ,
@@ -30 +32 @@
                 `summary` TEXT NULL ,
                 `presentation` TEXT NULL ,
-                `presentation_display` VARCHAR( 255 ) NULL ,
                 `rules` TEXT NULL ,
-                `rules_display` VARCHAR( 255 ) NULL ,
                 `prices` TEXT NULL ,
-                `prices_display` VARCHAR( 255 ) NULL ,
-                `final` TEXT NULL ,
-                `final_display` VARCHAR( 255 ) NULL ,
+                `final` TEXT NULL 
                 PRIMARY KEY ( `id` )
-        );";
-        pwg_query($query);
+        );");
         
-        $query = "CREATE TABLE `" . $prefixeTable . "contests_results` (
+        pwg_query("CREATE TABLE `" . $prefixeTable . "contests_results` (
                 `image_id` INT NOT NULL ,
                 `contest_id` INT NOT NULL ,
@@ -48 +45 @@
                 `comment` TEXT NULL,
                 UNIQUE ( `image_id` , `contest_id` )
-        );";
-        pwg_query($query);
+        );");
         
-        $query = "INSERT INTO " . CONFIG_TABLE . "(param,value,comment) VALUES('ContestResults', '" . default_config . "', 'Parametres du plugin ContestResults');";
-        pwg_query($query);
+        pwg_query("INSERT INTO " . CONFIG_TABLE . "(param,value,comment) VALUES('ContestResults', '" . default_config . "', 'Parametres du plugin ContestResults');");
 }
 
+// Activation
 function plugin_activate(){
-        global $conf;
+        global $conf, $prefixeTable;
 
-        // compatibilité avec les versions < 1.1
-        if(!isset($conf['ContestResults'])){
-                $query = "INSERT INTO " . CONFIG_TABLE . "(param,value,comment) VALUES('ContestResults', '" . default_config . "', 'Parametres du plugin ContestResults');";
-                pwg_query($query);
+        // 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`");
+                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`");
         }
 }
 
-function plugin_uninstall(){
+// Désinstallation
+function plugin_uninstall() {
         global $prefixeTable;
 
-        $query = "DROP TABLE `" . $prefixeTable . "contests`;";
-        pwg_query($query);
-        
-        $query = "DROP TABLE `" . $prefixeTable . "contests_results`;";
-        pwg_query($query);
-        
-        $query = "DELETE FROM " . CONFIG_TABLE . " WHERE `param` = 'ContestResults';";
-        pwg_query($query);
+        pwg_query("DROP TABLE `" . $prefixeTable . "contests`;");
+        pwg_query("DROP TABLE `" . $prefixeTable . "contests_results`;");
+        pwg_query("DELETE FROM " . CONFIG_TABLE . " WHERE `param` = 'ContestResults';");
 }
 ?>