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);
}
}
