/**

*

* @package acp

* @version $Id: acp_main.php 9171 2008-12-04 14:53:04Z acydburn $

* @copyright (c) 2005 phpBB Group

* @license http://opensource.org/licenses/gpl-license.php GNU Public License

*

*/

/**

* @ignore

*/

if (!defined('IN_PHPBB'))

{

	exit;

}

/**

* @package acp

*/

class acp_main

{

	var $u_action;

	function main($id, $mode)

	{

		global $config, $db, $user, $auth, $template;

		global $phpbb_root_path, $phpbb_admin_path, $phpEx;

		// Show restore permissions notice

		if ($user->data['user_perm_from'] && $auth->acl_get('a_switchperm'))

		{

			$this->tpl_name = 'acp_main';

			$this->page_title = 'ACP_MAIN';

			$sql = 'SELECT user_id, username, user_colour

				FROM ' . USERS_TABLE . '

				WHERE user_id = ' . $user->data['user_perm_from'];

			$result = $db->sql_query($sql);

			$user_row = $db->sql_fetchrow($result);

			$db->sql_freeresult($result);

			$perm_from = '<strong' . (($user_row['user_colour']) ? ' style="color: #' . $user_row['user_colour'] . '">' : '>');

			$perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '' : '';

			$perm_from .= $user_row['username'];

			$perm_from .= ($user_row['user_id'] != ANONYMOUS) ? '' : '';

			$perm_from .= '';

			$template->assign_vars(array(

				'S_RESTORE_PERMISSIONS'		=> true,

				'U_RESTORE_PERMISSIONS'		=> append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=restore_perm'),

				'PERM_FROM'					=> $perm_from,

				'L_PERMISSIONS_TRANSFERRED_EXPLAIN'	=> sprintf($user->lang['PERMISSIONS_TRANSFERRED_EXPLAIN'], $perm_from, append_sid("{$phpbb_root_path}ucp.$phpEx", 'mode=restore_perm')),

			));

			return;

		}

		$action = request_var('action', '');

		if ($action)

		{

			if ($action === 'admlogout')

			{

				$user->unset_admin();

				$redirect_url = append_sid("{$phpbb_root_path}index.$phpEx");

				meta_refresh(3, $redirect_url);

				trigger_error($user->lang['ADM_LOGGED_OUT'] . '

' . sprintf($user->lang['RETURN_INDEX'], '', ''));

			}

			if (!confirm_box(true))

			{

				switch ($action)

				{

					case 'online':

						$confirm = true;

						$confirm_lang = 'RESET_ONLINE_CONFIRM';

					break;

					case 'stats':

						$confirm = true;

						$confirm_lang = 'RESYNC_STATS_CONFIRM';

					break;

					case 'user':

						$confirm = true;

						$confirm_lang = 'RESYNC_POSTCOUNTS_CONFIRM';

					break;

					case 'date':

						$confirm = true;

						$confirm_lang = 'RESET_DATE_CONFIRM';

					break;

					case 'db_track':

						$confirm = true;

						$confirm_lang = 'RESYNC_POST_MARKING_CONFIRM';

					break;

					case 'purge_cache':

						$confirm = true;

						$confirm_lang = 'PURGE_CACHE_CONFIRM';

					break;

					default:

						$confirm = true;

						$confirm_lang = 'CONFIRM_OPERATION';

				}

				if ($confirm)

				{

					confirm_box(false, $user->lang[$confirm_lang], build_hidden_fields(array(

						'i'			=> $id,

						'mode'		=> $mode,

						'action'	=> $action,

					)));

				}

			}

			else

			{

				switch ($action)

				{

					case 'online':

						if (!$auth->acl_get('a_board'))

						{

							trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

						}

						set_config('record_online_users', 1, true);

						set_config('record_online_date', time(), true);

						add_log('admin', 'LOG_RESET_ONLINE');

					break;

					case 'stats':

						if (!$auth->acl_get('a_board'))

						{

							trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

						}

						$sql = 'SELECT COUNT(post_id) AS stat

							FROM ' . POSTS_TABLE . '

							WHERE post_approved = 1';

						$result = $db->sql_query($sql);

						set_config('num_posts', (int) $db->sql_fetchfield('stat'), true);

						$db->sql_freeresult($result);

						$sql = 'SELECT COUNT(topic_id) AS stat

							FROM ' . TOPICS_TABLE . '

							WHERE topic_approved = 1';

						$result = $db->sql_query($sql);

						set_config('num_topics', (int) $db->sql_fetchfield('stat'), true);

						$db->sql_freeresult($result);

						$sql = 'SELECT COUNT(user_id) AS stat

							FROM ' . USERS_TABLE . '

							WHERE user_type IN (' . USER_NORMAL . ',' . USER_FOUNDER . ')';

						$result = $db->sql_query($sql);

						set_config('num_users', (int) $db->sql_fetchfield('stat'), true);

						$db->sql_freeresult($result);

						$sql = 'SELECT COUNT(attach_id) as stat

							FROM ' . ATTACHMENTS_TABLE . '

							WHERE is_orphan = 0';

						$result = $db->sql_query($sql);

						set_config('num_files', (int) $db->sql_fetchfield('stat'), true);

						$db->sql_freeresult($result);

						$sql = 'SELECT SUM(filesize) as stat

							FROM ' . ATTACHMENTS_TABLE . '

							WHERE is_orphan = 0';

						$result = $db->sql_query($sql);

						set_config('upload_dir_size', (float) $db->sql_fetchfield('stat'), true);

						$db->sql_freeresult($result);

						if (!function_exists('update_last_username'))

						{

							include($phpbb_root_path . "includes/functions_user.$phpEx");

						}

						update_last_username();

						add_log('admin', 'LOG_RESYNC_STATS');

					break;

					case 'user':

						if (!$auth->acl_get('a_board'))

						{

							trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

						}

						// Resync post counts

						$start = $max_post_id = 0;

						// Find the maximum post ID, we can only stop the cycle when we've reached it

						$sql = 'SELECT MAX(forum_last_post_id) as max_post_id

							FROM ' . FORUMS_TABLE;

						$result = $db->sql_query($sql);

						$max_post_id = (int) $db->sql_fetchfield('max_post_id');

						$db->sql_freeresult($result);

						// No maximum post id? :o

						if (!$max_post_id)

						{

							$sql = 'SELECT MAX(post_id)

								FROM ' . POSTS_TABLE;

							$result = $db->sql_query($sql);

							$max_post_id = (int) $db->sql_fetchfield('max_post_id');

							$db->sql_freeresult($result);

						}

						// Still no maximum post id? Then we are finished

						if (!$max_post_id)

						{

							add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

							break;

						}

						$step = ($config['num_posts']) ? (max((int) ($config['num_posts'] / 5), 20000)) : 20000;

						$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_posts = 0');

						while ($start < $max_post_id)

						{

							$sql = 'SELECT COUNT(post_id) AS num_posts, poster_id

								FROM ' . POSTS_TABLE . '

								WHERE post_id BETWEEN ' . ($start + 1) . ' AND ' . ($start + $step) . '

									AND post_postcount = 1 AND post_approved = 1

								GROUP BY poster_id';

							$result = $db->sql_query($sql);

							if ($row = $db->sql_fetchrow($result))

							{

								do

								{

									$sql = 'UPDATE ' . USERS_TABLE . " SET user_posts = user_posts + {$row['num_posts']} WHERE user_id = {$row['poster_id']}";

									$db->sql_query($sql);

								}

								while ($row = $db->sql_fetchrow($result));

							}

							$db->sql_freeresult($result);

							$start += $step;

						}

						add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

					break;

					case 'date':

						if (!$auth->acl_get('a_board'))

						{

							trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

						}

						set_config('board_startdate', time() - 1);

						add_log('admin', 'LOG_RESET_DATE');

					break;

					case 'db_track':

						switch ($db->sql_layer)

						{

							case 'sqlite':

							case 'firebird':

								$db->sql_query('DELETE FROM ' . TOPICS_POSTED_TABLE);

							break;

							default:

								$db->sql_query('TRUNCATE TABLE ' . TOPICS_POSTED_TABLE);

							break;

						}

						// This can get really nasty... therefore we only do the last six months

						$get_from_time = time() - (6 * 4 * 7 * 24 * 60 * 60);

						// Select forum ids, do not include categories

						$sql = 'SELECT forum_id

							FROM ' . FORUMS_TABLE . '

							WHERE forum_type <> ' . FORUM_CAT;

						$result = $db->sql_query($sql);

						$forum_ids = array();

						while ($row = $db->sql_fetchrow($result))

						{

							$forum_ids[] = $row['forum_id'];

						}

						$db->sql_freeresult($result);

						// Any global announcements? ;)

						$forum_ids[] = 0;

						// Now go through the forums and get us some topics...

						foreach ($forum_ids as $forum_id)

						{

							$sql = 'SELECT p.poster_id, p.topic_id

								FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t

								WHERE t.forum_id = ' . $forum_id . '

									AND t.topic_moved_id = 0

									AND t.topic_last_post_time > ' . $get_from_time . '

									AND t.topic_id = p.topic_id

									AND p.poster_id <> ' . ANONYMOUS . '

								GROUP BY p.poster_id, p.topic_id';

							$result = $db->sql_query($sql);

							$posted = array();

							while ($row = $db->sql_fetchrow($result))

							{

								$posted[$row['poster_id']][] = $row['topic_id'];

							}

							$db->sql_freeresult($result);

							$sql_ary = array();

							foreach ($posted as $user_id => $topic_row)

							{

								foreach ($topic_row as $topic_id)

								{

									$sql_ary[] = array(

										'user_id'		=> (int) $user_id,

										'topic_id'		=> (int) $topic_id,

										'topic_posted'	=> 1,

									);

								}

							}

							unset($posted);

							if (sizeof($sql_ary))

							{

								$db->sql_multi_insert(TOPICS_POSTED_TABLE, $sql_ary);

							}

						}

						add_log('admin', 'LOG_RESYNC_POST_MARKING');

					break;

					case 'purge_cache':

						if ((int) $user->data['user_type'] !== USER_FOUNDER)

						{

							trigger_error($user->lang['NO_AUTH_OPERATION'] . adm_back_link($this->u_action), E_USER_WARNING);

						}

						global $cache;

						$cache->purge();

						// Clear permissions

						$auth->acl_clear_prefetch();

						cache_moderators();

						add_log('admin', 'LOG_PURGE_CACHE');

					break;

				}

			}

		}

		// Get forum statistics

		$total_posts = $config['num_posts'];

		$total_topics = $config['num_topics'];

		$total_users = $config['num_users'];

		$total_files = $config['num_files'];

		$start_date = $user->format_date($config['board_startdate']);

		$boarddays = (time() - $config['board_startdate']) / 86400;

		$posts_per_day = sprintf('%.2f', $total_posts / $boarddays);

		$topics_per_day = sprintf('%.2f', $total_topics / $boarddays);

		$users_per_day = sprintf('%.2f', $total_users / $boarddays);

		$files_per_day = sprintf('%.2f', $total_files / $boarddays);

		$upload_dir_size = get_formatted_filesize($config['upload_dir_size']);

		$avatar_dir_size = 0;

		if ($avatar_dir = @opendir($phpbb_root_path . $config['avatar_path']))

		{

			while (($file = readdir($avatar_dir)) !== false)

			{

				if ($file[0] != '.' && $file != 'CVS' && strpos($file, 'index.') === false)

				{

					$avatar_dir_size += filesize($phpbb_root_path . $config['avatar_path'] . '/' . $file);

				}

			}

			closedir($avatar_dir);

			$avatar_dir_size = get_formatted_filesize($avatar_dir_size);

		}

		else

		{

			// Couldn't open Avatar dir.

			$avatar_dir_size = $user->lang['NOT_AVAILABLE'];

		}

		if ($posts_per_day > $total_posts)

		{

			$posts_per_day = $total_posts;

		}

		if ($topics_per_day > $total_topics)

		{

			$topics_per_day = $total_topics;

		}

		if ($users_per_day > $total_users)

		{

			$users_per_day = $total_users;

		}

		if ($files_per_day > $total_files)

		{

			$files_per_day = $total_files;

		}

		if ($config['allow_attachments'] || $config['allow_pm_attach'])

		{

			$sql = 'SELECT COUNT(attach_id) AS total_orphan

				FROM ' . ATTACHMENTS_TABLE . '

				WHERE is_orphan = 1

					AND filetime < ' . (time() - 3*60*60);

			$result = $db->sql_query($sql);

			$total_orphan = (int) $db->sql_fetchfield('total_orphan');

			$db->sql_freeresult($result);

		}

		else

		{

			$total_orphan = false;

		}

		$dbsize = get_database_size();

		$template->assign_vars(array(

			'TOTAL_POSTS'		=> $total_posts,

			'POSTS_PER_DAY'		=> $posts_per_day,

			'TOTAL_TOPICS'		=> $total_topics,

			'TOPICS_PER_DAY'	=> $topics_per_day,

			'TOTAL_USERS'		=> $total_users,

			'USERS_PER_DAY'		=> $users_per_day,

			'TOTAL_FILES'		=> $total_files,

			'FILES_PER_DAY'		=> $files_per_day,

			'START_DATE'		=> $start_date,

			'AVATAR_DIR_SIZE'	=> $avatar_dir_size,

			'DBSIZE'			=> $dbsize,

			'UPLOAD_DIR_SIZE'	=> $upload_dir_size,

			'TOTAL_ORPHAN'		=> $total_orphan,

			'S_TOTAL_ORPHAN'	=> ($total_orphan === false) ? false : true,

			'GZIP_COMPRESSION'	=> ($config['gzip_compress']) ? $user->lang['ON'] : $user->lang['OFF'],

			'DATABASE_INFO'		=> $db->sql_server_info(),

			'BOARD_VERSION'		=> $config['version'],

			'U_ACTION'			=> $this->u_action,

			'U_ADMIN_LOG'		=> append_sid("{$phpbb_admin_path}index.$phpEx", 'i=logs&mode=admin'),

			'U_INACTIVE_USERS'	=> append_sid("{$phpbb_admin_path}index.$phpEx", 'i=inactive&mode=list'),

			'S_ACTION_OPTIONS'	=> ($auth->acl_get('a_board')) ? true : false,

			'S_FOUNDER'			=> ($user->data['user_type'] == USER_FOUNDER) ? true : false,

			)

		);

		$log_data = array();

		$log_count = 0;

		if ($auth->acl_get('a_viewlogs'))

		{

			view_log('admin', $log_data, $log_count, 5);

			foreach ($log_data as $row)

			{

				$template->assign_block_vars('log', array(

					'USERNAME'	=> $row['username_full'],

					'IP'		=> $row['ip'],

					'DATE'		=> $user->format_date($row['time']),

					'ACTION'	=> $row['action'])

				);

			}

		}

		if ($auth->acl_get('a_user'))

		{

			$inactive = array();

			$inactive_count = 0;

			view_inactive_users($inactive, $inactive_count, 10);

			foreach ($inactive as $row)

			{

				$template->assign_block_vars('inactive', array(

					'INACTIVE_DATE'	=> $user->format_date($row['user_inactive_time']),

					'JOINED'		=> $user->format_date($row['user_regdate']),

					'LAST_VISIT'	=> (!$row['user_lastvisit']) ? ' - ' : $user->format_date($row['user_lastvisit']),

					'REASON'		=> $row['inactive_reason'],

					'USER_ID'		=> $row['user_id'],

					'USERNAME'		=> $row['username'],

					'U_USER_ADMIN'	=> append_sid("{$phpbb_admin_path}index.$phpEx", "i=users&mode=overview&u={$row['user_id']}"))

				);

			}

			$option_ary = array('activate' => 'ACTIVATE', 'delete' => 'DELETE');

			if ($config['email_enable'])

			{

				$option_ary += array('remind' => 'REMIND');

			}

			$template->assign_vars(array(

				'S_INACTIVE_USERS'		=> true,

				'S_INACTIVE_OPTIONS'	=> build_select($option_ary))

			);

		}

		// Warn if install is still present

		if (file_exists($phpbb_root_path . 'install'))

		{

			$template->assign_var('S_REMOVE_INSTALL', true);

		}

		if (!defined('PHPBB_DISABLE_CONFIG_CHECK') && file_exists($phpbb_root_path . 'config.' . $phpEx) && is_writable($phpbb_root_path . 'config.' . $phpEx))

		{

			// World-Writable? (000x)

			$template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms($phpbb_root_path . 'config.' . $phpEx) & 0x0002));

		}

		$this->tpl_name = 'acp_main';

		$this->page_title = 'ACP_MAIN';

	}

}

?>