Topic: Trigger user account in WordPress
Hello guys. I'm trying to make syntax so I can put the basic data into WordPress from Diablo II. The problem is that I don't know where to trigger my query. For example I have made these three rules, using database d2gs (Wordpress) and d2server(PVPGN ladder etc).
I made something like this.
//Database from D2 Server to WP
INSERT INTO d2gs.d2users (`user_login`, `user_pass`, `user_nicename`, `user_email`) SELECT username, acct_passhash1, acct_username, acct_email FROM bnet
And this one:
//Inside WordPress after user has been created
INSERT INTO d2usermeta (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM d2users), 'd2capabilities', 'a:2:{s:10:"subscriber";b:1;s:15:"bbp_participant";b:1;}');
INSERT INTO d2usermeta (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM d2users), 'd2user_level', '0');
Question 1: Where i have to put the first syntax? I'm not in home to test right now...
Question 2: I know that WP uses SHA256+Salt and D2 uses XSHA1. what is the best way to make the password hash to match from db1 to db2 and vice?
I hope you can help me. Thanks in advance.