I'm sorry but I'm a newbie.
Can anyone tell me how can I run the following PHP Script sent by
Florian ? and which db setting do I have to select ?
Thanks
==========================================
$abfrage = "SELECT ticket_id from article where
a_subject = 'Re: Re: My details'
OR a_subject = 'Re: Details'
OR a_subject = 'Re: Approved'
OR a_subject = 'Re: Wicked screensaver'
OR a_subject = 'Re: That movie'
OR a_body = 'See the attached file for details'
";
$ergebnis = mysql_query($abfrage);
if(!$ergebnis)
echo "Abfrage nicht korrekt: $abfrage<br>\n";
while
(
list
(
$db_id
)
= mysql_fetch_row($ergebnis)
)
{
$abfrage2 = "update ticket set ticket_state_id = '2' where id =
'$db_id'";
$abfrage2 = mysql_query($abfrage2);
}
==========================================
Luis Vazquez
_______________________________________________
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