function transmit($timestamp = 0, $limit = 25) { require_once 'utilities.class.php'; $utilObj = new utilities($this->db); // return serialized log info for synchronization $log = array(); /*** Transmit votes - req. ncUid and contentid ***/ $votes = array(); $x = 0; $page = 0; $q = $this->db->query("SELECT Log.*,User.ncUid,Content.contentid FROM Log,User,Content WHERE Log.itemid=Content.siteContentId AND contentid>0 AND User.ncUid<>0 AND Log.userid1=User.userid AND action='vote' AND status='pending' AND Content.isBlocked=0 AND User.isBlocked=0 ORDER BY Log.id DESC"); while ($data = $this->db->readQ($q)) { $votes[$x][contentid] = $data->contentid; $votes[$x][logid] = $data->id; // fetch newscloud id from userid1 $votes[$x][uid] = $data->ncUid; // $this->lookupUid($data->userid1); $x += 1; } $this->narrate('Transmitting votes'); $this->narrate($votes); $log['votes'] = $votes; /*** Transmit new users - req isVerifiedEmail=1 ***/ $newUsers = array(); $x = 0; require_once 'userRemoteSync.class.php'; $rsObj = new userRemoteSync($this->db); require_once PATH_CORE . '/classes/systemStatus.class.php'; $ssObj = new systemStatus($this->db); $partnerid = $ssObj->getState('partnerid'); $q = $rsObj->findUnlinkedAccounts(); while ($data = $this->db->readQ($q)) { $newUsers[$x][partnerid] = $partnerid; $newUsers[$x][userid] = $data->userid; $newUsers[$x][name] = $data->name; $newUsers[$x][email] = $data->email; $newUsers[$x][fbId] = $data->fbId; $newUsers[$x][city] = $data->city; $x += 1; } $log['newUsers'] = $newUsers; $this->narrate('New users to sync with NewsCloud'); $this->narrate($newUsers); // build for users to synchronize - changed bio, changed user level - to do : facebook image /*** Transmit users who change their user level ***/ $levelChanges = array(); $x = 0; require_once 'userRemoteSync.class.php'; $rsObj = new userRemoteSync($this->db); $q = $rsObj->findUserLevelIncreases($timestamp); while ($data = $this->db->readQ($q)) { $levelChanges[$x][logid] = $data->id; $levelChanges[$x][userid] = $data->userid; $levelChanges[$x][uid] = $data->ncUid; $levelChanges[$x][userlevel] = $data->itemid; $x += 1; } $log['levelChanges'] = $levelChanges; $this->narrate('User Level Increases'); $this->narrate($levelChanges); /*** Transmit read story records - req. ncUid and contentid ***/ $q = $this->db->query("SELECT Log.id,Content.contentid,User.ncUid FROM Log,Content,User WHERE action='readStory' AND status='pending' AND User.userid=Log.userid1 AND Log.itemid=Content.siteContentId AND User.ncUid>0 AND Content.contentid>0 AND Content.isBlocked=0 AND User.isBlocked=0 ORDER BY id DESC LIMIT {$limit};"); $readStory = array(); $x = 0; while ($data = $this->db->readQ($q)) { $readStory[$x][contentid] = $data->contentid; $readStory[$x][logid] = $data->id; $readStory[$x][uid] = $data->ncUid; $x += 1; } $log['readStory'] = $readStory; /*** Transmit published story to journal - req. ncUid and contentid ***/ $q = $this->db->query("SELECT Log.id,Content.contentid,User.ncUid FROM Log,Content,User WHERE action='publishStory' AND status='pending' AND User.userid=Log.userid1 AND Log.itemid=Content.siteContentId AND User.ncUid>0 AND Content.contentid>0 AND Content.isBlocked=0 AND User.isBlocked=0 ORDER BY id DESC LIMIT {$limit};"); $pubStory = array(); $x = 0; while ($data = $this->db->readQ($q)) { $pubStory[$x][contentid] = $data->contentid; $pubStory[$x][logid] = $data->id; $pubStory[$x][uid] = $data->ncUid; $x += 1; } $log['pubStory'] = $pubStory; /*** Transmit posted raw stories - req ncUid ***/ $q = $this->db->queryC("SELECT Log.id,Log.itemid,User.ncUid FROM Log,User WHERE action='publishWire' AND status='pending' AND User.userid=Log.userid1 AND User.ncUid>0 AND User.isBlocked=0 ORDER BY id DESC LIMIT {$limit};"); $pubWire = array(); $x = 0; while ($data = $this->db->readQ($q)) { $wireQuery = $this->db->queryC("SELECT * FROM Newswire WHERE id={$data->itemid};"); if ($wireQuery !== false) { $wi = $this->db->readQ($wireQuery); $pubWire[$x][logid] = $data->id; $pubWire[$x][uid] = $data->ncUid; // fetch wire story url $pubWire[$x][url] = $wi->url; $pubWire[$x][siteContentId] = $data->itemid2; $pubWire[$x][wireid] = $wi->wireid; switch ($wi->feedType) { default: // wire $pubWire[$x][feedType] = 'wire'; break; case 'blog': $pubWire[$x][feedType] = 'blog'; $pubWire[$x][title] = $wi->title; $pubWire[$x][date] = $wi->date; $pubWire[$x][caption] = $utilObj->shorten($wi->caption, 500); break; } $x += 1; } else { // story deleted from newswire $this->db->update("Log", "status='error'", "id={$data->id}"); } } $log['pubWire'] = $pubWire; /*** Transmit posted stories, a new user posted story - req ncUid ***/ $q = $this->db->queryC("SELECT Log.id,Log.itemid,User.ncUid FROM Log,User WHERE action='postStory' AND status='pending' AND User.userid=Log.userid1 AND User.ncUid>0 AND User.isBlocked=0 ORDER BY id DESC LIMIT {$limit};"); if ($q !== false) { //$this->db->log('inside poststory'); require_once PATH_CORE . '/classes/content.class.php'; $cObj = new content($this->db); $postStory = array(); $x = 0; while ($data = $this->db->readQ($q)) { $this->db->log($data->id); // fetch contentid from siteContentid $si = $cObj->getById($data->itemid); if ($si !== false) { $postStory[$x][logid] = $data->id; $postStory[$x][siteContentId] = $data->itemid; $postStory[$x][uid] = $data->ncUid; $postStory[$x][title] = $si->title; $postStory[$x][url] = $si->url; $postStory[$x][date] = $si->date; $postStory[$x][caption] = htmlentities($utilObj->shorten(strip_tags($si->caption), 500), ENT_QUOTES); $imageProps = $cObj->getImage($data->itemid); if ($imageProps !== false) { $postStory[$x][imageurl] = $imageProps->url; } $x += 1; } } $log['postStory'] = $postStory; } $this->narrate('Posting stories to NewsCloud'); $this->narrate($postStory); /*** Transmit comments - req. ncUid and contentid ***/ $comments = array(); $q = $this->db->query("SELECT Log.id,Comments.comments,Comments.siteCommentId,Content.contentid,User.ncUid FROM Log,Comments,Content,User WHERE Log.itemid=Comments.siteCommentId AND Comments.siteContentId=Log.itemid2 AND Content.siteContentId=Log.itemid2 AND Content.contentid>0 AND Log.userid1=User.userid AND User.ncUid>0 AND action='comment' AND status='pending' AND Content.isBlocked=0 AND User.isBlocked=0 AND Comments.videoid=0 ORDER BY id DESC LIMIT {$limit};"); $x = 0; while ($data = $this->db->readQ($q)) { $comments[$x][uid] = $data->ncUid; $comments[$x][contentid] = $data->contentid; $comments[$x][logid] = $data->id; $comments[$x][comments] = htmlentities($data->comments, ENT_QUOTES); $comments[$x][siteCommentId] = $data->siteCommentId; $x += 1; // fetch contentid from siteContentid //$contentid=$this->lookupContentId($data->itemid); //if ($contentid!==false AND $contentid<>0) { // fetch newscloud id from userid1 //$ncUid=$this->lookupUid($data->userid1); //if ($ncUid<>0) { //} //} } $log['comments'] = $comments; $this->narrate('Transmitting comments'); $this->narrate($comments); // send serialized array out return serialize($log); }
$action = 'unknown'; } if (isset($_GET['userid'])) { $userid = $_GET['userid']; } else { $userid = 0; } if (isset($_GET['itemid'])) { $itemid = $_GET['itemid']; } else { $id = 0; } switch ($action) { case 'jumpToStory': // to do: log story read require_once PATH_CORE . "classes/content.class.php"; $cObj = new content($db); $story = $cObj->getById($itemid); header("Location: " . $story->url); break; case 'readWire': require_once PATH_CORE . "/classes/log.class.php"; $logObj = new log($db); $info = $logObj->serialize(0, $db->ui->userid, 'readWire', $itemid); $logObj->update($info); require_once PATH_CORE . "classes/newswire.class.php"; $nwObj = new newswire($db); $url = $nwObj->getWebpage($itemid); header("Location: " . $url); break; }