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; }