Changeset 8946 for extensions/ConcoursPhoto/publish.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/publish.php (modified) (5 diffs)

extensions/ConcoursPhoto/publish.php

@@ -10 +10 @@
 $ap_id = explode('concours/' , $_SERVER['REQUEST_URI']);
 $id_concours = $ap_id[1];
+
+$user['ipguest'] = null;
+if (is_a_guest())
+{
+    if (isset($_SERVER['HTTP_X_FORWARDED_FOR']))
+        $IP = $_SERVER['HTTP_X_FORWARDED_FOR']; 
+    elseif(isset($_SERVER['HTTP_CLIENT_IP']))   
+        $IP = $_SERVER['HTTP_CLIENT_IP'];   
+    else
+        $IP = $_SERVER['REMOTE_ADDR'];  
+         
+    // store ip
+    $user['ipguest'] = $IP;
+}
+        
+
 
 $concours = new Concours($id_concours);
@@ -34 +50 @@
                 .' INNER JOIN '.CATEGORIES_TABLE.' AS cat ON ic.category_id = cat.id'
                 .' INNER JOIN '.CONCOURS_RESULT_TABLE.' AS conc ON conc.img_id = img.id'
-                .' WHERE ic.category_id = '.$concours->concours_infos['category'];
+                .' WHERE ic.category_id = '.$concours->concours_infos['category']
+                .' AND conc.id_concours = '.$concours->concours_infos['id']
+        ;
 
 if ($concours->concours_infos['method'] == 1)   // total
@@ -45 +63 @@
 $result = pwg_query($query);
 $rang = 1;
+$previousNote = $previousMoy = 0;
 while ($row = mysql_fetch_assoc($result))
 {
@@ -76 +95 @@
         unset_make_full_url();
 
+    // Check the exaequos
+    if ($concours->my_config['check_exaequo'])
+    {
+        if ( ($concours->concours_infos['method'] == 1  // total
+               AND ($row['note'] == $previousNote))
+             OR  ($concours->concours_infos['method'] == 2      // moyenne
+                  AND ($row['moyenne'] == $previousMoy)))
+        {
+//            echo "Rang=".$rang."\n";
+            $rang --;
+            
+        }
+    }
+
         $template->append( 'concours_note', array(
                         'img_id' => $row['id'],
@@ -87 +120 @@
                         'moyenne'       => ($row['moyenne'] == 0 ? 'N/A' :$row['moyenne']),
                         'nbvotant'      => $row['nbvotant'],
-                        'usernote'      => $concours->get_img_globalnote_user($row['id'])
+                        'usernote'      => $concours->get_img_globalnote_user($row['id'], null, null, $user['ipguest'])
                         
                 ));
-        $rang ++;
+    $rang ++;
+    
+//    echo "Rang=".$rang."\n";
+    $previousNote = $row['note'];
+    $previousMoy = $row['moyenne'];
 
 }