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 <[email protected]> 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 <[email protected]> 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 > > > > [email protected] > > > > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english > > > > > > > _______________________________________________ > > > TYPO3-english mailing list > > > [email protected] > > > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english > > > > _______________________________________________ > > TYPO3-english mailing list > > [email protected] > > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english > > > _______________________________________________ > TYPO3-english mailing list > [email protected] > http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english _______________________________________________ TYPO3-english mailing list [email protected] http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
