News (ältere News)

mymaddin

Hallo allerseits!

Gibt es eine Möglichkeit, dass immer 2 News auf der Seite direkt zu sehen sind und dann für ältere News, soll unten dann so 1 2 3 stehn das angeklickt werden kann
und dann kann man die älteren News sehen.

Versteht jemand was ich vorhabe`?
Page: http://www.mymaddin.com/

Gruß Martin

No0ob

Wenn das ganze über MySQL läuft, einfach über LIMIT-Anweisungen einstellen

mymaddin

Wie ist der Code dazu?

K.Y.L.T.

da musst du uns zuerst den Code deiner PHP verraten, sonst können wir nicht sagen wie der verändert werden muss

Allgemein irgendwas in der art musst du suchen:

mysql_query("select * from news ");

mymaddin

So BItte:

PHP

<?php
/*
 ########################################################################
#                                                                        #
#           Version 4       /                        /   /               #
#          -----------__---/__---__------__----__---/---/-               #
#           | /| /  /___) /   ) (_ `   /   ) /___) /   /                 #
#          _|/_|/__(___ _(___/_(__)___/___/_(___ _/___/___               #
#                       Free Content / Management System                 #
#                                   /                                    #
#                                                                        #
#                                                                        #
#   Copyright 2005-2006 by webspell.org / webspell.info                  #
#                                                                        #
#   visit webSPELL.org, webspell.info to get webSPELL for free           #
#   - Script runs under the GNU GENERAL PUBLIC LICENCE                   #
#   - It's NOT allowed to remove this copyright-tag                      #
#   -- http://www.fsf.org/licensing/licenses/gpl.html                    #
#                                                                        #
#   Code based on WebSPELL Clanpackage (Michael Gruber - webspell.at),   #
#   Far Development by Development Team - webspell.org / webspell.info   #
#                                                                        #
#   visit webspell.org / webspell.info                                   #
#                                                                        #
 ########################################################################
*/


$action = $_GET['action'];
if($action=="new") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  echo '<html><head>';
	echo'<script src="js/bbcode.js" language="jscript" type="text/javascript"></script>
		 <link href="_stylesheet.css" rel="stylesheet" type="text/css"></head></script>
<script type="text/javascript">
_uacct = "UA-2159210-1";
urchinTracker();
</script><body>';

	if(isnewsadmin($userID)) {
		safe_query("DELETE FROM ".PREFIX."news WHERE headline1='' AND lang1='' AND lang2='' AND headline2=''");		
		safe_query("INSERT INTO ".PREFIX."news (date, poster, saved) VALUES ('".time()."', '$userID', '0')");
		$newsID=mysql_insert_id();

		$newsrubrics=safe_query("SELECT rubricID, rubric FROM ".PREFIX."news_rubrics ORDER BY rubric");
	    while($dr=mysql_fetch_array($newsrubrics)) {
		    $rubrics.='<option value="'.$dr[rubricID].'">'.$dr[rubric].'</option>';
		}

  	if($_POST['topnews']) safe_query("UPDATE ".PREFIX."settings SET topnewsID='$newsID'");


		$lang=safe_query("SELECT lang, language FROM ".PREFIX."news_languages ORDER BY language");
		while($dl=mysql_fetch_array($lang)) {
		    if($dl[lang]=="de") $langs1.='<option value="'.$dl[lang].'" selected>'.$dl[language].'</option>';
			else $langs1.='<option value="'.$dl[lang].'">'.$dl[language].'</option>';

			if($dl[lang]=="uk") $langs2.='<option value="'.$dl[lang].'" selected>'.$dl[language].'</option>';
			else $langs2.='<option value="'.$dl[lang].'">'.$dl[language].'</option>';
		}
		$url1="http://";
		$url2="http://";
		$url3="http://";
		$url4="http://";

		$bg1=BG_1;
		eval ("\$addbbcode = \"".gettemplate("addbbcode")."\";");
		eval ("\$addflags = \"".gettemplate("flags")."\";");

		eval ("\$news_post = \"".gettemplate("news_post")."\";");
	    echo $news_post;  
	}
	else redirect('index.php?site=news', 'no access!');
}
elseif($action=="save") {
 	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  $newsID = $_POST['newsID'];
  $save = $_POST['save'];
  $preview = $_POST['preview'];

  $rubric = $_POST['rubric'];


	$lang1 = $_POST['lang1'];
	$headline1 = $_POST['headline1'];
	$message = $_POST['message'];


	$lang2 = $_POST['lang2'];
	$headline2 = $_POST['headline2'];
	$content2 = $_POST['content2'];


	$link1 = $_POST['link1'];
	$url1 = $_POST['url1'];
	$window1 = $_POST['window1'];


	$link2 = $_POST['link2'];
	$url2 = $_POST['url2'];
	$window2 = $_POST['window2'];


	$link3 = $_POST['link3'];
	$url3 = $_POST['url3'];
	$window3 = $_POST['window3'];


	$link4 = $_POST['link4'];
	$url4 = $_POST['url4'];
	$window4 = $_POST['window4'];

	$intern = $_POST['intern'];
	$comments = $_POST['comments'];

	safe_query("UPDATE ".PREFIX."news SET rubric='$rubric',
                      lang1='$lang1',
                      headline1='".mysql_escape_string($headline1)."',
                      content1='".mysql_escape_string($message)."',
                      lang2='$lang2',
                      headline2='".mysql_escape_string($headline2)."',
                      content2='".mysql_escape_string($content2)."',
                      link1='$link1',
                      url1='$url1',
                      window1='$window1',
                      link2='$link2',
                      url2='$url2',
                      window2='$window2',
                      link3='$link3',
                      url3='$url3',
                      window3='$window3',
                      link4='$link4',
                      url4='$url4',
                      window4='$window4',
                      saved='1',
                      intern='$intern',
                      comments='$comments' WHERE newsID='$newsID'");

	// löschen der einträge die älter als 1 stunde sind und keinen text enthalten
	$ergebnis=safe_query("SELECT * FROM ".PREFIX."news WHERE headline1='' OR content1=''");
	while($ds=mysql_fetch_array($ergebnis)) {
		if((time()-$ds[date]) > (60*60)) safe_query("DELETE FROM ".PREFIX."news WHERE newsID='$ds[newsID]'");
	}


	if($_POST['topnews']) safe_query("UPDATE ".PREFIX."settings SET topnewsID='$newsID'");


	if($save) echo'<body onLoad="window.close()"></body>';
	if($preview) header("Location: news.php?action=preview&newsID=$newsID");


}
elseif($action=="preview") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');




  $newsID = $_GET['newsID'];


	echo'<script src="js/bbcode.js" language="jscript" type="text/javascript"></script>
		 <link href="_stylesheet.css" rel="stylesheet" type="text/css">';


	$bg1=BG_1;

	eval ("\$title_news = \"".gettemplate("title_news")."\";");
	echo $title_news;


	$result=safe_query("SELECT * FROM ".PREFIX."news WHERE newsID='$newsID'");
    $ds=mysql_fetch_array($result);
	    $bgcolor=BG_1;
		$date = date("d.m.Y", $ds[date]);
		$time = date("H:i", $ds[date]);
		$rubrikname=getrubricname($ds[rubric]);
		$rubricpic='[img]images/news-rubrics/'.getrubricpic($ds[rubric]).'[/img]';
		if(!file_exists($rubricpic)) $rubricpic = '';

		$lang=$ds[lang1];
		$language1="[flag]".$ds[lang1]."[/flag]";
		$language2="[flag]".$ds[lang2]."[/flag]";

		if($lang==$ds[lang1]) {
		    if($ds[headline1]) $headline = $ds[headline1];
			else $headline = $ds[headline2];

			if($ds[content1]) $content = $ds[content1];
			else $content='[b]no version in selected language available![/b].[br][br]'.$ds[content2];

			$langs='';
			if($ds[headline2]) {
			    $langs='[url='news.php?action=preview&newsID='.$ds[newsID].'&lang='.$ds[lang2].'']'.flags($language2).'[/url]';
	            $language=getlanguage($ds[lang2]);
				$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);
			}	
		}
		else {
		    if($ds[headline2]) $headline = $ds[headline2];
			else $headline = $ds[headline1];

			if($ds[content2]) $content = $ds[content2];
			else $content='[b]no version in selected language available![/b].[br][br]'.$ds[content1];

			$langs='';
			if($ds[headline1]) {
			    $langs='[url='news.php?action=preview&newsID='.$ds[newsID].'&lang='.$ds[lang1].'']'.flags($language1).'[/url]';
				$language=getlanguage($ds[lang1]);
				$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);
			}	
		}

		$content = htmloutput($content);
		$content = toggle($content, $ds[newsID]);
		$poster='[url='index.php?site=profile&id='.$ds[poster].''][b]'.getnickname($ds[poster]).'[/b][/url]';
		if($ds[link1] && $ds[url1]!="http://" && $ds[window1]) $related.='• [url=''.$ds[url1].'']'.$ds[link1].'[/url] ';
		if($ds[link1] && $ds[url1]!="http://" && !$ds[window1]) $related.='• [url=''.$ds[url1].'']'.$ds[link1].'[/url] ';

		if($ds[link2] && $ds[url2]!="http://" && $ds[window2]) $related.='• [url=''.$ds[url2].'']'.$ds[link2].'[/url] ';
		if($ds[link2] && $ds[url2]!="http://" && !$ds[window2]) $related.='• [url=''.$ds[url2].'']'.$ds[link2].'[/url] ';

		if($ds[link3] && $ds[url3]!="http://" && $ds[window3]) $related.='• [url=''.$ds[url3].'']'.$ds[link3].'[/url] ';
		if($ds[link3] && $ds[url3]!="http://" && !$ds[window3]) $related.='• [url=''.$ds[url3].'']'.$ds[link3].'[/url] ';

		if($ds[link4] && $ds[url4]!="http://" && $ds[window4]) $related.='• [url=''.$ds[url4].'']'.$ds[link4].'[/url] ';
		if($ds[link4] && $ds[url4]!="http://" && !$ds[window4]) $related.='• [url=''.$ds[url4].'']'.$ds[link4].'[/url] ';

	    eval ("\$news = \"".gettemplate("news")."\";");
	    echo $news;

		echo'
		     <input type="button" class="button" onClick="MM_goToURL(\'parent\',\'news.php?action=edit&newsID='.$newsID.'\');return document.MM_returnValue" value="edit news"> 
			 <input type="button" class="button" onClick="javascript:self.close()" value="save news"> 
			 <input type="button" class="button" onClick="MM_confirm(\'really delete this entry?\', \'news.php?action=delete&id=$newsID&close=true\')" value="cancel">';
}
elseif($_POST['quickactiontype']=="publish" OR $_GET['quickactiontype']=="publish") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  $newsID = $_POST['newsID'];

	if(is_array($newsID)) {
		foreach($newsID as $id) {
			safe_query("UPDATE ".PREFIX."news SET published='1' WHERE newsID='$id'");
		}
	}
	header("Location: index.php?site=news");
}
elseif($_POST['quickactiontype']=="unpublish" OR $_GET['quickactiontype']=="unpublish") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  $newsID = $_POST['newsID'];
  if(!$newsID) $newsID[] = $_GET['newsID'];

	foreach($newsID as $id) {
		safe_query("UPDATE ".PREFIX."news SET published='0' WHERE newsID='$id'");
	}
	header("Location: index.php?site=news");
}
elseif($_POST['quickactiontype']=="delete") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  $newsID = $_POST['newsID'];

	foreach($newsID as $id) {
    	$ds=mysql_fetch_array(safe_query("SELECT screens FROM ".PREFIX."news WHERE newsID='$id'"));
		if($ds[screens]) {
			$screens=explode("|", $ds[screens]);
			if(is_array($screens)) {
				$filepath = "./images/news-pics/";
				foreach($screens as $screen) {
					if(file_exists($filepath.$screen)) @unlink($filepath.$screen);
				}
			}
		}	
		safe_query("DELETE FROM ".PREFIX."news WHERE newsID='$id'");
		safe_query("DELETE FROM ".PREFIX."comments WHERE parentID='$id' AND type='ne'");
	}
	header("Location: index.php?site=news");
}
elseif($action=="delete") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');


  $id = $_GET['id'];

	$ds=mysql_fetch_array(safe_query("SELECT screens FROM ".PREFIX."news WHERE newsID='$id'"));
	if($ds[screens]) {
		$screens=explode("|", $ds[screens]);
		if(is_array($screens)) {
			$filepath = "./images/news-pics/";
			foreach($screens as $screen) {
				if(file_exists($filepath.$screen)) @unlink($filepath.$screen);
			}
		}
	}

	safe_query("DELETE FROM ".PREFIX."news WHERE newsID='$id'");
	safe_query("DELETE FROM ".PREFIX."comments WHERE parentID='$id' AND type='ne'");


	if($close) echo'<body onLoad="window.close()"></body>';
	else header("Location: index.php?site=news");
}
elseif($action=="edit") {
	include("_mysql.php");
	include("_settings.php");
	include("_functions.php");
	if(!isnewsadmin($userID)) die('No access.');

  $newsID = $_GET['newsID'];


	echo'<script src="js/bbcode.js" language="jscript" type="text/javascript"></script>
		 <link href="_stylesheet.css" rel="stylesheet" type="text/css">';

	$ds=mysql_fetch_array(safe_query("SELECT * FROM ".PREFIX."news WHERE newsID='$newsID'"));
	$lang=safe_query("SELECT lang, language FROM ".PREFIX."news_languages ORDER BY language");
	while($dl=mysql_fetch_array($lang)) {
	    if($dl[lang]==$ds[lang1]) $langs1.='<option value="'.$dl[lang].'" selected>'.$dl[language].'</option>';
		else $langs1.='<option value="'.$dl[lang].'">'.$dl[language].'</option>';

		if($dl[lang]==$ds[lang2]) $langs2.='<option value="'.$dl[lang].'" selected>'.$dl[language].'</option>';
		else $langs2.='<option value="'.$dl[lang].'">'.$dl[language].'</option>';
	}

	$headline1=getinput($ds[headline1]);
	$message=getinput($ds[content1]);
	$headline2=getinput($ds[headline2]);
	$content2=getinput($ds[content2]);

	$newsrubrics=safe_query("SELECT * FROM ".PREFIX."news_rubrics ORDER BY rubric");
    while($dr=mysql_fetch_array($newsrubrics)) {
	    if($ds[rubric]==$dr[rubricID]) $rubrics.='<option value="'.$dr[rubricID].'" selected>'.$dr[rubric].'</option>';
		else $rubrics.='<option value="'.$dr[rubricID].'">'.$dr[rubric].'</option>';
	}


  if($ds[intern]) $intern = '<option value="0">No</option><option value="1" selected>Yes</option>';
  else $intern = '<option value="0" selected>No</option><option value="1">Yes</option>';


	$link1=$ds[link1];
	$link2=$ds[link2];
	$link3=$ds[link3];
	$link4=$ds[link4];

	$url1="http://";
	$url2="http://";
	$url3="http://";
	$url4="http://";

	if($ds[url1]!="http://") $url1=$ds[url1];
	if($ds[url2]!="http://") $url2=$ds[url2];
	if($ds[url3]!="http://") $url3=$ds[url3];
	if($ds[url4]!="http://") $url4=$ds[url4];

	if($ds[window1]) $window1='<input class="input" name="window1" type="radio" value="1" checked> new window <input class="input" type="radio" name="window1" value="0"> _self';
	else $window1='<input class="input" name="window1" type="radio" value="1"> new window <input class="input" type="radio" name="window1" value="0" checked> _self';

	if($ds[window2]) $window2='<input class="input" name="window2" type="radio" value="1" checked> new window <input class="input" type="radio" name="window2" value="0"> _self';
	else $window2='<input class="input" name="window2" type="radio" value="1"> new window <input class="input" type="radio" name="window2" value="0" checked> _self';

	if($ds[window3]) $window3='<input class="input" name="window3" type="radio" value="1" checked> new window <input class="input" type="radio" name="window3" value="0"> _self';
	else $window3='<input class="input" name="window3" type="radio" value="1"> new window <input class="input" type="radio" name="window3" value="0" checked> _self';

	if($ds[window4]) $window4='<input class="input" name="window4" type="radio" value="1" checked> new window <input class="input" type="radio" name="window4" value="0"> _self';
	else $window4='<input class="input" name="window4" type="radio" value="1"> new window <input class="input" type="radio" name="window4" value="0" checked> _self';

	if($ds[picalign]=="left") $align='<input class="input" type="radio" name="align" value="left" checked> left 
	                                <input class="input" type="radio" name="align" value="right"> right';
	else $align='<input class="input" type="radio" name="align" value="left"> left 
	             <input class="input" type="radio" name="align" value="right" checked> right';

	$comments='<option value="0">Nein</option><option value="1">Nur User</option><option value="2">Ja</option>';								
	$comments=str_replace('value="'.$ds[comments].'"', 'value="'.$ds[comments].'" selected', $comments);

	$bg1=BG_1;

	eval ("\$addbbcode = \"".gettemplate("addbbcode")."\";");
	eval ("\$addflags = \"".gettemplate("flags")."\";");

	eval ("\$news_edit = \"".gettemplate("news_edit")."\";");
    echo $news_edit;
}
elseif($action=="unpublished") {
	eval ("\$title_news = \"".gettemplate("title_news")."\";");
	echo $title_news;


	if(isnewsadmin($userID)) $post='<input type="button" class="button" onClick="MM_openBrWindow(\'news.php?action=new\',\'News\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="News eintragen">';


	echo $post.' <input type="button" class="button" onClick="MM_goToURL(\'parent\',\'index.php?site=news\');return document.MM_returnValue" value="Zeige News">';

	// Not published News
	if(isnewsadmin($userID)) {
		$ergebnis=safe_query("SELECT * FROM ".PREFIX."news WHERE published='0' AND saved='1' ORDER BY date ASC");
		if(mysql_num_rows($ergebnis)) {
			echo'<h2>NOT PUBLISHED NEWS:</h2>';

			echo'<form method="post" name="form" action="news.php">';
			eval ("\$news_archive_head = \"".gettemplate("news_archive_head")."\";");
		    echo $news_archive_head;	   

			$i=1;
			while($ds=mysql_fetch_array($ergebnis)) {
				if($i%2) {
					$bg1=BG_1;
					$bg2=BG_2;
				}
				else {
					$bg1=BG_3;
					$bg2=BG_4;
				}

				$date=date("d.m.Y", $ds[date]);
				$rubric=getrubricname($ds[rubric]);
				$language1="[flag]".$ds[lang1]."[/flag]";
				$language2="[flag]".$ds[lang2]."[/flag]";

				if($ds[headline1]) {
				    $langs='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang1].'']'.flags($language1).'[/url]';
					$language=getlanguage($ds[lang1]);
					$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);
					$headline='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang1].'']'.$ds[headline1].'[/url]';
				}  
				if($ds[headline2]) {
				    $lang2=' [url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang2].'']'.flags($language2).'[/url]';
					$language=getlanguage($ds[lang2]);
					$lang2 = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$lang2);
					$langs.=$lang2;
					$headline.=' - [url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang2].'']'.$ds[headline2].'[/url]';
				}	


				$poster='[url='index.php?site=profile&id='.$ds[poster].'']'.getnickname($ds[poster]).'[/url]';


				$multiple='';
				$admdel='';
				if(isnewsadmin($userID)) {
					$multiple='<input class="input" type="checkbox" name="newsID[]" value="'.$ds[newsID].'">';
					$admdel='<table width="100%" border="0" cellspacing="0" cellpadding="4">
							<tr>
							<td><input class="input" type="checkbox" name="ALL" value="ALL" onClick="SelectAll(this.form);"> select all</td>
							    <td align="right"><select name="quickactiontype">
								<option value="publish">publish selected</option>
								<option value="delete">delete selected</option>
								</select> 
							<input type="submit" name="quickaction" value="go"></td>
							</tr>
							</table></form>';


				}
				eval ("\$news_archive_content = \"".gettemplate("news_archive_content")."\";");
		        echo $news_archive_content;
				$i++;
			}
			eval ("\$news_archive_foot = \"".gettemplate("news_archive_foot")."\";");
		    echo $news_archive_foot;


			unset($ds);
		}
	}
}
elseif($action=="archive") {
	eval ("\$title_news = \"".gettemplate("title_news")."\";");
	echo $title_news;

  $page=$_GET['page'];
  $sort=$_GET['sort'];
  $type=$_GET['type'];
	$post='';
	$publish='';
	if(isnewsadmin($userID)) {
		$post='<input type="button" class="button" onClick="MM_openBrWindow(\'news.php?action=new\',\'News\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="News posten">';
		$unpublished=safe_query("SELECT newsID FROM ".PREFIX."news WHERE published='0' AND saved='1'");
		$unpublished=mysql_num_rows($unpublished);
		if($unpublished) $publish='<input type="button" class="button" onClick="MM_goToURL(\'parent\',\'index.php?site=news&action=unpublished\');return document.MM_returnValue" value="'.$unpublished.' Nicht publizierte News"> ';
	}
	echo $post.' '.$publish.' <input type="button" class="button" onClick="MM_goToURL(\'parent\',\'index.php?site=news\');return document.MM_returnValue" value="Zeige News">';

	$all=safe_query("SELECT newsID FROM ".PREFIX."news WHERE published='1' AND intern<=".isclanmember($userID));
	$all=mysql_num_rows($all);
	$pages=1;
	if(!isset($page)) $page = 1;
	if(!isset($sort)) $sort = "date";
	if(!isset($type)) $type = "DESC";

	$max = empty($maxnewsarchiv) ? 20 : $maxnewsarchiv;



	for ($n=$max; $n<=$all; $n+=$max) {
	    if($all>$n) $pages++;
	}

	if($pages>1) $page_link = makepagelink("index.php?site=news&action=archive&sort=$sort&type=$type", $page, $pages);

	if ($page == "1") {
        $ergebnis = safe_query("SELECT * FROM ".PREFIX."news WHERE published='1' AND intern<=".isclanmember($userID)." ORDER BY $sort $type LIMIT 0,$max");
	    if($type=="DESC") $n=$gesamt;
		else $n=1;
	}
	else {
	    $start=$page*$max-$max;
	    $ergebnis = safe_query("SELECT * FROM ".PREFIX."news WHERE published='1' AND intern<=".isclanmember($userID)." ORDER BY $sort $type LIMIT $start,$max");
	    if($type=="DESC") $n = ($gesamt)-$page*$max+$max;
		else $n = ($gesamt+1)-$page*$max+$max;
	}
	if($all) {
	    if($type=="ASC") 
		        echo'[url='index.php?site=news&action=archive&page='.$page.'&sort='.$sort.'&type=DESC']Sort:[/url] [img]images/icons/asc.gif[/img]';
		    else 
		        echo'[url='index.php?site=news&action=archive&page='.$page.'&sort='.$sort.'&type=ASC']Sort:[/url] [img]images/icons/desc.gif[/img]';


		
		if($pages>1) echo $page_link;
		if(isnewsadmin($userID)) echo'<form method="post" name="form" action="news.php">';
		eval ("\$news_archive_head = \"".gettemplate("news_archive_head")."\";");
	    echo $news_archive_head;
		$i=1;
		while($ds=mysql_fetch_array($ergebnis)) {
			if($i%2) {
				$bg1=BG_1;
				$bg2=BG_2;
			}
			else {
				$bg1=BG_3;
				$bg2=BG_4;
			}

			$date=date("d.m.Y", $ds[date]);
			$rubric=getrubricname($ds[rubric]);
			$language1="[flag]".$ds[lang1]."[/flag]";
			$language2="[flag]".$ds[lang2]."[/flag]";

			$comms = getanzcomments($ds[newsID], 'ne');

			if($ds[headline1]) {
			    $langs='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang1].'']'.flags($language1).'[/url]';
				$language=getlanguage($ds[lang1]);
				$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);

				$headline='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang1].''][b]'.getinput($ds[headline1]).'[/b][/url]';
			}  
			if($ds[headline2]) {
			    $lang2=' [url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang2].'']'.flags($language2).'[/url]';
				$language=getlanguage($ds[lang2]);
				$lang2 = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$lang2);
				$langs.=$lang2;

				$headline.=' - [url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang2].''][b]'.getinput($ds[headline2]).'[/b][/url]';
			}	


			$poster='[url='index.php?site=profile&id='.$ds[poster].'']'.getnickname($ds[poster]).'[/url]';

			$multiple='';
			$admdel='';
			if(isnewsadmin($userID)) $multiple='<input class="input" type="checkbox" name="newsID[]" value="'.$ds[newsID].'">';

			eval ("\$news_archive_content = \"".gettemplate("news_archive_content")."\";");
	        echo $news_archive_content;
			$i++;
		}
		if(isnewsadmin($userID)) $admdel='<table width="100%" border="0" cellspacing="0" cellpadding="4">
							<tr>
							<td><input class="input" type="checkbox" name="ALL" value="ALL" onClick="SelectAll(this.form);"> select all</td>
							    <td align="right"><select name="quickactiontype">
								<option value="delete">markierte löschen</option>
								<option value="unpublish">nicht publizierte auswählen</option>
								</select> 
							<input type="submit" name="quickaction" value="go"></td>
							</tr>
							</table></form>';

		eval ("\$news_archive_foot = \"".gettemplate("news_archive_foot")."\";");
	    echo $news_archive_foot;
		unset($ds);

	}
	else echo'no entries';
}
else {
	eval ("\$title_news = \"".gettemplate("title_news")."\";");
	echo $title_news;


	$post='';
	$publish='';
	if(isnewsadmin($userID)) {
		$post='<input type="button" class="button" onClick="MM_openBrWindow(\'news.php?action=new\',\'News\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="News Posten">';
		$unpublished=safe_query("SELECT newsID FROM ".PREFIX."news WHERE published='0' AND saved='1'");
		$unpublished=mysql_num_rows($unpublished);
		if($unpublished) $publish='<input type="button" class="button" onClick="MM_goToURL(\'parent\',\'index.php?site=news&action=unpublished\');return document.MM_returnValue" value="'.$unpublished.' Nicht publizierte News"> ';
	}
	echo $post.' '.$publish.'';

	if($_GET['show']) {
   $result=safe_query("SELECT rubricID FROM ".PREFIX."news_rubrics WHERE rubric='".$_GET['show']."' LIMIT 0,1");
   $dv=mysql_fetch_array($result);
   $showonly = "AND rubric='".$dv[rubricID]."'";
  }


	$result=safe_query("SELECT * FROM ".PREFIX."news WHERE published='1' AND intern<=".isclanmember($userID)." $showonly ORDER BY date DESC LIMIT 0,$maxshownnews");
    $i=1;
	while($ds=mysql_fetch_array($result)) {
	    if($i%2) $bg1=BG_1;
		else $bg1=BG_2;

		$date = date("d.m.Y", $ds[date]);
		$time = date("H:i", $ds[date]);
		$rubrikname=getrubricname($ds[rubric]);
		$rubricpic_path = "images/news-rubrics/".getrubricpic($ds[rubric]);
		$rubricpic='[img]'.$rubricpic_path.'[/img]';
		echo $rubripic;
		if(!is_file($rubricpic_path)) $rubricpic='';

		$lang=$ds[lang1];
		$language1="[flag]".$ds[lang1]."[/flag]";
		$language2="[flag]".$ds[lang2]."[/flag]";

		if($lang==$ds[lang1]) {
		    if($ds[headline1]) $headline = $ds[headline1];
			else $headline = $ds[headline2];

			if($ds[content1]) $content = $ds[content1];
			else $content='[b]Keine Version in der gewünschten Sprache verfügbar![/b].[br][br]'.$ds[content2];

			if($ds[headline2]) {
			    $langs='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang2].'']'.flags($language2).'[/url]';
	            $language=getlanguage($ds[lang2]);
				$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);
			}	
			else $langs='';
		}
		else {
		    if($ds[headline2]) $headline = $ds[headline2];
			else $headline = $ds[headline1];

			if($ds[content2]) $content = $ds[content2];
			else $content='[b]Keine Version in der gewünschten Sprache verfügbar![/b].[br][br]'.$ds[content1];

			if($ds[headline1]) {
			    $langs='[url='index.php?site=news_comments&newsID='.$ds[newsID].'&lang='.$ds[lang1].'']'.flags($language1).'[/url]';
				$language=getlanguage($ds[lang1]);
				$langs = eregi_replace ('(alt=")(.*)(")',"\\1 news in $language\\3",$langs);
			}	
			else $langs='';
		}

		$content = htmloutput($content);
		$content = toggle($content, $ds[newsID]);		
		$poster='[url='index.php?site=profile&id='.$ds[poster].''][b]'.getnickname($ds[poster]).'[/b][/url]';
		if($ds[link1] && $ds[url1]!="http://" && $ds[window1]) $related.='• [url=''.$ds[url1].'']'.$ds[link1].'[/url] ';
		if($ds[link1] && $ds[url1]!="http://" && !$ds[window1]) $related.='• [url=''.$ds[url1].'']'.$ds[link1].'[/url] ';

		if($ds[link2] && $ds[url2]!="http://" && $ds[window2]) $related.='• [url=''.$ds[url2].'']'.$ds[link2].'[/url] ';
		if($ds[link2] && $ds[url2]!="http://" && !$ds[window2]) $related.='• [url=''.$ds[url2].'']'.$ds[link2].'[/url] ';

		if($ds[link3] && $ds[url3]!="http://" && $ds[window3]) $related.='• [url=''.$ds[url3].'']'.$ds[link3].'[/url] ';
		if($ds[link3] && $ds[url3]!="http://" && !$ds[window3]) $related.='• [url=''.$ds[url3].'']'.$ds[link3].'[/url] ';

		if($ds[link4] && $ds[url4]!="http://" && $ds[window4]) $related.='• [url=''.$ds[url4].'']'.$ds[link4].'[/url] ';
		if($ds[link4] && $ds[url4]!="http://" && !$ds[window4]) $related.='• [url=''.$ds[url4].'']'.$ds[link4].'[/url] ';

		if(empty($related)) $related="kein link verfügbar"; 

		if($ds[comments]) {
			if($ds[cwID]) {  // CLANWAR-NEWS
				$anzcomments = getanzcomments($ds[cwID], 'cw');
				if($anzcomments) $comments='[url='index.php?site=clanwars_details&cwID='.$ds[cwID].'']['.$anzcomments.'] comments[/url] latest by '.getlastcommentposter($ds[cwID], 'cw').' - '.date("d.m.Y - H:i", getlastcommentdate($ds[cwID], 'cw'));
				else $comments='[url='index.php?site=clanwars_details&cwID='.$ds[cwID].''][0] comments[/url]';
			}
			else {
				$anzcomments = getanzcomments($ds[newsID], 'ne');
				if($anzcomments) $comments='[url='index.php?site=news_comments&newsID='.$ds[newsID].'']Kommentare ('.$anzcomments.')[/url]';
				else $comments='[url='index.php?site=news_comments&newsID='.$ds[newsID].'']Kommentare (0)[/url]';
			}
		}
		else $comments='';	

		if(isnewsadmin($userID)) $adminaction='<input type="button" class="button" onClick="MM_goToURL(\'parent\',\'news.php?quickactiontype=unpublish&newsID='.$ds[newsID].'\');return document.MM_returnValue" value="unpublish">
																					 <input type="button" class="button" onClick="MM_openBrWindow(\'news.php?action=edit&newsID='.$ds[newsID].'\',\'News\',\'toolbar=no,status=no,scrollbars=yes,width=800,height=600\')" value="bearbeiten"> 
		                                       <input type="button" class="button" onClick="MM_confirm(\'really delete this entry?\', \'news.php?action=delete&id='.$ds[newsID].'\')" value="löschen">';
		else $adminaction='';


		eval ("\$news = \"".gettemplate("news")."\";");
	    echo $news;


		$i++;

		unset($related);
		unset($comments);
		unset($lang);
		unset($ds);
	}
}


?>

Alles anzeigen

phpfan

Ich präzisiere mal die Antwort von K.Y.L.T. : da musst du uns zuerst den relevanten Code deiner PHP verraten.

Oder glaubst du wirklich, dass sich jemand durch diese über 600 Zeilen lange, unformatierte Buchstabenwüste kämpft?

PHPDummy

brauchte ich auch vor einigen Tagen...

bei mir sollten die 5 aktuellsten Ereignisse beginnend ab dem aktuellen Datum angezeigt werden :

mit folgendem Code habe ich das erreicht

Code

$abfrage = "SELECT * FROM tabelle WHERE datum > now() ORDER by datum LIMIT 5

Hoffe das hilft dir ein wenig weiter...

Gruß PHPDummy

mymaddin

Nein ich meine es glaube ich anders.

Es Sollen zwei News angezeigt werden und dann die dritte soll aufeine neue Seite Also 2 stehn usw.

gelöschter User

Hier hast du ein Beispiel wie mann sowas macht!
Am besten du machst dir mal ne test.php und dann testest du es mal aus.

PHP

<?php
// Mysql Daten
C$dbHost = "127.0.0.1";
$dbUser = "root";
$dbPass = "";
$dbName = "test";


$connect = mysql_connect($dbHost, $dbUser, $dbPass) or die("Keine Verbindung zum Datenbankserver!");
mysql_select_db($dbName);




// Angabe von wo aus die News angezeigt werden
$do = mysql_query("SELECT COUNT(*) as anzahl FROM news");
$count = mysql_result($do,0);
if($_REQUEST['id'] == "" || $_REQUEST['id'] < 0) 
{
  $sid = 0;
}
else
{
  $sid = $_REQUEST['id'];
  if($count-1 <= $sid) $sid = $count-1;
}


  
// Hole News
$do = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT $sid,2");
while($f = mysql_fetch_array($do))
{
  // Anzeige der News
  echo $f['name']." schrieb:
".$f['text']."


";
}


// Vor und Zurück
echo '
'.$n.'


[url=''.$_SERVER['PHP_SELF'].'?id='.($sid+1).'']Vor[/url]


[url=''.$_SERVER['PHP_SELF'].'?id='.($sid-1).'']Zurück[/url]';


?>

Alles anzeigen

Hier hast auch meine Test MySQL Tabelle:

Code

CREATE TABLE `news` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;


#
# Daten für Tabelle `news`
#


INSERT INTO `news` VALUES (1, '1', '1');
INSERT INTO `news` VALUES (2, '2', '2');
INSERT INTO `news` VALUES (3, '3', '3');
INSERT INTO `news` VALUES (4, '4', '4');
INSERT INTO `news` VALUES (5, '5', '5');
INSERT INTO `news` VALUES (6, '6', '6');
INSERT INTO `news` VALUES (7, '7', '7');
INSERT INTO `news` VALUES (8, '8', '8');
INSERT INTO `news` VALUES (9, '9', '9');
INSERT INTO `news` VALUES (10, '10', '10');

Alles anzeigen

Gruß crAzywuLf

mymaddin

Ich hatte das schonmal......

Dann habe ich nur einen bestimmten Code in die news.php eingefügt.

Sorry für die Blödheit.....

Tags