Changeset 1042

Timestamp:

04/23/2008 10:09:11 PM (2 years ago)

Author:

BrianKoontz

Message:

Fixed wikka_sessions timestamp issue, logic error that prevented
session ids from being stored in table. Refs #608.

Files:

• trunk/wikka.php (modified) (1 diff)

trunk/wikka.php

@@ -977 +977 @@
 { 
         $res = $wakka->LoadSingle("SELECT * FROM ".$wakka->config['table_prefix']."sessions WHERE sessionid='".session_id()."' AND userid='".$user['name']."'");  
-        if(isset($res)) 
+        if(!empty($res)) 
         { 
                 // Just update the session_start time 
-                $wakka->Query("UPDATE ".$wakka->config['table_prefix']."sessions SET session_start=FROM_UNIXTIME(".$wakka->GetMicroTime().") WHERE sessionid='".session_id()."' AND userid='".$user['name']."'"); 
+                $wakka->Query("UPDATE ".$wakka->config['table_prefix']."sessions SET session_start=NOW() WHERE sessionid='".session_id()."' AND userid='".$user['name']."'"); 
         } 
         else 
         { 
                 // Create new session record 
-                $wakka->Query("INSERT INTO ".$wakka->config['table_prefix']."sessions (sessionid, userid, session_start) VALUES('".session_id()."', '".$user['name']."', FROM_UNIXTIME(".$wakka->GetMicroTime()."))"); 
+                $wakka->Query("INSERT INTO ".$wakka->config['table_prefix']."sessions (sessionid, userid, session_start) VALUES('".session_id()."', '".$user['name']."', NOW())"); 
         } 
 }