Skip to forum content

You are not logged in. Please login or register.


forums.pvpgn.pro → [EN] Diablo → Trigger user account in WordPress

Pages 1

You must login or register to post a reply

RSS topic feed

Posts: 1

1

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.

Posts: 1

Pages 1

You must login or register to post a reply

Who now at forum

Currently view post: 1 guest, 0 registered users

forums.pvpgn.pro → [EN] Diablo → Trigger user account in WordPress