public static function getObject($record)
{
global $DEFAULT_LANG;
# Converts a user record in DB into a User object
if ($record == null) {
return null;
}
$user = new User();
$user->userId = $record['user_id'];
$user->username = $record['username'];
$user->password = $record['password'];
$user->actualName = $record['actualname'];
$user->level = $record['level'];
$user->email = $record['email'];
$user->phone = $record['phone'];
$user->createdBy = $record['created_by'];
$user->labConfigId = $record['lab_config_id'];
if (isset($record['lang_id'])) {
$user->langId = $record['lang_id'];
} else {
$user->langId = $DEFAULT_LANG;
}
/*if( $user->labConfigId == 128 || $user->labConfigId == 129 || $user->labConfig == 131 ) */
$user->country = LabConfig::getUserCountry($user->labConfigId);
return $user;
}
function updateDatabase()
{
global $labConfigId, $DB_HOST, $DB_USER, $DB_PASS;
$country = strtolower(LabConfig::getUserCountry($labConfigId));
$saved_db = DbUtil::switchToCountry($country);
$currentDir = getcwd();
$mainBlisDir = substr($currentDir, $length, strpos($currentDir, "htdocs"));
//$blisLabBackupFilePath = "\"".$mainBlisDir.$backup_folder."\blis_".$lab_config_id."\blis_".$lab_config_id."_backup.sql\"";
$sqlFilePath = "\"" . $mainBlisDir . "htdocs\\export\\temp.sql\"";
$mysqlExePath = "\"" . $mainBlisDir . "server\\mysql\\bin\\mysql.exe\"";
$dbname = "blis_" . $country;
$command = $mysqlExePath . " -h {$DB_HOST} -P 7188 -u {$DB_USER} -p{$DB_PASS} {$dbname} < {$sqlFilePath}";
$command = "C: &" . $command;
//the C: is a useless command to prevent the original command from failing because of having more than 2 double quotes
echo $command;
system($command, $return_var);
if ($return_var == 0) {
echo "true";
} else {
echo "false";
}
DbUtil::switchRestore($saved_db);
}
