Dec 16

AHP Sitewide Recent Posts – hack 2.2ish

I received a comment on the main AHP Sitewide Recent Posts hack about having an issue of just displaying the title for the post. The plugin uses a “option code” to determine which items will be displayed for each post. The idea is, you add the value for each option and that total value lets the plugin know which items to show.

[php] // DISPLAY OPTIONS BITMASK
$grav_flag = 1; // gravatar
$date_flag = 2; // date
$auth_flag = 4; // author name
$com_flag = 8; // comment count
$name_flag = 16; // blog name
$post_flag = 32; // post name
$exc_flag = 64; // post excerpt
$cap_flag = 128; // excerpt capitalization</blockquote>
[/php]

For example, if you only wanted to show the post name, then the option value would be 32.

[php]<?php ahp_recent_posts(5, 90, 32); ?> [/php]

If you wanted to show the post name and the blog name, then the option value would be 48 (32 + 16).

[php]<?php ahp_recent_posts(5, 90, 48); ?> [/php]

To show all items in the post, the option value is 225;

[php]<?php ahp_recent_posts(5, 90, 225); ?> [/php]

Unfortunately, the display part of the plugin was not set to only display those items, so I update the code to only show the post item if the flag is set to true.

[php] echo $begin_wrap;
if($use_date) { echo ‘<div class=”date”>’ . $thisdate . ‘</div>'; }
if($use_grav) { echo ‘<div id=”avatar” style=”margin-left:65px; margin-top:14px;”>’ . $thisgravatar . ‘</div>'; }
if($use_post) { echo ‘<h3>’ . $this_postname . ‘</h3>'; }
if($use_date) { echo ‘<div class=”postmetadata”>&nbsp;@ ‘ . $thistime; }
if($use_auth) { echo ‘<br /><div id=”author”>’ . $thisauthor . ‘</div>'; }
if($use_name) { echo ‘<br /><div id=”blogname”>&nbsp;’ . $this_blogname . ‘</div>'; }
if($use_com) { echo ‘<div id=”comment”> | ‘ . $thiscomment . ‘</div></div>'; }
if($use_exc) { echo ‘<div id=”excerpt”>’ . $thisexcerpt . ‘</div>'; }
echo $end_wrap . “\n”;
[/php]

Thanks to Kit at http://kitmobley.com/ for pointing out the issue to me.

The complete code

[php collapse=”true”]
<?php

/*
Plugin Name: AHP Sitewide Recent Posts for WordPress MU
Plugin URI: http://www.metablog.us/blogging/ahp-recent-posts-plugin-for-wordpress-mu/
Description: Retrieves a highly customizable list of the most recent sitewide posts in a WordPress MU installation. Automatically excludes blog ID 1 (main blog), and post ID 1 (first “Hello World” posts of new blogs).
Author: Aziz Poonawalla
Author URI: http://metablog.us

FUNCTION ARGUMENTS

$how_many: how many recent posts are being displayed
$how_long: time frame to choose recent posts from (in days)
$optmask: bitmask for various display options (default: 255)
DISPLAY OPTIONS BITMASK
1; // gravatar
2; // date
4; // author name
8; // comment count
16; // blog name
32; // post name
64; // post excerpt
128; // excerpt capitalization
$exc_size: size of excerpt in words (default: 30)
$begin_wrap: start html code (default: <li class=”ahp_recent-posts”>)
$end_wrap: end html code to adapt to different themes (default: </li>)

SAMPLE FUNCTION CALL

to show 5 posts from recent 30 days: <?php ahp_recent_posts(5, 30); ?>

SAMPLE CSS

gravatar styling: img.avatar-24 { float: left; padding: 0px; border: none; margin: 4px; clear: left; }
LI styling: li.ahp-recent-posts { list-style-type: none ;}
excerpt styling: .ahp-excerpt { margin-top: 2px }

TODO:

– link gravatar icon to Extended Profile in buddypress, if installed
– widgetize
– show more than one post per blog

CHANGELOG
Version 0.8
Update Author: Dean Logan
Update Author URI: http://www.dean-logan.com
– Altered the post query to be a count
– added a “per site” limit for the number of posts per site
– modified closing call to include the “per site” limit

Version 0.7
Update Author: Dean Logan
Update Author URI: http://www.dean-logan.com
– altered loops add an array to store comments
– sort comment array and then display
– altered display layout

Version 0.6
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added comment count display option
– added enable/disable excerpt capitalization
– consolidated title/name of post display options into bitmask
– reduced number of required arguments
– added class name ahp-recent-posts to default start html LI tags
– added class ahp-excerpt to excerpt block

Version 0.5
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– changed gravatar link to point to all posts by author on main blog (ID = 1).
– added date string, author output
– implemented bitmask to control gravatar, date, author output
– consolidated numwords argument with display argument

Version 0.4.1
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added gravatar support, icon size 24px
– gravatar can be styled by img.avatar-24 in your css file
– gravatar image links to author’s blog
– capitalization of first five words of the excerpt

Version 0.4.0
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added exclusions for first blog, first post, enabled post excerpt

Version: 0.32
Update Author: G. Morehouse
Update Author URI: http://wiki.evernex.com/index.php?title=Wordpress_MU_sitewide_recent_posts_plugin

Version: 0.31
Update Author: Sven Laqua
Update Author URI: http://www.sl-works.de/

Version: 0.3
Author: Ron Rennick
Author URI: http://atypicalhomeschool.net/
*/

function ahp_recent_posts($how_many, $how_long, $optmask = 255, $exc_size = 30, $per_site = 5, $begin_wrap = ‘<li class=”ahp_recent-posts”>’, $end_wrap = ‘</li>’) {
global $wpdb;
$counter = 0;

// EDIT THESE TO CUSTOMIZE THE OUTPUT
$debug = 0;
$blog_prefix = “Posted from “;
$post_prefix = “”;
$auth_prefix = ‘Posted by ‘;
$com_prefix = ‘ &nbsp; currently ‘;
$date_format = ‘D M jS, Y';
$grav_size = 60;

// DISPLAY OPTIONS BITMASK
$grav_flag = 1; // gravatar
$date_flag = 2; // date
$auth_flag = 4; // author name
$com_flag = 8; // comment count
$name_flag = 16; // blog name
$post_flag = 32; // post name
$exc_flag = 64; // post excerpt
$cap_flag = 128; // excerpt capitalization

// set the various option flags
if ($optmask & $grav_flag) { $use_grav = 1; } else { $use_grav = 0; }
if ($optmask & $date_flag) { $use_date = 1; } else { $use_date = 0; }
if ($optmask & $auth_flag) { $use_auth = 1; } else { $use_auth = 0; }
if ($optmask & $com_flag) { $use_com = 1; } else { $use_com = 0; }
if ($optmask & $name_flag) { $use_name = 1; } else { $use_name = 0; }

if ($optmask & $post_flag) { $use_post = 1; } else { $use_post = 0; }
if ($optmask & $exc_flag) { $use_exc = 1; } else { $use_exc = 0; }
if ($optmask & $cap_flag) { $use_cap = 1; } else { $use_cap = 0; }

// debug block
if ($debug) {
echo ‘<hr>’.’opt = ‘.$optmask.': grav = ‘.$use_grav.’, date = ‘.$use_date
.’, auth = ‘.$use_auth.’, use_com = ‘.$use_com.’, use_name = ‘.$use_name
.’, use_post = ‘.$use_post.’, use_exc = ‘.$use_exc.’, use_cap = ‘.$use_cap;
}

// get a list of blogs in order of most recent update. show only public and nonarchived/spam/mature/deleted
$blogs = $wpdb->get_col(“SELECT blog_id FROM $wpdb->blogs WHERE
public = ‘1’ AND archived = ‘0’ AND mature = ‘0’ AND spam = ‘0’ AND deleted = ‘0’ AND
last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
ORDER BY last_updated DESC”);

$postArray = array();
$i = 0;
if ($blogs) {
echo ‘<ul class=”ahp_recent-posts”>’ . “\n”;
foreach ($blogs as $blog) {

// we need _posts, _comments, and _options tables for this to work
$blogPostsTable = “wp_”.$blog.”_posts”;

// debug block
if ($debug) {
echo ‘<hr>processing blog ‘.$blog.’ = <a href=”‘.
$options[0]->option_value.'”>’.$options[1]->option_value.'</a> <br>';
}

// fetch the ID, post title, post content, post date, and user’s email for the latest post
$sqlCount = “SELECT count($blogPostsTable.ID) “;
$sqlSelect = “SELECT $blogPostsTable.post_date, $blog AS this_blog, $blogPostsTable.ID, $blogPostsTable.post_title,
$blogPostsTable.post_content, wp_users.display_name,
wp_users.user_email, wp_users.user_login “;
$sqlFrom = ” FROM $blogPostsTable, wp_users
WHERE wp_users.ID = $blogPostsTable.post_author
AND post_status = ‘publish’ AND post_type = ‘post’
AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
AND $blogPostsTable.id > 1 “;
// build the count query
$sql = $sqlCount . ” . $sqlFrom;
$postcount = $wpdb->get_var($sql);
// if posts are found, cycle through the count and get the correct number of posts
if($postcount > 0) {
if ($postcount > $per_site) {
$site_limit = $per_site;
} else {
$site_limit = $postcount;
}
for($x = 0; $x < $site_limit; $x++){
$sqlOrder = ” ORDER BY $blogPostsTable.post_date DESC limit $x,1″;
$sql = $sqlSelect . ” . $sqlFrom .”. $sqlOrder;
$postArray[$i] = $wpdb->get_row($sql, ARRAY_A);
$i++;
}
}
}

if(count($postArray) > 0){
array_multisort($postArray, SORT_DESC);
while ($counter < count($postArray)){

// debug block
if ($debugflag) {
echo ‘processing thispost ID = ‘ . $postArray[$counter][‘ID’] . ‘<br>';
echo ‘post_title = ‘ . $postArray[$counter][‘post_title’] . ‘<br>';
echo ‘post_content = ‘ . $postArray[$counter][‘post_content’] . ‘<br>';
echo ‘post_date = ‘ . $postArray[$counter][‘post_date’] . ‘<br>';
echo ‘display_name = ‘ . $postArray[$counter][‘display_name’] . ‘<br>';
echo ‘user_email = ‘ . $postArray[$counter][‘user_email’] . ‘<br>';
echo ‘user_login = ‘ . $postArray[$counter][‘user_login’] . ‘<br>';
echo ‘site_url = ‘ . $postArray[$counter][‘option_value’] . ‘<br>';
}

// get post ID
$thispostID = $postArray[$counter][‘ID’];

// get permalink by ID. check wp-includes/wpmu-functions.php
$thispermalink = get_blog_permalink( $postArray[$counter][‘this_blog’], $thispostID);

// set blog tables
$blogOptionsTable = “wp_” . $postArray[$counter][‘this_blog’] . “_options”;
$blogCommentsTable = “wp_” . $postArray[$counter][‘this_blog’] . “_comments”;

// get blog name, URL
if ($use_name) {

$options = $wpdb->get_results(“SELECT option_value FROM
$blogOptionsTable WHERE option_name IN (‘siteurl’,’blogname’)
ORDER BY option_name DESC”);

$blog_link = $options[0]->option_value;
$blog_name = $options[1]->option_value;
$this_blogname = $blog_prefix.'<a href=”‘ . $blog_link . ‘”>’ . $blog_name . ‘</a>';

} else { $this_blogname = ”; }

// get comments
if ($use_com) {

// sql query for all comments on the current post
$thesecomments = $wpdb->get_results(“SELECT comment_ID
FROM $blogCommentsTable
WHERE comment_post_ID = $thispostID”);

// count total number of comments
$num_comments = sizeof($thesecomments);

// pretty text
if ($num_comments == 0) { $thiscomment = $com_prefix.’no comments'; }
elseif ($num_comments == 1) { $thiscomment = $com_prefix.’one comment'; }
else { $thiscomment = $com_prefix.$num_comments.’ comments'; }

} else { $thiscomment = ”; }

// get author
if ($use_auth) {
$thisauthor = $auth_prefix.$postArray[$counter][‘display_name’];
} else { $thisauthor = ”; }

// get author’s posts link
$thisuser = $thispost[0]->user_login;
$thisuser_url = $thisbloglink.”author/”.$thisuser;

// get gravatar
if ($use_grav) {
$grav_img = get_avatar( $postArray[$counter][‘user_email’] , $grav_size );
$thisgravatar = ‘<a href=”‘.$thisuser_url.'”>’.$grav_img.'</a>';
} else { $thisgravatar = ”; }

// get post date (nicely formatted)
if ($use_date) {
//$thisdate = date($date_format, strtotime( $thispost[0]->post_date )) ;
$thisdate = ‘<span class=”dateMonth”>’ . date(‘M’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class=”dateDay”>’ . date(‘d’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class=”dateYear”>’ . date(‘Y’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thistime = date(‘g:i a’, strtotime( $postArray[$counter][‘post_date’] ));
} else { $thisdate = ”; }

// get post name
if ($use_post) {
$this_postname = $post_prefix . ‘<a href=”‘ . $thispermalink . ‘”>’ .$postArray[$counter][‘post_title’] . ‘</a><br>';
} else {
$this_postname = ”; }

if ($use_exc) {
if ($exc_size == 0) {
$thisexcerpt = ”;
} else {
// get post content and truncate to (numwords) words
$thiscontent = strip_tags( $postArray[$counter][‘post_content’] );
preg_match(“/([\S]+\s*){0,$exc_size}/”, $thiscontent, $regs);

if ($use_cap) {
// build the excerpt html block, capitalize first five words
$trunc_content = explode( ‘ ‘, trim($regs[0]) , 6 );
$exc_str = strtoupper($trunc_content[0]).’ ‘
.strtoupper($trunc_content[1]).’ ‘
.strtoupper($trunc_content[2]).’ ‘
.strtoupper($trunc_content[3]).’ ‘
.strtoupper($trunc_content[4]).’ ‘
.$trunc_content[5].’… ‘;
} else { $exc_str = trim($regs[0]); }

$thisexcerpt = ‘<span style=”ahp-excerpt”>’.$exc_str
.'<a href=”‘.$thispermalink.'”>’
.’&raquo;&raquo;MORE’.'</a></span>';
}
} else { $thisexcerpt = ”; }

echo $begin_wrap;
if($use_date) { echo ‘<div class=”date”>’ . $thisdate . ‘</div>'; }
if($use_grav) { echo ‘<div id=”avatar” style=”margin-left:65px; margin-top:14px;”>’ . $thisgravatar . ‘</div>'; }
if($use_post) { echo ‘<h3>’ . $this_postname . ‘</h3>'; }
if($use_date) { echo ‘<div class=”postmetadata”>&nbsp;@ ‘ . $thistime; }
if($use_auth) { echo ‘<br /><div id=”author”>’ . $thisauthor . ‘</div>'; }
if($use_name) { echo ‘<br /><div id=”blogname”>&nbsp;’ . $this_blogname . ‘</div>'; }
if($use_com) { echo ‘<div id=”comment”> | ‘ . $thiscomment . ‘</div></div>'; }
if($use_exc) { echo ‘<div id=”excerpt”>’ . $thisexcerpt . ‘</div>'; }
echo $end_wrap . “\n”;

$counter++;

// don’t go over the limit
if($counter >= ($how_many)) {
break;
}
}
}
}
else {
//echo “no recent posts meet the criteria…<br>”;
}
}
?>
[/php]

Oct 07

AHP Sitewide Recent Posts – hack 2.1ish

It’s funny how things happen to fall into place. Jacob over at 912Candidates.org was lamenting over the issue of not keeping the main page up-to-date. A few of the state sites have been posting updates, but Jacob has been a little busy and didn’t have anything to put on his front page. If only, he thought, there was a way to show the posts from the other sites. Well, what do you know, I was just playing around with a plug-in that did that. After pointing Jacob to the example on NC Freedom, he came back with some changes. The biggest change that he wanted was to use the flag icon I was using for each site instead of the avatar for the user.

When I created the one off Gold List plug-in for the 912Candidate site, I used avatar images that depict state flags. I decided to be a little creative and spice up the list with these flags and it turned out really well. Initially I had some issues getting the flags to work, because I needed an easy way to get the file name based off of the site. Each state site used the state abbreviation and the file names used the full name of the state. I didn’t want to rename all the image files, so I created an array to hold the values.

[php]
// state list
$stateList = array( ‘AL’ => ‘Alabama’, ‘AK’ => ‘Alaska’, ‘AZ’ => ‘Arizona’, ‘AR’ => ‘Arkansas’, ‘CA’ => ‘California’,
‘CO’ => ‘Colorado’, ‘CT’ => ‘Connecticut’, ‘DE’ => ‘Delaware’, ‘DC’ => ‘District of Columbia’, ‘FL’ => ‘Florida’,
‘GA’ => ‘Georgia’, ‘HI’ => ‘Hawaii’, ‘ID’ => ‘Idaho’, ‘IL’ => ‘Illinois’, ‘IN’ => ‘Indiana’, ‘IA’ => ‘Iowa’,
‘KS’ => ‘Kansas’, ‘KY’ => ‘Kentucky’, ‘LA’ => ‘Louisiana’, ‘ME’ => ‘Maine’, ‘MD’ => ‘Maryland’, ‘MA’ => ‘Massachusetts’,
‘MI’ => ‘Michigan’, ‘MN’ => ‘Minnesota’, ‘MS’ => ‘Mississippi’, ‘MO’ => ‘Missouri’, ‘MT’ => ‘Montana’, ‘NE’ => ‘Nebraska’,
‘NV’ => ‘Nevada’, ‘NH’ => ‘New Hampshire’, ‘NJ’ => ‘New Jersey’, ‘NM’ => ‘New Mexico’, ‘NY’ => ‘New York’, ‘NC’ => ‘North Carolina’,
‘ND’ => ‘North Dakota’, ‘OH’ => ‘Ohio’, ‘OK’ => ‘Oklahoma’, ‘OR’ => ‘Oregon’, ‘PA’ => ‘Pennsylvania’, ‘RI’ => ‘Rhode Island’,
‘SC’ => ‘South Carolina’, ‘SD’ => ‘South Dakota’, ‘TN’ => ‘Tennessee’, ‘TX’ => ‘Texas’, ‘UT’ => ‘Utah’, ‘VT’ => ‘Vermont’,
‘VA’ => ‘Virginia’, ‘WA’ => ‘Washington’, ‘WV’ => ‘West Virginia’, ‘WI’ => ‘Wisconsin’, ‘WY’ => ‘Wyoming’ );
[/php]

By having the array, I could always add more values or use either the initial to get the name or the name to get the initial.
I updated the code to search through the array and match up a substring of the blog link to the state abbreviations. If an abbreviation matched, then the code for adding the image is added to the variable. I replaced the avatar variable value with this new variable. It makes for a nice effect on the main page of 912Candidates.
[php]
foreach ($stateList as $abbr => $stateName){
if($abbr == strtoupper(substr($blog_link,strpos($blog_link,’org’) + 4, 2))){
$this_blog_image = ‘<img src="/resources/flags/’ .
$stateName .
‘.gif" height="55" width="55" border="0" align="left" style="padding-right: 5pt;" />';
}
}
[/php]

Sep 29

AHP Sitewide Recent Posts – hack 2.0

After completing the initial hack, I went back to my production site and noticed that only one post from each site was being displayed. I believe this was the original intent of the plug-in, but I think that needs to be changed, so I made a little improvement. So now, the plug-in lets you set a max limit on the number of post per site. If you have a lot of sites, you’ll probably want to up the number of posts to display in general. Here is what I did.

The first thing I did was to split up the sql code into different parts.
The first part was changed to a simple count of the number of posts available.
[php]$sqlCount = “SELECT count($blogPostsTable.ID) “;[/php]
The second part is the actual full select statement to get the post information.
[php]$sqlSelect = “SELECT $blogPostsTable.post_date, $blog AS this_blog, $blogPostsTable.ID, $blogPostsTable.post_title,
$blogPostsTable.post_content, wp_users.display_name,
wp_users.user_email, wp_users.user_login “;[/php]
The third part is the rest of the select statement, except the order by, which will be used by both select statements.
[php]$sqlFrom = ” FROM $blogPostsTable, wp_users
WHERE wp_users.ID = $blogPostsTable.post_author
AND post_status = ‘publish’ AND post_type = ‘post’
AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
AND $blogPostsTable.id > 1 “;[/php]
The final part is the order by and limit statement that will be dynamically created based on the number of posts found.
[php]$sqlOrder = “ORDER BY $blogPostsTable.post_date DESC limit $x,1″;[/php]

As before, there is an initial query to get the number of posts available. But, I changed it to a var query, which will reduce the call to the database.
[php]
// build the count query
$sql = $sqlCount . ” . $sqlFrom;
$postcount = $wpdb->get_var($sql);
[/php]
Once I get that value back, if there are more than 0 posts, then I loop through the call getting each post and inserting it into the array.
I have to first make sure that the number of posts is not less than the per site post limit. If it is less, I use that number, but if it is more, then I just use the per site limit. The “x” counter lets me start the limit at the proper post and only go 1 row from that point. For example, when $x is 4, it goes to row 4 and gets only that one row. I rebuild the query and then get the post data to insert into the array, with the $i counting the array rows.
[php]
if($postcount > 0) {
if ($postcount > $per_site) {
$site_limit = $per_site;
} else {
$site_limit = $postcount;
}
for($x = 0; $x < $site_limit; $x++){
$sqlOrder = ” ORDER BY $blogPostsTable.post_date DESC limit $x,1″;
$sql = $sqlSelect . ” . $sqlFrom .”. $sqlOrder;
$postArray[$i] = $wpdb->get_row($sql, ARRAY_A);
$i++;
}
}
[/php]
To make sure the page formatting doesn’t break, I added the “per site” limit to the “how many” limit to make sure that the counter doesn’t go to high.
I changed out the $a counter with the $counter variable. And made sure that the “break” call was inside the while loop.

Finally I added a parameter to the function and defaulted the value at 2 per site.
[php]
function ahp_recent_posts($how_many, $how_long, $optmask = 255, $exc_size = 30, $per_site = 2, $begin_wrap = ‘<li class=”ahp_recent-posts”>’, $end_wrap = ‘</li>’)
[/php]

Here is the complete code
[php collapse=”true”]
<?php

/*
Plugin Name: AHP Sitewide Recent Posts for WordPress MU
Plugin URI: http://www.metablog.us/blogging/ahp-recent-posts-plugin-for-wordpress-mu/
Description: Retrieves a highly customizable list of the most recent sitewide posts in a WordPress MU installation. Automatically excludes blog ID 1 (main blog), and post ID 1 (first “Hello World” posts of new blogs).
Author: Aziz Poonawalla
Author URI: http://metablog.us

FUNCTION ARGUMENTS

$how_many: how many recent posts are being displayed
$how_long: time frame to choose recent posts from (in days)
$optmask: bitmask for various display options (default: 255)
DISPLAY OPTIONS BITMASK
1; // gravatar
2; // date
4; // author name
8; // comment count
16; // blog name
32; // post name
64; // post excerpt
128; // excerpt capitalization
$exc_size: size of excerpt in words (default: 30)
$begin_wrap: start html code (default: <li class=”ahp_recent-posts”>)
$end_wrap: end html code to adapt to different themes (default: </li>)

SAMPLE FUNCTION CALL

to show 5 posts from recent 30 days: <?php ahp_recent_posts(5, 30); ?>

SAMPLE CSS

gravatar styling: img.avatar-24 { float: left; padding: 0px; border: none; margin: 4px; clear: left; }
LI styling: li.ahp-recent-posts { list-style-type: none ;}
excerpt styling: .ahp-excerpt { margin-top: 2px }

TODO:

– link gravatar icon to Extended Profile in buddypress, if installed
– widgetize
– show more than one post per blog

CHANGELOG
Version 0.8
Update Author: Dean Logan
Update Author URI: http://www.dean-logan.com
– Altered the post query to be a count
– added a “per site” limit for the number of posts per site
– modified closing call to include the “per site” limit

Version 0.7
Update Author: Dean Logan
Update Author URI: http://www.dean-logan.com
– altered loops add an array to store comments
– sort comment array and then display
– altered display layout

Version 0.6
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added comment count display option
– added enable/disable excerpt capitalization
– consolidated title/name of post display options into bitmask
– reduced number of required arguments
– added class name ahp-recent-posts to default start html LI tags
– added class ahp-excerpt to excerpt block

Version 0.5
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– changed gravatar link to point to all posts by author on main blog (ID = 1).
– added date string, author output
– implemented bitmask to control gravatar, date, author output
– consolidated numwords argument with display argument

Version 0.4.1
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added gravatar support, icon size 24px
– gravatar can be styled by img.avatar-24 in your css file
– gravatar image links to author’s blog
– capitalization of first five words of the excerpt

Version 0.4.0
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added exclusions for first blog, first post, enabled post excerpt

Version: 0.32
Update Author: G. Morehouse
Update Author URI: http://wiki.evernex.com/index.php?title=Wordpress_MU_sitewide_recent_posts_plugin

Version: 0.31
Update Author: Sven Laqua
Update Author URI: http://www.sl-works.de/

Version: 0.3
Author: Ron Rennick
Author URI: http://atypicalhomeschool.net/
*/

function ahp_recent_posts($how_many, $how_long, $optmask = 255, $exc_size = 30, $per_site = 5, $begin_wrap = ‘<li class=”ahp_recent-posts”>’, $end_wrap = ‘</li>’) {
global $wpdb;
$counter = 0;

// EDIT THESE TO CUSTOMIZE THE OUTPUT
$debug = 0;
$blog_prefix = “Posted from “;
$post_prefix = “”;
$auth_prefix = ‘Posted by ‘;
$com_prefix = ‘ &nbsp; currently ‘;
$date_format = ‘D M jS, Y';
$grav_size = 60;

// DISPLAY OPTIONS BITMASK
$grav_flag = 1; // gravatar
$date_flag = 2; // date
$auth_flag = 4; // author name
$com_flag = 8; // comment count
$name_flag = 16; // blog name
$post_flag = 32; // post name
$exc_flag = 64; // post excerpt
$cap_flag = 128; // excerpt capitalization

// set the various option flags
if ($optmask & $grav_flag) { $use_grav = 1; } else { $use_grav = 0; }
if ($optmask & $date_flag) { $use_date = 1; } else { $use_date = 0; }
if ($optmask & $auth_flag) { $use_auth = 1; } else { $use_auth = 0; }
if ($optmask & $com_flag) { $use_com = 1; } else { $use_com = 0; }
if ($optmask & $name_flag) { $use_name = 1; } else { $use_name = 0; }

if ($optmask & $post_flag) { $use_post = 1; } else { $use_post = 0; }
if ($optmask & $exc_flag) { $use_exc = 1; } else { $use_exc = 0; }
if ($optmask & $cap_flag) { $use_cap = 1; } else { $use_cap = 0; }

// debug block
if ($debug) {
echo ‘<hr>’.’opt = ‘.$optmask.': grav = ‘.$use_grav.’, date = ‘.$use_date
.’, auth = ‘.$use_auth.’, use_com = ‘.$use_com.’, use_name = ‘.$use_name
.’, use_post = ‘.$use_post.’, use_exc = ‘.$use_exc.’, use_cap = ‘.$use_cap;
}

// get a list of blogs in order of most recent update. show only public and nonarchived/spam/mature/deleted
$blogs = $wpdb->get_col(“SELECT blog_id FROM $wpdb->blogs WHERE
public = ‘1’ AND archived = ‘0’ AND mature = ‘0’ AND spam = ‘0’ AND deleted = ‘0’ AND
last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
ORDER BY last_updated DESC”);

$postArray = array();
$i = 0;
if ($blogs) {
echo ‘<ul class=”ahp_recent-posts”>’ . “\n”;
foreach ($blogs as $blog) {

// we need _posts, _comments, and _options tables for this to work
$blogPostsTable = “wp_”.$blog.”_posts”;

// debug block
if ($debug) {
echo ‘<hr>processing blog ‘.$blog.’ = <a href=”‘.
$options[0]->option_value.'”>’.$options[1]->option_value.'</a> <br>';
}

// fetch the ID, post title, post content, post date, and user’s email for the latest post
$sqlCount = “SELECT count($blogPostsTable.ID) “;
$sqlSelect = “SELECT $blogPostsTable.post_date, $blog AS this_blog, $blogPostsTable.ID, $blogPostsTable.post_title,
$blogPostsTable.post_content, wp_users.display_name,
wp_users.user_email, wp_users.user_login “;
$sqlFrom = ” FROM $blogPostsTable, wp_users
WHERE wp_users.ID = $blogPostsTable.post_author
AND post_status = ‘publish’ AND post_type = ‘post’
AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
AND $blogPostsTable.id > 1 “;
// build the count query
$sql = $sqlCount . ” . $sqlFrom;
$postcount = $wpdb->get_var($sql);
// if posts are found, cycle through the count and get the correct number of posts
if($postcount > 0) {
if ($postcount > $per_site) {
$site_limit = $per_site;
} else {
$site_limit = $postcount;
}
for($x = 0; $x < $site_limit; $x++){
$sqlOrder = ” ORDER BY $blogPostsTable.post_date DESC limit $x,1″;
$sql = $sqlSelect . ” . $sqlFrom .”. $sqlOrder;
$postArray[$i] = $wpdb->get_row($sql, ARRAY_A);
$i++;
}
}
}

if(count($postArray) > 0){
array_multisort($postArray, SORT_DESC);
while ($counter < count($postArray)){

// debug block
if ($debugflag) {
echo ‘processing thispost ID = ‘ . $postArray[$counter][‘ID’] . ‘<br>';
echo ‘post_title = ‘ . $postArray[$counter][‘post_title’] . ‘<br>';
echo ‘post_content = ‘ . $postArray[$counter][‘post_content’] . ‘<br>';
echo ‘post_date = ‘ . $postArray[$counter][‘post_date’] . ‘<br>';
echo ‘display_name = ‘ . $postArray[$counter][‘display_name’] . ‘<br>';
echo ‘user_email = ‘ . $postArray[$counter][‘user_email’] . ‘<br>';
echo ‘user_login = ‘ . $postArray[$counter][‘user_login’] . ‘<br>';
echo ‘site_url = ‘ . $postArray[$counter][‘option_value’] . ‘<br>';
}

// get post ID
$thispostID = $postArray[$counter][‘ID’];

// get permalink by ID. check wp-includes/wpmu-functions.php
$thispermalink = get_blog_permalink( $postArray[$counter][‘this_blog’], $thispostID);

// set blog tables
$blogOptionsTable = “wp_” . $postArray[$counter][‘this_blog’] . “_options”;
$blogCommentsTable = “wp_” . $postArray[$counter][‘this_blog’] . “_comments”;

// get blog name, URL
if ($use_name) {

$options = $wpdb->get_results(“SELECT option_value FROM
$blogOptionsTable WHERE option_name IN (‘siteurl’,’blogname’)
ORDER BY option_name DESC”);

$blog_link = $options[0]->option_value;
$blog_name = $options[1]->option_value;
$this_blogname = $blog_prefix.'<a href=”‘ . $blog_link . ‘”>’ . $blog_name . ‘</a>';

} else { $this_blogname = ”; }

// get comments
if ($use_com) {

// sql query for all comments on the current post
$thesecomments = $wpdb->get_results(“SELECT comment_ID
FROM $blogCommentsTable
WHERE comment_post_ID = $thispostID”);

// count total number of comments
$num_comments = sizeof($thesecomments);

// pretty text
if ($num_comments == 0) { $thiscomment = $com_prefix.’no comments'; }
elseif ($num_comments == 1) { $thiscomment = $com_prefix.’one comment'; }
else { $thiscomment = $com_prefix.$num_comments.’ comments'; }

} else { $thiscomment = ”; }

// get author
if ($use_auth) {
$thisauthor = $auth_prefix.$postArray[$counter][‘display_name’];
} else { $thisauthor = ”; }

// get author’s posts link
$thisuser = $thispost[0]->user_login;
$thisuser_url = $thisbloglink.”author/”.$thisuser;

// get gravatar
if ($use_grav) {
$grav_img = get_avatar( $postArray[$counter][‘user_email’] , $grav_size );
$thisgravatar = ‘<a href=”‘.$thisuser_url.'”>’.$grav_img.'</a>';
} else { $thisgravatar = ”; }

// get post date (nicely formatted)
if ($use_date) {
//$thisdate = date($date_format, strtotime( $thispost[0]->post_date )) ;
$thisdate = ‘<span class=”dateMonth”>’ . date(‘M’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class=”dateDay”>’ . date(‘d’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class=”dateYear”>’ . date(‘Y’, strtotime( $postArray[$counter][‘post_date’] )) . ‘</span>';
$thistime = date(‘g:i a’, strtotime( $postArray[$counter][‘post_date’] ));
} else { $thisdate = ”; }

// get post name
if ($use_post) {
$this_postname = $post_prefix . ‘<a href=”‘ . $thispermalink . ‘”>’ .$postArray[$counter][‘post_title’] . ‘</a><br>';
} else {
$this_postname = ”; }

if ($use_exc) {
if ($exc_size == 0) {
$thisexcerpt = ”;
} else {
// get post content and truncate to (numwords) words
$thiscontent = strip_tags( $postArray[$counter][‘post_content’] );
preg_match(“/([\S]+\s*){0,$exc_size}/”, $thiscontent, $regs);

if ($use_cap) {
// build the excerpt html block, capitalize first five words
$trunc_content = explode( ‘ ‘, trim($regs[0]) , 6 );
$exc_str = strtoupper($trunc_content[0]).’ ‘
.strtoupper($trunc_content[1]).’ ‘
.strtoupper($trunc_content[2]).’ ‘
.strtoupper($trunc_content[3]).’ ‘
.strtoupper($trunc_content[4]).’ ‘
.$trunc_content[5].’… ‘;
} else { $exc_str = trim($regs[0]); }

$thisexcerpt = ‘<span style=”ahp-excerpt”>’.$exc_str
.'<a href=”‘.$thispermalink.'”>’
.’&raquo;&raquo;MORE’.'</a></span>';
}
} else { $thisexcerpt = ”; }

echo $begin_wrap
. ‘<div class=”date”>’ . $thisdate . ‘</div>’
. ‘<div id=”avatar” style=”margin-left:65px; margin-top:14px;”>’ . $thisgravatar . ‘</div>’
. ‘<h3>’ . $this_postname . ‘</h3>’
. ‘<div class=”postmetadata”>&nbsp;@ ‘ . $thistime . ‘<br /><div id=”author”>’ . $thisauthor . ‘</div>’
. ‘<br /><div id=”blogname”>&nbsp;’ . $this_blogname . ‘</div><div id=”comment”> | ‘ . $thiscomment . ‘</div></div>’
. ‘<div id=”excerpt”>’ . $thisexcerpt . ‘</div>’
. $end_wrap . “\n”;

$counter++;

// don’t go over the limit
if($counter >= ($how_many)) {
break;
}
}
}
}
else {
//echo “no recent posts meet the criteria…<br>”;
}
}
?>
[/php]

Sep 29

Sitewide Recent Posts – hack

I started using WordPress Mu for a couple of sites that I am helping out with. The key to WordPress Mu is the ability to have multiple WordPress sites under the control of a main WordPress site. For example, if you have a common topic, you can have multiple sub-sites under the main site. Examples of these are the two sites I am helping out with 9/12 Candidates and NC Freedom. While 912 Candidates has sub-sites based on each state, NC Freedom uses sub-sites based on regions within the state.

Another part of WordPress Mu is the ability to have a sitewide plug-in. A sitewide plugin can pull information throughout the site. On 912 Candidates I create a sitewide plug-in to handle the Gold List of candidates. It allows each sub-site to enter in their candidate and have the Gold Lists update across the site accordingly.

For the NC Freedom site, I needed a way to show the most recent post from across the site. Luckily, WordPress Mu has a site with plug-ins created for sitewide use. On this site I found AHP Sitewide Recent Posts. Unfortunately there was a slight issue with how the recent posts were returned.

The 0.6.1 version would get each blog based on the update date value and then get each post for those blogs, posting the excerpts as it went through each blog. This meant, that if a blog was updated for any reason, it might have an early update date and it’s posts would show as being newer than other posts that were in reality posted more recently. The best option would be to put all of the posts into an array, then sort the array on the post date and then finally display them in the appropriate order.

The first change I made was to add an array variable and a counter.
[php]
$postArray = array();
$i = 0;
[/php]
Next I shortened the loop area to only include the blog and post queries and not display any output. This also included separating out the sql statement for the comment query, since I would be using this twice. First to loop through each comment and then second to insert that comment into the array. The “$i” counter allows each post to be inserted at the next array spot. I also modified the query to put the post date as the first column and the second column as the blog id ($blog AS this_blog). These changes will help with the sorting and permalink structure.
[php]
foreach ($blogs as $blog) {

// we need _posts, _comments, and _options tables for this to work
$blogPostsTable = "wp_".$blog."_posts";…

// fetch the ID, post title, post content, post date, and user’s email for the latest post
$sql = "SELECT $blogPostsTable.post_date, $blog AS this_blog, $blogPostsTable.ID, $blogPostsTable.post_title,
$blogPostsTable.post_content, wp_users.display_name,
wp_users.user_email, wp_users.user_login
FROM $blogPostsTable, wp_users
WHERE wp_users.ID = $blogPostsTable.post_author
AND post_status = ‘publish’ AND post_type = ‘post’
AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
AND $blogPostsTable.id > 1
ORDER BY $blogPostsTable.post_date DESC limit 0,1";
$thispost = $wpdb->get_results($sql);

// if it is found put it into the Array
if($thispost) {

$postArray[$i] = $wpdb->get_row($sql, ARRAY_A);
$i++;
}
}
[/php]
Finally, after the array is done, there is a check to see if there are actual rows in the array. If there are rows, then the array is sorted by the first column, which is the post date. Then the script loops through the array to display each posts.

[php]
if(count($postArray) > 0){
array_multisort($postArray, SORT_DESC);
for ($a = 0; $a < count($postArray); $a++){
[/php]

When each row is called, a little different syntax is required. There has to be a reference to the array item, then the column.
[php]$postArray[$a][‘post_date’][/php]

Here is the complete modified script. The displaying of the post has been modified to fit better with the layout of site I am using it on. Look here for the working example.
[php collapse=”true”]
<?php

/*
Plugin Name: AHP Sitewide Recent Posts for WordPress MU
Plugin URI: http://www.metablog.us/blogging/ahp-recent-posts-plugin-for-wordpress-mu/
Description: Retrieves a highly customizable list of the most recent sitewide posts in a WordPress MU installation. Automatically excludes blog ID 1 (main blog), and post ID 1 (first "Hello World" posts of new blogs).
Author: Aziz Poonawalla
Author URI: http://metablog.us

FUNCTION ARGUMENTS

$how_many: how many recent posts are being displayed
$how_long: time frame to choose recent posts from (in days)
$optmask: bitmask for various display options (default: 255)
DISPLAY OPTIONS BITMASK
1; // gravatar
2; // date
4; // author name
8; // comment count
16; // blog name
32; // post name
64; // post excerpt
128; // excerpt capitalization
$exc_size: size of excerpt in words (default: 30)
$begin_wrap: start html code (default: <li class="ahp_recent-posts">)
$end_wrap: end html code to adapt to different themes (default: </li>)

SAMPLE FUNCTION CALL

to show 5 posts from recent 30 days: <?php ahp_recent_posts(5, 30); ?>

SAMPLE CSS

gravatar styling: img.avatar-24 { float: left; padding: 0px; border: none; margin: 4px; clear: left; }
LI styling: li.ahp-recent-posts { list-style-type: none ;}
excerpt styling: .ahp-excerpt { margin-top: 2px }

TODO:

– link gravatar icon to Extended Profile in buddypress, if installed
– widgetize
– show more than one post per blog

CHANGELOG
Version 0.7
Update Author: Dean Logan
Update Author URI: http://www.dean-logan.com
– altered loops add an array to store comments
– sort comment array and then display
– altered display layout

Version 0.6
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added comment count display option
– added enable/disable excerpt capitalization
– consolidated title/name of post display options into bitmask
– reduced number of required arguments
– added class name ahp-recent-posts to default start html LI tags
– added class ahp-excerpt to excerpt block

Version 0.5
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– changed gravatar link to point to all posts by author on main blog (ID = 1).
– added date string, author output
– implemented bitmask to control gravatar, date, author output
– consolidated numwords argument with display argument

Version 0.4.1
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added gravatar support, icon size 24px
– gravatar can be styled by img.avatar-24 in your css file
– gravatar image links to author’s blog
– capitalization of first five words of the excerpt

Version 0.4.0
Update Author: Aziz Poonawalla
Update Author URI: http://metablog.us
– added exclusions for first blog, first post, enabled post excerpt

Version: 0.32
Update Author: G. Morehouse
Update Author URI: http://wiki.evernex.com/index.php?title=Wordpress_MU_sitewide_recent_posts_plugin

Version: 0.31
Update Author: Sven Laqua
Update Author URI: http://www.sl-works.de/

Version: 0.3
Author: Ron Rennick
Author URI: http://atypicalhomeschool.net/
*/

function ahp_recent_posts($how_many, $how_long, $optmask = 255, $exc_size = 30, $begin_wrap = ‘<li class="ahp_recent-posts">’, $end_wrap = ‘</li>’) {
global $wpdb;
$counter = 0;

// EDIT THESE TO CUSTOMIZE THE OUTPUT
$debug = 0;
$blog_prefix = "Posted from ";
$post_prefix = "";
$auth_prefix = ‘Posted by ‘;
$com_prefix = ‘ &nbsp; currently ‘;
$date_format = ‘D M jS, Y';
$grav_size = 60;

// DISPLAY OPTIONS BITMASK
$grav_flag = 1; // gravatar
$date_flag = 2; // date
$auth_flag = 4; // author name
$com_flag = 8; // comment count
$name_flag = 16; // blog name
$post_flag = 32; // post name
$exc_flag = 64; // post excerpt
$cap_flag = 128; // excerpt capitalization

// set the various option flags
if ($optmask & $grav_flag) { $use_grav = 1; } else { $use_grav = 0; }
if ($optmask & $date_flag) { $use_date = 1; } else { $use_date = 0; }
if ($optmask & $auth_flag) { $use_auth = 1; } else { $use_auth = 0; }
if ($optmask & $com_flag) { $use_com = 1; } else { $use_com = 0; }
if ($optmask & $name_flag) { $use_name = 1; } else { $use_name = 0; }

if ($optmask & $post_flag) { $use_post = 1; } else { $use_post = 0; }
if ($optmask & $exc_flag) { $use_exc = 1; } else { $use_exc = 0; }
if ($optmask & $cap_flag) { $use_cap = 1; } else { $use_cap = 0; }

// debug block
if ($debug) {
echo ‘<hr>’.’opt = ‘.$optmask.': grav = ‘.$use_grav.’, date = ‘.$use_date
.’, auth = ‘.$use_auth.’, use_com = ‘.$use_com.’, use_name = ‘.$use_name
.’, use_post = ‘.$use_post.’, use_exc = ‘.$use_exc.’, use_cap = ‘.$use_cap;
}

// get a list of blogs in order of most recent update. show only public and nonarchived/spam/mature/deleted
$blogs = $wpdb->get_col("SELECT blog_id FROM $wpdb->blogs WHERE
public = ‘1’ AND archived = ‘0’ AND mature = ‘0’ AND spam = ‘0’ AND deleted = ‘0’ AND
last_updated >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
ORDER BY last_updated DESC");

$postArray = array();
$i = 0;
if ($blogs) {
echo ‘<ul class="ahp_recent-posts">’ . "\n";
foreach ($blogs as $blog) {

// we need _posts, _comments, and _options tables for this to work
$blogPostsTable = "wp_".$blog."_posts";

// debug block
if ($debug) {
echo ‘<hr>processing blog ‘.$blog.’ = <a href="’.
$options[0]->option_value.’">’.$options[1]->option_value.'</a> <br>';
}

// fetch the ID, post title, post content, post date, and user’s email for the latest post
$sql = "SELECT $blogPostsTable.post_date, $blog AS this_blog, $blogPostsTable.ID, $blogPostsTable.post_title,
$blogPostsTable.post_content, wp_users.display_name,
wp_users.user_email, wp_users.user_login
FROM $blogPostsTable, wp_users
WHERE wp_users.ID = $blogPostsTable.post_author
AND post_status = ‘publish’ AND post_type = ‘post’
AND post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long DAY)
AND $blogPostsTable.id > 1
ORDER BY $blogPostsTable.post_date DESC limit 0,1";
$thispost = $wpdb->get_results($sql);

// if it is found put it into the array
if($thispost) {

$postArray[$i] = $wpdb->get_row($sql, ARRAY_A);
$i++;
}
}

if(count($postArray) > 0){
array_multisort($postArray, SORT_DESC);
for ($a = 0; $a < count($postArray); $a++){
// debug block
if ($debugflag) {
echo ‘processing thispost ID = ‘ . $postArray[$a][‘ID’] . ‘<br>';
echo ‘post_title = ‘ . $postArray[$a][‘post_title’] . ‘<br>';
echo ‘post_content = ‘ . $postArray[$a][‘post_content’] . ‘<br>';
echo ‘post_date = ‘ . $postArray[$a][‘post_date’] . ‘<br>';
echo ‘display_name = ‘ . $postArray[$a][‘display_name’] . ‘<br>';
echo ‘user_email = ‘ . $postArray[$a][‘user_email’] . ‘<br>';
echo ‘user_login = ‘ . $postArray[$a][‘user_login’] . ‘<br>';
echo ‘site_url = ‘ . $postArray[$a][‘option_value’] . ‘<br>';
}

// get post ID
$thispostID = $postArray[$a][‘ID’];

// get permalink by ID. check wp-includes/wpmu-functions.php
$thispermalink = get_blog_permalink( $postArray[$a][‘this_blog’], $thispostID);

// set blog tables
$blogOptionsTable = "wp_" . $postArray[$a][‘this_blog’] . "_options";
$blogCommentsTable = "wp_" . $postArray[$a][‘this_blog’] . "_comments";

// get blog name, URL
if ($use_name) {

$options = $wpdb->get_results("SELECT option_value FROM
$blogOptionsTable WHERE option_name IN (‘siteurl’,’blogname’)
ORDER BY option_name DESC");

$blog_link = $options[0]->option_value;
$blog_name = $options[1]->option_value;
$this_blogname = $blog_prefix.'<a href="’ . $blog_link . ‘">’ . $blog_name . ‘</a>';

} else { $this_blogname = ”; }

// get comments
if ($use_com) {

// sql query for all comments on the current post
$thesecomments = $wpdb->get_results("SELECT comment_ID
FROM $blogCommentsTable
WHERE comment_post_ID = $thispostID");

// count total number of comments
$num_comments = sizeof($thesecomments);

// pretty text
if ($num_comments == 0) { $thiscomment = $com_prefix.’no comments'; }
elseif ($num_comments == 1) { $thiscomment = $com_prefix.’one comment'; }
else { $thiscomment = $com_prefix.$num_comments.’ comments'; }

} else { $thiscomment = ”; }

// get author
if ($use_auth) {
$thisauthor = $auth_prefix.$postArray[$a][‘display_name’];
} else { $thisauthor = ”; }

// get author’s posts link
$thisuser = $thispost[0]->user_login;
$thisuser_url = $thisbloglink."author/".$thisuser;

// get gravatar
if ($use_grav) {
$grav_img = get_avatar( $postArray[$a][‘user_email’] , $grav_size );
$thisgravatar = ‘<a href="’.$thisuser_url.’">’.$grav_img.'</a>';
} else { $thisgravatar = ”; }

// get post date (nicely formatted)
if ($use_date) {
//$thisdate = date($date_format, strtotime( $thispost[0]->post_date )) ;
$thisdate = ‘<span class="dateMonth">’ . date(‘M’, strtotime( $postArray[$a][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class="dateDay">’ . date(‘d’, strtotime( $postArray[$a][‘post_date’] )) . ‘</span>';
$thisdate .= ‘<span class="dateYear">’ . date(‘Y’, strtotime( $postArray[$a][‘post_date’] )) . ‘</span>';
$thistime = date(‘g:i a’, strtotime( $postArray[$a][‘post_date’] ));
} else { $thisdate = ”; }

// get post name
if ($use_post) {
$this_postname = $post_prefix . ‘<a href="’ . $thispermalink . ‘">’ .$postArray[$a][‘post_title’] . ‘</a><br>';
} else { $this_postname = ”; }

if ($use_exc) {

if ($exc_size == 0) { $thisexcerpt = ”; }
else {
// get post content and truncate to (numwords) words
$thiscontent = strip_tags( $postArray[$a][‘post_content’] );
preg_match("/([\S]+\s*){0,$exc_size}/", $thiscontent, $regs);

if ($use_cap) {
// build the excerpt html block, capitalize first five words
$trunc_content = explode( ‘ ‘, trim($regs[0]) , 6 );
$exc_str = strtoupper($trunc_content[0]).’ ‘
.strtoupper($trunc_content[1]).’ ‘
.strtoupper($trunc_content[2]).’ ‘
.strtoupper($trunc_content[3]).’ ‘
.strtoupper($trunc_content[4]).’ ‘
.$trunc_content[5].’… ‘;
} else { $exc_str = trim($regs[0]); }

$thisexcerpt = ‘<span style="ahp-excerpt">’.$exc_str
.'<a href="’.$thispermalink.’">’
.’&raquo;&raquo;MORE’.'</a></span>';
}
} else { $thisexcerpt = ”; }

echo $begin_wrap
. ‘<div class="date">’ . $thisdate . ‘</div>’
. ‘<div id="avatar" style="margin-left:65px; margin-top:14px;">’ . $thisgravatar . ‘</div>’
. ‘<h3>’ . $this_postname . ‘</h3>’
. ‘<div class="postmetadata">&nbsp;@ ‘ . $thistime . ‘<br /><div id="author">’ . $thisauthor . ‘</div>’
. ‘<br /><div id="blogname">&nbsp;’ . $this_blogname . ‘</div><div id="comment"> | ‘ . $thiscomment . ‘</div></div>’
. ‘<div id="excerpt">’ . $thisexcerpt . ‘</div>’
. $end_wrap . "\n";

$counter++;
}

// don’t go over the limit
if($counter >= $how_many) {
break;
}
}
}
else {
//echo "no recent posts meet the criteria…<br>";
}
}
?>
[/php]

Apr 09

svn causing me heartburn

Arrrghh!!

So, the Plugin Directory finally pushed the 1.1.0 version of my Mixed Tape plugin to the repository to download. After I upgraded the plugin through the admin Dashboard, I noticed that the players were not showing in the test page. Well, apparently the svn check in blew up when I tried to add the 1.1.0 version and never put the audio files up to the site. I copied the audio directory from the trunk, which is apparently a no no. So, from now on I will have to remember to copy it from my working directory, which happens to be my local directory of my site.

I know some people have demo sites of their blogs. I really never thought I would have to worry about that, until now. I really don’t want to go through the hassle of setting up a duplicate blog just for testing, but it might come to that. My blog doesn’t get much traffic, but who knows, with the plugins and the Meetup Organizer Tool, it might just start.

Anyway, I’ve released 1.1.1 of the Mixed Tape and I see that the audio directory is under that version. I guess this will also be a good test to see how the tags/revisions work. Since the audio folder wasn’t in 1.1.0, then there will be a definite change between the two version. Of course, I will have to wait until it gets pushed through the repository, however long that will take.

Apr 08

An ah ha! moment

So, I apparently didn’t get enough sleep last night and my brain isn’t working on all cylinders. Anyway, it hasn’t stopped me from some side brain storming. Since I finally got my Mixed Tape plugin to show up on the plugin directory, I guess I was thinking about the type of people who might use it. I shared it with one of the guys over at Music Brainz, who plans to do a little write-up about the plugin. I guess that was in the back of my head, because it came to me that people who review music could use the plugin. Of course, that might have nothing to do with a music database, but it might. I bet there are plenty of people who write-up reviews about the latest album from their favorite artist, before they submit it to Music Brainz.

Since the plugin basically just takes the tracks and makes a playlist a reviewer could discuss each of the tracks on the album and link to the track as the review goes along. So, when they are done, someone could listen to the track and see if they have the same impression as the reviewer.

So, this means I probably need to make some small enhancements. I can probably add an option to the playlist to show either the mixed tape or a cd or maybe just an album. Or maybe I could show do a thumbnail of the album art, if the reviewer had that. Then I guess there would be an option as to whether or not the page contained a mixed tape or single album.

Welp, guess I better add that to the “to do” list.

Apr 07

Patiently waiting

Arrghhh!!
So, I got approval and the “go ahead” e-mail for my Mixed Tape plugin. I did the checkout using TortoiseSVN and it created the folders for the plugin. But, after adding files to the trunk, creating a tag folder and committing the files back up to svn, nothing. The files are up on svn, but the download page has yet to update. The page still shows my login as the author and doesn’t have any of the other information that my WP People plugin download page has. Very frustrating.

I know I’m not the only one who has gotten frustrated with creating plugins. Just check out The Agony and Ecstasy – Creating a WordPress Plugin. I even found a guy who posted a video series called How to Host a Plugin on WordPress in a four part series. The only thing I learned from the series is that it would be nice to have a new computer and maybe I would use a free open source IDE called Aptana.

I think I’ll let it set for a day and hopefully it will magically fix itself. Until then, I manually reloaded the plugin so that the demo page would still work.

Apr 06

My new Mixed Tape plugin

Mixed Tape

Mixed Tape

I am about to release a new plugin for WordPress. I am calling it WordPress Mixed Tape (WP Mixed Tape). If you have no idea what a mixed tape (mix tape) is, well, take a little trip back in time with me. Back in the day (let’s say the 1980’s), [W:cassette tapes] where the way taking your music with you. The [W:8-track tape] had gone the way of the [W:Dodo] and record [W:albums] were not portable. If those terms seem foreign to you, I included Wikipedia links to help you understand a little better. The great thing about tapes were that you could copy them to another tape. And, if you didn’t particularly like all the songs on a tape, you could copy tracks or part of tracks off of one tape and put it on another. You could even put your own voice recording or other recordings on to the tape.

Of course, this lead to people making their own full tapes for different purposes. One of the best or worst purposes for mixed tapes was for wooing someone. If you had a crush on someone or had been dating them for a period of time, you could show your love by copying a bunch of different songs that related to your emotional attachment to the other person onto a mixed tape. You could also be creative and add your own commentary in between tracks to show how that particular song meant so much to you about the current situation. For better or for worse, mixed tapes either helped or hurt the lovelorn and their situation. In today’s digital age, mixed tapes are now replaced by CDs (if you are legally allowed to make them now). But, even CDs are going away, since people can download music directly. So, what is a person supposed to do now to make a mixed tape? Well, you write a blog post as a mixed tape.

You are probably wondering how I came up with this idea. Well, Dean Logic is always all over the place, but there was a focus for this.

I was reading a coupe of posts on Gizmodo about the Windows PC commercial where “Lauren” buys a laptop for under $1000 and keeps the change. The Apple Fan Boys on Gizmodo didn’t appreciate Lauren’s selection. Not really caring about what her selection was, I was thinking I could write her an open letter stating that I didn’t care what she bought, because she’s cute. Then I started thinking that it would be great it I could make the post into a Mixed Tape. And that’s how this came about.

Basically, you add tracks to your post as you write. The idea would be that the tracks correspond to that particular part of the post. And then you add a tag to add the play list to the post with the name of your mixed tape, because very good mixed tape has a label. The code goes through and converts the track and play list tags and presto! You have a post that is also a mixed tape.

Now, to work on my open letter/mixed tape post for Lauren.

Apr 03

A little clean up

Well, I was getting a little annoyed with the look of my blog and forum, so I decided to do a little clean up.

The theme I was using on the blog was called Life Is a Byte. For one reason or another, the site I got it from is no longer available. After adding the cloud widgets and some other things, I noticed that it was behaving badly on IE. Well, I wouldn’t recommend IE to my mother, so it really wasn’t a big deal. However, I did want to get it fix, so I went searching for a new theme that was similar to what I had. My thought was, I could find a similar theme and just fix the problems in the old copy, paste and steal method of the web. Well, as you can see at the bottom of each page, I found the original theme site that my old theme was based off of.

i3Theme apparently is the “most downloaded Mac theme”, according to the site MangoOrange. Well, I like mangoes, so I have no problem that it’s supposed to be a Mac theme, I just want it to work with my blog. If you look at the site, you’ll notice that the theme comes in bright blue, dark blue, red pink and green. As you can tell by my site, I did a little alterations to one of those version. I took the red version and changed the background images to fit my darker theme. If you look very closely, you’ll notice that it’s not completely black. Unfortunately, I couldn’t copy the swoosh look they have on the colored versions, so I just did some hue alterations and left it at that. It works for what I want.

The great thing about using the original theme is that the background images in the side panels now works. Of course, that means I need to go back into the cloud widgets and make the backgrounds transparent. I am happy with how it looks in FireFox, but IE has decided that it won’t work with the theme. And, it’s not just my site, because MangoOrange has the same problem when viewed through IE. I guess they figure their users for Opera, Safari or FireFox fans.

After getting that straightened out, I did a little tweak to the Forum. The biggest problem with using WordPress for the main site and phpBB3 for the forum, is there are no good links between the two. So, I can’t stick the forum inside the blog and use the blogs theme. Also, I a member can’t register in the blog and also be registered in the forum. I tried to use a hack that would do that, but it about blew up my site. So, the most I can do is use a theme close to the one I am using on WordPress. The one I found is called ProNight. The base theme is called ProSilver, so I guess that’s how they came up with the name. After getting the new theme on the blog, I took the background image and replaced the header image on the forum. Then I added a link back to the main site (you have to do that, because there is no built-in link back to the main page). To clean things up, I removed a small site logo and change the font of the forum description. I think it fits in nicely with the site, but gives the user a slightly different look, so that they know they are on the forum and not the main site.

I also made some updates to my WP People plugin for the blog.

Little by little, I’m getting things done.

Mar 24

In a cloud

While I was surfing around the WordPress plugins trying to work on updating my own WP People plugin, I spotted a really cool Flash plugin. It tags the Tags created using a post and puts them into a 3D cloud sphere. Tags basically help search engines and those using search engines find pages on specific topics. For example, I plan on tagging this post with “wordpress, cloud, WP Cumulus, plugins”. This means, that anyone searching on those four tags, should see this post as one of the search results.

Anyway, back to the plugin. I did a quick search and found Roy Tanck’s plugin called WP Cumulus. Nice name. Someone else had created a plugin called Flash Tag Cloud, but after just a glance I figured it wasn’t the same one I saw earlier. So, I did a little more research and figured out the correct one. It was easy to install and after a few tweaks, fits perfectly into my site. So, I gave Roy Tanck a donation of $10. Right after I gave him the donation, I noticed he had another cloud application that showed Flickr and Picasa RSS feeds. Now, this version isn’t exactly a plugin version, I guess he’s still working on the details. However, he did provide a way to add it to your site. So, I created my Picasa ablum cloud and with the help of the Text/HTML widget, stuck it into my site. Awesome! Nothing like letting someone else do the hard work. But, I did reward him.

I also decided to use FAQ-Tastic Lite as my FAQ tool for my Applications and Plugins. It seems to do everything I need. I also just gave him a donation, but the conversion rate made his a little higher. There does seem to be a lot of work done on the tool, so I don’t have too much of an issue with the donation I gave.