function smooth_slider_wpmu_carousel_posts($max_posts, $offset = 0) { global $smooth_slider; global $wpdb, $table_prefix, $blog_id; $html = ''; $smooth_sldr_k = 0; $blogs = $wpdb->get_results($wpdb->prepare("SELECT blog_id FROM {$wpdb->blogs} WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered ASC", $wpdb->siteid), ARRAY_A); foreach ($blogs as $details) { switch_to_blog($details['blog_id']); global $table_prefix; $table_name = $table_prefix . SLIDER_TABLE; $post_table = $table_prefix . "posts"; if (smooth_slider_table_exists($table_name, DB_NAME)) { $myposts = $wpdb->get_results("SELECT a.post_id, a.date FROM \r\r\n\t {$table_name} a LEFT OUTER JOIN {$post_table} b \r\r\n\t\t\t\t\t\t\t\t ON a.post_id = b.ID \r\r\n\t\t\t\t\t\t\t\t WHERE b.post_status = 'publish' OR (b.post_type='attachment' AND b.post_status = 'inherit') \r\r\n\t ORDER BY a.slide_order ASC, a.date DESC LIMIT {$offset}, {$max_posts}", OBJECT); foreach ($myposts as $mypost) { $posts_table = $table_prefix . "posts"; $id = $mypost->post_id; $post = $wpdb->get_row("SELECT * FROM {$posts_table} WHERE ID = {$id}", OBJECT); $post_title = stripslashes($post->post_title); $post_title = str_replace('"', '', $post_title); $slider_content = $post->post_content; // $permalink = get_permalink($post->ID); $post_id = $post->ID; //2.1 changes start $slide_redirect_url = get_post_meta($post_id, 'slide_redirect_url', true); $sslider_nolink = get_post_meta($post_id, 'sslider_nolink', true); trim($slide_redirect_url); if (!empty($slide_redirect_url) and isset($slide_redirect_url)) { $permalink = $slide_redirect_url; } else { $permalink = get_permalink($post_id); } if ($sslider_nolink == '1') { $permalink = ''; } //2.1 changes end $smooth_sldr_k++; $html .= '<div class="smooth_slideri"> <!-- smooth_slideri -->'; $thumbnail = get_post_meta($post_id, 'slider_thumbnail', true); $image_control = get_post_meta($post_id, 'slider_image_control', true); if ($smooth_slider['content_from'] == "slider_content") { $slider_content = get_post_meta($post_id, 'slider_content', true); } if ($smooth_slider['content_from'] == "excerpt") { $slider_content = $post->post_excerpt; } $slider_content = stripslashes($slider_content); $slider_content = str_replace(']]>', ']]>', $slider_content); $slider_content = str_replace("\n", "<br />", $slider_content); $slider_content = strip_tags($slider_content, $smooth_slider['allowable_tags']); if ($smooth_slider['img_pick'][0] == '1') { $custom_key = array($smooth_slider['img_pick'][0]); } else { $custom_key = ''; } if ($smooth_slider['img_pick'][2] == '1') { $the_post_thumbnail = true; } else { $the_post_thumbnail = false; } if ($smooth_slider['img_pick'][3] == '1') { $attachment = true; $order_of_image = $smooth_slider['img_pick'][4]; } else { $attachment = false; $order_of_image = '1'; } if ($smooth_slider['img_pick'][5] == '1') { $image_scan = true; } else { $image_scan = false; } if ($smooth_slider['img_size'] == '1') { $gti_width = false; } else { $gti_width = $smooth_slider['img_width']; } if ($smooth_slider['crop'] == '0') { $extract_size = 'full'; } elseif ($smooth_slider['crop'] == '1') { $extract_size = 'large'; } elseif ($smooth_slider['crop'] == '2') { $extract_size = 'medium'; } else { $extract_size = 'thumbnail'; } $img_args = array('custom_key' => $custom_key, 'attachment' => $attachment, 'size' => $extract_size, 'the_post_thumbnail' => $the_post_thumbnail, 'default_image' => false, 'order_of_image' => $order_of_image, 'link_to_post' => false, 'image_class' => 'smooth_slider_thumbnail', 'image_scan' => $image_scan, 'width' => $gti_width, 'height' => false, 'echo' => false, 'permalink' => $permalink); $html .= sslider_get_the_image($img_args); if (!$smooth_slider['content_limit'] or $smooth_slider['content_limit'] == '' or $smooth_slider['content_limit'] == ' ') { $slider_excerpt = substr($slider_content, 0, $smooth_slider['content_chars']); } else { $slider_excerpt = smooth_slider_word_limiter($slider_content, $limit = $smooth_slider['content_limit']); } if ($smooth_slider['image_only'] == '1') { $html .= '<!-- /smooth_slideri --> </div>'; } else { if ($permalink != '') { $html .= '<h2 ><a href="' . $permalink . '">' . $post_title . '</a></h2><span> ' . $slider_excerpt . '</span> <p class="more"><a href="' . $permalink . '">' . $smooth_slider['more'] . '</a></p> <!-- /smooth_slideri --> </div>'; } else { $html .= '<h2 >' . $post_title . '</h2><span> ' . $slider_excerpt . '</span> <!-- /smooth_slideri --> </div>'; } } if ($smooth_sldr_k >= $max_posts) { break; } } if ($smooth_sldr_k >= $max_posts) { break; } } //smooth slider table exists } restore_current_blog(); echo $html; return $smooth_sldr_k; }
/** * Get the image with a link to the post. Use sslider_get_the_image() instead. * * @since 0.1 * @deprecated 0.3 */ function sslider_get_the_image_link($deprecated = '', $deprecated_2 = '', $deprecated_3 = '') { sslider_get_the_image(); }
function carousel_posts_on_slider_category($max_posts = '5', $catg_slug = '', $offset = 0, $out_echo = '1') { global $smooth_slider; global $wpdb, $table_prefix; if (!empty($catg_slug)) { $category = get_category_by_slug($catg_slug); $slider_cat = $category->term_id; } else { $category = get_the_category(); $slider_cat = $category[0]->cat_ID; } $posts = get_posts('numberposts=' . $max_posts . '&offset=' . $offset . '&category=' . $slider_cat); $html = ''; $smooth_sldr_a = 0; foreach ($posts as $post) { $id = $post->ID; $post_title = stripslashes($post->post_title); $post_title = str_replace('"', '', $post_title); $slider_content = $post->post_content; //2.3 changes // $permalink = get_permalink($post->ID); $post_id = $post->ID; //2.1 changes start $slide_redirect_url = get_post_meta($post_id, 'slide_redirect_url', true); $sslider_nolink = get_post_meta($post_id, 'sslider_nolink', true); trim($slide_redirect_url); if (!empty($slide_redirect_url) and isset($slide_redirect_url)) { $permalink = $slide_redirect_url; } else { $permalink = get_permalink($post_id); } if ($sslider_nolink == '1') { $permalink = ''; } //2.1 changes end $smooth_sldr_a++; $html .= '<li class="smooth_slideri"><div> <!-- smooth_slideri -->'; $thumbnail = get_post_meta($post_id, $smooth_slider['img_pick'][1], true); //$image_control = get_post_meta($post_id, 'slider_image_control', true); if ($smooth_slider['content_from'] == "slider_content") { $slider_content = get_post_meta($post_id, 'slider_content', true); } if ($smooth_slider['content_from'] == "excerpt") { $slider_content = $post->post_excerpt; } $slider_content = strip_shortcodes($slider_content); $slider_content = stripslashes($slider_content); $slider_content = str_replace(']]>', ']]>', $slider_content); $slider_content = str_replace("\n", "<br />", $slider_content); $slider_content = strip_tags($slider_content, $smooth_slider['allowable_tags']); if ($smooth_slider['img_pick'][0] == '1') { $custom_key = array($smooth_slider['img_pick'][1]); } else { $custom_key = ''; } if ($smooth_slider['img_pick'][2] == '1') { $the_post_thumbnail = true; } else { $the_post_thumbnail = false; } if ($smooth_slider['img_pick'][3] == '1') { $attachment = true; $order_of_image = $smooth_slider['img_pick'][4]; } else { $attachment = false; $order_of_image = '1'; } if ($smooth_slider['img_pick'][5] == '1') { $image_scan = true; } else { $image_scan = false; } if ($smooth_slider['img_size'] == '1') { $gti_width = $smooth_slider['img_width']; } else { $gti_width = false; } if ($smooth_slider['crop'] == '0') { $extract_size = 'full'; } elseif ($smooth_slider['crop'] == '1') { $extract_size = 'large'; } elseif ($smooth_slider['crop'] == '2') { $extract_size = 'medium'; } else { $extract_size = 'thumbnail'; } $img_args = array('custom_key' => $custom_key, 'post_id' => $post_id, 'attachment' => $attachment, 'size' => $extract_size, 'the_post_thumbnail' => $the_post_thumbnail, 'default_image' => false, 'order_of_image' => $order_of_image, 'link_to_post' => false, 'image_class' => 'smooth_slider_thumbnail', 'image_scan' => $image_scan, 'width' => $gti_width, 'height' => false, 'echo' => false, 'permalink' => $permalink); $html .= sslider_get_the_image($img_args); if (!$smooth_slider['content_limit'] or $smooth_slider['content_limit'] == '' or $smooth_slider['content_limit'] == ' ') { $slider_excerpt = substr($slider_content, 0, $smooth_slider['content_chars']); } else { $slider_excerpt = smooth_slider_word_limiter($slider_content, $limit = $smooth_slider['content_limit']); } if ($smooth_slider['image_only'] == '1') { $html .= '<!-- /smooth_slideri --> </div></li>'; } else { if ($permalink != '') { $html .= '<h2 ><a href="' . $permalink . '">' . $post_title . '</a></h2><span> ' . $slider_excerpt . '</span> <p class="more"><a href="' . $permalink . '">' . $smooth_slider['more'] . '</a></p> <!-- /smooth_slideri --> </div></li>'; } else { $html .= '<h2 >' . $post_title . '</h2><span> ' . $slider_excerpt . '</span> <!-- /smooth_slideri --> </div></li>'; } } } if ($out_echo == '1') { echo $html; } $r_array = array($smooth_sldr_a, $html); return $r_array; }