/**
* Main control method
*/
public function authControl()
{
$this->setViewTemplate('post.index.tpl');
if (isset($_REQUEST['t']) && is_numeric($_REQUEST['t']) && $this->post_dao->isPostInDB($_REQUEST['t'])) {
$post_id = $_REQUEST['t'];
$this->addToViewCacheKey($post_id);
$post = $this->post_dao->getPost($post_id);
$this->addToView('post', $post);
$this->addToView('likely_orphans', $this->post_dao->getLikelyOrphansForParent($post->pub_date, $post->author_user_id, $post->author_username, 15));
$this->addToView('all_tweets', $this->post_dao->getAllPosts($post->author_user_id, 15));
$all_replies = $this->post_dao->getRepliesToPost($post_id);
$this->addToView('replies', $all_replies);
$all_replies_count = count($all_replies);
$this->addToView('reply_count', $all_replies_count);
$all_retweets = $this->post_dao->getRetweetsOfPost($post_id);
$this->addToView('retweets', $all_retweets);
$retweet_reach = $this->post_dao->getPostReachViaRetweets($post_id);
$this->addToView('retweet_reach', $retweet_reach);
$public_replies = $this->post_dao->getPublicRepliesToPost($post_id);
$public_replies_count = count($public_replies);
$this->addToView('public_reply_count', $public_replies_count);
$private_replies_count = $all_replies_count - $public_replies_count;
$this->addToView('private_reply_count', $private_replies_count);
} else {
$this->addToView('error', 'Post not found');
}
return $this->generateView();
}
/**
* Load view with individual post and replies and retweets
* @param int $post_id
* @param str $network
*/
private function loadSinglePostThread($post_id, $network)
{
$this->setPageTitle('Public Post Replies');
$this->post_dao->isPostByPublicInstance($_GET['t'], $network);
$post = $this->post_dao->getPost($post_id, $network);
if (!isset($post)) {
$this->addErrorMessage("Post " . $post_id . " on " . ucwords($network) . " is not in ThinkUp.");
} else {
$plugin_option_dao = DAOFactory::GetDAO('PluginOptionDAO');
$options = $plugin_option_dao->getOptionsHash('geoencoder', true);
if (isset($options['distance_unit']->option_value)) {
$distance_unit = $options['distance_unit']->option_value;
} else {
$distance_unit = 'km';
}
$public_tweet_replies = $this->post_dao->getPublicRepliesToPost($post->post_id, $network, 'default', $distance_unit);
$public_retweets = $this->post_dao->getRetweetsOfPost($post->post_id, $network, 'default', $distance_unit, true);
$this->addToView('post', $post);
$this->addToView('replies', $public_tweet_replies);
$this->addToView('retweets', $public_retweets);
$this->addToView('unit', $distance_unit);
$rtreach = 0;
foreach ($public_retweets as $t) {
$rtreach += $t->author->follower_count;
}
$this->addToView('rtreach', $rtreach);
}
}
/**
* Load view with individual post and replies and retweets
* @param int $post_id
*/
private function loadSinglePostThread($post_id)
{
$post = $this->post_dao->getPost($post_id);
$public_tweet_replies = $this->post_dao->getPublicRepliesToPost($post->post_id);
$public_retweets = $this->post_dao->getRetweetsOfPost($post->post_id, true);
$this->addToView('post', $post);
$this->addToView('replies', $public_tweet_replies);
$this->addToView('retweets', $public_retweets);
$rtreach = 0;
foreach ($public_retweets as $t) {
$rtreach += $t->author->follower_count;
}
$this->addToView('rtreach', $rtreach);
}
/**
* Main control method
*/
public function authControl()
{
$this->setViewTemplate('post.index.tpl');
$network = isset($_GET['n']) ? $_GET['n'] : 'twitter';
$_GET['n'] = $network;
if ($this->shouldRefreshCache()) {
if (isset($_GET['t']) && is_numeric($_GET['t']) && $this->post_dao->isPostInDB($_GET['t'], $network)) {
$plugin_option_dao = DAOFactory::GetDAO('PluginOptionDAO');
$options = $plugin_option_dao->getOptionsHash('geoencoder', true);
if (isset($options['distance_unit']->option_value)) {
$distance_unit = $options['distance_unit']->option_value;
} else {
$distance_unit = 'km';
}
$post_id = $_GET['t'];
$post = $this->post_dao->getPost($post_id, $network);
$this->addToView('post', $post);
$this->addToView('unit', $distance_unit);
// costly query
//$this->addToView('likely_orphans', $this->post_dao->getLikelyOrphansForParent($post->pub_date,
//$post->author_user_id,$post->author_username, 15) );
//$this->addToView('all_tweets', $this->post_dao->getAllPosts($post->author_user_id, 15) );
$all_replies = $this->post_dao->getRepliesToPost($post_id, $network, 'default', $distance_unit);
$this->addToView('replies', $all_replies);
$all_replies_by_location = $this->post_dao->getRepliesToPost($post_id, $network, 'location', $distance_unit);
$this->addToView('replies_by_location', $all_replies_by_location);
$all_replies_count = count($all_replies);
$this->addToView('reply_count', $all_replies_count);
$all_retweets = $this->post_dao->getRetweetsOfPost($post_id, $network, 'default', $distance_unit);
$this->addToView('retweets', $all_retweets);
$all_retweets_by_location = $this->post_dao->getRetweetsOfPost($post_id, $network, 'location', $distance_unit);
$this->addToView('retweets_by_location', $all_retweets_by_location);
$retweet_reach = $this->post_dao->getPostReachViaRetweets($post_id, $network);
$this->addToView('retweet_reach', $retweet_reach);
$public_replies = $this->post_dao->getPublicRepliesToPost($post_id, $network);
$public_replies_count = count($public_replies);
$this->addToView('public_reply_count', $public_replies_count);
$private_replies_count = $all_replies_count - $public_replies_count;
$this->addToView('private_reply_count', $private_replies_count);
} else {
$this->addErrorMessage('Post not found');
}
}
return $this->generateView();
}
function testFetchUserStreamWithTwoPostsAndOneComment()
{
/*
$this->assertTrue(unserialize('a:2:{s:5:"posts";a:2:{i:0;a:21:{s:7:"post_id";s:25:"606837591_108956622464235";s:9:"viewer_id";s:9:"606837591";s:9:"source_id";s:9:"606837591";s:4:"type";s:2:"46";s:6:"app_id";s:0:"";s:11:"attribution";s:0:"";s:8:"actor_id";s:9:"606837591";s:9:"target_id";s:0:"";s:7:"message";s:50:"The Pacific is really good. Can\'t wait for part 3.";s:10:"attachment";a:1:{s:11:"description";s:0:"";}s:8:"app_data";s:0:"";s:12:"action_links";s:0:"";s:8:"comments";a:4:{s:10:"can_remove";s:1:"1";s:8:"can_post";s:1:"1";s:5:"count";s:1:"0";s:12:"comment_list";s:0:"";}s:5:"likes";a:6:{s:4:"href";s:82:"http://www.facebook.com/social_graph.php?node_id=108956622464235&class=LikeManager";s:5:"count";s:1:"0";s:6:"sample";s:0:"";s:7:"friends";s:0:"";s:10:"user_likes";s:1:"0";s:8:"can_like";s:1:"1";}s:7:"privacy";a:6:{s:11:"description";s:12:"Only Friends";s:5:"value";s:11:"ALL_FRIENDS";s:7:"friends";s:0:"";s:8:"networks";s:0:"";s:5:"allow";s:0:"";s:4:"deny";s:0:"";}s:12:"updated_time";s:10:"1269488627";s:12:"created_time";s:10:"1269488627";s:10:"tagged_ids";s:0:"";s:9:"is_hidden";s:1:"0";s:10:"filter_key";s:34:"f8c16f44b43083fc2545a46d-606837591";s:9:"permalink";s:82:"http://www.facebook.com/profile.php?v=feed&story_fbid=108956622464235&id=606837591";}i:1;a:21:{s:7:"post_id";s:25:"606837591_107266209295210";s:9:"viewer_id";s:9:"606837591";s:9:"source_id";s:9:"606837591";s:4:"type";s:2:"46";s:6:"app_id";s:0:"";s:11:"attribution";s:0:"";s:8:"actor_id";s:9:"606837591";s:9:"target_id";s:0:"";s:7:"message";s:23:"SHAKE IT LIKE A POM-POM";s:10:"attachment";a:1:{s:11:"description";s:0:"";}s:8:"app_data";s:0:"";s:12:"action_links";s:0:"";s:8:"comments";a:4:{s:10:"can_remove";s:1:"1";s:8:"can_post";s:1:"1";s:5:"count";s:1:"0";s:12:"comment_list";s:0:"";}s:5:"likes";a:6:{s:4:"href";s:82:"http://www.facebook.com/social_graph.php?node_id=107266209295210&class=LikeManager";s:5:"count";s:1:"0";s:6:"sample";s:0:"";s:7:"friends";s:0:"";s:10:"user_likes";s:1:"0";s:8:"can_like";s:1:"1";}s:7:"privacy";a:6:{s:11:"description";s:12:"Only Friends";s:5:"value";s:11:"ALL_FRIENDS";s:7:"friends";s:0:"";s:8:"networks";s:0:"";s:5:"allow";s:0:"";s:4:"deny";s:0:"";}s:12:"updated_time";s:10:"1269411918";s:12:"created_time";s:10:"1269411918";s:10:"tagged_ids";s:0:"";s:9:"is_hidden";s:1:"0";s:10:"filter_key";s:34:"f8c16f44b43083fc2545a46d-606837591";s:9:"permalink";s:82:"http://www.facebook.com/profile.php?v=feed&story_fbid=107266209295210&id=606837591";}}s:8:"profiles";a:1:{i:0;a:5:{s:2:"id";s:9:"606837591";s:3:"url";s:0:"";s:4:"name";s:12:"Gina Trapani";s:10:"pic_square";s:60:"http://profile.ak.fbcdn.net/v222/1942/94/q606837591_9678.jpg";s:4:"type";s:4:"user";}}}'));
$stream = unserialize('a:2:{s:5:"posts";a:2:{i:0;a:21:{s:7:"post_id";s:25:"606837591_108956622464235";s:9:"viewer_id";s:9:"606837591";s:9:"source_id";s:9:"606837591";s:4:"type";s:2:"46";s:6:"app_id";s:0:"";s:11:"attribution";s:0:"";s:8:"actor_id";s:9:"606837591";s:9:"target_id";s:0:"";s:7:"message";s:50:"The Pacific is really good. Can\'t wait for part 3.";s:10:"attachment";a:1:{s:11:"description";s:0:"";}s:8:"app_data";s:0:"";s:12:"action_links";s:0:"";s:8:"comments";a:4:{s:10:"can_remove";s:1:"1";s:8:"can_post";s:1:"1";s:5:"count";s:1:"0";s:12:"comment_list";s:0:"";}s:5:"likes";a:6:{s:4:"href";s:82:"http://www.facebook.com/social_graph.php?node_id=108956622464235&class=LikeManager";s:5:"count";s:1:"0";s:6:"sample";s:0:"";s:7:"friends";s:0:"";s:10:"user_likes";s:1:"0";s:8:"can_like";s:1:"1";}s:7:"privacy";a:6:{s:11:"description";s:12:"Only Friends";s:5:"value";s:11:"ALL_FRIENDS";s:7:"friends";s:0:"";s:8:"networks";s:0:"";s:5:"allow";s:0:"";s:4:"deny";s:0:"";}s:12:"updated_time";s:10:"1269488627";s:12:"created_time";s:10:"1269488627";s:10:"tagged_ids";s:0:"";s:9:"is_hidden";s:1:"0";s:10:"filter_key";s:34:"f8c16f44b43083fc2545a46d-606837591";s:9:"permalink";s:82:"http://www.facebook.com/profile.php?v=feed&story_fbid=108956622464235&id=606837591";}i:1;a:21:{s:7:"post_id";s:25:"606837591_107266209295210";s:9:"viewer_id";s:9:"606837591";s:9:"source_id";s:9:"606837591";s:4:"type";s:2:"46";s:6:"app_id";s:0:"";s:11:"attribution";s:0:"";s:8:"actor_id";s:9:"606837591";s:9:"target_id";s:0:"";s:7:"message";s:23:"SHAKE IT LIKE A POM-POM";s:10:"attachment";a:1:{s:11:"description";s:0:"";}s:8:"app_data";s:0:"";s:12:"action_links";s:0:"";s:8:"comments";a:4:{s:10:"can_remove";s:1:"1";s:8:"can_post";s:1:"1";s:5:"count";s:1:"0";s:12:"comment_list";s:0:"";}s:5:"likes";a:6:{s:4:"href";s:82:"http://www.facebook.com/social_graph.php?node_id=107266209295210&class=LikeManager";s:5:"count";s:1:"0";s:6:"sample";s:0:"";s:7:"friends";s:0:"";s:10:"user_likes";s:1:"0";s:8:"can_like";s:1:"1";}s:7:"privacy";a:6:{s:11:"description";s:12:"Only Friends";s:5:"value";s:11:"ALL_FRIENDS";s:7:"friends";s:0:"";s:8:"networks";s:0:"";s:5:"allow";s:0:"";s:4:"deny";s:0:"";}s:12:"updated_time";s:10:"1269411918";s:12:"created_time";s:10:"1269411918";s:10:"tagged_ids";s:0:"";s:9:"is_hidden";s:1:"0";s:10:"filter_key";s:34:"f8c16f44b43083fc2545a46d-606837591";s:9:"permalink";s:82:"http://www.facebook.com/profile.php?v=feed&story_fbid=107266209295210&id=606837591";}}s:8:"profiles";a:1:{i:0;a:5:{s:2:"id";s:9:"606837591";s:3:"url";s:0:"";s:4:"name";s:12:"Gina Trapani";s:10:"pic_square";s:60:"http://profile.ak.fbcdn.net/v222/1942/94/q606837591_9678.jpg";s:4:"type";s:4:"user";}}}');
$this->assertTrue(is_array($stream));
$this->assertTrue(is_array($stream["posts"]));
//print_r($stream["posts"]);
*/
$this->instance->network_user_id = '6068375911';
$fbc = new FacebookCrawler($this->instance, $this->logger, $this->fb, $this->db);
$session_key = 'f8c16f44b43083fc2545a46d-606837591';
$fbc->fetchUserPostsAndReplies($this->instance->network_user_id, $session_key);
$pd = new PostDAO($this->db, $this->logger);
$p = $pd->getPost('108956622464235');
$this->assertTrue($p->mention_count_cache == 1);
$p = $pd->getPost('107266209295210');
$this->assertTrue($p->mention_count_cache == 0);
}
function testFetchSearchResults()
{
$this->api->available = true;
$this->api->available_api_calls_for_crawler = 1;
$tc = new TwitterCrawler($this->instance, $this->logger, $this->api, $this->db);
$tc->fetchInstanceUserInfo();
$tc->fetchSearchResults('@whitehouse');
$pdao = new PostDAO($this->db, $this->logger);
$this->assertTrue($pdao->isPostInDB(11841192840.0));
$post = $pdao->getPost(11841192840.0);
$this->assertEqual($post->post_text, "RT @CindyPDX: @whitehouse PLS send to my President: http://familiesofautistickids.ning.com/video/through-my-eyes-thanh-bui <Does he remember our son?");
}
/**
* Smarty Tweet from ID plugin
*
* Type: modifier<br>
* Name: tweet_from_id<br>
* Date: March 9, 2010
* Purpose: Converts a tweet id into a full Tweet object.
* Input: status id
* Example: {$tweet->in_reply_to_id|tweet_from_id}
* @author Thomas Woodham
* @version 1.0
* @param integer
* @return object
*/
function smarty_modifier_tweet_from_id($status_id)
{
global $db, $cfg, $i;
// Necessary evil.
$conn = $db->getConnection();
$td = new PostDAO($db);
if ($status_id > 0) {
$tweet = $td->getPost($status_id);
} else {
$tweet = new Post(array('id' => 0, 'status_id' => 0));
}
return $tweet;
}
public function testPointCoordsNoPolygon()
{
$item = $this->getJSONStringFromFile("place3.json");
$this->json_parser->parseJSON($item);
// check post information
$post = $this->post_dao->getPost('36358312584806400', 'twitter');
$this->assertEqual($post->post_id, '36358312584806400');
// should be no places info
// check post_locations table information
$post_loc_arr = $this->place_dao->getPostPlace('36358312584806400');
$this->assertEqual($post_loc_arr['post_id'], '36358312584806400');
$this->assertEqual($post_loc_arr['place_id'], null);
$this->assertEqual($post_loc_arr['longlat'], 'POINT(139.722 35.6596)');
}
/**
* Convert the post as it is returned from the database to how it looks when output by the Twitter API.
* Also, add the replies into the post with the index "replies".
*
* If the $post parameter is not a Post object, the function returns null.
*
* @param Post $post The post object.
* @return stdObject The post formatted to look like the Twitter API.
*/
private function convertPostToTweet($post)
{
if (!$post instanceof Post) {
return null;
}
if ($this->include_replies) {
/*
* Get all replies to the post. The limit is set to 0 because if the count is not greater than 0,
* the method returns all replies.
*/
$replies = $this->post_dao->getRepliesToPost($post->post_id, $post->network, $this->order_by, $this->unit, $this->is_public, 0);
// if replies exist for this post
if ($replies) {
// recursively scan through the post replies, converting them
foreach ($replies as $reply) {
$reply = $this->convertPostToTweet($reply);
}
// add the replies to the post
$post->replies = $replies;
}
}
/*
* Chop and changing the data fetched from the database to look more like the official Twitter API.
*/
$post->text = $post->post_text;
$post->created_at = strftime('%a %b %d %T %z %Y', strtotime($post->pub_date));
$post->id = $post->post_id;
$post->favorited = $post->favorited ? true : false;
$post->annotations = null;
// to be implemented at some point
$post->truncated = false;
// always false
$post->protected = $post->is_protected == 0 ? false : true;
if ($post->geo != null) {
$coordinates = preg_split('/(, |,| )/', $post->geo);
$post->geo = new stdClass();
$post->geo->coordinates = $coordinates;
if (!isset($post->coordinates)) {
$post->coordinates = new stdClass();
}
$post->coordinates->coordinates = $coordinates;
}
/*
* SET THINKUP METADATA
*/
$post->thinkup = new stdClass();
$post->thinkup->retweet_count_cache = $post->retweet_count_cache;
$post->thinkup->retweet_count_api = $post->retweet_count_api;
$post->thinkup->reply_count_cache = $post->reply_count_cache;
$post->thinkup->old_retweet_count_cache = $post->old_retweet_count_cache;
$post->thinkup->is_geo_encoded = $post->is_geo_encoded;
$user = $this->user_dao->getUserByName($post->author_username, $post->network);
/*
* Occasionally you run into users you haven't fetched yet. Bypass this code if you find one of them.
*/
if ($user != null) {
if (!$this->trim_user) {
$post->user = $this->convertUserToStdClass($user);
$post->user->id = $post->user->user_id;
$post->user->followers_count = $post->user->follower_count;
$post->user->profile_image_url = $post->user->avatar;
$post->user->name = $post->user->full_name;
$post->user->screen_name = $post->user->username;
$post->user->statuses_count = $post->user->post_count;
$post->user->created_at = strftime('%a %b %d %T %z %Y', strtotime($post->user->joined));
$post->user->favorites_count = $post->user->favorites_count;
if (isset($post->user->other)) {
if (isset($post->user->other['avg_tweets_per_day'])) {
$post->user->avg_tweets_per_day = $post->user->other['avg_tweets_per_day'];
}
}
$post->user->thinkup = new stdClass();
$post->user->thinkup->last_post = $post->user->last_post;
$post->user->thinkup->last_post_id = $post->user->last_post_id;
$post->user->thinkup->found_in = $post->user->found_in;
} else {
$post->user = new stdClass();
$post->user->id = $user->user_id;
}
}
if ($this->include_entities) {
/*
* Gather hashtags and format them into a Tweet entity.
*/
$extracted_hashtags = Post::extractHashtags($post->text);
if (!isset($post->entities)) {
$post->entities = new stdClass();
}
$post->entities->hashtags = array();
if (!empty($extracted_hashtags)) {
foreach ($extracted_hashtags as $hashtag_text) {
$hashtag = new stdClass();
$hashtag->text = str_replace('#', '', $hashtag_text);
$hashtag->indices[] = stripos($post->text, $hashtag_text);
$hashtag->indices[] = strlen($hashtag_text) + $hashtag->indices[0];
$post->entities->hashtags[] = $hashtag;
}
}
/*
* Gather mentions and format them into a Tweet entity.
*/
$mentions = Post::extractMentions($post->text);
if (!isset($post->entities)) {
$post->entities = new stdClass();
}
$post->entities->user_mentions = array();
if (!empty($mentions)) {
foreach ($mentions as $username) {
$mentioned_user = $this->user_dao->getUserByName(str_replace('@', '', $username), $user->network);
$mention = new stdClass();
if (is_null($mentioned_user)) {
// skip this for now, probably not a good idea
continue;
/*
* If the user is not in our own ThinkUp database, a Twitter API call needs to be
* made to fill in the missing details.
*
* Not 100% sure if this is a good idea but it works.
*/
$user_api_call = json_decode(Utils::getURLContents('https://api.twitter.com/1/users/show.json?screen_name=' . $username));
$mention->name = $user_api_call->name;
$mention->id = $user_api_call->id;
$mention->screen_name = $user_api_call->screen_name;
} else {
$mention->name = $mentioned_user->full_name;
$mention->id = $mentioned_user->user_id;
$mention->screen_name = $mentioned_user->username;
}
$mention->indices = array();
$mention->indices[] = stripos($post->text, $username);
$mention->indices[] = strlen($username) + $mention->indices[0];
$post->entities->user_mentions[] = $mention;
}
}
}
if ($post->in_retweet_of_post_id != null) {
$post->retweeted_status = $this->post_dao->getPost($post->in_retweet_of_post_id, $user->network);
$post->retweeted_status = $this->convertPostToTweet($post->retweeted_status);
}
/*
* Unset no-longer-used variables in this post; mostly variables that have been moved to more
* Twtter like locations / naming conventions.
*/
unset($post->post_id, $post->pub_date, $post->network, $post->post_text, $post->author, $post->author_fullname, $post->author_username, $post->author_user_id, $post->author_avatar, $post->adj_pub_date, $post->user->follower_count, $post->user->is_protected, $post->user->network, $post->user->avatar, $post->user->full_name, $post->user->username, $post->user->user_id, $post->user->post_count, $post->user->joined, $post->user->favorites_count, $post->user->other, $post->link, $post->in_retweet_of_post_id, $post->in_retweet_of_user_id, $post->retweet_count_cache, $post->reply_count_cache, $post->old_retweet_count_cache, $post->is_geo_encoded, $post->rt_threshold, $post->is_protected, $post->user->last_post, $post->user->last_post_id, $post->user->found_in);
return $post;
}
/**
* Method to find distance between reply and initial post
* @param PostDAO $post_dao
* @param array $post
* @param str $geodata
* @return int $reply_retweet_distance
*/
public function getDistance($post_dao, $post, $geodata)
{
if ($post['in_reply_to_post_id'] != NULL) {
if ($post_dao->isPostInDB($post['in_reply_to_post_id'], 'twitter')) {
$original_post = $post_dao->getPost($post['in_reply_to_post_id'], 'twitter');
if ($original_post->is_geo_encoded == 1) {
$o_post_geo = $original_post->geo;
$reply_retweet_distance = self::getDistanceBetweenPosts($geodata, $o_post_geo);
} else {
if ($original_post->is_geo_encoded == 0) {
return FALSE;
}
}
} else {
$reply_retweet_distance = -1;
}
}
if ($post['in_retweet_of_post_id'] != NULL) {
if ($post_dao->isPostInDB($post['in_retweet_of_post_id'], 'twitter')) {
$original_post = $post_dao->getPost($post['in_retweet_of_post_id'], 'twitter');
if ($original_post->is_geo_encoded == 1) {
$o_post_geo = $original_post->geo;
$reply_retweet_distance = self::getDistanceBetweenPosts($geodata, $o_post_geo);
} else {
if ($original_post->is_geo_encoded == 0) {
return FALSE;
}
}
} else {
$reply_retweet_distance = -1;
}
}
return $reply_retweet_distance;
}
if (isset($_REQUEST['page'])) {
$page = $_REQUEST['page'];
} else {
$page = 1;
}
if ($page > 1) {
$s->assign('prev_page', $page - 1);
}
$s->assign('cfg', $cfg);
$i = $id->getInstanceFreshestOne();
$s->assign('crawler_last_run', $i->crawler_last_run);
$s->assign('i', $_i);
// show tweet with public replies
if (isset($_REQUEST['t']) && $pd->isPostByPublicInstance($_REQUEST['t'])) {
if (!$s->is_cached('public.tpl', $_REQUEST['t'])) {
$post = $pd->getPost($_REQUEST['t']);
$public_tweet_replies = $pd->getPublicRepliesToPost($post->post_id);
$public_retweets = $pd->getRetweetsOfPost($post->post_id, true);
$s->assign('post', $post);
$s->assign('replies', $public_tweet_replies);
$s->assign('retweets', $public_retweets);
$rtreach = 0;
foreach ($public_retweets as $t) {
$rtreach += $t->author->follower_count;
}
$s->assign('rtreach', $rtreach);
$s->assign('site_root', $THINKTANK_CFG['site_root_path']);
}
$s->display('public.tpl', $_REQUEST['t']);
} elseif (isset($_REQUEST['v'])) {
$view = $_REQUEST['v'];
function testAssignParent()
{
//Add two "parent" posts
$q = "INSERT INTO tt_posts (post_id, author_user_id, author_username, author_fullname, author_avatar, post_text, source, pub_date, mention_count_cache, retweet_count_cache) VALUES (550, 19, 'linkbaiter', 'Link Baiter', 'avatar.jpg', 'This is parent post 1', 'web', '2006-03-01 00:01:00', 1, 0);";
$this->db->exec($q);
$q = "INSERT INTO tt_posts (post_id, author_user_id, author_username, author_fullname, author_avatar, post_text, source, pub_date, mention_count_cache, retweet_count_cache) VALUES (551, 19, 'linkbaiter', 'Link Baiter', 'avatar.jpg', 'This is parent post 2', 'web', '2006-03-01 00:01:00', 0, 0);";
$this->db->exec($q);
//Add a post with the parent post 550
$q = "INSERT INTO tt_posts (post_id, author_user_id, author_username, author_fullname, author_avatar, post_text, source, pub_date, mention_count_cache, retweet_count_cache, in_reply_to_post_id) VALUES (552, 19, 'linkbaiter', 'Link Baiter', 'avatar.jpg', 'This is a reply with the wrong parent', 'web', '2006-03-01 00:01:00', 0, 0, 550);";
$this->db->exec($q);
$pdao = new PostDAO($this->db, $this->logger);
$post = $pdao->getPost(552);
//Assert parent post is 550
$this->assertEqual($post->in_reply_to_post_id, 550);
//Change parent post to 551
$pdao->assignParent(551, 552);
$child_post = $pdao->getPost(552);
//Assert parent post is now 551
$this->assertEqual($child_post->in_reply_to_post_id, 551);
//Assert old parent post has one fewer reply total
$old_parent = $pdao->getPost(550);
$this->assertEqual($old_parent->mention_count_cache, 0);
//Assert new parent post has one more reply total
$new_parent = $pdao->getPost(551);
$this->assertEqual($new_parent->mention_count_cache, 1);
}
<?php
session_start();
if (!isset($_SESSION['user'])) {
header("Location: /session/login.php");
}
// set up
chdir("..");
require_once "common/init.php";
$pd = new PostDAO($db);
if (isset($_REQUEST['t']) && is_numeric($_REQUEST['t']) && $pd->isPostInDB($_REQUEST['t'])) {
$post_id = $_REQUEST['t'];
$s = new SmartyThinkTank();
if (!$s->is_cached('status.index.tpl', $post_id)) {
$post = $pd->getPost($post_id);
$u = new Utils();
// BUG: THIS ISN'T GOING TO WORK WHEN LOOKING AT POSTS OF OTHER USERS BECAUSE THEY DON'T HAVE INSTANCES
//$id = new InstanceDAO($db);
//$i = $id->getByUsername($post->author_username);
// instead, lets pull the instance object out of the session variable
$i = unserialize($_SESSION['instance']);
if (isset($i)) {
$s->assign('likely_orphans', $pd->getLikelyOrphansForParent($post->pub_date, $i->network_user_id, $post->author_username, 15));
$s->assign('all_tweets', $pd->getAllPosts($i->network_user_id, 15));
}
$cfg = new Config($i->network_username, $i->network_user_id);
// instantiate data access objects
$ud = new UserDAO($db);
$all_replies = $pd->getRepliesToPost($post_id);
$all_replies_count = count($all_replies);
$all_retweets = $pd->getRetweetsOfPost($post_id);
session_start();
if (!isset($_SESSION['user'])) {
header("Location: /session/login.php");
}
// set up
chdir("..");
require_once 'config.webapp.inc.php';
ini_set("include_path", ini_get("include_path") . PATH_SEPARATOR . $INCLUDE_PATH);
require_once "init.php";
$pd = new PostDAO($db);
if (isset($_REQUEST['t']) && is_numeric($_REQUEST['t']) && $pd->isPostInDB($_REQUEST['t'])) {
$status_id = $_REQUEST['t'];
$s = new SmartyThinkTank();
if (!$s->is_cached('status.index.tpl', $status_id)) {
$post = $pd->getPost($status_id);
$u = new Utils();
// BUG: THIS ISN'T GOING TO WORK WHEN LOOKING AT POSTS OF OTHER USERS BECAUSE THEY DON'T HAVE INSTANCES
$id = new InstanceDAO($db);
$i = $id->getByUsername($post->author_username);
if (isset($i)) {
$s->assign('likely_orphans', $pd->getLikelyOrphansForParent($post->pub_date, $i->network_user_id, $post->author_username, 15));
$s->assign('all_tweets', $pd->getAllPosts($i->network_user_id, 15));
}
$cfg = new Config($i->network_username, $i->network_user_id);
// instantiate data access objects
$ud = new UserDAO($db);
$all_replies = $pd->getRepliesToPost($status_id);
$all_replies_count = count($all_replies);
$all_retweets = $pd->getRetweetsOfPost($status_id);
$retweet_reach = $pd->getPostReachViaRetweets($status_id);
