| 0,0 → 1,153 |
|---|
| <?php |
| /************************* |
| Coppermine Photo Gallery |
| ************************ |
| Copyright (c) 2003-2005 Coppermine Dev Team |
| v1.1 originaly written by Gregory DEMAR |
| |
| This program is free software; you can redistribute it and/or modify |
| it under the terms of the GNU General Public License as published by |
| the Free Software Foundation; either version 2 of the License, or |
| (at your option) any later version. |
| ******************************************** |
| Coppermine version: 1.3.3 |
| $Source: /cvsroot/coppermine/stable/reviewcom.php,v $ |
| $Revision: 1.6 $ |
| $Author: gaugau $ |
| $Date: 2005/04/19 03:17:11 $ |
| **********************************************/ |
| |
| define('IN_COPPERMINE', true); |
| define('REVIEWCOM_PHP', true); |
| |
| require('include/init.inc.php'); |
| |
| if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__); |
| // Delete comments if form is posted |
| $nb_com_del = 0; |
| if (isset($HTTP_POST_VARS['cid_array'])) { |
| $cid_array = $HTTP_POST_VARS['cid_array']; |
| $cid_set = ''; |
| foreach ($cid_array as $cid) |
| $cid_set .= ($cid_set == '') ? '(' . $cid : ', ' . $cid; |
| $cid_set .= ')'; |
| |
| db_query("DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE msg_id IN $cid_set"); |
| $nb_com_del = mysql_affected_rows(); |
| } |
| |
| $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE 1"); |
| $nbEnr = mysql_fetch_array($result); |
| $comment_count = $nbEnr[0]; |
| |
| if (!$comment_count) cpg_die(INFORMATION , $lang_reviewcom_php['no_comment'], __FILE__, __LINE__); |
| |
| $start = isset($HTTP_GET_VARS['start']) ? (int)$HTTP_GET_VARS['start'] : 0; |
| $count = isset($HTTP_GET_VARS['count']) ? $HTTP_GET_VARS['count'] : 25; |
| $next_target = $PHP_SELF . '?start=' . ($start + $count) . '&count=' . $count; |
| $prev_target = $PHP_SELF . '?start=' . max(0, $start - $count) . '&count=' . $count; |
| $s50 = $count == 50 ? 'selected' : ''; |
| $s75 = $count == 75 ? 'selected' : ''; |
| $s100 = $count == 100 ? 'selected' : ''; |
| |
| if ($start + $count < $comment_count) { |
| $next_link = "<a href=\"$next_target\"><b>{$lang_reviewcom_php['see_next']}</b></a> - "; |
| } else { |
| $next_link = ''; |
| } |
| |
| if ($start > 0) { |
| $prev_link = "<a href=\"$prev_target\"><b>{$lang_reviewcom_php['see_prev']}</b></a> - "; |
| } else { |
| $prev_link = ''; |
| } |
| |
| pageheader($lang_reviewcom_php['title']); |
| starttable(-1, $lang_reviewcom_php['title'], 3); |
| echo <<<EOT |
| <form action="$PHP_SELF?start=$start&count=$count" method="post"> |
| |
| EOT; |
| |
| if ($nb_com_del > 0) { |
| $msg_txt = sprintf($lang_reviewcom_php['n_comm_del'], $nb_com_del); |
| echo <<<EOT |
| <tr> |
| <td class="tableh2" colspan="3" align="center"> |
| <br /><b>$msg_txt</b><br /><br /> |
| </td> |
| </tr> |
| |
| EOT; |
| } |
| |
| echo <<<EOT |
| <tr> |
| <td class="tableb" colspan="3"> |
| $prev_link |
| $next_link |
| <b>{$lang_reviewcom_php['n_comm_disp']}</b> |
| <select onChange="if(this.options[this.selectedIndex].value) window.location.href='$PHP_SELF?start=$start&count='+this.options[this.selectedIndex].value;" name="count" class="listbox"> |
| <option value="25">25</option> |
| <option value="50" $s50>50</option> |
| <option value="75" $s75>75</option> |
| <option value="100" $s100>100</option> |
| </select> |
| </td> |
| </tr> |
| |
| EOT; |
| |
| $result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, {$CONFIG['TABLE_COMMENTS']}.pid as pid, aid, filepath, filename, url_prefix, pwidth, pheight FROM {$CONFIG['TABLE_COMMENTS']}, {$CONFIG['TABLE_PICTURES']} WHERE {$CONFIG['TABLE_COMMENTS']}.pid = {$CONFIG['TABLE_PICTURES']}.pid ORDER BY msg_id DESC LIMIT $start, $count"); |
| |
| while ($row = mysql_fetch_array($result)) { |
| $thumb_url = get_pic_url($row, 'thumb'); |
| if (!is_image($row['filename'])) { |
| $image_info = getimagesize($thumb_url); |
| $row['pwidth'] = $image_info[0]; |
| $row['pheight'] = $image_info[1]; |
| } |
| $image_size = compute_img_size($row['pwidth'], $row['pheight'], $CONFIG['alb_list_thumb_size']); |
| $thumb_link = 'displayimage.php?pos=' . - $row['pid']; |
| $msg_date = localised_date($row['msg_date'], $comment_date_fmt); |
| echo <<<EOT |
| <tr> |
| <td colspan="2" class="tableh2" valign="top"> |
| <table cellpadding="0" cellspacing="0" border ="0"> |
| <tr> |
| <td><input name="cid_array[]" type="checkbox" value="{$row['msg_id']}"> |
| <td><img src="images/spacer.gif" width="5" height="1" /><br/></td> |
| <td><b>{$row['msg_author']}</b> - {$msg_date}</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| <tr> |
| <td class="tableb" valign="top" width="100%"> |
| {$row['msg_body']} |
| </td> |
| <td class="tableb" align="center"> |
| <a href="$thumb_link" target="_blank"><img src="$thumb_url" {$image_size['geom']} class="image" border="0"><br /></a> |
| </td> |
| </tr> |
| |
| EOT; |
| flush(); |
| } |
| |
| mysql_free_result($result); |
| |
| echo <<<EOT |
| <tr> |
| <td colspan="3" align="center" class="tablef"> |
| <input type="submit" value="{$lang_reviewcom_php['del_comm']}" class="button"> |
| </td> |
| </form> |
| </tr> |
| |
| EOT; |
| endtable(); |
| pagefooter(); |
| ob_end_flush(); |
| |
| ?> |