unset($_SESSION['member']);
$cap = 'notEq';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['txtCapchainput'] == $_SESSION['cap_code']) {
$cap = 'Eq';
$alphanum = "0123456789";
$alphaz = "0123456789qwertyuioplkjhgfdsazxcvbnm";
$code_cards = substr(str_shuffle($alphanum), 0, 5);
$passNew = substr(str_shuffle($alphaz), 0, 8);
if (isset($_POST['btnSignEmail'])) {
$pass = md5($passNew);
$capcha = isset($_POST['txtCapcha']) ? trim($_POST['txtCapcha']) : '';
$capchainput = isset($_POST['txtCapchainput']) ? trim($_POST['txtCapchainput']) : '';
$email1 = isset($_POST['txtUid']) ? trim($_POST['txtUid']) : '';
$email = chackInputSql($email1);
$openidReturn_to = isset($_POST['openidReturn_to']) ? trim($_POST['openidReturn_to']) : '';
if (check_email_address($email)) {
$errMsg = '';
} else {
$errMsg = CEMAILTHISVARIANCE;
}
/*if($capcha!=$capchainput){
$errMsg = TINCORRECTSECURITYCODE;
}else{
$errMsg = '';
}*/
if ($errMsg == '') {
// kiem tra bao loi
//up date mat khau moi
$fields_arrForgotpassUpdate = array("pwd" => "'{$pass}'", "last_modified" => "now()", "lang" => "'{$_lang}'");
//nguoi gioi thieu
$address = isset($_POST['txtAddress']) ? trim($_POST['txtAddress']) : '';
$type_member = isset($_POST['type_member']) ? trim($_POST['type_member']) : '0';
$pass = isset($_POST['txtPwd']) ? trim($_POST['txtPwd']) : '';
$voucher = isset($_POST['txtCodeVoucher']) ? trim($_POST['txtCodeVoucher']) : '';
$discouts = isset($_POST['comboDiscounts']) ? trim($_POST['comboDiscounts']) : 0;
$email = chackInputSql($email1);
$date_from = isset($_POST['date-from']) ? trim($_POST['date-from']) : time();
$date_from1 = explode('/', $date_from);
$date_from2 = $date_from1[1] . '/' . $date_from1[0] . '/' . $date_from1[2] . " 00:00:01";
$date_from = strtotime($date_from2);
$date_to = isset($_POST['date-to']) ? trim($_POST['date-to']) : time();
$date_to1 = explode('/', $date_to);
$date_to2 = $date_to1[1] . '/' . $date_to1[0] . '/' . $date_to1[2] . " 23:59:59";
$date_to = strtotime($date_to2);
$name = chackInputSql($name1);
$ldate = $strtotimeDmy;
//LAY THONG TIN NGUOI GIOI THIEU
if ($email == '') {
$errMsg = CYOUMAYENTEREMAIL;
} else {
$errMsg = '';
}
if (check_email_address($email)) {
$errMsg = '';
} else {
$errMsg = CFNBOXMALFORMED;
}
if ($name == '') {
$errMsg = CNAME;
} else {
$urlCode = removeVietnamese($name, " ", "-");
//lay url tu dong
$phone = strip_tags($phone1);
$address = strip_tags($address1);
$email = chackInputSql($email1);
$birthday = chackInputSql($birthday1);
$telephone = chackInputSql($telephone1);
$schools = chackInputSql($schools1);
$majors = chackInputSql($majors1);
$subject = chackInputSql($subject1);
$yexperience1 = isset($_POST['txtYexperience']) ? trim($_POST['txtYexperience']) : '';
//students_number
$higher_scores1 = isset($_POST['txtHigher_scores']) ? trim($_POST['txtHigher_scores']) : '';
//tong diem 3 mon
$yexperience = chackInputSql($yexperience1);
$higher_scores = chackInputSql($higher_scores1);
$classes_good = isset($_POST['classes_good']) ? trim($_POST['classes_good']) : '';
$price = isset($_POST['txtPrice']) ? trim($_POST['txtPrice']) : '';
for ($e = 1; $e <= count($TYPE_SEARCH['TG_SCT']); $e++) {
$tg_scts1 = $_POST['TG_SCTS' . $e] != '' ? $e : 0;
$tg_sctc1 = $_POST['TG_SCTC' . $e] != '' ? $e : 0;
$tg_sctt1 = $_POST['TG_SCTT' . $e] != '' ? $e : 0;
$tg_scts2 .= $tg_scts1 . '_';
$tg_sctc2 .= $tg_sctc1 . '_';
$tg_sctt2 .= $tg_sctt1 . '_';
}
$tg_scts = substr($tg_scts2, 0, -1);
$tg_sctc = substr($tg_sctc2, 0, -1);
$tg_sctt = substr($tg_sctt2, 0, -1);
$detail_short = isset($_POST['txtDetailShort']) ? trim($_POST['txtDetailShort']) : '';
$keywords = removeUtf8($name);
//kiem tra neu da bam nut
unset($_SESSION['member']);
unset($_SESSION['memberlogin']);
echo "<script>window.location='" . $serverName . $_lang . '?openidReturn_to=' . $urlFullMahoa . "'</script>";
}
if (!isset($_SESSION['member']) || $_SESSION['member'] == '') {
$flagLogin = false;
} else {
$flagLogin = true;
}
if (isset($_POST['login'])) {
//kiem tra bat dau tu trang login============================
$email1 = trim($_POST['txtUid']);
$pass1 = $_POST['txtPwd'];
$email = chackInputSql($email1);
$pass = chackInputSql($pass1);
$auto_login = $_POST['chackLogin'] != '' ? 1 : 0;
$openidReturn_to = $_POST['openidReturn_to'];
if (!isset($_SESSION['member']) || $_SESSION['member'] == '') {
//kiem tra session da ton tai hay chua tao moi============================
$resultSignIn = @mysql_query("select * from " . $tableMemberId . " where email='" . $email . "' and " . $whereStatus . " limit 1", $conn);
$rowsSignIn = @mysql_num_rows($resultSignIn);
if ($rowsSignIn < 1) {
$errMsg = MWRONGUSERNAME;
} else {
$rowSignIn = @mysql_fetch_array($resultSignIn);
if ($pass != $rowSignIn['pwd']) {
$errMsg = MWRONGPASSWORD . " - <a href=\"" . $serverName . FRAMEMEMBERYFPNAME . '/?openidReturn_to=' . $openidReturn_to . "\" class=\"name_xanh\" title=\"" . MFORGOTPASSWORD . "\" class=\"font11\">" . MFORGOTPASSWORD . "?</a>";
} else {
$flagLogin = true;
$idMember = $rowSignIn['id'];
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if ($_POST['txtCapchainput'] == $_SESSION['cap_code']) {
$cap = 'Eq';
$email1 = isset($_POST['txtUid']) ? trim($_POST['txtUid']) : '';
$passSend1 = isset($_POST['txtpass']) ? trim($_POST['txtpass']) : '';
$pass1 = isset($_POST['txtPwd']) ? trim($_POST['txtPwd']) : '';
$phone = isset($_POST['txtPhone']) ? trim($_POST['txtPhone']) : '';
$name1 = isset($_POST['txtName']) ? trim($_POST['txtName']) : '';
//nguoi gioi thieu
$referrer1 = isset($_POST['txtCode']) ? trim($_POST['txtCode']) : '';
$type_member = $_POST['type_member'];
$email = chackInputSql($email1);
$passSend = chackInputSql($passSend1);
$pass = chackInputSql($pass1);
$name = chackInputSql($name1);
$referrer = chackInputSql($referrer1);
$capcha = isset($_POST['txtCapcha']) ? trim($_POST['txtCapcha']) : '';
$capchainput = isset($_POST['txtCapchainput']) ? trim($_POST['txtCapchainput']) : '';
$codereferrer = $referrer;
$openidReturn_to = $_POST['openidReturn_to'];
$ldate = $strtotimeDmy;
//LAY THONG TIN NGUOI GIOI THIEU
if ($email == '') {
$errMsg = CYOUMAYENTEREMAIL;
} else {
$errMsg = '';
}
if (check_email_address($email)) {
$errMsg = '';
} else {
$errMsg = CFNBOXMALFORMED;
}
//lay theo ngon ngu
} else {
//neu tham moi
$fields_arr = array("parent" => "{$codeParent}", "parent_1" => "'{$parent_1}'", "id_member" => "'{$idMember}'", "name_member" => "'{$nameMember}'", "ldate" => "'{$ldate}'", "name" => "'{$name}'", "code" => "'{$code}'", "district" => "'{$district}'", "city" => "'{$city}'", "website" => "'{$website}'", "phone" => "'{$phone}'", "email" => "'{$email}'", "sex" => "'{$sex}'", "discount_start_date" => "'{$discount_start_date}'", "discount_end_date" => "'{$discount_end_date}'", "url" => "'{$urlCode}'", "last_modified" => "now()", "date_added" => "now()", "lang" => "'{$_lang}'");
$updateprofileId = insert($tableNewId, $fields_arr);
$oldid = @mysql_insert_id();
//lay id vua them vo
//lay theo ngon ngu
foreach ($conf as $ln => $j) {
$name1 = isset($_POST['txtName' . $ln]) ? trim($_POST['txtName' . $ln]) : '';
$name = chackInputSql(strip_tags($name1));
$urlCode = removeVietnamese($name, " ", "-");
//lay url tu dong
$address1 = isset($_POST['txtAddress' . $ln]) ? trim($_POST['txtAddress' . $ln]) : '';
$address = chackInputSql(strip_tags($address1));
$detail_short = isset($_POST['txtDetailShort' . $ln]) ? trim($_POST['txtDetailShort' . $ln]) : '';
//$detail_short = strip_tags($detail_short1,'<script><iframe>');
$detail = isset($_POST['txtDetail' . $ln]) ? trim($_POST['txtDetail' . $ln]) : '';
//$detail = strip_tags($detail1,'<script><iframe>');
$keywords = $name;
$description = substrNumber(strip_tags($detail_short), '160', '');
$fields_arr1 = array("id_code" => "{$oldid}", "parent" => "{$codeParent}", "parent_1" => "'{$parent_1}'", "id_member" => "'{$idMember}'", "name_member" => "'{$nameMember}'", "ldate" => "'{$ldate}'", "name" => "'{$name}'", "code" => "'{$code}'", "district" => "'{$district}'", "detail" => "'{$detail}'", "detail_short" => "'{$detail_short}'", "city" => "'{$city}'", "website" => "'{$website}'", "address" => "'{$address}'", "phone" => "'{$phone}'", "email" => "'{$email}'", "sex" => "'{$sex}'", "discount_start_date" => "'{$discount_start_date}'", "discount_end_date" => "'{$discount_end_date}'", "keywords" => "'{$keywords}'", "description" => "'{$description}'", "url" => "'{$urlCode}'", "last_modified" => "now()", "date_added" => "now()", "lang" => "'{$ln}'");
//$updateprofileId = update($tableNewId,$fields_profile,"id=".$oldid);
$updateprofile = insert($tableNew, $fields_arr1);
$rowoldidLn = getRecord($tableNew, 'id_code=' . $oldid . " and lang='" . $ln . "'");
$oldidLn = $rowoldidLn['id'];
//lay id vua them vo
//kiem tra url nay da ton tai hay chua
if (countRecord($tableNew, "url='" . $urlCode . "' and id<>" . $oldidLn) > 0) {
$urlCodeUp = $urlCode . "-" . $oldidLn;