KamTape - ".htmlspecialchars($video['title'])."

prepare("SELECT * FROM videos WHERE vid = ? AND converted = 1"); $video->execute([$_GET['v']]); if($video->rowCount() == 0) { header("Location: index.php?unavail"); die(); } else { $video = $video->fetch(PDO::FETCH_ASSOC); } if ($video['uid'] != $session['uid'] || $session['staff'] != 1) { if($video['reason'] == 1) { session_error_index("This video has been removed by the user.", "error"); } if($video['reason'] == 3) { session_error_index("This video has been removed due to copyright infringement.", "error"); } if($video['reason'] == 2) { session_error_index("This video has been removed due to terms of use violation.", "error"); } } if ($video['uid'] == $session['uid'] || $session['staff'] == 1) { if($video['reason'] == 1) { session_error_index("This video has been removed by the user.", "error"); } if($video['reason'] == 3) { alert("Your video has been removed due to copyright infringement.", "error"); } if($video['reason'] == 2) { alert("Your video has been removed due to terms of use violation.", "error"); } } $uploader = $conn->prepare("SELECT * FROM users WHERE uid = ?"); $uploader->execute([$video['uid']]); $uploader = $uploader->fetch(PDO::FETCH_ASSOC); $alreadyrelated = $conn->prepare("SELECT COUNT(*) FROM relationships WHERE sender = :member_id AND respondent = :him AND accepted = 1"); $alreadyrelated->execute([ ":member_id" => $session['uid'], ":him" => $uploader['uid'] ]); if($alreadyrelated === 1) { $friendswith = 1; } $newrelated = $conn->prepare("SELECT COUNT(*) FROM relationships WHERE sender = :him AND respondent = :member_id AND accepted = 1"); $newrelated->execute([ ":member_id" => $session['uid'], ":him" => $uploader['uid'] ]); if($newrelated === 1) { $friendswith = 1; } if($session['staff'] == 1) { $friendswith = 1; } if ($uploader['uid'] == $session['uid']) { $friendswith = 1; } if($friendswith < 1 && $video['privacy'] == 2) { session_error_index("This is a private video. If you have been sent this video, please make sure you accept the sender's friend request.", "error"); } if ($uploader['uid'] == NULL) { redirect("/index.php"); } if ($uploader['termination'] == 1) { redirect("/index.php"); } if($video['converted'] == 0) { header("Location: index.php"); } echo "KamTape - ".htmlspecialchars($video['title']).""; $subscribed = $conn->prepare("SELECT subscription_id FROM subscriptions WHERE subscriber = ? AND subscribed_to = ? AND subscribed_type = 'user_uploads'"); $subscribed->execute([ $session['uid'], $uploader['uid'] ]); $search = preg_quote($video['tags']); // Escape special characters for regular expression $search = str_replace(" ", "|", $search); $results = $conn->prepare("SELECT tags FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE videos.tags REGEXP ? AND videos.converted = 1 And videos.privacy = 1 ORDER BY videos.uploaded DESC LIMIT 200"); // Regex! $results->execute([$search]); /*$views = $conn->prepare("SELECT views FROM videos WHERE vid = ?"); $views->execute([$video['vid']]); $video['views'] = $views->fetchColumn();*/ $notOrganic = false; $playing = $conn->prepare(" SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND users.termination = 0 ORDER BY (INSTR(LOWER(description), LOWER(?)) > 0) LIMIT 1000 "); $playing->execute([$search, $search, $search, $search, $_GET['v']]); $playing = $playing->fetchAll(PDO::FETCH_ASSOC); $schedulla = array_column($playing, 'vid'); $schedex = array_search($_GET['v'], $schedulla); $play_schedule = []; $play_schedule['before'] = ($schedex > 0) ? $schedulla[$schedex - 1] : null; $play_schedule['next'] = ($schedex < count($schedulla) - 1) ? $schedulla[$schedex + 1] : null; // Check for organic views (better spam prevention) $organ_views = $conn->prepare("SELECT COUNT(view_id) AS views FROM views WHERE vid = ? AND viewed > DATE_SUB(NOW(), INTERVAL 1 DAY)"); $organ_views->execute([$video['vid']]); $organc = $organ_views->fetchColumn(); if ($organc > 300) { $notOrganic = true; } // Check for organic views (better spam prevention) $organ_views = $conn->prepare("SELECT COUNT(view_id) AS views FROM views WHERE vid = ? AND viewed > DATE_SUB(NOW(), INTERVAL 1 MINUTE)"); $organ_views->execute([$video['vid']]); $organc = $organ_views->fetchColumn(); if ($organc > 15) { $notOrganic = true; } if ($notOrganic = true) { $already_viewed = $conn->prepare("SELECT COUNT(view_id) FROM views WHERE vid = ? AND viewed > DATE_SUB(NOW(), INTERVAL 1 HOUR)"); $already_viewed->execute([$video['vid']]); } else { $already_viewed = $conn->prepare("SELECT COUNT(view_id) FROM views WHERE vid = ? AND sid = ? AND viewed > DATE_SUB(NOW(), INTERVAL 10 MINUTE)"); $already_viewed->execute([$video['vid'], session_id()]); } if($already_viewed->fetchColumn() == 0) { if($_SESSION['uid'] != NULL) { $add_view = $conn->prepare("INSERT INTO views (view_id, referer, vid, sid, uid) VALUES (?, ?, ?, ?, ?)"); $add_view->execute([generateId(34), $vidReferer, $video['vid'], session_id(), $session['uid']]); $add_view_cnt = $conn->prepare("UPDATE videos SET views = views + 1 WHERE vid = ?"); $add_view_cnt->execute([$video['vid']]); $add_view_vidswatched = $conn->prepare("UPDATE users SET vids_watched = vids_watched + 1 WHERE uid = ?"); $add_view_vidswatched->execute([$session['uid']]); } else { $add_view = $conn->prepare("INSERT INTO views (view_id, referer, vid, sid, uid) VALUES (?, ?, ?, ?, NULL)"); $add_view->execute([generateId(34), $vidReferer, $video['vid'], session_id()]); $add_view_cnt = $conn->prepare("UPDATE videos SET views = views + 1 WHERE vid = ?"); $add_view_cnt->execute([$video['vid']]); } } /*$maker_videos = $conn->prepare("SELECT vid FROM videos WHERE uid = ? AND converted = 1 AND privacy =1"); $maker_videos->execute([$video["uid"]]); $maker_favorites = $conn->prepare("SELECT fid FROM favorites WHERE uid = ?"); $maker_favorites->execute([$video["uid"]]); $maker_friends = $GLOBALS['conn']->prepare("SELECT relationship FROM relationships WHERE (sender = ? OR respondent = ?) AND accepted = 1"); $maker_friends->execute([$video['uid'], $video['uid']]);*/ $comments = $conn->prepare("SELECT * FROM comments LEFT JOIN users ON users.uid = comments.uid WHERE vidon = ? AND users.termination = 0 AND is_reply = 0 ORDER BY post_date DESC"); $comments->execute([$video['vid']]); if($_SESSION['uid'] != NULL) { // Logged in stuff $favorites_of_you = $conn->prepare( "SELECT * FROM favorites LEFT JOIN videos ON favorites.vid = videos.vid LEFT JOIN users ON users.uid = videos.uid WHERE favorites.uid = ? AND videos.converted = 1 AND videos.privacy = 1 ORDER BY favorites.fid DESC" ); $favorites_of_you->execute([$session['uid']]); $videos_of_you = $conn->prepare( "SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE videos.uid = ? AND videos.converted = 1 AND videos.privacy = 1 ORDER BY videos.uploaded DESC" ); $videos_of_you->execute([$session['uid']]); // End logged in stuff } $ACCESSES = $conn->prepare("SELECT referer FROM views WHERE vid = ? AND referer NOT LIKE '%kamtape.com%' ORDER BY viewed DESC"); $ACCESSES->execute([$video['vid']]); $SITE_LIST = []; foreach ($ACCESSES as $WEBSITE) { $SITE_LIST[] = $WEBSITE['referer']; } function isUserOnline($lastLoginDate) { // Define an online threshold (e.g., 5 minutes) in seconds $onlineThreshold = 5 * 60; // Convert the last login date to a Unix timestamp $lastLoginTimestamp = strtotime($lastLoginDate); // Calculate the difference between current time and last login time $timeDifference = time() - $lastLoginTimestamp; // Check if the time difference is within the online threshold with a margin of error // You can adjust the margin based on how accurate you want the online status to be $marginOfError = 30; // 30 seconds return $timeDifference <= ($onlineThreshold + $marginOfError); } if ($session['uid'] === null) { $par_link = 'signup.php'; } else { $par_link = 'my_videos_upload.php'; } function contest_check($tag, $title, $date) { global $video; $video_tags = $video['tags']; global $par_link; if (strpos($video_tags, $tag) !== false) { echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '


	'; echo ' '.$date.' Contest Entry '; echo ' '.$title.' '; echo ' '; echo ' '; echo 'Join! \| Learn More'; echo ' '; echo '

'; } } $related_vid_count = $conn->prepare(" SELECT COUNT(*) FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE (videos.tags REGEXP ? OR videos.description REGEXP ? OR videos.title REGEXP ? OR users.username REGEXP ?) AND videos.privacy = 1 AND videos.converted = 1 AND users.termination = 0 "); $related_vid_count->execute([$search, $search, $search, $search]); $related_vid_count = $related_vid_count->fetchColumn(); // HONORS $video_honors = []; /* Honors: Recently Featured */ $really_featured = $conn->prepare("SELECT * FROM picks WHERE video = :video_id"); $really_featured->execute([ ":video_id" => $_GET['v'] ]); if($really_featured->rowCount() == 1) { $video_honors[] = ["honor" => "Recently Featured", "url" => "s=rf&page=1"]; } /* Honors: Most Viewed */ $most_viewed = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1) ORDER BY views DESC LIMIT 50" ); if ($most_viewed) { $most_viewed = $most_viewed->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($most_viewed, 'vid')); unset($most_viewed); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "#" . $where_it_is . " - Most Viewed", "url" => "s=mp&t=a&page=1"]; } } /* Honors: Most Viewed (Today) */ $most_viewed = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1 AND uploaded > DATE_SUB(NOW(), INTERVAL 2 DAY)) ORDER BY views DESC LIMIT 50" ); if ($most_viewed) { $most_viewed = $most_viewed->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($most_viewed, 'vid')); unset($most_viewed); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "#" . $where_it_is . " - Most Viewed (Today)", "url" => "s=mp&t=t&page=1"]; } } /* Honors: Most Viewed (This Week) */ $most_viewed = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1 AND uploaded > DATE_SUB(NOW(), INTERVAL 2 WEEK)) ORDER BY views DESC LIMIT 50" ); if ($most_viewed) { $most_viewed = $most_viewed->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($most_viewed, 'vid')); unset($most_viewed); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "#" . $where_it_is . " - Most Viewed (This Week)", "url" => "s=mp&t=w&page=1"]; } } /* Honors: Most Viewed (This Month) */ $most_viewed = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1 AND uploaded > DATE_SUB(NOW(), INTERVAL 1 MONTH)) ORDER BY views DESC LIMIT 50" ); if ($most_viewed) { $most_viewed = $most_viewed->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($most_viewed, 'vid')); unset($most_viewed); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "#" . $where_it_is . " - Most Viewed (This Month)", "url" => "s=mp&t=m&page=1"]; } } /* Honors: Most Discussed */ $most_discussed = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1) ORDER BY comm_count DESC LIMIT 50" ); if ($most_discussed) { $most_discussed = $most_discussed->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($most_discussed, 'vid')); unset($most_discussed); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "#" . $where_it_is . " - Most Discussed", "url" => "s=md&page=1"]; } } /* Honors: Top Favorite */ $top_favorite = $conn->query( "SELECT * FROM videos WHERE (converted = 1 AND privacy = 1) ORDER BY fav_count DESC LIMIT 1" ); if ($top_favorite) { $top_favorite = $top_favorite->fetchAll(PDO::FETCH_ASSOC); $honor_find = array_search($video['vid'], array_column($top_favorite, 'vid')); unset($top_favorite); if ($honor_find !== false) { $where_it_is = $honor_find + 1; $video_honors[] = ["honor" => "Top Favorite", "url" => "s=mf&page=1"]; } } ?>

Hello, you either have JavaScript turned off or an old version of Macromedia's Flash Player, click here to get the latest flash player.

href="signup.php?r=c&v=" href="#comment" >Post Comments // href="signup.php?r=a&v=" href="#" onClick="return addFavorite();" >Add to Favorites // href="signup.php?r=o&v=" href="#flag" >Flag This Video

Video Owner Options: Edit Your Video Here

ManagerTape Options: Moderate This Video // Moderate Uploader

0) { ?>

Average ( )

prepare("SELECT * FROM ratings WHERE user = :uid AND video = :video_id"); $already_rated->execute([ ":uid" => $session['uid'], ":video_id" => htmlspecialchars($video['vid']) ]); if ($already_rated->rowCount() == 0) { $ur_rating = 0; } else { $already_rated = $already_rated->fetch(PDO::FETCH_ASSOC); $ur_rating = $already_rated['rating']; } ?>

Added on by

Video Details //

Runtime: | Views: | Comments:

Tags: $tag) { echo '' . htmlspecialchars($tag) . ''; if ($index < $tagCount - 1) { echo ', '; } } ?>

Channels:

User Details //

Videos: | Favorites: | Friends:

User Name:

I am online now!'; } else { echo "I was on the site ". timeAgo($uploader['last_act']) ."."; } ?>

Send Me a Private Message!

=">rowCount() > 0) { echo "unsubscribe"; } else { echo "subscribe"; } ?> rowCount() > 0) { echo "from"; } else { echo "to"; } ?> 's videos

Share Details // Help?
Video URL (Permalink):	(E-mail or link it)
Embeddable Player:	(Put this video on your website. Works on Friendster, eBay, Blogger, FriendProject!)
Sites linking to this video: $referer ) { if ($frequency < 1) { $frequency = 1; } if(empty($referer)) { echo '» '.htmlspecialchars($frequency).' click from somewhere... '."\r\n"; } else { echo '» '.htmlspecialchars($frequency).' clicks from '.htmlspecialchars($referer).' '."\r\n"; } } ?>

Comments have been disabled for this video.

Comment on this video:

Comments ():

prepare("SELECT vid FROM videos WHERE uid = ? AND converted = 1"); $comment_videos->execute([$comment["uid"]]); $comment_favorites = $conn->prepare("SELECT fid FROM favorites WHERE uid = ?"); $comment_favorites->execute([$comment["uid"]]); $comment_friends = $GLOBALS['conn']->prepare("SELECT relationship FROM relationships WHERE (sender = ? OR respondent = ?) AND accepted = 1"); $comment_friends->execute([$comment['uid'], $comment['uid']]);*/ if ($comment['vid'] == NULL) { ?>

'; } else { ?>

// Videos () | Favorites () | Friends () - ()

(Reply to this) (Create new thread)