Quick easy way to make PhpBB3 create a game account for Mangos (3.1.3)

[milla247]

This guide is just a simple easy way to make phpbb3 registration also create a game account with the same forum username and password.

Open ucp_register.php in (forum root folder)\includes\ucp\

Find:

$user_row = array(
					'username'				=> $data['username'],
					'user_password'			=> phpbb_hash($data['new_password']),
					'user_email'			=> $data['email'],
					'group_id'				=> (int) $group_id,
					'user_timezone'			=> (float) $data['tz'],
					'user_dst'				=> $is_dst,
					'user_lang'				=> $data['lang'],
					'user_type'				=> $user_type,
					'user_actkey'			=> $user_actkey,
					'user_ip'				=> $user->ip,
					'user_regdate'			=> time(),
					'user_inactive_reason'	=> $user_inactive_reason,
					'user_inactive_time'	=> $user_inactive_time,
				
);
				// Register user...

Above those lines add :

$mangos_username=$data['username'];
$mangos_passw=$data['new_password'];
$mangos_email=$data['email'];
$mangos_ip="0.0.0.0";
$mangos_lock_acc="0";
$mangos_expansion="2";
$mangos_sql = "INSERT INTO `account` (`username`,`sha_pass_hash`,`email`,`last_ip`,`locked`,`expansion`) VALUES (UPPER('".$mangos_username."'),SHA1(CONCAT(UPPER('".$mangos_username."'),':',UPPER('".$mangos_passw."'))),'".$mangos_email."','".$mangos_ip."','".$mangos_lock_acc."','".$mangos_expansion."')";

$mangos_link = mysql_connect('Localhost','mangosuser','mangospassword');
$mangos_db_sel = mysql_select_db('realmd', $mangos_link);
$mangos_result = mysql_query($mangos_sql);
mysql_close();

Replace the red mangosuser and mangospassword with your database root login

it should look like this..

$mangos_username=$data['username'];
$mangos_passw=$data['new_password'];
$mangos_email=$data['email'];
$mangos_ip="0.0.0.0";
$mangos_lock_acc="0";
$mangos_expansion="2";
$mangos_sql = "INSERT INTO `account` (`username`,`sha_pass_hash`,`email`,`last_ip`,`locked`,`expansion`) VALUES (UPPER('".$mangos_username."'),SHA1(CONCAT(UPPER('".$mangos_username."'),':',UPPER('".$mangos_passw."'))),'".$mangos_email."','".$mangos_ip."','".$mangos_lock_acc."','".$mangos_expansion."')";

$mangos_link = mysql_connect('Localhost','root','ascent');
$mangos_db_sel = mysql_select_db('realmd', $mangos_link);
$mangos_result = mysql_query($mangos_sql);
mysql_close();

				$user_row = array(
					'username'				=> $data['username'],
					'user_password'			=> phpbb_hash($data['new_password']),
					'user_email'			=> $data['email'],
					'group_id'				=> (int) $group_id,
					'user_timezone'			=> (float) $data['tz'],
					'user_dst'				=> $is_dst,
					'user_lang'				=> $data['lang'],
					'user_type'				=> $user_type,
					'user_actkey'			=> $user_actkey,
					'user_ip'				=> $user->ip,
					'user_regdate'			=> time(),
					'user_inactive_reason'	=> $user_inactive_reason,
					'user_inactive_time'	=> $user_inactive_time,
				
);
				// Register user...

Now everytime a guest registers it will create a game account.
Note that all the PHPBB3 register settings and controls will now apply to the game account.

(only one email, mx record check, captcha check, etc)

Enjoy =)

[Wast3d]

This is amazing... Could you do the same for vbulletin aswell?

[Xees]

lol i feel like noob