phpBB.de

Code: Alles auswählen

$search_limit = 0;
 
$forum_id = array(37,22);
$forum_id_where = create_where_clauses($forum_id, 'forum');
 
$topic_id = array(20, 50);
$topic_id_where = create_where_clauses($topic_id, 'topic');

$topics = 'SELECT * FROM ' . TOPICS_TABLE . '
         ' . $forum_id_where . '
         AND topic_status <> ' . ITEM_MOVED . '
         AND topic_approved = 1
         ORDER BY topic_id DESC';
 
$topics_result = $db->sql_query_limit($topics, $search_limit);
 
   while( $topics_row = $db->sql_fetchrow($topics_result) )
   {
      $topic_title       = censor_text($topics_row['topic_title']);
      $topic_cal       = censor_text($topics_row['topic_title']);
      $topic_author       = get_username_string('full', $topics_row['topic_poster'], $topics_row['topic_first_poster_name'], $topics_row['topic_first_poster_colour']);
      $topic_date       = $user->format_date($topics_row['topic_time']);
      $topic_last_post    = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topics_row['forum_id'] . '&t=' . $topics_row['topic_id'] . '&p=' . $topics_row['topic_last_post_id']) . '#p' . $topics_row['topic_last_post_id'];
      $topic_last_author    = get_username_string('full', $topics_row['topic_last_poster_id'], $topics_row['topic_last_poster_name'], $topics_row['topic_last_poster_colour']);
      $topic_link       = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $topics_row['forum_id'] . '&t=' . $topics_row['topic_id']);
                             
////////////////////////////hier wird aussortiert///////////////////
       $topic_cal =  substr($topic_cal, 0, 10); 
       $topic_cal=str_replace(".","",$topic_cal);  
           if (is_numeric($topic_cal))
      {  
////////////////////////////hier wird aussortiert///////////////////
      $template->assign_block_vars('kalender', array(
      'TOPIC_TITLE'       => $topic_title,
      'TOPIC_AUTHOR'       => $topic_author,
      'TOPIC_DATE'       => $topic_date,
      'TOPIC_LAST_POST'    => $topic_last_post,
      'TOPIC_LAST_AUTHOR' => $topic_last_author,
      'TOPIC_LINK'       => $topic_link,
      ));
      }
   }