[geeklog-devtalk] geeklog-devel digest, Vol 1 #482 - 3 msgs

[geeklog-devel-request at lists.geeklog.net]

Send geeklog-devel mailing list submissions to
	geeklog-devel at lists.geeklog.net

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.geeklog.net/listinfo/geeklog-devel
or, via email, send a message with subject or body 'help' to
	geeklog-devel-request at lists.geeklog.net

You can reach the person managing the list at
	geeklog-devel-admin at lists.geeklog.net

When replying, please edit your Subject line so it is more specific
than "Re: Contents of geeklog-devel digest..."


Today's Topics:

   1. Re: GL2 DataAccess Class (Vincent Furia)
   2. About the forum spammer (Dirk Haun)
   3. Re: About the forum spammer (Vincent Furia)

--__--__--

Message: 1
Date: Mon, 17 Jan 2005 13:38:20 -0500
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] GL2 DataAccess Class
Reply-To: geeklog-devel at lists.geeklog.net

I guess I should have been more specific...

There is no way to use criteria to do UPDATEs or DELETEs (criteria
with INSERTs doesn't make much sense).

It is not clear if what behavior specifying the SQL for UDPATEs,
DELETEs and INSERTs will be.  From reading the code it looks like the
SQL will be executed, I'm just not sure if the program will stop with
an error afterwards or throw an exception or just return an empty
result set.

I haven't tested the DAO code under these conditions, but it looks
like something that needs be corrected.

-Vinny


On Mon, 17 Jan 2005 11:41:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> You sure?  It's an easy fix to get around that...but seems the

> updates/deletes should work.

> 

> --Tony

> 

> Vincent Furia wrote:

> 

> >Tony,

> >

> >Another issue with the DAO class is that it seems catered to providing

> >support only for SELECT's.  It won't work for doing INSERT's,

> >UPDATE's, or DELETE's (etc...).

> >

> >-Vinny

> >

> >

> >On Mon, 17 Jan 2005 09:39:04 -0500, Vincent Furia <vfuria at gmail.com> wrote:

> >

> >

> >>Tony,

> >>

> >>Caching between page calls would be great.  But even having a static

> >>variable or something similar to persist between calls to the "find"

> >>method would be a good start (and probably sufficient for most sites).

> >>

> >>-Vinny

> >>

> >>

> >>On Mon, 17 Jan 2005 08:32:53 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:

> >>

> >>

> >>>You mean cache it to memory or to a file.  I'd love to cache it to

> >>>memory but, afaik, it would require php's shared memory which isn't

> >>>enabled by default.

> >>>

> >>>I s'pose if the xml parsing itself if that bad, would could cache a

> >>>php-friendly data structure to a file.

> >>>

> >>>I'm open to this.  I just learned how to profile PHP applications this

> >>>past week so finding poor performing code shouldn't be a problem.

> >>>

> >>>--Tony

> >>>

> >>>Vincent Furia wrote:

> >>>

> >>>

> >>>

> >>>>Tony,

> >>>>

> >>>>Just looking through the DAO to understand everything it is doing

> >>>>better.  I noticed that the "find" method (and the other methods)

> >>>>reloads the named queries from the xml file on every call.  We should

> >>>>look for a way to work around this (i.e. somehow cache the DOMXPath

> >>>>object) so as not to suffer huge penalties for parsing the XML file on

> >>>>every DB call.

> >>>>

> >>>>-Vinny

> >>>>_______________________________________________

> >>>>geeklog-devel mailing list

> >>>>geeklog-devel at lists.geeklog.net

> >>>>http://lists.geeklog.net/listinfo/geeklog-devel

> >>>>

> >>>>

> >>>>

> >>>>

> >>>_______________________________________________

> >>>geeklog-devel mailing list

> >>>geeklog-devel at lists.geeklog.net

> >>>http://lists.geeklog.net/listinfo/geeklog-devel

> >>>

> >>>

> >>>

> >_______________________________________________

> >geeklog-devel mailing list

> >geeklog-devel at lists.geeklog.net

> >http://lists.geeklog.net/listinfo/geeklog-devel

> >

> >

> 

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>


--__--__--

Message: 2
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devel at lists.geeklog.net>
Date: Mon, 17 Jan 2005 21:18:50 +0100
Organization: Terra Software Systems
Subject: [geeklog-devel] About the forum spammer
Reply-To: geeklog-devel at lists.geeklog.net

Found this:

    http://wordpress.org/support/topic.php?id=20956

It's about a known case of comment spamming in weblogs. The author
noticed that all the domains used in the comment spams resolve to the
same IP address, 161.58.59.8

And look what we just got (thanks Tom, thanks SpamX plugin!):


| Please check some helpful info about<A HREF="http://internet-

| poker.fidelityfunding.net/"> internet poker


dirk at terra:dirk> ping fidelityfunding.net
PING fidelityfunding.net (161.58.59.8): 56 data bytes

The nice thing is that he's also setting up bogus "account terminated"
pages (try the above URL).

Anyway, the IP address might be another filter criterion, instead of
having to update the blacklist all the time. Anyone wanting to write a
SpamX module for this?

MT Blacklist is lagging behind, btw. The last few spam posts were only
caught because they contained "texas holdem" - whatever that is, but it
appears in all those posts.

bye, Dirk


-- 
http://www.haun-online.de/
http://www.macosx-faq.de/


--__--__--

Message: 3
Date: Mon, 17 Jan 2005 16:36:39 -0500
From: Vincent Furia <vfuria at gmail.com>
To: geeklog-devel at lists.geeklog.net
Subject: Re: [geeklog-devel] About the forum spammer
Reply-To: geeklog-devel at lists.geeklog.net

Texas Hold'em is type of Poker.  The world poker championship in Vegas
plays Texas Hold'em.  A lot of gambling sites push it, a lot of those
are sketchy, hence the need to block the text.

-Vinny


On Mon, 17 Jan 2005 21:18:50 +0100, Dirk Haun <dirk at haun-online.de> wrote:

> Found this:

> 

>     http://wordpress.org/support/topic.php?id=20956

> 

> It's about a known case of comment spamming in weblogs. The author

> noticed that all the domains used in the comment spams resolve to the

> same IP address, 161.58.59.8

> 

> And look what we just got (thanks Tom, thanks SpamX plugin!):

> 

> | Please check some helpful info about<A HREF="http://internet-

> | poker.fidelityfunding.net/"> internet poker

> 

> dirk at terra:dirk> ping fidelityfunding.net

> PING fidelityfunding.net (161.58.59.8): 56 data bytes

> 

> The nice thing is that he's also setting up bogus "account terminated"

> pages (try the above URL).

> 

> Anyway, the IP address might be another filter criterion, instead of

> having to update the blacklist all the time. Anyone wanting to write a

> SpamX module for this?

> 

> MT Blacklist is lagging behind, btw. The last few spam posts were only

> caught because they contained "texas holdem" - whatever that is, but it

> appears in all those posts.

> 

> bye, Dirk

> 

> --

> http://www.haun-online.de/

> http://www.macosx-faq.de/

> 

> _______________________________________________

> geeklog-devel mailing list

> geeklog-devel at lists.geeklog.net

> http://lists.geeklog.net/listinfo/geeklog-devel

>



--__--__--

_______________________________________________
geeklog-devel mailing list
geeklog-devel at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devel


End of geeklog-devel Digest