phpBB.de

Code: Alles auswählen

#
#-----[ OPEN ]----------------------------------------------
#

viewforum.php

#-----[ FIND ]----------------------------------------------
#

    AND t.topic_type <> " . POST_ANNOUNCE . "

#
#-----[ REPLACE WITH ]----------------------------------------------
#

    AND t.topic_type = " . POST_STICKY . " 

#-----[ FIND ]----------------------------------------------
#

  $total_topics++;
}

$db->sql_freeresult($result);

#
#-----[ AFTER, ADD ]----------------------------------------------
#

// BEGIN Advanced Topic Type MOD

//
// All topic types added
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
  FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
  WHERE t.forum_id = $forum_id
  AND t.topic_poster = u.user_id
  AND p.post_id = t.topic_first_post_id
  AND p2.post_id = t.topic_last_post_id
  AND u2.user_id = p2.poster_id 
  AND t.topic_type > " . POST_GLOBAL_ANNOUNCE . " 
  AND t.topic_type_active = 1
  $limit_topics_time
  ORDER BY t.topic_type DESC, t.topic_last_post_id DESC 
  LIMIT $start, ".$board_config['topics_per_page'];

if ( !($result = $db->sql_query($sql)) )
{
  message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}

$total_add_types = 0;
while( $row = $db->sql_fetchrow($result) )
{
  $topic_rowset[] = $row;
  $total_add_types++;
}

$db->sql_freeresult($result);

//
// All normal posts and inactive topic types
//
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
  FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
  WHERE t.forum_id = $forum_id
  AND t.topic_poster = u.user_id
  AND p.post_id = t.topic_first_post_id
  AND p2.post_id = t.topic_last_post_id
  AND u2.user_id = p2.poster_id 
  AND ( (t.topic_type > ". POST_GLOBAL_ANNOUNCE ." AND t.topic_type_active = 0 ) OR t.topic_type = " . POST_NORMAL . " )
  $limit_topics_time
  ORDER BY t.topic_last_post_id DESC 
  LIMIT $start, ".$board_config['topics_per_page'];

if ( !($result = $db->sql_query($sql)) )
{
  message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}

$total_non_active = 0;
while( $row = $db->sql_fetchrow($result) )
{
  $topic_rowset[] = $row;
  $total_non_active++;
}

$db->sql_freeresult($result);
// END Advanced Topic Type MOD

#-----[ FIND ]----------------------------------------------
#

$total_topics += $total_announcements;

#
#-----[ AFTER, ADD ]----------------------------------------------
#

// BEGIN Advanced Topic Type MOD
$total_topics += $total_add_types;
$total_topics += $total_non_active;
// END Advanced Topic Type MOD

#-----[ FIND ]----------------------------------------------
#

//
// Okay, lets dump out the page ...
//

#
#-----[ AFTER, ADD ]----------------------------------------------
#

// BEGIN Advanced Topic Type MOD
$sql = "SELECT t.*, t1.topic_type_color AS announce_color, t2.topic_type_color AS sticky_color
  FROM ". TOPIC_ADD_TYPE_TABLE ." t,". TOPIC_ADD_TYPE_TABLE ." t1, ". TOPIC_ADD_TYPE_TABLE ." t2
  WHERE t1.topic_type_name = 'announce'
  AND t2.topic_type_name = 'sticky'";
  
if ( !($result = $db->sql_query($sql)) )
{
  message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
}
while ($tt_row = $db->sql_fetchrow($result))
{
  $row[] = $tt_row;
  $announce_color = '#'.$tt_row['announce_color'];
  $sticky_color = '#'.$tt_row['sticky_color'];
}
// END Advanced Topic Type MOD

#-----[ FIND ]----------------------------------------------
#

    if( $topic_type == POST_ANNOUNCE )
    {
      $topic_type = $lang['Topic_Announcement'] . ' ';
    }
    else if( $topic_type == POST_STICKY )
    {
      $topic_type = $lang['Topic_Sticky'] . ' ';
    }

#
#-----[ REPLACE WITH ]----------------------------------------------
#

    // BEGIN Advanced Topic Type MOD
    if( $topic_type == POST_ANNOUNCE )
    {
      $topic_type = '<span style="color:'. $announce_color .'">'. $lang['Topic_Announcement'] . ' </span>';
    }
    else if( $topic_type == POST_STICKY )
    {
      $topic_type = '<span style="color:'. $sticky_color .'">'. $lang['Topic_Sticky'] . ' </span>';
    }
    else if( $topic_type > POST_GLOBAL_ANNOUNCE )
    {
      for($j = 0; $j < count($row); $j++ )
      {
        if( intval($topic_rowset[$i]['topic_type'] - POST_ADD_TYPE) == $row[$j]['topic_type_order'] )
        {
          $topic_type = '<span style="color:#'. $row[$j]['topic_type_color'] .'">'. $row[$j]['topic_type_name'] .':</span> ';      
        }
      }  
    }
    // END Advanced Topic Type MOD

#-----[ FIND ]----------------------------------------------
#

      if( $topic_rowset[$i]['topic_type'] == POST_ANNOUNCE )
      {
        $folder = $images['folder_announce'];
        $folder_new = $images['folder_announce_new'];
      }

#
#-----[ AFTER, ADD ]----------------------------------------------
#

      // BEGIN Advanced Topic Type MOD
      else if( $topic_rowset[$i]['topic_type'] > POST_ADD_TYPE )
      {
        if( $row[$i]['topic_type_image'] != '' )
        {
          $folder = $row[$i]['topic_type_image'];
          $folder_new = $row[$i]['topic_type_image_new'];
        }
        else
        {  
          $folder = $images['folder_topic_type'];
	  $folder_new = $images['folder_topic_type_new'];
        }
      }
      // END Advanced Topic Type MOD