Inheritance: implements phpbb\log\log_interface
Ejemplo n.º 1
0
	protected function execute(InputInterface $input, OutputInterface $output)
	{
		$this->migrator->set_output_handler(new \phpbb\db\log_wrapper_migrator_output_handler($this->user, new console_migrator_output_handler($this->user, $output), $this->phpbb_root_path . 'store/migrations_' . time() . '.log', $this->filesystem));

		$this->migrator->create_migrations_table();

		$this->cache->purge();

		$this->load_migrations();
		$orig_version = $this->config['version'];
		while (!$this->migrator->finished())
		{
			try
			{
				$this->migrator->update();
			}
			catch (\phpbb\db\migration\exception $e)
			{
				$output->writeln('<error>' . $e->getLocalisedMessage($this->user) . '</error>');
				$this->finalise_update();
				return 1;
			}
		}

		if ($orig_version != $this->config['version'])
		{
			$this->log->add('admin', ANONYMOUS, '', 'LOG_UPDATE_DATABASE', time(), array($orig_version, $this->config['version']));
		}

		$this->finalise_update();
		$output->writeln($this->user->lang['DATABASE_UPDATE_COMPLETE']);
	}
 function main($id, $mode)
 {
     global $phpbb_container, $user, $template, $config, $request;
     $this->phpbb_container = $phpbb_container;
     $this->user = $user;
     $this->template = $template;
     $this->config = $config;
     $this->request = $request;
     $this->log = $this->phpbb_container->get('log');
     $this->tpl_name = 'acp_codebox_plus';
     $this->page_title = $this->user->lang('CODEBOX_PLUS_TITLE');
     add_form_key('o0johntam0o/acp_codebox_plus');
     if ($this->request->is_set_post('submit')) {
         if (!check_form_key('o0johntam0o/acp_codebox_plus')) {
             trigger_error('FORM_INVALID');
         }
         $this->config->set('codebox_plus_syntax_highlighting', $request->variable('codebox_plus_syntax_highlighting', 0));
         $this->config->set('codebox_plus_expanded', $request->variable('codebox_plus_expanded', 0));
         $this->config->set('codebox_plus_download', $request->variable('codebox_plus_download', 0));
         $this->config->set('codebox_plus_login_required', $request->variable('codebox_plus_login_required', 0));
         $this->config->set('codebox_plus_prevent_bots', $request->variable('codebox_plus_prevent_bots', 0));
         $this->config->set('codebox_plus_captcha', $request->variable('codebox_plus_captcha', 0));
         $this->config->set('codebox_plus_max_attempt', $request->variable('codebox_plus_max_attempt', 0));
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'CODEBOX_PLUS_LOG_MSG');
         trigger_error($this->user->lang('CODEBOX_PLUS_SAVED') . adm_back_link($this->u_action));
     }
     $this->template->assign_vars(array('U_ACTION' => $this->u_action, 'S_CODEBOX_PLUS_VERSION' => isset($this->config['codebox_plus_version']) ? $this->config['codebox_plus_version'] : 0, 'S_CODEBOX_PLUS_SYNTAX_HIGHLIGHTING' => isset($this->config['codebox_plus_syntax_highlighting']) ? $this->config['codebox_plus_syntax_highlighting'] : 0, 'S_CODEBOX_PLUS_EXPANDED' => isset($this->config['codebox_plus_expanded']) ? $this->config['codebox_plus_expanded'] : 0, 'S_CODEBOX_PLUS_DOWNLOAD' => isset($this->config['codebox_plus_download']) ? $this->config['codebox_plus_download'] : 0, 'S_CODEBOX_PLUS_LOGIN_REQUIRED' => isset($this->config['codebox_plus_login_required']) ? $this->config['codebox_plus_login_required'] : 0, 'S_CODEBOX_PLUS_PREVENT_BOTS' => isset($this->config['codebox_plus_prevent_bots']) ? $this->config['codebox_plus_prevent_bots'] : 0, 'S_CODEBOX_PLUS_CAPTCHA' => isset($this->config['codebox_plus_captcha']) ? $this->config['codebox_plus_captcha'] : 0, 'S_CODEBOX_PLUS_MAX_ATTEMPT' => isset($this->config['codebox_plus_max_attempt']) ? $this->config['codebox_plus_max_attempt'] : 0));
 }
Ejemplo n.º 3
0
 /**
  * Run the cronjob.
  */
 public function run()
 {
     $time = strtotime('- ' . $this->config['ajaxshoutbox_prune_days'] . ' days');
     $sql = 'SELECT * FROM ' . $this->table . ' WHERE post_time <= ' . $time;
     $result = $this->db->sql_query($sql);
     $canpush = $this->push->canPush();
     $delete = array();
     while ($row = $this->db->sql_fetchrow($result)) {
         if ($canpush) {
             if ($this->push->delete($row['shout_id']) !== false) {
                 $delete[] = $row['shout_id'];
             }
         } else {
             $delete[] = $row['shout_id'];
         }
     }
     $this->db->sql_freeresult();
     if (sizeof($delete)) {
         $sql = 'DELETE FROM ' . $this->table . ' WHERE ' . $this->db->sql_in_set('shout_id', $delete);
         $this->db->sql_query($sql);
         $uuid = $this->user->data['user_id'];
         if (!$uuid) {
             $uuid = ANONYMOUS;
         }
         $this->log->add('admin', $uuid, $this->user->ip, 'LOG_AJAX_SHOUTBOX_PRUNED', time(), array(sizeof($delete)));
     }
     $this->config->set('shoutbox_prune_gc', time(), false);
 }
Ejemplo n.º 4
0
 /**
  * If login failed set the conter +1
  *
  * @param object $event The event object
  * @return null
  * @access public
  */
 public function login_box_failed($event)
 {
     // Set the counter +1
     $sql = 'UPDATE ' . USERS_TABLE . " SET failed_logins_count = failed_logins_count + 1\n\t\t\tWHERE username_clean = '" . $this->db->sql_escape(utf8_clean_string($event['username'])) . "'";
     $this->db->sql_query($sql);
     // Add to user log
     $this->log->add('user', ANONYMOUS, $this->user->ip, 'TRY_TO_LOGIN_FAIL', time(), array('reportee_id' => ANONYMOUS, 'username' => $event['username']));
 }
Ejemplo n.º 5
0
 public function main($id, $mode)
 {
     global $config, $db, $request, $template, $user, $phpbb_root_path, $phpEx, $phpbb_container;
     $this->config = $config;
     $this->db = $db;
     $this->log = $phpbb_container->get('log');
     $this->request = $request;
     $this->template = $template;
     $this->user = $user;
     $this->phpbb_root_path = $phpbb_root_path;
     $this->php_ext = $phpEx;
     // Load a template from adm/style for our ACP page
     $this->tpl_name = 'acp_usermerge';
     // Set the page title for our ACP page
     $this->page_title = 'ACP_USER_MERGE';
     // Quick var-checking and var setup.
     $action = $this->request->variable('action', '');
     $merge = $action == 'merge' ? true : false;
     $errors = array();
     $old_username = $this->request->variable('old_username', '', true);
     $new_username = $this->request->variable('new_username', '', true);
     $form_key = 'acp_user_merge';
     add_form_key($form_key);
     // Hath we an invalid form key?
     if ($this->request->is_set_post('submit') && !check_form_key($form_key)) {
         $errors[] = $user->lang['FORM_INVALID'];
     }
     if ($this->request->is_set_post('submit') || $merge) {
         $old_user_id = $this->check_user($old_username, $errors, true);
         $new_user_id = $this->check_user($new_username, $errors, false);
     }
     // Make sure we have submitted the form, and that we do not have errors
     if (($this->request->is_set_post('submit') || $merge) && !sizeof($errors)) {
         if ($old_user_id == $new_user_id) {
             $warning = sprintf($this->user->lang['CANNOT_MERGE_SAME'], $old_username);
             trigger_error($warning . adm_back_link($this->u_action), E_USER_WARNING);
         }
         // Have we confirmed this change?
         if (confirm_box(true)) {
             // Let's roll!
             $this->user_merge($old_user_id, $new_user_id);
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_USERS_MERGED', time(), array($old_username . ' &raquo; ' . $new_username));
             trigger_error($this->user->lang['USERS_MERGED'] . adm_back_link($this->u_action));
         } else {
             $hidden_fields = array('i' => $id, 'mode' => $mode, 'old_username' => $old_username, 'new_username' => $new_username, 'action' => 'merge');
             // Be annoying.  Are you suuuuuuuuuuuure?  No, really, are you sure?
             $merge_users_confirm = sprintf($this->user->lang['MERGE_USERS_CONFIRM'], $old_username);
             confirm_box(false, $merge_users_confirm, build_hidden_fields($hidden_fields));
         }
     }
     $user_merge_version = !empty($this->config['usermerge_version']) ? $this->config['usermerge_version'] : '';
     // Assign template stuffs now.
     $this->page_title = $this->user->lang['ACP_USER_MERGE_TITLE'];
     $template->assign_vars(array('S_ERROR' => sizeof($errors) ? true : false, 'ERROR_MSG' => implode('<br />', $errors), 'USER_MERGE_VERSION' => $user_merge_version, 'U_FIND_OLD_USERNAME' => append_sid("{$this->phpbb_root_path}memberlist.{$this->php_ext}", 'mode=searchuser&amp;form=user_merge&amp;field=old_username&amp;select_single=true'), 'U_FIND_NEW_USERNAME' => append_sid("{$this->phpbb_root_path}memberlist.{$this->php_ext}", 'mode=searchuser&amp;form=user_merge&amp;field=new_username&amp;select_single=true'), 'OLD_USERNAME' => !empty($old_user_id) ? $old_username : '', 'NEW_USERNAME' => !empty($new_user_id) ? $new_username : '', 'L_TITLE' => $this->user->lang['ACP_USER_MERGE_TITLE'], 'L_EXPLAIN' => $this->user->lang['ACP_USER_MERGE_EXPLAIN'], 'USERMERGE_VERSION' => $user_merge_version, 'U_ACTION' => $this->u_action));
 }
Ejemplo n.º 6
0
 /**
  * Log failed login attempts
  *
  * @param object $event The event object
  * @return null
  * @access public
  */
 public function failed_login($event)
 {
     $result = $event['result'];
     $username = $event['username'];
     $additional_data = array();
     $additional_data['reportee_id'] = $result['user_row']['user_id'];
     // We want to log Admin fails to the Admin log and User fails to the user log
     $log_type = $this->get_userid_from_username($username);
     switch ($result['status']) {
         case LOGIN_ERROR_USERNAME:
             $error_msg = 'ERROR_LOGIN_USERNAME';
             $log_type = 'user';
             // This can only be user as we have no data to test
             $additional_data[] = $username;
             break;
         case LOGIN_ERROR_PASSWORD:
             $error_msg = 'ERROR_LOGIN_PASSWORD';
             break;
         case LOGIN_ERROR_ATTEMPTS:
             $error_msg = 'ERROR_LOGIN_ATTEMPTS';
             break;
         case LOGIN_ERROR_PASSWORD_CONVERT:
             $error_msg = 'ERROR_LOGIN_PASSWORD_CONVERT';
             break;
         default:
             // Let's have a catchall for any other fails
             $error_msg = 'ERROR_LOGIN_UNKNOWN';
             $log_type = 'user';
             $additional_data[] = $result['status'];
             $additional_data[] = $username;
             break;
     }
     $this->log->add($log_type, $result['user_row']['user_id'], $this->user->ip, $error_msg, time(), $additional_data);
 }
Ejemplo n.º 7
0
 /**
  * Validate config vars and update config table if needed
  *
  * @return null
  */
 public function process()
 {
     $submit = $this->request->is_set_post('submit') ? true : false;
     $this->new_config = $this->config;
     $cfg_array = $this->request->is_set('config') ? $this->request->variable('config', array('' => ''), true) : $this->new_config;
     $error = array();
     // We validate the complete config if whished
     validate_config_vars($this->display_vars['vars'], $cfg_array, $error);
     // Do not write values if there is an error
     if (sizeof($error)) {
         $submit = false;
     }
     // We go through the display_vars to make sure no one is trying to set variables he/she is not allowed to...
     foreach ($this->display_vars['vars'] as $config_name => $null) {
         if (!isset($cfg_array[$config_name]) || strpos($config_name, 'legend') !== false) {
             continue;
         }
         $this->new_config[$config_name] = $config_value = $cfg_array[$config_name];
         if ($submit) {
             $this->config->set($config_name, $config_value);
         }
     }
     if ($submit) {
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'DIR_CONFIG_SETTINGS');
         trigger_error($this->user->lang['CONFIG_UPDATED'] . adm_back_link($this->u_action));
     }
     $this->template->assign_vars(array('L_TITLE' => $this->user->lang[$this->display_vars['title']], 'L_TITLE_EXPLAIN' => $this->user->lang[$this->display_vars['title'] . '_EXPLAIN'], 'S_ERROR' => sizeof($error) ? true : false, 'ERROR_MSG' => implode('<br />', $error), 'U_ACTION' => $this->u_action));
 }
 /**
  * Activate user
  *
  * @param object $event The event object
  * @return null
  * @access public
  */
 private function user_justification_activate()
 {
     $user = $this->data;
     if (!function_exists('user_active_flip')) {
         include $this->root_path . 'includes/functions_user.' . $this->php_ext;
     }
     if (!class_exists('messenger')) {
         include $this->root_path . 'includes/functions_messenger.' . $this->php_ext;
     }
     user_active_flip('activate', $user['user_id']);
     $messenger = new \messenger(false);
     $messenger->template('admin_welcome_activated', $user['user_lang']);
     $messenger->to($user['user_email'], $user['username']);
     $messenger->anti_abuse_headers($this->config, $this->user);
     $messenger->assign_vars(array('USERNAME' => htmlspecialchars_decode($user['username'])));
     $messenger->send(NOTIFY_EMAIL);
     $messenger->save_queue();
     // Remove the notification
     $this->notification_manager->delete_notifications('notification.type.admin_activate_user', $user['user_id']);
     $sql = 'UPDATE ' . USERS_TABLE . "\n\t\t\tSET user_actkey = ''\n\t\t\tWHERE user_id = {$user['user_id']}";
     $this->db->sql_query($sql);
     // Create the correct logs
     $this->log->add('user', $this->user->data['user_id'], $this->user->ip, 'LOG_USER_ACTIVE_USER', false, array('reportee_id' => $user['user_id']));
     $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_USER_ACTIVE', false, array($user['username']));
 }
Ejemplo n.º 9
0
    /**
     * Submit auto group rule form data
     *
     * @param int $autogroups_id An auto group identifier
     *                           A value of 0 is new, otherwise we're updating
     * @return null
     * @access protected
     */
    protected function submit_autogroup_rule($autogroups_id = 0)
    {
        $data = array('autogroups_type_id' => $this->request->variable('autogroups_type_id', 0), 'autogroups_min_value' => $this->request->variable('autogroups_min_value', 0), 'autogroups_max_value' => $this->request->variable('autogroups_max_value', 0), 'autogroups_group_id' => $this->request->variable('autogroups_group_id', 0), 'autogroups_default' => $this->request->variable('autogroups_default', false), 'autogroups_notify' => $this->request->variable('autogroups_notify', false));
        // Prevent form submit when no user groups are available or selected
        if (!$data['autogroups_group_id']) {
            trigger_error($this->user->lang('ACP_AUTOGROUPS_INVALID_GROUPS') . adm_back_link($this->u_action), E_USER_WARNING);
        }
        // Prevent form submit when min and max values are identical
        if ($data['autogroups_min_value'] == $data['autogroups_max_value']) {
            trigger_error($this->user->lang('ACP_AUTOGROUPS_INVALID_RANGE') . adm_back_link($this->u_action), E_USER_WARNING);
        }
        if ($autogroups_id != 0) {
            $sql = 'UPDATE ' . $this->autogroups_rules_table . '
				SET ' . $this->db->sql_build_array('UPDATE', $data) . '
				WHERE autogroups_id = ' . (int) $autogroups_id;
            $this->db->sql_query($sql);
        } else {
            $sql = 'INSERT INTO ' . $this->autogroups_rules_table . ' ' . $this->db->sql_build_array('INSERT', $data);
            $this->db->sql_query($sql);
            $autogroups_id = $this->db->sql_nextid();
        }
        // Apply the auto group to all users
        $this->manager->sync_autogroups($autogroups_id);
        // Log the action
        $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'ACP_AUTOGROUPS_SAVED_LOG', time());
        // Output message to user after submitting the form
        trigger_error($this->user->lang('ACP_AUTOGROUPS_SUBMIT_SUCCESS') . adm_back_link($this->u_action));
    }
Ejemplo n.º 10
0
 /**
  * {@inheritdoc}
  */
 public function run()
 {
     $this->language->add_lang('migrator');
     if (!isset($this->config['version_update_from'])) {
         $this->config->set('version_update_from', $this->config['version']);
     }
     $original_version = $this->config['version_update_from'];
     $this->migrator->set_output_handler(new log_wrapper_migrator_output_handler($this->language, new installer_migrator_output_handler($this->iohandler), $this->phpbb_root_path . 'store/migrations_' . time() . '.log', $this->filesystem));
     $this->migrator->create_migrations_table();
     $migrations = $this->extension_manager->get_finder()->core_path('phpbb/db/migration/data/')->extension_directory('/migrations')->get_classes();
     $this->migrator->set_migrations($migrations);
     $migration_step_count = $this->installer_config->get('database_update_migration_steps', -1);
     if ($migration_step_count < 0) {
         $migration_step_count = count($this->migrator->get_installable_migrations()) * 2;
         $this->installer_config->set('database_update_migration_steps', $migration_step_count);
     }
     $progress_count = $this->installer_config->get('database_update_count', 0);
     $restart_progress_bar = $progress_count === 0;
     // Only "restart" when the update runs for the first time
     $this->iohandler->set_task_count($migration_step_count, $restart_progress_bar);
     $this->installer_config->set_task_progress_count($migration_step_count);
     while (!$this->migrator->finished()) {
         try {
             $this->migrator->update();
             $progress_count++;
             $last_run_migration = $this->migrator->get_last_run_migration();
             if (isset($last_run_migration['effectively_installed']) && $last_run_migration['effectively_installed']) {
                 // We skipped two step, so increment $progress_count by another one
                 $progress_count++;
             } else {
                 if ($last_run_migration['task'] === 'process_schema_step' && !$last_run_migration['state']['migration_schema_done'] || $last_run_migration['task'] === 'process_data_step' && !$last_run_migration['state']['migration_data_done']) {
                     // We just run a step that wasn't counted yet so make it count
                     $migration_step_count++;
                 }
             }
             $this->iohandler->set_task_count($migration_step_count);
             $this->installer_config->set_task_progress_count($migration_step_count);
             $this->iohandler->set_progress('STAGE_UPDATE_DATABASE', $progress_count);
         } catch (exception $e) {
             $msg = $e->getParameters();
             array_unshift($msg, $e->getMessage());
             $this->iohandler->add_error_message($msg);
             throw new user_interaction_required_exception();
         }
         if ($this->installer_config->get_time_remaining() <= 0 || $this->installer_config->get_memory_remaining() <= 0) {
             $this->installer_config->set('database_update_count', $progress_count);
             $this->installer_config->set('database_update_migration_steps', $migration_step_count);
             throw new resource_limit_reached_exception();
         }
     }
     if ($original_version !== $this->config['version']) {
         $this->log->add('admin', isset($this->user->data['user_id']) ? $this->user->data['user_id'] : ANONYMOUS, $this->user->ip, 'LOG_UPDATE_DATABASE', false, array($original_version, $this->config['version']));
     }
     $this->iohandler->add_success_message('INLINE_UPDATE_SUCCESSFUL');
     $this->config->delete('version_update_from');
     $this->cache->purge();
     $this->config->increment('assets_version', 1);
 }
Ejemplo n.º 11
0
 /**
  * Log failed login attempts for members of specific groups
  *
  * @param object $event The event object
  * @return null
  * @access public
  */
 public function log_failed_login_attempts($event)
 {
     if (!$this->config['sec_login_attempts']) {
         return;
     }
     if ($this->in_watch_group($event['result']['user_row']['user_id'])) {
         $this->log->add('user', $event['result']['user_row']['user_id'], $this->user->ip, 'LOG_TEAM_AUTH_FAIL', time(), array('reportee_id' => $event['result']['user_row']['user_id']));
     }
 }
 function main()
 {
     // Only registered users can go beyond this point
     if (!$this->user->data['is_registered']) {
         if ($this->user->data['is_bot']) {
             redirect(append_sid("{$this->phpbb_root_path}index.{$this->phpEx}"));
         }
         login_box('', $this->user->lang['LOGIN_INFO']);
     }
     $adm_points = $this->request->variable('adm_points', false);
     $u_id = $this->request->variable('user_id', 0);
     $post_id = $this->request->variable('post_id', 0);
     if (empty($u_id)) {
         $message = $this->user->lang['EDIT_NO_ID_SPECIFIED'] . '<br /><br /><a href="' . $this->helper->route('dmzx_ultimatepoints_controller', array('mode' => 'bank_edit')) . '">&laquo; ' . $this->user->lang['BACK_TO_PREV'] . '</a>';
         trigger_error($message);
     }
     $user_id = $u_id;
     add_form_key('bank_edit');
     if ($adm_points != false && ($this->auth->acl_get('a_') || $this->auth->acl_get('m_chg_bank'))) {
         $this->template->assign_block_vars('administer_bank', array());
         $submit = isset($_POST['submit']) ? true : false;
         if ($submit) {
             if (!check_form_key('bank_edit')) {
                 trigger_error('FORM_INVALID');
             }
             $new_points = round($this->request->variable('points', 0.0), 2);
             $this->functions_points->set_bank($u_id, $new_points);
             $sql_array = array('SELECT' => 'user_id, username, user_points, user_colour', 'FROM' => array(USERS_TABLE => 'u'), 'WHERE' => 'user_id = ' . (int) $u_id);
             $sql = $this->db->sql_build_query('SELECT', $sql_array);
             $result = $this->db->sql_query($sql);
             $points_user = $this->db->sql_fetchrow($result);
             // Add logs
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_MOD_BANK', false, array($points_user['username']));
             $message = $post_id ? sprintf($this->user->lang['EDIT_P_RETURN_POST'], '<a href="' . append_sid("{$this->phpbb_root_path}viewtopic.{$this->phpEx}", "p=" . $post_id) . '">', '</a>') : sprintf($this->user->lang['EDIT_P_RETURN_INDEX'], '<a href="' . append_sid("{$this->phpbb_root_path}index.{$this->phpEx}") . '">', '</a>');
             trigger_error(sprintf($this->user->lang['EDIT_POINTS_SET'], $this->config['points_name']) . $message);
         } else {
             $sql_array = array('SELECT' => 'u.user_id, u.username, u.user_points, u.user_colour, b.holding', 'FROM' => array(USERS_TABLE => 'u'), 'LEFT_JOIN' => array(array('FROM' => array($this->points_bank_table => 'b'), 'ON' => 'u.user_id = b.user_id')), 'WHERE' => 'u.user_id = ' . (int) $u_id);
             $sql = $this->db->sql_build_query('SELECT', $sql_array);
             $result = $this->db->sql_query($sql);
             $row = $this->db->sql_fetchrow($result);
             if (empty($u_id)) {
                 $message = $this->user->lang['EDIT_USER_NOT_EXIST'] . '<br /><br /><a href="' . $this->helper->route('dmzx_ultimatepoints_controller', array('mode' => 'bank_edit')) . '">&laquo; ' . $this->user->lang['BACK_TO_PREV'] . '</a>';
                 trigger_error($message);
             }
             $hidden_fields = build_hidden_fields(array('user_id' => $u_id, 'post_id' => $post_id));
             $this->template->assign_vars(array('USER_NAME' => get_username_string('full', $u_id, $row['username'], $row['user_colour']), 'BANK_POINTS' => sprintf($this->functions_points->number_format_points($row['holding'])), 'POINTS_NAME' => $this->config['points_name'], 'CURRENT_VALUE' => $row['holding'], 'L_POINTS_MODIFY' => sprintf($this->user->lang['EDIT_BANK_MODIFY'], $this->config['points_name']), 'L_P_BANK_TITLE' => sprintf($this->user->lang['EDIT_P_BANK_TITLE'], $this->config['points_name']), 'L_USERNAME' => $this->user->lang['USERNAME'], 'L_SET_AMOUNT' => $this->user->lang['EDIT_SET_AMOUNT'], 'U_USER_LINK' => append_sid("{$this->phpbb_root_path}memberlist.{$this->phpEx}", "mode=viewprofile&amp;u=" . $u_id), 'S_ACTION' => $this->helper->route('dmzx_ultimatepoints_controller', array('mode' => 'bank_edit', 'adm_points' => '1')), 'S_HIDDEN_FIELDS' => $hidden_fields));
         }
     }
     // Generate the page
     page_header($this->user->lang['EDIT_POINTS_ADMIN']);
     // Generate the page template
     $this->template->set_filenames(array('body' => 'points/points_bank_edit.html'));
     page_footer();
 }
Ejemplo n.º 13
0
 /**
  * Post to the shoutbox-app server
  *
  * @param array $data
  * @param string $path
  *
  * @return mixed
  */
 private function postData($data, $path)
 {
     $browser = new Browser(new Curl());
     try {
         $headers = array('Content-Type' => 'application/json');
         $data = @json_encode($data);
         /** @var \Buzz\Message\Response $response */
         $response = $browser->post($this->config['ajaxshoutbox_api_server'] . $path, $headers, $data);
         if ($response->isSuccessful()) {
             $rsp = $response->getContent();
             $rsp = @json_decode($rsp, true);
             if (isset($rsp['error'])) {
                 throw new \Exception(htmlspecialchars($rsp['error']));
                 // ;)
             }
             return $rsp;
         }
     } catch (\Exception $e) {
         $this->log->add('critical', $this->user->data['user_id'], $this->user->ip, 'LOG_AJAX_SHOUTBOX_ERROR', time(), array($e->getMessage()));
         return false;
     }
 }
Ejemplo n.º 14
0
 function main($id, $mode)
 {
     global $user, $template, $cache, $config, $phpbb_root_path, $phpEx, $phpbb_container, $request;
     $this->config = $config;
     $this->phpbb_container = $phpbb_container;
     $this->config_text = $this->phpbb_container->get('config_text');
     $this->log = $this->phpbb_container->get('log');
     $this->request = $request;
     $this->template = $template;
     $this->user = $user;
     $this->phpbb_root_path = $phpbb_root_path;
     $this->php_ext = $phpEx;
     $this->user->add_lang_ext('davidiq/reimg', 'reimg_acp');
     $this->tpl_name = 'reimg';
     $this->page_title = 'ACP_REIMG_SETTINGS';
     $form_name = 'acp_reimg';
     add_form_key($form_name);
     $reimg_swap_portrait = $this->request->variable('reimg_swap_portrait', (bool) $this->config['reimg_swap_portrait']);
     $reimg_resize_sig_img = $this->request->variable('reimg_resize_sig_img', (bool) $this->config['reimg_resize_sig_img']);
     $reimg_link = $this->request->variable('reimg_link', $this->config['reimg_link']);
     $reimg_zoom = $this->request->variable('reimg_zoom', $this->config['reimg_zoom']);
     $reimg_attachments = $this->request->variable('reimg_attachments', (bool) $this->config['reimg_attachments']);
     $reimg_for_all = $this->request->variable('reimg_for_all', (bool) $this->config['reimg_for_all']);
     if ($this->request->is_set_post('submit')) {
         if (!check_form_key($form_name)) {
             trigger_error($this->user->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         //Update configuration now
         $this->config->set('reimg_swap_portrait', $reimg_swap_portrait);
         $this->config->set('reimg_resize_sig_img', $reimg_resize_sig_img);
         $this->config->set('reimg_link', $reimg_link);
         $this->config->set('reimg_zoom', $reimg_zoom);
         $this->config->set('reimg_attachments', $reimg_attachments);
         $this->config->set('reimg_for_all', $reimg_for_all);
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_REIMG_UPDATED');
         trigger_error($user->lang['REIMG_UPDATED'] . adm_back_link($this->u_action));
     }
     $template->assign_vars(array('S_REIMG_SWAP_PORTRAIT' => $reimg_swap_portrait, 'S_REIMG_RESIZE_SIG_IMG' => $reimg_resize_sig_img, 'S_REIMG_LINK' => $this->select_reimg_link_method($reimg_link), 'S_REIMG_ZOOM' => $this->select_reimg_zoom_method($reimg_zoom), 'S_REIMG_ATTACHMENTS' => $reimg_attachments, 'S_REIMG_FOR_ALL' => $reimg_for_all, 'U_ACTION' => $this->u_action));
 }
Ejemplo n.º 15
0
 /**
  * Performs add|edit|del|clean|prune actions
  */
 public function mchat_action($action, $sql_ary = null, $message_id = 0, $log_username = '')
 {
     switch ($action) {
         // User adds a message
         case 'add':
             $sql = 'INSERT INTO ' . $this->mchat_table . ' ' . $this->db->sql_build_array('INSERT', $sql_ary);
             $this->mchat_add_user_session();
             break;
             // User edits a message
         // User edits a message
         case 'edit':
             $sql = 'UPDATE ' . $this->mchat_table . ' SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' WHERE message_id = ' . (int) $message_id;
             $this->mchat_add_user_session();
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_EDITED_MCHAT', false, array($log_username));
             break;
             // User deletes a message
         // User deletes a message
         case 'del':
             $sql = 'DELETE FROM ' . $this->mchat_table . ' WHERE message_id = ' . (int) $message_id;
             $this->mchat_add_user_session();
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_DELETED_MCHAT', false, array($log_username));
             $this->cache->destroy('sql', $this->mchat_table);
             break;
             // Founder purges all messages
         // Founder purges all messages
         case 'clean':
             $sql = 'TRUNCATE TABLE ' . $this->mchat_table;
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_MCHAT_TABLE_PRUNED');
             $this->cache->destroy('sql', $this->mchat_table);
             break;
             // User triggers messages to be pruned
         // User triggers messages to be pruned
         case 'prune':
             $sql = 'DELETE FROM ' . $this->mchat_table . ' WHERE message_id < ' . (int) $message_id;
             $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_MCHAT_TABLE_PRUNED');
             $this->cache->destroy('sql', $this->mchat_table);
             break;
         default:
             return;
     }
     $result = $this->db->sql_query($sql);
     if ($result !== false) {
         switch ($action) {
             case 'add':
                 if ($this->db->sql_nextid() == 1) {
                     $this->cache->destroy('sql', $this->mchat_table);
                 }
                 break;
         }
     }
 }
Ejemplo n.º 16
0
 /**
  * Sets the title of an idea.
  *
  * @param int    $idea_id ID of the idea to be updated.
  * @param string $title   New title.
  *
  * @return boolean True if updated, false if invalid length.
  */
 public function set_title($idea_id, $title)
 {
     if (utf8_clean_string($title) === '' || utf8_strlen($title) > 64) {
         return false;
     }
     $sql_ary = array('idea_title' => $title);
     $this->update_idea_data($sql_ary, $idea_id, 'table_ideas');
     // We also need to update the topic's title
     $idea = $this->get_idea($idea_id);
     $sql = 'UPDATE ' . TOPICS_TABLE . "\n\t\t\tSET topic_title='" . $this->db->sql_escape($title) . "'\n\t\t\tWHERE topic_id=" . (int) $idea['topic_id'];
     $this->db->sql_query($sql);
     $this->log->add('mod', $this->user->data['user_id'], $this->user->ip, 'ACP_PHPBB_IDEAS_TITLE_EDITED_LOG', time(), array($idea_id));
     return true;
 }
Ejemplo n.º 17
0
 /**
  * Main ACP module
  *
  * @param int $id
  * @param string $mode
  * @return null
  * @access public
  */
 public function main($id, $mode)
 {
     $this->tpl_name = 'acp_teamsecurity';
     $this->page_title = $this->user->lang('ACP_TEAM_SECURITY_SETTINGS');
     // Only allow founders to view/manage these settings
     if ($this->user->data['user_type'] != USER_FOUNDER) {
         trigger_error($this->user->lang('ACP_FOUNDER_MANAGE_ONLY'), E_USER_WARNING);
     }
     $form_key = 'acp_teamsecurity';
     add_form_key($form_key);
     if ($this->request->is_set_post('submit')) {
         if (!check_form_key($form_key)) {
             trigger_error($this->user->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         // Validate the email address submitted by the user
         $sec_contact = $this->request->variable('sec_contact', '');
         if ($sec_contact != '' && !preg_match('/^' . get_preg_expression('email') . '$/i', $sec_contact)) {
             trigger_error($this->user->lang('EMAIL_INVALID_EMAIL') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         $this->config->set('sec_contact', $sec_contact);
         $this->config->set('sec_contact_name', $this->request->variable('sec_contact_name', '', true));
         $this->config->set('sec_login_email', $this->request->variable('sec_login_email', 0));
         $this->config->set('sec_login_attempts', $this->request->variable('sec_login_attempts', 0));
         $this->config->set('sec_email_changes', $this->request->variable('sec_email_changes', 0));
         $this->config->set('sec_strong_pass', $this->request->variable('sec_strong_pass', 0));
         $this->config->set('sec_min_pass_chars', $this->request->variable('sec_min_pass_chars', 0));
         $this->config->set('sec_usergroups', json_encode($this->request->variable('sec_usergroups', array(0))));
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_TEAM_SEC_UPDATED');
         trigger_error($this->user->lang('CONFIG_UPDATED') . adm_back_link($this->u_action));
     }
     // Set template vars for usergroups multi-select box
     $group_id_ary = !$this->config['sec_usergroups'] ? array() : json_decode(trim($this->config['sec_usergroups']), true);
     $this->get_group_options($group_id_ary);
     // Set output vars for display in the template
     $this->template->assign_vars(array('S_ACP_LOGIN_EMAIL' => $this->config['sec_login_email'], 'ACP_CONTACT_EMAIL' => $this->config['sec_contact'], 'ACP_CONTACT_NAME' => $this->config['sec_contact_name'], 'S_ACP_LOGIN_ATTEMPTS' => $this->config['sec_login_attempts'], 'S_ACP_EMAIL_CHANGES' => $this->config['sec_email_changes'], 'S_ACP_STRONG_PASS' => $this->config['sec_strong_pass'], 'ACP_MIN_PASS_CHARS' => $this->config['sec_min_pass_chars'], 'U_ACTION' => $this->u_action));
 }
Ejemplo n.º 18
0
 /**
  * Get link's information and call appropriate action
  *
  * @param	array $mark Website selected for (dis)approval
  * @return	null
  */
 public function exec_action($mark)
 {
     $this->_get_infos_links($mark);
     switch ($this->action) {
         case 'approved':
             $this->_action_approved();
             break;
         case 'disapproved':
             $this->_action_disapproved();
             break;
         default:
             return;
     }
     $this->phpbb_log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_LINK_' . strtoupper($this->action), time(), array(implode(', ', $this->affected_link_name)));
 }
    function random_bonus_increment($user_id)
    {
        /**
         * Read out config values
         */
        $sql = 'SELECT *
			FROM ' . $this->points_values_table;
        $result = $this->db->sql_query($sql);
        $points_values = $this->db->sql_fetchrow($result);
        $this->db->sql_freeresult($result);
        $bonus_chance = '';
        $bonus = false;
        // Basic value, sorry..
        $bonus_value = 0.0;
        // Basic value
        // Following numbers are 'times 100' to get rid of commas, as mt_rand doesn't get comma numbers.
        $bonus_chance = $points_values['points_bonus_chance'] * 100;
        // The chance percentage for a user to get the bonus
        $random_number = mt_rand(0, 10000);
        // The random number we compare to the chance percentage
        if ($random_number <= $bonus_chance) {
            $bonus = true;
            // Check if we want a fixed bonus value or not
            if ($points_values['points_bonus_min'] == $points_values['points_bonus_max']) {
                $bonus_value = $points_values['points_bonus_min'];
            } else {
                // Create the bonus value, between the set minimum and maximum
                // Following numbers are 'times 100' to get rid of commas, as mt_rand doesn't get comma numbers.
                $bonus_random = mt_rand($points_values['points_bonus_min'] * 100, $points_values['points_bonus_max'] * 100) / 100;
                $bonus_value = round($bonus_random, 0, PHP_ROUND_HALF_UP);
            }
        }
        if ($bonus && $bonus_value) {
            $this->add_points((int) $user_id, $bonus_value);
            // Send out notification
            // Increase our notification sent counter
            $this->config->increment('points_notification_id', 1);
            // Store the notification data we will use in an array
            $data = array('points_notify_id' => (int) $this->config['points_notification_id'], 'points_notify_msg' => sprintf($this->user->lang['NOTIFICATION_RANDOM_BONUS'], $bonus_value, $this->config['points_name']), 'sender' => (int) $this->user->data['user_id'], 'receiver' => (int) $user_id, 'mode' => 'logs');
            $this->notification_manager->add_notifications('dmzx.ultimatepoints.notification.type.points', $data);
            $sql_array = array('SELECT' => 'username', 'FROM' => array(USERS_TABLE => 'u'), 'WHERE' => 'user_id = ' . (int) $user_id);
            $sql = $this->db->sql_build_query('SELECT', $sql_array);
            $result = $this->db->sql_query($sql);
            $points_user = $this->db->sql_fetchrow($result);
            // Add logs
            $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_MOD_POINTS_RANDOM', false, array($points_user['username']));
        }
    }
Ejemplo n.º 20
0
 /**
  * Send notification to users
  *
  * @param int $rule_id The rule identifier
  * @return null
  * @access public
  */
 public function send_notification($rule_id)
 {
     // Use a confirmation box routine when sending notifications
     if (confirm_box(true)) {
         // Increment our notifications sent counter
         $this->config->increment('boardrules_notification', 1);
         // Store the notification data we will use in an array
         $notification_data = array('rule_id' => $rule_id, 'notification_id' => $this->config['boardrules_notification']);
         // Create the notification
         $this->notification_manager->add_notifications('phpbb.boardrules.notification.type.boardrules', $notification_data);
         // Log the notification
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'ACP_BOARDRULES_NOTIFY_LOG');
     } else {
         // Request confirmation from the user to send notification to all users
         // Build a hidden array of the form data
         confirm_box(false, $this->user->lang('ACP_BOARDRULES_NOTIFY_CONFIRM'), build_hidden_fields(array('action_send_notification' => true, 'rule_id' => $rule_id)));
     }
 }
 /**
  * Activate user
  *
  * @param object $event The event object
  * @return null
  * @access public
  */
 private function user_justification_activate()
 {
     $user = $this->data;
     if (!function_exists('user_active_flip')) {
         include $this->root_path . 'includes/functions_user.' . $this->php_ext;
     }
     if (!class_exists('messenger')) {
         include $this->root_path . 'includes/functions_messenger.' . $this->php_ext;
     }
     user_active_flip('activate', $user['user_id']);
     $messenger = new \messenger(false);
     $messenger->template('admin_welcome_activated', $user['user_lang']);
     $messenger->to($user['user_email'], $user['username']);
     $messenger->anti_abuse_headers($this->config, $this->user);
     $messenger->assign_vars(array('USERNAME' => htmlspecialchars_decode($user['username'])));
     $messenger->send(NOTIFY_EMAIL);
     $messenger->save_queue();
     $this->log->add('user', $this->user->data['user_id'], $this->user->ip, 'LOG_USER_ACTIVE', time(), array($user['username']));
 }
    /**
     * Clear user reputation
     *
     * @param int $user_id User id
     * @param array $data Reputation data
     * @param arrat $post_ids Post IDs
     * @access public
     * @return null
     */
    public function clear_user_reputation($user_id, $data, $post_ids)
    {
        // Required fields
        $fields = array('user_id_to', 'reputation_item_id');
        foreach ($fields as $field) {
            if (!isset($data[$field])) {
                throw new \pico\reputation\exception\invalid_argument(array($field, 'FIELD_MISSING'));
            }
        }
        $sql = 'UPDATE ' . USERS_TABLE . "\n\t\t\tSET user_reputation = 0\n\t\t\tWHERE user_id = {$user_id}";
        $this->db->sql_query($sql);
        $sql = 'UPDATE ' . POSTS_TABLE . '
			SET post_reputation = 0
			WHERE ' . $this->db->sql_in_set('post_id', $post_ids, false, true);
        $this->db->sql_query($sql);
        $sql = 'DELETE FROM ' . $this->reputations_table . "\n\t\t\tWHERE user_id_to = {$user_id}";
        $this->db->sql_query($sql);
        $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_USER_REPUTATION_CLEARED', false, array('user_id_to' => isset($data['username_to']) ? $data['username_to'] : $data['user_id_to']));
    }
 /**
  * Display the options a user can configure for this extension
  *
  * @return null
  * @access public
  */
 public function display_options()
 {
     // Add the language file
     $this->language->add_lang('acp_autobackup', 'david63/autodbbackup');
     // Create a form key for preventing CSRF attacks
     $form_key = 'auto_db_backup';
     add_form_key($form_key);
     $this->get_filetypes();
     $time = time();
     // Submit
     if ($this->request->is_set_post('submit')) {
         // Is the submitted form is valid?
         if (!check_form_key($form_key)) {
             trigger_error($this->language->lang('FORM_INVALID') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         // Get the date/time variables
         $day = $this->request->variable('auto_db_backup_day', 0);
         $month = $this->request->variable('auto_db_backup_month', 0);
         $year = $this->request->variable('auto_db_backup_year', 0);
         $hour = $this->request->variable('auto_db_backup_hour', 0);
         $minute = $this->request->variable('auto_db_backup_minute', 0);
         $enable = $this->request->variable('auto_db_backup_enable', 0);
         // Let's do a bit of validation
         if (!checkdate($month, $day, $year)) {
             trigger_error($this->language->lang('DATE_TIME_ERROR') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         $dst = date('I', $time);
         $this->backup_date = mktime($hour + $dst, $minute, 0, $month, $day, $year);
         // Skip this check if disabling
         if ($enable && $this->backup_date <= $time) {
             trigger_error($this->language->lang('AUTO_DB_BACKUP_TIME_ERROR') . adm_back_link($this->u_action), E_USER_WARNING);
         }
         // Set the options the user has configured
         $this->set_options();
         // Add option settings change action to the admin log
         $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_AUTO_DB_BACKUP_SETTINGS');
         trigger_error($this->language->lang('AUTO_DB_BACKUP_SETTINGS_CHANGED') . adm_back_link($this->u_action));
     }
     $next_backup_date = $this->config['auto_db_backup_last_gc'] > $time ? getdate($this->config['auto_db_backup_last_gc']) : getdate($this->config['auto_db_backup_last_gc'] + $this->config['auto_db_backup_gc']);
     // Output the page
     $this->template->assign_vars(array('AUTO_DB_BACKUP_COPIES' => $this->config['auto_db_backup_copies'], 'AUTO_DB_BACKUP_DAY' => $next_backup_date['mday'], 'AUTO_DB_BACKUP_GC' => $this->config['auto_db_backup_gc'] / 3600, 'AUTO_DB_BACKUP_HOUR' => $next_backup_date['hours'], 'AUTO_DB_BACKUP_MINUTE' => $next_backup_date['minutes'], 'AUTO_DB_BACKUP_MONTH' => $next_backup_date['mon'], 'AUTO_DB_BACKUP_VERSION' => ext::AUTO_DB_BACKUP_VERSION, 'AUTO_DB_BACKUP_YEAR' => $next_backup_date['year'], 'S_AUTO_DB_BACKUP_ENABLE' => $this->config['auto_db_backup_enable'], 'S_AUTO_DB_BACKUP_OPTIMIZE' => $this->config['auto_db_backup_optimize'], 'U_ACTION' => $this->u_action, 'YEAR_START' => $next_backup_date['year'], 'YEAR_END' => $next_backup_date['year'] + 1));
 }
Ejemplo n.º 24
0
 /**
  * Delete a page
  *
  * @param int $page_id The page identifier to delete
  * @return null
  * @access public
  */
 public function delete_page($page_id)
 {
     // Initiate and load the page entity
     /* @var $entity \phpbb\pages\entity\page */
     $entity = $this->container->get('phpbb.pages.entity')->load($page_id);
     try {
         // Delete the page
         $this->page_operator->delete_page($page_id);
     } catch (\phpbb\pages\exception\base $e) {
         // Display an error message if delete failed
         trigger_error($this->user->lang('ACP_PAGES_DELETE_ERRORED') . adm_back_link($this->u_action), E_USER_WARNING);
     }
     // Log the action
     $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'ACP_PAGES_DELETED_LOG', time(), array($entity->get_title()));
     // If AJAX was used, show user a result message
     if ($this->request->is_ajax()) {
         $json_response = new \phpbb\json_response();
         $json_response->send(array('MESSAGE_TITLE' => $this->user->lang('INFORMATION'), 'MESSAGE_TEXT' => $this->user->lang('ACP_PAGES_DELETE_SUCCESS'), 'REFRESH_DATA' => array('time' => 3)));
     }
 }
    /**
     * Delete a flag
     *
     * @param int $flag_id The flag identifier to delete
     * @return null
     * @access public
     */
    public function delete_flag($flag_id)
    {
        if (confirm_box(true)) {
            // Grab the flag name for the log...
            $sql = 'SELECT flag_name, flag_image
				FROM ' . $this->flags_table . '
				WHERE flag_id = ' . (int) $flag_id;
            $result = $this->db->sql_query($sql);
            $flag_row = $this->db->sql_fetchrow($result);
            $this->db->sql_freeresult($result);
            // Delete the flag...
            $sql = 'DELETE FROM ' . $this->flags_table . '
				WHERE flag_id = ' . (int) $flag_id;
            $this->db->sql_query($sql);
            // Reset the flag for users
            $sql = 'UPDATE ' . USERS_TABLE . '
				SET user_flag = 0
				WHERE user_flag = ' . (int) $flag_id;
            $this->db->sql_query($sql);
            $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_FLAGS_DELETED', time(), array($flag_row['flag_name']));
            $this->cache->destroy('_user_flags');
            $this->functions->cache_flags();
            trigger_error($this->user->lang['MSG_FLAGS_DELETED'] . adm_back_link($this->u_action . "&amp;mode=manage"));
        } else {
            // display a count of users who have this flag
            $sql = 'SELECT COUNT(user_flag) AS flag_count
				FROM ' . USERS_TABLE . '
				WHERE user_flag = ' . (int) $flag_id;
            $result = $this->db->sql_query($sql);
            $row = $this->db->sql_fetchrow($result);
            $this->db->sql_freeresult($result);
            $message = $this->user->lang['MSG_CONFIRM'];
            if (!empty($row['flag_count'])) {
                $message .= $row['flag_count'] != 1 ? $this->user->lang('MSG_FLAGS_CONFIRM_DELETE', $row['flag_count']) : $this->user->lang('MSG_FLAG_CONFIRM_DELETE', $row['flag_count']);
            }
            confirm_box(false, $message, build_hidden_fields(array('id' => (int) $flag_id, 'mode' => 'manage', 'action' => 'delete')));
            // Use a redirect to take the user back to the previous page
            // if the user chose not delete the flag from the confirmation page.
            redirect("{$this->u_action}");
        }
    }
 private function get_file($url)
 {
     // We'll use curl..most servers have it installed as default
     if (function_exists('curl_init')) {
         $ch = curl_init();
         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
         curl_setopt($ch, CURLOPT_URL, $url);
         curl_setopt($ch, CURLOPT_TIMEOUT, 5);
         curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
         $contents = curl_exec($ch);
         $httpcode = curl_getinfo($ch, CURLINFO_HTTP_CODE);
         curl_close($ch);
         // if nothing is returned (SFS is down)
         if ($httpcode != 200) {
             return false;
         }
         return $contents;
     }
     $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_SFS_NEED_CURL', time());
     return false;
 }
Ejemplo n.º 27
0
 /**
  * {@inheritdoc}
  */
 public function run()
 {
     $this->language->add_lang('migrator');
     if (!isset($this->config['version_update_from'])) {
         $this->config->set('version_update_from', $this->config['version']);
     }
     $original_version = $this->config['version_update_from'];
     $this->migrator->set_output_handler(new log_wrapper_migrator_output_handler($this->language, new installer_migrator_output_handler($this->iohandler), $this->phpbb_root_path . 'store/migrations_' . time() . '.log', $this->filesystem));
     $this->migrator->create_migrations_table();
     $migrations = $this->extension_manager->get_finder()->core_path('phpbb/db/migration/data/')->extension_directory('/migrations')->get_classes();
     $this->migrator->set_migrations($migrations);
     $migration_count = count($this->migrator->get_migrations());
     $this->iohandler->set_task_count($migration_count, true);
     $progress_count = $this->installer_config->get('database_update_count', 0);
     while (!$this->migrator->finished()) {
         try {
             $this->migrator->update();
             $progress_count++;
             $this->iohandler->set_progress('STAGE_UPDATE_DATABASE', $progress_count);
         } catch (exception $e) {
             $msg = $e->getParameters();
             array_unshift($msg, $e->getMessage());
             $this->iohandler->add_error_message($msg);
             $this->iohandler->send_response();
             throw new user_interaction_required_exception();
         }
         if ($this->installer_config->get_time_remaining() <= 0 || $this->installer_config->get_memory_remaining() <= 0) {
             $this->installer_config->set('database_update_count', $progress_count);
             throw new resource_limit_reached_exception();
         }
     }
     if ($original_version !== $this->config['version']) {
         $this->log->add('admin', isset($this->user->data['user_id']) ? $this->user->data['user_id'] : ANONYMOUS, $this->user->ip, 'LOG_UPDATE_DATABASE', false, array($original_version, $this->config['version']));
     }
     $this->iohandler->finish_progress('INLINE_UPDATE_SUCCESSFUL');
     $this->iohandler->add_success_message('INLINE_UPDATE_SUCCESSFUL');
     $this->config->delete('version_update_from');
     $this->cache->purge();
     $this->config->increment('assets_version', 1);
 }
Ejemplo n.º 28
0
    /**
     * Set ideas forum options
     *
     * @return void
     * @access public
     */
    public function set_ideas_forum_options()
    {
        // Check if Ideas forum is selected and apply relevant settings if it is
        // But display the confirm box first
        if (confirm_box(true)) {
            if (empty($this->config['ideas_forum_id'])) {
                trigger_error($this->language->lang('ACP_IDEAS_NO_FORUM') . adm_back_link($this->u_action), E_USER_WARNING);
            }
            if (!class_exists('auth_admin')) {
                include $this->phpbb_root_path . 'includes/acp/auth.' . $this->php_ext;
            }
            $auth_admin = new \auth_admin();
            $forum_id = (int) $this->config['ideas_forum_id'];
            // Get the REGISTERED usergroup ID
            $sql = 'SELECT group_id
				FROM ' . GROUPS_TABLE . "\n\t\t\t\tWHERE group_name = '" . $this->db->sql_escape('REGISTERED') . "'";
            $this->db->sql_query($sql);
            $group_id = (int) $this->db->sql_fetchfield('group_id');
            // Get 'f_' local REGISTERED users group permissions array for the ideas forum
            // Default undefined permissions to ACL_NO
            $hold_ary = $auth_admin->get_mask('set', false, $group_id, $forum_id, 'f_', 'local', ACL_NO);
            $auth_settings = $hold_ary[$group_id][$forum_id];
            // Set 'Can start new topics' permissions to 'Never' for the ideas forum
            $auth_settings['f_post'] = ACL_NEVER;
            // Update the registered usergroup permissions for selected Ideas forum...
            $auth_admin->acl_set('group', $forum_id, $group_id, $auth_settings);
            // Disable auto-pruning for ideas forum
            $sql = 'UPDATE ' . FORUMS_TABLE . '
				SET ' . $this->db->sql_build_array('UPDATE', array('enable_prune' => false)) . '
				WHERE forum_id = ' . $forum_id;
            $this->db->sql_query($sql);
            $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'ACP_PHPBB_IDEAS_FORUM_SETUP_LOG');
            trigger_error($this->language->lang('ACP_IDEAS_FORUM_SETUP_UPDATED') . adm_back_link($this->u_action));
        } else {
            confirm_box(false, $this->language->lang('ACP_IDEAS_FORUM_SETUP_CONFIRM'), build_hidden_fields(array('ideas_forum_setup' => $this->request->is_set_post('ideas_forum_setup'))));
        }
    }
Ejemplo n.º 29
0
    /**
     * The main cron task code.
     */
    public function cron_tidy_warnings($topic_ids = array())
    {
        $warning_list = $user_list = $unban_list = array();
        $current_time = time();
        $sql = 'SELECT * FROM ' . WARNINGS_TABLE . "\n\t\t\tWHERE warning_end < {$current_time} \n\t\t\tAND warning_end > 0 \n\t\t\tAND warning_status = 1";
        $result = $this->db->sql_query($sql);
        while ($row = $this->db->sql_fetchrow($result)) {
            $warning_list[] = $row['warning_id'];
            $user_list[$row['user_id']] = isset($user_list[$row['user_id']]) ? ++$user_list[$row['user_id']] : 1;
        }
        $this->db->sql_freeresult($result);
        if (sizeof($warning_list)) {
            $this->db->sql_transaction('begin');
            $sql = 'UPDATE ' . WARNINGS_TABLE . ' SET warning_status = 0
				WHERE ' . $this->db->sql_in_set('warning_id', $warning_list);
            $this->db->sql_query($sql);
            foreach ($user_list as $user_id => $value) {
                $sql = 'UPDATE ' . USERS_TABLE . " SET user_warnings = user_warnings - {$value}\n\t\t\t\t\tWHERE user_id = {$user_id}";
                $this->db->sql_query($sql);
            }
            // Try to get storage engine type to detect if transactions are supported
            // to apply proper bans selection (MyISAM/InnoDB)
            $operator = '<';
            /* Comment out this part of code for now as get_table_status()
            			* as unavailable for \phpbb\db\driver\driver_interface
            			if (strpos($this->db->get_sql_layer(), 'mysql') !== false)
            			{
            				$table_status = $this->db->get_table_status(USERS_TABLE);
            				if (isset($table_status['Engine']))
            				{
            					$operator = ($table_status['Engine'] === 'MyISAM') ? '<' : '<=';
            				}
            			}
            			*/
            $sql = 'SELECT u.user_id, b.ban_id FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . " b\n\t\t\t\tWHERE u.user_ban_id = 1\n\t\t\t\t\tAND u.user_warnings {$operator} " . (int) $this->config['warnings_for_ban'] . '
					AND u.user_id = b.ban_userid';
            $result = $this->db->sql_query($sql);
            while ($row = $this->db->sql_fetchrow($result)) {
                $unban_list[(int) $row['user_id']] = (int) $row['ban_id'];
            }
            $this->db->sql_freeresult($result);
            if (sizeof($unban_list)) {
                $sql = 'UPDATE ' . USERS_TABLE . ' SET user_ban_id = 0
					WHERE ' . $this->db->sql_in_set('user_id', array_keys($unban_list));
                $this->db->sql_query($sql);
                $sql = 'SELECT u.username AS unban_info, u.user_id
					FROM ' . USERS_TABLE . ' u, ' . BANLIST_TABLE . ' b
					WHERE ' . $this->db->sql_in_set('b.ban_id', $unban_list) . '
						AND u.user_id = b.ban_userid';
                $result = $this->db->sql_query($sql);
                $l_unban_list = '';
                $user_ids_ary = array();
                while ($row = $this->db->sql_fetchrow($result)) {
                    $l_unban_list .= ($l_unban_list != '' ? ', ' : '') . $row['unban_info'];
                    $user_ids_ary[] = $row['user_id'];
                }
                $this->db->sql_freeresult($result);
                $sql = 'DELETE FROM ' . BANLIST_TABLE . '
					WHERE ' . $this->db->sql_in_set('ban_id', $unban_list);
                $this->db->sql_query($sql);
                // Add to moderator log, admin log and user notes
                $this->phpbb_log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_UNBAN_USER', false, $l_unban_list);
                $this->phpbb_log->add('mod', 0, 0, 'LOG_UNBAN_USER', false, $l_unban_list);
                foreach ($user_ids_ary as $user_id) {
                    $this->phpbb_log->add('user', $user_id, 0, 'LOG_UNBAN_USER', false, $l_unban_list);
                }
            }
            $this->db->sql_transaction('commit');
        }
        $this->cache->destroy('sql', array(WARNINGS_TABLE, BANLIST_TABLE));
        $this->config->set('warnings_last_gc', time(), true);
    }
Ejemplo n.º 30
0
    /**
     * Main ACP module
     *
     * @param int $id
     * @param string $mode
     * @access public
     */
    public function main($id, $mode)
    {
        $form_key = 'acp_similar_topics';
        add_form_key($form_key);
        $action = $this->request->variable('action', '');
        switch ($action) {
            case 'advanced':
                $forum_id = $this->request->variable('f', 0);
                if ($this->request->is_set_post('submit')) {
                    $this->check_form_key($form_key);
                    $similar_topic_forums = implode(',', $this->request->variable('similar_forums_id', array(0)));
                    $this->validate_config_length($similar_topic_forums);
                    $sql = 'UPDATE ' . FORUMS_TABLE . "\n\t\t\t\t\t\tSET similar_topic_forums = '" . $this->db->sql_escape($similar_topic_forums) . "'\n\t\t\t\t\t\tWHERE forum_id = {$forum_id}";
                    $this->db->sql_query($sql);
                    $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');
                    trigger_error($this->user->lang('PST_SAVED') . adm_back_link($this->u_action));
                }
                $forum_name = '';
                $selected = array();
                if ($forum_id > 0) {
                    $sql = 'SELECT forum_name, similar_topic_forums
						FROM ' . FORUMS_TABLE . "\n\t\t\t\t\t\tWHERE forum_id = {$forum_id}";
                    $result = $this->db->sql_query($sql);
                    while ($fid = $this->db->sql_fetchrow($result)) {
                        $selected = explode(',', trim($fid['similar_topic_forums']));
                        $forum_name = $fid['forum_name'];
                    }
                    $this->db->sql_freeresult($result);
                }
                $this->template->assign_vars(array('S_ADVANCED_SETTINGS' => true, 'SIMILAR_FORUMS_OPTIONS' => make_forum_select($selected, false, false, true), 'PST_FORUM_NAME' => $forum_name, 'PST_ADVANCED_EXP' => $this->user->lang('PST_ADVANCED_EXP', $forum_name), 'U_ACTION' => $this->u_action . '&amp;action=advanced&amp;f=' . $forum_id, 'U_BACK' => $this->u_action));
                break;
            default:
                if ($this->request->is_set_post('submit')) {
                    $this->check_form_key($form_key);
                    // Get checkbox array form data and check string length
                    $mark_noshow_forum = implode(',', $this->request->variable('mark_noshow_forum', array(0), true));
                    $mark_ignore_forum = implode(',', $this->request->variable('mark_ignore_forum', array(0), true));
                    $this->validate_config_length($mark_noshow_forum, $mark_ignore_forum);
                    // Set basic config settings
                    $this->config->set('similar_topics', $this->request->variable('pst_enable', 0));
                    $this->config->set('similar_topics_limit', abs($this->request->variable('pst_limit', 0)));
                    // use abs for positive values only
                    $this->config->set('similar_topics_cache', abs($this->request->variable('pst_cache', 0)));
                    // use abs for positive values only
                    $this->config->set('similar_topics_words', $this->request->variable('pst_words', '', true));
                    $this->config->set('similar_topics_hide', $mark_noshow_forum);
                    $this->config->set('similar_topics_ignore', $mark_ignore_forum);
                    // Set date/time config settings
                    $pst_time = abs($this->request->variable('pst_time', 0));
                    // use abs for positive values only
                    $pst_time_type = $this->request->variable('pst_time_type', '');
                    $this->config->set('similar_topics_type', $pst_time_type);
                    $this->config->set('similar_topics_time', $this->set_pst_time($pst_time, $pst_time_type));
                    $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_MSG');
                    trigger_error($this->user->lang('PST_SAVED') . adm_back_link($this->u_action));
                }
                // Allow option to update the database to enable FULLTEXT support
                if ($this->request->is_set_post('fulltext')) {
                    if (confirm_box(true)) {
                        // If FULLTEXT is not supported, lets make it so
                        if (!$this->fulltext_support_enabled()) {
                            // Alter the database to support FULLTEXT
                            $this->enable_fulltext_support();
                            // Store the original database storage engine in a config var for recovery on uninstall
                            $this->config->set('similar_topics_fulltext', (string) $this->fulltext->get_engine());
                            $this->log->add('admin', $this->user->data['user_id'], $this->user->ip, 'PST_LOG_FULLTEXT', time(), array(TOPICS_TABLE));
                            trigger_error($this->user->lang('PST_SAVE_FULLTEXT') . adm_back_link($this->u_action));
                        } else {
                            trigger_error($this->user->lang('PST_ERR_FULLTEXT') . adm_back_link($this->u_action), E_USER_WARNING);
                        }
                    } else {
                        confirm_box(false, $this->user->lang('CONFIRM_OPERATION'), build_hidden_fields(array('fulltext' => 1)));
                    }
                }
                // Build the time options select menu
                $time_options = array('d' => $this->user->lang('PST_DAYS'), 'w' => $this->user->lang('PST_WEEKS'), 'm' => $this->user->lang('PST_MONTHS'), 'y' => $this->user->lang('PST_YEARS'));
                foreach ($time_options as $value => $label) {
                    $this->template->assign_block_vars('similar_time_options', array('VALUE' => $value, 'LABEL' => $label, 'S_SELECTED' => $value == $this->config['similar_topics_type']));
                }
                $this->template->assign_vars(array('S_PST_ENABLE' => $this->isset_or_default($this->config['similar_topics'], false), 'PST_LIMIT' => $this->isset_or_default($this->config['similar_topics_limit'], ''), 'PST_CACHE' => $this->isset_or_default($this->config['similar_topics_cache'], ''), 'PST_WORDS' => $this->isset_or_default($this->config['similar_topics_words'], ''), 'PST_TIME' => $this->get_pst_time($this->config['similar_topics_time'], $this->config['similar_topics_type']), 'S_PST_NO_SUPPORT' => !$this->fulltext_support_enabled(), 'S_PST_NO_MYSQL' => !$this->fulltext->is_mysql(), 'U_ACTION' => $this->u_action));
                $ignore_forums = explode(',', trim($this->config['similar_topics_ignore']));
                $noshow_forums = explode(',', trim($this->config['similar_topics_hide']));
                $forum_list = $this->get_forum_list();
                foreach ($forum_list as $row) {
                    $this->template->assign_block_vars('forums', array('FORUM_NAME' => $row['forum_name'], 'FORUM_ID' => $row['forum_id'], 'CHECKED_IGNORE_FORUM' => in_array($row['forum_id'], $ignore_forums) ? 'checked="checked"' : '', 'CHECKED_NOSHOW_FORUM' => in_array($row['forum_id'], $noshow_forums) ? 'checked="checked"' : '', 'S_IS_ADVANCED' => (bool) $row['similar_topic_forums'], 'U_ADVANCED' => "{$this->u_action}&amp;action=advanced&amp;f=" . $row['forum_id'], 'U_FORUM' => append_sid("{$this->root_path}viewforum.{$this->php_ext}", 'f=' . $row['forum_id'])));
                }
                break;
        }
    }