';
echo
'
Metalgigs.',getCountryFlag(),' News Feed
http://www.metalgigs.'.getCountryFlag().'/news
Der Metalgigs.',getCountryFlag(),' News Feed mit allen News rund um Metalgigs.de und Metalgigs.at
';
while ($row = fetch_assoc($res)) {
pNewsEntry($row);
}
echo
"
";
}
/**
*
* @param $row
*/
function pNewsEntry($row){
// $maxLength = 150;
$datum = format_rss_time($row['timestamp']);
$newstext = htmlspecialchars(Parser::parseComment($row['newstext']));
// $newstext = shortStringNoCutoff($newstext;
echo "
-
$datum
",$row['titel'],"
http://www.metalgigs.",getCountryFlag(),"/news_",$row['ID'],".html
$newstext
http://www.metalgigs.",getCountryFlag(),"/news_",$row['ID'],".html
";
}
/**
* Gibt den persönlichen Startseiten Feed aus
*/
function pPersStartRss(){
$hash = real_escape_string(htmlentities($_GET['id']));
$sql = "SELECT * FROM user_start WHERE rssID = '$hash'";
$res = query($sql);
if(num_rows($res)==1) {
$row = fetch_assoc($res);
$uID = $row['uID'];
$userSQL = "SELECT username FROM user WHERE uID = $uID LIMIT 0,1";
$userRes = query($userSQL);
$userRow = fetch_assoc($userRes);
$username = $userRow['username'];
$sqlStart = $row['sql2'];
$sql = "SELECT k.ID,LID, isKonzert, Bands, titel,name, stadt, url, Genre, stadt_bei, longitude, latitude,k.Timestamp,land FROM konzerte as k JOIN locations as l ON k.locationID = l.LID JOIN konzert_datum as d ON k.ID=d.konzertID WHERE d.Datum>=NOW() $sqlStart ORDER BY k.`ID` DESC LIMIT 0,60";
$res = query($sql);
// $res = Events::getCompleteEventsRes("Datum>=NOW() $sqlStart ORDER BY k.Timestamp DESC ", "LIMIT 0,60");
pRssFeed("$username's Metalgigs Feed", "rssfeed.rdf?id=$hash", "Deine aktuellen Termine", $res);
}
else {
echo "Ungültige ID!";
}
}
/**
*
*/
function pBandRss(){
$band = urldecode(real_escape_string($_GET['band']));
$sql = "SELECT ID FROM bands2 WHERE name = '$band'";
$res = query($sql);
if(num_rows($res)==1) {
$bandRow = fetch_assoc($res);
$bandID = $bandRow['ID'];
$flagg = getCountryFlag();
$sql = "SELECT k.ID,LID, isKonzert, Bands, titel,name, stadt, url, Genre, stadt_bei, longitude, latitude,k.Timestamp,land FROM konzerte as k JOIN locations as l ON k.locationID = l.LID WHERE k.ID = ANY (SELECT konzertID FROM bandSpieltBei WHERE bandID=$bandID) ORDER BY k.ID DESC LIMIT 0,60";
$res = query($sql);
pRssFeed("Zukünftige Konzert von $band auf Metalgigs.de & Metalgigs.at als RSS Feed", "rssfeed.rdf?band=".urlencode($band), "Metalgigs.$flagg Rss Feed für $band", $res);
}
else {
echo "Ungueltige Band!";
}
}
/**
* Rss Feed für bestimmte Stadt ausgeben
*/
function pStadtRss(){
$stadt = real_escape_string($_GET['stadt']);
$sql = "SELECT k.ID,LID, isKonzert, Bands, titel,name, stadt, url, Genre, stadt_bei, longitude, latitude,k.Timestamp,land FROM konzerte AS k JOIN locations as l ON k.locationID=l.LID WHERE (l.stadt = '$stadt' OR l.stadt_bei='$stadt') ORDER BY k.`ID` DESC LIMIT 0,60";
$res = query($sql);
pRssFeed("$stadt's Metalgigs Feed", "rssfeed.rdf?stadt=$stadt", "Metalgigs Rss Feed für $stadt", $res);
}
/**
* Gibt einen Rss Feed aus
* @param string $title $title
* @param string $link href="http://www.metalgigs.de/$link"
* @param string $description $description
* @param string $sql Entsprechender Sql Befehl
*/
function pRssFeed($title,$link,$description,$res){
header("Content-Type: application/xml; charset=ISO-8859-1");
echo
'
';
echo
'
',$title,'
http://www.metalgigs.'.getCountryFlag().'/
',$description,'
';
while($row = fetch_assoc($res)){
pRssEntry($row);
}
echo
"
";
}
/**
* Gibt einen RSS Eintrag anhand der $row aus
* @param $row
*/
function pRssEntry($row){ // d.Datum, k.ID, isKonzert, Bands, titel,name, stadt, url, Genre, stadt_bei, longitude, latitute,Timestamp,land
$sql = "SELECT Datum FROM konzert_datum WHERE konzertID=".$row['ID']." ORDER BY Datum ASC";
$res = query($sql);
$dateStart = $dateEnd = 0;
while ($dateRow = fetch_assoc($res)) {
if($dateStart == 0){
$dateStart = format_time($dateRow['Datum']);
}
if($dateRow > $dateEnd){
$dateEnd = $dateRow['Datum'];
}
}
$dateEnd = format_time($dateEnd);
if($dateStart != $dateEnd){
$dateEnd = " bis ".$dateEnd;
}
else {
$dateEnd = "";
}
// $datum = format_time($row['Datum']);
$id = $row['ID'];
$titel = "";
$category = "";
if($row['isKonzert']==1) {
$category = "Konzert";
if(!isset ($_GET['twitter'])){
$titel="[Konzert] ";
}
else {
$titel="#Konzert ";
}
$sql = "SELECT name FROM bands2 WHERE ID = ANY(SELECT bandID FROM bandSpieltBei WHERE konzertID=$id)";
$res = query($sql);
$bands = null;
while ($row2 = fetch_assoc($res)) {
$bands .= $row2['name'].", ";
}
$bands = substr($bands, 0, -2);
}
else {
$category = "Party";
if(!isset ($_GET['twitter'])){
$titel = "[Party] ";
}
else {
$titel = "#Party ";
}
$bands = $row['Bands'];
}
$titel = $titel.$row['titel'];
$location = $row['name'];
$stadt = $row['stadt'];
// $url = $row['url'];
$url = Locations::getLocationLink($row['LID'], $row['name'], $row['stadt'], $row['land']);
$genre = $row['Genre'];
$ahref = "";
if($url!=NULL) {
$ahref = "<a href="$url">$location</a>";
}
else {
$ahref = " $location ";
}
$bands = htmlspecialchars($bands);
if(isset ($_GET['twitter'])){
$location = "#".$location;
$stadt = "#".$stadt;
}
$stadt_bei = "";
if($row['stadt_bei'] != null && $row['stadt_bei'] != ''){
$stadt_bei = ' bei '.$row['stadt_bei'];
}
$geoRss = "";
if($row['latitude'] != null && $row['longitude'] != null){
$geoRss = ''.$row['latitude'].' '.$row['longitude'].'';
}
$link = getEventLink($row['ID'], $row['titel'], $row['isKonzert'], $row['stadt'], $row['land'], true);
// $minimalLink = Events::getMinimalEventLink($row['ID'], $row['isKonzert'], $row['land'], true);
echo "
-
",format_rss_time($row['Timestamp']),"
",$dateStart,$dateEnd," - ",$titel," @ ",$location,", ",$stadt,$stadt_bei,"
$link
",$dateStart,$dateEnd," - $bands <br> $ahref - ",$genre,"
$category
",$link,"
$geoRss
";
}
?>