execRequete("SELECT * FROM texts WHERE id='130'"); /* $texte=$bd->execRequete("SELECT * FROM texts WHERE titen='$type'"); */ $texte=$bd->ligneSuivante($texte); ?>
execRequete("SELECT * FROM maps WHERE permalink='".$mapperm."'"); while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['mapname']." (".$list['mapplace'].")"; echo "

"; echo ""; echo ""; echo "
"; echo $list['mapaddress']; echo ""; // show list of dates he-she played $lista=$bd->execRequete("SELECT partydat, mapsid, maps.id, parties.id as partiesid FROM maps, parties WHERE permalink='".$mapperm."' AND maps.id = parties.mapsid ORDER BY parties.id DESC"); echo "

Parties we had at this venue

"; while ($listb=$bd->ligneSuivante($lista)) { $mapperm = $listb['permalink']; $partydat = showdat($listb['partydat'],$lg); $partiesid = $listb['partiesid']; echo "".$partydat."
"; } echo "
"; eval('echo "

".$list["map'.$lg.'"]."

";'); echo "
"; echo $list['mappics']; echo "
"; if ($list['mapgoogle']!='') { echo "
"; } //show direct link //echo "

http://www.losninos.be/artist/".$list['permalink'].""; //show videos /* if ($list['artistvideos'] != '') echo $list['artistvideos']; */ //show pictures of artist /* echo "

"; showartistxl ('artists','',$list['id']); */ } echo "

 

"; } /* elseif (isset($mapid)) */ elseif (!empty($mapid)) { $liste=$bd->execRequete("SELECT * FROM maps WHERE id='".$mapid."'"); while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['mapname']." (".$list['mapplace'].")"; echo "

"; echo ""; echo ""; echo "
"; echo $list['mapaddress']; echo ""; // show list of dates he-she played $lista=$bd->execRequete("SELECT partydat, mapsid, maps.id, parties.id as partiesid FROM maps, parties WHERE maps.id='".$mapid."' AND maps.id = parties.mapsid ORDER BY parties.id DESC"); echo "

Parties at this venue

"; while ($listb=$bd->ligneSuivante($lista)) { $mapperm = $listb['permalink']; $partydat = showdat($listb['partydat'],$lg); $partiesid = $listb['partiesid']; echo "".$partydat."
"; } echo "
"; eval('echo "

".$list["map'.$lg.'"]."

";'); echo "
"; echo $list['mappics']; echo "
"; if ($list['mapgoogle']!='') { echo "
"; } //show direct link //echo "

http://www.losninos.be/artist/".$list['permalink'].""; //show videos /* if ($list['artistvideos'] != '') echo $list['artistvideos']; */ //show pictures of artist /* echo "

"; showartistxl ('artists','',$list['id']); */ } echo "

 

"; } ################## ## ALL VENUES ## ################## else { eval('$showtexte=$texte["text'.$lg.'"];'); $result=PutPict($showtexte,$texte['id']); echo $result['txt']; $liste=$bd->execRequete("SELECT * FROM maps WHERE visible = 'y' ORDER BY mapname"); while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['mapname']." (".$list['mapplace'].")"; echo "

"; } echo "

 

"; } ?>