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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
|
<?php
// This script checks for pending scheduled notifications
// and sends them at the right time.
include_once('../header.php');
include_once('../includes/notify.inc.php');
$notify = new Notifications;
$now = date(U);
$get_reminders = $db->Query("SELECT * FROM {$dbprefix}reminders r
LEFT JOIN {$dbprefix}tasks t ON r.task_id = t.task_id
LEFT JOIN {$dbprefix}projects p ON t.attached_to_project = p.project_id
WHERE t.is_closed = '0'
ORDER BY r.reminder_id");
// Cycle through all reminders in the database table
while ($row = $db->FetchRow($get_reminders))
{
// Check to see if it's time to send a reminder
if (($row['start_time'] < $now) && (($row['last_sent'] + $row['how_often']) < $now))
{
// Send the reminder
$lang = $flyspray_prefs['lang_code'];
require("../lang/$lang/functions.inc.php");
$jabber_users = array();
$email_users = array();
// Get the user's notification type and address
$get_details = $db->Query("SELECT notify_type, jabber_id, email_address
FROM {$dbprefix}users
WHERE user_id = ?",
array($row['to_user_id']));
while ($subrow = $db->FetchArray($get_details))
{
if (($flyspray_prefs['user_notify'] == '1' && $subrow['notify_type'] == '1')
OR ($flyspray_prefs['user_notify'] == '2'))
{
array_push($email_users, $subrow['email_address']);
} elseif (($flyspray_prefs['user_notify'] == '1' && $subrow['notify_type'] == '2')
OR ($flyspray_prefs['user_notify'] == '3'))
{
array_push($jabber_users, $subrow['jabber_id']);
}
}
$subject = $functions_text['notifyfrom'];
$message = stripslashes($row['reminder_message']);
// Pass the recipients and message onto the notification function
$notify->SendEmail($email_users, $subject, $message);
$notify->StoreJabber($jabber_users, $subject, $message);
// Update the database with the time sent
$update_db = $db->Query("UPDATE {$dbprefix}reminders
SET last_sent = ?
WHERE reminder_id = ?",
array($now, $row['reminder_id']));
// Debug
echo "Reminder Sent!<br>";
}
}
// send those stored notifications
$notify->SendJabber();
?>
<html>
<head>
<title>Scheduled Reminders</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<h1>Scheduled Reminders</h1>
This is a backend script that really isn't meant to be displayed in your browser.
To enable scheduled reminders, you set up some sort of background program to
activate this script regularly. The unix utility 'cron' can be used in conjunction
with 'wget' to do this.
</body>
</html>
|
