include "header.php";
session_start();
// GRAFIEKEN OPBOUWEN
// Grafiek 1 opbouwen aantal gebruikers per land
$dedata1 = "['Land', '" . $lang['MAINPAGE_USER'] . "'],";
$perland=mysqli_query($connectie,"SELECT landid FROM `bt_user` GROUP BY landid");
while ($row = mysqli_fetch_array($perland))
{
$hetland = $row["landid"];
$aantalgebruikersperland = mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE `landid` = '$hetland'");
$aantalgebruikersperland = mysqli_num_rows($aantalgebruikersperland);
if ($hetland==0)
{ $hetland=$lang['USER_UNKNOWN'];
$onbteller=$aantalgebruikersperland;
}
else
{ $hetland=$row["landid"];
$countryid=$row["landid"];
include "includes/include_plaats.php";
$dedata1 .= "['$landje', $aantalgebruikersperland],";
}
$xxx=mysqli_query($connectie,"SELECT nl FROM `bt_country` WHERE id=$hetland");
while ($row = mysqli_fetch_array($xxx))
{
$hetland = $row["nl"];
}
}
$dedata1 = substr($dedata1,0,strlen($dedata1)-1);
// Grafiek 2 opbouwen aantal gebruikers per taal
$dedata2 = "['Taal', '" . $lang['MAINPAGE_USER'] . "'],";
$aantalgebruikerspertaal = "";
$teller=1;
$pertaal=mysqli_query($connectie,"SELECT taal FROM `bt_user` GROUP BY taal");
// SELECT count(taal) AS aantal FROM `bt_user` GROUP BY taal
// SELECT id,taal, count(taal) AS aantal FROM `bt_user` GROUP BY taal ORDER BY `aantal`
$pertaal=mysqli_query($connectie," SELECT taal, count(taal) AS aantal FROM `bt_user` GROUP BY taal ORDER BY `aantal`DESC");
while ($row = mysqli_fetch_array($pertaal))
{
$detaal = $row["taal"];
$aantal = $row["aantal"];
// $aantalgebruikerspertaal = mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE `taal` = '$detaal'");
// $aantalgebruikerspertaal = mysqli_num_rows($aantalgebruikerspertaal);
if ($detaal=="") { $taalnaam = $lang['USER_UNKNOWN']; }
if ($detaal=="frl") { $taalnaam = $lang['SETTINGS_FRISIAN']; }
if ($detaal=="nl") { $taalnaam = $lang['SETTINGS_DUTCH']; }
if ($detaal=="en") { $taalnaam = $lang['SETTINGS_ENGLISH']; }
if ($detaal=="de") { $taalnaam = $lang['SETTINGS_GERMAN']; }
if ($detaal=="no") { $taalnaam = $lang['SETTINGS_NORWEGIAN']; }
if ($detaal=="it") { $taalnaam = $lang['SETTINGS_ITALIAN']; }
if ($detaal=="fr") { $taalnaam = $lang['SETTINGS_FRENCH']; }
if ($detaal=="es") { $taalnaam = $lang['SETTINGS_SPANISH']; }
if ($detaal=="cat") { $taalnaam = $lang['SETTINGS_CATALAN']; }
if ($detaal=="se") { $taalnaam = $lang['SETTINGS_SWEDISH']; }
// $dedata2 .= "['$taalnaam', $aantalgebruikerspertaal],";
$dedata2 .= "['$taalnaam', $aantal],";
$gebruikerspertaaltabel .= '
' . $teller . ' ' . $taalnaam . ' ' . $aantal . ' ';
$teller++;
}
$dedata2 = substr($dedata2,0,strlen($dedata2)-1);
// Grafiek 3 opbouwen aantal concerten per gebruiker
$dedata3 = "['Taal', '" . $lang['MAINPAGE_USER'] . "'],";
$tel0=0;
$tel10=0;
$tel20=0;
$tel30=0;
$tel40=0;
$tel50=0;
$tel60=0;
$tel70=0;
$tel80=0;
$tel90=0;
$tel100=0;
$tel150=0;
$tel200=0;
$usercount=mysqli_query($connectie,"SELECT userid, COUNT( concertid ) FROM `bt_userconcerts` GROUP BY userid ORDER BY COUNT( concertid ) ASC ");
while ($row = mysqli_fetch_array($usercount))
{
$telling = $row["COUNT( concertid )"];
if ($telling<10) { $tel0++; }
if ($telling>10 AND $telling<20) { $tel10++; }
if ($telling>20 AND $telling<30) { $tel20++; }
if ($telling>30 AND $telling<40) { $tel30++; }
if ($telling>40 AND $telling<50) { $tel40++; }
if ($telling>50 AND $telling<60) { $tel50++; }
if ($telling>60 AND $telling<70) { $tel60++; }
if ($telling>70 AND $telling<80) { $tel70++; }
if ($telling>80 AND $telling<90) { $tel80++; }
if ($telling>90 AND $telling<100) { $tel90++; }
if ($telling>100 AND $telling<150) { $tel100++; }
if ($telling>150 AND $telling<200) { $tel150++; }
if ($telling>200) { $tel200++; }
}
$dedata3 .= "['<10', $tel0],";
$dedata3 .= "['10-20', $tel10],";
$dedata3 .= "['20-30', $tel20],";
$dedata3 .= "['30-40', $tel30],";
$dedata3 .= "['40-50', $tel40],";
$dedata3 .= "['50-60', $tel50],";
$dedata3 .= "['60-70', $tel60],";
$dedata3 .= "['70-80', $tel70],";
$dedata3 .= "['80-90', $tel80],";
$dedata3 .= "['90-100', $tel90],";
$dedata3 .= "['100-150', $tel100],";
$dedata3 .= "['150-200', $tel150],";
$dedata3 .= "['>200', $tel200]";
$concertenpergebruikertabel .= '1 0 - 10 ' . $tel0 . ' ';
$concertenpergebruikertabel .= '2 10 - 20 ' . $tel10 . ' ';
$concertenpergebruikertabel .= '3 20 - 30 ' . $tel20 . ' ';
$concertenpergebruikertabel .= '4 30 - 40 ' . $tel30 . ' ';
$concertenpergebruikertabel .= '5 40 - 50 ' . $tel40 . ' ';
$concertenpergebruikertabel .= '6 50 - 60 ' . $tel50 . ' ';
$concertenpergebruikertabel .= '7 60 - 70 ' . $tel60 . ' ';
$concertenpergebruikertabel .= '8 70 - 80 ' . $tel70 . ' ';
$concertenpergebruikertabel .= '9 80 - 90 ' . $tel80 . ' ';
$concertenpergebruikertabel .= '10 90 - 100 ' . $tel90 . ' ';
$concertenpergebruikertabel .= '11 100 - 150 ' . $tel100 . ' ';
$concertenpergebruikertabel .= '12 150 - 200 ' . $tel150 . ' ';
$concertenpergebruikertabel .= '13 >200 ' . $tel200 . ' ';
// Grafiek 4 opbouwen aantal bezochte concerten per decenium/jaar
$dedata4 = "['Taal', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata4 .= "['1970-1980', 2],";
$dedata4 .= "['1980-1990', 5],";
$dedata4 .= "['1990-2000', 15],";
$dedata4 .= "['2000-2010', 12],";
$dedata4 .= "['2010-2020', 35],";
// $dedata4 .= "['2020-2030', 50],";
$zeventig=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='197' GROUP BY concertid");
$aantalzeventig = mysqli_num_rows($zeventig);
$tachtig=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='198' GROUP BY concertid");
$aantaltachtig = mysqli_num_rows($tachtig);
$negentig=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='199' GROUP BY concertid");
$aantalnegentig = mysqli_num_rows($negentig);
$nul=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='200' GROUP BY concertid");
$aantalnul = mysqli_num_rows($nul);
$tien=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='201' GROUP BY concertid");
$aantaltien = mysqli_num_rows($tien);
$twintig=mysqli_query($connectie,"SELECT datum FROM `bt_userconcerts` INNER JOIN bt_live ON bt_userconcerts.concertid = bt_live.id WHERE substr(datum,1,3)='202' GROUP BY concertid");
$aantaltwintig = mysqli_num_rows($twintig);
$dedata4 = "['Decenium', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata4 .= "['1970-1980', $aantalzeventig],";
$dedata4 .= "['1980-1990', $aantaltachtig],";
$dedata4 .= "['1990-2000', $aantalnegentig],";
$dedata4 .= "['2000-2010', $aantalnul],";
$dedata4 .= "['2010-2020', $aantaltien]";
// $dedata4 .= "['2020-2030', $aantaltwintig]";
$concertenperdeceniumtabel .= '1 1970-1980 ' . $aantalzeventig . ' ';
$concertenperdeceniumtabel .= '2 1980-1990 ' . $aantaltachtig . ' ';
$concertenperdeceniumtabel .= '3 1990-2000 ' . $aantalnegentig . ' ';
$concertenperdeceniumtabel .= '4 2000-2000 ' . $aantalnul . ' ';
$concertenperdeceniumtabel .= '5 2010-2020 ' . $aantaltien . ' ';
$concertenperdeceniumtabel .= '5 2020-2030 ' . $aantaltwintig . ' ';
// Grafiek 5 opbouwen aantal gebruikers My Bosstime
/*
$dedata5 = "['" . $lang['USER_YEARS'] . "', '" . $lang['MAINPAGE_USER'] . "'],";
$huidigedagmaand = date("Y") . date("m");
$jaar = 2012;
$maand = "01";
for ($i = 1; $i <= 40; $i++)
{
if ($maand=="01")
{ $maand="04"; $as = $jaar . "-1"; }
elseif ($maand=="04")
{ $maand="07"; $as = $jaar . "-2"; }
elseif ($maand=="07")
{ $maand="10"; $as = $jaar . "-3"; }
elseif ($maand=="10")
{ $maand="01"; $jaar=$jaar+1; $as = $jaar . "-4";}
if ($jaar.$maand<$huidigedagmaand)
{
$datumpunt = $jaar . "-" . $maand . "";
$gebruikers = mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE `datum` < '$datumpunt 00:00:00'");
$aantalgebruikers = mysqli_num_rows($gebruikers);
$dedata5 .= "['" . $datumpunt . "', " . $aantalgebruikers . "],";
}
}
$datumpunt = $lang['USER_GRAPHNOW'];
$gebruikers = mysqli_query($connectie,"SELECT * FROM `bt_user`");
$aantalgebruikers = mysqli_num_rows($gebruikers);
$dedata5 .= "['" . $datumpunt . "', " . $aantalgebruikers . "]";
// Grafiek 6-10 opbouwen aantal gebruikers My Bosstime
$dedata6 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata7 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata8 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata9 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$dedata10 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$teller=0;
$maand="01";
$jaar=2012;
$aantalgebruikers=0;
$aantalgebruikersjaar=0;
$data2012 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$data2013 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$data2014 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$data2015 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$data2016 = "['Jaar', '" . $lang['MAINPAGE_USER'] . "'],";
$huidigmaand = date(m);
$huidigjaar = date(Y);
while ($jaar<=$huidigjaar)
{
$gebruikers = mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE SUBSTR( datum, 1, 7 ) = '$jaar-$maand'");
$aantalgebruikers = mysqli_num_rows($gebruikers);
$aantalgebruikersjaar = $aantalgebruikersjaar + $aantalgebruikers;
if ($jaar==2012)
{
if ($maand=="01") { $data2012 .= "[' " . $lang['MONTH_ABBR_JAN'] . "',"; }
if ($maand=="02") { $data2012 .= "[' " . $lang['MONTH_ABBR_FEB'] . "',"; }
if ($maand=="03") { $data2012 .= "[' " . $lang['MONTH_ABBR_MAR'] . "',"; }
if ($maand=="04") { $data2012 .= "[' " . $lang['MONTH_ABBR_APR'] . "',"; }
if ($maand=="05") { $data2012 .= "[' " . $lang['MONTH_ABBR_MAY'] . "',"; }
if ($maand=="06") { $data2012 .= "[' " . $lang['MONTH_ABBR_JUN'] . "',"; }
if ($maand=="07") { $data2012 .= "[' " . $lang['MONTH_ABBR_JUL'] . "',"; }
if ($maand=="08") { $data2012 .= "[' " . $lang['MONTH_ABBR_AUG'] . "',"; }
if ($maand=="09") { $data2012 .= "[' " . $lang['MONTH_ABBR_SEP'] . "',"; }
if ($maand=="10") { $data2012 .= "[' " . $lang['MONTH_ABBR_OCT'] . "',"; }
if ($maand=="11") { $data2012 .= "[' " . $lang['MONTH_ABBR_NOV'] . "',"; }
if ($maand=="12") { $data2012 .= "[' " . $lang['MONTH_ABBR_DEC'] . "',"; }
$data2012 .= $aantalgebruikersjaar;
$data2012 .= "],";
}
if ($jaar==2013)
{
if ($maand=="01") { $data2013 .= "[' " . $lang['MONTH_ABBR_JAN'] . "',"; }
if ($maand=="02") { $data2013 .= "[' " . $lang['MONTH_ABBR_FEB'] . "',"; }
if ($maand=="03") { $data2013 .= "[' " . $lang['MONTH_ABBR_MAR'] . "',"; }
if ($maand=="04") { $data2013 .= "[' " . $lang['MONTH_ABBR_APR'] . "',"; }
if ($maand=="05") { $data2013 .= "[' " . $lang['MONTH_ABBR_MAY'] . "',"; }
if ($maand=="06") { $data2013 .= "[' " . $lang['MONTH_ABBR_JUN'] . "',"; }
if ($maand=="07") { $data2013 .= "[' " . $lang['MONTH_ABBR_JUL'] . "',"; }
if ($maand=="08") { $data2013 .= "[' " . $lang['MONTH_ABBR_AUG'] . "',"; }
if ($maand=="09") { $data2013 .= "[' " . $lang['MONTH_ABBR_SEP'] . "',"; }
if ($maand=="10") { $data2013 .= "[' " . $lang['MONTH_ABBR_OCT'] . "',"; }
if ($maand=="11") { $data2013 .= "[' " . $lang['MONTH_ABBR_NOV'] . "',"; }
if ($maand=="12") { $data2013 .= "[' " . $lang['MONTH_ABBR_DEC'] . "',"; }
$data2013 .= $aantalgebruikersjaar;
$data2013 .= "],";
}
if ($jaar==2014)
{
if ($maand=="01") { $data2014 .= "[' " . $lang['MONTH_ABBR_JAN'] . "',"; }
if ($maand=="02") { $data2014 .= "[' " . $lang['MONTH_ABBR_FEB'] . "',"; }
if ($maand=="03") { $data2014 .= "[' " . $lang['MONTH_ABBR_MAR'] . "',"; }
if ($maand=="04") { $data2014 .= "[' " . $lang['MONTH_ABBR_APR'] . "',"; }
if ($maand=="05") { $data2014 .= "[' " . $lang['MONTH_ABBR_MAY'] . "',"; }
if ($maand=="06") { $data2014 .= "[' " . $lang['MONTH_ABBR_JUN'] . "',"; }
if ($maand=="07") { $data2014 .= "[' " . $lang['MONTH_ABBR_JUL'] . "',"; }
if ($maand=="08") { $data2014 .= "[' " . $lang['MONTH_ABBR_AUG'] . "',"; }
if ($maand=="09") { $data2014 .= "[' " . $lang['MONTH_ABBR_SEP'] . "',"; }
if ($maand=="10") { $data2014 .= "[' " . $lang['MONTH_ABBR_OCT'] . "',"; }
if ($maand=="11") { $data2014 .= "[' " . $lang['MONTH_ABBR_NOV'] . "',"; }
if ($maand=="12") { $data2014 .= "[' " . $lang['MONTH_ABBR_DEC'] . "',"; }
$data2014 .= $aantalgebruikersjaar;
$data2014 .= "],";
}
if ($jaar==2015)
{
if ($maand=="01") { $data2015 .= "[' " . $lang['MONTH_ABBR_JAN'] . "',"; }
if ($maand=="02") { $data2015 .= "[' " . $lang['MONTH_ABBR_FEB'] . "',"; }
if ($maand=="03") { $data2015 .= "[' " . $lang['MONTH_ABBR_MAR'] . "',"; }
if ($maand=="04") { $data2015 .= "[' " . $lang['MONTH_ABBR_APR'] . "',"; }
if ($maand=="05") { $data2015 .= "[' " . $lang['MONTH_ABBR_MAY'] . "',"; }
if ($maand=="06") { $data2015 .= "[' " . $lang['MONTH_ABBR_JUN'] . "',"; }
if ($maand=="07") { $data2015 .= "[' " . $lang['MONTH_ABBR_JUL'] . "',"; }
if ($maand=="08") { $data2015 .= "[' " . $lang['MONTH_ABBR_AUG'] . "',"; }
if ($maand=="09") { $data2015 .= "[' " . $lang['MONTH_ABBR_SEP'] . "',"; }
if ($maand=="10") { $data2015 .= "[' " . $lang['MONTH_ABBR_OCT'] . "',"; }
if ($maand=="11") { $data2015 .= "[' " . $lang['MONTH_ABBR_NOV'] . "',"; }
if ($maand=="12") { $data2015 .= "[' " . $lang['MONTH_ABBR_DEC'] . "',"; }
$data2015 .= $aantalgebruikersjaar;
$data2015 .= "],";
}
if ($jaar==2016)
{
if ($maand=="01") { $data2016 .= "[' " . $lang['MONTH_ABBR_JAN'] . "',"; }
if ($maand=="02") { $data2016 .= "[' " . $lang['MONTH_ABBR_FEB'] . "',"; }
if ($maand=="03") { $data2016 .= "[' " . $lang['MONTH_ABBR_MAR'] . "',"; }
if ($maand=="04") { $data2016 .= "[' " . $lang['MONTH_ABBR_APR'] . "',"; }
if ($maand=="05") { $data2016 .= "[' " . $lang['MONTH_ABBR_MAY'] . "',"; }
if ($maand=="06") { $data2016 .= "[' " . $lang['MONTH_ABBR_JUN'] . "',"; }
if ($maand=="07") { $data2016 .= "[' " . $lang['MONTH_ABBR_JUL'] . "',"; }
if ($maand=="08") { $data2016 .= "[' " . $lang['MONTH_ABBR_AUG'] . "',"; }
if ($maand=="09") { $data2016 .= "[' " . $lang['MONTH_ABBR_SEP'] . "',"; }
if ($maand=="10") { $data2016 .= "[' " . $lang['MONTH_ABBR_OCT'] . "',"; }
if ($maand=="11") { $data2016 .= "[' " . $lang['MONTH_ABBR_NOV'] . "',"; }
if ($maand=="12") { $data2016 .= "[' " . $lang['MONTH_ABBR_DEC'] . "',"; }
$data2016 .= $aantalgebruikersjaar;
$data2016 .= "],";
}
if ($maand=="01") { $maand="02"; }
elseif ($maand=="02") { $maand="03"; }
elseif ($maand=="03") { $maand="04"; }
elseif ($maand=="04") { $maand="05"; }
elseif ($maand=="05") { $maand="06"; }
elseif ($maand=="06") { $maand="07"; }
elseif ($maand=="07") { $maand="08"; }
elseif ($maand=="08") { $maand="09"; }
elseif ($maand=="09") { $maand="10"; }
elseif ($maand=="10") { $maand="11"; }
elseif ($maand=="11") { $maand="12"; }
elseif ($maand=="12") { $maand="01"; $jaar=$jaar+1; }
$teller++;
}
$data2012 = substr($data2012,0,strlen($data2012)-1);
$data2013 = substr($data2013,0,strlen($data2013)-1);
$data2014 = substr($data2014,0,strlen($data2014)-1);
$data2015 = substr($data2015,0,strlen($data2015)-1);
$data2016 = substr($data2016,0,strlen($data2016)-1);
*/
?>
// maak blokje met de landen en aantal gebruikers voor de sidebar
$go=mysqli_query($connectie,"SELECT * FROM `bt_user` ORDER BY gebruikersnaam DESC");
while ($row = mysqli_fetch_array($go))
{
$email = $row["email"];
$gebruikersnaam = $row["gebruikersnaam"];
$naam = $row["naam"];
$datum = $row["datum"];
$actief = $row["actief"];
$taaluser = $row["taal"];
$plaats = $row["plaats"];
$land = $row["land"];
// $landid = $row["landid"];
$landuser = $row["landid"];
$fansinds = $row["fansinds"];
$openbaar = $row["openbaar"];
$facebookid = $row["facebookid"];
$twitterid = $row["twitterid"];
}
$aantalgebruikerstotaal = mysqli_num_rows($go);
$unknown = $aantalgebruikerstotaal;
$sql = "SELECT * FROM `bt_country` ORDER BY $taal";
$gocountry=mysqli_query($connectie,"$sql");
$gocountry=mysqli_query($connectie,"SELECT * FROM `bt_country` ORDER BY $taal");
$userpercountry .= "" . $lang['USER_All'] . " ";
$userpercountry .= "" . $lang['USER_BTHAS'] . " $aantalgebruikerstotaal " . $lang['USER_USERS'] . ".
";
$userpercountry .= "" . $lang['USER_PERCOUNTRY'] . " ";
while ($row = mysqli_fetch_array($gocountry))
{
$landid = $row["id"];
$officieel = $row["officieel"];
// $vlag = $row["vlag"];
// if ($vlag == "")
// {
// $vlag = "noflag.png";
// }
$gocountryuser=mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE `landid` = $landid");
$gebruikersperland = mysqli_num_rows($gocountryuser);
// $countryid = $landid;
if ($gebruikersperland>0)
{
switch ($taal)
{
case 'nl':
if ($row["nl"]<>"")
{ $landje = $row["nl"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'en':
if ($row["en"]<>"")
{ $landje = $row["en"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'frl':
if ($row["frl"]<>"")
{ $landje = $row["frl"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'de':
if ($row["de"]<>"")
{ $landje = $row["de"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'es':
if ($row["es"]<>"")
{ $landje = $row["es"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'cat':
if ($row["cat"]<>"")
{ $landje = $row["cat"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'se':
if ($row["se"]<>"")
{ $landje = $row["se"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'it':
if ($row["it"]<>"")
{ $landje = $row["it"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'fr':
if ($row["fr"]<>"")
{ $landje = $row["fr"]; }
else
{ $landje = $row["officieel"]; }
break;
case 'no':
if ($row["no"]<>"")
{ $landje = $row["no"]; }
else
{ $landje = $row["officieel"]; }
break;
default:
$landje = $row["officieel"];
}
// selecteer vlag van het land
if ($landid==1) { $landvlag = " "; }
if ($landid==29) { $landvlag = " "; }
if ($landid==5) { $landvlag = " "; }
if ($landid==11) { $landvlag = " "; }
if ($landid==27) { $landvlag = " "; }
if ($landid==18) { $landvlag = " "; }
if ($landid==9) { $landvlag = " "; }
if ($landid==33) { $landvlag = " "; }
if ($landid==13) { $landvlag = " "; }
// if ($landid=="Engeland") { $landvlag = " "; }
if ($landid==10) { $landvlag = " "; }
if ($landid==26) { $landvlag = " "; }
if ($landid==8) { $landvlag = " "; }
if ($landid==30) { $landvlag = " "; }
if ($landid==28) { $landvlag = " "; }
if ($landid==24) { $landvlag = " "; }
if ($landid==15) { $landvlag = " "; }
if ($landid==23) { $landvlag = " "; }
if ($landid==3) { $landvlag = " "; }
if ($landid==22) { $landvlag = " "; }
if ($landid==2) { $landvlag = " "; }
if ($landid==20) { $landvlag = " "; }
if ($landid==25) { $landvlag = " "; }
if ($landid==14) { $landvlag = " "; }
if ($landid==17) { $landvlag = " "; }
if ($landid==12) { $landvlag = " "; }
if ($landid==34) { $landvlag = " "; }
if ($landid==19) { $landvlag = " "; }
if ($landid==4) { $landvlag = " "; }
if ($landid==7) { $landvlag = " "; }
if ($landid==31) { $landvlag = " "; }
if ($landid==21) { $landvlag = " "; }
if ($landid==6) { $landvlag = " "; }
if ($landid==16) { $landvlag = " "; }
if ($landid==32) { $landvlag = " "; }
$userpercountry .= " ";
$userpercountry .= "" . $landje . " ";
$userpercountry .= " : ";
$userpercountry .= $gebruikersperland;
$userpercountry .= " ";
$userpercountrytabel .= "" . $landvlag . " " . $landje . " " . $gebruikersperland . " \n";
$unknown = $unknown-$gebruikersperland;
}
}
$userpercountry .= "" . $lang['USER_NOCOUNTRYKNOWN'] . " ";
$userpercountry .= $unknown;
$userpercountry .= " " . $lang['USER_USERS'] . ".
";
$go=mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE id=$gebruikersid AND landid=0");
$gebruikerzonderland = mysqli_num_rows($go);
if ($login==TRUE AND $gebruikerzonderland==1)
{
$userpercountry .= " " . $lang['USER_PROFILENOCOUNTRY2'] . " ";
}
?>
echo strtoupper($lang['MENU_STATISTICSUSER']); ?>
$statistiekusertitel = explode(" ", $lang['MENU_STATISTICSUSER']); ?>
echo $statistiekusertitel[0]; ?> echo $statistiekusertitel[1]; ?>
echo $lang['USER_BTHAS'] . " $aantalgebruikerstotaal " . $lang['USER_USERS']; ?>.
echo strtoupper($lang['USER_PERCOUNTRY']); ?>
echo $lang['STAT_ALBUMNUMBER']; ?>
echo $userpercountrytabel; ?>
echo "
" . $lang['USER_NOCOUNTRYKNOWN'] . " " . $unknown . " " . $lang['USER_USERS'] . ".
";
echo "
";
$go=mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE id=$gebruikersid AND landid=0");
$gebruikerzonderland = mysqli_num_rows($go);
if ($login==TRUE AND $gebruikerzonderland==1)
{
// echo "
" . " " . $lang['USER_PROFILENOCOUNTRY2'] . "
";
echo '
× Oops! ' . $lang['USER_PROFILENOCOUNTRY2'] . '
';
}
?>
echo strtoupper($lang['USER_GRAPHLANG']); ?>
echo $lang['STAT_ALBUMNUMBER']; ?>
echo $gebruikerspertaaltabel; ?>
echo strtoupper($lang['USER_GRAPHCONCERTS']); ?>
echo $lang['MAINPAGE_CONCERTS']; ?> echo $lang['STAT_ALBUMNUMBER']; ?>
echo $concertenpergebruikertabel; ?>
echo strtoupper($lang['USER_GRAPHDECADE']); ?>
echo $lang['TOUR_PERIOD']; ?> echo $lang['STAT_ALBUMNUMBER']; ?>
echo $concertenperdeceniumtabel; ?>
include "footer.php";
?>