include ('common/core.php'); ?> $banner = 'N'; // required to show banner in left vertical column ?> if (!isset($_SESSION['mid'])) {?>
global $sitename, $include, $css, $js; ?> if (isset($sts)) { if (isset($iaccept)) { $memexist = new FC_SQL; $table = " $dbrb_member_mst "; $select = "select $dbrb_member_email from "; $where = " where lower($dbrb_member_email) = lower('".$memail."')"; $memexist->query($table,$where,$extra="",$select); //echo $select.$table.$where; if($memexist->num_of_rows()>0) { while($memexist->next_record()) { $errormsg = "The email you have chosen is already registered. If you have forgotten your password, " . "click here."; //break; } } else { $insertmem = new FC_SQL; $table=" $dbrb_member_mst ($dbrb_member_prefix, $dbrb_member_mfname,$dbrb_member_mlname,$dbrb_member_madd1,$dbrb_member_madd2,$dbrb_member_madd3,$dbrb_member_city,$dbrb_member_state,$dbrb_member_country,$dbrb_member_pin,$dbrb_member_email,$dbrb_member_passwd,$dbrb_member_encryp_passwd,$dbrb_member_stdcode,$dbrb_member_restel,$dbrb_member_mobile,$dbrb_member_newsletter,$dbrb_member_mempoints,$dbrb_member_regdate,$dbrb_member_last_login) " ; $where=" values('$mprefix ', '".ucfirst(trim($mfname))."','".ucfirst(trim($mlname))."','".ucfirst(trim($madd1))."','".ucfirst(trim($madd2))."','".ucfirst(trim($madd3))."','".ucfirst(trim($mcity))."','".ucfirst(trim($mstate))."','".ucfirst(trim($mcountry))."','".$mpin."','".trim($memail)."','".trim($mpass)."','".md5(trim($mpass))."','".trim($mstd)."','".trim($mtel)."','".trim($mmobile)."','Y','0','".date("Y-m-d H:i:s")."', now())"; $select="insert into "; $insertmem->query($table,$where,$extra="",$select); getlogin(trim($memail), trim($mpass), $sitename); } } } ?>