Changeset 4260 for extensions/ConcoursPhoto/include/Concours.class.php

Timestamp:

Nov 12, 2009, 9:56:21 PM (14 years ago)

Author:

tiico

Message:

[ConcoursPhoto] Add global note under thumb (+ param) and in concours image page; Correct author masking

File:

• extensions/ConcoursPhoto/include/Concours.class.php (modified) (7 diffs)

extensions/ConcoursPhoto/include/Concours.class.php

@@ -724 +724 @@
 }
 //  END DEBUG
+
+
+        // disable author name on image which are present in a concours.
+        // check the categories where the current image is present and disable the author name
+                if ($this->my_config['mask_author'] && $this->my_config['mask_author'] == true)
+                {
+                        // Get all categories where the current image is present
+                        $query = '
+                        SELECT category_id,uppercats,commentable,global_rank
+                          FROM '.IMAGE_CATEGORY_TABLE.'
+                                INNER JOIN '.CATEGORIES_TABLE.' ON category_id = id
+                          WHERE image_id = '.$page['image_id'].'
+                          ;';
+//                     echo $query;
+                        $result = pwg_query($query);
+                        $related_categories = array();
+                        while ($row = mysql_fetch_array($result))
+                        {
+                          array_push($related_categories, $row['category_id']);
+                        }
+                        //
+            //echo related_categories;
+            if (count($related_categories))
+            {
+                // Request for all concours prepared & actived on each categories
+                $query = '
+                    SELECT *
+                    FROM ' . CONCOURS_TABLE .' 
+                    WHERE category IN ('.implode(',', $related_categories).')
+                    AND time_to_sec(TIMEDIFF(now(), end_date)) < 0
+                ';
+        //                echo $query;
+                $result = pwg_query($query);
+                // If one or more concours are found, the author name is masked
+                if ($result && mysql_fetch_assoc($result))
+                    $template->assign('INFO_AUTHOR',l10n('concours_img_author'));
+            }
+                }
+
+        // End disable author name
+
+
                 if (($page['section']) == 'categories' AND !empty($page['category']))
                 {
@@ -729 +771 @@
                         //------------
                         // Step 1
-            
+
+/*            
             if ($this->my_config['mask_author'] && $this->my_config['mask_author'] == true)
             {
@@ -744 +787 @@
                     $template->assign('INFO_AUTHOR',l10n('concours_img_author'));
             }
-
+*/
             
                         $query = '
@@ -907 +950 @@
                                 $template->assign( 'concours_infos', array(
                                                         'name'  => $concours['name'],
-                                                        'descr' => $concours['descr']
+                                                        'descr' => $concours['descr'],
+                            'note'  => $this->get_img_globalnote_user($page['current_item'], $concours['id'])
                                                                 ));
                                 
@@ -1446 +1490 @@
         if ($menu->get_id() != 'menubar' OR $this->my_config['active_menubar'] == false)
           return;
-        $menu->register_block( new RegisteredBlock( 'CONCOURS_menu', 'Polls', 'MYPOLLS'));
+        $menu->register_block( new RegisteredBlock( 'CONCOURS_menu', 'concours', 'ConcoursPhoto'));
         }
 
@@ -1546 +1590 @@
                 global $page;
                 
+                
                 if (isset($page['section']) and $page['section'] == 'concours')
                 {
@@ -1553 +1598 @@
 
         
+  // Show the global note under the thumbnail
+  function thumbnail_note($tpl_var) 
+  {
+
+        global $page;
+        $this->get_user_groups();
+
+    if ($this->my_config['thumb_note'] && $this->my_config['thumb_note'] == true)
+    {
+        $concours = array();
+        if (($page['section']) == 'categories' AND !empty($page['category']))
+        {
+            $query = '
+                SELECT *
+                FROM ' . CONCOURS_TABLE .' 
+                WHERE category =' . $page['category']['id'] . '
+                AND time_to_sec(TIMEDIFF(begin_date,now())) < 0
+                AND time_to_sec(TIMEDIFF(now(), end_date)) < 0
+                ';
+
+            $result = pwg_query($query);
+    if ($this->debug) echo $query."\n";
+            while ($row = mysql_fetch_assoc($result))
+            {
+                
+                if (!empty($row['groups']))
+                {
+    if ($this->debug)   echo "GROUPS=".$row['groups'];                          
+                    $authorized_groups = explode(',', $row['groups']);
+                    if (array_intersect($this->user_groups, $authorized_groups) == array()) 
+                    {
+    if ($this->debug)   echo "ERROR GROUPS";
+                        continue;
+                    }
+                    $concours = $row;
+                }
+            }
+            if (count($concours))
+            {
+
+                foreach($tpl_var as $cle=>$valeur) {
+                {
+                  $tpl_var[$cle]['NAME'] = $tpl_var[$cle]['NAME'].'<br>&nbsp;'.l10n('thumbnail_global_note').' : '.$this->get_img_globalnote_user($tpl_var[$cle]['ID'], $concours['id']);
+                  }
+                }
+            }
+        }
+    }
+    return $tpl_var;
+  }
+        
+        
 }