[otrs] this is my scripts to reject all incoming email except valid customer and agent

[Chris Wong]

Dear all,
  I've write 2 scripts to reject the email for otrs.
  This script only support for the system has procmail
and php. 

Would you please give me some suggestion for my
script?
Thanks

Chris   

.procmailrc :

  :
  :
VERBOSE=on
MAILLIST=`$HOME/getEmail.php`

:0 fhw:
* $ !From.${MAILLIST}
| (formail -r ; echo "Your post has been rejected,") |
$SENDMAIL -oi -t
  :
  :

###----getEmail.php:-----###
#!/usr/bin/php -q

<?php

  mysql_connect("localhost","userid","passwd");
  mysql_select_db("otrs");
  $sql1="SELECT c.email
         FROM customer_user c, valid v
         WHERE c.valid_id = v.id
         AND v.name = 'valid'";
  
  $sql2="SELECT p.preferences_value 
         FROM system_user s, valid v, user_preferences
p
         WHERE p.preferences_key = 'UserEmail'
         AND p.user_id = s.id
         AND s.valid_id = v.id
         AND v.name = 'valid'";         

  $result1 = mysql_query($sql1);
  $mail_list="";
  while($row = mysql_fetch_array($result1)){
        if(strlen($mail_list)>0)
$mail_list=sprintf("%s|",$mail_list);
        $mail_list =
sprintf("%s%s",$mail_list,trim($row[0]));
  }
  
  mysql_free_result($result1);  
  $result2 = mysql_query($sql2);
  while($row = mysql_fetch_array($result2)){
        if(strlen($mail_list)>0) $mail_list=
sprintf("%s|",$mail_list);
        $mail_list =
sprintf("%s%s",$mail_list,trim($row[0]));
  }
  mysql_free_result($result2);  
  printf("%s",$mail_list);
?>

_________________________________________________________
最新鈴聲推介:十面埋伏，千金，心淡...
http://ringtone.yahoo.com.hk
_______________________________________________
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