<? echo $title; ?>

prepare("SELECT * FROM digged_posts WHERE post_id = ?"); $stmt->bind_param("i", $post_id); $stmt->execute(); $result = $stmt->get_result(); if ($result) { while ($row = $result->fetch_assoc()) { $data = $row; } $result->free(); } $stmt->close(); // SECURITY FIX: prepared statement $stmt2 = $mysqli->prepare("SELECT * FROM dmca_post_table WHERE post_id = ?"); $stmt2->bind_param("i", $post_id); $stmt2->execute(); $result2 = $stmt2->get_result(); if ($result2) { while ($row = $result2->fetch_assoc()) { $dmca_post = $row['post_id']; } $result2->free(); } $stmt2->close(); $mysqli->close(); if(!empty($dmca_post)) { unset($data); } //============================// $title = clean_title($data['title']); $title = html_entity_decode($title); $data['mp4Url'] = str_replace('http://', 'https://', $data['mp4Url']); $data['posterUrl'] = str_replace('http://', 'https://', $data['posterUrl']); $data['mobilePosterUrl'] = str_replace('http://', 'https://', $data['mobilePosterUrl']); //=====================// if ($data['type'] == 'GFYCAT') { $gfycat_decode_json = json_decode($data['gfycat_full_data'], TRUE); } //=====================// if ($data['type'] == 'JPG') { $duplicates = RETURN_DUPLICATES_FULL(array($data), '', '', 1, 30); $duplicates_photos = htmlspecialchars($duplicates[0]['duplicates_photos']); } //=====================// /* $duplicates = RETURN_DUPLICATES(array($data), array('videos'), array('GIF', 'REDDIT'), array('REDDIT', 'GIF'), 1, 30); $fallback_screenshots = htmlspecialchars($duplicates[0]['duplicates_screenshots']); $fallback_screenshot = json_decode($duplicates[0]['duplicates_screenshots'], TRUE); $fallback_screenshot = $fallback_screenshot[0]; $duplicates_videos = json_decode($duplicates[0]['duplicates_videos'], TRUE); for($d=0;$d'; } */ //===========================// if (!empty($data['post_id'])) { //==============================// $mysqli = new mysqli("localhost", "xen", "sssss", "kittycage"); //=================// if ($result = $mysqli->query("SELECT post_id, image, type, mp4Url, posterUrl, reddit_fallback_src FROM digged_posts WHERE post_id < '".$post_id."' AND (distance < 3 AND score > 100) ORDER BY post_id DESC LIMIT 1;")) { while ($row = $result->fetch_assoc()) { $prevPost[] = $row; } $result->free(); } //=================// if (empty($prevPost)) { if ($result = $mysqli->query("SELECT post_id, image, type, mp4Url, posterUrl, reddit_fallback_src FROM digged_posts WHERE (distance < 3 AND score > 100) ORDER BY post_id DESC LIMIT 1;")) { while ($row = $result->fetch_assoc()) { $prevPost[] = $row; } $result->free(); } } //=================// if ($result = $mysqli->query("SELECT post_id, image, type, mp4Url, posterUrl, reddit_fallback_src FROM digged_posts WHERE post_id > '".$post_id."' AND (distance < 3 AND score > 100) ORDER BY post_id ASC LIMIT 1;")) { while ($row = $result->fetch_assoc()) { $nextPost[] = $row; } $result->free(); } //=================// if (empty($nextPost)) { if ($result = $mysqli->query("SELECT post_id, image, type, mp4Url, posterUrl, reddit_fallback_src FROM digged_posts WHERE (distance < 3 AND score > 100) ORDER BY post_id ASC LIMIT 1;")) { while ($row = $result->fetch_assoc()) { $nextPost[] = $row; } $result->free(); } } //=================// $mysqli->close(); //==============================// } ?> <? echo $title; ?> '; echo ''; echo ''; } if ($data['type'] == 'GIF') { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } if ($data['type'] == 'GFYCAT'|| $data['type'] == 'GIF') { echo ' '; } ?> '; }?>

(current)

MORE GIFS LIKE THIS

Report

'.$x++.''; if ($z != (count($image_album_source) - 1)) { $album_dropdown.= ''; } } echo '

'; } } //================================// ?>

'; echo ''; } else { /* echo '

'; */ echo '

'; //================================// echo '

'; echo ' MP4'; if (!empty($gfycat_decode_json['gfyItem']['tags'])) { echo '

'; foreach($gfycat_decode_json['gfyItem']['tags'] as $tag) { echo ''.$tag.''; } echo '

'; } echo '

'; //================================// } if ($_GET['frame'] == 1) { $onclick_next = 'onclick="event.preventDefault(); NextPost();"'; $onclick_prev = 'onclick="event.preventDefault(); PrevPost();"'; } echo ''; echo ''; ?> $(window).on("load",function(e){ $("#loadOverlay").remove(); imageFallback($("#post"), 1); }); '; } ?>