require_once "../config/i18n.php";
require_once "../config/session_info.php";
require_once "../lib/FlashMsg.php";
$title = _("Database Creation");
require_once "../layout/header.php";
require_once dirname(__FILE__) . "/parse_sql_file.php";
require_once "../model/Query/Setting.php";
require_once "../lib/Form.php";
if (isset($_GET["confirm"]) && $_GET["confirm"] == "yes") {
Form::compareToken('./index.php');
}
echo HTML::section(1, $title);
/**
* Testing connection and current version
*/
$setQ = new Query_Setting();
echo Msg::info(_("Database connection is good."));
/**
* Show warning message if database exists
*/
$setQ->captureError(true);
$setQ->select();
if ($setQ->isError()) {
echo HTML::para(_("Building OpenClinic tables..."));
} else {
$set = $setQ->fetch();
if (!$set) {
$setQ->close();
Error::fetch($setQ);
}
if (!isset($_GET["confirm"]) || $_GET["confirm"] != "yes") {
*/
$tab = "admin";
$nav = "themes";
/**
* Checking for get and post vars. Go back to form if none found.
*/
if (count($_POST) == 0 && count($_GET) == 0) {
header("Location: ../admin/theme_edit_form.php");
exit;
}
require_once "../model/Query/Setting.php";
require_once "../lib/Form.php";
/**
* Reading general settings
*/
$setQ = new Query_Setting();
$setQ->select();
$set = $setQ->fetch();
if (!$set) {
$setQ->close();
Error::fetch($setQ);
}
$setQ->freeResult();
$setQ->close();
unset($setQ);
define("OPEN_LANGUAGE", $set->getLanguage());
unset($set);
/**
* i18n l10n (after OPEN_LANGUAGE is defined)
*/
require_once "../config/i18n.php";
/**
* Controlling vars
*/
$tab = "admin";
$nav = "settings";
/**
* Checking permissions
*/
require_once "../auth/login_check.php";
loginCheck(OPEN_PROFILE_ADMINISTRATOR);
/**
* Checking for $formError to read data from database
*/
if (!isset($formError)) {
include_once "../model/Query/Setting.php";
$setQ = new Query_Setting();
$setQ->select();
$set = $setQ->fetch();
if ($set) {
$formVar["clinic_name"] = $set->getClinicName();
$formVar["clinic_hours"] = $set->getClinicHours();
$formVar["clinic_address"] = $set->getClinicAddress();
$formVar["clinic_phone"] = $set->getClinicPhone();
$formVar["clinic_url"] = $set->getClinicUrl();
$formVar["language"] = $set->getLanguage();
$formVar["id_theme"] = $set->getIdTheme();
$formVar["session_timeout"] = $set->getSessionTimeout();
$formVar["items_per_page"] = $set->getItemsPerPage();
} else {
Error::fetch($setQ, false);
}
$set->setSessionTimeout($_POST["session_timeout"]);
$_POST["session_timeout"] = $set->getSessionTimeout();
$set->setItemsPerPage($_POST["items_per_page"]);
$_POST["items_per_page"] = $set->getItemsPerPage();
if (!$set->validateData()) {
$formError["session_timeout"] = $set->getSessionTimeoutError();
$formError["items_per_page"] = $set->getItemsPerPageError();
Form::setSession($_POST, $formError);
header("Location: ../admin/setting_edit_form.php");
exit;
}
/**
* Destroy form values and errors
*/
Form::unsetSession();
/**
* Update app settings
*/
$setQ = new Query_Setting();
$setQ->update($set);
if (isset($_POST["id_theme"])) {
$setQ->updateTheme($_POST["id_theme"]);
}
$setQ->close();
unset($setQ);
unset($set);
/**
* Redirect to destiny to avoid reload problem
*/
FlashMsg::add(_("Data has been updated."));
header("Location: ../admin/setting_edit_form.php");
* @version CVS: $Id: upgrade.php,v 1.13 2013/01/16 20:58:07 jact Exp $
* @author jact <*****@*****.**>
*/
$tab = "install";
$nav = "upgrade";
$returnLocation = './index.php';
// Instead of include environment.php (because maybe database connection doesn't exists)
define("OPEN_THEME_NAME", "OpenClinic");
define("OPEN_THEME_CSS_FILE", "openclinic.css");
require_once "../config/i18n.php";
require_once "../config/session_info.php";
require_once "../lib/FlashMsg.php";
require_once "../model/Query/Setting.php";
require_once "../lib/File.php";
// File::getDirContent()
$setQ = new Query_Setting();
$setQ->captureError(true);
$setQ->select();
if ($setQ->isError()) {
FlashMsg::add(sprintf(_("The connection to the database failed with the following error: %s"), $setQ->getDbError()), OPEN_MSG_ERROR);
$setQ->close();
// after getDbError
header("Location: " . $returnLocation);
exit;
}
$set = $setQ->fetch();
if (!$set) {
$setQ->close();
Error::fetch($setQ);
}
$version = $set->getVersion();
/**
* Checking for post vars. Go back to $returnLocation if none found.
*/
if (count($_POST) == 0) {
header("Location: " . $returnLocation);
exit;
}
/**
* Checking permissions
*/
require_once "../auth/login_check.php";
loginCheck(OPEN_PROFILE_ADMINISTRATOR);
require_once "../lib/Form.php";
/**
* Destroy form values and errors
*/
Form::unsetSession();
/**
* Update theme in use
*/
$idTheme = intval($_POST["id_theme"]);
require_once "../model/Query/Setting.php";
$setQ = new Query_Setting();
$setQ->updateTheme($idTheme);
$setQ->close();
unset($setQ);
/**
* Redirect to $returnLocation to avoid reload problem
*/
FlashMsg::add(_("Default theme has been changed."));
header("Location: " . $returnLocation);
