<?

require("config_inc.php");
require("func_inc.php");
include "sponsor_inc.php";

$lastip = getenv("REMOTE_ADDR");
$dbh = mysql_connect ($conf['dbhost'], $conf['dbuser'], $conf['dbpass']) or die (mysql_error());
mysql_select_db ($conf['dbname']);
$show_array = array(
     'title' => "Registrasi NetJutawan - Sponsor: $sponsor_name"
);

if ($_POST) {
$error = "";

$userid = stripslashes($userid);
$email = stripslashes($email);
$name = stripslashes($name);
$city = stripslashes($city);
$state = stripslashes($state);
$zip = stripslashes($zip);

if (!strlen($userid)) { $error .= "<li>Mohon diisi UserId yang anda inginkan.</li>";}
if (strlen($userid)< 5) { $error .= "<li>Mohon diisi UserId lebih dari 5 huruf.</li>";}
if (strlen($userid)> 12) { $error .= "<li>Maksimum panjang UserId adalah 12 huruf.</li>";}
if (ereg('%', $userid) || ereg(' ', $userid)) { $error .= "<li>UserId yang anda isikan tidak diterima/invalid.</li>";}
if(!eregi("^[_\.0-9a-z-]+$",$userid)) { $error .= "<li>UserId yang anda isikan tidak diterima/invalid.</li>";}
if (read_member($userid)) { $error .= "<li>UserId '$userid' sudah digunakan, Silahkan pilih yang lain.</li>";}
if (!check_email($email)) { $error .= "<li>Mohon diisi email yang benar.</li>";}
if (!strlen($password1)) { $error .= "<li>Mohon diisi password yang anda inginkan.</li>";}
if (strlen($password1)< 5) { $error .= "<li>Mohon diisi Password lebih dari 5 huruf atau angka</li>";}
if (strlen($password1)> 12) { $error .= "<li>Maksimum panjang Password adalah 12 huruf atau angka.</li>";}
if ($password1 != $password2) { $error .= "<li>Mohon diisi password yang sama.</li>";}

if (!strlen($name)) { $error .= "<li>Mohon diisi nama lengkap anda.</li>";}
if (!strlen($address)) { $error .= "<li>Mohon diisi Alamat anda.</li>";}
if (!strlen($city)) { $error .= "<li>Mohon diisi Kota anda.</li>";}
if (!strlen($state)) { $error .= "<li>Mohon diisi Propinsi anda.</li>";}
if (!strlen($zip)) { $error .= "<li>Mohon diisi Kode Pos anda.</li>";}
if (!strlen($bank)) { $error .= "<li>Mohon diisi Data Bank anda.</li>";}
if (!$cek) { $error .= "<li>Anda harus menyetujui kebijakan program ini</li>";}
if ($error) { show_error($error);}

//proses 3 angka unik untuk masing-masing biaya
$unik = unik_number();

$parent1_amount = $conf['parent1_amount']+$unik;
$parent2_amount = $conf['parent2_amount']+$unik;
$parent3_amount = $conf['parent3_amount']+$unik;
$admin_amount   = $conf['admin_amount']+$unik;
$val_kode = make_val_kode(12);

//$db_password = md5($password1);

//Masukin data member ke database members

parent_data($parent1);

$dbq1 ="INSERT INTO members SET userid = '$userid', password = '$password1',bank = '$bank', email='$email',
         name = '$name', address = '$address', city = '$city', state = '$state', zip = '$zip',
         phone = '$phone', parent1 = '$parent1', parent2 = '$parent2',parent3 = '$parent3', val_ok = '1',
         payment = '$unik', joindate = NOW() , val_kode = '$val_kode', sas = '$sas', yahooid = '$yahooid'";


        $res = mysql_query($dbq1) or  show_error(mysql_error());

   // *****************************************
   // Update  downline_hit Sponsor
   // *****************************************
   mysql_query("UPDATE members SET dl_hit=dl_hit+1 WHERE userid='$parent1'") or  show_error(mysql_error());


      $Timestamper = time();
      $query = "INSERT INTO subscribers SET
          ResponderID ='1', EmailAddress = '$email',
          TimeJoined  = '$Timestamper', Real_TimeJoined = '$Timestamper',
          LastActivity = '$Timestamper', FirstName = '$name',CanReceiveHTML ='0',
          UserLevel = '0', UserID ='$userid'";

          $DB_result = mysql_query($query);

   // *****************************************


$letters_row=mysql_fetch_array(
             mysql_db_query($conf['dbname'],"SELECT newuser_msg,parent1_msg,parent2_msg,
             parent3_msg,admin_msg,user_title,parent1_title,parent2_title,parent3_title,
             admin_title FROM letters")) or show_error(mysql_error());

$newuser_msg    = $letters_row['newuser_msg'];
$parent1_msg     = $letters_row['parent1_msg'];
$parent2_msg     = $letters_row['parent2_msg'];
$parent3_msg     = $letters_row['parent3_msg'];
$admin_msg      = $letters_row['admin_msg'];

$user_title     = $letters_row['user_title'];
$parent1_title = $letters_row['parent1_title'];
$parent2_title = $letters_row['parent2_title'];
$parent3_title = $letters_row['parent3_title'];
$admin_title    = $letters_row['admin_title'];

$msg = parse_mail($newuser_msg);
$user_title = parse_mail($user_title);

//sendmail($conf['admin_email'],$email,$user_title,$msg,'1');

sendmail($conf['admin_email'],
         $conf['admin_name'],
         $email,
         $name,
         $user_title,
         $msg,
         1
         );


$msg = parse_mail($parent1_msg);
$parent1_title = parse_mail($parent1_title);
$p1_row=mysql_fetch_array(mysql_db_query($conf['dbname'],"SELECT email,name FROM members WHERE userid ='$parent1'"));
//sendmail($conf['admin_email'],$p1_row['email'],$parent1_title,$msg,'1');

sendmail($conf['admin_email'],
         $conf['admin_name'],
         $p1_row['email'],
         $p1_row['name'],
         $parent1_title,
         $msg,
         1
         );


$msg = parse_mail($parent2_msg);
$parent2_title = parse_mail($parent2_title);
$p2_row=mysql_fetch_array(mysql_db_query($conf['dbname'],"SELECT email,name FROM members WHERE userid ='$parent2'"));
//sendmail($conf['admin_email'],$p2_row['email'],$parent2_title,$msg,'1');

sendmail($conf['admin_email'],
         $conf['admin_name'],
         $p2_row['email'],
         $p2_row['name'],
         $parent2_title,
         $msg,
         1
         );


$msg = parse_mail($parent3_msg);
$parent3_title = parse_mail($parent3_title);
$p3_row=mysql_fetch_array(mysql_db_query($conf['dbname'],"SELECT email,name FROM members WHERE userid ='$parent3'"));
//sendmail($conf['admin_email'],$p3_row['email'],$parent3_title,$msg,'1');

sendmail($conf['admin_email'],
         $conf['admin_name'],
         $p3_row['email'],
         $p3_row['name'],
         $parent3_title,
         $msg,
         1
         );


// Kirim email kepada admin :
$msg = parse_mail($admin_msg);
$admin_title = parse_mail($admin_title);

//sendmail($email,$conf['admin_email'],$admin_title,$msg,'1');

sendmail($conf['admin_email'],
         $conf['admin_name'],
         $conf['admin_email'],
         $conf['admin_name'],
         $admin_title,
         $msg,
         1
         );


$show_array = array(
     'title' => "Registrasi IndoJutawan - Sponsor: $sponsor_name"
);

display_home_page("page_thanks.html",$show_array);
exit;
}
display_home_page("page_join.html",$show_array);


// Fungsi parse email :
function parse_mail($str) {
 global $conf, $userid,$password1,$bank,$name,$address,$city,$state,$zip,
        $phone,$email,$parent1,$parent2,$parent3,$parent1_amount,$lastip,
        $parent2_amount,$parent3_amount,$admin_amount,$val_kode,$yahooid;

        $msg = $str;

$p1_row=mysql_fetch_array(mysql_db_query($conf['dbname'], "SELECT name,email,bank,phone,userid,yahooid FROM members WHERE userid='$parent1'"))
             or  show_error(mysql_error());
$p2_row=mysql_fetch_array(mysql_db_query($conf['dbname'], "SELECT name,email,bank,phone,userid,yahooid FROM members WHERE userid='$parent2'"))
             or  show_error(mysql_error());
$p3_row=mysql_fetch_array(mysql_db_query($conf['dbname'], "SELECT name,email,bank,phone,userid,yahooid FROM members WHERE userid='$parent3'"))
             or  show_error(mysql_error());


      $msg = str_replace("{member_name}",$name,$msg);
      $msg = str_replace("{member_email}",$email,$msg);
      $msg = str_replace("{member_phone}",$phone,$msg);
      $msg = str_replace("{member_userid}",$userid,$msg);
      $msg = str_replace("{member_password}",$password1,$msg);
      $msg = str_replace("{member_address}",$address,$msg);
      $msg = str_replace("{member_city}",$city,$msg);
      $msg = str_replace("{member_state}",$state,$msg);
      $msg = str_replace("{member_zip}",$zip,$msg);
      $msg = str_replace("{member_bank}",$bank,$msg);
      $msg = str_replace("{member_ip}",$lastip,$msg);
      $msg = str_replace("{member_yahoo}",$yahooid,$msg);
      $msg = str_replace("{val_kode}",$val_kode,$msg);

      $msg = str_replace("{parent1_userid}",$p1_row['userid'],$msg);
      $msg = str_replace("{parent1_name}",$p1_row['name'],$msg);
      $msg = str_replace("{parent1_phone}",$p1_row['phone'],$msg);
      $msg = str_replace("{parent1_email}",$p1_row['email'],$msg);
      $msg = str_replace("{parent1_bank}",$p1_row['bank'],$msg);
      $msg = str_replace("{parent1_amount}",$parent1_amount,$msg);
      $msg = str_replace("{parent1_yahoo}",$p1_row['yahooid'],$msg);

     $msg = str_replace("{parent2_userid}",$p2_row['userid'],$msg);
     $msg = str_replace("{parent2_name}",$p2_row['name'],$msg);
     $msg = str_replace("{parent2_phone}",$p2_row['phone'],$msg);
     $msg = str_replace("{parent2_email}",$p2_row['email'],$msg);
     $msg = str_replace("{parent2_bank}",$p2_row['bank'],$msg);
     $msg = str_replace("{parent2_amount}",$parent2_amount,$msg);
     $msg = str_replace("{parent2_yahoo}",$p2_row['yahooid'],$msg);

     $msg = str_replace("{parent3_userid}",$p3_row['userid'],$msg);
     $msg = str_replace("{parent3_name}",$p3_row['name'],$msg);
     $msg = str_replace("{parent3_phone}",$p3_row['phone'],$msg);
     $msg = str_replace("{parent3_email}",$p3_row['email'],$msg);
     $msg = str_replace("{parent3_bank}",$p3_row['bank'],$msg);
     $msg = str_replace("{parent3_amount}",$parent3_amount,$msg);
     $msg = str_replace("{parent3_yahoo}",$p3_row['yahooid'],$msg);

     $msg = str_replace("{admin_name}",$conf['admin_name'],$msg);
     $msg = str_replace("{admin_phone}",$conf['admin_phone'],$msg);
     $msg = str_replace("{admin_email}",$conf['admin_email'],$msg);
     $msg = str_replace("{admin_bank}",$conf['admin_bank'],$msg);
     $msg = str_replace("{admin_address}",$conf['admin_address'],$msg);
     $msg = str_replace("{admin_amount}",$admin_amount,$msg);

     $msg = str_replace("{member_url}",$conf['member_url'],$msg);
     $msg = str_replace("{program_name}",$conf['program_name'],$msg);
     $msg = str_replace("{program_url}",$conf['program_url'],$msg);

     return $msg;

}


?>