Advertisement
Guest User

Untitled

a guest
Oct 13th, 2016
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. SET @username = 'username';
  2. SET @password = 'password';
  3. SET @email = 'email';
  4.  
  5. INSERT INTO `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
  6. VALUES
  7. (NULL , @username, MD5(@password), '', @email, '', NOW(), '', '0', @username);
  8. INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
  9. VALUES
  10. (NULL, LAST_INSERT_ID(), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'),
  11. (NULL, LAST_INSERT_ID(), 'wp_user_level', '10'),
  12. (NULL, LAST_INSERT_ID(), 'nickname', @username);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement