'; $message = "Thank you for your payment. Please keep the following information where you can find it.

"; $message .= "Your Member Name (login ID) is: ".$row_ccc['user_id']."
"; $message .= "Your password is: ".$row_ccc['password']."
"; $message .= "Payment amount: ".$payment_gross."
"; $message .= "Date of payment: ".$row_ccc['billing_start']."
"; $message .= "Your membership expires: ".$row_ccc['billing_end']."

"; $message .= 'Thank you for being part of our community. We hope you enjoy your experience with us, and we will do our best to insure you do. If you have any questions, please contact us at support@astro-grid.com.'; $message .= ""; mail($to,$subject,$message,$from); header("location:myaccount.php"); } if($_GET['case']=="pay"&&$paypal!=1) { extract($_SESSION); $sql="select * from user_cc_details where email='$email'"; $result=mysql_query($sql); $count=mysql_num_rows($result); $sql1="select * from user_cc_details where user_id='$username'"; $result1=mysql_query($sql1); $count1=mysql_num_rows($result1); if($count!=0 ) { $case1="emailexist"; $flag=1; } else if($count1!=0 ) { $case1="userexist"; $flag=1; } //echo $dob_country; if($flag!=1) { $name=$fname.' '.$lname; $expire=$month.' '.$year; $sql_in1="insert into user_cc_details(user_id,password,billing_start,billing_end,payer_name,address1,address2,city, state,country,zipcode,signup_date,login_date,email) values ('$username','$password','$start','$end','$name','$address1','$address2','$dob_city', '$dob_state','$dob_country','$zipcode',now(),now(),'$email')"; $res_in1=mysql_query($sql_in1) or die(mysql_error()); // send mail $sql_ccc ="select user_id, password, email, id, date_format(billing_start,'%c/%d/%Y') as billing_start, date_format(billing_end,'%c/%d/%Y') as billing_end from user_cc_details where id = ".mysql_insert_id(); $res_ccc = mysql_query($sql_ccc); $row_ccc = mysql_fetch_array($res_ccc); $from = 'MIME-Version: 1.0' . "\r\n"; $from .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $from .= 'To: '.$row_ccc['email']."\r\n"; $from .= 'From: support@astro-grid.com'."\r\n"; $from .= 'Reply-To: support@astro-grid.com'."\r\n"; $subject = "Welcome to Astro-Grid.com"; $message = ' Astro-Mail Welcome '; $message = "Thank you for your payment. Please keep the following information where you can find it.

"; $message .= "Your Member Name (login ID) is: ".$row_ccc['user_id']."
"; $message .= "Your password is: ".$row_ccc['password']."
"; $message .= "Payment amount: ".$_SESSION['amount']."
"; $message .= "Date of payment: ".$row_ccc['billing_start']."
"; $message .= "Your membership expires: ".$row_ccc['billing_end']."

"; $message .= 'Thank you for being part of our community. We hope you enjoy your experience with us, and we will do our best to insure you do. If you have any questions, please contact us at support@astro-grid.com.'; $message .= ""; mail($to,$subject,$message,$from); mysql_free_result($res_ccc); $_SESSION=array(); session_destroy(); session_start(); $_SESSION['id']=$row_ccc['id']; $id = $_SESSION['id']; } } if($_GET['case']=="update") { extract($_POST); $name=$fname.' '.$lname; $sql_up="update user_cc_details set payer_name='$fname',address1='$address1',address2='$address2',city='$city',state='$state',country='$country',zipcode='$zipcode',email='$email' where id='".$_SESSION['id']."'"; mysql_query($sql_up) or die(mysql_error()); } if($_GET['action']=="passupdate") { $oldpass=$_POST['old_password']; $npass=$_POST['new_password']; $sql="select * from user_cc_details where id='".$_SESSION['id']."' and password='$oldpass'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count!=0) { $sql_up="update user_cc_details set password='$npass' where id='".$_SESSION['id']."'"; $result_up=mysql_query($sql_up); $action="success"; } else { $action="fail"; } } if($_GET['case']=="paysuccessful") { extract($_SESSION); $user_pay1=select_table("user_cc_details","id=$id"); $res_pay1=mysql_fetch_assoc($user_pay1); $name=$fname.' '.$lname; $expire=$month.' '.$year; $end_time=$membership_type; $sql_end="select date_add('$start', interval $end_time month)"; $res_end=mysql_query($sql_end); $row_end=mysql_fetch_row($res_end); $end=$row_end[0]; $sql_up="update user_cc_details set billing_start='$start',billing_end='$end', payer_name='$name',address1='$address1',address2='$address2',city='$dob_city',state='$dob_state',country='$dob_country',zipcode='$zipcode' where id=$id"; mysql_query($sql_up) or die(mysql_error()); // send mail $sql_ccc ="select user_id, password, email, date_format(billing_start,'%c/%d/%Y') as billing_start, date_format(billing_end,'%c/%d/%Y') as billing_end from user_cc_details where id = ".$id; $res_ccc = mysql_query($sql_ccc); $row_ccc = mysql_fetch_array($res_ccc); $from = 'MIME-Version: 1.0' . "\r\n"; $from .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $from .= 'To: '.$row_ccc['email']."\r\n"; $from .= 'From: support@astro-grid.com'."\r\n"; $from .= 'Reply-To: support@astro-grid.com'."\r\n"; $subject = "Welcome to Astro-Grid.com"; $message = ' Astro-Mail Welcome '; $message = "Thank you for your payment. Please keep the following information where you can find it.

"; $message .= "Your Member Name (login ID) is: ".$row_ccc['user_id']."
"; $message .= "Your password is: ".$row_ccc['password']."
"; $message .= "Payment amount: ".$_SESSION['amount']."
"; $message .= "Date of payment: ".$row_ccc['billing_start']."
"; $message .= "Your membership expires: ".$row_ccc['billing_end']."
"; $message .= "Your credit card statement will show a payment to PsyCom.

"; $message .= 'Thank you for being part of our community. We hope you enjoy your experience with us, and we will do our best to insure you do. If you have any questions, please contact us at support@astro-grid.com.'; $message .= ""; mail($to,$subject,$message,$from); mysql_free_result($res_ccc); } $user_pay=select_table("user_cc_details","id=$id"); $res_pay=mysql_fetch_assoc($user_pay); extract($res_pay); $sql_signup="select date_format('".$res_pay['signup_date']."','%b %e, %Y')"; $res_signup=mysql_query($sql_signup); $row_signup=mysql_fetch_row($res_signup); $sql_login="select date_format('".$res_pay['login_date']."','%b %e, %Y')"; $res_login=mysql_query($sql_login); $row_login=mysql_fetch_row($res_login); $sql_end="select date_format('".$res_pay['billing_end']."','%b %e, %Y')"; $res_end=mysql_query($sql_end); $row_end=mysql_fetch_row($res_end); ?> My Astro-Dating Account



Your Payment was successful-Thank You
     Logout 
's Account
Subscribed Since: Last Login: Subscription Expires: Extend Membership
Membership extended successfully

Change Password
Password Updated Successfully
Incorrect Old password
Old Password
New Password
Retype Password

Change Billing Info
Name:
Address 1:
Address 2:
City:
State/Province: ">
Postal Code:
Email:
Country: