/** To set Global Settings in Database */
function setGlobalSettings($globals)
{
foreach ($globals as $var => $val) {
setGlobalSettingByAttribute($var, $val);
}
}
function importDatabase()
{
global $installFolder, $URL_REWRITE;
mysql_connect(MYSQL_SERVER, MYSQL_USERNAME, MYSQL_PASSWORD);
mysql_select_db(MYSQL_DATABASE);
$handle = @fopen($installFolder . "/pragyan_structure.sql", "r");
$query = '';
if ($handle) {
while (!feof($handle)) {
$buffer = fgets($handle, 4096);
if (strpos($buffer, "--") !== 0) {
$query .= $buffer;
}
}
fclose($handle);
}
$query = str_replace("pragyanV3_", MYSQL_DATABASE_PREFIX, $query);
$singlequeries = explode(";\n", $query);
foreach ($singlequeries as $singlequery) {
if (trim($singlequery) != "") {
$result1 = mysql_query($singlequery);
if (!$result1) {
$output = "<h3>Error:</h3><pre>" . $singlequery . "</pre>\n<br/>Unable to create structure. " . mysql_error();
return $output;
}
}
}
$error = (include 'searchStructure.php');
if ($error != '') {
return $error;
}
$handle = @fopen($installFolder . "/pragyan_inserts.sql", "r");
if ($handle) {
while (!feof($handle)) {
$buffer = fgets($handle, 4096);
if (strpos($buffer, "--") !== 0) {
$query .= $buffer;
}
}
fclose($handle);
}
$query = str_replace("pragyanV3_", MYSQL_DATABASE_PREFIX, $query);
$singlequeries = explode(";\n", $query);
foreach ($singlequeries as $singlequery) {
if (trim($singlequery) != "") {
$result1 = mysql_query($singlequery);
if (!$result1) {
$output = "<h3>Error:</h3><pre>" . $singlequery . "</pre>\n<br/>Unable to import the rows. " . mysql_error();
return $output;
}
}
}
$DEFAULT_USER_ACTIVATE = DEFAULT_USER_ACTIVATE == "true" ? 1 : 0;
$SEND_MAIL_ON_REGISTRATION = SEND_MAIL_ON_REGISTRATION == "true" ? 1 : 0;
setGlobalSettingByAttribute("cms_title", CMS_TITLE);
setGlobalSettingByAttribute("cms_email", CMS_EMAIL);
setGlobalSettingByAttribute("default_template", CMS_TEMPLATE);
setGlobalSettingByAttribute("url_rewrite", $URL_REWRITE);
setGlobalSettingByAttribute("default_user_activate", $DEFAULT_USER_ACTIVATE);
setGlobalSettingByAttribute("default_mail_verify", $SEND_MAIL_ON_REGISTRATION);
setGlobalSettingByAttribute("upload_limit", UPLOAD_LIMIT);
setGlobalSettingByAttribute("cms_desc", CMS_TITLE);
setGlobalSettingByAttribute("cms_keywords", CMS_TITLE);
setGlobalSettingByAttribute("reindex_frequency", "2");
setGlobalSettingByAttribute("allow_login", "1");
setGlobalSettingByAttribute("cms_footer", "© 2010 - powered by <a href=\"http://sourceforge.net/projects/pragyan\" title=\"Praygan CMS\">Pragyan CMS v3.0</a>");
setGlobalSettingByAttribute("openid_enabled", OPENID_ENABLED);
$query = "INSERT IGNORE INTO `" . MYSQL_DATABASE_PREFIX . "users` (`user_id`,`user_name`,`user_email`,`user_fullname`,`user_password`,`user_regdate`,`user_lastlogin`,`user_activated`,`user_loginmethod`) VALUES (\n\t1,'" . ADMIN_USERNAME . "','" . ADMIN_EMAIL . "','" . ADMIN_FULLNAME . "','" . md5(ADMIN_PASSWORD) . "',NOW(),'',1,'db')";
mysql_query($query);
global $cmsFolder;
$templates = scandir($cmsFolder . '/templates');
foreach ($templates as $tdir) {
if (is_dir($cmsFolder . '/templates/' . $tdir) && $tdir[0] != '.' && $tdir != "common") {
$query = "INSERT IGNORE INTO `" . MYSQL_DATABASE_PREFIX . "templates` (`template_name`) VALUES ('{$tdir}')";
mysql_query($query);
}
}
return '';
}
