kyeghoyan
/
Epesi
forked from jtylek/EpesiCRM
1
0
Fork 0
Code Issues 0 Pull Requests 0 Releases 0 Wiki Activity
EPESI BIM • Business Information Manager • Cloud CRM/ERP http://epe.si/
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9561 Commits
3 Branches
72 MiB
 
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Epesi/setup.php

644 lines
24 KiB
Raw Permalink Blame History 

  1. <?php

  2. /**

  3.  * @author Paul Bukowski <pbukowski@telaxus.com>

  4.  * @version 1.0

  5.  * @copyright Copyright &copy; 2007, Telaxus LLC

  6.  * @license MIT

  7.  * @package epesi-base

  8.  */

  9. if (version_compare(phpversion(), '5.4.0')==-1)

  10. 	error_reporting(E_ALL); //all without notices

  11. else

  12. 	error_reporting(E_ALL & ~E_STRICT & ~E_DEPRECATED);

  13. ob_start();

  14. ini_set('arg_separator.output','&');

  15. @define('SYSTEM_TIMEZONE',date_default_timezone_get());

  16. date_default_timezone_set(SYSTEM_TIMEZONE);

  17. 

  18. define('_VALID_ACCESS',1);

  19. require_once('include/data_dir.php');

  20. require_once('modules/Libs/QuickForm/requires.php');

  21. 

  22. /* You can predefine user, password, database name, etc in file defined by var below.

  23. Example installation_config.php file:

  24. <?php

  25. $CONFIG = array('user' => 'db_username', 'password' => 'db_password', 'db' => 'database_name', 'host' => 'db_server_host',

  26.     'newdb' => 0,  // or 1 to create new database

  27.     'engine' => 'mysqli',  // or 'postgres' for PostgreSQL

  28.     'direction' => 0  // Left to Right, or 1 for Right to Left

  29. );

  30. ?>

  31. */

  32. $fast_install_filename = "installation_config.php";

  33. 

  34. // translation support

  35. $install_lang_dir = 'modules/Base/Lang/lang';

  36. $ls_langs = scandir($install_lang_dir);

  37. $langs = array();

  38. foreach ($ls_langs as $entry)

  39.     if (preg_match('/.\.php$/i', $entry)) {

  40.         $lang = substr($entry, 0, -4);

  41.         $langs[$lang] = $lang;

  42.     }

  43. $install_lang_code = & $_GET['install_lang'];

  44. require 'include/misc.php';

  45. require 'include/module_primitive.php';

  46. require 'include/module.php';

  47. require 'include/module_common.php';

  48. require 'modules/Base/Lang/LangCommon_0.php';

  49. $install_lang_load = isset($langs[$install_lang_code])

  50.     ? $langs[$install_lang_code] : 'en'; // fallback to english

  51. define('FORCE_LANG_CODE', $install_lang_load);

  52. include "{$install_lang_dir}/{$install_lang_load}.php";

  53. // end translations load

  54. 

  55. function set_header($str) {

  56. 	print('<script type="text/javascript">document.getElementById("setup_page_header").innerHTML="'.$str.'";</script>');

  57. }

  58. 

  59. ?>

  60. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

  61. <html>

  62. <head>

  63. 	  <meta content="text/html; charset=UTF-8" http-equiv="content-type">

  64. 	  <title><?php echo __("EPESI setup"); ?></title>

  65. 	  <link href="setup.css" type="text/css" rel="stylesheet"/>

  66. </head>

  67. <body>

  68. 		<table id="banner" border="0" cellpadding="0" cellspacing="0">

  69. 			<tr>

  70. 				<td class="image">&nbsp;</td>

  71. 				<td class="back" id="setup_page_header">&nbsp;</td>

  72. 				<td class="image back">&nbsp;</td>

  73. 			</tr>

  74. 		</table>

  75. 		<br>

  76. 		<center>

  77. 		<table id="main" border="0" cellpadding="0" cellspacing="0">

  78. 			<tr>

  79. 				<td>

  80. <?php

  81. 

  82. function footer() {

  83. ?>

  84. 				</td>

  85. 			</tr>

  86. 		</table>

  87. 		</center>

  88. 		<br>

  89. 		<center>

  90. 		<span class="footer">Copyright &copy; <?php echo date('Y'); ?> &bull; <a href="http://www.telaxus.com">Telaxus LLC</a></span>

  91. 		<br>

  92. 		<p><a href="http://www.epe.si"><img src="images/epesi-powered.png" border="0"></a></p>

  93. 		</center>

  94. </body>

  95. </html>

  96. <?php

  97. }

  98. register_shutdown_function('footer');

  99. 

  100. // language selection form

  101. if (!isset($install_lang_code)) {

  102. 	$complete = Base_LangCommon::get_complete_languages();

  103. 	$labels = Base_LangCommon::get_base_languages();

  104. 	$list = array();

  105. 	foreach ($complete as $l) {

  106. 		$list[$l] = isset($labels[$l])?$labels[$l]:$l;

  107. 	}

  108. 	$rest = array();

  109. 	foreach ($langs as $l) {

  110. 		$rest[$l] = isset($labels[$l])?$labels[$l]:$l;

  111. 	}

  112. 	asort($list);

  113. 	asort($rest);

  114. 	$list = array_merge(array('en'=>$labels['en']), $list);

  115. 	print('<div id="complete_translations">');

  116. 	foreach ($list as $l=>$label) {

  117. 		Base_LangCommon::print_flag($l, $label, 'href="?install_lang='.$l.'"');

  118. 		unset($rest[$l]);

  119. 	}

  120. 	print('</div>');

  121. 	print('<a class="show_incomplete button" onclick="this.style.display=\'none\';document.getElementById(\'incomplete_translations\').style.display=\'\';">Show incomplete translations</a>');

  122. 	print('<div id="incomplete_translations" style="display:none;">');

  123. 	foreach ($rest as $l=>$label) {

  124. 		Base_LangCommon::print_flag($l, $label, 'href="?install_lang='.$l.'"');

  125. 	}

  126. 	print('</div>');

  127. 	

  128. 	set_header('Select Language');

  129. 	die();

  130. }

  131. 

  132. /**

  133.  * Check access to working directories

  134.  */

  135. 

  136. if(file_exists('easyinstall.php')){

  137. 	unlink('easyinstall.php');

  138. }

  139. 

  140. if (isset($_GET['check'])) {

  141. 	require_once('check.php');

  142. 	print('<br><br><a class="button" href="index.php?install_lang='.$install_lang_load.'" style="display:block;width:200px; margin:0 auto;">' . __('Continue with installation') . '</a>');

  143. 	die();

  144. }

  145. 

  146. if(trim(ini_get("safe_mode")))

  147. 	die(__('You cannot use EPESI with PHP safe mode turned on - please disable it. Please notice this feature is deprecated since PHP 5.3 and is removed in PHP 5.4.'));

  148. 

  149. if(file_exists(DATA_DIR.'/config.php'))

  150. 	die(__('Cannot write into %s file. Please delete this file.', array(DATA_DIR.'/config.php')));

  151. 

  152. if(!is_writable(DATA_DIR))

  153. 	die(__('Cannot write into "%s" directory. Please fix privileges.', array(DATA_DIR)));

  154. 

  155. if (isset($_GET['tos1']) && $_GET['tos1'] && isset($_GET['tos2']) && $_GET['tos2'] && isset($_GET['tos3']) && $_GET['tos3'] && isset($_GET['tos4']) && $_GET['tos4']) {

  156.     $_GET['license'] = 1;

  157.     unset($_GET['tos1']);

  158.     unset($_GET['tos2']);

  159.     unset($_GET['tos3']);

  160.     unset($_GET['tos4']);

  161. }

  162. 

  163. if(!isset($_GET['license'])) {

  164. 	set_header(__('License Agreement'));

  165. 	print('<div class="license">');

  166.     print read_doc_file('license');

  167. 	print('</div>');

  168. 	print('<div class="license agreement">');

  169. 	$form = new HTML_QuickForm('licenceform','get');

  170. 	$form -> addElement('html', '<tr><td colspan=2><h3>'.__('By installing and using this software you agree to the MIT license and following terms:').'</h3></td></tr>');

  171. 	$form -> addElement('checkbox','tos1','',__('I will not remove the <strong>"Copyright by Telaxus LLC"</strong> notice as required by the MIT license.'));

  172. 	$form -> addElement('checkbox','tos2','',__('I will not remove <strong>"EPESI powered"</strong> logo and the link from the application login screen or the toolbar.'));

  173. 	$form -> addElement('checkbox','tos3','',__('I will not remove <strong>"Support -> About"</strong> credit page from the application menu.'));

  174. 	$form -> addElement('checkbox','tos4','',__('I will not remove or rename <strong>"EPESI Store"</strong> links from the application.'));

  175. 	foreach($_GET as $f=>$v) {

  176.         if (substr($f, 0, 3) != 'tos' && $f != 'submitted')

  177.             $form->addElement('hidden',$f,$v);

  178.     }

  179. 	$form->addElement('hidden','submitted',1);

  180. 	$form -> addRule('tos1', __('Field required'), 'required');

  181. 	$form -> addRule('tos2', __('Field required'), 'required');

  182. 	$form -> addRule('tos3', __('Field required'), 'required');

  183. 	$form -> addRule('tos4', __('Field required'), 'required');

  184. 	isset($_GET['submitted']) && $_GET['submitted'] && $form->validate();

  185. 	$form -> addElement('submit', null, __('Next'));

  186. 	$form->setRequiredNote('<span class="required_note_star">*</span> <span class="required_note">'.__('denotes required field').'</span>');

  187. 	$form->display();

  188.     print('</div>');

  189. } elseif(!isset($_GET['htaccess'])) {

  190. 	ob_start();

  191. 	print('<h1>' . __('Welcome to EPESI setup!') . '<br></h1><h2>' . __('Hosting compatibility') . ':</h2><br><div class="license">');

  192. 	if(check_htaccess()) {

  193. 		$_GET['htaccess'] = 1;

  194. 		ob_end_clean();

  195. 	} else {

  196. 		print('</div><br><a class="button" href="setup.php?license=1&htaccess=1&install_lang='.$install_lang_load.'">' . __('Ok') . '</a>');

  197. 		ob_end_flush();

  198. 	}

  199. }

  200. if(isset($_GET['htaccess']) && isset($_GET['license'])) {

  201. 	set_header(__('Configuration'));

  202. 	$form = new HTML_QuickForm('serverform','post',$_SERVER['PHP_SELF'].'?'.http_build_query($_GET));

  203. 	$form -> addElement('header', null, __('Database server settings'));

  204. 	$form -> addElement('text', 'host', __('Database server address'));

  205. 	$form -> addRule('host', __('Field required'), 'required');

  206. 	$form -> addElement('text', 'port', __('Custom database port'));

  207. 	$form -> addElement('select', 'engine', __('Database engine'), array('postgres'=>'PostgreSQL', 'mysqli'=>'MySQL'));

  208. 	$form -> addRule('engine', __('Field required'), 'required');

  209. 	$form -> addElement('text', 'user', __('Database server user'));

  210. 	$form -> addRule('user', __('Field required'), 'required');

  211. 	$form -> addElement('password', 'password', __('Database server password'));

  212. 	$form -> addRule('password', __('Field required'), 'required');

  213. 	$form -> addElement('text', 'db', __('Database name'));

  214. 	$form -> addRule('db', __('Field required'), 'required');

  215.     $create_db_warn_msg = __('WARNING: Make sure you have CREATE access level to do this!');

  216. 	$form -> addElement('select', 'newdb', __('Create new database'),

  217.             array(0 => __('No'), 1 => __('Yes')),

  218.             array('onChange' => 'if(this.value==1) alert("' . $create_db_warn_msg . '","warning");'));

  219. 	$form -> addRule('newdb', __('Field required'), 'required');

  220. 	$form -> addElement('header', null, __('Other settings'));

  221. 	$form -> addElement('select', 'direction', __('Text direction'),

  222.             array(0 => __('Left to Right'), 1 => __('Right to Left')));

  223. 

  224. 	$form -> addElement('submit', 'submit', __('Next'));

  225. 	$form -> setDefaults(array('engine'=>'mysqli','db'=>'epesi','host'=>'localhost'));

  226. 	$form->setRequiredNote('<span class="required_note_star">*</span> <span class="required_note">'.__('denotes required field').'</span>');

  227. 

  228.     if (file_exists($fast_install_filename)) {

  229.         include $fast_install_filename;

  230.         if (isset($CONFIG) && is_array($CONFIG)) {

  231.             $txt = __('Some fields were filled to make installation easier.');

  232.             print '<div style="text-align:center"><p style="width: 250px;margin-left: auto;margin-right: auto;">' . $txt . '</p></div>';

  233.             foreach ($CONFIG as $key => $value) {

  234.                 $form->setDefaults(array($key => $value));

  235.                 $form->getElement($key)->freeze();

  236.             }

  237.         }

  238.     }

  239.     $required_note_text = __('denotes required field');

  240. 	$form->setRequiredNote('<span class="required_note_star">*</span> <span class="required_note">' . $required_note_text . '</span>');

  241. 	$form -> addElement('html', '<tr><td colspan=2><br /><b>'

  242.             . __('Any existing tables will be dropped!') . '</b><br />'

  243.             . __('The database will be populated with data.') . '<br />'

  244.             . __('This operation can take several minutes.') . '</td></tr>');

  245. 	if($form -> validate()) {

  246. 		$engine = $form -> exportValue('engine');

  247. 		$direction = $form -> exportValue('direction');

  248. 		$other = array('direction'=>$direction);

  249.         $host = $form -> exportValue('host');

  250. 		$port = $form->exportValue('port');

  251.         $user = $form -> exportValue('user');

  252.         $pass = $form -> exportValue('password');

  253.         $dbname = $form -> exportValue('db');

  254.         $new_db = $form->exportValue('newdb');

  255. 		switch($engine) {

  256. 			case 'postgres':

  257. 				if(!function_exists('pg_connect')) {

  258. 				    echo(__('Please enable postgresql extension in php.ini.'));

  259. 				} else {

  260. 					$port_def = $port ? " port=$port" : '';

  261. 					$link = pg_connect("host=$host user=$user password=$pass dbname=postgres" . $port_def);

  262. 					if(!$link) {

  263. 	 					echo(__('Could not connect.'));

  264. 					} else {

  265. 						if ($port) {

  266. 							$host .= ':' . $port;

  267. 						}

  268. 						if ($new_db == 1) {

  269. 							$sql = 'CREATE DATABASE "'.$dbname.'"';

  270. 							if (pg_query($link, $sql)) {

  271. 				   				//echo "Database '$dbname' created successfully\n";

  272. 				   				write_config($host,$user,$pass,$dbname,$engine,$other);

  273. 							} else {

  274. 		 		  				echo __('Error creating database') . ': ' . pg_last_error() . "\n";

  275. 		 	  				}

  276. 		   					pg_close($link);

  277. 						} else {

  278. 							include_once('libs/adodb/adodb.inc.php');

  279. 							$ado = & NewADOConnection('postgres');

  280. 							if(!@$ado->Connect($host,$user,$pass,$dbname)) {

  281. 								echo __('Database does not exist.') . "\n";

  282.                                 echo '<br />' .__('Please create the database first or select option')

  283.                                         . ':<br /><b>' . __('Create new database') . '</b>';

  284. 							} else {

  285. 								write_config($host, $user, $pass, $dbname, $engine,$other);

  286. 							}

  287. 						}

  288. 					}

  289. 				}

  290. 			break;

  291.             case 'mysqli':

  292.                 if (!class_exists('mysqli')) {

  293.                     echo(__('Please enable mysql extension in php.ini.'));

  294.                 } else {

  295. 					if ($port) {

  296. 						$host .= ':' . $port;

  297. 					}

  298.                     $link = new mysqli($host, $user, $pass);

  299.                     if ($link->connect_errno) {

  300.                         echo(__('Could not connect') . "(Errno: {$link->connect_errno}): " . $link->connect_error);

  301.                     } else {

  302.                         if ($new_db == 1) {

  303.                             $sql = 'CREATE DATABASE `' . $dbname . '` CHARACTER SET utf8 COLLATE utf8_unicode_ci';

  304.                             if ($link->query($sql)) {

  305.                                 write_config($host, $user, $pass, $dbname, $engine, $other);

  306.                             } else {

  307.                                 echo __('Error creating database: ') . $link->error . "\n";

  308.                             }

  309.                             $link->close();

  310.                         } else {

  311.                             $result = $link->select_db($dbname);

  312.                             if (!$result) {

  313.                                 echo __('Database does not exist') . ': ' . $link->error . "\n";

  314.                                 echo '<br />' . __('Please create the database first or select option')

  315.                                 . ':<br /><b>' . __('Create new database') . '</b>';

  316.                             } else {

  317.                                 write_config($host, $user, $pass, $dbname, $engine, $other);

  318.                             }

  319.                         }

  320.                     }

  321.                 }

  322.                 break;

  323. 		}

  324. 	}

  325. 

  326. 	$renderer =& $form->defaultRenderer();

  327. 	$renderer->setHeaderTemplate("\n\t<tr>\n\t\t<td style=\"white-space: nowrap; height: 20px; vertical-align: middle; background-color: #336699; background-image: url('images/header-blue.png'); background-repeat: repeat-x; color: #FFFFFF; font-weight: normal; text-align: center;\" align=\"left\" valign=\"baseline\" colspan=\"2\">{header}</td>\n\t</tr>");

  328. 	$renderer->setElementTemplate("\n\t<tr>\n\t\t<td align=\"right\" valign=\"baseline\"><!-- BEGIN required --><span style=\"color: #ff0000\">*</span><!-- END required -->{label}</td>\n\t\t<td valign=\"baseline\" align=\"left\"><!-- BEGIN error --><span style=\"color: #ff0000\">{error}</span><br /><!-- END error -->\t{element}</td>\n\t</tr>");

  329. 		$form->accept($renderer);

  330. 		print($renderer->toHtml());

  331. 	}

  332. 

  333. ///////////////////////////////////////////////////////////////

  334. ///////////////////////////////////////////////////////////////

  335. function check_htaccess() {

  336. 	$dir = trim(dirname($_SERVER['SCRIPT_NAME']),'/');

  337. 	$epesi_dir = '/'.$dir.($dir?'/':'');

  338. 	$protocol = (isset($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS'])!== "off") ? 'https://' : 'http://';

  339. 	$test_url = $protocol.$_SERVER['HTTP_HOST'].$epesi_dir.'data/test.php';

  340. 	file_put_contents('data/test.php','<?php'."\n".'print("OK"); ?>');

  341. 

  342.     	copy('htaccess.txt','data/.htaccess');

  343. 

  344. 	if(ini_get('allow_url_fopen'))

  345. 		$ret = @file_get_contents($test_url);

  346. 	elseif (extension_loaded('curl')) { // Test if curl is loaded

  347. 		$ch = curl_init();

  348. 		curl_setopt($ch, CURLOPT_HEADER, 0);

  349. 		curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //Set curl to return the data instead of printing it to the browser.

  350. 		curl_setopt($ch, CURLOPT_URL, $test_url);

  351. 		$ret = curl_exec($ch);

  352. 		curl_close($ch);

  353. 	}

  354. 

  355. 	if(!isset($ret)) {

  356. 		unlink('data/.htaccess');

  357. 		unlink('data/test.php');

  358. 		print(__('Unable to check EPESI root .htaccess file hosting compatibility. You should tweak it yourself.')

  359.                 . '<br>' . __('Suggested .htaccess file is:') . '<pre>' . file_get_contents('htaccess.txt') . '</pre>');

  360. 		return false;

  361. 	}

  362. 	if($ret!=="OK") {

  363. 		file_put_contents('data/.htaccess',"Options -Indexes\nSetEnv PHPRC ".dirname(__FILE__)."\n");

  364. 		if(ini_get('allow_url_fopen'))

  365. 			$ret = @file_get_contents($test_url);

  366. 		elseif (extension_loaded('curl')) { // Test if curl is loaded

  367. 			$ch = curl_init();

  368. 			curl_setopt($ch, CURLOPT_HEADER, 0);

  369. 			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //Set curl to return the data instead of printing it to the browser.

  370. 			curl_setopt($ch, CURLOPT_URL, $test_url);

  371. 			$ret = curl_exec($ch);

  372. 			curl_close($ch);

  373. 		}

  374. 		if($ret!=="OK") {

  375. 			unlink('data/.htaccess');

  376. 			unlink('data/test.php');

  377. 			print(__('Your hosting is not compatible with default EPESI root .htaccess file. You should tweak it yourself.')

  378.                     . '<br>' . __('Default .htaccess file is:') . '<pre>' . file_get_contents('htaccess.txt') . '</pre>');

  379. 			return false;

  380. 		}

  381. 	}

  382. 	if(!is_writable('.')) {

  383. 		unlink('data/test.php');

  384. 		print(__('Your hosting is compatible with default EPESI root .htaccess file, but installer cannot write to EPESI root directory. You should paste following text to .htaccess file manually.')

  385.                 . '<pre>' . file_get_contents('data/.htaccess') . '</pre>');

  386. 		unlink('data/.htaccess');

  387. 		return false;

  388. 	}

  389. 	unlink('data/test.php');

  390. 	rename('data/.htaccess','.htaccess');

  391. 	return true;

  392. }

  393. 

  394. function write_config($host, $user, $pass, $dbname, $engine, $other) {

  395.     global $install_lang_load;

  396. 	$local_dir = dirname(dirname(str_replace('\\','/',__FILE__)));

  397. 	$script_filename = str_replace('\\','/',$_SERVER['SCRIPT_FILENAME']);

  398. 	$other_conf = '';

  399. 	if(strcmp($local_dir,substr($script_filename,0,strlen($local_dir)))) {

  400.         $epesi_dir = str_replace('\\', '/', dirname($_SERVER['SCRIPT_NAME']));

  401.         $other_conf .= "\n".'@define(\'EPESI_DIR\',\''. addcslashes($epesi_dir, '\'\\') .'\');';

  402.     }

  403. 	$other_conf .= "\n".'define(\'DIRECTION_RTL\',\''.($other['direction']?'1':'0').'\');';

  404. 

  405. 	$protocol = (isset($_SERVER['HTTPS']) && strtolower($_SERVER['HTTPS'])!== "off") ? 'https://' : 'http://';

  406.         $domain_name = '';

  407.         if (isset($_SERVER['HTTP_HOST']) && $_SERVER['HTTP_HOST']) {

  408.             $domain_name = $_SERVER['HTTP_HOST'];

  409.         } else if (isset($_SERVER['SERVER_NAME']) && $_SERVER['SERVER_NAME']) {

  410.             $domain_name = $_SERVER['SERVER_NAME'];

  411.         }

  412.     if ($domain_name) {

  413.         $url = $protocol . $domain_name . dirname($_SERVER['REQUEST_URI']);

  414.         $url = str_replace('\\', '/', $url);

  415.         $other_conf .= "\n" . 'define(\'EPESI_URL\',\'' . addcslashes($url, '\'\\') . '\');';

  416.     }

  417. 	$c = & fopen(DATA_DIR.'/config.php', 'w');

  418. 	fwrite($c, '<?php

  419. /**

  420.  * Config file.

  421.  * 

  422.  * All commented out defines are default values as they were

  423.  * during the installation process. Default values may change after an update,

  424.  * but your config file will remain as it was. If you want to know

  425.  * current default values please look at file include/config.php

  426.  *

  427.  * This file contains database configuration.

  428.  */

  429. defined(\'_VALID_ACCESS\') || die(\'Direct access forbidden\');

  430. 

  431. /**

  432.  * Address of SQL server.

  433.  */

  434. define(\'DATABASE_HOST\',\''.addcslashes($host, '\'\\').'\');

  435. 

  436. /**

  437.  * User to log in to SQL server.

  438.  */

  439. define(\'DATABASE_USER\',\''.addcslashes($user, '\'\\').'\');

  440. 

  441. /**

  442.  * User password to authorize SQL server.

  443.  */

  444. define(\'DATABASE_PASSWORD\',\''.addcslashes($pass, '\'\\').'\');

  445. 

  446. /**

  447.  * Database to use.

  448.  */

  449. define(\'DATABASE_NAME\',\''.addcslashes($dbname, '\'\\').'\');

  450. 

  451. /**

  452.  * Database driver.

  453.  */

  454. define(\'DATABASE_DRIVER\',\''.addcslashes($engine, '\'\\').'\');

  455. 

  456. /*

  457.  * Turns on transfer reduction: not everything is sent to the client

  458.  */

  459. //define(\'REDUCING_TRANSFER\',1);

  460. 

  461. /*

  462.  * A lot of debug info, starting with what modules are changed, what module variables are set... etc.

  463.  */

  464. //define(\'DEBUG\',0);

  465. 

  466. /*

  467.  * Show module loading time ...  = module + all children times

  468.  */

  469. //define(\'MODULE_TIMES\',0);

  470. 

  471. /*

  472.  * Show queries execution time.

  473.  */

  474. //define(\'SQL_TIMES\',0);

  475. 

  476. /*

  477.  * If you have got good server, but poor connection, turn it on.

  478.  */

  479. //define(\'STRIP_OUTPUT\',0);

  480. 

  481. /*

  482.  * Display errors on page.

  483.  */

  484. //define(\'DISPLAY_ERRORS\',1);

  485. 

  486. /*

  487.  * Notify all errors, including E_NOTICE, etc. Developer should use it!

  488.  */

  489. //define(\'REPORT_ALL_ERRORS\',0);

  490. 

  491. /*

  492.  * Compress history

  493.  */

  494. //define(\'GZIP_HISTORY\',1);

  495. 

  496. /*

  497.  * Compress HTTP output

  498.  */

  499. //define(\'MINIFY_ENCODE\',1);

  500. 

  501. /*

  502.  * Apply sources minifying algorithms.

  503.  *

  504.  * If enabled CPU usage may raise, but amount

  505.  * of transferred data is smaller.

  506.  */

  507. //define(\'MINIFY_SOURCES\',0);

  508. 

  509. /*

  510.  * Show donation links in EPESI

  511.  */

  512. //define(\'SUGGEST_DONATION\',1);

  513. 

  514. /*

  515.  * automatically check for new version

  516.  */

  517. //define(\'CHECK_VERSION\',1);

  518. 

  519. /*

  520.  * Disable some administrator preferences.

  521.  */

  522. //define(\'DEMO_MODE\',0);

  523. 

  524. define(\'FILE_SESSION_DIR\',\''.str_replace('\\', '/', sys_get_temp_dir()).'\');

  525. define(\'INSTALLATION_ID\',\''.md5(__FILE__ . strval(microtime(true))).'\');

  526. 

  527. '.$other_conf.'

  528. ?>');

  529. 	fclose($c);

  530. 

  531. 	ob_start();

  532. 	ob_start('rm_config');

  533. 

  534. 	//fill database

  535. 	clean_database();

  536. 	install_base();

  537. 

  538. 	ob_end_flush();

  539. 

  540. 	if(file_exists(DATA_DIR.'/config.php'))

  541. 		header("Location: setup.php?install_lang={$install_lang_load}&check=1");

  542. 	ob_end_flush();

  543. }

  544. 

  545. 

  546. //////////////////////////////////////////////

  547. function rm_config($x) {

  548. 	if($x) {

  549. 		unlink(dirname(__FILE__).'/'.DATA_DIR.'/config.php');

  550. 		clean_database();

  551. 	}

  552. 	return $x;

  553. }

  554. 

  555. function clean_database() {

  556. 	require_once('include/config.php');

  557. 	require_once('include/database.php');

  558. 	$tables_db = DB::MetaTables();

  559. 	$tables = array();

  560. 	if(DB::is_mysql())

  561. 		DB::Execute('SET FOREIGN_KEY_CHECKS=0');

  562. 	if(DB::is_postgresql() && strpos(DB::GetOne('SELECT version()'),'PostgreSQL 8.2')!==false) {

  563.     	    foreach ($tables_db as $t) {

  564. 	            $idxs = DB::Execute('SELECT t.tgargs as args FROM pg_trigger t,pg_class c,pg_proc p WHERE t.tgenabled AND t.tgrelid = c.oid AND t.tgfoid = p.oid AND p.proname = \'RI_FKey_check_ins\' AND c.relname = \''.strtolower($t).'\' ORDER BY t.tgrelid');

  565. 		    $matches = array(1=>array());

  566. 		    while ($i = $idxs->FetchRow()) {

  567. 		            $data = explode(chr(0), $i[0]);

  568. 			    $matches[1][] = $data[0];

  569. 		    }

  570. 		    $num_keys = count($matches[1]);

  571. 		    for ( $i = 0;  $i < $num_keys;  $i ++ )

  572. 		            DB::Execute('ALTER TABLE '.$t.' DROP CONSTRAINT '.$matches[1][$i]);

  573. 	}

  574. 																	    }

  575. 	foreach($tables_db as $t) {

  576. 		DB::DropTable($t);

  577. 	}

  578. 	if(DB::is_mysql())

  579. 		DB::Execute('SET FOREIGN_KEY_CHECKS=1');

  580. }

  581. 

  582. function install_base() {

  583. 	require_once('include/config.php');

  584. 	require_once('include/database.php');

  585. 	

  586. 	@DB::Execute('ALTER DATABASE `'.DATABASE_NAME.'` CHARACTER SET utf8 COLLATE utf8_unicode_ci');

  587. 

  588. 	$ret = DB::CreateTable('modules',"name C(128) KEY,version I NOTNULL, priority I NOTNULL DEFAULT 0, state I NOTNULL DEFAULT 0");

  589. 	if($ret===false)

  590. 		die('Invalid SQL query - Setup module (modules table)');

  591. 

  592. 	$ret = DB::CreateTable('cron',"func C(32) KEY,last I NOTNULL, running I1 NOTNULL DEFAULT 0, description C(255)");

  593. 	if($ret===false)

  594. 		die('Invalid SQL query - Setup cron (cron table)');

  595. 

  596. 	$ret = DB::CreateTable('session',"name C(128) NOTNULL," .

  597. 			"expires I NOTNULL DEFAULT 0, data B",array('constraints'=>', PRIMARY KEY(name)'));

  598. 	if($ret===false)

  599. 		die('Invalid SQL query - Database module (session table)');

  600. 

  601. 	$ret = DB::CreateTable('session_client',"session_name C(128) NOTNULL, client_id I2," .

  602. 			"data B",array('constraints'=>', FOREIGN KEY(session_name) REFERENCES session(name), PRIMARY KEY(client_id,session_name)'));

  603. 	if($ret===false)

  604. 		die('Invalid SQL query - Database module (session_client table)');

  605. 

  606. 	$ret = DB::CreateTable('history',"session_name C(128) NOTNULL, page_id I, client_id I2," .

  607. 			"data B",array('constraints'=>', FOREIGN KEY(session_name) REFERENCES session(name), PRIMARY KEY(client_id,session_name,page_id)'));

  608. 	if($ret===false)

  609. 		die('Invalid SQL query - Database module (history table)');

  610. 

  611. 	DB::CreateIndex('history__session_name__client_id__idx', 'history', 'session_name, client_id');

  612. 

  613. 	$ret = DB::CreateTable('variables',"name C(128) KEY,value X");

  614. 	if($ret===false)

  615. 		die('Invalid SQL query - Database module (variables table)');

  616. 

  617. 	$ret = DB::Execute("insert into variables values('default_module',%s)",array(serialize('FirstRun')));

  618. 	if($ret === false)

  619. 		die('Invalid SQL query - Setup module (populating variables)');

  620. 

  621. 	$ret = DB::Execute("insert into variables values('version',%s)",array(serialize(EPESI_VERSION)));

  622. 	if($ret === false)

  623. 		die('Invalid SQL query - Setup module (populating variables)');

  624. 

  625. }

  626. //////////////////////////////////////////////

  627. function read_doc_file($file_basename, $suffix = 'html') {

  628.     global $install_lang_load;

  629.     $dir = 'docs/';

  630.     $file = $dir . $file_basename . '.' . $suffix;  // default file

  631.     $custom_file = $dir . "{$file_basename}_{$install_lang_load}.{$suffix}";

  632.     if (file_exists($custom_file))

  633.         $file = $custom_file;

  634.     $fp = @fopen($file, 'r');

  635.     if ($fp) {

  636.         $content = fread($fp, filesize($file));

  637.     }

  638.     fclose($fp);

  639.     return $content;

  640. }

  641. 

  642. ob_end_flush();

  643. ?>