phpBB.de

Code: Alles auswählen

  <td class="row1" width="100%" {C_ONMOUSEOVER}="this.style.backgroundColor='{C_ROW1_OVER}';" {C_ONMOUSEOUT}="this.style.backgroundColor='{C_ROW1}';" {C_ONCLICK}="window.location.href='{catrow.forumrow.U_VIEWFORUM}'"><span class="forumlink"> <a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><br /> 

Code: Alles auswählen

default:
			$sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
				FROM (( " . FORUMS_TABLE . " f
				LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id )
				ORDER BY f.cat_id, f.forum_order";
			break;
	}
	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not query forums information', '', __LINE__, __FILE__, $sql);
	}

	$forum_data = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$forum_data[] = $row;
	}

	if ( !($total_forums = count($forum_data)) )
	{
		message_die(GENERAL_MESSAGE, $lang['No_forums']);
	}

	//
	// Obtain a list of topic ids which contain

Code: Alles auswählen

#
#-----[ OPEN ]----------------------[phpBB 2.0.5]--------------------------
#

Code: Alles auswählen

if ( $forum_data[$j]['forum_last_post_id'] ) 

Code: Alles auswählen

else
							{
								$last_post = $lang['No_Posts'];
							}

Code: Alles auswählen

############################################################## 
## Mod Title:   Last post topic on index 
## Original Mod Title: shows topic of last made post on index 
## Mod Version: 1.0.0 
## Author:      MandersOnline <mods@mandersonline.nl> 
##         http://www.mandersonline.nl/mods 
## Author Original:   e-sven <sven@e-sven.net> 
##         http://www.e-sven.net 
## Description: -adds lasts post topic to each forum on 
##               the index page (based on read-access) 
##      -word censorship is used 
##      -topic title with more then 27 chars are cut off 
##      -mouseover info displays the full title 
## 
## Installation Level:  easy 
## Installation Time:   2-5 Minutes 
## Files To Edit:       index.php 
## Included Files:      index.php (pre-modded) 
############################################################## 
## History: 
##         1.0 Release for phpBB 2.0.10 
############################################################## 
## Before Adding This MOD To Your Forum, 
## You Should Back Up All Files Related To This MOD 
############################################################## 

....mach mal erst was anderes....

# 
#-----[ ACTION Find ]----------------------------------------- 
# 
   if ( $forum_data[$j]['forum_last_post_id'] ) 
   { 
   ... 
   } 


# 
#-----[ ACTION Replace With ]--------------------------------- 
# 
   if ( $forum_data[$j]['forum_last_post_id'] ) 
   { 
      $topic_title = $forum_data[$j]['topic_title']; 
      $topic_title2 = $forum_data[$j]['topic_title']; 
       
      // 
      // Censor topic title 
      // 
      if ( count($orig_word) ) 
      { 
         $topic_title = preg_replace($orig_word, $replacement_word, $topic_title); 
         $topic_title2 = preg_replace($orig_word, $replacement_word, $topic_title2); 
      } 
                               
      if (strlen($topic_title)>27) { 
         $topic_title = substr($topic_title,0,24) . '...'; 
      } 

      $last_post_time = create_date($board_config['default_dateformat'], $forum_data[$j]['post_time'], $board_config['board_timezone']); 
      $last_post = '<a href="' . append_sid("viewtopic.$phpEx?"  . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '" title="' . $topic_title2 . '">' . $topic_title . '</a><br>'; 
      $last_post .= $last_post_time . '&nbsp;<a href="' . append_sid("viewtopic.$phpEx?"  . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '"></a><br>' . $lang['by'] . '&nbsp;'; 
      $last_post .= ( $forum_data[$j]['user_id'] == ANONYMOUS ) ? ( ($forum_data[$j]['post_username'] != '' ) ? $forum_data[$j]['post_username'] . ' ' : $lang['Guest'] . ' ' ) : '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . '='  . $forum_data[$j]['user_id']) . '">' . $forum_data[$j]['username'] . '</a> '; 
   } 

# 
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------- 
#