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