ilch.de :: Forum :: Ilch Clan 1.1 :: Fehlersuche und Probleme

das was ich verändert habe...

showpost.htm

<style type="text/css">
<!--
.Stil2 {color: #000000}
.Stil6 {font-size: 10px}
-->
</style>
<br />


<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="60%">{SITELINK}</td>
    <td width="40%" align="right">{ANTWORTEN}</td>
  </tr>
</table>
<table width="100%" border="0" cellspacing="1" cellpadding="2" class="border">
  <tr class="Chead"> 
    <th colspan="2" height="25"><b>{TOPICNAME}</b></td>
  </tr>
	{EXPLODE}  <tr class="{class}">
    <td width="20%" valign="top" nowrap bgcolor="#F7D85E"><p><a name="{id}"></a>{erst} <span class="Stil6">PM schreiben </span></p>
      <p align="left"><strong>{Hauptklasse}</strong><font class="smalfont"></font><br />
        <font class="smalfont">{avatar}</font><font class="smalfont"><br>
        </font></p>      </td>
    <td height="0" rowspan="2" valign="top"><p align="right" class="Stil2">{date} </p>
    <p class="Stil2">{txt} </p>
    <p class="Stil2">{sig}</p></td>
  </tr>
	<tr class="{class}">
	  <td valign="top" bgcolor="#F7D85E"><div align="center">
	    <p><font class="smalfont">{reng} </font><font class="smalfont"><em><strong>{Forumtitel}</strong></em></font><font class="smalfont">{rang}</font><font class="smalfont">{posts}</font></p>
      </div></td>
  </tr>
	<tr class="{class}">
	  <td width="20%" valign="top" bgcolor="#F7D85E"><p><font class="smalfont">{details}</font></p>      </td>
	  <td height="-1" valign="top"><div align="right"><span class="Stil2">{delete} &nbsp; {change} &nbsp; <a href="index.php?forum-newpost-{TID}-z{id}">{_lang_quote}</a></span></div></td>
  </tr>
  <tr class="{class}">
    <td width="20%" valign="top" nowrap bgcolor="#F7D85E">&nbsp;</td>
    <td height="0" valign="bottom"><a href="index.php?forum-inform-p{id}">Diesen Beitrag melden</a> </td>
  </tr>
  <tr> 
    <td colspan="2" class="Cdark" height="10"></td>
  </tr>
	{EXPLODE}
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td width="60%">{SITELINK}</td>
    <td width="40%" align="right">{ANTWORTEN}</td>
  </tr>
</table>
{EXPLODE}
<br />
<strong>{_lang_administrattopic}</strong><br />
<a href="javascript:renametopic()">{_lang_rename}</a>
&nbsp;,&nbsp;
<a href="index.php?forum-edittopic-{tid}-2">{_lang_delete}</a>
&nbsp;,&nbsp;
<a href="index.php?forum-edittopic-{tid}-3">{_lang_shift}</a>
&nbsp;,&nbsp;
<a href="index.php?forum-edittopic-{tid}-4-2">{status}</a>
&nbsp;,&nbsp;
<a href="index.php?forum-edittopic-{tid}-5">{festnorm}</a>

<script language="JavaScript" type="text/javascript">
<!--
  function renametopic () {
	  var x = prompt ( "Bitte den neuen Namen vom Thema eintragen" , "" );
		if ( x ) {
		  document.location.href="index.php?forum-edittopic-{tid}-1=0&newTopic="+x;
		}
	}
	
//-->
</script>

showpost.php

<?php 
#   Copyright by: Manuel
#   Support: www.ilch.de


defined ('main') or die ( 'no direct access' );



# check ob ein fehler aufgetreten ist.
check_forum_failure($forum_failure);

# toipc als gelesen markieren
$_SESSION['forumSEE'][$fid][$tid] = time();

$title = $allgAr['title'].' :: Forum :: '.$aktTopicRow['name'].' :: Beitr&auml;ge zeigen';
$hmenu  = $extented_forum_menu.'<a class="smalheaderfont" href="index.php?forum">Forum</a><b> &raquo; </b><a class="smalheaderfont" href="index.php?forum-showcat-'.$aktForumRow['cid'].'">'.$aktForumRow['kat'].'</a><b> &raquo; </b><a class="smalheaderfont" href="index.php?forum-showtopics-'.$fid.'">'.$aktForumRow['name'].'</a><b> &raquo; </b>';
$hmenu .= $aktTopicRow['name'].$extented_forum_menu_sufix;
$design = new design ( $title , $hmenu, 1, 'forum/index.htm' );
$design->header();


# Topic Hits werden eins hochgesetzt.
db_query('UPDATE `prefix_topics` SET hit = hit + 1 WHERE id = "'.$tid.'"');

# mehrere seiten fals gefordert	 
$limit = $allgAr['Fpanz'];  // Limit 
$page = ($menu->getA(3) == 'p' ? $menu->getE(3) : 1 );
$MPL = db_make_sites ($page , "WHERE tid = ".$tid , $limit , 'index.php?forum-showposts-'.$tid , 'posts' );
$anfang = ($page - 1) * $limit;

$antworten = '';
if ($aktTopicRow['stat'] == 1 AND $forum_rights['reply'] == TRUE ) {
  $antworten = '<b>[ <a href="index.php?forum-newpost-'.$tid.'">'.$lang['answer'].'</a> ]</b>';
}

$class = 'Cmite';

$tpl = new tpl ( 'forum/showpost' );
$ar = array (
  'SITELINK' => $MPL,
  'tid' => $tid,
	'ANTWORTEN' => $antworten,
	'TOPICNAME' => $aktTopicRow['name']
);
$tpl->set_ar_out($ar,0);
$i = $anfang +1;
$erg = db_query("SELECT prefix_posts.id,txt,time,erstid,erst,sig,avatar,posts FROM `prefix_posts` LEFT JOIN prefix_user ON prefix_posts.erstid = prefix_user.id WHERE tid = ".$tid." ORDER BY time LIMIT ".$anfang.",".$limit);
while($row = db_fetch_assoc($erg)) {
  
	$class = ( $class == 'Cnorm' ? 'Cmite' : 'Cnorm' );
	
	# define some vars.
	$row['sig'] = ( empty($row['sig']) ? '' : '<br /><hr style="width: 50%;" align="left">'.bbcode($row['sig']) );
	//$row['Hauptklasse'] = ( empty($row['Hauptklasse']) ? '' : '<br /><hr style="width: 50%;" align="left">'.bbcode($row['Hauptklasse']) );
	$row['TID'] = $tid;
	$row['class'] = $class;
	$row['date'] = date ('d.m.Y - H:i:s', $row['time'] );
        $row['delete'] = '';
	$row['change'] = '';
        $row['avatar'] = (file_exists($row['avatar'])?'<br /><img src="'.$row['avatar'].'" alt="User Pic" border="0" /><br />':'');
        $row['reng']   = userrang ($row['posts'],$row['erstid']);
        $row['erst'] .= "<br><br><a href='index.php?forum-privmsg-new&empfid=".$row['erstid']."'><img src='include/images/icons/privmsg.gif' border='0' alt='Private Nachricht an den User senden'></a>";		
        $row['posts']  = ($row['posts']?'<br />Posts: '.$row['posts']:'');
	$row['txt']    = (isset($_GET['such']) ? markword(bbcode ($row['txt']),$_GET['such']) : bbcode ($row['txt']) );
	$row['i']      = $i;
        $row['page']   = $page;
  
	if ( $row['erstid'] != '' ) {
		  $user_row = db_fetch_assoc(db_query("SELECT posts,regist FROM prefix_user WHERE id = ".$row['erstid']));
		$row['erst'] = '<a href="index.php?user-details-'.$row['erstid'].'"><b>'.$row['erst'].'</b></a>';
		$posts = $user_row['posts'];
	$row['posts'] = '<br />Posts: '.$user_row['posts'];
		
		if ( $posts == '' ) { $row['posts'] = '<br>Nicht registriert';}
		
		//Forumex - begin
    $row['txt'] = FE_Vote2HTML($row['id'],$row['txt']);
    //Forumex - end
		
		#Ranking Balken
		#Grafiken definieren
		//$rand_l = '<img src="include/images/icons/ranking/rank_left.jpg" width="8" height="17" alt="" border="0">';
		//$rand_r = '<img src="include/images/icons/ranking/rank_right.jpg" width="8" height="17" alt="" border="0">';
		//$rank_grey = '<img src="include/images/icons/ranking/rank_grey.jpg" width="8" height="17" alt="" border="0">';
		$rank_01 = '<img src="include/images/icons/ranking/schildgrau.gif" width="72" height="62" alt="" border="0">';
		$rank_02 = '<img src="include/images/icons/ranking/schild.gif" width="72" height="62" alt="" border="0">';
		$rank_03 = '<img src="include/images/icons/ranking/schildl.gif" width="72" height="62" alt="" border="0">';
		$rank_04 = '<img src="include/images/icons/ranking/schildlr.gif" width="72" height="62" alt="" border="0">';
		//$rank_05 = '<img src="include/images/icons/ranking/fschild.gif" width="72" height="70" alt="" border="0">';
		$rank_05 = '<img src="include/images/icons/ranking/fschildl.gif" width="72" height="70" alt="" border="0">';
		$rank_06 = '<img src="include/images/icons/ranking/fschildlr.gif" width="72" height="65" alt="" border="0">';
		$rank_07 = '<img src="include/images/icons/ranking/fschildlmr.gif" width="72" height="65" alt="" border="0">';
		//$rank_08 = '<img src="include/images/icons/ranking/nschild.gif" width="72" height="65" alt="" border="0">';
		$rank_08 = '<img src="include/images/icons/ranking/nschildl.gif" width="72" height="65" alt="" border="0">';
		$rank_09 = '<img src="include/images/icons/ranking/nschildlr.gif" width="72" height="65" alt="" border="0">';
		$rank_10 = '<img src="include/images/icons/ranking/nschildlmr.gif" width="72" height="90" alt="" border="0">';
		
		
		
		
		
		
		//$rank_05 = '<img src="include/images/icons/ranking/rank_05.jpg" width="8" height="17" alt="" border="0">';
		//$rank_06 = '<img src="include/images/icons/ranking/rank_06.jpg" width="8" height="17" alt="" border="0">';
		//$rank_07 = '<img src="include/images/icons/ranking/rank_07.jpg" width="8" height="17" alt="" border="0">';
		//$rank_08 = '<img src="include/images/icons/ranking/rank_08.jpg" width="8" height="17" alt="" border="0">';
		//$rank_09 = '<img src="include/images/icons/ranking/rank_09.jpg" width="8" height="17" alt="" border="0">';
		//$rank_10 = '<img src="include/images/icons/ranking/rank_10.jpg" width="8" height="17" alt="" border="0">';
		
		#Bezugnehmen auf das Ranking des users
		if ( $posts != '' ) {
		$row['rang'] = '<br>';
		
        if ($user_row['posts'] <= '100') { $row['rang'] .= $rank_01; }
		elseif ($user_row['posts'] <= '200') { $row['rang'] .= $rank_02; }
		elseif ($user_row['posts'] <= '300') { $row['rang'] .= $rank_03; }
		elseif ($user_row['posts'] <= '400') { $row['rang'] .= $rank_04; }
		elseif ($user_row['posts'] <= '500') { $row['rang'] .= $rank_05; }
		elseif ($user_row['posts'] <= '600') { $row['rang'] .= $rank_06; }
		elseif ($user_row['posts'] <= '700') { $row['rang'] .= $rank_07; }
		elseif ($user_row['posts'] <= '800') { $row['rang'] .= $rank_08; }
		elseif ($user_row['posts'] <= '900') { $row['rang'] .= $rank_09; }
		elseif ($user_row['posts'] <= '1000') { $row['rang'] .= $rank_10; }
		}
		
		else {$row['rang'] .= ""; }
		
		#Wenn der User registriert ist wird folgendes ausgelesen
		if ( $posts != '' ) {
		
		#Male or Female		
		$abf1 = "SELECT * FROM prefix_userfields where uid = ".$row['erstid']." and fid = 9";
		$erg1 = db_query($abf1);
		$gender = db_fetch_object($erg1);

		if ($gender->val == "männlich" ){
		$row['erst'] .= '&nbsp;<img src="include/images/icons/male.gif" border="0">';
		}
		elseif ($gender->val == "weiblich" ){
		$row['erst'] .= '&nbsp;<img src="include/images/icons/female.gif" border="0">';
		}
		
		#Messenger Daten werden ausgelesen		
		$abf1 = "SELECT * FROM prefix_userfields where uid = ".$row['erstid']." and fid = 7";
		$erg1 = db_query($abf1);
		$icqnr = db_fetch_object($erg1);

		if (is_numeric($icqnr->val) ){
		$row['erst'] .= '&nbsp;<a href="http://www.icq.com/whitepages/cmd.php?uin='.$icqnr->val.'&action=add"><img src="include/images/icons/icqblume.gif" alt="User in ICQ Liste hinzufuegen" border="0"></a>';
		}
		
		#Website des Users
		$abf1 = "SELECT * FROM prefix_userfields where uid = ".$row['erstid']." and fid = 4";
		$erg1 = db_query($abf1);
		$uwebsite = db_fetch_object($erg1);

		if ($uwebsite->val <> "" ){
		$row['erst'] .= '&nbsp;<a href="'.$uwebsite->val.'" target="_blank"><img src="include/images/icons/uwebsite.gif" border="0" alt="Website des Users besuchen"></a>';
		}
		
		}
		
		#User Details
		if ( $posts != '' ) {
		$abf1 = 'SELECT * FROM prefix_user where id = '.$row["erstid"];
		$erg1 = db_query($abf1);
		$user = db_fetch_object($erg1);
		$bf1 = "SELECT * FROM prefix_userfields where uid = ".$row['erstid']." and fid = 1";
		$rg1 = db_query($bf1);
		$userfield = db_fetch_object($rg1);
		
		$zeit = date('d. M Y',$user->regist);
		
		$row['details'] = "<br><br>Dabei seit: ".$zeit."<br>";
		if ($userfield->val != '') {
		$row['details'] .= "Kommt aus: ".$userfield->val."<br>";
		}
		
		}
		else {
		$row['details'] = "";}
		
		#
		#Edit Ende
		##################################

		# profilefields
		$sig = @db_result(db_query("SELECT val FROM prefix_userfields WHERE uid = ".$row['erstid']." AND fid = 5"),0);
		if (!empty($sig)) { $row['sig'] = '<br /><hr size="1" width="100" align="left">'.bbcode($sig); }
		
		$avatar = @db_result(db_query("SELECT val FROM prefix_userfields WHERE uid = ".$row['erstid']." AND fid = 6"),0);
		if (!empty($avatar)) { $row['avatar'] = '<br /><br /><img src="'.$avatar.'" alt="User Pic" border="0" /><br />'; }
		
		$Hauptklasse = Hauptklasse2;
		$Hauptklasse2 = str_replace('Moench', 'Mönch', $Hauptklasse);
		$Hauptklasse = @db_result(db_query("SELECT Hauptklasse FROM prefix_user WHERE id = ".$row['erstid']),0);
		if (!empty($Hauptklasse)) { $row['Hauptklasse'] = '<br /><hr size="1" width="100" align="left">'.bbcode($Hauptklasse); }
		else {$row['Hauptklasse']="";}
		
		//$Forumtitel;
		$Forumtitel= @db_result(db_query("SELECT Forumtitel FROM prefix_user WHERE id = ".$row['erstid']),0);
		$posts = @db_result(db_query("SELECT posts FROM prefix_user WHERE id = ".$row['erstid']),0);
		if ($posts >= 1000) { $row['Forumtitel'] = '<br /><hr size="1" width="100" align="left">'.bbcode($Forumtitel); }
		else {$row['Forumtitel']="";}
		
	}
	
	
         if(empty($points)){
	$points=0;
	}
	$rang=$posts+$points;
	//$row['rang'] = rangbildforum ($rang);
	if ($forum_rights['mods'] == TRUE AND $i>1) {
	  $row['delete'] = '<a href="index.php?forum-delpost-'.$tid.'-'.$row['id'].'">'.$lang['delete'].'</a>';
	}
	if ( $forum_rights['reply'] == TRUE AND loggedin() ) {
	  $row['change'] = '&nbsp;<a href="index.php?forum-editpost-'.$tid.'-'.$row['id'].'">'.$lang['change'].'</a>';
	}
	
	//Forumex - begin
    $row['txt'] = FE_Vote2HTML($row['id'],$row['txt']);
    //Forumex - end
	
	$tpl->set_ar_out($row,1);
  
  $i++;
}

$tpl->set_ar_out( array ( 'SITELINK' => $MPL, 'ANTWORTEN' => $antworten ) , 2 );

if (loggedin()) {
  if ($menu->get(3) == 'topicalert') {
    if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) {
      db_query("DELETE FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid);
    } else {
      db_query("INSERT INTO prefix_topic_alerts (tid,uid) VALUES (".$tid.", ".$_SESSION['authid'].")");
    }
  }
  
  echo 'Optionen:';
  if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_topic_alerts WHERE uid = ".$_SESSION['authid']." AND tid = ".$tid),0)) {
    echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['nomailonreply'].'</a><br />';
  } else {
    echo '<br />- <a href="index.php?forum-showposts-'.$tid.'-topicalert">'.$lang['mailonreply'].'</a><br />';
  }
}

if ( $forum_rights['mods'] == TRUE ) {
  $tpl->set ( 'status', ($aktTopicRow['stat'] == 1 ? $lang['close'] : $lang['open'] ) );
	$tpl->set ( 'festnorm', ($aktTopicRow['art'] == 0 ? $lang['fixedtopic'] : $lang['normaltopic'] ) );
	$tpl->set('tid',$tid);
	$tpl->out(3);
}
$design->footer();
?>

eigentlich werden nur noch zuätzliche db felder abgerufen

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Forum problem