{
return $this->prefix;
}
function setPrefix($prefix)
{
$this->prefix = $prefix;
}
function loadState($stid, $mainseid, $seid, $prefix)
{
global $db, $survey;
$key = $survey->getDataEncryptionKey();
$data = "data as data_dec";
$assignments = "assignments as assignments_dec";
$fills = "fills as fills_dec";
if ($key != "") {
$data = "aes_decrypt(data, '" . $key . "') as data_dec";
$assignments = "aes_decrypt(assignments, '" . $key . "') as assignments_dec";
$fills = "aes_decrypt(fills, '" . $key . "') as fills_dec";
}
if (Config::retrieveDataFromState() == false) {
$q = "select suid, stateid, mainseid, seid, parentseid, parentrgid, parentprefix, prefix, primkey, rgid, displayed, template, loopstring, looplastaction, looprgid, whilergid, whilelastaction, subdisplays, inlinefields, language, mode, version, {$assignments}, {$fills} from " . Config::dbSurveyData() . "_states where suid=" . prepareDatabaseString($this->suid) . " and mainseid=" . prepareDatabaseString($mainseid) . " and seid=" . prepareDatabaseString($seid) . " and prefix='" . prepareDatabaseString($prefix) . "' and primkey='" . prepareDatabaseString($this->primkey) . "' and stateid=" . prepareDatabaseString($stid);
} else {
$q = "select suid, stateid, mainseid, seid, parentseid, parentrgid, parentprefix, prefix, primkey, rgid, displayed, template, loopstring, looplastaction, looprgid, whilergid, whilelastaction, subdisplays, inlinefields, language, mode, version, {$data}, {$assignments}, {$fills} from " . Config::dbSurveyData() . "_states where suid=" . prepareDatabaseString($this->suid) . " and mainseid=" . prepareDatabaseString($mainseid) . " and seid=" . prepareDatabaseString($seid) . " and prefix='" . prepareDatabaseString($prefix) . "' and primkey='" . prepareDatabaseString($this->primkey) . "' and stateid=" . prepareDatabaseString($stid);
}
$r = $db->selectQuery($q);
if ($row = $db->getRow($r)) {
$this->setSuid($row["suid"]);
$this->stateid = $row["stateid"];
$this->mainseid = $row["mainseid"];
$this->seid = $row["seid"];
$this->parentseid = $row["parentseid"];
$this->parentrgid = $row["parentrgid"];
$this->parentprefix = $row["parentprefix"];
$this->prefix = $row["prefix"];
$this->primkey = $row["primkey"];
$this->rgid = $row["rgid"];
$this->displayed = $row["displayed"];
$this->template = $row["template"];
$this->loopstring = $row["loopstring"];
$this->leftoff = $row["looplastaction"];
$this->looprgid = $row["looprgid"];
$this->whileleftoff = $row["whilelastaction"];
$this->whilergid = $row["whilergid"];
if (Config::retrieveDataFromState()) {
$this->loadData($row["data_dec"]);
}
$this->loadAssignments($row["assignments_dec"]);
$this->loadFillTexts($row["fills_dec"]);
$this->loadSubDisplays($row["subdisplays"]);
$this->loadInlineFields($row["inlinefields"]);
$this->language = $row["language"];
