<?php
$dbhost = '208.146.35.1';
$dbuser = 'fastdl';
$dbpass = 'Voltage!911!sql';
$dbname = 'fastdl_perp3';

$host2="localhost";
$username2="voltageg_site";
$password2="rogerman123";
$database2="voltageg_forums";

$conn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname) or die('Could not select BAN databse');

$steamid = $_GET['steamid'];
$q = mysql_query("SELECT * FROM `pending_users` WHERE `steamid`='" . $steamid ."' LIMIT 1");

if (!$q){ die('b'); }

function SteamID2CommunityID($steamid) {
	$parts = explode(':', str_replace('STEAM_', '' ,$steamid));
	return bcadd(bcadd('76561197960265728', $parts['1']), bcmul($parts['2'], '2'));
}

while ($row = mysql_fetch_assoc($q)){
	mysql_query("DELETE FROM `pending_users` WHERE `id` = '".$row['id']."'");
	$salt = substr(md5(mt_rand()), 0, 30);
	$regOptions = array(
		'usergroupid' => "'2'",
		'membergroupids' => "''",
		'displaygroupid' => "'0'",
		'username' => "'".$row['username']."'",
		'password' => "'".md5(md5($row['password']) . $salt)."'",
		'passworddate' => "'".date('Y-m-d')."'",
		'email' => "'notavailable@gmail.com'",
		'styleid' => "'0'",
		'parentemail' => "''",
		'homepage' => "''",
		'icq' => "''",
		'aim' => "''",
		'yahoo' => "''",
		'msn' => "''",
		'skype' => "''",
		'showvbcode' => "'1'",
		'showbirthday' => "'2'",
		'usertitle' => "''",
		'customtitle' => "'0'",
		'joindate' => "'".time()."'",
		'daysprune' => "'0'",
		'lastvisit' => "'".time()."'",
		'lastactivity' => "'".time()."'",
		'lastpost' => "'0'",
		'lastpostid' => "'0'",
		'posts' => "'0'",
		'reputation' => "'10'",
		'reputationlevelid' => "'5'",
		'timezoneoffset' => "'0'",
		'pmpopup' => "'0'",
		'avatarid' => "'0'",
		'avatarrevision' => "'0'",
		'profilepicrevision' => "'0'",
		'sigpicrevision' => "'0'",
		'profilepicrevision' => "'0'",
		'options' => "'33570831'",
		'birthday' => "''",
		'birthday_search' => "'0000-00-00'",
		'maxposts' => "'-1'",
		'startofweek' => "'-1'",
		'ipaddress' => "'".$row['ipaddress']."'",
		'referrerid' => "'0'",
		'languageid' => "'0'",
		'emailstamp' => "'0'",
		'threadedmode' => "'0'",
		'autosubscribe' => "'-1'",
		'pmunread' => "'0'",
		'salt' => "'".$salt."'",
		'ipoints' => "'0'",
		'infractions' => "'0'",
		'warnings' => "'0'",
		'infractiongroupid' => "''",
		'adminoptions' => "'0'",
		'profilevisits' => "'0'",
		'friendcount' => "'0'",
		'friendreqcount' => "'0'",
		'vmunreadcount' => "'0'",
		'vmmoderatedcount' => "'0'",
		'socgroupinvitecount' => "'0'",
		'socgroupreqcount' => "'0'",
		'pcunreadcount' => "'0'",
		'pcmoderatedcount' => "'0'",
		'gmmoderatedcount' => "'0'",
		'assetposthash' => "''",
		'fbuserid' => "''",
		'fbjoindate' => "'0'",
		'fbname' => "''",
		'logintype' => "'vb'",
		'fbaccesstoken' => "''",
		'tmnt_joins' => "'0'",
		'tmnt_wins' => "'0'",
		'tmnt_teams' => "''",
		'tmnt_ladders' => "''",
		'tmnt_notifications' => "''",
		'doubloons' => "'0'",
		'fans' => "'0'",
		'achievements' => "''",
		'importuserid' => "'0'",
		'mh_firstname' => "''",
		'mh_lastname' => "''",
		'mh_address' => "''",
		'mh_city' => "''",
		'mh_zipcode' => "''",
		'mh_location' => "'0'",
		'mh_state' => "''",
		'mh_country' => "''",
		'mh_phone' => "''",
		'mh_invoices' => "'0'",
		'mh_amount' => "'0.00'",
		'mh_paid' => "'0.00'",
		'mh_unpaid' => "'0.00'",
		'mh_overdue' => "'0.00'",
		'bloggroupreqcount' => "'0'",
		'showblogcss' => "'1'");
	mysql_query("DELETE FROM `pending_users` WHERE `steamid` = '".$row['steamid']."' LIMIT 1");

	$conn = mysql_connect ($dbhost2, $dbuser2, $dbpass2) or die ('I cannot connect to the database because: ' . mysql_error());
	mysql_select_db ($dbname2) or die('Could not select BAN databse');
	mysql_query("INSERT INTO `forums_user` (" . implode(', ', array_keys($regOptions)) . ") VALUES (" . implode(', ', $regOptions) . ')');
	$id = mysql_insert_id();

	mysql_query("INSERT INTO `forums_userfield` (`userid`, `field5`, `field6`, `field7`, `field8`) ('".$id."', '".$row['steamid']."', '".SteamID2CommunityID($row['steamid'])."', 'voltage', '4')");
	die('s');
}
die('c');
?>