1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 | <?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