[wp-hackers] Advanced Search + spam filter

Robin Chang amorphous123 at gmail.com
Wed Mar 25 15:29:40 GMT 2009


Hi, I was wondering about how would designing a more intricate and
thoughtful searching mechanism be? Appreciated? No comment?What I had in
mind was that there would be a new addition to the current database tables
so that the administrator could prioritize a certain post to show up on the
top more likely. Also so that commenters could help to prioritize it. I was
also thinking of creating a new table that would keep track of what people
search for and click on, to better help people find what they want. The
basic meta options of looking through the title, body, by who, and by date
would also be included. I was also considering a type of fuzzy logic that
would help people find what they want, such in a way that Google does "did
you mean...".

I was also wondering how a better spam filter would help. I know I have the
problem of spam bots coming and spamming, thus I had to disable comments. I
know that adding a image detection would help, but I did not want to resort
to that as it would discourage people to comment. (But then again, one might
consider that if they're not willing to spend 5 seconds typing in the words
then their words shouldn't be viewed by the world wide web =P.) I was
thinking of implementing a search-feature as I mentioned above that, one
that would keep track of what the moderator has marked as "spam" and try to
come up with some semantics or patterns that would better distinguish
comments from with merit or worthless. I was also considering that if a
person was going to moderate it, that certain comments prioritize by what
the content. If it's obviously spam or meaningless trash, it would be
automatically deleted (or put on the bottom of the list depending whether or
not the user puts that option). If it has certain keywords or "spam words",
it would be put lower onto the list.

Thanks guys for your time reading this! I appreciate any comments I could
get back ^^;

On Wed, Mar 25, 2009 at 5:00 AM, <wp-hackers-request at lists.automattic.com>wrote:

> Send wp-hackers mailing list submissions to
>        wp-hackers at lists.automattic.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.automattic.com/mailman/listinfo/wp-hackers
> or, via email, send a message with subject or body 'help' to
>        wp-hackers-request at lists.automattic.com
>
> You can reach the person managing the list at
>        wp-hackers-owner at lists.automattic.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of wp-hackers digest..."
>
>
> Today's Topics:
>
>   1. Re: Dispay none for different categories (Mike Schinkel)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 25 Mar 2009 02:03:32 -0500 (CDT)
> From: Mike Schinkel <mikeschinkel at newclarity.net>
> Subject: Re: [wp-hackers] Dispay none for different categories
> To: wp-hackers at lists.automattic.com
> Message-ID: <EMEWEMEW2_DELIMl2O23Wcfaaee89e02b66e8d11807,
>        mikeschinkel at newclarity.net, 2938828.6661237964610325.J>
> Content-Type: text/plain; charset=utf-8
>
> Frank:
>
> I'm still not 100% sure exactly what you want since you didn't get examples
> of categories, but I think the following *might* give you what you need. I
> tested it in the templates functions.php file but it will likely work the
> same in a plugin.  I used a hypothetical addition to the were clause that
> limits to categories with the slugs 'news', 'charity', and 'events':
>
>   add_filter('list_terms_exclusions','my_list_terms_exclusions');
>   function my_list_terms_exclusions($args) {
>      $where = " AND t.slug IN ('news','charity','events')";
>      return $where;
>   }
>
> This is the SQL statement that it is adding to the WHERE clause:
>
>  SELECT
>    t.term_id,
>    t.name,
>    t.slug,
>    t.term_group,
>    tt.term_taxonomy_id,
>    tt.term_id,
>    tt.taxonomy,
>    tt.description,
>    tt.parent,
>    tt.count
>  FROM
>    wp_terms AS t
>    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
>  WHERE
>    tt.taxonomy IN ('category') AND
>    tt.count > 0
>
> Thus the SQL statement will look conceptually like this when the above
> filter is in place:
>
>  SELECT
>    t.term_id,
>    t.name,
>    t.slug,
>    t.term_group,
>    tt.term_taxonomy_id,
>    tt.term_id,
>    tt.taxonomy,
>    tt.description,
>    tt.parent,
>    tt.count
>  FROM
>    wp_terms AS t
>    INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id
>  WHERE
>    tt.taxonomy IN ('category') AND
>    tt.count > 0 AND
>    t.slug IN ('news','charity','events')
>
> Of course that filter might cause unexpected side effects elsewhere so
> you'll need to test it throughout and also you might need to ensure that the
> action is only called where it is needed.
>
> Let me know if this is actually what you needed or if not please explain
> why not and give some examples of what you'd want to see.
>
> Hope this helps.
>
> -Mike Schinkel
> http://mikeschinkel.com/
>
> ----- Original Message -----
> From: "Frank Bueltge" <frank at bueltge.de>
> To: wp-hackers at lists.automattic.com
> Sent: Tuesday, March 24, 2009 5:04:02 PM GMT -05:00 US/Canada Eastern
> Subject: Re: [wp-hackers] Dispay none for different categories
>
> Soory for my bad english.
>
> On the post-page in admin, the meta box category list all categories with
> wp_category_checklist().
> I will exclude several categories on this list. All categories have an id
> and a class, so it is possible exclude with javascipt or css. I will exlude
> several categories in the select-query of wp_category_checklist().
>
> Thanks a lot
>
>
> On Tue, Mar 24, 2009 at 6:32 PM, Mike Schinkel
> <mikeschinkel at newclarity.net>wrote:
>
> > Frank:
> >
> > I'm not clear on what you are trying to do exactly. Can you explain it
> > differently?
> >
> > -Mike Schinkel
> > http://mikeschinkel.com/
> >
> > ----- Original Message -----
> > From: "Frank Bueltge" <frank at bueltge.de>
> > To: wp-hackers at lists.automattic.com
> > Sent: Tuesday, March 24, 2009 7:51:05 AM GMT -05:00 US/Canada Eastern
> > Subject: [wp-hackers] Dispay none for different categories
> >
> > Hello,
> >
> > any one have a idea?
> > I will display none for a categories in edit post on admin-area.
> > I have not found a hook for the select and think, it is possible to
> display
> > none with css or javascript an load admin.
> > A this is not ao easy for a users with many categories in wordpress.
> >
> > It is possible to hook an the meta box for categories and reduce the
> select
> > for categories ind the meta box on edit post?
> >
> > Thanks for your ideas
> > Best regards
> > Frank
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> >
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
>
> ------------------------------
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
>
> End of wp-hackers Digest, Vol 50, Issue 66
> ******************************************
>


More information about the wp-hackers mailing list