function generateAndPublishFeed($rs)
{
global $facebook, $title, $message, $actualPosts, $templateBundleId, $picture, $pLink;
$id = $rs->data['uid'];
echo '<h6>Actual posts: ' . $actualPosts++ . '</h6>';
$facebook->api_client->batch_queue = null;
$facebook->api_client->begin_batch();
$message2 = sprintf($message, $rs->getHebrewDate('medeng'), $rs->data['title']);
$messageHTML2 = sprintf($messageHTML, $rs->getHebrewDate('medeng'), $rs->data['title']);
//echo $message2;
$facebook->api_client->notifications_send_announce($facebook->user, $messageHTML2);
$facebook->api_client->notifications_sendEmail($facebook->user, $title, $message2, $messageHTML2);
$messageData = json_encode(array("title" => $rs->data['title'], "hebrewDate" => $rs->getHebrewDate('medeng'), "originalDate" => $rs->data['originalDate'], "nextOccurance" => $rs->getNextOccurance(), "images" => array(array("src" => $picture, "href" => $pLink))));
$facebook->api_client->feed_publishUserAction($templateBundleId, $messageData);
print_r_debug($messageData);
$facebook->api_client->end_batch();
}
//header("Content-Type: application/xhtml+xml; charset=utf-8;");
$debug = false;
require_once 'appinclude.php';
$conn = dbConnect();
if (isset($_REQUEST['submit'])) {
$strNotifications = isset($_REQUEST["chkNotifications"]) ? 'true' : 'false';
$strEmail = isset($_REQUEST["chkEmail"]) ? 'true' : 'false';
$strMiniFeed = isset($_REQUEST["chkMiniFeed"]) ? 'true' : 'false';
$sql = "UPDATE fbUsers SET sendNotification={$strNotifications}, sendEmail={$strEmail}, sendMiniFeed={$strMiniFeed} WHERE id='{$facebook->user}' AND appid='{$facebook->api_key}'";
print_r_debug($sql);
mysql_query($sql, $conn);
//$success = true;
$facebook->redirect('fullPageAd.php?msg=settingssaved&settingschanged=email');
}
$sql = "SELECT sendNotification, sendEmail, sendMiniFeed FROM fbUsers WHERE id='{$facebook->user}' AND appid='{$facebook->api_key}'";
print_r_debug($sql);
$result = mysql_query($sql, $conn);
$rs = mysql_fetch_assoc($result);
mysql_close($conn);
?>
<style>
<?php
require_once '../main.css';
?>
form {
padding: 20px 20px 20px 20px;
font-size:14px;
border-left:1px #000099 solid;
border-right:1px #000099 solid;
}
#form h3 {
function generateAndPublishFeed($rs)
{
global $facebook, $title, $message, $messageHTML, $cDatesStr, $actualPosts, $activeDateStr, $templateBundleId, $picture, $pLink;
$id = $rs['id'];
if (!$rs['sendEmail'] && !$rs['sendNotification']) {
return;
}
$facebook->api_client->batch_queue = null;
$fql = "SELECT uid, name, sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = {$id}) AND birthday in ('{$cDatesStr}')";
$themStr = 'them';
trace('Pre Query: ');
$friends = $facebook->api_client->fql_query($fql);
trace('Pre Loop: ');
print_r($friends);
if (is_array($friends) && count($friends) > 0) {
echo '<h6>Actual posts: ' . $actualPosts++ . '</h6>';
$facebook->api_client->begin_batch();
foreach ($friends as $friend) {
$message2 = sprintf($message, $activeDateStr, $friend['name'], $friend['sex'] == '' ? 'them' : ($friend['sex'] == 'male' ? 'him' : 'her'), $friend['uid']);
//echo $message2;
$messageHTML2 = sprintf($messageHTML, $activeDateStr, $friend['name'], $friend['sex'] == '' ? 'them' : ($friend['sex'] == 'male' ? 'him' : 'her'), $friend['uid']);
//echo $messageHTML2;
if ($rs['sendNotification']) {
$facebook->api_client->notifications_send_announce($facebook->user, $messageHTML2);
}
if ($rs['sendEmail']) {
$facebook->api_client->notifications_sendEmail($facebook->user, $title, $message2, $messageHTML2);
}
}
if ($rs['sendMiniFeed'] == 1 && count($friends) > 0) {
$messageData = json_encode(array("today" => $activeDateStr, "ammount" => count($friends), "images" => array(array("src" => $picture, "href" => $pLink))));
$facebook->api_client->feed_publishUserAction($templateBundleId, $messageData);
print_r_debug($messageData);
}
$facebook->api_client->end_batch();
}
}
public static function findBySQL($className, $sql)
{
$class = new ReflectionClass($className);
$arr = array();
print_r_debug($sql);
$conn = self::connection();
$results = mysql_query($sql, $conn);
while ($rs = mysql_fetch_assoc($results)) {
$arr[] = $class->newInstance($rs);
}
if (count($arr) == 0) {
$rec = $class->newInstance();
if (!$rec->recordErrors($sql, $conn)) {
$arr[] = $rec;
}
}
mysql_close($conn);
return $arr;
}
public static function findByWhere($className, $sqlWhere)
{
$class = new ReflectionClass($className);
$arr = array();
$rec = $class->newInstance();
$tableName = $rec->tableName;
$sql = "SELECT * FROM {$tableName} WHERE {$sqlWhere}";
print_r_debug($sql);
$results = mysql_query($sql, self::connection());
while ($rs = mysql_fetch_assoc($results)) {
$arr[] = $class->newInstance($rs);
}
if (count($arr) == 0) {
if (!$rec->recordErrors($sql)) {
$arr[] = $rec;
}
}
return $arr;
}
