I want to have a signup for wordpress and for ingame as once, so you just need to register once.
So the user should register at wordpress and ingame, how can I do that?
The MSSQL Server is on a extern server. (How can I connect it to a extern server?) The Webserver allows a mssql connection.
$connect = odbc_connect("Driver={SQL Server Native Client 10.0};Server={$host}; Database={$dbname}", $user, $pass) or die("Can't connect the MSSQL server.");
function valida_email($email) {//Funktion um das Format der E-Mail zu bestätigen! if (preg_match('/^[A-Za-z0-9-_.+%]+@[A-Za-z0-9-.]+\.[A-Za-z]{2,4}$/', $email)) return true; else return false; }
$result = odbc_exec($connect, "SELECT name FROM dbo.Account WHERE name = '$userid'"); $existing_users = odbc_num_rows($result); if($existing_users >= 1) {//Überprüft, ob das Konto noch nicht existiert! header("location:accal.html"); }
$result2 = odbc_exec($connect, "SELECT email FROM dbo.Account WHERE email = '$email'"); $existing_email = odbc_num_rows($result2); if($existing_email >= 1) {//Überprüft, ob die E-Mail nicht in Gebrauch ist! header("location:accal2.html"); }
if (!$_POST['username'] ) {//Schaut dass kein Feld leer ist! header("location:accal3.html"); die();
}
if (!$_POST['password'] ) {//Schaut dass kein Feld leer ist! header("location:accal3.html"); die(); }
if (!$_POST['email'] ) {//Schaut dass kein Feld leer ist! header("location:accal3.html"); die(); }
if (!$_POST['secret'] ) {//Schaut dass kein Feld leer ist! header("location:accal3.html"); die(); }
if (!$_POST['resp'] ) {//Schaut dass kein Feld leer ist! header("location:accal3.html"); die(); }
if($_POST['password'] != $_POST['password_conf']) { // Wir überprüfen, ob die eingegebenen Kennwörter übereinstimmen header ("location:accal5.html"); die(); }
if(!valida_email($_POST['email'])) { // überprüfen, ob die eingegebene E-Mail korrekt ist header("location:accal2b.html"); die(); }
/** * Prints signup_header via wp_head * * @since MU */ function do_signup_header() { /** * Fires within the head section of the site sign-up screen. * * @since 3.0.0 */ do_action( 'signup_header' ); } add_action( 'wp_head', 'do_signup_header' );
if ( !is_multisite() ) { wp_redirect( wp_registration_url() ); die(); }
/** * Fires before the site sign-up form. * * @since 3.0.0 */ do_action( 'before_signup_form' ); ?> <div id="signup-content" class="widecolumn"> <div class="mu_register wp-signup-container"> <?php /** * Generates and displays the Signup and Create Site forms * * @since MU * * @param string $blogname The new site name. * @param string $blog_title The new site title. * @param WP_Error|string $errors A WP_Error object containing existing errors. Defaults to empty string. */ function show_blog_form( $blogname = '', $blog_title = '', $errors = '' ) { if ( ! is_wp_error( $errors ) ) { $errors = new WP_Error(); }
$current_network = get_network(); // Blog name if ( !is_subdomain_install() ) echo '<label for="blogname">' . __('Site Name:') . '</label>'; else echo '<label for="blogname">' . __('Site Domain:') . '</label>';
/* translators: %s: site address */ echo '<p>(<strong>' . sprintf( __( 'Your address will be %s.' ), $site ) . '</strong>) ' . __( 'Must be at least 4 characters, letters and numbers only. It cannot be changed, so choose carefully!' ) . '</p>'; }
<?php /** * Fires after the site sign-up form. * * @since 3.0.0 * * @param WP_Error $errors A WP_Error object possibly containing 'blogname' or 'blog_title' errors. */ do_action( 'signup_blogform', $errors ); }
/** * Validate the new site signup * * @since MU * * @return array Contains the new site data and error messages. */ function validate_blog_form() { $user = ''; if ( is_user_logged_in() ) $user = wp_get_current_user();
/** * Display user registration form * * @since MU * * @param string $user_name The entered username. * @param string $user_email The entered email address. * @param WP_Error|string $errors A WP_Error object containing existing errors. Defaults to empty string. */ function show_user_form($user_name = '', $user_email = '', $errors = '') { if ( ! is_wp_error( $errors ) ) { $errors = new WP_Error(); }
// User name echo '<label for="user_name">' . __('Username:') . '</label>'; if ( $errmsg = $errors->get_error_message('user_name') ) { echo '<p class="error">'.$errmsg.'</p>'; } echo '<input name="user_name" type="text" id="user_name" value="'. esc_attr( $user_name ) .'" autocapitalize="none" autocorrect="off" maxlength="60" /><br />'; _e( '(Must be at least 4 characters, letters and numbers only.)' ); ?>
<label for="user_email"><?php _e( 'Email Address:' ) ?></label> <?php if ( $errmsg = $errors->get_error_message('user_email') ) { ?> <p class="error"><?php echo $errmsg ?></p> <?php } ?> <input name="user_email" type="email" id="user_email" value="<?php echo esc_attr($user_email) ?>" maxlength="200" /><br /><?php _e('We send your registration email to this address. (Double-check your email address before continuing.)') ?> <?php if ( $errmsg = $errors->get_error_message('generic') ) { echo '<p class="error">' . $errmsg . '</p>'; } /** * Fires at the end of the user registration form on the site sign-up form. * * @since 3.0.0 * * @param WP_Error $errors A WP_Error object containing containing 'user_name' or 'user_email' errors. */ do_action( 'signup_extra_fields', $errors ); }
/** * Validate user signup name and email * * @since MU * * @return array Contains username, email, and error messages. */ function validate_user_form() { return wpmu_validate_user_signup($_POST['user_name'], $_POST['user_email']); }
/** * Allow returning users to sign up for another site * * @since MU * * @param string $blogname The new site name * @param string $blog_title The new site title. * @param WP_Error|string $errors A WP_Error object containing existing errors. Defaults to empty string. */ function signup_another_blog( $blogname = '', $blog_title = '', $errors = '' ) { $current_user = wp_get_current_user();
if ( ! is_wp_error($errors) ) { $errors = new WP_Error(); }
echo '<h2>' . sprintf( __( 'Get <em>another</em> %s site in seconds' ), get_network()->site_name ) . '</h2>';
if ( $errors->get_error_code() ) { echo '<p>' . __( 'There was a problem, please correct the form below and try again.' ) . '</p>'; } ?> <p><?php printf( __( 'Welcome back, %s. By filling out the form below, you can <strong>add another site to your account</strong>. There is no limit to the number of sites you can have, so create to your heart’s content, but write responsibly!' ), $current_user->display_name ) ?></p>
<?php $blogs = get_blogs_of_user($current_user->ID); if ( !empty($blogs) ) { ?>
<p><?php _e( 'Sites you are already a member of:' ) ?></p> <ul> <?php foreach ( $blogs as $blog ) { $home_url = get_home_url( $blog->userblog_id ); echo '<li><a href="' . esc_url( $home_url ) . '">' . $home_url . '</a></li>'; } ?> </ul> <?php } ?>
<p><?php _e( 'If you’re not going to use a great site domain, leave it for a new user. Now have at it!' ) ?></p> <form id="setupform" method="post" action="wp-signup.php"> <input type="hidden" name="stage" value="gimmeanotherblog" /> <?php /** * Hidden sign-up form fields output when creating another site or user. * * @since MU * * @param string $context A string describing the steps of the sign-up process. The value can be * 'create-another-site', 'validate-user', or 'validate-site'. */ do_action( 'signup_hidden_fields', 'create-another-site' ); ?> <?php show_blog_form($blogname, $blog_title, $errors); ?> <p class="submit"><input type="submit" name="submit" class="submit" value="<?php esc_attr_e( 'Create Site' ) ?>" /></p> </form> <?php }
/** * Validate a new site signup. * * @since MU * * @return null|bool True if site signup was validated, false if error. * The function halts all execution if the user is not logged in. */ function validate_another_blog_signup() { global $wpdb, $blogname, $blog_title, $errors, $domain, $path; $current_user = wp_get_current_user(); if ( ! is_user_logged_in() ) { die(); }
if ( $language ) { $blog_meta_defaults['WPLANG'] = $language; } }
}
/** * Filters the new site meta variables. * * Use the {@see 'add_signup_meta'} filter instead. * * @since MU * @deprecated 3.0.0 Use the {@see 'add_signup_meta'} filter instead. * * @param array $blog_meta_defaults An array of default blog meta variables. */ $meta_defaults = apply_filters( 'signup_create_blog_meta', $blog_meta_defaults );
/** * Filters the new default site meta variables. * * @since 3.0.0 * * @param array $meta { * An array of default site meta variables. * * @type int $lang_id The language ID. * @type int $blog_public Whether search engines should be discouraged from indexing the site. 1 for true, 0 for false. * } */ $meta = apply_filters( 'add_signup_meta', $meta_defaults );
/** * Confirm a new site signup. * * @since MU * @since 4.4.0 Added the `$blog_id` parameter. * * @param string $domain The domain URL. * @param string $path The site root path. * @param string $blog_title The site title. * @param string $user_name The username. * @param string $user_email The user's email address. * @param array $meta Any additional meta from the {@see 'add_signup_meta'} filter in validate_blog_signup(). * @param int $blog_id The site ID. */ function confirm_another_blog_signup( $domain, $path, $blog_title, $user_name, $user_email = '', $meta = array(), $blog_id = 0 ) {
?> <h2><?php /* translators: %s: site name */ printf( __( 'The site %s is yours.' ), $site ); ?></h2> <p> <?php printf( /* translators: 1: home URL, 2: site address, 3: login URL, 4: username */ __( '<a href="%1$s">%2$s</a> is your new site. <a href="%3$s">Log in</a> as “%4$s” using your existing password.' ), esc_url( $home_url ), untrailingslashit( $domain . $path ), esc_url( $login_url ), $user_name ); ?> </p> <?php /** * Fires when the site or user sign-up process is complete. * * @since 3.0.0 */ do_action( 'signup_finished' ); }
/** * Setup the new user signup process * * @since MU * * @param string $user_name The username. * @param string $user_email The user's email. * @param WP_Error|string $errors A WP_Error object containing existing errors. Defaults to empty string. */ function signup_user( $user_name = '', $user_email = '', $errors = '' ) { global $active_signup;
if ( !is_wp_error($errors) ) $errors = new WP_Error();
/** * Filters the default user variables used on the user sign-up form. * * @since 3.0.0 * * @param array $signup_user_defaults { * An array of default user variables. * * @type string $user_name The user username. * @type string $user_email The user email address. * @type WP_Error $errors A WP_Error object with possible errors relevant to the sign-up user. * } */ $filtered_results = apply_filters( 'signup_user_init', $signup_user_defaults ); $user_name = $filtered_results['user_name']; $user_email = $filtered_results['user_email']; $errors = $filtered_results['errors'];
?>
<h2><?php /* translators: %s: name of the network */ printf( __( 'Get your own %s account in seconds' ), get_network()->site_name ); ?></h2> <form id="setupform" method="post" action="wp-signup.php" novalidate="novalidate"> <input type="hidden" name="stage" value="validate-user-signup" /> <?php /** This action is documented in wp-signup.php */ do_action( 'signup_hidden_fields', 'validate-user' ); ?> <?php show_user_form($user_name, $user_email, $errors); ?>
/** * Validate the new user signup * * @since MU * * @return bool True if new user signup was validated, false if error */ function validate_user_signup() { $result = validate_user_form(); $user_name = $result['user_name']; $user_email = $result['user_email']; $errors = $result['errors'];
/** * New user signup confirmation * * @since MU * * @param string $user_name The username * @param string $user_email The user's email address */ function confirm_user_signup($user_name, $user_email) { ?> <h2><?php /* translators: %s: username */ printf( __( '%s is your new username' ), $user_name) ?></h2> <p><?php _e( 'But, before you can start using your new username, <strong>you must activate it</strong>.' ) ?></p> <p><?php /* translators: %s: email address */ printf( __( 'Check your inbox at %s and click the link given.' ), '<strong>' . $user_email . '</strong>' ); ?></p> <p><?php _e( 'If you do not activate your username within two days, you will have to sign up again.' ); ?></p> <?php /** This action is documented in wp-signup.php */ do_action( 'signup_finished' ); }
/** * Setup the new site signup * * @since MU * * @param string $user_name The username. * @param string $user_email The user's email address. * @param string $blogname The site name. * @param string $blog_title The site title. * @param WP_Error|string $errors A WP_Error object containing existing errors. Defaults to empty string. */ function signup_blog($user_name = '', $user_email = '', $blogname = '', $blog_title = '', $errors = '') { if ( !is_wp_error($errors) ) $errors = new WP_Error();
/** * Filters the default site creation variables for the site sign-up form. * * @since 3.0.0 * * @param array $signup_blog_defaults { * An array of default site creation variables. * * @type string $user_name The user username. * @type string $user_email The user email address. * @type string $blogname The blogname. * @type string $blog_title The title of the site. * @type WP_Error $errors A WP_Error object with possible errors relevant to new site creation variables. * } */ $filtered_results = apply_filters( 'signup_blog_init', $signup_blog_defaults );
/** * Validate new site signup * * @since MU * * @return bool True if the site signup was validated, false if error */ function validate_blog_signup() { // Re-validate user info. $user_result = wpmu_validate_user_signup( $_POST['user_name'], $_POST['user_email'] ); $user_name = $user_result['user_name']; $user_email = $user_result['user_email']; $user_errors = $user_result['errors'];
/** * New site signup confirmation * * @since MU * * @param string $domain The domain URL * @param string $path The site root path * @param string $blog_title The new site title * @param string $user_name The user's username * @param string $user_email The user's email address * @param array $meta Any additional meta from the {@see 'add_signup_meta'} filter in validate_blog_signup() */ function confirm_blog_signup( $domain, $path, $blog_title, $user_name = '', $user_email = '', $meta = array() ) { ?> <h2><?php /* translators: %s: site address */ printf( __( 'Congratulations! Your new site, %s, is almost ready.' ), "<a href='http://{$domain}{$path}'>{$blog_title}</a>" ) ?></h2>
<p><?php _e( 'But, before you can start using your site, <strong>you must activate it</strong>.' ) ?></p> <p><?php /* translators: %s: email address */ printf( __( 'Check your inbox at %s and click the link given.' ), '<strong>' . $user_email . '</strong>' ); ?></p> <p><?php _e( 'If you do not activate your site within two days, you will have to sign up again.' ); ?></p> <h2><?php _e( 'Still waiting for your email?' ); ?></h2> <p> <?php _e( 'If you haven’t received your email yet, there are a number of things you can do:' ) ?> <ul id="noemail-tips"> <li><p><strong><?php _e( 'Wait a little longer. Sometimes delivery of email can be delayed by processes outside of our control.' ) ?></strong></p></li> <li><p><?php _e( 'Check the junk or spam folder of your email client. Sometime emails wind up there by mistake.' ) ?></p></li> <li><?php /* translators: %s: email address */ printf( __( 'Have you entered your email correctly? You have entered %s, if it’s incorrect, you will not receive your email.' ), $user_email ); ?></li> </ul> </p> <?php /** This action is documented in wp-signup.php */ do_action( 'signup_finished' ); }
/** * Retrieves languages available during the site/user signup process. * * @since 4.4.0 * * @see get_available_languages() * * @return array List of available languages. */ function signup_get_available_languages() { /** * Filters the list of available languages for front-end site signups. * * Passing an empty array to this hook will disable output of the setting on the * signup form, and the default language will be used when creating the site. * * Languages not already installed will be stripped. * * @since 4.4.0 * * @param array $available_languages Available languages. */ $languages = (array) apply_filters( 'signup_get_available_languages', get_available_languages() );
/* * Strip any non-installed languages and return. * * Re-call get_available_languages() here in case a language pack was installed * in a callback hooked to the 'signup_get_available_languages' filter before this point. */ return array_intersect_assoc( $languages, get_available_languages() ); }
// Main $active_signup = get_site_option( 'registration', 'none' );
/** * Filters the type of site sign-up. * * @since 3.0.0 * * @param string $active_signup String that returns registration type. The value can be * 'all', 'none', 'blog', or 'user'. */ $active_signup = apply_filters( 'wpmu_active_signup', $active_signup );
// Make the signup type translatable. $i18n_signup['all'] = _x('all', 'Multisite active signup type'); $i18n_signup['none'] = _x('none', 'Multisite active signup type'); $i18n_signup['blog'] = _x('blog', 'Multisite active signup type'); $i18n_signup['user'] = _x('user', 'Multisite active signup type');
if ( is_super_admin() ) { /* translators: 1: type of site sign-up; 2: network settings URL */ echo '<div class="mu_alert">' . sprintf( __( 'Greetings Site Administrator! You are currently allowing “%s” registrations. To change or disable registration go to your <a href="%s">Options page</a>.' ), $i18n_signup[$active_signup], esc_url( network_admin_url( 'settings.php' ) ) ) . '</div>'; }
$current_user = wp_get_current_user(); if ( $active_signup == 'none' ) { _e( 'Registration has been disabled.' ); } elseif ( $active_signup == 'blog' && !is_user_logged_in() ) { $login_url = wp_login_url( network_site_url( 'wp-signup.php' ) ); /* translators: %s: login URL */ printf( __( 'You must first <a href="%s">log in</a>, and then you can create a new site.' ), $login_url ); } else { $stage = isset( $_POST['stage'] ) ? $_POST['stage'] : 'default'; switch ( $stage ) { case 'validate-user-signup' : if ( $active_signup == 'all' || $_POST[ 'signup_for' ] == 'blog' && $active_signup == 'blog' || $_POST[ 'signup_for' ] == 'user' && $active_signup == 'user' ) validate_user_signup(); else _e( 'User registration has been disabled.' ); break; case 'validate-blog-signup': if ( $active_signup == 'all' || $active_signup == 'blog' ) validate_blog_signup(); else _e( 'Site registration has been disabled.' ); break; case 'gimmeanotherblog': validate_another_blog_signup(); break; case 'default': default : $user_email = isset( $_POST[ 'user_email' ] ) ? $_POST[ 'user_email' ] : ''; /** * Fires when the site sign-up form is sent. * * @since 3.0.0 */ do_action( 'preprocess_signup_form' ); if ( is_user_logged_in() && ( $active_signup == 'all' || $active_signup == 'blog' ) ) signup_another_blog($newblogname); elseif ( ! is_user_logged_in() && ( $active_signup == 'all' || $active_signup == 'user' ) ) signup_user( $newblogname, $user_email ); elseif ( ! is_user_logged_in() && ( $active_signup == 'blog' ) ) _e( 'Sorry, new registrations are not allowed at this time.' ); else _e( 'You are logged in already. No need to register again!' );
if ( $newblogname ) { $newblog = get_blogaddress_by_name( $newblogname );
if ( $active_signup == 'blog' || $active_signup == 'all' ) /* translators: %s: site address */ printf( '<p><em>' . __( 'The site you were looking for, %s, does not exist, but you can create it now!' ) . '</em></p>', '<strong>' . $newblog . '</strong>' ); else /* translators: %s: site address */ printf( '<p><em>' . __( 'The site you were looking for, %s, does not exist.' ) . '</em></p>', '<strong>' . $newblog . '</strong>' ); } break; } } ?> </div> </div> <?php /** * Fires after the sign-up forms, before wp_footer. * * @since 3.0.0 */ do_action( 'after_signup_form' ); ?>
<?php get_footer( 'wp-signup' );
How can I mix the registration that it write it in both databases? Do I need changes on the config file too or it´s enough just in the signup file?
I think its not recommented to modify the WP core files in all. You can build an Plugin, or extra Development. I dont know if its possible to handle that with some settings.
If you change the wordpress core, your changes get revealed on the next update.
So you cann add_acctions in your WP Plugin you just have to look at which point you have to "register" your function that also writes the registration in the other db.
