REDAXO Forum

Code: Alles auswählen

SELECT name,id FROM rex_article WHERE id = '9'

Code: Alles auswählen

<?PHP
/* Datenbankserver - In der Regel die IP */
$db_server = 'localhost';
/* Datenbankname */
$db_name = 'redaxo';
/* Datenbankuser */
$db_user = 'user';
/* Datenbankpasswort */
$db_passwort = 'pass';
/* Erstellt Connect zu Datenbank her */
$db = @ mysql_connect ( $db_server, $db_user, $db_passwort );
$db_select = @ mysql_select_db( $db_name );

$sql = 'SELECT title, create_date FROM rex_488_articles ORDER BY create_date DESC Limit 5';

$result = mysql_query ( $sql );

$menge = mysql_num_rows ( $result );
$n = "\n";
$rss_title = "http://www.domain.de/rssfeed.php"; // titel des RSS-feeds
	$rss_link = "http://www.domain.de/rssfeed.php"; // link 
	$rss_description = "http://www.domain.de/"; // beschreibung des feeds
	$rss_language = "de-at"; //language code (zb: "de-at");
	$domain = "http://www.domain.de/"; # inkl http:// und abschließendem /    wird in den Links vor rex_getUrl($articleId) gesetzt

header("Content-type: application/xml");
	echo '<'.'?xml version="1.0" encoding="ISO-8859-1" ?'.'>';
	echo '<rss version="0.91">'.$n;
	echo '<channel>'.$n;
	echo '<title>'.$rss_title.'</title>'.$n;
	echo '<link>'.$rss_link.'</link>'.$n;
	echo '<description>'.$rss_description.'</description>'.$n;
	echo '<language>'.$rss_language.'</language>'.$n;

 while ( $row = mysql_fetch_row ( $result ) )
 {
   //echo $row[0] . ' - ' . $row[1] . '<br><br>';
   	echo '<item>'.$n;
		echo '<title>'.$row[0];
		echo '</title>'.$n;
		echo '<description>'.$row[0].'</description>'.$n;
		echo '<link>'.$domain;
		echo '</link>'.$n;
		echo '</item>'.$n;
 }
 	echo '</channel>'.$n;
	echo '</rss>'.$n;
?>

Code: Alles auswählen

RewriteEngine On


RewriteRule blog\/tags\/(.*)\/page\/([0-9]{1,3})\/(.*).html$ index.php?article_id=5&_rex488_uri=tags/$1/$3.html&tag=$1&page=$2&%{QUERY_STRING} [L]
RewriteRule blog/tags/(.*)/(.*).html$ index.php?article_id=5&_rex488_uri=tags/$1/$2.html&tag=$1&%{QUERY_STRING} [L]
RewriteRule blog/archive/([0-9]{1,4})-([0-9]{1,2})/archive.html$ index.php?article_id=5&_rex488_uri=archive/$1-$2/archive.html&archive=$1$2&%{QUERY_STRING} [L]
RewriteRule blog/archive/([0-9]{1,4})-([0-9]{1,2})/page/([0-9]{1,3})/archive.html$ index.php?article_id=5&_rex488_uri=archive/$1-$2/archive.html&archive=$1$2&page=$3&%{QUERY_STRING} [L]
RewriteRule blog/page\/([0-9]{1,3})/(.*)$ index.php?article_id=5&_rex488_uri=$2&page=$1&%{QUERY_STRING} [L]
RewriteRule blog/+(.*)/trackback\/(.*)$ index.php?article_id=5&_rex488_uri=$1/$2&trackback=$1/$2&%{QUERY_STRING} [L]
RewriteRule blog/+(.*)/page\/([0-9]{1,3})/(.*)$ index.php?article_id=5&_rex488_uri=$1/$3&page=$2&%{QUERY_STRING} [L]
RewriteRule blog/(.*)$ index.php?article_id=5&_rex488_uri=$1&%{QUERY_STRING} [L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-l
RewriteCond %{REQUEST_URI} !^redaxo/.*
RewriteCond %{REQUEST_URI} !^files/.*
RewriteRule ^(.*)$ index.php?%{QUERY_STRING} [L]