function getAggregrateDataOld($variable)
{
global $survey, $db;
$arr = array();
$decrypt = "data as data_dec";
if ($survey->getDataEncryptionKey() != "") {
$decrypt = "aes_decrypt(data, '" . $survey->getDataEncryptionKey() . "') as data_dec";
}
if (Config::useDataRecords()) {
$query = "select {$decrypt} from " . Config::dbSurveyData() . "_datarecords where suid=" . $survey->getSuid() . $extracompleted . " order by primkey";
} else {
$query = "select {$decrypt} from " . Config::dbSurveyData() . "_data where suid=" . $survey->getSuid() . " and variablename='" . VARIABLE_PRIMKEY . "' " . $extracompleted . " order by primkey";
}
$res = $db->selectQuery($query);
$datanames = array();
if ($res) {
if ($db->getNumberOfRows($res) == 0) {
return 'No records found';
} else {
/* go through records */
while ($row = $db->getRow($res)) {
$record = new DataRecord();
$record->setAllData(unserialize(gzuncompress($row["data_dec"])));
$data = $record->getDataForVariable($variable->getName());
foreach ($data as $rec) {
$arr[$rec->getAnswer()]++;
}
}
}
}
return $arr;
}
