Index: trunk/kernel/include/usersession.php
===================================================================
diff -u -r2299 -r2308
--- trunk/kernel/include/usersession.php (.../usersession.php) (revision 2299)
+++ trunk/kernel/include/usersession.php (.../usersession.php) (revision 2308)
@@ -568,17 +568,11 @@
//if(!(int)$FrontEnd==1)
//{
+ $db =& $this->adodbConnection;
$sessionkey = $this->GetSessionKey();
- $sql = "SELECT * FROM ".GetTablePrefix()."SessionData WHERE VariableName='$variableName' AND SessionKey='$sessionkey'";
- $rs = $this->adodbConnection->Execute($sql);
- if($rs && !$rs->EOF)
- {
- $sql = "UPDATE ".GetTablePrefix()."SessionData SET VariableValue='$variableValue' WHERE VariableName='$variableName' AND SessionKey='$sessionkey'";
- }
- else
- $sql = "INSERT INTO ".GetTablePrefix()."SessionData (VariableName,VariableValue,SessionKey) VALUES ('$variableName','$variableValue','$sessionkey')";
-
- $this->adodbConnection->Execute($sql);
+ $sql = 'REPLACE INTO '.GetTablePrefix().'SessionData (SessionKey,VariableName,VariableValue) VALUES (%s,%s,%s)';
+ $db->Execute( sprintf($sql, $db->qstr($sessionkey), $db->qstr($variableName), $db->qstr($variableValue) ) );
+
// echo "
UPDATE: $sql
";
//}
}