Changeset 8946 for extensions/ConcoursPhoto/maintain.inc.php

Timestamp:

Jan 27, 2011, 8:46:55 PM (13 years ago)

Author:

tiico

Message:

Prepare v2.0.0 for Concours photo plugin :

• Add exaequo checking for the result (beta)
• Add EN language
• Correct "concours not displayed" when no group is selected in admin page. Now, concours is available for all registered user (not depending on the group appartenance)
• Add option to allow author to vote for their photos (disable check based on username=authorname)
• Add option to allow user to change the score after a validation
• Add to guest the possibility to vote for a concours (BETA)
• Some correction (code and database structure)

File:

• extensions/ConcoursPhoto/maintain.inc.php (modified) (6 diffs)

extensions/ConcoursPhoto/maintain.inc.php

@@ -27 +27 @@
                                 `groups` varchar(255) default NULL,
                                 `method` smallint(5) default 1 NOT NULL,
+                                `guest` Boolean default FALSE,
                                 
                                 PRIMARY KEY  (`id`)
@@ -59 +60 @@
                                 `datas` longtext default NULL,
                                 `comment` longtext default NULL,                                
+                                `ipguest` longtext default NULL,
                                 PRIMARY KEY  (`id`)
                                 ) DEFAULT CHARSET=utf8;';
@@ -74 +76 @@
                                 `nbvotant` smallint(5) default 0,
                                 
-                                PRIMARY KEY  (`img_id`),
+                                PRIMARY KEY  (`img_id`, `id_concours`),
                                 FOREIGN KEY (`id_concours`) REFERENCES ' . $prefixeTable . 'concours(id)                                
                                 ) DEFAULT CHARSET=utf8;';
@@ -188 +190 @@
   global $prefixeTable;
 
-  // Check if upgrade is needed
+  // Check if upgrade is needed (from 1.0.0)
   $query = 'SHOW FULL COLUMNS FROM ' . $prefixeTable . 'concours_result;';
   $result = array_from_query($query, 'Field');
   if (count($result) < 7)       // only 6 datas on previous database
   {
+    upgrade_concoursresult_from_100();
+  }
+  // Check if upgrade is needed (from 1.0.0)
+  $query = 'SHOW FULL COLUMNS FROM ' . $prefixeTable . 'concours;';
+  $result = array_from_query($query, 'Field');
+  if (count($result) < 10)      // only 6 datas on previous database
+  {
     upgrade_concours_from_100();
   }
@@ -216 +225 @@
 }
 
-// Add new parameter in database in version 2.0.0:
+// Add new parameter in database in version 1.0.1:
 // - moy : moyenne of global note with all participant
 // - nbvotant : nb of vote for an image
 // - method = type of rank calculation (1-> total; 2-> moyenne)
-function upgrade_concours_from_100()
+function upgrade_concoursresult_from_100()
 {
         global $prefixeTable;
@@ -241 +250 @@
 }
 
+// Add new parameter in database in version 2.0.0:
+// - guest : boolean to allow guest to use this function (concours)
+function upgrade_concours_from_100()
+{
+        global $prefixeTable;
+        // Add new parameters
+        $query = 'ALTER TABLE ' . $prefixeTable . 'concours
+        ADD `guest` boolean default FALSE AFTER `method`
+        ;';
+
+        pwg_query($query);
+        // Add new parameters
+        $query = 'ALTER TABLE ' . $prefixeTable . 'concours_data
+        ADD `ipguest` longtext default NULL AFTER `comment`
+        ;';
+
+        pwg_query($query);
+ 
+}
+
 ?>