[TYPO3-english] Published content

[Søren Malling]

Try with the following query:

SELECT uid, title, crdate
FROM tt_content
WHERE hidden = 0

I don't know the extension and how many params you can add, but give it a
try.

On Fri, May 15, 2009 at 12:41 PM, Sergio <scatala at iti.upv.es> wrote:

>
> Yeah, that's exactly what I did, Soren. My event Query is:
>
> SELECT uid, title, crdate
> FROM tt_content
>
> and that selects every post that's been created on the last X minutes.
>
> But what I just want to know is when a certain content has been
> published (first, field "hidden = 1" and afterwards "hidden = 0").
>
> Sergio
>
>
> El vie, 15-05-2009 a las 12:36 +0200, Søren Malling escribió:
> > Hi Sergio,
> >
> > I just went through the documentation of the extension, and found that
> you
> > are able to create your own notifications, maybe that could help you?
> >
> >
> http://typo3.org/documentation/document-library/extension-manuals/kc_emailnotification/0.0.1/view/1/4/#id3923235
> >
> > Regards,
> >
> > Søren
> >
> > On Fri, May 15, 2009 at 12:26 PM, Sergio <scatala at iti.upv.es> wrote:
> >
> > > Hi list,
> > >
> > > I'm using "kc_emailnotification" extension to inform my users by email
> > > when certain content has been created. But now I would like to inform
> > > them when certain content has been "published". I mean, when content is
> > > not hidden anymore (hidden=0).
> > >
> > > Any idea?
> > >
> > > Thanks in advance,
> > > Sergio
> > >
> > >
> > > _______________________________________________
> > > TYPO3-english mailing list
> > > TYPO3-english at lists.netfielders.de
> > > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> > >
> > _______________________________________________
> > TYPO3-english mailing list
> > TYPO3-english at lists.netfielders.de
> > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>