="INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) VALUES ("&A4&", '"&B4&"', MD5('"&E4&"'), '"&LOWER(B4)&"', '"&LOWER(B4)&"@gmail.com', '', '2021-01-018 11:33:20', '1609932803:$P$B7LBiFY6NR6NrXFrSCrO7/54DqNi8B/', 0, '"&C4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'nickname', '"&B4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'first_name', '"&C4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'last_name', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'description', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'rich_editing', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'syntax_highlighting', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'comment_shortcuts', 'false');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'admin_color', 'fresh');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'use_ssl', '0');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'show_admin_bar_front', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'locale', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_capabilities', 'a:1:{s:10:\""subscriber\"";b:1;}');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_user_level', '0');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_multiple_roles', 'a:2:{i:0;s:23:\""um_erlms-entry-operator\"";i:1;s:14:\""um_data-viewer\"";}');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_user_profile_url_slug_user_login', '"&B4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'account_status', 'approved');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'sw_pwd', '"&E4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'dismissed_wp_pointers', 'wp496_privacy');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'synced_gravatar_hashed_id', '354fbe8cea21bca9871847af17cb1970');"
="INSERT INTO t_site_user_map (UserId, InstanceId, IsActive) VALUES('"&A4&"', 1580086744006, 1);"
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_users.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_usermeta.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_t_site_user_map.sql
mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_users.sql mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_usermeta.sql
mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_t_site_user_map.sql
WP
Create WordPress users by WP Ajax
Add the following code to function.php in child theme.
add_action('wp_ajax_create_my_users_action', 'create_my_users');
add_action('wp_ajax_nopriv_create_my_users_action', 'create_my_users');
function create_my_users(){
if(!wp_verify_nonce($_POST['nonce_id'], 'create_my_users_action')){
echo '<div class="alert alert_error">Error!</div>';
wp_die();
}
$my_users = $_POST['my_users'];
//var_dump($my_users);
$user_ids = [];
foreach($my_users as $u){
$userdata = array(
'user_login' => $u['user_login'],
'user_pass' => $u['user_pass'],
'user_email' => $u['user_email'],
'first_name' => $u['first_name'],
'last_name' => $u['last_name'],
'nickname' => $u['nickname']
);
$user_id = wp_insert_user( $userdata );
//$result = add_user_meta($user_id, 'sw', $u['sw'], true);
$result = update_user_meta( $user_id, 'account_status', $u['account_status'] );
$result = update_user_meta( $user_id, 'um_multiple_roles', $u['um_multiple_roles'] );
$user_ids[] = $user_id;
}
echo json_encode($user_ids);
wp_die();
}
function create_my_users_shortcode() {
$my_users = json_encode([[
'user_login' => 'a11111111111',
'user_pass' => '123456',
'user_email' => 'a11111111111@gmail.com',
'role' => 'subscriber',
'first_name' => 'a11111111111',
'last_name' => '',
'sw' => '',
'account_status' => 'approved',
'um_multiple_roles' =>['um_data-entry-operator']
],
[
'user_login' => 'a22222222222',
'user_pass' => '123456',
'user_email' => 'a22222222222@gmail.com',
'role' => 'subscriber',
'first_name' => 'a22222222222',
'last_name' => '',
'sw' => '',
'account_status' => 'approved',
'um_multiple_roles' =>['um_data-entry-operator']
]
]);
$html = '<button nonce_id='.wp_create_nonce('create_my_users_action').' class="create_my_users">Test</button>
<ul id="info_create_my_users"></ul>
<script>
jQuery(document).ready(function($) {
$(".create_my_users").on("click", function() {
var nonce_id = $(this).attr("nonce_id");
$.ajax({
url: "' . admin_url('admin-ajax.php') . '",
type: "POST",
data: {
action: "create_my_users_action",
my_users: '.$my_users.',
nonce_id: nonce_id
},
beforeSend: function(){
$("#info_create_my_users").empty();
$("#info_create_my_users").append("Creating users ...");
},
success: function(html) {
$("#info_create_my_users").empty();
$("#info_create_my_users").append(html);
}
});
});
});
</script>';
return $html;
}
add_shortcode('CreateMyUsersShortcode', 'create_my_users_shortcode');
You can place this short code anywhere in PHP code block like header, body, footer etc as follows.
<?php echo do_shortcode("[CreateMyUsersShortcode]"); ?>
You can place this short code into any post and page as follows.
[CreateMyUsersShortcode]
How to import wordpress site by separate site and db in local
wp_options -> siteurl -> http://159.89.80.126 -> http://localhost/bdcovid19elmis
wp_options -> home -> http://159.89.80.126 -> http://localhost/bdcovid19elmis
Ultimate Member -> User Roles -> Login Options -> Set Custom Redirect URL -> Change IP to localhost to all of the Role.
wp-config.php -> DB_NAME -> bdcovid19elmisdb
wp-config.php -> DB_USER -> root
wp-config.php -> DB_PASSWORD -> [blank]
D:\xampp7227\htdocs\bdcovid19elmis\wp-content\themes\betheme-child\settings.ini.php
user = root
password =
dbname = bdcovid19elmisdb
http://localhost/bdcovid19elmis/wp-admin/ -> Settings -> Permalink -> Click on button “Save Changes”
http://localhost/bdcovid19elmis/wp-admin/ -> Pages -> Open any one page and save it again to fix url localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> General -> Fevicon -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> General -> Apple Touch Icon -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> Logo -> LOGO -> Logo -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> Logo -> LOGO -> Retina Logo -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> Logo -> STICKY HEADER LOGO -> Logo -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Betheme -> Theme Options -> Global -> Logo -> STICKY HEADER LOGO -> Retina Logo -> Change IP to localhost
http://localhost/bdcovid19elmis/wp-admin/ -> Appearance -> Widgets -> Footer|#1 -> Change IP to localhost