user_login;
$UserName=$current_user->user_login;
//echo “UserName”, $UserName;
}

if ($UserName!=””)
{
$SelectUserQuery=”select * from wp_users where user_login=’$UserName'”;
$SelectUserResult=mysql_query($SelectUserQuery);
$UserRows=mysql_fetch_array($SelectUserResult);
$SelectUserNumRows=mysql_num_rows($SelectUserResult);

$ID=$UserRows[‘ID’];

$SelectCustQuery=”select * from customer where wp_user_id=’$ID'”;
$SelectCustResult=mysql_query($SelectCustQuery);
$CustRows=mysql_fetch_array($SelectCustResult);
$SelectCustNumRows=mysql_num_rows($SelectCustResult);

If ($SelectCustNumRows>0)
{
$Cid=$CustRows[‘CidSTATIC’];
$ScreenName=$CustRows[‘ScreenName’];
$FirstName=$CustRows[‘FirstNameVALIDATE’];
$LastName=$CustRows[‘LastNameVALIDATE’];

$InsertLogin=”insert into login(CidSTATIC,FirstName,LastName,ScreenName)Values(‘$Cid’,’$FirstName’,’$LastName’,’$ScreenName’)”;
$InsertResult=mysql_query($InsertLogin);

if($InsertResult)
{
$LoginOK=”Y”;
}
else
{
$LMessage.=”$FirstName$space$LastName login insert failed
“;
$LMessage.=$InsertLogin;
send_mail($from,$to,$subject,$LMessage);
}

require_once(“scripts/playerregister2.php”);//Player Profile

}
ELSE
{
$LMessage.=”$FirstName$space$LastName customer retrieval failed – Social Club
“;
$LMessage.=$SelectCustQuery;
send_mail($from,$to,$subject,$LMessage);
}
}

else

{

echo “login screen, You must be logged in. If you are not registered – click on the JOIN link on the menu to register”;

}

?>