include ("../daten.php");
include ("../texte/de/lang.inc.php");
/* VERBINDUNG ZUR DATENBANK AUFBAUEN */
require ("../redakteur/config_frontend.php3");
$mysqli = new mysqli("localhost", "user", "password", "database"); /* mysql_connect($mysqlhst,$mysqlusr,$mysqlpass); */
mysql_select_db($dbname);
if (empty($news_detail)) {
/* DIE ERSTEN DREI NEWS-EINTRÄGE HOLEN */
$get_news = "SELECT A.news_id, UNIX_TIMESTAMP(A.news_date_online) AS 'date_online', A.reihenfolge, A.sprach_id, A.news_ort, A.news_headline, A.news_teaser, A.news_text FROM t_news as A, t_sprache as B where (A.sprach_id = B.sprach_id) AND (B.sprachkuerzel = '$lang') AND (A.istonline = '1') order by date_online desc, A.reihenfolge desc limit 0, 3";
/* DIE WEITEREN NEWS-EINTRÄGE HOLEN */
$get_news_2 = "SELECT A.news_id, UNIX_TIMESTAMP(A.news_date_online) AS 'date_online', A.reihenfolge, A.sprach_id, A.news_ort, A.news_headline, A.news_teaser, A.istonline FROM t_news as A, t_sprache as B where (A.sprach_id = B.sprach_id) AND (B.sprachkuerzel = '$lang') AND (A.istonline = '1') order by date_online desc, A.reihenfolge desc limit 3, 10";
} else {
/* DETAILS ZUR NEWS HOLEN */
$get_news = "SELECT UNIX_TIMESTAMP(news_date_online) AS 'date_online', news_ort, news_headline, news_teaser, news_text, ref_id, car_id FROM t_news where news_id=$news_id";
}
?>