````

Important notes: The database layer code (creating a view) is simple, powerful and secure.
[color=#ff3366]To allow people to easily login[/color] (to Wordpress) you need to, for example, either "properly modify" the existing Wordpress logins (with a "simple" plugin [size=xx-small]// to allow wordpress to use the info in the modified db table[/size]), and/or "hack away" with something like this on the Wordpress side.
[url=https://community.mybb.com/thread-118986.html][Tutorial] EZ Fast Login | (SSO Integration) | Force Login To MyBB[/url]


[b]The Main Event[/b]
So simple, almost no PHP required (!!??!?)

1a) This SQL sample assumes your wordpress is installed using a ' mybb_wp_ ' db table prefix

1b) temporarily delete (and or backup/delete) the wordpress users table  (mybb_wp_users)

2) Now the fun part  // Showing us many coders work too d__m hard  :)




[code] -- Structure for view `mybb_wp_users`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mybb_wp_users` AS select 
`mybb_users`.`uid` AS `ID`,
`mybb_users`.`username` AS `user_login`,
`mybb_users`.`password` AS `user_pass`,
`mybb_users`.`username` AS `user_nicename`,
`mybb_users`.`email` AS `user_email`,
`mybb_users`.`website` AS `user_url`,
`mybb_users`.`regdate` AS `user_registered`,
`mybb_users`.`salt` AS `user_activation_key`,
`mybb_users`.`'_*choose _a_mybb_db_column_related _to_ranks_usergroup_anything_you_need*_'` AS `user_status`,
`mybb_users`.`username` AS `display_name`
from `mybb_users`;

CREATE VIEW abc1.mybb_wp_users AS SELECT
abc1.mybb_<snip>