function snapSendFeedback($snapDbConn, $data)
{
global $APPCONFIG;
$adminEmail = $APPCONFIG['EMAIL']['ADMINEMAILADDRESS'];
$contactname = $data['name'];
$contactemail = $data['emailaddress'];
$message = $data['message'];
$ipaddress = $_SERVER['REMOTE_ADDR'];
$browser = $_SERVER['HTTP_USER_AGENT'];
$feedbackdetails = "<p>";
$feedbackdetails .= "Name: {$contactname}<br />";
$feedbackdetails .= "Email: {$contactemail}<br />";
$feedbackdetails .= "Browser: {$browser}<br />";
$feedbackdetails .= "IP Address: {$ipaddress}<br />";
$feedbackdetails .= "Message: {$message}<br />";
$feedbackdetails .= "</p>";
$contentData = array('FEEDBACKDETAILS' => $feedbackdetails);
snapSendFalconEmail('feedbackform', $adminEmail, $contentData);
$query = "insert into snap_feedback (contactname,contactemail,browser,ipaddress,message,addedon) values(?,?,?,?,?,now()) ";
$arrParams = array('sssss', &$contactname, &$contactemail, &$browser, &$ipaddress, &$message);
$result = snapDbQuery($snapDbConn, $query, $arrParams);
if (!$result['insert_id']) {
return 0;
}
return array('type' => 'success', 'descr' => 'Feedback / Query registered successfully');
}
echo $err;
exit;
}
//empty request params
if (empty($userid) || empty($uniqid)) {
sendError(1);
}
//db connect failed
$snapDbConn = snapCreateDbConnect('snapdb');
if (!$snapDbConn) {
sendError(2);
}
//check uniqid comparison
$query = "select id,userid,username,email,linktime,verifyid,linktype,linkstatus from snap_linktrack where userid = ? and linktype = 'resetpassword' order by id desc limit 1";
$arrParams = array('s', &$userid);
$result = snapDbQuery($snapDbConn, $query, $arrParams);
if (!isset($result['rows'])) {
sendError(1);
}
$linkid = $result['rows'][0]->id;
$userid = $result['rows'][0]->userid;
$username = $result['rows'][0]->username;
$email = $result['rows'][0]->email;
$linktime = $result['rows'][0]->linktime;
$verifyid = $result['rows'][0]->verifyid;
$linkstatus = $result['rows'][0]->linkstatus;
//uniqid does not match the verify id in db
if ($uniqid != $verifyid) {
sendError(3);
}
//linkstats = 1 mean old link
