<?php
    define('IN_PHPBB', true);
    $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './forum/';
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    require($phpbb_root_path . 'common.' . $phpEx);
    require($phpbb_root_path . 'includes/functions_user.' . $phpEx);
    require($phpbb_root_path . 'includes/functions_module.' . $phpEx);

function forumRegister($user_name, $password, $email, $coppa = false) {

    global $db, $template, $config, $auth, $phpEx, $phpbb_root_path, $cache, $user;
    $_REQUEST['username'] = $_POST['username'] = $user_name;
    $_REQUEST['email'] = $_REQUEST['email_confirm'] = $_POST['email'] = $_POST['email_confirm'] = $email;
    $_REQUEST['new_password'] = $_REQUEST['password_confirm'] = $_POST['new_password'] = $_POST['password_confirm'] = $password;

    // Start session management
    $user->session_begin();
    $auth->acl($user->data);
    $user->setup();

    $timezone = date('Z') / 3600;
    $is_dst = date('I');

    if ($config['board_timezone'] == $timezone || $config['board_timezone'] == ($timezone - 1)) {
        $timezone = ($is_dst) ? $timezone - 1 : $timezone;

        if (!isset($user->lang['tz_zones'][(string) $timezone])) {
            $timezone = $config['board_timezone'];
        }
    } else {
        $is_dst = $config['board_dst'];
        $timezone = $config['board_timezone'];
    }

    $data = array(
        'username' => utf8_normalize_nfc(request_var('username', '', true)),
        'new_password' => request_var('new_password', '', true),
        'password_confirm' => request_var('password_confirm', '', true),
        'email' => strtolower(request_var('email', '')),
        'email_confirm' => strtolower(request_var('email_confirm', '')),
        'lang' => basename(request_var('lang', $user->lang_name)),
        'tz' => request_var('tz', (float) $timezone),
    );

    $server_url = generate_board_url();
    // Which group by default?
    $group_name = ($coppa) ? 'REGISTERED_COPPA' : 'REGISTERED';

    $sql = 'SELECT group_id
      FROM ' . GROUPS_TABLE . "
      WHERE group_name = '" . $db->sql_escape($group_name) . "'
         AND group_type = " . GROUP_SPECIAL;
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $db->sql_freeresult($result);

    $group_id = $row['group_id'];

    if (($coppa ||
            $config['require_activation'] == USER_ACTIVATION_SELF ||
            $config['require_activation'] == USER_ACTIVATION_ADMIN) && $config['email_enable']) {
        $user_actkey = gen_rand_string(10);
        $key_len = 54 - (strlen($server_url));
        $key_len = ($key_len < 6) ? 6 : $key_len;
        $user_actkey = substr($user_actkey, 0, $key_len);

        $user_type = USER_INACTIVE;
        $user_inactive_reason = INACTIVE_REGISTER;
        $user_inactive_time = time();
    } else {
        $user_type = USER_NORMAL;
        $user_actkey = '';
        $user_inactive_reason = 0;
        $user_inactive_time = 0;
    }

    $user_row = array(
        'username' => $data['username'],
        'user_password' => phpbb_hash($data['new_password']),
        'user_email' => $data['email'],
        'group_id' => (int) $group_id,
        'user_timezone' => (float) $data['tz'],
        'user_dst' => $is_dst,
        'user_lang' => $data['lang'],
        'user_type' => $user_type,
        'user_actkey' => $user_actkey,
        'user_ip' => $user->ip,
        'user_regdate' => time(),
        'user_inactive_reason' => $user_inactive_reason,
        'user_inactive_time' => $user_inactive_time,
    );

    $user_id = user_add($user_row);
}

//edit user profile
function forumEdit($user_id, $email, $password, $cu_password="")
{
    global $db, $template, $config, $auth, $phpEx, $phpbb_root_path, $cache, $user;

   $user->session_begin();
   $auth->acl($user->data);
   $user->setup();

   $sql = 'SELECT user_id FROM ' . USERS_TABLE . " WHERE username = '" . $db->sql_escape($user_id) . "' ";
   $result = $db->sql_query($sql);
   $row = $db->sql_fetchrow($result);
   $db->sql_freeresult($result);
   $uid = $row[user_id];

    if(!$uid)
      exit();

    if(!$cu_password ){

        $sql_ary1 = $sql_ary2 = array();

      $sql_ary1 = array(
         'user_email'      => $email,
         'user_email_hash'   => crc32($email) . strlen($email)
      );

        if($password){
         $sql_ary2 = array(
            'user_password'      => phpbb_hash($password) ,
            'user_passchg'      => time()
         );
       }

        $sql_ary = array_merge($sql_ary1,$sql_ary2);
      if (sizeof($sql_ary))
      {
         $sql = 'UPDATE ' . USERS_TABLE . '
            SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
            WHERE user_id = ' . $uid;
         $db->sql_query($sql);
      }

   }
   else{

      if (!$user->data['user_password']){
         forumLogin($user_id,$cu_password,false);
         $user->session_begin();
         $auth->acl($user->data);
         $user->setup();
      }

      if ($user->data['user_password']){

         $_REQUEST['email'] = $_REQUEST['email_confirm'] = $_POST['email']= $_POST['email_confirm']= $email;
         $_REQUEST['new_password'] = $_REQUEST['password_confirm'] = $_POST['new_password']= $_POST['password_confirm']= $password;

         $data = array(
            'email'            => strtolower(request_var('email', $user->data['user_email'])),
            'email_confirm'      => strtolower(request_var('email_confirm', '')),
            'new_password'      => request_var('new_password', '', true),
            'password_confirm'   => request_var('password_confirm', '', true),
         );

         $sql_ary = array(
            'user_email'      => ($auth->acl_get('u_chgemail')) ? $data['email'] : $user->data['user_email'],
            'user_email_hash'   => ($auth->acl_get('u_chgemail')) ? crc32($data['email']) . strlen($data['email']) : $user->data['user_email_hash'],
            'user_password'      => ($auth->acl_get('u_chgpasswd') && $data['new_password']) ? phpbb_hash($data['new_password']) : $user->data['user_password'],
            'user_passchg'      => ($auth->acl_get('u_chgpasswd') && $data['new_password']) ? time() : 0,
         );

         if (sizeof($sql_ary))
         {
            $sql = 'UPDATE ' . USERS_TABLE . '
               SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
               WHERE user_id = ' . $uid;
            $db->sql_query($sql);
         }

      }
   }
}


echo $_POST["username"];
echo('testing');