WB 2.11.0

<?php

/**

 *

 * @category        admin

 * @package         users

 * @author          WebsiteBaker Project

 * @copyright       Ryan Djurovich

 * @copyright       WebsiteBaker Org. e.V.

 * @link            http://websitebaker.org/

 * @license         http://www.gnu.org/licenses/gpl.html

 * @platform        WebsiteBaker 2.8.3

 * @requirements    PHP 5.3.6 and higher

 * @version         $Id: add.php 2 2017-07-02 15:14:29Z Manuela $

 * @filesource      $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/branches/main/admin/users/add.php $

 * @lastmodified    $Date: 2017-07-02 17:14:29 +0200 (Sun, 02 Jul 2017) $

 *

 */

// Print admin header

if ( !defined( 'WB_PATH' ) ){ require( dirname(dirname((__DIR__))).'/config.php' ); }

if ( !class_exists('admin', false) ) { require(WB_PATH.'/framework/class.admin.php'); }

// suppress to print the header, so no new FTAN will be set

$admin = new admin('Access', 'users_add',false);

$aErrorMessage = array();

$oTrans = Translate::getInstance();

$oTrans->enableAddon(ADMIN_DIRECTORY.'\\users');

// Create a javascript back link

$js_back = ADMIN_URL.'/users/index.php';

if( !$admin->checkFTAN() )

{

    $admin->print_header();

    $sInfo = strtoupper(basename(__DIR__).'_'.basename(__FILE__, ''.PAGE_EXTENSION).'::');

    $sDEBUG=(@DEBUG?$sInfo:'');

    $admin->print_error($sDEBUG.$oTrans->MESSAGE_GENERIC_SECURITY_ACCESS, $js_back );

}

// After check print the header

$admin->print_header();

/**

 * $sLanguagesAddonDefaultFile = WB_PATH.'/account/languages/EN.php';

 * if (is_readable($sLanguagesAddonDefaultFile)){include $sLanguagesAddonDefaultFile;}

 * $sLanguagesAddonFile = WB_PATH.'/account/languages/'.LANGUAGE.'.php';

 * if (is_readable($sLanguagesAddonFile)){include $sLanguagesAddonFile;}

 */

/*

print '<pre  class="mod-pre rounded">function <span>'.__FUNCTION__.'( '.''.' );</span>  filename: <span>'.basename(__FILE__).'</span>  line: '.__LINE__.' -> <br />';

print_r( $oTrans ); print '</pre>'; flush (); //  ob_flush();;sleep(10); die();

*/

$aInputs = array();

$aInputs = array_merge( $_POST );

// Get details entered

$groups_id = ( isset($aInputs['groups']) ? implode(",", $aInputs['groups']) : '');

$active = intval( is_array($aInputs['active'])  ?($aInputs['active'][0]):$aInputs['active']);

$username_fieldname = $admin->get_post('username_fieldname');

$username = strtolower($admin->get_post($username_fieldname));

$password = $admin->get_post('password');

$password2 = $admin->get_post('password2');

$display_name = $admin->StripCodeFromText($admin->get_post('display_name'));

$email = $admin->StripCodeFromText($admin->get_post('email'));

$home_folder = $admin->get_post('home_folder');

$default_language = DEFAULT_LANGUAGE;

$default_timezone = DEFAULT_TIMEZONE;

/*----------------------------------------------------------------------------------------------------*/

    // Check values

    // Check if username already exists

    $sql  = 'SELECT `user_id` FROM `'.TABLE_PREFIX.'users` '

          . 'WHERE `username` = \''.$username.'\' ';

    if ($database->get_one($sql)) {

        $aErrorMessage[] = $oTrans->MESSAGE_USERS_USERNAME_TAKEN;

    }

    if(!preg_match('/^[a-z]{1}[a-z0-9_-]{2,}$/i', $username)) {

        $aErrorMessage[] = $oTrans->MESSAGE_USERS_NAME_INVALID_CHARS.' / '

                         . $oTrans->MESSAGE_USERS_USERNAME_TOO_SHORT;

    }

    if(strlen($password) < 2) {

        $aErrorMessage[] = $oTrans->MESSAGE_USERS_PASSWORD_TOO_SHORT;

    }

    if($password != $password2) {

        $aErrorMessage[] = $oTrans->MESSAGE_USERS_PASSWORD_MISMATCH;

    }

    $sql  = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'users` ';

    $sql .= 'WHERE  `display_name` LIKE \''.$display_name.'\'';

    if ($database->get_one($sql) > 0) {

        $aErrorMessage[] = ( @$oTrans->MESSAGE_USERS_DISPLAYNAME_TAKEN?:$oTrans->MESSAGE_MEDIA_BLANK_NAME.' ('.$oTrans->TEXT_DISPLAY_NAME.')');

    }

    if($email != '')

    {

        // Check if the email already exists

        $sql  = 'SELECT `user_id` FROM `'.TABLE_PREFIX.'users` '

              . 'WHERE `email` = \''.$email.'\' ';

        if ($database->get_one($sql))

        {

            if(isset($oTrans->MESSAGE_USERS_EMAIL_TAKEN))

            {

                $aErrorMessage[] = $oTrans->MESSAGE_USERS_EMAIL_TAKEN;

            }

            if($admin->validate_email($email) == false)

            {

                $aErrorMessage[] = $oTrans->MESSAGE_USERS_INVALID_EMAIL;

            }

        }

    } else { // e-mail must be present

        $aErrorMessage[] = $oTrans->MESSAGE_SIGNUP_NO_EMAIL;

    }

    if($groups_id == '') {

        $aErrorMessage[] = $oTrans->MESSAGE_USERS_NO_GROUP;

    }

/*----------------------------------------------------------------------------------------------------*/

// choose group_id from groups_id - workaround for still remaining calls to group_id (to be cleaned-up)

$gid_tmp = explode(',', $groups_id);

if(in_array('1', $gid_tmp)) $group_id = '1'; // if user is in administrator-group, get this group

else $group_id = $gid_tmp[0]; // else just get the first one

unset($gid_tmp);

if (!sizeof($aErrorMessage)) {

// MD5 supplied password

$md5_password = md5($password);

$now = time();

// Insert the user into the database

$sql = // add the Admin user

     'INSERT INTO `'.TABLE_PREFIX.'users` SET '

    .    '`group_id`='.intval($group_id).', '

    .    '`groups_id`=\''.$database->escapeString($groups_id).'\', '

    .    '`active`=\''.$database->escapeString($active).'\', '

    .    '`username`=\''.$database->escapeString($username).'\', '

    .    '`password`=\''.$database->escapeString($md5_password).'\', '

    .    '`remember_key`=\'\', '

    .    '`last_reset`=0, '

    .    '`display_name`=\''.$database->escapeString($display_name).'\', '

    .    '`email`=\''.$database->escapeString($email).'\', '

    .    '`timezone`=\''.$database->escapeString($default_timezone).'\', '

    .    '`date_format`=\''.DEFAULT_DATE_FORMAT.'\', '

    .    '`time_format`=\''.DEFAULT_TIME_FORMAT.'\', '

    .    '`language`=\''.$database->escapeString($default_language).'\', '

    .    '`home_folder`=\''.$database->escapeString($home_folder).'\', '

    .    '`login_when`=\''.time().'\', '

    .    '`login_ip`=\'\' '

    .    '';

    if (!$database->query($sql)) {

        if($database->is_error()) {

            $aErrorMessage[] = $database->get_error();

        }

    }

}

if (sizeof($aErrorMessage)) {

    $admin->print_error(implode('<br />', $aErrorMessage), $js_back);

} else {

    $admin->print_success($oTrans->MESSAGE_USERS_ADDED, $js_back);

}

// Print admin footer

$admin->print_footer();