Anonymous

		//-----------------------------------------
		// Load the template...
		//-----------------------------------------
		
		if($where == '24') {
		$template = ("ssi_news");
		}
		elseif($where == '48') {
		$template = ("ssi_news2");
		}
			
		//-----------------------------------------
		// Get the topics, member info and other stuff
		//-----------------------------------------
		
		$ipsclass->DB->build_query( array( 'select'   => 't.*',
												 'from'     => array( 'topics' => 't' ),
												 'where'    => "t.forum_id in (24,48,26,60) AND t.approved=1",
												 'order'    => 't.tid DESC',
												 'limit'    => array( 0, 10 ),
												 'add_join' => array( 0 => array( 'select' => 'm.members_display_name as member_name, m.mgroup, m.id as member_id,m.title as member_title',
																				  'from'   => array( 'members' => 'm' ),
																				  'where'  => "m.id=t.starter_id",
																				  'type'   => 'left' ),
																	  1 => array( 'select' => 'p.*',
																				  'from'   => array( 'posts' => 'p' ),
																				  'where'  => "t.topic_firstpost=p.pid",
																				  'type'   => 'inner' )  )
										)      );
		
		$ipsclass->DB->exec_query();