{PROJECT}
./template/home.ini

{MENU}
00.01

{TITEL}
Konzertkarten und Tickets - Hier finden Sie ihre Tickets

{DESCRIPTION}
Konzertkarten1.de bietet Tickets für Events bundesweit an. Bestellen Sie bequem von zu Hause aus.


{KEYWORDS}
<!-- PAXPHP keywords
echo "\n<meta name=\"Keywords\" content=\"Konzertkarten, Tickets, Karten, Shop, online, bestellen, München, Berlin, Dortmund, Köln, Hamburg, Rock, Pop, Musical, Oper, Theater\">\n";
PAXPHP keywords -->

{CONTENT}
<!-- PAXPHP teaser
echo "<h1>Die aktuellen Topevents</h1>";
include "./include.php";


function topten() {
	$sql = "
	SELECT DISTINCT TOURNR, RANKING FROM eventim5 WHERE (datetime > CURDATE()) AND (RANKING != 0) AND (KATEGORIENR != '3A') GROUP BY TOURNR ORDER by RANKING
	LIMIT 0 , 15
       ";
       $result = mysql_query($sql);
        while (list($TOURNR) = mysql_fetch_row($result)) {
#if ($firstchar != $firstchar_prev) {
 if ($TOURNR != $TOURNR_prev) {
         listonetopevent($TOURNR);
}
}
$TOURNR_prev = $TOURNR;
#$firstchar_prev = $firstchar;

#        } // end while
} // end function topten



function listonetopevent($TOURNR) {
       $result = mysql_query("select EVENTNAME, KATEGORIENR from eventim5 where TOURNR='$TOURNR' ORDER BY LENGTH(EVENTNAME) LIMIT 0,1");
        while ($row = mysql_fetch_array($result)) {
	  $EVENTNAME = $row[EVENTNAME];
if (($row[KATEGORIENR] == '1A')
or ($row[KATEGORIENR] == '1B')
or ($row[KATEGORIENR] == '2')
or ($row[KATEGORIENR] == '5')
or ($row[KATEGORIENR] == '20')
or ($row[KATEGORIENR] == '0')
or ($row[KATEGORIENR] == '1C')
or ($row[KATEGORIENR] == '2A')
or ($row[KATEGORIENR] == '2C')
or ($row[KATEGORIENR] == '2F')
or ($row[KATEGORIENR] == '1D')
or ($row[KATEGORIENR] == '1E')
or ($row[KATEGORIENR] == '1F'))
{ $tix = Konzertkarten; } else { $tix = Karten;
 }

	 }
       $result2 = mysql_query("select ProductLongDescription, ImageSmallURL from eventimraw3 where TOURNR='$TOURNR' LIMIT 0,1");
        while ($row = mysql_fetch_array($result2)) {
#	  echo "<b><a href=\"/".Linkstring($EVENTNAME)."_karten.html\">$EVENTNAME $tix</a></b><br /><br />";
	  echo "<b><i>$EVENTNAME</i></b><br /><br />";
	  echo "<img src=\"".$row[ImageSmallURL]."\" align=\"left\" alt=\"\">".limit_text($row[ProductLongDescription], 500)." ...<br clear=\"all\"><br>";

		$userlist = array();
#		echo "Erleben Sie $EVENTNAME in: ";
#		$result3 = mysql_query("SELECT DISTINCT ORT, EVENTNR, EVENTNAME FROM eventim5 WHERE TOURNR='$TOURNR' GROUP BY(ORT) ORDER BY ORT");
#		 while ($row = mysql_fetch_array($result3)) {
#		  $link = "<a href=\"/d/".$row[EVENTNR]."/".Linkstring($row[EVENTNAME])."/".Linkstring($row[ORT])."/\">$row[ORT]</a>";
#		  $link = "$row[ORT]";
#		  $userlist[] = $link;
#	        }
#		$userlist = implode(", ", $userlist);
#		echo "$userlist";
		echo "<b><a href=\"/".Linkstring($EVENTNAME)."_karten.html\">$EVENTNAME $tix</a></b><br />";
#		echo "<b><a href=\"/".Linkstring($EVENTNAME)."_karten.html\">$EVENTNAME</a></b><br />";
		echo "<hr>";

        }
} // end function listonetopevent

#listonetopevent(223894); // Groenemeyer
#listonetopevent(211708); // Smashing Pumpkins
listonetopevent(261718); // DEPECHE MODE
topten();


PAXPHP teaser -->

<br />
<center>
<!-- PAXPHP quicknav
#echo "<form><select name=navdate onchange=\"location.href=this.form.navdate.options[this.form.navdate.selectedIndex].value\"><option value=''";echo "><center>-- Alle Konzerte im Überblick --</center></option>";$result = mysql_query("SELECT * FROM $dbase WHERE KATEGORIENR = '1A' ORDER by EVENTNAME");while ($row = mysql_fetch_array($result)) {
#$firstchar = Modify_tolower($row[TOURNR]);
#$veranstaltung = Linkstring($row[EVENTNAME]);
#if ($veranstaltung != $veranstaltung_prev) {
#echo"<option value=/".$veranstaltung."_karten.html";
#if(trim($veranstaltung)=="") $veranstaltung=$row["EVENTNAME"];$eventtaster = substr ("$veranstaltung", 0, 50);
#echo ">$row[EVENTNAME]</option>";
#}
#$veranstaltung_prev = $veranstaltung;
#$short_prev = $short;
#}echo "</select></form>";
PAXPHP quicknav -->
</center>