function showSetupRes()
{
/* write conf.php file */
if (is_writable('conf.php') == false) {
$message = '<div class="alert alert-danger">' . Language::installWarning() . '</div>';
return $this->getContent("setup", $message);
} else {
// TODO: FINISH ADDING POST SETTINGS TO THE CONFIG, ADD SAMPLE SETTINGS AND ANYTHING ELSE MISSING FROM THE SETUP WIZARD
/* test db */
$db = new Database();
if ($db->connect(loadvar("databaseserver"), loadvar("databasename"), loadvar("databaseuser"), loadvar("databasepassword")) == false) {
//no connection with DB.. Errormessage!
$message = '<div class="alert alert-danger">' . Language::installWarningDatabase() . '</div>';
return $this->getContent("setup", $message);
} else {
$file = fopen("conf.php", "w");
$str = '<?php
$configuration = array(
CONFIGURATION_DATABASE => array(
CONFIGURATION_DATABASE_SERVER => "' . loadvar("databaseserver") . '",
CONFIGURATION_DATABASE_NAME => "' . loadvar("databasename") . '",
CONFIGURATION_DATABASE_TYPE => "1",
CONFIGURATION_DATABASE_USER => "' . loadvar("databaseuser") . '",
CONFIGURATION_DATABASE_PASSWORD => "' . loadvar("databasepassword") . '",
CONFIGURATION_DATABASE_SURVEY => "' . loadvar("databasetablename") . '"
),
CONFIGURATION_GENERAL => array(
CONFIGURATION_GENERAL_STARTUP => "1",
CONFIGURATION_GENERAL_DEVICE => "1"
),
CONFIGURATION_SAMPLE => array(
CONFIGURATION_SAMPLE_PANEL => "' . loadvar("sampletype") . '",
CONFIGURATION_SAMPLE_TRACKING => "' . loadvar("sampletracking") . '",
CONFIGURATION_SAMPLE_INTERVIEWADDRESS => "' . loadvar("sampleinterviewaddress") . '",
CONFIGURATION_SAMPLE_PROXYCODE => "' . loadvar("sampleproxycode") . '",
CONFIGURATION_SAMPLE_PROXYCONTACT => "' . loadvar("sampleproxycontact") . '",
CONFIGURATION_SAMPLE_COMMUNICATION => "' . loadvar("samplecommunication") . '",
CONFIGURATION_SAMPLE_FILELOCATION => "' . loadvar("samplefilelocation") . '"
),
CONFIGURATION_ENCRYPTION => array(
CONFIGURATION_ENCRYPTION_DATA => "' . loadvar("encryptiondata") . '",
CONFIGURATION_ENCRYPTION_LOGINCODES => "' . loadvar("encryptionlogincodes") . '",
CONFIGURATION_ENCRYPTION_ADMIN => "' . loadvar("encryptionadmin") . '",
CONFIGURATION_ENCRYPTION_PERSONAL => "' . loadvar("encryptionrespondent") . '",
CONFIGURATION_ENCRYPTION_REMARK => "' . loadvar("encryptionremarks") . '",
CONFIGURATION_ENCRYPTION_CONTACTREMARK => "' . loadvar("encryptioncontactremarks") . '",
CONFIGURATION_ENCRYPTION_CONTACTNAME => "' . loadvar("encryptioncontactnames") . '",
CONFIGURATION_ENCRYPTION_ACTION_PARAMS => "' . loadvar("encryptionparameters") . '",
CONFIGURATION_ENCRYPTION_DIRECT => "' . loadvar("encryptiondirect") . '",
CONFIGURATION_ENCRYPTION_LAB => "' . loadvar("encryptionlab") . '",
CONFIGURATION_ENCRYPTION_FILE => "' . loadvar("encryptionfile") . '"
),
CONFIGURATION_DATETIME => array(
CONFIGURATION_DATETIME_TIMEZONE => "' . loadvar("timezone") . '",
CONFIGURATION_DATETIME_USFORMAT_SMS => "' . loadvar('timeformatsms') . '",
CONFIGURATION_DATETIME_USFORMAT_SURVEY => "' . loadvar('timeformatsurvey') . '",
CONFIGURATION_DATETIME_MINUTES_SMS => "' . loadvar('timeminutessms') . '",
CONFIGURATION_DATETIME_MINUTES_SURVEY => "' . loadvar('timeminutessurvey') . '",
CONFIGURATION_DATETIME_SECONDS_SMS => "' . loadvar('timesecondssms') . '",
CONFIGURATION_DATETIME_SECONDS_SURVEY => "' . loadvar('timesecondssurvey') . '"
),
CONFIGURATION_LOGGING => array(
CONFIGURATION_LOGGING_TIMINGS => "' . loadvar('loggingtimings') . '",
CONFIGURATION_LOGGING_PARAMS => "' . loadvar('loggingactions') . '",
CONFIGURATION_LOGGING_ACTIONS => "' . loadvar('loggingactions') . '",
CONFIGURATION_LOGGING_PARADATA => "' . loadvar('loggingparadata') . '",
CONFIGURATION_LOGGING_TABSWITCH => "' . loadvar('loggingtabswitch') . '",
CONFIGURATION_LOGGING_MOUSE => "' . loadvar('loggingmouse') . '"
),
CONFIGURATION_SESSION => array(
CONFIGURATION_SESSION_WARN => "' . loadvar('sessionwarn') . '",
CONFIGURATION_SESSION_TIMEOUT => "' . loadvar('sessionduration') . '",
CONFIGURATION_SESSION_LOGOUT => "' . loadvar('sessionlogout') . '",
CONFIGURATION_SESSION_REDIRECT => "' . loadvar('sessionredirect') . '",
CONFIGURATION_SESSION_PING => "' . loadvar('sessionping') . '"
),
CONFIGURATION_PERFORMANCE => array(
CONFIGURATION_PERFORMANCE_DATA_FROM_STATE => "' . loadvar('performancestate') . '",
CONFIGURATION_PERFORMANCE_PREPARE_QUERIES => "' . loadvar('performancequeries') . '",
CONFIGURATION_PERFORMANCE_UNSERIALIZE => "' . loadvar('performanceserialize') . '",
CONFIGURATION_PERFORMANCE_USE_DATARECORDS => "' . loadvar('performancerecords') . '",
CONFIGURATION_PERFORMANCE_USE_DYNAMIC_MINIFY => "' . loadvar('performanceminify') . '",
CONFIGURATION_PERFORMANCE_USE_LOCKING => "' . loadvar('performancelocking') . '",
CONFIGURATION_PERFORMANCE_USE_TRANSACTIONS => "' . loadvar('performancetransaction') . '"
)
);
?>';
fwrite($file, $str);
fclose($file);
// create tables
$fr = file_get_contents(dirname(__FILE__) . "/admin/sql/createtables.sql");
$str = str_replace("survey1", loadvar("databasetablename"), $fr);
$db->executeQueries($str);
$query = "REPLACE INTO `" . loadvar("databasetablename") . "_users` (`urid`, `status`, `name`, `username`, `password`, `usertype`, usersubtype, `sup`, `filter`, `regionfilter`, `testmode`, `communication`, `settings`, `access`, `lastdata`, `ts`) VALUES\n (1, 1, 'Sysadmin', 'sysadmin', aes_encrypt('sysadmin','" . loadvar("encryptionadmin") . "'), 4, 1, NULL, 1, 0, 0, 2, 0x613a313a7b733a31303a226e6176696e6272656164223b733a313a2231223b7d, NULL, NULL, '2014-04-12 00:20:49');";
$db->executeQuery($query);
//echo $query;
return $this->getContent("finish");
}
}
}
