[TYPO3-english] Published content

Sergio scatala at iti.upv.es
Fri May 15 13:01:21 CEST 2009


I thought that solution but if someone updates content after being
published, an email will arrive to all users too. I only want to know
when "hidden" field changes :-(



El vie, 15-05-2009 a las 12:45 +0200, Søren Malling escribió:
> 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
> >
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english



More information about the TYPO3-english mailing list