include "header.php";
session_start();
function convertToHoursMins($time, $format = '%02d:%02d')
{
if ($time < 1)
{ return; }
$hours = floor($time / 60);
$minutes = ($time % 60);
return sprintf($format, $hours, $minutes);
}
// LANGSTE CONCERT
$teller=1;
$go=mysqli_query($connectie,"SELECT id,datum,plaats,lengte FROM `bt_live` ORDER BY `bt_live`.`lengte` DESC LIMIT 10");
while ($row = mysqli_fetch_array($go))
{
$id = $row["id"];
$datum = $row["datum"];
$plaats = $row["plaats"];
$lengte = $row["lengte"];
$day = substr ($datum, 6, 2);
$month = substr ($datum, 4, 2);
$year = substr ($datum, 0, 4);
$date = str_replace("DD", $day, $dateformat);
$date = str_replace("MM", $month, $date);
$date = str_replace("YYYY", $year, $date);
$go2=mysqli_query($connectie,"SELECT city FROM bt_plaats WHERE id = '$plaats' ");
while ($row = mysqli_fetch_array($go2))
{
$city = $row["city"];
include "includes/include_plaats.php";
}
$lengte = convertToHoursMins($lengte, '%01d:%02d');
$langsteconcerttabel .= '
' . $teller . ' | ' . $plaatsevent . ' | ' . $date . ' | ' . $lengte . ' |
';
$teller++;
}
// MEESTE WERELDPREMIERES
$meestewereldpremtabel;
// MEESTE TOURPREMIERES
$meestetourpremtabel;
// LANGSTE SETLIJST
$teller=1;
$go=mysqli_query($connectie,"SELECT concertid,count(concertid) AS aantal FROM `bt_concertsongs` GROUP BY concertid ORDER BY count(concertid) DESC LIMIT 10");
while ($row = mysqli_fetch_array($go))
{
$concertid = $row["concertid"];
$aantal = $row["aantal"];
$go2=mysqli_query($connectie,"SELECT id,datum,plaats,lengte FROM `bt_live` WHERE id=$concertid");
while ($row = mysqli_fetch_array($go2))
{
$id = $row["id"];
$datum = $row["datum"];
$plaats = $row["plaats"];
$lengte = $row["lengte"];
$day = substr ($datum, 6, 2);
$month = substr ($datum, 4, 2);
$year = substr ($datum, 0, 4);
$date = str_replace("DD", $day, $dateformat);
$date = str_replace("MM", $month, $date);
$date = str_replace("YYYY", $year, $date);
$go3=mysqli_query($connectie,"SELECT city FROM bt_plaats WHERE id = '$plaats' ");
while ($row = mysqli_fetch_array($go3))
{
$city = $row["city"];
include "includes/include_plaats.php";
}
}
$langstesetlijsttabel .= '' . $teller . ' | ' . $plaatsevent . ' | ' . $date . ' | ' . $aantal . ' |
';
$teller++;
}
// CONCERTEN HET DICHTSTBIJ JOU
$dichtsbijtabel;
// CONCERTEN HET VERST AF VAN JOU
$verstwegtabel;
// MEESTE PERSOONLIJKEPREMIERES
$meesteperspremtabel;
?>
echo strtoupper($lang['MENU_STATISTICSCONCERT']); ?>
$statistiekconcerttitel = explode(" ", $lang['MENU_STATISTICSCONCERT']); ?>
echo $statistiekconcerttitel[0]; ?> echo $statistiekconcerttitel[1]; ?>
$MOSTWORLDPREMtabel = "
UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER |
";
$MOSTTOURPREMtabel = "
UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER |
";
$CONCERTSNEARtabel = "
UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER |
";
$MOSTPERSPREMtabel = "
UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER |
";
$CONCERTSFARtabel = "
UNDER CONSTRUCTION / WORKING ON A HIGHWAY / PLEASE COME BACK LATER |
";
?>
echo strtoupper($lang['STAT_LONGCONCERT']); ?>
| | | echo $lang['DISCO_LENGTH']; ?> |
echo $langsteconcerttabel; ?>
echo strtoupper($lang['STAT_MOSTWORLDPREM']); ?>
| | | echo $lang['STAT_ALBUMNUMBER']; ?> |
echo $MOSTWORLDPREMtabel; ?>
echo strtoupper($lang['STAT_MOSTTOURPREM']); ?>
| | | echo $lang['STAT_ALBUMNUMBER']; ?> |
echo $MOSTTOURPREMtabel; ?>
include "footer.php";
?>