<?include("header.php");
	
  if ($_POST["email"]!='' && $_POST["first_name"]!='')
  {
	  $msg='';
	  $sql="select count(*) from user_master where email='".$_POST["email"]."'";
	  $cmd = mysql_query($sql);
	  $rs = mysql_fetch_array($cmd);
	  if ($rs[0]==0)
	  {
		  $password=genpasswordnum(4);
		  $sql="insert into user_master(first_name,email,user_name,password,user_type,user_profile)values('".$_POST["first_name"]."','".$_POST["email"]."','".$_POST["email"]."','".$password."',3,'".pdbfx("user_profile")."')";
		   mysql_query($sql);
			$msg="Your password is email to to you.Please Check your email.";
			$body="Dear ".$_POST["first_name"].",<br>";
			$body.="Thank you for your registration at <a href=http://www.SeekYa.com target=_blank>www.SeekYa.com</a>";
			$body.="<br><br>Your Login password is ";
			$body.="<br><font color=blue><b>".$password."</b></font><br><br>Thanks,<br>Webmaster";
			$subject=$_POST["first_name"]." Your Password for SeekYa.com";
			$headers = "From: admin@SeekYa.com \nContent-Type: text/html";
			mail($_POST["email"],$subject,$body,$headers);
	  }
	  else
	  {
		 $msg="This email is already in use.";
	  }
  }
  ?>
  <?
  
  $sql="Select * from category_master where category_status=1  order by category_name";

  $cmdcat = mysql_query($sql);?>
  <h1><strong>Register</strong>
  </h1>
  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td width="5%">&nbsp;</td>
                        <td width="93%">
						
				
						  
						  
					
					    </td>
                        <td width="2%" align="right">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td colspan="3" style="padding-left:2; padding-right:2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td bgcolor="ffaa00"><table width="100%" border="0" cellspacing="1" cellpadding="0">
                                  <tr> 
                                    <td bgcolor="FDF5E5"><table width="100%" border="0" cellspacing="1" cellpadding="0">
                                        <tr> 
                                          <td><table width="100%" border="0" cellspacing="0" cellpadding="5">
                                              <tr> 
                                                <td width="94%" align="center" valign="top"><table width="91%" border="0" cellspacing="0" cellpadding="0">
                        


									 <tr> 
                      <td background="images/leftbgbox.gif" >&nbsp;</td>
                      <td valign="top"  style="PADDING-LEFT:0; padding-top:5"><table width="100%" height="100%" border="0" cellspacing="0" cellpadding="0">
						<tr> 
                            <td colspan="2" class="text">
							<b><u><?=$msg;?></u></b><br><br>
							</td>
                        </tr>

                          <tr> 
                            <td colspan="2" class="text"><form name=video method=POST action="register.php">
							Your Email : <input name="email" type="text" class="textbox" size="35"><br><br>
							</td>
                          </tr>
						   <tr> 
                            <td colspan="2" class="text">
							Your Name : <input name="first_name" type="text" class="textbox" size="35"><br><br>
							</td>
                          </tr>
						   <tr> 
                            <td colspan="2" class="text">
							We will email your password to above email.
							<br><br>
							</td>
                          </tr>
						    <tr> 
                            <td colspan="2" class="text">
							About Yourself(Optional) : <textarea name=user_profile class=textarea rows=8 cols=50 style="overflow:hidden;"></textarea><br><br>
							</td>
                          </tr>
						 <tr> 
                            <td colspan="2" class="text" align=center>
							<input type=submit name=advance class=button value="Register >>"><br><br>
							
							</form></td>
                          </tr>
						 

							
                          	
						 
                        </table></td>
                      
                    </tr>
                    
                  </table></td>
              </tr>
                                                  </table></td>
                                                <td width="76%" valign="top"><table width="100%" border="0" cellspacing="3" cellpadding="0">
                                                   
                                                    
                                                    <tr> 
                                                      <td colspan="2" class="text"><img src="images/trans.gif" width="1" height="10"></td>
                                                    </tr>
                                                   
													
                                                  </table></td>
                                              </tr>
                                            </table></td>
                                        </tr>
                                        <tr> 
                                          <td background="images/middleboxbotstrip.gif"><img src="images/middleboxbotstrip.gif" width="2" height="11"></td>
                                        </tr>
                                      </table></td>
                                  </tr>
                                </table></td>
                            </tr>
  </table></td>
                      </tr>
                    </table></td>
                </tr>

 
  

  <?include("footer.php");
?>
<script>
	function openWin(argURL, argSize) {
	window.open(argURL, "x_win" + (new Date()).getTime(), "resizable=yes,scrollbars=yes," + argSize);
}
</script>