<?php
defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Übersicht Musiknews';
$hmenu = 'Übersicht Musiknews';
$design = new design ( $title , $hmenu );
$design->header();
# Allgemeine Variablen
$textlaenge = 300; # Hier stellt man die Text laenge ein :-)
$titlelaenge = 40; # Hier stellt man die Text laenge ein :-)
$limit = 1; # Wie viel HipHop news angezeigt werden sollen, das muss immer auf 1 stehen!!
$tpl = new tpl('musiknews/musiknewsde');
//Abfrage für HipHop de Version
$abf1 = "SELECT
a.news_title,
a.news_id,
a.news_kat,
a.news_text,
b.name,
b.id
FROM prefix_musiknewsde as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE a.news_kat = 'pop' AND "
.$_SESSION['authright']." <= a.news_recht
ORDER BY news_time DESC
LIMIT $limit";
$erg = db_query($abf1);
while ($row = db_fetch_assoc($erg)) {
if(strlen($row['news_text']) > $textlaenge ){
$textausgabe = substr($row['news_text'], 0, $textlaenge ).'...';
}
if(strlen($row['news_title']) > $titlelaenge ){
$hiphopdetitle = substr($row['news_title'], 0, $titlelaenge ).'...';
}
$hiphopdeid = $row['news_id'];
}
//====================================================================================================================================
//Abfrage für RnB de Version
$abf2 = "SELECT
a.news_title as rnbtitle,
a.news_id as rnbid,
a.news_text as rnbtext,
b.name,
b.id
FROM prefix_musiknewsde as a
LEFT JOIN prefix_user as b ON a.user_id = b.id
WHERE a.news_kat = 'rnb' AND "
.$_SESSION['authright']." <= a.news_recht
ORDER BY news_time DESC
LIMIT $limit";
$erg2 = db_query($abf2);
while ($row2 = db_fetch_assoc($erg2)) {
if(strlen($row2['rnbtext']) > $textlaenge ){
$rnbtext = substr($row2['rnbtext'], 0, $textlaenge ).'...';
}
if(strlen($row2['rnbtitle']) > $titlelaenge ){
$rnbdetitle = substr($row2['rnbtitle'], 0, $titlelaenge ).'...';
}
$rnbdeid = $row2['rnbid'];
}
$ar = array (
//RnB
'rnbdetitle' => $rnbdetitle,
'rnbde' => $rnbtext,
'rnbdeid' => $rnbdeid,
//HipHop
'hiphopdetitle' => $hiphopdetitle,
'hiphopde' => $textausgabe,
'hiphopdeid' => $hiphopdeid
);
$tpl->set_ar_out($ar,0);
$design->footer();
?>
verwendete ilchClan Version: 1.1
Zitat geschrieben von Mairu
