Requested: '.$reqd_total.' times
'.$ttartistcut.'
'.$tttitlecut.'
';
}
$likedlist = '';
$tlnumberlikes = '';
$tlsongID = '';
$tlartist = '';
$tltitle = '';
$tlartistcut = '';
$tltitlecut = '';
$tlartist_pic = '';
$sqltl = "SELECT `likes`, COUNT(*) as `lID` FROM `songlikes` GROUP BY `likes` ORDER BY `lID` DESC LIMIT 0, 10";
$tlresult = mysqli_query($db_conx, $sqltl);
if($tlresult === FALSE) { $likedlist = ''; }
while($tl1row = mysqli_fetch_assoc($tlresult)) {
$tlsongID = mysqli_real_escape_string($db_conx, $tl1row['likes']);
$sqlri2 = "SELECT * FROM `songs` WHERE `ID`='$tlsongID'";
$resultri2 = mysqli_query($db_conx, $sqlri2);
while($tlrow = mysqli_fetch_assoc($resultri2)) {
$tlsongID = mysqli_real_escape_string($db_conx, $tlrow["ID"]);
$tlartist = $tlrow["artist"];
$tltitle = mysqli_real_escape_string($db_conx, $tlrow["title"]);
$tlartistcut = preg_replace('/\s+?(\S+)?$/', '', substr($tlrow['artist'] . ' ', 0, 26)). '';
$tltitlecut = preg_replace('/\s+?(\S+)?$/', '', substr($tlrow['title'] . ' ', 0, 32)). '...';
if (file_exists('pictures/'.$tlartist.'.jpg') && $tlartist != '') {
$tlartist_pic = 'pictures/'.$tlartist.'.jpg';
} else {
$tlartist_pic = 'assets/img/noimglrg.jpg';
}
$counttllikes = mysqli_query($db_conx, "SELECT * FROM `songlikes` WHERE `likes`='".$tlsongID."'");
$tlnumberlikes = mysqli_num_rows($counttllikes);
}
$likedlist .= '
'.$tlnumberlikes.' likes
'.$tlartistcut.'
'.$tltitlecut.'
';
}
$toppld = '';
$tpld_total = '';
$pldsongID = '';
$pldartist = '';
$pldtitle = '';
$pldartistcut = '';
$pldtitlecut = '';
$pldartist_pic = '';
$sqltpld = "SELECT `trackID`, COUNT(*) as `nID` FROM `history` WHERE `song_type`='0' GROUP BY `trackID` ORDER BY `nID` DESC LIMIT 10";
$tpld = mysqli_query($db_conx, $sqltpld);
if($tpld === FALSE) { $toppld = ''; }
while($rtpld = mysqli_fetch_assoc($tpld)) {
$tpsongID = mysqli_real_escape_string($db_conx, $rtpld['trackID']);
$sqlpld = "SELECT * FROM `songs` WHERE `ID`='$tpsongID'";
$resultpld = mysqli_query($db_conx, $sqlpld);
while($pldrow = mysqli_fetch_assoc($resultpld)) {
$pldsongID = mysqli_real_escape_string($db_conx, $pldrow["ID"]);
$pldartist = $pldrow["artist"];
$tpld_total = $pldrow["count_played"];
$pldtitle = mysqli_real_escape_string($db_conx, $pldrow["title"]);
$pldartistcut = preg_replace('/\s+?(\S+)?$/', '', substr($pldrow['artist'] . ' ', 0, 42)). '';
$pldtitlecut = preg_replace('/\s+?(\S+)?$/', '', substr($pldrow['title'] . ' ', 0, 32)). '...';
if (file_exists('pictures/'.$pldartist.'.jpg') && $pldartist != '') {
$pldartist_pic = 'pictures/'.$pldartist.'.jpg';
} else {
$pldartist_pic = 'assets/img/noimglrg.jpg';
}
}
$toppld .= '
Played: '.$tpld_total.' times
'.$pldartistcut.'
'.$pldtitlecut.'
';
}
?>
<?php echo SITE_NAME; ?>
Developed By StewartsWebWorks.com