}
if ($type == 7) {
$fav_id = mysql_real_escape_string($result_members_media['audio_id']);
}
// get more details about video i.e titles etc
$sql2 = "SELECT * FROM {$table2} WHERE indexer = {$fav_id} ";
$query2 = @mysql_query($sql2);
$result_members_media = @mysql_fetch_array($query2);
if ($type == 4) {
//fav pictures resize thumb
//rescale thumbs
$image_id = $result_members_media['indexer'];
$image_name = $result_members_media['image_id'];
$page_display_width = $config['members_profile_thumb_width'];
$image_thumb = $base_path . '/addons/albums/thumbs/' . $image_name;
$display_thumbs = show_thumb($image_thumb, $page_display_width);
$image_width = $display_thumbs[0];
$image_height = $display_thumbs[1];
$image_array = array('image_width' => $image_width, 'image_height' => $image_height);
//merge arrays
$result_members_media = @array_merge($result_members_media, $image_array);
}
}
//Compile results
/////////////////
$member_media[] = $result_members_media;
$show_v = 2;
}
////////////////////////////////////////////
//PAGINATION PLUS >> start -- reusable code
////////////////////////////////////////////
$poster_picture = "pictures/{$a1_existing_file}";
} else {
$poster_picture = "themes/{$user_theme}/images/placeholder.gif";
}
} else {
$poster_picture = "themes/{$user_theme}/images/placeholder.gif";
}
// get members online status
$sql = "SELECT * FROM online WHERE logged_in_id = {$poster_id}";
$my_online_status = @mysql_num_rows(mysql_query($sql));
if ($my_online_status > 0) {
$online_status = '<img src="images/icon_online.gif" alt="status" title="' . $lang_online . '" border="0" width="8" height="8" style="padding-bottom: 1px; vertical-align: middle;" />';
} else {
$online_status = '<img src="images/icon_offline.gif" alt="status" title="' . $lang_offline . '" border="0" width="8" height="8" style="padding-bottom: 1px; vertical-align: middle;" />';
}
$display_thumbs = show_thumb($poster_picture, $page_display_small_width);
$new_smallwidth = $display_thumbs[0];
$new_smallheight = $display_thumbs[1];
$blog_story = $result['blog_story'];
$blog_owner_name = $result['blog_owner'];
//$wrap = wordwrap($blog_story, $wrap_limit, " ", true);
//$wrap = htmlspecialchars_decode($wrap);
$wrap = htmlspecialchars_decode($blog_story);
$drop_block = "<div id=\"drop_block_{$blog_id}\" style=\"margin-left:1px; float:left;\"></div>";
// we need to query blogcomments_replys to find any REPLIES
$each_reply = array();
$sql_replies = "SELECT * FROM blog_replys WHERE blog_id = {$blog_id} ORDER BY indexer DESC";
// LIMIT $limit_value, $limit";
$replies = @mysql_query($sql_replies);
$replies_count = mysql_num_rows($replies);
$reply_wrap = array();
$approved = $result['approved'];
if (@mysql_num_rows(mysql_query($sql)) == 0) {
$mypicture = "../themes/{$user_theme}/images/placeholder.gif";
$picture_status = $lang_no_pictures_uploaded;
} else {
$mypicture = $config['site_base_url'] . '/pictures/' . $existing_file;
//create pull down under picture to allow deleting image
$picture_status = '</font><font size="2"> | <b>' . $lang_del_avatar . '</b></font>
<select size="1" name="delete_avatar">
<option value="no" >' . $lang_no . '</option>
<option value="yes" >' . $lang_yes . '</option>
</select>';
}
//rescale thumbs
$page_display_width = $config['members_profile_own_thumb_width'];
$display_thumbs = show_thumb($mypicture, $page_display_width);
$image_width_profile = $display_thumbs[0];
$image_height_profile = $display_thumbs[1];
if ($image_width_profile == 0) {
$image_width_profile = 100;
}
if ($image_height_profile == 0) {
$image_height_profile = 100;
}
////////////////////
// get users stats
////////////////////
//get number of videos per member
/////////////////////////////////
$sql = "SELECT indexer FROM videos WHERE approved='yes' AND user_id = {$member_id}";
$query = @mysql_query($sql);