Hi AleX, is this question still up to date or do you come along with Martin's close.pl which is even though a "hack" still much cleaner than mine php script.
I could make a clean version of it and post it here or on some website but I am not sure if that makes sense if Martin wants to implement that feature in futures releases anyway. --Florian ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 27, 2003 7:12 PM Subject: [otrs] Removing lots of mails from OTRS? > Hi Florian, could you be more "specific", > I mean that I'm not that good in php, so would be great if you can post your > script, so I can run it in cron, > I'm filled with loop protection message, because I've BadFrommed the email I > was receiving the virus from, without thinkink that my postmaster mail was in > a queue. > Whatever, the simple php script, could help a lot. > > BR > AleX > > >Hello there, I had the same problem and i wrote a small PHP-Script which > >helped me out here: > > > >basically, the idea is to selects the "bad" emails from the article table, > >reads out the ticket_id and then removes > >these in the "tickets" table. here's how i did it: > > > >(of course, you have to select your db settings first) > >========================================== > > $abfrage = "SELECT ticket_id from article where > > a_subject = 'Re: Re: My details' > >... > >CUT > >... > >========================================== > > > >I am aware of the fact that it is not very clean, but running it as a > >cronjob started every 2 minutes > >it is doin a fine work for me. > > > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > > _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
