Skip to content

@freekrai /multisite_functions.php
Created

Embed URL

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Some handy wordpress multisite functions
<?php
$posts = multisite_latest_post( array(
"how_many"=>10,
"how_long_days"=>30,
"how_many_words"=>50,
"more_text"=>"[...]",
"remove_html"=>true,
"sort_by"=>"post_date",
// if paginating:
"paginate"=>true,
"start"=>0,
"end"=>25,
// query based on meta values: (key / value)
"metas"=>array(
"tumblog"=>"articles",
)
));
echo "There were ".$posts['total']." posts found";
foreach($posts['posts'] as $item){
?>
<li><a href="<?php echo $item->post_url; ?>">++ <?php echo $item->post_title; ?></a><span> <?php echo multisite_post_meta($item->blog_id,$item->ID,"tumblog"); ?></span></li>
<?php
}
function multisite_latest_post($args) {
global $wpdb;
extract($args);
// validate
if( empty($how_many) ) $how_many = 10;
if( empty($how_long_days) ) $how_long_days = 30;
if( empty($how_many_words) ) $how_many_words = 50;
if( empty($more_text) ) $more_text = "[...]";
if( empty($remove_html) ) $remove_html = true;
if( empty($sort_by) ) $sort_by = "post_date";
if( empty($paginate) ) $paginate = true;
if( empty($start) ) $start = 0;
if( empty($end) ) $end = 25;
if( !isset($meta) ) $meta = array();
$query = "SELECT blog_id FROM $wpdb->blogs WHERE blog_id !='1'";
$blogs = $wpdb->get_col($query);
if ($blogs) {
//we use blog id to loop post query
foreach ($blogs as $blog) {
$blogPostsTable = 'wp_'.$blog.'_posts';
$blogPostMetaTable = 'wp_'.$blog.'_postmeta';
$db_query = "SELECT sql_calc_found_rows $blogPostsTable.ID,
$blogPostsTable.post_author,
$blogPostsTable.post_title,
$blogPostsTable.guid,
$blogPostsTable.post_date,
$blogPostsTable.post_content,
$blogPostsTable.post_modified,
$blogPostsTable.comment_count
FROM $blogPostsTable";
$i = 1;
if( count($metas) ){
foreach($metas as $mname=>$mval){
$db_query .= " JOIN $blogPostMetaTable m{$i} ON m{$i}.post_id = $blogPostsTable.ID";
$i++;
}
reset($metas);
$db_query .= " WHERE $blogPostsTable.post_status = 'publish' AND $blogPostsTable.post_type = 'video'";
$i = 1;
foreach($metas as $mname=>$mval){
$db_query .= " AND m{$i}.meta_key='{$mname}' AND m{$i}.meta_value='{$mval}'";
$i++;
}
}else{
$db_query .= " WHERE $blogPostsTable.post_status = 'publish' AND $blogPostsTable.post_type = 'video'";
}
if( $paginate ){
$db_query .= " LIMIT $start,$end";
}else{
$db_query .= " AND $blogPostsTable.post_date >= DATE_SUB(CURRENT_DATE(), INTERVAL $how_long_days DAY)";
}
$thispos = $wpdb->get_results($db_query);
foreach($thispos as $thispost) {
if($sort_by == 'post_date') {
$order = $thispost->post_date;
}
else{
$order = $thispost->post_modified;
}
$post_dates[] = $order;
$post_guids[$order] = $thispost->guid;
$blog_IDs[$order] = $blog;
$post_IDs[$order] = $thispost->ID;
$post_titles[$order] = $thispost->post_title;
$post_authors[$order] = $thispost->post_author;
$post_contents[$order] = $thispost->post_content;
$comments[$order] = $thispost->comment_count;
}
}
rsort($post_dates);
$union_results = array_unique($post_dates);
$ResultArray = array_slice($union_results, 0, $how_many);
foreach ($ResultArray as $date) {
$ID = $post_IDs[$date];
$id_author = $post_authors[$date];
$post_url = get_blog_permalink($blog_IDs[$date], $ID);/*$post_guids[$date];*/
$post_title = $post_titles[$date];
$post_content = $post_contents[$date];
$post_date = mysql2date(get_option('date_format'), $date);
$post_time = mysql2date(get_option('time_format'), $date);
$total_comment = $comments[$date];
$user_info = get_userdata($id_author);
$author_blog_url = get_blogaddress_by_id($user_info->primary_blog);
$author_url = $user_info->user_url;
$author_email = $user_info->user_email;
$blog_id = $blog_IDs[$date];
if($user_info->first_name) {
$author_name = $user_info->first_name.' '.$user_info->last_name;
}
else{
$author_name = $user_info->nickname;
}
if($remove_html) {
$post_content = multisite_cleanup_post($post_content);
}
$results = array();
$results['ID'] = $ID;
$results['post_url'] = $post_url;
$results['post_title'] = $post_title;
$results['post_content'] = multisite_cut_article_by_words($post_content, $how_many_words);
if ($results['post_content'] != $post_content)
$results['post_content'] .= sprintf(' <a href="%s">%s</a>', $post_url, $more_text);
$results['author_blog_url'] = $author_blog_url;
$results['author_url'] = $author_url;
$results['author_email'] = $author_email;
$results['author_name'] = $author_name;
$results['post_date'] = $post_date;
$results['post_time'] = $post_time;
$results['comment_count'] = $total_comment;
$results['blog_id'] = $blog_id;
$returns[] = $results;
}
$latest_posts = multisite_bind_array_to_object($returns);
$total = $wpdb->get_var("SELECT FOUND_ROWS() as total");
return array("posts"=>$latest_posts,"total"=>$total);
}
}
function multisite_post_meta($blog,$post,$key){
global $wpdb;
$blogPostsTable = 'wp_'.$blog.'_postmeta';
$query = "SELECT meta_value FROM {$blogPostsTable} WHERE post_id ='{$post}' AND meta_key='{$key}'";
$meta_value = $wpdb->get_var($query);
return $meta_value;
}
function get_blog_domain($blog_id){
global $wpdb;
$query = "SELECT domain FROM $wpdb->blogs WHERE blog_id ='{$blog_id}'";
$domain = $wpdb->get_var($query);
return $domain;
}
function multisite_bind_array_to_object($array) {
$return = new stdClass();
foreach ($array as $k => $v) {
if (is_array($v)) {
$return->$k = multisite_bind_array_to_object($v);
}
else {
$return->$k = $v;
}
}
return $return;
}
function multisite_cut_article_by_words($original_text, $how_many) {
$word_cut = strtok($original_text," ");
$return = '';
for ($i=1;$i<=$how_many;$i++) {
$return .= $word_cut;
$return .= (" ");
$word_cut = strtok(" ");
}
$return .= '';
return $return;
}
function multisite_cleanup_post($source) {
$replace_all_html = strip_tags($source);
$bbc_tag = array('/\[caption(.*?)]\[\/caption\]/is');
$result = preg_replace($bbc_tag, '', $replace_all_html);
return $result;
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.