function SendJabber()
{
global $db, $fs;
include_once BASEDIR . '/includes/class.jabber2.php';
if (empty($fs->prefs['jabber_server']) || empty($fs->prefs['jabber_port']) || empty($fs->prefs['jabber_username']) || empty($fs->prefs['jabber_password'])) {
return false;
}
// get listing of all pending jabber notifications
$result = $db->Query("SELECT DISTINCT message_id\n FROM {notification_recipients}\n WHERE notify_method='j'");
if (!$db->CountRows($result)) {
return false;
}
$JABBER = new Jabber($fs->prefs['jabber_username'] . '@' . $fs->prefs['jabber_server'], $fs->prefs['jabber_password'], $fs->prefs['jabber_ssl'], $fs->prefs['jabber_port']);
$JABBER->login();
// we have notifications to process - connect
$JABBER->log("We have notifications to process...");
$JABBER->log("Starting Jabber session:");
$ids = array();
while ($row = $db->FetchRow($result)) {
$ids[] = $row['message_id'];
}
$desired = join(",", array_map('intval', $ids));
$JABBER->log("message ids to send = {" . $desired . "}");
// removed array usage as it's messing up the select
// I suspect this is due to the variable being comma separated
// Jamin W. Collins 20050328
$notifications = $db->Query("\n\t\t\t\tSELECT * FROM {notification_messages}\n\t\t\t\tWHERE message_id IN ({$desired})\n\t\t\t\tORDER BY time_created ASC");
$JABBER->log("number of notifications {" . $db->CountRows($notifications) . "}");
// loop through notifications
while ($notification = $db->FetchRow($notifications)) {
$subject = $notification['message_subject'];
$body = $notification['message_body'];
$JABBER->log("Processing notification {" . $notification['message_id'] . "}");
$recipients = $db->Query("\n\t\t\t\tSELECT * FROM {notification_recipients}\n\t\t\t\tWHERE message_id = ?\n\t\t\t\tAND notify_method = 'j'", array($notification['message_id']));
// loop through recipients
while ($recipient = $db->FetchRow($recipients)) {
$jid = $recipient['notify_address'];
$JABBER->log("- attempting send to {" . $jid . "}");
// send notification
if ($JABBER->send_message($jid, $body, $subject, 'normal')) {
// delete entry from notification_recipients
$result = $db->Query("DELETE FROM {notification_recipients}\n WHERE message_id = ?\n AND notify_method = 'j'\n AND notify_address = ?", array($notification['message_id'], $jid));
$JABBER->log("- notification sent");
} else {
$JABBER->log("- notification not sent");
}
}
// check to see if there are still recipients for this notification
$result = $db->Query("SELECT * FROM {notification_recipients}\n WHERE message_id = ?", array($notification['message_id']));
if ($db->CountRows($result) == 0) {
$JABBER->log("No further recipients for message id {" . $notification['message_id'] . "}");
// remove notification no more recipients
$result = $db->Query("DELETE FROM {notification_messages}\n WHERE message_id = ?", array($notification['message_id']));
$JABBER->log("- Notification deleted");
}
}
// disconnect from server
$JABBER->disconnect();
$JABBER->log("Disconnected from Jabber server");
return true;
}