source: trunk/include/picture_comment.inc.php @ 1860

Last change on this file since 1860 was 1860, checked in by rvelices, 17 years ago
  • bug 654: sql error on user comment (since my commit 1849)
  • languages: english corrections + keep lang files sorted by key
  • admin multi view correction: language was not always properly changed
  • refactor function get_computed_categories (with rub's blessing)
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
File size: 5.7 KB
Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | PhpWebGallery - a PHP based picture gallery                           |
4// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
5// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
6// +-----------------------------------------------------------------------+
7// | file          : $Id: picture_comment.inc.php 1860 2007-02-26 23:52:22Z rvelices $
8// | last update   : $Date: 2007-02-26 23:52:22 +0000 (Mon, 26 Feb 2007) $
9// | last modifier : $Author: rvelices $
10// | revision      : $Revision: 1860 $
11// +-----------------------------------------------------------------------+
12// | This program is free software; you can redistribute it and/or modify  |
13// | it under the terms of the GNU General Public License as published by  |
14// | the Free Software Foundation                                          |
15// |                                                                       |
16// | This program is distributed in the hope that it will be useful, but   |
17// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
18// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
19// | General Public License for more details.                              |
20// |                                                                       |
21// | You should have received a copy of the GNU General Public License     |
22// | along with this program; if not, write to the Free Software           |
23// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
24// | USA.                                                                  |
25// +-----------------------------------------------------------------------+
26
27/**
28 * This file is included by the picture page to manage user comments
29 *
30 */
31
32// the picture is commentable if it belongs at least to one category which
33// is commentable
34$page['show_comments'] = false;
35foreach ($related_categories as $category)
36{
37  if ($category['commentable'] == 'true')
38  {
39    $page['show_comments'] = true;
40    break;
41  }
42}
43
44if ( $page['show_comments'] and isset( $_POST['content'] ) )
45{
46  if ( $user['is_the_guest'] and !$conf['comments_forall'] )
47  {
48    die ('Session expired');
49  }
50
51  $comm = array(
52    'author' => trim( stripslashes(@$_POST['author']) ),
53    'content' => trim( stripslashes($_POST['content']) ),
54    'image_id' => $page['image_id'],
55   );
56
57  include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
58 
59  $comment_action = insert_user_comment($comm, @$_POST['key'], $infos );
60
61  switch ($comment_action)
62  {
63    case 'moderate':
64      array_push( $infos, $lang['comment_to_validate'] );
65    case 'validate':
66      array_push( $infos, $lang['comment_added']);
67      break;
68    case 'reject': 
69      set_status_header(403);
70      array_push($infos, l10n('comment_not_added') );
71      break;
72    default:
73      trigger_error('Invalid comment action '.$comment_action, E_USER_WARNING);
74  }
75
76  foreach ($infos as $info)
77  {
78    $template->assign_block_vars(
79        'information',
80        array( 'INFORMATION'=>$info )
81      );
82  }
83
84  // allow plugins to notify what's going on
85  trigger_action( 'user_comment_insertion',
86      array_merge($comm, array('action'=>$comment_action) )
87    );
88}
89
90
91if ($page['show_comments'])
92{
93  // number of comment for this picture
94  $query = 'SELECT COUNT(*) AS nb_comments';
95  $query.= ' FROM '.COMMENTS_TABLE.' WHERE image_id = '.$page['image_id'];
96  $query.= " AND validated = 'true'";
97  $query.= ';';
98  $row = mysql_fetch_array( pwg_query( $query ) );
99
100  // navigation bar creation
101  if (!isset($page['start']))
102  {
103    $page['start'] = 0;
104  }
105
106  $page['navigation_bar'] = create_navigation_bar(
107    duplicate_picture_url(array(), array('start')),
108    $row['nb_comments'],
109    $page['start'],
110    $conf['nb_comment_page'],
111    true // We want a clean URL
112    );
113
114  $template->assign_block_vars(
115    'comments',
116    array(
117      'NB_COMMENT' => $row['nb_comments'],
118      'NAV_BAR' => $page['navigation_bar'],
119      )
120    );
121
122  if ($row['nb_comments'] > 0)
123  {
124    $query = '
125SELECT id,author,date,image_id,content
126  FROM '.COMMENTS_TABLE.'
127  WHERE image_id = '.$page['image_id'].'
128    AND validated = \'true\'
129  ORDER BY date ASC
130  LIMIT '.$page['start'].', '.$conf['nb_comment_page'].'
131;';
132    $result = pwg_query( $query );
133
134    while ($row = mysql_fetch_array($result))
135    {
136      $template->assign_block_vars(
137        'comments.comment',
138        array(
139          'COMMENT_AUTHOR' => empty($row['author'])
140            ? $lang['guest']
141            : $row['author'],
142
143          'COMMENT_DATE' => format_date(
144            $row['date'],
145            'mysql_datetime',
146            true),
147
148          'COMMENT' => trigger_event('render_comment_content',$row['content']),
149          )
150        );
151
152      if (is_admin())
153      {
154        $template->assign_block_vars(
155          'comments.comment.delete',
156          array(
157            'U_COMMENT_DELETE' =>
158              add_url_params(
159                    $url_self,
160                    array(
161                      'action'=>'delete_comment',
162                      'comment_to_delete'=>$row['id']
163                    )
164                )
165            )
166          );
167      }
168    }
169  }
170
171  if (!$user['is_the_guest']
172      or ($user['is_the_guest'] and $conf['comments_forall']))
173  {
174    include_once(PHPWG_ROOT_PATH.'include/functions_comment.inc.php');
175    $key = get_comment_post_key($page['image_id']);
176    $content = '';
177    if ('reject'===@$comment_action)
178    {
179      $content = htmlspecialchars($comm['content']);
180    }
181    $template->assign_block_vars('comments.add_comment',
182        array(
183          'KEY' => $key,
184          'CONTENT' => $content
185        ));
186    // display author field if the user is not logged in
187    if ($user['is_the_guest'])
188    {
189      $template->assign_block_vars(
190        'comments.add_comment.author_field', array()
191        );
192    }
193  }
194}
195
196?>
Note: See TracBrowser for help on using the repository browser.