Fix for SQL error
authorRoland Häder <roland@mxchange.org>
Wed, 7 Oct 2009 21:40:06 +0000 (21:40 +0000)
committerRoland Häder <roland@mxchange.org>
Wed, 7 Oct 2009 21:40:06 +0000 (21:40 +0000)
inc/libs/online_functions.php

index 47ac57f..0348497 100644 (file)
@@ -74,7 +74,7 @@ function FILTER_UPDATE_ONLINE_LIST () {
        } // END - if
 
        // Now search for the user
        } // END - if
 
        // Now search for the user
-       $result = SQL_QUERY_ESC("SELECT `timestamp` FROM `{!_MYSQL_PREFIX!}_online` WHERE sid='%s' LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT `timestamp` FROM `{!_MYSQL_PREFIX!}_online` WHERE `sid`='%s' LIMIT 1",
        array(session_id()), __FUNCTION__, __LINE__);
 
        // Entry found?
        array(session_id()), __FUNCTION__, __LINE__);
 
        // Entry found?
@@ -93,7 +93,7 @@ SET
        `timestamp`=UNIX_TIMESTAMP(),
        `ip`='%s'
 WHERE 
        `timestamp`=UNIX_TIMESTAMP(),
        `ip`='%s'
 WHERE 
-       sid`='%s'
+       `sid`='%s'
 LIMIT 1",
                array(
                        getModule(),
 LIMIT 1",
                array(
                        getModule(),
@@ -130,5 +130,5 @@ LIMIT 1",
                array(getConfig('online_timeout')), __FUNCTION__, __LINE__);
 }
 
                array(getConfig('online_timeout')), __FUNCTION__, __LINE__);
 }
 
-//
+// [EOF]
 ?>
 ?>