X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fsession.php;h=a1412ad9b445079b7ecfc00d8310f80e44f18342;hb=1f9b52f2bf62a00add5b62b21e2dd009246345ef;hp=af871b28a1d8467b9ebb4f87ad1131f4cf424804;hpb=ad3566aeaa8825d0f0968203e48cdb66a2918049;p=friendica.git

diff --git a/include/session.php b/include/session.php
index af871b28a1..a1412ad9b4 100644
--- a/include/session.php
+++ b/include/session.php
@@ -24,17 +24,17 @@ function ref_session_read($id) {
 	if (is_object($memcache)) {
 		$data = $memcache->get(get_app()->get_hostname().":session:".$id);
 		if (!is_bool($data)) {
+			$session_exists = true;
 			return $data;
 		}
 		logger("no data for session $id", LOGGER_TRACE);
 		return '';
 	}
 
-	$r = q("SELECT `data` FROM `session` WHERE `sid`= '%s'", dbesc($id));
-
+	$r = dba::select('session', array('data'), array('sid' => $id), array('limit' => 1));
 	if (dbm::is_result($r)) {
 		$session_exists = true;
-		return $r[0]['data'];
+		return $r['data'];
 	} else {
 		logger("no data for session $id", LOGGER_TRACE);
 	}
@@ -73,15 +73,12 @@ function ref_session_write($id, $data) {
 	}
 
 	if ($session_exists) {
-		$r = q("UPDATE `session`
-				SET `data` = '%s', `expire` = '%s'
-				WHERE `sid` = '%s'
-				AND (`data` != '%s' OR `expire` != '%s')",
-				dbesc($data), dbesc($expire), dbesc($id), dbesc($data), dbesc($expire));
+		$fields = array('data' => $data, 'expire' => $expire);
+		$condition = array("`sid` = ? AND (`data` != ? OR `expire` != ?)", $id, $data, $expire);
+		dba::update('session', $fields, $condition);
 	} else {
-		$r = q("INSERT INTO `session`
-				SET `sid` = '%s', `expire` = '%s', `data` = '%s'",
-				dbesc($id), dbesc($default_expire), dbesc($data));
+		$fields = array('sid' => $id, 'expire' => $default_expire, 'data' => $data);
+		dba::insert('session', $fields);
 	}
 
 	return true;
@@ -99,14 +96,12 @@ function ref_session_destroy($id) {
 		return true;
 	}
 
-	q("DELETE FROM `session` WHERE `sid` = '%s'", dbesc($id));
-
+	dba::delete('session', array('sid' => $id));
 	return true;
 }
 
 function ref_session_gc($expire) {
-	q("DELETE FROM `session` WHERE `expire` < %d", dbesc(time()));
-
+	dba::delete('session', array("`expire` < ?", time()));
 	return true;
 }