You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
56 lines
1.6 KiB
56 lines
1.6 KiB
<?php |
|
/** |
|
* Created by xiaofu.qin |
|
* Description: 用户在前端页面请求激活码，其实这些激活码是从finereport官网上获取的，并没有存入数据库中，所以该文件就是接受index.php的ajax传递进来的激活码进行数据库保存操作。 |
|
*/ |
|
session_start(); |
|
define('FINEREPORT', '100'); |
|
require_once '../myFunc/mysql_beta.php'; |
|
|
|
|
|
|
|
//判断前端页面传递回来的token是否正确 |
|
if( !isset($_POST['token']) || $_POST['token'] !== $_SESSION['token'] ) { |
|
exit('Go home,my boy!'); |
|
} |
|
|
|
$key = addslashes(htmlspecialchars($_POST["key"])); |
|
$type = addslashes(htmlspecialchars($_POST['type'])); |
|
$uid = $_SESSION['uid']; |
|
$time = time(); |
|
|
|
|
|
$conn = connect(); |
|
|
|
if( $type == 'fineBI' ) { |
|
$sql = 'update pre_common_member_profile set finebi_code=?, finebi_activation_time=? where uid=?'; |
|
}else { |
|
$sql = 'update pre_common_member_profile set finereport_code=?, finereport_activation_time=? where uid=?'; |
|
} |
|
|
|
|
|
$stmt = $conn->prepare($sql); |
|
|
|
if( !$stmt ) { |
|
exit('false'); |
|
} |
|
|
|
$stmt->bind_param('sii', $key, $time, $uid); |
|
$stmt->execute(); |
|
if( $stmt->affected_rows !== 1){ |
|
exit('Can not insert into the database'); |
|
} |
|
//发送邮件 |
|
|
|
require_once '../myFunc/clueReceipt.php'; |
|
if( isset($_SESSION['email']) && strlen($_SESSION['email'])>0 ) { |
|
$nameforsend = isset($_SESSION['realname'])? $_SESSION['realname']: '尊敬的用户'; |
|
if($type == 'fineReport') { |
|
$reqresult = send_mail($_SESSION['email'], 'zlwd',$subject='【帆软】这是关于FineReport的更多资料', ARRAY("%key%" => ARRAY($nameforsend))); |
|
} |
|
} |
|
|
|
echo 'true'; |
|
|
|
$stmt->free_result(); |
|
$conn->close(); |