send_mail.php 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. #!/usr/local/bin/php
  2. <?php
  3. $cidReset=true;
  4. require_once ('/home/dokeos/portal/user_161/main/inc/global.inc.php');
  5. require_once (api_get_path(LIBRARY_PATH).'/fileManage.lib.php');
  6. require_once (api_get_path(CONFIGURATION_PATH) ."/add_course.conf.php");
  7. require_once (api_get_path(LIBRARY_PATH)."/add_course.lib.inc.php");
  8. require_once (api_get_path(LIBRARY_PATH)."/course.lib.php");
  9. require (api_get_path(LIBRARY_PATH)."/groupmanager.lib.php");
  10. require_once (api_get_path(LIBRARY_PATH)."/surveymanager.lib.php");
  11. require_once (api_get_path(LIBRARY_PATH)."/usermanager.lib.php");
  12. $table_reminder=Database::get_main_table(MAIN_SURVEY_REMINDER_TABLE);
  13. $sql_remind="SELECT * FROM $table_reminder WHERE access='0'";
  14. $res_remind=api_sql_query($sql_remind);
  15. while($obj=mysql_fetch_object($res_remind))
  16. {
  17. $time=getdate();
  18. $time=$time['yday'];
  19. if($obj->access=='0' && $obj->reminder_time==$time)
  20. {
  21. $surveyid=$obj->sid;
  22. $db_name=$obj->db_name;
  23. $to=$obj->email;
  24. $subject=$obj->subject;
  25. $message=$obj->content;
  26. $sender_name = $_SESSION['_user']['lastName'].' '.$_SESSION['_user']['firstName'];
  27. $email = $_SESSION['_user']['mail'];
  28. $headers = " MIME-Version: 1.0 \r\n";
  29. $headers .= " Content-type: text/html; charset=iso-8859-1\r\n";
  30. $headers .= 'From: '.$sender_name.' <'.$to.'>' . "\r\n";
  31. $headers="From:$to\r\nReply-to: $to\r\nContent-type: text/html; charset=us-ascii";
  32. @mail($to,$subject,$message,$headers);
  33. $end=explode("-",$obj->avail_till);
  34. $date=mktime(0, 0, 0, $end[1],$end[2],$end[0]);
  35. $curr=mktime(0, 0, 0, $time['mon'], $time['mday'], $time['year']);
  36. if($curr<$date)
  37. {
  38. switch($obj->reminder_choice)
  39. {
  40. case "1":
  41. {
  42. $day = $time+7;
  43. $sql_insert="UPDATE reminder_dummy SET reminder_time='$day' WHERE sid='$surveyid' AND db_name='$db_name' AND email='$to'";
  44. $res_insert=mysql_query($sql_insert);
  45. break;
  46. }
  47. case "2":
  48. {
  49. $day = $time+14;
  50. $sql_insert="UPDATE reminder_dummy SET reminder_time='$day' WHERE sid='$surveyid' AND db_name='$db_name' AND email='$to'";
  51. $res_insert=mysql_query($sql_insert);
  52. break;
  53. }
  54. case "3":
  55. {
  56. $day = $time+30;
  57. $sql_insert="UPDATE reminder_dummy SET reminder_time='$day' WHERE sid='$surveyid' AND db_name='$db_name' AND email='$to'";
  58. $res_insert=mysql_query($sql_insert);
  59. break;
  60. }
  61. }
  62. }
  63. }
  64. }
  65. ?>