/' . $landje . ''; } // linker kolom landen overzicht $landenoverzicht .= "

" . $lang['MENU_BRUCEIN'] . "

"; $landenoverzicht .= ''; $gocountry=mysqli_query($connectie,"SELECT * FROM bt_country WHERE id<>35 AND id <> 36 ORDER BY $taal"); while ($row = mysqli_fetch_array($gocountry)) { $cid = $row["id"]; // $vlag = $row["vlag"]; $afk = strtolower($row["afk"]); // if ($vlag == "") // { $vlag = "noflag.png"; } 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 '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 'no': if ($row["no"]<>"") { $landje = $row["no"]; } else { $landje = $row["officieel"]; } break; case 'it': if ($row["it"]<>"") { $landje = $row["it"]; } else { $landje = $row["officieel"]; } break; case 'dk': if ($row["dk"]<>"") { $landje = $row["dk"]; } else { $landje = $row["officieel"]; } break; case 'fr': if ($row["fr"]<>"") { $landje = $row["fr"]; } else { $landje = $row["officieel"]; } break; default: $landje = $row["officieel"]; } $landenoverzicht .= ""; } $landenoverzicht .= "
" . $landje . "
"; //echo ""; // continent codes $regiocode = "002"; // Afrika $regiocode = "150"; // Europa //$regiocode = "019"; // Americas //$regiocode = "021"; // Noord Americas //$regiocode = "005"; // Zuid Americas //$regiocode = "142"; // Azie //$regiocode = "009"; // Oceanie $regiocode = "NL"; $regiocode = "world"; // World $go=mysqli_query($connectie,"SELECT * FROM `bt_country` WHERE `id` =$countryid"); while ($row = mysqli_fetch_array($go)) { $regiocode = $row["afk"]; } if ($landid=="") { $height = "100%"; } else { $height = "200px"; } // statistieken ophalen uit DB $go1=mysqli_query($connectie,"SELECT * FROM `bt_countrystat` ORDER BY aantalconcerten DESC"); $teller = 1; while ($row = mysqli_fetch_array($go1)) { $id = $row["id"]; $land = $row["land"]; $aantalconcerten = $row["aantalconcerten"]; $go2=mysqli_query($connectie,"SELECT * FROM `bt_country` WHERE id=$id"); while ($row = mysqli_fetch_array($go2)) { 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 '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 'no': if ($row["no"]<>"") { $landje = $row["no"]; } else { $landje = $row["officieel"]; } break; case 'it': if ($row["it"]<>"") { $landje = $row["it"]; } else { $landje = $row["officieel"]; } break; case 'dk': if ($row["dk"]<>"") { $landje = $row["dk"]; } else { $landje = $row["officieel"]; } break; case 'fr': if ($row["fr"]<>"") { $landje = $row["fr"]; } else { $landje = $row["officieel"]; } break; default: $landje = $row["officieel"]; } } $landmapdata .= "['" . $landje . "', " . $aantalconcerten . "],"; } $landmapdata = substr($landmapdata,0,-1); //echo $landmapdata; $main2map .= "
"; if ($landid=="") { // echo "Bruce Springsteen heeft in de volgende landen gespeeld:"; //$sidebar = "

" . $lang['MENU_MYBOSSTIME'] . "

"; //$sidebar .= "

\""

"; $sidebar .= $landenoverzicht; //$main1 = "

$titel

"; $main1 = "

" . $lang['COUNTRY_TOTALCOUNTRY'] . "

"; $main1 .= ''; //$main1 .= ""; //$main1 .= ""; $main1 .= ""; //$main1 .= ""; // statistieken ophalen uit DB $go2=mysqli_query($connectie,"SELECT * FROM `bt_countrystat` ORDER BY aantalconcerten DESC"); $teller = 1; while ($row = mysqli_fetch_array($go2)) { $id = $row["id"]; $land = $row["land"]; $aantalconcerten = $row["aantalconcerten"]; $aantalplaatsen = $row["aantalplaatsen"]; $aantalstadions = $row["aantalstadions"]; $aantalnummers = $row["aantalnummers"]; $eerstejaar = $row["eerstejaar"]; $laatstejaar = $row["laatstejaar"]; $gocountry=mysqli_query($connectie,"SELECT * FROM bt_country WHERE id = '$land' "); while ($row = mysqli_fetch_array($gocountry)) { 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 '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; default: $landje = $row["officieel"]; } } if ($oud==$aantalconcerten) { $positie = ""; } else { $positie = $teller; } $main1 .= ""; $oud = $aantalconcerten; $teller++; } $main1 .= "

" . $lang['COUNTRY_TOTALCOUNTRY'] . "

   
" . $lang['ST_COUNTRY'] . "" . $lang['COUNTRY_NUMBER'] . "
   
$positie $landje$aantalconcerten
"; $main1 .= "

" . $lang['COUNTRY_TOTALCITY'] . "

"; $main1 .= ''; // $main1 .= ""; // $main1 .= ""; $main1 .= ""; // statistieken ophalen uit DB $go2=mysqli_query($connectie,"SELECT * FROM `bt_countrystat` ORDER BY aantalplaatsen DESC"); $teller = 1; while ($row = mysqli_fetch_array($go2)) { $id = $row["id"]; $land = $row["land"]; $aantalconcerten = $row["aantalconcerten"]; $aantalplaatsen = $row["aantalplaatsen"]; $aantalstadions = $row["aantalstadions"]; $aantalnummers = $row["aantalnummers"]; $eerstejaar = $row["eerstejaar"]; $laatstejaar = $row["laatstejaar"]; $gocountry=mysqli_query($connectie,"SELECT * FROM bt_country WHERE id = '$land' "); while ($row = mysqli_fetch_array($gocountry)) { 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 '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; default: $landje = $row["officieel"]; } } if ($oud==$aantalplaatsen) { $positie = ""; } else { $positie = $teller; } $main1 .= ""; $oud = $aantalplaatsen; $teller++; } $main1 .= "

" . $lang['COUNTRY_TOTALCITY'] . "

   
" . $lang['ST_COUNTRY'] . "" . $lang['COUNTRY_NUMBER'] . "
$positie $landje$aantalplaatsen
"; $main2 .= "

" . $lang['COUNTRY_TOTALVENUE'] . "

"; $main2 .= ''; // $main2 .= ""; // $main2 .= ""; $main2 .= ""; // statistieken ophalen uit DB $go2=mysqli_query($connectie,"SELECT * FROM `bt_countrystat` ORDER BY aantalstadions DESC"); $teller = 1; while ($row = mysqli_fetch_array($go2)) { $id = $row["id"]; $land = $row["land"]; $aantalconcerten = $row["aantalconcerten"]; $aantalplaatsen = $row["aantalplaatsen"]; $aantalstadions = $row["aantalstadions"]; $aantalnummers = $row["aantalnummers"]; $eerstejaar = $row["eerstejaar"]; $laatstejaar = $row["laatstejaar"]; $gocountry=mysqli_query($connectie,"SELECT * FROM bt_country WHERE id = '$land' "); while ($row = mysqli_fetch_array($gocountry)) { 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 '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; default: $landje = $row["officieel"]; } } if ($oud==$aantalstadions) { $positie = ""; } else { $positie = $teller; } $main2 .= ""; $oud = $aantalstadions; $teller++; } $main2 .= "

" . $lang['COUNTRY_TOTALVENUE'] . "

   
" . $lang['ST_COUNTRY'] . "" . $lang['COUNTRY_NUMBER'] . "
$positie $landje$aantalstadions
"; // 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; $gocountry=mysqli_query($connectie,"SELECT * FROM `bt_country` ORDER BY `bt_country`.`officieel`"); $sidebaruserscountry .= "

" . $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); 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 '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; 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; default: $landje = $row["officieel"]; } $sidebaruserscountry .= ""; $sidebaruserscountry .= "" . $landje . ""; $sidebaruserscountry .= " : "; $sidebaruserscountry .= $gebruikersperland; $sidebaruserscountry .= "
"; $unknown = $unknown-$gebruikersperland; } } $sidebaruserscountry .= "

" . $lang['USER_NOCOUNTRYKNOWN'] . " "; $sidebaruserscountry .= $unknown; $sidebaruserscountry .= " " . $lang['USER_USERS'] . ".

"; $main2 .= $sidebaruserscountry; $main3 .= $main2map; } else { // Specifiek land $sidebar .= $landenoverzicht; $main1 = "

$titel

"; //$main1 .= "

xcvb titelxcvb titelxcvb titelxcvb titelxcvb titelxcvb titelxcvb titel

"; // SPECIFIEKE LANDPAGINA $go=mysqli_query($connectie,"SELECT * FROM `bt_country` WHERE `id` =$countryid"); while ($row = mysqli_fetch_array($go)) { $countryafk = $row["afk"]; $countryimage = $row["en"] . ".png"; $countryimage = $row["afk"] . ".png"; $countryimage = strtolower($countryimage); } // statistieken ophalen uit DB $go2=mysqli_query($connectie,"SELECT * FROM `bt_countrystat` WHERE `id` =$countryid"); $teller = 1; while ($row = mysqli_fetch_array($go2)) { $id = $row["id"]; $land = $row["land"]; $aantalconcerten = $row["aantalconcerten"]; $aantalplaatsen = $row["aantalplaatsen"]; $aantalstadions = $row["aantalstadions"]; $aantalnummers = $row["aantalnummers"]; $eerstejaar = $row["eerstejaar"]; $laatstejaar = $row["laatstejaar"]; $aantalnummers = $row["aantalnummers"]; $aantalverschillendenummers = $row["aantalverschillendenummers"]; } $goaantalgebruikers = mysqli_query($connectie,"SELECT * FROM `bt_user` WHERE `landid` = $countryid"); $aantalgebruikersditland = mysqli_num_rows($goaantalgebruikers); /* ONDERSTAANDE NOG VERWERKEN: = 'Aantal concerten in'; = 'Eerste concert'; = 'Laatste concert'; = 'Aantal verschillende steden'; = 'Aantal verschillende locaties'; = 'Aantal nummers gespeeld in'; = 'Aantal verschillende nummers gespeeld in'; */ $main1 .= ''; $main1 .= "
" . $lang['COUNTRY_NUMBERCONCERTS'] . "$aantalconcerten"; $main1 .= "
" . $lang['COUNTRY_FIRST'] . "$eerstejaar"; $main1 .= "
" . $lang['COUNTRY_LAST'] . "$laatstejaar"; $main1 .= "
" . $lang['COUNTRY_DIFFERENTCOUNTRIES'] . "$aantalplaatsen"; $main1 .= "
" . $lang['COUNTRY_DIFFERENTLOCATIONS'] . "$aantalstadions"; $main1 .= "
" . $lang['COUNTRY_NUMBERPLAYED'] . "$aantalnummers"; $main1 .= "
" . $lang['COUNTRY_DIFFERENTNUMBER'] . "$aantalverschillendenummers"; $main1 .= "
" . $lang['COUNTRY_DIFFERENTUSER'] . "$aantalgebruikersditland"; $main1 .= "
"; // $main1 .= ""; // $main1 .= ""; // $main1 .= ""; // $main1 .= ""; // $main1 .= ""; // $main1 .= "
"; // $main1 .= "
"; // $main1 .= ""; $main2 .= ""; // $main1 .= "x
x
x"; $main1 .= "

" . $lang['COUNTRY_FOLLOWINGPLACES'] . ":

"; $main1 .= ''; $main1 .= ""; $main1 .= ""; $main1 .= ""; $gostad=mysqli_query($connectie,"SELECT * FROM `bt_city` WHERE `land` = $countryid ORDER BY officieel"); while ($row = mysqli_fetch_array($gostad)) { $city = $row["id"]; $goaantalconcerten = mysqli_query($connectie,"SELECT bt_live.id, bt_plaats.googleearth FROM bt_live INNER JOIN bt_plaats ON bt_plaats.id = bt_live.plaats INNER JOIN bt_city ON bt_city.id = bt_plaats.city WHERE bt_city.id = $city"); $aantalconcerten = mysqli_num_rows($goaantalconcerten); include "includes/include_plaats.php"; $main1 .= ''; // $main1 .= "
"; } $main1 .= "
" . $lang['TOUR_PLACE'] . "" . $lang['COUNTRY_NUMBERCONCERTS'] . "
' . $plaatsevent . '' . $aantalconcerten . '
"; $main1 .= "

" . $lang['COUNTRY_FOLLOWINGSTADIUMS']. ":

"; $main1 .= ''; $main1 .= ""; $main1 .= ""; $main1 .= ""; $gostadion=mysqli_query($connectie,"SELECT bt_city.id id, naam, bt_plaats.id stadionid FROM `bt_city` JOIN bt_plaats ON bt_plaats.city = bt_city.id WHERE bt_city.land=$countryid ORDER BY naam"); while ($row = mysqli_fetch_array($gostadion)) { $city = $row["id"]; $naam = $row["naam"]; $stadionid = $row["stadionid"]; include "includes/include_plaats.php"; $goaantalstadions = mysqli_query($connectie,"SELECT * FROM `bt_live` WHERE `plaats` = $stadionid"); $aantalstadions = mysqli_num_rows($goaantalstadions); $main1 .= ''; $main1 .= ''; $main1 .= ""; } $main1 .= "
" . $lang['TOUR_LOCATION'] . "" . $lang['TOUR_PLACE'] . "" . $lang['COUNTRY_NUMBERCONCERTS'] . "
' . $naam . '' . $plaatsevent . '" . $aantalstadions . "
"; $main1 .= "

" . $lang['COUNTRY_FOLLOWINGCONCERTS']. ":

"; $main1 .= ''; $main1 .= ""; $main1 .= ""; $main1 .= ""; $main1 .= ""; $visited = $lang['TOUR_VISIT']; if($login == TRUE) { $main1 .= ""; } else { $main1 .= ""; } $main1 .= ""; $concert = $_POST['id']; if ($userid!="" AND $concert!="") { //mysqli_query($connectie,"INSERT INTO `bt_userconcerts` (`id`, `userid`, `concertid`) VALUES (NULL, '$userid', '$concert')") or die("Er ging iets mis het het opslaan..."); //INSERT INTO table (primarykeycol,col1,col2) VALUES (1,2,3) ON DUPLICATE KEY UPDATE col1=0, col2=col2+1 // $main1 .= "jaaa"; //mysqli_query($connectie,"UPDATE `bt_userconcerts` SET concertid=$concert WHERE userid=$userid;"); mysqli_query($connectie,"INSERT INTO `bt_userconcerts` (`id`, `userid`, `concertid`) VALUES (NULL, '$userid', '$concert')") or die("Er ging iets mis het het opslaan..."); } if(isset($_GET['sortby'])) { switch($_GET['sortby']) { case 'datum': $sorteer = 'datum'; break; case 'plaats': $sorteer = 'bt_plaats.plaats'; break; case 'naam': $sorteer = 'bt_plaats.naam'; break; } } else $sorteer = 'datum'; $manier = (isset($_GET['updown']) && ($_GET['updown']) == 'DESC') ? 'DESC' : 'ASC'; $go=mysqli_query($connectie,"select bt_city.land, bt_plaats.land, bt_live.* FROM bt_live INNER JOIN bt_plaats On bt_live.plaats = bt_plaats.id INNER JOIN bt_city On bt_plaats.city = bt_city.id WHERE bt_city.land=$countryid ORDER BY ".$sorteer." ".$manier); while ($row = mysqli_fetch_array($go)) { $id = $row["id"]; $datum = $row["datum"]; $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); $plaats = $row["plaats"]; $fotos = $row["fotos"]; $torrent = $row["torrent"]; $waardering = $row["waardering"]; $storyteller = $row["storyteller"]; $brucebase = $row["brucebase"]; $setlist = $row["setlist"]; $video = $row["video"]; $tour = $row["tour"]; $klikje=""; $gosetlist=mysqli_query($connectie,"SELECT * FROM bt_concertsongs WHERE concertid = '$id'"); $aantalnummers = mysqli_num_rows($gosetlist); $main1 .= "
\n"; // $main1 .= "'); return false;\">\n"; // $main1 .= "
\n"; $main1 .= " \n"; if ($aantalnummers > 0) { // volledige setlijst $main1 .= "\n"; // niet volledige setlijst // $main1 .= "\n"; } else { $main1 .= "\n"; } if(!isset($_SESSION['logged_in']) || $_SESSION['logged_in'] == true) { $boxje = "\n"; $geweest = FALSE; $gogogo=mysqli_query($connectie,"SELECT * FROM bt_userconcerts WHERE userid=$userid AND concertid=$id"); while ($row = mysqli_fetch_array($gogogo)) { // $boxje .= "\n"; $geweest = TRUE; } if ($geweest) { // $boxje .= "\n"; $boxje .= ""; /* $boxje .= "\n";*/ } else { $boxje .= ""; } } else { $boxje = " "; } $go2=mysqli_query($connectie,"SELECT * FROM bt_plaats WHERE id = '$plaats' "); while ($row = mysqli_fetch_array($go2)) { $idpl = $row["id"]; $naam = $row["naam"]; $city = $row["city"]; // $plaatsevent = $row["plaats"]; // $land = $row["land"]; $googleearth = $row["googleearth"]; $website = $row["website"]; $foto = $row["foto"]; $capaciteit = $row["capaciteit"]; $adres = $row["adres"]; // include "tourvlaggen.php"; include "includes/include_plaats.php"; $main1 .= "\n"; $main1 .= "\n"; // $main1 .= "\n"; $main1 .= "\n"; $main1 .= "\n"; $main1 .= "\n"; } } $main1 .= "
" . $lang['TOUR_DATE'] . "" . $lang['TOUR_LOCATION'] . "" . $lang['TOUR_PLACE'] . "$visited 
$klikje$date $klikje$date \"Setlist$klikje$date$klikje$naam $klikje$plaatsevent$landvlag\n"; if($login == TRUE) { $main1 .= $boxje; } else { $main1 .= " "; } $main1 .= "
\n"; $main1 .= "
"; $main1 .= "
"; } ?>