<?php
$CFG['number_of_news'] = '5';
$CFG['news_length'] = '200';
$CFG['news_forum'] = '1';
$CFG['poll_forum'] = '1';
$CFG['number_recent_topics'] = '10';
$CFG['exceptional_forums'] = '';
 
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'fetchposts.'.$phpEx);
 
 
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
 
$total_posts = get_db_stat('postcount');
$total_users = get_db_stat('usercount');
$total_topics = get_db_stat('topiccount');
$newest_userdata = get_db_stat('newestuser');
$newest_user = $newest_userdata['username'];
$newest_uid = $newest_userdata['user_id'];
 
if( $total_posts == 0 )
{
 $l_total_post_s = $lang['Posted_articles_zero_total'];
}
else if( $total_posts == 1 )
{
 $l_total_post_s = $lang['Posted_article_total'];
}
else
{
 $l_total_post_s = $lang['Posted_articles_total'];
}
 
if( $total_users == 0 )
{
 $l_total_user_s = $lang['Registered_users_zero_total'];
}
else if( $total_users == 1 )
{
 $l_total_user_s = $lang['Registered_user_total'];
}
else
{
 $l_total_user_s = $lang['Registered_users_total'];
}
 
$sql = "SELECT * FROM ". FORUMS_TABLE . " ORDER BY forum_id";
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;
}
 
$is_auth_ary = array();
$is_auth_ary = auth(AUTH_ALL, AUTH_LIST_ALL, $userdata, $forum_data);
 
if( $CFG['exceptional_forums'] == '' )
{
 $except_forum_id = '\'start\'';
}
else
{
 $except_forum_id = $CFG['exceptional_forums'];
}
 
for ($i = 0; $i < count($forum_data); $i++)
{
 if ((!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_read']) or (!$is_auth_ary[$forum_data[$i]['forum_id']]['auth_view']))
 {
  if ($except_forum_id == '\'start\'')
  {
   $except_forum_id = $forum_data[$i]['forum_id'];
  }
  else
  {
   $except_forum_id .= ',' . $forum_data[$i]['forum_id'];
  }
 }
}
$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
  FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u
  WHERE t.forum_id NOT IN (" . $except_forum_id . " )
   AND t.topic_status <> 2
   AND p.post_id = t.topic_last_post_id
   AND p.poster_id = u.user_id
  ORDER BY p.post_id DESC
  LIMIT " . $CFG['number_recent_topics'];
if (!$result = $db->sql_query($sql))
{
 message_die(GENERAL_ERROR, 'Could not query recent topics information', '', __LINE__, __FILE__, $sql);
}
$number_recent_topics = $db->sql_numrows($result);
$recent_topic_row = array();
while ($row = $db->sql_fetchrow($result))
{
 $recent_topic_row[] = $row;
}
for ($i = 0; $i < $number_recent_topics; $i++)
{
 $template->assign_block_vars('recent_topic_row', array(
  'U_TITLE' => append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $recent_topic_row[$i]['post_id']) . '#' .$recent_topic_row[$i]['post_id'],
  'L_TITLE' => $recent_topic_row[$i]['topic_title'],
  'U_POSTER' => append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $recent_topic_row[$i]['user_id']),
  'S_POSTER' => $recent_topic_row[$i]['username'],
  'S_POSTTIME' => create_date($board_config['default_dateformat'], $recent_topic_row[$i]['post_time'], $board_config['board_timezone'])
  )
 );
}
 
 
if( $userdata['session_logged_in'] )
{
 $sql = "SELECT COUNT(post_id) as total
   FROM " . POSTS_TABLE . "
   WHERE post_time >= " . $userdata['user_lastvisit'];
 $result = $db->sql_query($sql);
 if( $result )
 {
  $row = $db->sql_fetchrow($result);
  $lang['Search_new'] = $lang['Search_new'] . "&nbsp;(" . $row['total'] . " )";
 }
}
 
 
define('SHOW_ONLINE', true);
$page_title = $lang['Home'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
 
$template->set_filenames(array(
 'body' => 'portal_body.tpl')
);
 
 
$avatar_img = '';
if ( $userdata['user_avatar_type'] && $userdata['user_allowavatar'] )
{
 switch( $userdata['user_avatar_type'] )
 {
  case USER_AVATAR_UPLOAD:
   $avatar_img = ( $board_config['allow_avatar_upload'] ) ? '<img src="' . $board_config['avatar_path'] . '/' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
   break;
  case USER_AVATAR_REMOTE:
   $avatar_img = ( $board_config['allow_avatar_remote'] ) ? '<img src="' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
   break;
  case USER_AVATAR_GALLERY:
   $avatar_img = ( $board_config['allow_avatar_local'] ) ? '<img src="' . $board_config['avatar_gallery_path'] . '/' . $userdata['user_avatar'] . '" alt="" border="0" />' : '';
   break;
 }
}
 
if ($userdata['user_id'] != '-1')
{
 $name_link = '<a href="' . append_sid("profile.$phpEx?mode=editprofile&amp;" . $userdata['user_id']) . '">' . $userdata['username'] . '</a>';
}
else
{
 $name_link = $lang['Guest'];
}
//
// END: Avatar On Index MOD
//
 
 
$template->assign_vars(array(
 'WELCOME_TEXT' => $CFG['welcome_text'],
 'TOTAL_POSTS' => sprintf($l_total_post_s, $total_posts),
 'TOTAL_USERS' => sprintf($l_total_user_s, $total_users),
 'TOTAL_TOPICS' => sprintf($lang['total_topics'], $total_topics),
 'NEWEST_USER' => sprintf($lang['Newest_user'], '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=$newest_uid" ) . '">', $newest_user, '</a>'),
 'L_FORUM' => $lang['Forum'],
 'L_BOARD_NAVIGATION' => $lang['Board_navigation'],
 'L_STATISTICS' => $lang['Statistics'],  
 'L_ANNOUNCEMENT' => $lang['Post_Announcement'],
 'L_POSTED' => $lang['Posted'],
 'L_COMMENTS' => $lang['Comments'],
 'L_VIEW_COMMENTS' => $lang['View_comments'],
 'L_POST_COMMENT' => $lang['Post_your_comment'],
 'L_SEND_PASSWORD' => $lang['Forgotten_password'],
 'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword" ),
 'L_REGISTER_NEW_ACCOUNT' => sprintf($lang['Register_new_account'], '<a href="' . append_sid("profile.$phpEx?mode=register" ) . '">', '</a>'),
 'L_REMEMBER_ME' => $lang['Remember_me'],
 'L_VIEW_COMPLETE_LIST' => $lang['View_complete_list'],
 'L_POLL' => $lang['Poll'],
 'L_VOTE_BUTTON' => $lang['Vote'],
  // Recent Topics
 'L_RECENT_TOPICS' => $lang['Recent_topics'],
 
 // Search
 'L_SEARCH_AT' => $lang['Search_at'],
 'L_ADVANCED_SEARCH' => $lang['Advanced_search'],
 
 // Welcome Avatar
 'L_NAME_WELCOME' => $lang['Welcome'],
 'U_NAME_LINK' => $name_link,
 'AVATAR_IMG' => $avatar_img)
);
 
if(!isset($HTTP_GET_VARS['article']))
{
 $template->assign_block_vars('welcome_text', array());
 
 $fetchposts = phpbb_fetch_posts($CFG['news_forum'], $CFG['number_of_news'], $CFG['news_length']);
 
 for ($i = 0; $i < count($fetchposts); $i++)
 {
  if( $fetchposts[$i]['striped'] == 1 )
  {
   $open_bracket = '[ ';
   $close_bracket = ' ]';
   $read_full = $lang['Read_Full'];
  }
  else
  {
   $open_bracket = '';
   $close_bracket = '';
   $read_full = '';
  }
 
  $template->assign_block_vars('fetchpost_row', array(
   'TITLE' => $fetchposts[$i]['topic_title'],
   'POSTER' => $fetchposts[$i]['username'],
   'TIME' => $fetchposts[$i]['topic_time'],
   'TEXT' => $fetchposts[$i]['post_text'],
   'REPLIES' => $fetchposts[$i]['topic_replies'],
   'U_VIEW_COMMENTS' => append_sid('viewtopic.' . $phpEx . '?t=' . $fetchposts[$i]['topic_id']),
   'U_POST_COMMENT' => append_sid('posting.' . $phpEx . '?mode=reply&amp;t=' . $fetchposts[$i]['topic_id']),
   'U_READ_FULL' => append_sid('portal.' . $phpEx . '?article=' . $i),
   'L_READ_FULL' => $read_full,
   'OPEN' => $open_bracket,
   'CLOSE' => $close_bracket)
  );
 }
}
else
{
 $fetchposts = phpbb_fetch_posts($CFG['news_forum'], $CFG['number_of_news'], 0);
 
 $i = intval($HTTP_GET_VARS['article']);
 
 $template->assign_block_vars('fetchpost_row', array(
  'TITLE' => $fetchposts[$i]['topic_title'],
  'POSTER' => $fetchposts[$i]['username'],
  'TIME' => $fetchposts[$i]['topic_time'],
  'TEXT' => $fetchposts[$i]['post_text'],
  'REPLIES' => $fetchposts[$i]['topic_replies'],
  'U_VIEW_COMMENTS' => append_sid('viewtopic.' . $phpEx . '?t=' . $fetchposts[$i]['topic_id']),
  'U_POST_COMMENT' => append_sid('posting.' . $phpEx . '?mode=reply&amp;t=' . $fetchposts[$i]['topic_id'])
  )
 );
}
 
$fetchpoll = phpbb_fetch_poll($CFG['poll_forum']);
 
if (!empty($fetchpoll))
{
 $template->assign_vars(array(  
  'S_POLL_QUESTION' => $fetchpoll['vote_text'],
  'S_POLL_ACTION' => append_sid('posting.'.$phpEx.'?'.POST_TOPIC_URL.'='.$fetchpoll['topic_id']),
  'S_TOPIC_ID' => $fetchpoll['topic_id'],
  'L_SUBMIT_VOTE' => $lang['Submit_vote'],
  'L_LOGIN_TO_VOTE' => $lang['Login_to_vote']  
  )
 );
 
 for ($i = 0; $i < count($fetchpoll['options']); $i++)
 {
  $template->assign_block_vars('poll_option_row', array(
   'OPTION_ID' => $fetchpoll['options'][$i]['vote_option_id'],
   'OPTION_TEXT' => $fetchpoll['options'][$i]['vote_option_text'],
   'VOTE_RESULT' => $fetchpoll['options'][$i]['vote_result'],
   )
  );
 }  
}
else
{
 $template->assign_vars(array(  
  'S_POLL_QUESTION' => $lang['No_poll'],
  'DISABLED' => 'disabled="disabled"'
  )
 );
}
 
 
$template->pparse('body');
 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
 
?>

<?php
 
define('SHOW_ONLINE', true);
$page_title = $lang['Home'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
 
$template->set_filenames(array(
 'body' => 'portal_body.tpl')
);
 
 
//
// Generate the page
//
$template->pparse('body');
 
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
 
?>