get_results("SELECT guid, post_content, post_mime_type, post_title
FROM $wpdb->posts
WHERE post_parent = $id
ORDER BY ID ASC");*/
$image_data = $wpdb->get_results("SELECT guid, post_content, post_mime_type, post_title
FROM wp_posts
WHERE id = $id");
$match_count = preg_match_all("/
/", $image_data[0]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count == 0){
$match_count = preg_match_all("/
/", $image_data[1]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count == 0){
$match_count = preg_match_all("/
]+>/i", $image_data[1]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count == 0)
$match_count = preg_match_all("/
/", $image_data[0]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count == 0){
$match_count = preg_match_all("/youtube.com\/watch\?v=(\S*)/", $image_data[1]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count == 0) $match_count = preg_match_all("/youtube.com\/watch\?v=(\S*)/", $image_data[0]->post_content, $match_array, PREG_PATTERN_ORDER);
if($match_count != 0)
$img = 'http://img.youtube.com/vi/' . $match_array[1][0] . '/0.jpg';
}
}
}
if( $img == '') $img = $match_array[1][0];
$attach_img = amty_get_firstimage($output->guid);
$first_image_data = array ($image_data[0]);
foreach($first_image_data as $output) {
if (substr($output->post_mime_type, 0, 5) == 'image'){
$uploaded_img = $output->guid;
break;
}
}
$wp_query = $temp;
if( $img != '') return $img;
if( $attach_img != '') return $attach_img;
if( $uploaded_img != '') return $uploaded_img;
return '';
}
function amty_get_firstimage($post_id='', $size='thumbnail') {
$id = (int) $post_id;
$args = array(
'post_type' => 'attachment',
'post_mime_type' => 'image',
'numberposts' => 1,
'order' => 'ASC',
'orderby' => 'menu_order ID',
'post_status' => null,
'post_parent' => $id
);
$attachments = get_posts($args);
if ($attachments) {
$img = wp_get_attachment_image_src($attachments[0]->ID, $size);
return $img[0];
}else{
return '';
}
}
?>