" . make_clickable($comment->body) . "
\n";
$output_string .= "\t\t\tFriendFeed Comments does not have a nickname set. You need to enter your FriendFeed nickname for the comments to be loaded.
Hopefully you won't need to change this. The FriendFeed Comments plugin should link your post to the item on FriendFeed, but sometimes it can't. This is often due to the title of the post changing, but sometimes it just doesn't work. So if the wrong post, or none, is selected here, pick the right one and click save.
tags for easier viewing in HTML
*
* @param string $string The string to display
* @param bool $exit If true the script will exit immediately after diplaying
*/
function printr($string, $exit = false) {
print "";
print_r($string);
print "
";
if ($exit) {
exit;
}
}
/**
* Checks whether the entries table exists
*
* @global $wpdb
* @return bool True if the table exists
*/
function table_exists() {
global $wpdb;
return $wpdb->query($wpdb->prepare("show tables like '$this->table_name'")) > 0;
}
/**
* Create a blank version of the table, checks for existance first
**/
function create_table() {
global $wpdb;
if (!$this->table_exists()) {
$sql = "CREATE TABLE $this->table_name (
entry_id varchar( 50 ) CHARACTER SET utf8 NOT NULL ,
title varchar( 200 ) CHARACTER SET utf8 NOT NULL ,
key_val varchar( 200 ) CHARACTER SET utf8 NOT NULL ,
post_id int( 10 ) unsigned default NULL ,
comments longtext CHARACTER SET utf8 NOT NULL ,
likes longtext CHARACTER SET utf8 NOT NULL ,
created_on datetime NOT NULL ,
PRIMARY KEY ( entry_id ) ,
UNIQUE KEY post_id ( post_id )
) ENGINE = InnoDB COLLATE = utf8_general_ci";
$wpdb->query($wpdb->prepare($sql));
}
}
/**
* Remove the data table
*
* @global $wpdb
*
*/
function drop_table() {
global $wpdb;
$wpdb->query($wpdb->prepare("DROP TABLE IF EXISTS $this->table_name ;"));
}
/**
* Remove all items from the table
*
* @global $wpdb
*
*/
function empty_table() {
global $wpdb;
$wpdb->query($wpdb->prepare("TRUNCATE TABLE $this->table_name ;"));
}
/**
* Update the entry in the database
*
* @param string $entry_id
* @param array $comments
* @param array $likes
* @return int Positive if update was successful
*/
function update_entry($entry_id, $comments, $likes) {
global $wpdb;
if (is_array($comments)) {
$comments = serialize($comments);
}
if (is_array($likes)) {
$likes = serialize($likes);
}
$data = compact( 'comments', 'likes' );
return $wpdb->update($this->table_name, $data, array('entry_id' => $entry_id));
}
/**
* Insert an entry into the database
*
* @global $wpdb
* @param string $entry_id
* @param string $title
* @param array $comments
* @param array $likes
*/
function add_entry($entry_id, $title, $comments, $likes) {
global $wpdb;
if (is_array($comments)) {
$comments = serialize($comments);
}
if (is_array($likes)) {
$likes = serialize($likes);
}
$return = $wpdb->query( $wpdb->prepare("INSERT INTO $this->table_name
(entry_id, title, key_val, post_id, comments, likes, created_on)
VALUES ('%s', '%s', '%s', null, '%s', '%s', '%s')", $entry_id, $title, $this->format_title($title), $comments, $likes, current_time('mysql')
));
}
/**
* Link an entry to a blog post, remove other links to that entry
*
* @param string $entry_id
* @param int $post_id
* @return int Positive if successful
*/
function set_post_for_entry($entry_id, $post_id) {
global $wpdb;
$wpdb->query($wpdb->prepare("UPDATE $this->table_name SET post_id = null where post_id = $post_id"));
return $wpdb->update($this->table_name, array('post_id' => $post_id), array('entry_id' => $entry_id));
}
/**
* Tries to get the discussions for a post. If the discussion isn't currently linked to a post,
* it will try to link it based on the title
*
* @param int $post_id
* @param bool $check_cache
* @return object The discussion object from the db
*/
function get_discussion_for_post($post_id, $check_cache = true) {
global $wpdb;
$discussion = ($check_cache ? wp_cache_get('post_' . $post_id, $this->cache_key) : false);
if (!is_object($discussion)) {
//Lookup based on post_id
$discussion = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM $this->table_name WHERE post_id = $post_id" ) );
if (!$discussion) {
//Serialise the post's title & look based on that key
$post = get_post($post_id);
if ($post && $post->post_title) {
$key = $this->format_title(trim($post->post_title));
$discussion = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->table_name WHERE key_val = '%s'", $key));
if ($discussion) {
$discussion->post_id = $post_id;
$this->set_post_for_entry($discussion->entry_id, $post_id);
}
}
}
//If the discussion was found, deserialise the comments & likes & add to the cache
if ($discussion) {
$discussion->comments = unserialize($discussion->comments);
$discussion->likes = unserialize($discussion->likes);
wp_cache_add('post_' . $post_id, $discussion, $this->cache_key);
}
}
return $discussion;
}
/**
* Load the discussions from the FriendFeed API
*
* @return void
*/
function update_friendfeedcomments() {
$options = get_option($this->options_key);
$friendfeed = new FriendFeed($options['nickname']);
if ($options && $friendfeed) {
if ($this->is_debug()) {
$this->printr("Loading FriendFeed Data");
}
$ff_entries = $friendfeed->fetch_user_feed($options['nickname'], $options['servicename']);
if ($ff_entries && is_array($ff_entries->entries)) {
//Load up the posts from FriendFeed up to the max number of posts to load set
for ($i = $this->page_size ; $i <= $this->max_posts_to_load - $this->page_size; $i = $i + $this->page_size) {
$temp_posts = $friendfeed->fetch_user_feed($options['nickname'], $options['servicename'], $i, $this->page_size);
if ($temp_posts && is_array($temp_posts->entries)) {
$ff_entries->entries = array_merge($ff_entries->entries, $temp_posts->entries);
} else {
$i = $this->max_posts_to_load;
}
}
$blog_url = parse_url(strtolower(get_option('home')));
$match_count = 0;
$titles = get_option($this->titles_key);
if (!is_array($titles)) {
$titles = array();
}
foreach($ff_entries->entries as $entry) {
$post_url = parse_url(strtolower($entry->service->profileUrl));
$is_same_blog =
(
$blog_url['host'] == $post_url['host'] ||
$blog_url['host'] == 'www.' . $post_url['host'] ||
'www.' . $blog_url['host'] == $post_url['host']
)
&&
(
($post_url['path'] == $blog_url['path'] . '/') ||
($post_url['path'] .'/' == $blog_url['path']) ||
($post_url['path'] == $blog_url['path'])
);
if ($is_same_blog) {
if ($titles[$entry->id]) {
$this->update_entry($entry->id, $entry->comments, $entry->likes);
} else {
$this->add_entry($entry->id, $entry->title, $entry->comments, $entry->likes);
$titles[$entry->id] = $entry->title;
}
$match_count++;
}
}
update_option($this->titles_key, $titles);
if ($this->is_debug()) {
$this->printr(count($ff_entries->entries) . " entries loaded from FriendFeed");
$this->printr("$match_count entries loaded, " . count($titles) . " total entries stored.");
$this->printr('** Discussions **');
$this->printr($titles);
$this->printr('** Posts **');
$this->printr($ff_entries);
}
} else {
return false;
}
}
return true;
}
/**
* Remove all the data stored for the plugin
*
* @param bool $remove_table If true the database table will be dropped not just deleted
*/
function delete_all_data($remove_table = false) {
delete_option($this->titles_key);
if($remove_table) {
$this->drop_table();
} else {
$this->empty_table();
}
}
/**
* Function to render the options page
*
*/
function options_page() {
$options = get_option($this->options_key);
$error = false;
if ($_POST["wp_friendfeed"]) {
if ($_POST['ff_showdebug']) {
$this->is_debug = true;
}
if ($_POST['Clear']) {
$this->delete_all_data();
if ($this->update_friendfeedcomments()) {
$message = "Discussions reloaded.";
} else {
$error = "Unable to retrieve content from FriendFeed. The API may be down or there may be connectivity problems";
}
} elseif ($_POST['Delete']) {
delete_option($this->options_key);
$this->delete_all_data(true);
unset($_POST);
unset($options);
$message = "All information related to this plugin has been deleted. To finish removing this plugin, deactivate it on the Plugins page";
} else {
if (!$error) {
$options['nickname'] = $_POST['ff_nickname'];
$options['servicename'] = $_POST['ff_servicename'];
$options['showcomments'] = $_POST['ff_showcomments'];
$options['headline'] = $_POST['ff_headline'];
$options['showform'] = $_POST['ff_showform'];
$options['disableshowhide'] = $_POST['ff_disableshowhide'];
$options['usestyles'] = $_POST['ff_usestyles'];
$options['excludejslibrary'] = $_POST['ff_excludejslibrary'];
$options['jslibrary'] = $_POST['ff_jslibrary'];
update_option($this->options_key, $options);
if ($this->update_friendfeedcomments()) {
$message = "Settings Saved. Don't forget to put <?php wp_ffcomments(); ?> on your single post template to display the FriendFeed comments & likes.";
} else {
$error = "Unable to retrieve content from FriendFeed. The API may be down or there may be connectivity problems";
}
}
}
if ($error) {
$message = "Error: " . $error;
}
if ($message) {
?>
>
Did you find this plugin useful? Please consider donating to help me continue developing it and other plugins.
\n";
for($i = 0; $i < $count; $i++) {
$like = $likes[$i];
$output_string .= "\t\t\t\t