Changeset 756:5127beea4a3a for admin/services.php

Timestamp:

11/10/11 16:12:01 (14 years ago)

Author:

Dsls <dsls@…>

Branch:

formfilters

Message:

• Adapted comments.php do new filters
• added author filter, with autocompletion
• added comment_author parameter to dcBlog::getComments
• removed jquery.autocomplete
• added jquery UI (should be refined, this is quite raw...)
• added dcPager::jqueryUI
• adapted tags plugin to new jquery ui autocomplete

File:

• admin/services.php (modified) (2 diffs)

admin/services.php

@@ -25 +25 @@
 $core->rest->addFunction('delMeta',array('dcRestMethods','delMeta'));
 $core->rest->addFunction('setPostMeta',array('dcRestMethods','setPostMeta'));
+$core->rest->addFunction('searchCommentAuthor',array('dcRestMethods','searchCommentAuthor'));
 $core->rest->addFunction('searchMeta',array('dcRestMethods','searchMeta'));
 
@@ -393 +394 @@
           return $rsp;
      }
+
+     public static function searchCommentAuthor($core,$get)
+     {
+          $q = !empty($get['q']) ? strtoupper($get['q']) : null;
+          
+          $strReq = 'SELECT DISTINCT C.comment_author '.
+               'FROM '.$core->prefix.'comment C '.
+               'INNER JOIN '.$core->prefix.'post P on C.post_id = P.post_id '.
+               'WHERE P.blog_id = \''.$core->blog->id.'\' '.
+               'AND UPPER(comment_author) like \'%'.$core->con->escape($q).'%\''
+               ;
+          //echo $strReq;
+          $rs = $core->con->select($strReq);
+          $rsp = new xmlTag();
+          
+          while ($rs->fetch())
+          {
+               $author = new xmlTag('author');
+               $author->name=$rs->comment_author;
+               $rsp->insertNode($author);
+          }
+          
+          return $rsp;
+     }
+
 }
 ?>