YouTube Top 10
$x = 1;
$stuff = mysqli_query($db, "SELECT * FROM pack_chart ORDER BY views DESC LIMIT 10");
while ($ratch = mysqli_fetch_array($stuff)) {
$old_video = $ratch["id"];
$title = $ratch["title"];
$artist = $ratch["artist"];
$video_link = $ratch["video_link"];
$ytlink = $ratch["link"];
$views = $ratch["views"];
$thumbnail = $ratch["thumbnail"];
$comments = $ratch["comments"];
$favorites = $ratch["favorites"];
$dislikes = $ratch["dislikes"];
$likes = $ratch["likes"];
// TITLE MAINTENCE
// $title = substr($title, -22);
// $title = str_replace("Music Video Generator:", "", $title);
//parse_str($ytlink, $arr);
// $curry = $arr["http://www_youtube_com/watch?v";
// YOUTUBE LINK ROUTINE
$youtube_link = "http://www.youtube.com/watch?v=" . $ytlink;
$result = mysqli_query($db, "SELECT * FROM pack_song where youtube_link LIKE '%$ytlink%'");
//echo mysqli_num_rows ($result);
//echo mysqli_errno($db) . ": " . mysqli_error($db) . "\n";
while ($videodata = mysqli_fetch_array($result)) {
$video_id = $videodata["id"];
$atitle = $videodata["title"];
}
# watch.php?id= echo $video_id;
#$counter = $ratch["counter"];
### pull a random gif from the video_construct and use it as a frame
?>
$x++; }?>
echo $x;?>. echo $title; ?>
MVGEN Top 10 Viewed
$x = 1;
$coop = mysqli_query($db, "SELECT * FROM pack_song_views ORDER BY views DESC LIMIT 10");
while ($kik = mysqli_fetch_array($coop)) {
$rank_video_id = $kik["id"];
$views = $kik["views"];
$result = mysqli_query($db, "SELECT * FROM pack_song where id = '$rank_video_id'");
$ratch = mysqli_fetch_array($result);
$old_video = $ratch["id"];
$title = $ratch["title"];
$artist = $ratch["artist"];
$lyrics = $ratch["lyrics"];
$running_time = $ratch["running_time"];
$video_link = $ratch["video_link"];
$youtube_link = $ratch["youtube_link"];
$dailymotion_link = $ratch["dailymotion_link"];
$creation_date = $ratch["creation_date"];
$video_construct = $ratch["video_construct"];
$audio_info = $ratch["audio_info"];
$metadata = $ratch["metadata"];
$error_msg = $ratch["error_msg"];
$options = $ratch["options"];
$video_still = $ratch["video_still"];
if (!$video_still){
$video_still = "./mvgen_placeholder.png";
} else { $video_still = "./video/stills/" . $video_still; }
#$counter = $ratch["counter"];
### pull a random gif from the video_construct and use it as a frame
// TITLE MAINTENCE
// $title = substr($title, -22);
// $title = str_replace("Music Video Generator:", "", $title);
//parse_str($ytlink, $arr);
// $curry = $arr["http://www_youtube_com/watch?v";
// YOUTUBE LINK ROUTINE
//$youtube_link = "http://www.youtube.com/watch?v=" . $ytlink;
// dailymotion link
// $dailymotion_link = "" . $dmlink;
// $result = mysqli_query($db, "SELECT * FROM pack_song where youtube_link LIKE '%$ytlink%'");
//echo mysqli_num_rows ($result);
//echo mysqli_errno($db) . ": " . mysqli_error($db) . "\n";
//while ($videodata = mysqli_fetch_array($result)) {
//$video_id = $videodata["id"];
//$atitle = $videodata["title"];
//}
# watch.php?id= echo $video_id;
#$counter = $ratch["counter"];
### pull a random gif from the video_construct and use it as a frame
?>
$x++; }?>
echo $x;?>. echo $title; ?>
MVGEN Top 10 Gifs
$x = 1;
$stuff = mysqli_query($db, "SELECT * FROM pack_image ORDER BY counter DESC LIMIT 10");
while ($ratch = mysqli_fetch_array($stuff)) {
$gifid = $ratch["id"];
$image = $ratch["image"];
$tags = $ratch["tags"];
$counter = $ratch["counter"];
// TITLE MAINTENCE
// $title = substr($title, -22);
// $title = str_replace("Music Video Generator:", "", $title);
?>
$x++; }?>
echo $x;?>. KEWORDS [ echo $gifid; ?> ]
DailyMotion Top 10 MVGEN VIDEOS
$x = 1;
$stuff = mysqli_query($db, "SELECT * FROM pack_dm_chart ORDER BY views DESC LIMIT 10");
while ($ratch = mysqli_fetch_array($stuff)) {
$dm_video_id = $ratch["id"];
$title = $ratch["title"];
// $artist = $ratch["artist"];
//$video_link = $ratch["video_link"];
$dmlink = $ratch["link"];
$views = $ratch["views"];
$thumbnail = $ratch["thumbnail"];
//$comments = $ratch["comments"];
//$favorites = $ratch["favorites"];
//$dislikes = $ratch["dislikes"];
//$likes = $ratch["likes"];
// TITLE MAINTENCE
// $title = substr($title, -22);
// $title = str_replace("Music Video Generator:", "", $title);
//parse_str($ytlink, $arr);
// $curry = $arr["http://www_youtube_com/watch?v";
// YOUTUBE LINK ROUTINE
# watch.php?id= echo $video_id;
#$counter = $ratch["counter"];
### pull a random gif from the video_construct and use it as a frame
?>
$x++; }?>
echo $x;?>. echo $title; ?>
MVGEN Top 10 Users
$x = 1;
$stuff = mysqli_query($db, "SELECT * FROM pack_user_chart");
while ($ratch = mysqli_fetch_array($stuff)) {
$user_chart_id = $ratch["user_id"];
$user_name = $ratch["user_name"];
$videos = $ratch["videos"];
$views = $ratch["views"];
$logo = $ratch["logo"];
$website = $ratch["website"];
$video_list = $ratch["videohistory"];
// you have to spit this list out with links think
if ($logo) {
$user_logo = "./users/" . $user_name . "/" . $logo;
} else { $user_logo = "./mvgen.gif"; }
?>
$x++; }?>