query("SELECT tags FROM videos WHERE converted = 1 AND privacy = 1 ORDER BY uploaded DESC LIMIT 30"); $tag_list = []; foreach($tags_strings as $result) $tag_list = array_merge($tag_list, explode(" ", $result['tags'])); $tag_list = array_slice(array_count_values($tag_list), 0, 50); $featured = $conn->query("SELECT * FROM picks LEFT JOIN videos ON videos.vid = picks.video LEFT JOIN users ON users.uid = videos.uid WHERE videos.converted = 1 AND videos.privacy = 1 ORDER BY picks.featured DESC LIMIT 10"); if ($_SESSION['uid'] != NULL) { // ahhh!!!! logged in section $y_views = $conn->prepare("SELECT COUNT(view_id) FROM views WHERE uid = ?"); $y_views->execute([$session['uid']]); $y_views = $y_views->fetchColumn(); // PHP UP YOURS $vids = $conn->prepare( "SELECT * FROM videos LEFT JOIN users ON users.uid = videos.uid WHERE videos.uid = ? AND videos.converted = 1 ORDER BY videos.uploaded DESC" ); $vids->execute([$session['uid']]); $fans = $conn->prepare( "SELECT * FROM favorites LEFT JOIN videos ON favorites.vid = videos.vid LEFT JOIN users ON users.uid = videos.uid WHERE videos.uid = ? AND videos.converted = 1 ORDER BY favorites.fid DESC" ); $fans->execute([$session['uid']]); $p_views = $conn->prepare( "SELECT * FROM views LEFT JOIN videos ON views.vid = videos.vid LEFT JOIN users ON users.uid = videos.uid WHERE videos.uid = ? AND videos.converted = 1 ORDER BY views.view_id DESC" ); $p_views->execute([$session['uid']]); $favs = $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 ORDER BY favorites.fid DESC" ); $favs->execute([$session['uid']]); // endingggg } ?>

Monthly Contest

What is it?

KamTape is proud to present our first monthly video contest. Each month, users may submit videos with the contest tag of the month. Viewers may browse the contest entries by searching for the contest tag. At the end of the month, the KamTape staff will review all the submitted videos and choose the winner.

This Month (August 2005)

This month's contest is about how daily routines. As long as it has something to do with that, it doesn't matter. Comedy animation about daily routines, your actual daily routine, they'll all work. The tag of the month is mymorning. You can subscribe to an RSS feed for video submissions via this link.

How do I enter?

To enter, simply record yourself dancing at a unique location and tag the video with mymorning.

Who wins?

The winner will be picked at the end of the month by the KamTape staff.

The Prize?

Fame, fortune, and the envy of all eyes.


	Monthly Video Contest Schedule August: mymorning September 2005: To Be Announced October 2005: To Be Announced November 2005: To Be Announced December 2005: To Be Announced Have a suggestion for a monthly video contest? Please tell us about it.