1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
|
<?php include_once("./_common2.php"); ?>
<?php
include("../../manage/category/common.php");
@extract($_POST);
@extract($_GET);
$sql = "set names utf8";
mysql_query($sql);
$tel = $tel1."-".$tel2."-".$tel3;
$hp = $hp1."-".$hp2."-".$hp3;
$fax = $fax1."-".$fax2."-".$fax3;
$addres = $message;
date_default_timezone_set('Asia/Seoul');
if($mode=='new'){
$select_content2 = str_replace("^","*",$select_content2);
if($pro_call=='Y'){
$select_content2 = $select_content2.chr(13).chr(13)."※ 견적서 제출 전 추가상담을 위해 담당자가 연락주시기 바랍니다.";
}
if($cur_page2!=1 && strlen($page_history2)>3 && $select_content2!=''){
$reg_date = date("Y-m-d H:i:s");
//if($_COOKIE['USERID']=='tshop0103'){
//print_r($_POST); exit;
if($view_mode=='mobile'){
$smtitle = "consult-mobile";
$come_from = "mjsoft.co(m)";
} else {
$smtitle = "consult-pc";
$come_from = "mjsoft.co";
}
if($st_type=='mail_cs'){
$smtitle = "mail-cs";
}
if($come_from=='www.easytax.kr' || $come_from=='www.easytax.kr(m)'){
$smtitle = "tax";
}
if($come_from=='www.ebizmall.co.kr' || $come_from=='www.ebizmall.co.kr(m)'){
$smtitle = "biz";
}
if($come_from==''){ $come_from = 'mjsoft.co'; }
if($iw == 'mail_way'){
$select_content2 = "(M)".$select_content2;
}
if($inflow_txt != "") { // 유입경로 선택이 있다면
$inflow = $inflow_txt;
} else {
$inflow = "요청게시판 접수";
}
$insertQry = "insert into mBoard_install_req set smname = '{$company}', smtel = '{$tel}', smtitle = '{$smtitle}', telname = '{$name}', smdetail = '{$select_content2}',
contact_time = '{$ct_time}', ipadd = '".$_SERVER['REMOTE_ADDR']."', reg_date = '{$reg_date}', prog_select = '', come_from = '{$come_from}',
hptel = '{$hp}', faxtel = '{$fax}', s_email = '{$email}', address = '{$message}', inflow = '{$inflow}'
{$add_insert}
";
/*
} else {
if($iw == 'mail_way'){
$select_content2 = "(M)".$select_content2;
}
$insertQry = " insert into mBoard_consult (company, name, respon, tel, hp, fax, email, hope_date, address, product, add_product, detail, gubun, reg_date, mobile)
values ('{$company}','{$name}','{$respon}','{$tel}','{$hp}','{$fax}','{$email}','{$estidate}','{$addres}','{$productname}','{$addproduct}','{$select_content2}', 0,'{$reg_date}','{$view_mode}')";
}
*/
mysql_query($insertQry);
} else {
echo "정상적인 방법으로 접근하시기 바랍니다.";
}
} else {
if($cur_page*1>1 && strlen($page_history)>3 && $select_content!=''){
$reg_date = date("Y-m-d H:i:s",time());
$insertQry = " insert into mBoard_consult (company, name, respon, tel, hp, fax, email, hope_date, address, product, add_product, detail, gubun, reg_date, mobile)
values ('{$company}','{$name}','{$respon}','{$tel}','{$hp}','{$fax}','{$email}','{$estidate}','{$addres}','{$productname}','{$addproduct}','{$select_content}', 0,'{$reg_date}','{$view_mode}')";
mysql_query($insertQry);
} else {
echo "정상적인 방법으로 접근하시기 바랍니다.";
}
}
?>
|