Fixed issue: datestamp on not date stamped survey.

Dev : TODO verify for 1.92
LimeSurvey · May 14, 2012 · ad199b9 · ad199b9
1 parent 281108a
commit ad199b9
Showing 1 changed file with 12 additions and 3 deletions.
diff --git a/application/helpers/expressions/em_manager_helper.php b/application/helpers/expressions/em_manager_helper.php
@@ -4037,12 +4037,21 @@ private function _UpdateValuesInDatabase($updatedValues, $finished=false)
                     else
                     {
                         if ($finished) {
-                            $sQuery = 'UPDATE '.$this->surveyOptions['tablename'] . " SET "
-                            .dbQuoteID('submitdate') . "=" . dbQuoteAll($_SESSION['datestamp'])
-                            ." WHERE ID=".$_SESSION[$this->sessid]['srid'];
+                            $sQuery = 'UPDATE '.$this->surveyOptions['tablename'] . " SET ";
+                            if($this->surveyOptions['datestamp'])
+                            {
+                                // Replace with date("Y-m-d H:i:s") ? See timeadjust
+                                $sQuery .= dbQuoteID('submitdate') . "=" . dbQuoteAll($_SESSION[$this->sessid]['datestamp']);
+                            }
+                            else
+                            {
+                                $sQuery .= dbQuoteID('submitdate') . "=" . dbQuoteAll(date("Y-m-d H:i:s",mktime(0,0,0,1,1,1980)));
+                            }
+                            $sQuery .= " WHERE ID=".$_SESSION[$this->sessid]['srid'];
                             dbExecuteAssoc($sQuery);   // Checked
                         }
                     }
+                    }
 
                 }
                 if (($this->debugLevel & LEM_DEBUG_VALIDATION_SUMMARY) == LEM_DEBUG_VALIDATION_SUMMARY) {