' . $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 .= '10 - 10' . $tel0 . ''; $concertenpergebruikertabel .= '210 - 20' . $tel10 . ''; $concertenpergebruikertabel .= '320 - 30' . $tel20 . ''; $concertenpergebruikertabel .= '430 - 40' . $tel30 . ''; $concertenpergebruikertabel .= '540 - 50' . $tel40 . ''; $concertenpergebruikertabel .= '650 - 60' . $tel50 . ''; $concertenpergebruikertabel .= '760 - 70' . $tel60 . ''; $concertenpergebruikertabel .= '870 - 80' . $tel70 . ''; $concertenpergebruikertabel .= '980 - 90' . $tel80 . ''; $concertenpergebruikertabel .= '1090 - 100' . $tel90 . ''; $concertenpergebruikertabel .= '11100 - 150' . $tel100 . ''; $concertenpergebruikertabel .= '12150 - 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 .= '11970-1980' . $aantalzeventig . ''; $concertenperdeceniumtabel .= '21980-1990' . $aantaltachtig . ''; $concertenperdeceniumtabel .= '31990-2000' . $aantalnegentig . ''; $concertenperdeceniumtabel .= '42000-2000' . $aantalnul . ''; $concertenperdeceniumtabel .= '52010-2020' . $aantaltien . ''; $concertenperdeceniumtabel .= '52020-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); */ ?> " . $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 = "\"$landje\""; } if ($landid==29) { $landvlag = "\"$landje\""; } if ($landid==5) { $landvlag = "\"$landje\""; } if ($landid==11) { $landvlag = "\"$landje\""; } if ($landid==27) { $landvlag = "\"$landje\""; } if ($landid==18) { $landvlag = "\"$landje\""; } if ($landid==9) { $landvlag = "\"$landje\""; } if ($landid==33) { $landvlag = "\"$landje\""; } if ($landid==13) { $landvlag = "\"$landje\""; } // if ($landid=="Engeland") { $landvlag = "\"$landje\""; } if ($landid==10) { $landvlag = "\"$landje\""; } if ($landid==26) { $landvlag = "\"$landje\""; } if ($landid==8) { $landvlag = "\"$landje\""; } if ($landid==30) { $landvlag = "\"$landje\""; } if ($landid==28) { $landvlag = "\"$landje\""; } if ($landid==24) { $landvlag = "\"$landje\""; } if ($landid==15) { $landvlag = "\"$landje\""; } if ($landid==23) { $landvlag = "\"$landje\""; } if ($landid==3) { $landvlag = "\"$landje\""; } if ($landid==22) { $landvlag = "\"$landje\""; } if ($landid==2) { $landvlag = "\"$landje\""; } if ($landid==20) { $landvlag = "\"$landje\""; } if ($landid==25) { $landvlag = "\"$landje\""; } if ($landid==14) { $landvlag = "\"$landje\""; } if ($landid==17) { $landvlag = "\"$landje\""; } if ($landid==12) { $landvlag = "\"$landje\""; } if ($landid==34) { $landvlag = "\"$landje\""; } if ($landid==19) { $landvlag = "\"$landje\""; } if ($landid==4) { $landvlag = "\"$landje\""; } if ($landid==7) { $landvlag = "\"$landje\""; } if ($landid==31) { $landvlag = "\"$landje\""; } if ($landid==21) { $landvlag = "\"$landje\""; } if ($landid==6) { $landvlag = "\"$landje\""; } if ($landid==16) { $landvlag = "\"$landje\""; } if ($landid==32) { $landvlag = "\"$landje\""; } $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'] . "
"; } ?>

 
$aantalgebruikerstotaal " . $lang['USER_USERS']; ?>.
 

  
" . $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'] . '
'; } ?>