function addLogs($variable, $answer, $di) { if (Config::logSurveyActions() == false) { return; } $localdb = null; if (Config::useTransactions() == true) { global $transdb; $localdb = $transdb; } else { global $db; $localdb = $db; } $ans = $answer; if ($ans == "") { $ans = null; } $prim = $this->getPrimaryKey(); $var = $variable; $dirty = $di; $action = $this->currentaction; $suid = $this->getSuid(); $version = getSurveyVersion(); $language = getSurveyLanguage(); $mode = getSurveyMode(); if (Config::prepareDataQueries() == false) { global $survey; $key = $survey->getDataEncryptionKey(); $answer = '"' . prepareDatabaseString($ans) . '"'; if ($key != "") { $answer = "aes_encrypt('" . prepareDatabaseString($ans) . "', '" . $key . "')"; } $localdb->executeQuery('INSERT INTO ' . Config::dbSurveyData() . '_logs (suid, primkey, variablename, answer, dirty, action, version, language, mode) VALUES (' . $suid . ',"' . $prim . '","' . $var . '",' . $answer . ',' . $dirty . ',' . $action . ',' . $version . ',' . $language . ',' . $mode . ')'); //echo 'INSERT INTO ' . Config::dbSurveyData() . '_logs (suid, primkey, variablename, answer, dirty, action, version, language, mode) VALUES (' . $suid . ',"' . $prim . '","' . $var . '",' . $answer . ',' . $dirty . ',' . $action . ',' . $version . ',' . $language . ',' . $mode . ')<br/>'; } else { $bp = new BindParam(); $bp->add(MYSQL_BINDING_STRING, $suid); $bp->add(MYSQL_BINDING_STRING, $prim); $bp->add(MYSQL_BINDING_STRING, $var); $bp->add(MYSQL_BINDING_STRING, $ans); $bp->add(MYSQL_BINDING_INTEGER, $dirty); $bp->add(MYSQL_BINDING_INTEGER, $action); $bp->add(MYSQL_BINDING_INTEGER, $version); $bp->add(MYSQL_BINDING_INTEGER, $language); $bp->add(MYSQL_BINDING_INTEGER, $mode); $answer = "?"; global $survey; $key = $survey->getDataEncryptionKey(); if ($key != "") { $answer = "aes_encrypt(?, '" . $key . "')"; } $localdb->executeBoundQuery('INSERT INTO ' . Config::dbSurveyData() . '_logs (suid, primkey, variablename, answer, dirty, action, version, language, mode) VALUES (?,?,?,' . $answer . ',?,?,?,?,?)', $bp->get()); } }