include ("./systemy/config.php");
include ("./systemy/hihot_functiom.php");
//跳手機板
$window = isPhone();
if ($window) {
if (preg_match('/members.php/',$_SERVER['REQUEST_URI'])) {
header('Location:'.'/mobile/login.php');
} elseif (preg_match('/products_list.php/',$_SERVER['REQUEST_URI'])) {
header('Location:'.'/mobile/products.php');
} elseif (preg_match('/products.php/',$_SERVER['REQUEST_URI'])) {
header('Location:'.'/mobile/products2.php');
} elseif (preg_match('/contacts.php/',$_SERVER['REQUEST_URI'])) {
header('Location:'.'/mobile/contact.php');
} else {
header('Location:'.'/mobile'.$_SERVER['REQUEST_URI']);
}
}
$upload_path="./upload/product/";
$product_sql = sprintf("SELECT * FROM product_tb WHERE product_sn= %s", quote_smart($_GET['show']));
$product_data = mysql_get_info($product_sql);
$memb_sql = sprintf("SELECT * FROM member_tb WHERE member_sn = %s",quote_smart($_SESSION['security']['member_sn']));
$memb_data = mysql_get_info($memb_sql);
$_SESSION['security']['product_sn']=$product_data['product_sn'];
$_SESSION['security']['product_type']=$product_data['product_depend_sn'];
$cart_sql = "SELECT * FROM variable_tb ";
$cart_data = mysql_get_info( $cart_sql, $show_error );
//瀏覽數
$check_sql = sprintf("SELECT * FROM product_amount_tb WHERE product_type =%s AND product_psn =%s AND product_created_time =%s",quote_smart($product_data['product_depend_sn']),quote_smart($_GET['show']), quote_smart(date("Y").'-'.date("m").'-'.date("d")));
$check_data = mysql_get_info( $check_sql );
if( $check_data['product_created_time'] != date("Y").'-'.date("m").'-'.date("d") ) {
$update_sql = sprintf("INSERT INTO product_amount_tb ( product_type ,product_psn , product_master_sn , product_count , product_created_time ) VALUES ( %s, %s, %s, %s, %s )",quote_smart($product_data['product_depend_sn']),quote_smart($_GET['show']),quote_smart($product_data['product_depend_sn']), 1 , quote_smart(date("Y").'-'.date("m").'-'.date("d")));
mysql_execute( $update_sql );
} else {
$product_count=$check_data['product_count'] + 1;
$update_sql = sprintf("UPDATE product_amount_tb SET product_count = %s WHERE product_sn = %s LIMIT 1",quote_smart($product_count ) , quote_smart( $check_data['product_sn'] , false ) );
mysql_execute( $update_sql );
}
//產品詢問
if( $_POST['check_pass'] == "Y" ) {
if(trim($_POST['name']) != "" ) {
$order_sql = sprintf("INSERT INTO inquiry_product_tb ( inquiry_show_sn,inquiry_question,inquiry_created_time) VALUES ( %s,%s,%s)",quote_smart($_SESSION['security']['member_sn']),quote_smart($_POST['comment']),quote_smart( date("Y-m-d H:i:s") ));
mysql_execute( $order_sql );
$new_inquiry_sn = mysql_insert_id();
$details_sql = sprintf("INSERT INTO inquiry_product_detail_tb (
detail_inquiry_sn,
detail_id,
detail_name,
detail_type,
detail_email,
detail_product_sn,
detail_product_name ) VALUES ( %s, %s, %s, %s, %s, %s, %s )",
quote_smart( $new_inquiry_sn, false ),
quote_smart( $_SESSION['security']['member_id'] ),
quote_smart( $_POST['name'] ),
quote_smart( $_SESSION['security']['product_type']),
quote_smart( $_POST['email'] ),
quote_smart( $_SESSION['security']['product_sn'] ),
quote_smart( $product_data['product_name'] ));
mysql_execute( $details_sql );
$title = "來自" .query_website_name(). "網站 產品詢問信件";
$default_content = "您好!\r\n\r\n您有一則新的產品詢問\r\n\r\n請儘速上後台查看詢問內容,\r\n\r\n請按此:"."前往";
sendmail( $title ,$default_content, query_website_email() , query_website_name() ,$_SESSION['security']['member_name'],$_SESSION['security']['member_email']);
show_message("您的產品詢問我們已經收到了,我們會儘快回覆您!!",$_SERVER['HTTP_REFERER']);
exit();
}else{
show_message("部分欄位輸入不完整,請重新輸入,謝謝。",$_SERVER['HTTP_REFERER']);
exit();
}
}
//產品推薦
if( $_POST['check_pass2'] == "Y" ) {
//if(trim($_POST['share_friend_name']) != "" AND trim($_POST['share_friend_email']) != "" ) {
//推薦好友一
$mail_body = "
";
$mail_body .= "==== ".query_website_name()." 產品推薦====
";
$mail_body .= "推薦人姓名:".$_POST['share_name']."
";
$mail_body .= "推薦人E-mail:".$_POST['share_email']."
";
$mail_body .= "好友姓名:".$_POST['share_friend_name']."
";
$mail_body .= "好友E-mail:".$_POST['share_friend_email']."
";
$mail_body .= "標題:".$_POST['share_title']."
";
$mail_body .= "內容:
".nl2br($_POST['share_comment'])."
";
$headers = "From: ".$_POST['share_friend_email']."\r
" .'Reply-To:'.$_POST['share_email'] . "\r
" .'X-Mailer: PHP/' . phpversion();
$title ="來自".query_website_name()." 網站==產品推薦==";
sendmail($title ,$mail_body,$_POST['share_friend_email'], $_POST['share_friend_name'], $_POST['share_name'], $_POST['share_email'] );
//推薦好友二
$mail_body2 = "
";
$mail_body2 .= "==== ".query_website_name()." 產品推薦====
";
$mail_body2 .= "推薦人姓名:".$_POST['share_name']."
";
$mail_body2 .= "推薦人E-mail:".$_POST['share_email']."
";
$mail_body2 .= "好友姓名:".$_POST['share_friend_name2']."
";
$mail_body2 .= "好友E-mail:".$_POST['share_friend_email2']."
";
$mail_body2 .= "標題:".$_POST['share_title']."
";
$mail_body2 .= "內容:
".nl2br($_POST['share_comment'])."
";
$headers = "From: ".$_POST['share_friend_email2']."\r
" .'Reply-To:'.$_POST['share_email'] . "\r
" .'X-Mailer: PHP/' . phpversion();
$title ="來自".query_website_name()." 網站==產品推薦==";
sendmail($title ,$mail_body2,$_POST['share_friend_email2'], $_POST['share_friend_name2'], $_POST['share_name'], $_POST['share_email'] );
// 郵件標題,內容,收信人信箱,收信人,寄信人,寄信人信箱
//mb_internal_encoding("UTF-8");
//mb_send_mail($_POST['share_friend_email'],$title , $mail_body , $headers);
show_message($success_message[1][10],$_SERVER['HTTP_REFERER']);
exit();
//}
}
?>