Changeset 3263:a2e2eabd0f86

Timestamp:

07/03/16 12:47:07 (9 years ago)

Author:

franck <carnet.franck.paul@…>

Branch:

default

Message:

Add email and web site filters on comments list (admin), closes #995

Files:

• admin/comments.php (modified) (4 diffs)
• inc/core/class.dc.blog.php (modified) (1 diff)

admin/comments.php

@@ -54 +54 @@
 /* Get comments
 -------------------------------------------------------- */
-$author = isset($_GET['author']) ? $_GET['author'] : '';
-$status = isset($_GET['status']) ?      $_GET['status'] : '';
-$type = !empty($_GET['type']) ?         $_GET['type'] : '';
-$sortby = !empty($_GET['sortby']) ?     $_GET['sortby'] : 'comment_dt';
-$order = !empty($_GET['order']) ?       $_GET['order'] : 'desc';
-$ip = !empty($_GET['ip']) ?             $_GET['ip'] : '';
+$author = isset($_GET['author']) ? $_GET['author'] : '';
+$status = isset($_GET['status']) ? $_GET['status'] : '';
+$type   = !empty($_GET['type']) ? $_GET['type'] : '';
+$sortby = !empty($_GET['sortby']) ? $_GET['sortby'] : 'comment_dt';
+$order  = !empty($_GET['order']) ? $_GET['order'] : 'desc';
+$ip     = !empty($_GET['ip']) ? $_GET['ip'] : '';
+$email  = !empty($_GET['email']) ? $_GET['email'] : '';
+$site   = !empty($_GET['site']) ? $_GET['site'] : '';
 
 $with_spam = $author || $status || $type || $sortby != 'comment_dt' || $order != 'desc' || $ip;
@@ -108 +110 @@
 if ($ip) {
      $params['comment_ip'] = $ip;
+     $show_filters = true;
+}
+
+# - email filter
+if ($email) {
+     $params['comment_email'] = $email;
+     $show_filters = true;
+}
+
+# - site filter
+if ($site) {
+     $params['comment_site'] = $site;
      $show_filters = true;
 }
@@ -237 +251 @@
      '<p><label for="ip" class="ib">'.__('IP address:').'</label> '.
      form::field('ip',20,39,html::escapeHTML($ip)).'</p>'.
+     '<p><label for="email" class="ib">'.__('Email:').'</label> '.
+     form::field('email',20,255,html::escapeHTML($email)).'</p>'.
+     '<p><label for="site" class="ib">'.__('Web site:').'</label> '.
+     form::field('site',20,255,html::escapeHTML($site)).'</p>'.
      '</div>'.
 
@@ -276 +294 @@
      form::hidden(array('page'),$page).
      form::hidden(array('nb'),$nb_per_page).
+     form::hidden(array('email'),html::escapeHTML(preg_replace('/%/','%%',$email))).
+     form::hidden(array('site'),html::escapeHTML(preg_replace('/%/','%%',$site))).
      '</div>'.
 

inc/core/class.dc.blog.php

@@ -2039 +2039 @@
           }
 
+          if (isset($params['comment_email'])) {
+               $comment_email = $this->con->escape(str_replace('*','%',$params['comment_email']));
+               $strReq .= "AND comment_email LIKE '".$comment_email."' ";
+          }
+
           if (isset($params['comment_site'])) {
                $comment_site = $this->con->escape(str_replace('*','%',$params['comment_site']));