62 $stmt = $mysqli->prepare(
"UPDATE " . $db[
'users'] .
"
64 last_sign_in_stamp = ?
67 $stmt->bind_param(
"ii", $time, $this->userId);
79 $stmt = $mysqli->prepare(
"SELECT sign_up_stamp
80 FROM " . $db[
'users'] .
"
82 $stmt->bind_param(
"i", $this->userId);
84 $stmt->bind_result($timestamp);
97 $stmt = $mysqli->prepare(
"UPDATE " . $db[
'users'] .
"
102 $stmt->bind_param(
"si", $secure_pass, $this->userId);
103 $result = $stmt->execute();
105 if(!$result===FALSE) {
106 $this->passwordHash = $secure_pass;
117 $this->email = $newEmail;
118 $stmt = $mysqli->prepare(
"UPDATE " . $db[
'users'] .
"
123 $stmt->bind_param(
"si", $newEmail, $this->userId);
136 $stmt = $mysqli->prepare(
"SELECT id
137 FROM " . $db[
'user_permission'] .
"
139 AND permission_id = ?
143 foreach ($permissionId as $check) {
145 $stmt->bind_param(
"ii", $this->userId, $check);
147 $stmt->store_result();
148 if ($stmt->num_rows > 0) {
167 return $details[
'firstname'] .
" " . $details[
'lastname'];
180 if($resultType == 1) {
182 }
else if ($resultType == 2) {
188 if(!empty($result) && is_array($result)) {
190 if(count($storeArray)>=5) {
192 kdsort($storeArray, 1, SORT_ASC);
194 unset($storeArray[0]);
198 foreach ($storeArray as $resultSet) {
199 if(count($resultSet[
'result'])==count($result)) {
200 $diff = array_diff($resultSet[
'result'], $result);
202 $matchingKey = $resultSet[
'id'];
207 if($matchingKey==NULL) {
209 $resultIdentifier = substr(sha1(uniqid($this->userId,
true)),0,25);
210 $storeArray[] = array(
'result'=>$result,
'time'=> time(),
'id'=>$resultIdentifier);
211 return $resultIdentifier;
259 foreach ($this->tempReults as $cResult) {
260 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
261 return $cResult[
'result'];
264 foreach ($this->searchResults as $cResult) {
265 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
266 return $cResult[
'result'];
269 foreach ($this->filterResults as $cResult) {
270 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
271 return $cResult[
'result'];
287 foreach ($this->tempReults as $cResult) {
288 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
292 foreach ($this->searchResults as $cResult) {
293 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
297 foreach ($this->filterResults as $cResult) {
298 if(strcmp($cResult[
'id'],$resultIdentifier)==0) {
311 $qry =
"UPDATE " . $db[
'users'] .
"
314 $stmt = $mysqli->prepare($qry);
315 $stmt->bind_param(
"si", $this->sessionId, $this->userId);