this the other half
</td>
<td class="lined body padded-6" valign=top>
<span class="subtitle">Using a Spam Filter?</span></br></br>
Add our site to your list of approved domains now so you can receive your registration confirmation and messages from other members.
</td>
<td class="lined body padded-6" valign=top>
<span class="subtitle">What's in a Name?</span></br></br>
<p>Your first and last name will only be visible to your 1 degree Friends -- people who are DIRECTLY CONNECTED to you.
<p>Anyone who is 2 degrees removed will see your FIRST NAME and the FIRST INITIAL of your last name.
<p>People who are 3 degrees removed or more will only see your FIRST name.
</td>
</table>
</td>
</table>
<?
show_footer();
}
function do_register(){
$m_id=cookie_get("mem_id");
if($m_id!=''){
error_screen(25);
}
global $main_url;
//getting values from form
$form_data=array ("password","password2","fname","lname","gender","inv_id",
"day","month","year","email","email2","zip","country","terms","showloc","showgender","showage","pack");
while (list($key,$val)=each($form_data)){
${$val}=form_get("$val");
}
$sql="select * from member_package where package_id=$pack";
$res=mysql_query($sql);
$row=mysql_fetch_object($res);
$package_amt=$row->package_amt;
$sql_query="select mem_id from members where email='$email'";
$num2=sql_execute($sql_query,'num');
//values check
$password=trim($password);
$email=strtolower(trim($email));
$email=trim($email);
$email=str_replace( " ", "", $email );
$email=preg_replace( "#[\;\#\n\r\*\'\"<>&\%\!\(\)\{\}\[\]\?\\/]#", "", $email );
$email2=strtolower(trim($email2));
$email2=trim($email2);
$email2=str_replace( " ", "", $email2 );
$email2=preg_replace( "#[\;\#\n\r\*\'\"<>&\%\!\(\)\{\}\[\]\?\\/]#", "", $email2 );
$passl=strlen($password);
if(!isset($terms)){
$terms="no";
}
//checking if e-mail and confirm e-mail fields are equal
if($email!=$email2){
error_screen(1);
}
//checking if password and confirm password fields are equal
if($password!=$password2){
error_screen(2);
}
//if required values empty
elseif(($password=='')||($email=='')||($terms=='no')||($fname=='')||($lname=='')
||($gender=='')||($day==0)||($month==0)||($year==0)||($zip=='')||($country=='')){
error_screen(3);
}
//checking if this e-mail is already used
elseif($num2!=0){
error_screen(4);
}
//checking password length
elseif(($passl<4)||($passl>12)){
error_screen(7);
}
else{
//crypting password
$crypass=md5($password);
//preparing sql query
if($showloc==''){
$showloc=1;
}
if($showgender==''){
$showgender=1;
}
if($showage==''){
$showage=1;
}
$birthday=maketime(0,0,0,$month,$day,$year);
//adding data to db
$joined=time();
$crypass=md5($password);
if($package_amt=='0.00') {
$mem_st="F";
$p_stat="Y";
} else {
$mem_st="P";
$p_stat="N";
}
$sql_query="insert into members (email,password,fname,lname,zip,country,showloc,showgender,showage,gender,birthday,joined,mem_stat,mem_acc,pay_stat)
values ('$email','$crypass','$fname','$lname','$zip','$country','$showloc','$showgender','$showage','$gender','$birthday','$joined','$mem_st','$pack','$p_stat')";
sql_execute($sql_query,'');
$sql_query="select max(mem_id) as maxid from members";
$mem=sql_execute($sql_query,'get');
@mkdir("blog/".$mem->maxid,0777);
chmod("blog/".$mem->maxid,0777);
@copy("blog_url.php","blog/".$mem->maxid."/index.php");
//creating photo album
$sql_query="insert into photo(mem_id) values ('$mem->maxid')";
sql_execute($sql_query,'');
$time=time();
$sql_query="insert into profiles(mem_id,updated) values('$mem->maxid','$time')";
sql_execute($sql_query,'');
//sending sign-up e-mail (validation notice)
$val_key=$email.time();
$val_key=md5($val_key);
$sql_query="insert into validate (email,password,val_key) values ('$email','$password','$val_key')";
sql_execute($sql_query,'');
$data="<a href='$main_url/index.php?mode=join&act=val&val_key=$val_key&inv_id=$inv_id'>Verify Email</a>";
messages($email,'0',$data);
//showing a congratulation page
$sql_query="update stats set day_sgns=day_sgns+1,week_sgns=week_sgns+1,month_sgns=month_sgns+1";
sql_execute($sql_query,'');
if($package_amt=='0.00') complete_screen(0);
else {
global $main_url;
$link=$main_url."/index.php?mode=paypal&pack=$pack&mem_id=$mem->maxid";
show_screen($link);
}
}
}
function validate(){
//getting validate key
$val_key=form_get("val_key");
$inv_id=form_get("inv_id");
$sql_query="select * from validate where val_key='$val_key'";
$num=sql_execute($sql_query,'num');
//if val key is invalid showing error
if($num==0){
error_screen(6);
}
$val=sql_execute($sql_query,'get');
$data[0]=$val->email;
$data[1]=$val->password;
//sending user login info
messages($val->email,"2",$data);
//updating db (account verified)
$sql_query="delete from validate where val_key='$val_key'";
sql_execute($sql_query,'');
$sql_query="update members set verified='y' where email='$data[0]'";
sql_execute($sql_query,'');
if($inv_id!=''){
$sql_query="select * from invitations where inv_id='$inv_id'";
$frd=sql_execute($sql_query,'get');
$sql_query="select mem_id from members where email='$data[0]'";
$mem=sql_execute($sql_query,'get');
$sql_query="insert into network (mem_id,frd_id)
values ($mem->mem_id,$frd->mem_id),($frd->mem_id,$mem->mem_id)";
sql_execute($sql_query,'');
$sql_query="update invitations set stat='f' where inv_id='$inv_id'";
sql_execute($sql_query,'');
}//if
$sql_query="select mem_id from invitations where email='$data[0]' and stat!='f'";
$res=sql_execute($sql_query,'res');
$num=mysql_num_rows($res);
if($num!=0){
while($inv=mysql_fetch_object($res)){
$now=time();
$sql_query="select mem_id from members where email='$data[0]'";
$mem=sql_execute($sql_query,'get');
$subj="Invitation to Join ".name_header($inv->mem_id,"ad")."\'s Personal Network";
$bod="After you push \"Confirm\" button user ".name_header($inv->mem_id,"ad").
" will be added to your friends network.";
$sql_query="insert into messages_system(mem_id,frm_id,subject,body,type,folder,date)
values('$mem->mem_id','$inv->mem_id','$subj','$bod','friend','inbox','$now')";
sql_execute($sql_query,'');
}//while
}//if
complete_screen(2);
}
?>
