$typex_s = ""; } } } } if ($union_type == "notes") { $mysql1 = mysql_query("SELECT * FROM notes WHERE id='{$item_id}' AND note_date='{$datetime}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $note_id = $row['id']; $item_id = $row['id']; $user_id_note = $row['user_id']; $the_note_subject = $row['the_note_subject']; $the_note = $row['the_note']; $note_date = $row['note_date']; $convertedTime = $myObject->convert_datetime($note_date); $note_date = $myObject->make_ago($convertedTime); $memory_type = $row['memory_type']; $note_type = $row['note_type']; $comment_array = $row['comment_array']; $commentArray = explode(",", $comment_array); $comment_count = mysql_num_rows(mysql_query("SELECT id FROM notes_comments WHERE note_id='{$note_id}' AND delete_comment='1'")); $like_array_note = $row['like_array']; $love_array_note = $row['love_array']; $point_array_note = $row['point_array']; $likeArray_note = explode(",", $like_array_note); $loveArray_note = explode(",", $love_array_note); $pointArray_note = explode(",", $point_array_note); $like_array_count_note = count($likeArray_note); $love_array_count_note = count($loveArray_note); $point_array_count_note = count($pointArray_note); $point_array_count_note = $point_array_count_note * 10;
$i++; $mysql_album = mysql_query("SELECT * FROM planets_albums WHERE id='{$value}' LIMIT 1") or die("Sorry, we have a system error!"); while ($row = mysql_fetch_array($mysql_album)) { $album_id = $row['id']; $item_id = $row['id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $album_name = $row['album_name']; if (strlen($album_name) > 25) { $album_name = substr($album_name, 0, 25) . "..."; } $album_type = $row['album_type']; $memory_type = $row['memory_type']; $upload_date = $row['upload_date']; $convertedTime = $myObject->convert_datetime($upload_date); $upload_date = $myObject->make_ago($convertedTime); $like_array_album = $row['like_array']; $love_array_album = $row['love_array']; $image_array = $row['image_array']; $likeArray_album = explode(",", $like_array_album); $loveArray_album = explode(",", $love_array_album); $imageArray = explode(",", $image_array); $like_array_count_album = count($likeArray_album); $love_array_count_album = count($loveArray_album); $image_array_count = count($imageArray); $point_array_album = $row['point_array']; $pointArray_album = explode(",", $point_array_album); $point_array_count_album = count($pointArray_album); $point_array_count_album = $point_array_count_album * 10; if ($point_array_album == "") { $point_array_count_album = "0";
} else { $hide_llc_front = ""; $hide_llc_back = ""; } if ($union_type == "notes") { $mysql1 = mysql_query("SELECT * FROM planets_notes WHERE id='{$item_id}' AND note_date='{$datetime}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $note_id = $row['id']; $item = $row['id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $the_note_subject = $row['the_note_subject']; $the_note = $row['the_note']; $note_date = $row['note_date']; $convertedTime = $myObject->convert_datetime($note_date); $note_date = $myObject->make_ago($convertedTime); $memory_type = $row['memory_type']; $note_type = $row['note_type']; $comment_array = $row['comment_array']; $commentArray = explode(",", $comment_array); $comment_count = mysql_num_rows(mysql_query("SELECT id FROM planets_notes_comments WHERE note_id='{$note_id}' AND delete_comment='1'")); $like_array_note = $row['like_array']; $love_array_note = $row['love_array']; $point_array_note = $row['point_array']; $likeArray_note = explode(",", $like_array_note); $loveArray_note = explode(",", $love_array_note); $pointArray_note = explode(",", $point_array_note); $like_array_count_note = count($likeArray_note); $love_array_count_note = count($loveArray_note); $point_array_count_note = count($pointArray_note); $point_array_count_note = $point_array_count_note * 10;
if ($numRows > 0) { while ($row = mysql_fetch_array($mysql_union)) { $item_id = $row['id']; $datetime = $row['datetime']; $union_type = $row['union_type']; if ($union_type == "albums_posts") { $mysql1 = mysql_query("SELECT * FROM planets_albums_posts WHERE id='{$item_id}' AND post_date='{$datetime}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $albums_post_id = $row['id']; $album_id = $row['album_id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $the_post = $row['the_post']; $post_date = $row['post_date']; $convertedTime = $myObject->convert_datetime($post_date); $post_date = $myObject->make_ago($convertedTime); $albums_post_type = $row['albums_post_type']; $memory_type = $row['memory_type']; $comment_array = $row['comment_array']; $commentArray = explode(",", $comment_array); $comment_count = mysql_num_rows(mysql_query("SELECT id FROM planets_albums_posts_comments WHERE albums_post_id='{$albums_post_id}' AND delete_comment='1'")); $like_array_post = $row['like_array']; $love_array_post = $row['love_array']; $point_array_post = $row['point_array']; $likeArray_post = explode(",", $like_array_post); $loveArray_post = explode(",", $love_array_post); $pointArray_post = explode(",", $point_array_post); $like_array_count_post = count($likeArray_post); $love_array_count_post = count($loveArray_post); $point_array_count_post = count($pointArray_post); $point_array_count_post = $point_array_count_post * 10;
$transaction_date = $row['transaction_date']; $union_type = $row['union_type']; if ($union_type == "transactions") { $mysql1 = mysql_query("SELECT * FROM point_transactions WHERE id='{$transaction_id}' AND transaction_date='{$transaction_date}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $transaction_id = $row['id']; $plus_id = $row['plus_id']; $minus_id = $row['minus_id']; $item_id = $row['item_id']; $create_type = $row['create_type']; $create_id = $row['create_id']; $transaction_amount = $row['transaction_amount']; $transaction_type = $row['transaction_type']; $transaction_date = $row['transaction_date']; $convertedTime = $myObject->convert_datetime($transaction_date); $transaction_date = $myObject->make_ago($convertedTime); } $item_type = json_encode($transaction_type); $create_type_json = json_encode($create_type); $tt_text = "This"; if ($create_type == "profile") { $create_text = "profiles"; $location_text = "Profile"; } else { if ($create_type == "planet") { $create_text = "planets"; $location_text = "Planet"; } } $create_text_s = substr($create_text, 0, -1); if ($transaction_type == "images_walls") {
if ($union_type == "link_creates") { $mysql1 = mysql_query("SELECT * FROM link_creates WHERE id='{$item_id}' AND link_create_date='{$datetime}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $link_create_id = $row['id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $planet_id = $row['planet_id']; $page_id = $row['page_id']; $group_id = $row['group_id']; $event_id = $row['event_id']; $shop_id = $row['shop_id']; $create_type = $row['create_type']; $create_type_s = substr($create_type, 0, -1); $link_create_date = $row['link_create_date']; $convertedTime = $myObject->convert_datetime($link_create_date); $link_create_date = $myObject->make_ago($convertedTime); $link_create_type = $row['link_create_type']; $memory_type = $row['memory_type']; $comment_array = $row['comment_array']; $commentArray = explode(",", $comment_array); $comment_count = mysql_num_rows(mysql_query("SELECT id FROM link_creates_comments WHERE link_create_id='{$link_create_id}' AND delete_comment='1'")); $like_array_link_create = $row['like_array']; $love_array_link_create = $row['love_array']; $point_array_link_create = $row['point_array']; $likeArray_link_create = explode(",", $like_array_link_create); $loveArray_link_create = explode(",", $love_array_link_create); $pointArray_link_create = explode(",", $point_array_link_create); $like_array_count_link_create = count($likeArray_link_create); $love_array_count_link_create = count($loveArray_link_create); $point_array_count_link_create = count($pointArray_link_create); $point_array_count_link_create = $point_array_count_link_create * 10;
} // End Pagination $planetsDisplayList .= "<div class='planets_bars'>\n\t\t\t\t\t\t<div class='float_left'><img src='blank.gif' width='1px' height='1px' class='planets_lists'/><span class='heading_list'>" . $tab_heading . " Planets</span></div>\n\t\t\t\t\t<div class='float_right'>" . $list_planets . "</div></div>"; $i = 0; $planetsDisplayList .= "<div class='under_list_wrap'>"; foreach ($planetsArray2 as $key => $value) { $i++; $mysql_planets = mysql_query("SELECT * FROM planets WHERE id='{$value}' AND delete_item='1' LIMIT 1") or die("Sorry, we have a system error!"); while ($row = mysql_fetch_array($mysql_planets)) { $planet_id = $row['id']; $item_id = $row['id']; $user_id = $row['user_id']; $planet_name = $row['planet_name']; $create_date = $row['create_date']; $convertedTime = $myObject->convert_datetime($create_date); $create_date = $myObject->make_ago($convertedTime); $like_array_planets = $row['like_array']; $love_array_planets = $row['love_array']; $member_array_planets = $row['member_array']; $likeArray_planets = explode(",", $like_array_planets); $loveArray_planets = explode(",", $love_array_planets); $memberArray_planets = explode(",", $member_array_planets); $like_array_count_planets = count($likeArray_planets); $love_array_count_planets = count($loveArray_planets); } $member_array_count_planets = count($memberArray_planets); if ($member_array_count_planets != 1) { $m_s = "s"; } else { $m_s = ""; }
$numRows = mysql_num_rows($mysql_union); if ($numRows > 0) { while ($row = mysql_fetch_array($mysql_union)) { $item_id = $row['id']; $datetime = $row['datetime']; $union_type = $row['union_type']; if ($union_type == "posts") { $mysql1 = mysql_query("SELECT * FROM posts WHERE id='{$item_id}' AND post_date='{$datetime}' LIMIT 1"); while ($row = mysql_fetch_array($mysql1)) { $post_id = $row['id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $the_post = $row['the_post']; $post_date = $row['post_date']; $convertedTime = $myObject->convert_datetime($post_date); $post_date = $myObject->make_ago($convertedTime); $post_type = $row['post_type']; $memory_type = $row['memory_type']; $comment_array = $row['comment_array']; $commentArray = explode(",", $comment_array); $comment_count = mysql_num_rows(mysql_query("SELECT id FROM posts_comments WHERE post_id='{$post_id}' AND delete_comment='1'")); $like_array_post = $row['like_array']; $love_array_post = $row['love_array']; $point_array_post = $row['point_array']; $likeArray_post = explode(",", $like_array_post); $loveArray_post = explode(",", $love_array_post); $pointArray_post = explode(",", $point_array_post); $like_array_count_post = count($likeArray_post); $love_array_count_post = count($loveArray_post); $point_array_count_post = count($pointArray_post); $point_array_count_post = $point_array_count_post * 10;
if ($_POST['display'] == "display_image") { $planet_id = $_POST['id']; $ids = $_POST['ids']; $image_id = $_POST['image_id']; $typex = $_POST['type']; $user_type = "user_id"; $item_type = "images"; $mysql = mysql_query("SELECT id, user_page_id,user_post_id, album_id, upload_date, image_type, ext, like_array, love_array, point_array FROM " . $typex . "_" . $item_type . " WHERE id='{$image_id}' LIMIT 1"); $row = mysql_fetch_assoc($mysql); $item_id = $row['id']; $user_page_id = $row['user_page_id']; $user_post_id = $row['user_post_id']; $album_id = $row['album_id']; $upload_date = $row['upload_date']; $upload_date = $myObject->convert_datetime($upload_date); $upload_date = $myObject->make_ago($upload_date); $image_type = $row['image_type']; $ext = $row['ext']; $like_array_image = $row['like_array']; $love_array_image = $row['love_array']; $likeArray_image = explode(",", $like_array_image); $loveArray_image = explode(",", $love_array_image); $like_array_count_image = count($likeArray_image); $love_array_count_image = count($loveArray_image); $point_array_image = $row['point_array']; $pointArray_image = explode(",", $point_array_image); $point_array_count_image = count($pointArray_image); $point_array_count_image = $point_array_count_image * 10; if ($point_array_image == "") { $point_array_count_image = "0"; }