Changeset 8946 for extensions/ConcoursPhoto/admin/audit.php
- Timestamp:
- Jan 27, 2011, 8:46:55 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
extensions/ConcoursPhoto/admin/audit.php
r4428 r8946 17 17 $user_id = 0; 18 18 19 //echo "USER_ID=".$user_id;19 echo "USER_ID=".$user_id; 20 20 21 21 // Get the concours id if present … … 29 29 $users = array(); // contain {id;username} or each 30 30 $groups = $concours->concours_infos['groups']; 31 $query = 'SELECT user_id, username FROM ' . USER_GROUP_TABLE31 $query = 'SELECT distinct(user_id), username FROM ' . USER_GROUP_TABLE 32 32 .' INNER JOIN ' . USERS_TABLE .' ON id = user_id' 33 .($groups != NULL ? ' WHERE group_id = '.$groups : '') 33 .($groups != NULL ? ' WHERE group_id IN ('.$groups.')' : '') 34 // = '.$groups : '') 34 35 .' ORDER BY username ASC' 35 36 .';'; … … 55 56 } 56 57 58 // Add the guest list (if coucours OK for guest) 59 $ipguest = $concours->get_guest_list(); 60 if ($concours->concours_infos['guest']) 61 { 62 foreach ( $ipguest as $i => $userid ) //on parcours le tableau 63 { 64 $template->append('user_list', 65 array( 'ID' => 'G'.$i, //$userid['user_id'], 66 'NAME' => $userid, 67 'SELECTED' => ($user_id == 'G'.$i ? 'selected' : ''))); 68 } 69 } 57 70 58 71 // Send concours info to template … … 70 83 // Step 3 : Display theses informations 71 84 72 73 // nb of users who vote for each image (for a selected concours 74 $query = 'SELECT img_id, COUNT(DISTINCT user_id) AS NBVOTE FROM ' . CONCOURS_DATA_TABLE 75 .' WHERE id_concours = '.($concours_id !== null ? $concours_id : $this->concours_id ) 76 .' GROUP BY img_id ' 77 .';'; 78 79 $result = pwg_query($query); 80 $nbvotes = array(); 81 while ($row = mysql_fetch_assoc($result)) 82 { 83 $nbvotes[$row['img_id']] = $row['NBVOTE']; 84 } 85 // Get the nb of vote for the concours 86 $nbvotes = $concours->nb_votes_by_img(); 87 85 88 86 89 // Get all the users who have notes for the concours 87 $query = 'SELECT distinct (user_id), USER.username'90 $query = 'SELECT distinct user_id, USER.username' 88 91 .' FROM ' .CONCOURS_DATA_TABLE 89 92 .' INNER JOIN ' . USERS_TABLE.' AS USER on USER.id = user_id' 90 93 .' WHERE id_concours = '.$concours_id 94 // Dont take the guest informations because 95 .' AND user_id <> '.$conf['guest_id'] 91 96 .' ORDER BY username ASC' 92 97 .';'; … … 95 100 $user_list = array(); 96 101 while ($row2 = mysql_fetch_assoc($result)) 97 array_push($user_list, $row2); 98 102 // Dont take the guest informations because 103 // if ($row2['user_id'] != $conf['guest_id']) 104 array_push($user_list, $row2); 99 105 100 106 … … 185 191 $user_note = array(); 186 192 $globalnote = 0; 187 if ($user_id != 0) // for user 193 echo "USER=".$user_id."\n"; 194 if (!is_numeric($user_id) OR $user_id != 0) // for user 195 { 196 echo "USERNON0=".$user_id."\n"; 197 $pos = strpos($user_id, 'G'); 198 if ($pos === false) 199 { 200 $globalnote = $concours->get_img_globalnote_user($row['id'], $concours_id, $user_id); 201 $user_note = $concours->get_img_note_user($row['id'], $concours_id, $user_id); 202 } 203 else 204 { 205 echo "G...".substr($user_id, $pos+1)." = ".substr($user_id, $pos+1)."\n"; 206 echo "IPGUEST=".$ipguest[substr($user_id, $pos+1)]."\n"; 207 $globalnote = $concours->get_img_globalnote_user($row['id'], $concours_id, $conf['guest_id'], $ipguest[substr($user_id, $pos+1)]); 208 $user_note = $concours->get_img_note_user($row['id'], $concours_id, $conf['guest_id'], $ipguest[substr($user_id, $pos+1)]); 209 } 210 } 211 elseif (is_numeric($user_id) AND $user_id == 0) // for user // global 188 212 { 189 $globalnote = $concours->get_img_globalnote_user($row['id'], $concours_id, $user_id); 190 $user_note = $concours->get_img_note_user($row['id'], $concours_id, $user_id); 191 } 192 else // global 193 { 194 foreach ($user_list as $userid) 195 $globalnote += $concours->get_img_globalnote_user($row['id'], null, $userid['user_id']); 196 } 213 echo "USER00=".$user_id."\n"; 214 215 foreach ($user_list as $i => $userid) 216 $globalnote += $concours->get_img_globalnote_user($row['id'], null, $userid['user_id']); 217 218 foreach ($ipguest as $i => $ipguestt) 219 { 220 $globalnote += $concours->get_img_globalnote_user($row['id'], null, $conf['guest_id'], $ipguestt); 221 } 222 } 197 223 198 224 … … 233 259 234 260 $rang = 1; 261 $previousNote = $previousMoy = 0; 262 235 263 foreach ($concours_img as $key => $value) 236 264 { 265 266 // Check the exaequos 267 if ($concours->my_config['check_exaequo']) 268 { 269 if ( ($concours->concours_infos['method'] == 1 // total 270 AND ($concours_img[$key]['note'] == $previousNote)) 271 OR ($concours->concours_infos['method'] == 2 // moyenne 272 AND ($concours_img[$key]['moyenne'] == $previousMoy))) 273 { 274 $rang --; 275 276 } 277 } 278 // echo "RANG=".$rang."\n"; 237 279 $concours_img[$key]['rang'] = $rang; 238 $rang++;239 280 240 281 $template->append( 'concours_note', array( … … 251 292 252 293 )); 294 $rang++; 295 296 $previousNote = $concours_img[$key]['note']; 297 $previousMoy = $concours_img[$key]['moyenne']; 253 298 } 254 299
Note: See TracChangeset
for help on using the changeset viewer.