function addTimings($lastrgid, $laststateid) { if (Config::logSurveyTimings() == false) { return; } $localdb = null; if (Config::useTransactions() == true) { global $transdb; $localdb = $transdb; } else { global $db; $localdb = $db; } $vars = splitString("/~/", getFromSessionParams(SESSION_PARAM_VARIABLES)); $begin = date("Y-m-d H:i:s", getFromSessionParams(SESSION_PARAM_TIMESTAMP)); $end = time(); $lang = getSurveyLanguage(); $mode = getSurveyMode(); $version = getSurveyVersion(); $time = time(); foreach ($vars as $var) { $var = $this->prefixVariableName($var); $query = "insert into " . Config::dbSurveyData() . '_times (suid, primkey, stateid, rgid, variable, begintime, endtime, timespent, language, mode, version) values ('; $query .= prepareDatabaseString($this->getSuid()) . ","; $query .= "'" . prepareDatabaseString($this->primkey) . "',"; $query .= "'" . prepareDatabaseString($laststateid) . "',"; $query .= "'" . prepareDatabaseString($lastrgid) . "',"; $query .= "'" . prepareDatabaseString($var) . "',"; $query .= "'" . prepareDatabaseString($begin) . "',"; $query .= "'" . date("Y-m-d H:i:s", $end) . "',"; $query .= $time - getFromSessionParams(SESSION_PARAM_TIMESTAMP) . ","; $query .= prepareDatabaseString($lang) . ","; $query .= prepareDatabaseString($mode) . ","; $query .= prepareDatabaseString($version) . ")"; //echo$query . "<br/>"; $localdb->executeQuery($query); } }