unofficial_dotProject/inCronForDP.php at master · greywolfs/unofficial_dotProject · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
#!/usr/bin/php
<?php
define('DP_BASE_DIR','test');
$baseDir=$baseUrl=0;
include('includes/config.php');
$mysqli=new mysqli($dPconfig['dbhost'],$dPconfig['dbuser'],$dPconfig['dbpass'],$dPconfig['dbname']);
$mysqli->query('SET NAMES utf8');
if ($mysqli->connect_errno) {
	echo "Failed to connect to MySQL: " . $mysqli->connect_error;
}
$res=$mysqli->query('
	SELECT  event_id, event_title, event_start_date, event_description, event_remind, contact_email
	FROM events
	LEFT JOIN user_events USING (event_id)
	LEFT JOIN users USING (user_id)
	LEFT JOIN contacts ON user_contact=contact_id
	WHERE event_remind>0
	');
$events=array();
while ($row=$res->fetch_assoc()){
	if (strtotime($row['event_start_date'])-time()<$row['event_remind']){
		if (!isset($events[$row['event_id']])){
			$text=str_replace("\n","<br>", $row['event_description']);
			$events[$row['event_id']]['subject']= "[dotProject] Напоминание о событии";
			$events[$row['event_id']]['message']=
				'
				<html>
				<head>
				 <title>'.$row['event_title'].'</title>
				</head>
				<body>
				<b>'.$row['event_title'].'</b><br><br>
				'.$text.'
				</body>
				</html>
			';
			$events[$row['event_id']]['headers']= "MIME-Version: 1.0\r\n";
			$events[$row['event_id']]['headers'].= "Content-type: text/html; charset=UTF-8\r\n";
			$events[$row['event_id']]['headers'].= "From: no-reply@".$dPconfig['mailServer']."\r\n";
		}
		$events[$row['event_id']]['to'][]=$row['contact_email'];
	}
}
$readyEvent=array();
foreach ($events as $eventId=>$eventData){
	$to=implode(', ', $eventData['to']);
	if (mail($to, $eventData['subject'], $eventData['message'], $eventData['headers'])){
		$readyEvent[]=$eventId;
	}
}
if (!empty($readyEvent)){
	$sql=
		"
		UPDATE events
		SET event_remind=0
		WHERE event_id in (".implode(', ',$readyEvent).");";
	$mysqli->query($sql);
}
?>