PageRenderTime 58ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 1ms

/net-analyzer/midas-nms/files/install.php

http://github.com/funtoo/portage
PHP | 456 lines | 390 code | 26 blank | 40 comment | 49 complexity | e7a862adf3ca3c2e272a105a9d0f8508 MD5 | raw file
Possible License(s): Apache-2.0, AGPL-1.0, LGPL-2.1, MIT, CC-BY-SA-3.0, LGPL-2.0, Unlicense, AGPL-3.0, CC0-1.0, BSD-3-Clause, GPL-2.0, LGPL-3.0, MPL-2.0-no-copyleft-exception, GPL-3.0 
    

  1. <?

    2. 

  2. /********************************************************************

    3. 

  3. Copyright (c) 2003 Jason Sessler

    4. 

  4. 

    5. 

  5. Permission is hereby granted, free of charge, to any person

    6. 

  6. obtaining a copy of this software and associated documentation files

    7. 

  7. (the "Software"), to deal in the Software without restriction,

    8. 

  8. including without limitation the rights to use, copy, modify, merge,

    9. 

  9. publish, distribute, sublicense, and/or sell copies of the Software,

    10. 

  10. and to permit persons to whom the Software is furnished to do so,

    11. 

  11. subject to the following conditions:

    12. 

  12. 

    13. 

  13. The above copyright notice and this permission notice shall be

    14. 

  14. included in all copies or substantial portions of the Software.

    15. 

  15. 

    16. 

  16. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,

    17. 

  17. EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF

    18. 

  18. MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND

    19. 

  19. NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS

    20. 

  20. BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN

    21. 

  21. ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN

    22. 

  22. CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE

    23. 

  23. SOFTWARE.

    24. 

  24. ********************************************************************/

    25. 

  25. 

    26. 

  26. /********************************************************************

    27. 

  27. 	Changelog:

    28. 

  28. 	01/11/2004  -   Changed how the MIDAS version is loaded to variable.

    29. 

  29. 	12/15/2003  -   Version was incorrect

    30. 

  30. 	            -   Cleaned a few non-problematic typos

    31. 

  31. 	            -   Added check for MySQL Support in PHP

    32. 

  32. 

    33. 

  33. 	12/02/2003  -   Added set_time_limit()

    34. 

  34. 

    35. 

  35. 	11/27/2003  -   Added on/off toggle for creating the

    36. 

  36. 					inc/config/config.php file.

    37. 

  37. 

    38. 

  38. ********************************************************************/

    39. 

  39. 

    40. 

  40. // Needed for sql statements. When updating large MIDAS DBs, the

    41. 

  41. // process takes a lot longer than the php default time_limit

    42. 

  42. @set_time_limit(0);

    43. 

  43. 

    44. 

  44. define(_DOC_ROOT, "../");

    45. 

  45. define("_APPNAME", "MIDAS WebView Installer");

    46. 

  46. 

    47. 

  47. include _DOC_ROOT . "inc/version.php";

    48. 

  48. include _DOC_ROOT . "lib/mysql.inc.php";

    49. 

  49. include _DOC_ROOT . "lib/html.inc.php";

    50. 

  50. include _DOC_ROOT . "themes/plain_blue.php";

    51. 

  51. 

    52. 

  52. include "install.inc.php";

    53. 

  53. 

    54. 

  54. printf("<HTML>\n");

    55. 

  55. printf("<HEAD>\n");

    56. 

  56. printf("<TITLE>%s %s</TITLE>\n", _APPNAME, _VERSION);

    57. 

  57. printf("</HEAD>\n");

    58. 

  58. printf("<LINK rel=stylesheet href='%s' type=text/css>\n", $color['css']);

    59. 

  59. 

    60. 

  60. printf("<BODY bgcolor=%s topmargin=10 leftmargin=10>\n", $color[3]);

    61. 

  61. 

    62. 

  62. $DIR      = _DOC_ROOT . "inc/config";

    63. 

  63. $IMGDIR   = _DOC_ROOT . "php-graph";

    64. 

  64. $CONFIG   = $DIR . "/config.php";

    65. 

  65. $TEMPLATE = $DIR . "/config.template";

    66. 

  66. 

    67. 

  67. if($_POST['LOC'] == "") {

    68. 

  68. 	$info = null;

    69. 

  69. 	$error = FALSE;

    70. 

  70. 

    71. 

  71. 	if(@is_readable($CONFIG)) {

    72. 

  72. 		$schk .= html_tag("TR",

    73. 

  73. 			         html_tag("TD", "Site Config Exists", $color[0], "class=blacksmall align=left") .

    74. 

  74. 					 html_tag("TD", "WARNING", $color[1], "class=blacksmall align=center"),

    75. 

  75. 				 "", "");

    76. 

  76. 	} else {

    77. 

  77. 		$schk .= html_tag("TR",

    78. 

  78. 			         html_tag("TD", "Site Config Exists", $color[0], "class=blacksmall align=left") .

    79. 

  79. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    80. 

  80. 				 "", "");

    81. 

  81. 	}

    82. 

  82. 

    83. 

  83. 	if(@is_readable($TEMPLATE)) {

    84. 

  84. 		$schk .= html_tag("TR",

    85. 

  85. 			         html_tag("TD", "Site Config Template Exists", $color[0], "class=blacksmall align=left") .

    86. 

  86. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    87. 

  87. 				 "", "");

    88. 

  88. 	} else {

    89. 

  89. 		$schk .= html_tag("TR",

    90. 

  90. 			         html_tag("TD", "Site Config Template Exists", $color[0], "class=blacksmall align=left") .

    91. 

  91. 					 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    92. 

  92. 				 "", "");

    93. 

  93. 		$error = TRUE;

    94. 

  94. 	}

    95. 

  95. 

    96. 

  96. 	if(@!is_writeable($DIR)) {

    97. 

  97. 		$schk .= html_tag("TR",

    98. 

  98. 			         html_tag("TD", "/inc/config directory is Writable", $color[0], "class=blacksmall align=left") .

    99. 

  99. 					 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    100. 

  100. 				 "", "");

    101. 

  101. 		$error = TRUE;

    102. 

  102. 	} else {

    103. 

  103. 		$schk .= html_tag("TR",

    104. 

  104. 			         html_tag("TD", "/inc/config directory is Writable", $color[0], "class=blacksmall align=left") .

    105. 

  105. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    106. 

  106. 				 "", "");

    107. 

  107. 	}

    108. 

  108. 

    109. 

  109. 	if(@!is_writeable($IMGDIR)) {

    110. 

  110. 		$schk .= html_tag("TR",

    111. 

  111. 			         html_tag("TD", "/php-graph directory is Writable", $color[0], "class=blacksmall align=left") .

    112. 

  112. 					 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    113. 

  113. 				 "", "");

    114. 

  114. 		$error = TRUE;

    115. 

  115. 	} else {

    116. 

  116. 		$schk .= html_tag("TR",

    117. 

  117. 			         html_tag("TD", "/php-graph directory is Writable", $color[0], "class=blacksmall align=left") .

    118. 

  118. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    119. 

  119. 				 "", "");

    120. 

  120. 	}

    121. 

  121. 	if(@!function_exists(mysql_connect)) {

    122. 

  122. 		$schk .= html_tag("TR",

    123. 

  123. 			         html_tag("TD", "PHP with MySQL support", $color[0], "class=blacksmall align=left") .

    124. 

  124. 					 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    125. 

  125. 				 "", "");

    126. 

  126. 		$error = TRUE;

    127. 

  127. 	} else {

    128. 

  128. 		$schk .= html_tag("TR",

    129. 

  129. 			         html_tag("TD", "PHP with MySQL support", $color[0], "class=blacksmall align=left") .

    130. 

  130. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    131. 

  131. 				 "", "");

    132. 

  132. 	}

    133. 

  133. 	if(@!function_exists(imagepng)) {

    134. 

  134. 		$schk .= html_tag("TR",

    135. 

  135. 			         html_tag("TD", "PHP with GD+PNG support", $color[0], "class=blacksmall align=left") .

    136. 

  136. 					 html_tag("TD", "WARNING", $color[1], "class=blacksmall align=center"),

    137. 

  137. 				 "", "");

    138. 

  138. 	} else {

    139. 

  139. 		$schk .= html_tag("TR",

    140. 

  140. 			         html_tag("TD", "PHP with GD+PNG support", $color[0], "class=blacksmall align=left") .

    141. 

  141. 					 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    142. 

  142. 				 "", "");

    143. 

  143. 	}

    144. 

  144. 

    145. 

  145. 	$conf = html_tag("TR",

    146. 

  146. 	            html_tag("TD", "Absolute directory\n", $color[0], "class=blacksmall align=left") .

    147. 

  147. 	            html_tag("TD", "<input type=textbox name=ABS_ROOT value='/var/www/localhost/htdocs/midas-nms' size=30>\n", $color[3], "class=blacksmall align=left"),

    148. 

  148. 			"", "") .

    149. 

  149. 			html_tag("TR",

    150. 

  150. 	            html_tag("TD", "URL Directory\n", $color[0], "class=blacksmall align=left") .

    151. 

  151. 	            html_tag("TD", "<input type=textbox name=DOC_ROOT value='/midas-nms' size=20>\n", $color[3], "class=blacksmall align=left"),

    152. 

  152. 			"", "") .

    153. 

  153. 			sprintf("<input type=hidden name=RRD_ROOT value='/php-graph'>\n") .

    154. 

  154. 			html_tag("TR",

    155. 

  155. 	            html_tag("TD", "PHP Graphics URL Location\n", $color[0], "class=blacksmall align=left") .

    156. 

  156. 	            html_tag("TD", "/php-graph\n", $color[3], "class=blacksmall align=left"),

    157. 

  157. 			"", "") .

    158. 

  158. 			html_tag("TR",

    159. 

  159. 	            html_tag("TD", "MySQL Server\n", $color[0], "class=blacksmall align=left") .

    160. 

  160. 	            html_tag("TD", "<input type=textbox name=SERVER value='localhost' size=20>\n", $color[3], "class=blacksmall align=left"),

    161. 

  161. 			"", "") .

    162. 

  162. 			html_tag("TR",

    163. 

  163. 	            html_tag("TD", "MySQL user\n", $color[0], "class=blacksmall align=left") .

    164. 

  164. 	            html_tag("TD", "<input type=textbox name=USER value='root' size=15>\n", $color[3], "class=blacksmall align=left"),

    165. 

  165. 			"", "") .

    166. 

  166. 			html_tag("TR",

    167. 

  167. 	            html_tag("TD", "MySQL passwd\n", $color[0], "class=blacksmall align=left") .

    168. 

  168. 	            html_tag("TD", "<input type=password name=PASSWD value='' size=10>\n", $color[3], "class=blacksmall align=left"),

    169. 

  169. 			"", "") .

    170. 

  170. 			html_tag("TR",

    171. 

  171. 	            html_tag("TD", "MySQL dB\n", $color[0], "class=blacksmall align=left") .

    172. 

  172. 	            html_tag("TD", "<input type=textbox name=DB value='MIDAS2' size=15>\n", $color[3], "class=blacksmall align=left"),

    173. 

  173. 			"", "") .

    174. 

  174. 			html_tag("TR",

    175. 

  175. 	            html_tag("TD", "MIDAS MySQL allowed hosts\n", $color[0], "class=blacksmall align=left") .

    176. 

  176. 	            html_tag("TD", "<input type=textbox name='ALLOWED_HOSTS' value='localhost' size=25>\n", $color[3], "class=blacksmall align=left"),

    177. 

  177. 			"", "") .

    178. 

  178. 			html_tag("TR",

    179. 

  179. 	            html_tag("TD", "MIDAS MySQL user\n", $color[0], "class=blacksmall align=left") .

    180. 

  180. 	            html_tag("TD", "<input type=textbox name=MIDAS_USER value='midas' size=15>\n", $color[3], "class=blacksmall align=left"),

    181. 

  181. 			"", "") .

    182. 

  182. 			html_tag("TR",

    183. 

  183. 	            html_tag("TD", "MIDAS MySQL passwd\n", $color[0], "class=blacksmall align=left") .

    184. 

  184. 	            html_tag("TD", "<input type=textbox name=MIDAS_PASSWD value='password' size=10>\n", $color[3], "class=blacksmall align=left"),

    185. 

  185. 			"", "") .

    186. 

  186. 			html_tag("TR",

    187. 

  187. 	            html_tag("TD", "MIDAS dB SQL file\n", $color[0], "class=blacksmall align=left") .

    188. 

  188. 	            html_tag("TD", "<input type=textbox name=MIDAS_SQL value='/usr/share/midas-nms/sql/MIDAS.sql' size=55>\n", $color[3], "class=blacksmall align=left"),

    189. 

  189. 			"", "") .

    190. 

  190. 			html_tag("TR",

    191. 

  191. 	            html_tag("TD", "SNORT Default Rules SQL file\n", $color[0], "class=blacksmall align=left") .

    192. 

  192. 	            html_tag("TD", "<input type=textbox name=SNORT_SQL value='/usr/share/midas-nms/sql/DefaultSnortRules.sql' size=55>\n", $color[3], "class=blacksmall align=left"),

    193. 

  193. 			"", "") .

    194. 

  194. 			html_tag("TR",

    195. 

  195. 	            html_tag("TD", "Create inc/config/config.php file\n", $color[0], "class=blacksmall align=left") .

    196. 

  196. 	            html_tag("TD", "<input type=checkbox name=CREATE_CONFIG_FILE value='1' checked>\n", $color[3], "class=blacksmall align=center"),

    197. 

  197. 			"", "") .

    198. 

  198. 			html_tag("TR",

    199. 

  199. 	            html_tag("TD", "Create MIDAS dB user\n", $color[0], "class=blacksmall align=left") .

    200. 

  200. 	            html_tag("TD", "<input type=checkbox name=CREATE_MIDAS_USER value='1' checked>\n", $color[3], "class=blacksmall align=center"),

    201. 

  201. 			"", "") .

    202. 

  202. 			html_tag("TR",

    203. 

  203. 	            html_tag("TD", "Install MIDAS SQL\n", $color[0], "class=blacksmall align=left") .

    204. 

  204. 	            html_tag("TD", "<input type=checkbox name=INSTALL_MIDAS_SQL value='1' checked>\n", $color[3], "class=blacksmall align=center"),

    205. 

  205. 			"", "") .

    206. 

  206. 			html_tag("TR",

    207. 

  207. 	            html_tag("TD", "Install SNORT Default Rules SQL file\n", $color[0], "class=blacksmall align=left") .

    208. 

  208. 	            html_tag("TD", "<input type=checkbox name=INSTALL_SNORT_SQL value='1' checked>\n", $color[3], "class=blacksmall align=center"),

    209. 

  209. 			"", "");

    210. 

  210. 

    211. 

  211. 	$info = html_tag("TABLE",

    212. 

  212. 			    html_tag("TR",

    213. 

  213. 				    html_tag("TD", "<b>Site Configuration Sanity Checks</b>", $color[9], "colspan=2 class=blacksmall align=center"),

    214. 

  214. 				"", "") .

    215. 

  215. 				$schk,

    216. 

  216.             $color[10], "width=50% cellspacing=1 cellpadding=2") .

    217. 

  217.             "<br>" .

    218. 

  218. 			((!$error) ?

    219. 

  219. 			html_tag("TABLE",

    220. 

  220. 			    html_tag("TR",

    221. 

  221. 			        sprintf("<FORM method=post action='install.php'>\n") .

    222. 

  222. 				    html_tag("TD", "<b>Site Configuration</b>", $color[9], "colspan=2 class=blacksmall align=center"),

    223. 

  223. 				"", "") .

    224. 

  224. 				$conf .

    225. 

  225. 			    html_tag("TR",

    226. 

  226. 				    html_tag("TD", "<input type=submit name=LOC value=INSTALL>\n", $color[3], "colspan=2 class=blacksmall align=center") .

    227. 

  227. 				    sprintf("</FORM>\n"),

    228. 

  228. 				"", ""),

    229. 

  229. 			$color[10], "width=50% cellspacing=1 cellpadding=2") :

    230. 

  230. 			"The above error(s) must be fixed before continuing!\n");

    231. 

  231. } else if($_POST['LOC'] == "INSTALL") {

    232. 

  232. 	// Building /inc/config/config.php

    233. 

  233. 	if($_POST['CREATE_CONFIG_FILE']) {

    234. 

  234. 		if($tp = @fopen($TEMPLATE, "r")) {

    235. 

  235. 			if($fp = @fopen($CONFIG, "w+")) {

    236. 

  236. 				while(!@feof($tp)) {

    237. 

  237. 					$line = @fgets($tp, 1024);

    238. 

  238. 					$pattern = null;

    239. 

  239. 					$replace = null;

    240. 

  240. 					$x = 0;

    241. 

  241. 					$sPOS = 0;

    242. 

  242. 					$ePOS = 0;

    243. 

  243. 					while(($sPOS = strpos($line, "$[", $ePOS)) !== FALSE) {

    244. 

  244. 						if(($ePOS = strpos($line, "]$", $sPOS)) !== FALSE) {

    245. 

  245. 							$pattern[$x] = substr($line, $sPOS, $ePOS-($sPOS-2));

    246. 

  246. 							$replace[$x] = $_POST[str_replace(Array("$[", "]$"), Array("", ""), $pattern[$x])];

    247. 

  247. 							$x++;

    248. 

  248. 						} else {

    249. 

  249. 							$ePOS = $sPOS;

    250. 

  250. 						}

    251. 

  251. 					}

    252. 

  252. 					fputs($fp, str_replace($pattern, $replace, $line));

    253. 

  253. 				}

    254. 

  254. 				fclose($fp);

    255. 

  255. 			} else {

    256. 

  256. 				$inst = html_tag("TR",

    257. 

  257. 				            html_tag("TD", "config.php created", $color[0], "class=blacksmall align=left") .

    258. 

  258. 				            html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    259. 

  259. 						"", "");

    260. 

  260. 			}

    261. 

  261. 			fclose($tp);

    262. 

  262. 			if(is_null($inst)) {

    263. 

  263. 				$inst = html_tag("TR",

    264. 

  264. 				            html_tag("TD", "config.php created", $color[0], "class=blacksmall align=left") .

    265. 

  265. 				            html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    266. 

  266. 						"", "");

    267. 

  267. 			}

    268. 

  268. 		} else {

    269. 

  269. 			$inst = html_tag("TR",

    270. 

  270. 			            html_tag("TD", "config.php created", $color[0], "class=blacksmall align=left") .

    271. 

  271. 			            html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    272. 

  272. 					"", "");

    273. 

  273. 		}

    274. 

  274. 	}

    275. 

  275. 						

    276. 

  276. 	// SQL install (If applicable)

    277. 

  277. 	$credentials['mySQL']['server'] = $_POST['SERVER'];

    278. 

  278. 	$credentials['mySQL']['user']   = $_POST['USER'];

    279. 

  279. 	$credentials['mySQL']['passwd'] = $_POST['PASSWD'];

    280. 

  280. 	$db = new conn_mySQL($credentials);

    281. 

  281. 

    282. 

  282. 	$db->db_new_conn();

    283. 

  283. 

    284. 

  284. 	if($_POST['CREATE_MIDAS_USER']) {

    285. 

  285. 		$db->db = "mysql";

    286. 

  286. 		$hostList = explode(",", $_POST['ALLOWED_HOSTS']);

    287. 

  287. 		for($x=0;$x<sizeof($hostList);$x++) {

    288. 

  288. 			$db->add_table("user");

    289. 

  289. 			$db->add_data("Host", $hostList[$x]);

    290. 

  290. 			$db->add_data("User", $_POST['MIDAS_USER']);

    291. 

  291. 			$db->add_data("Password", sprintf("PASSWORD('%s')", $_POST['MIDAS_PASSWD']), FALSE);

    292. 

  292. 			$ret = $db->compile_query("INSERT");

    293. 

  293. 			if($ret['return']) {

    294. 

  294. 				$db->run_query();

    295. 

  295. 				$inst .= html_tag("TR",

    296. 

  296. 				             html_tag("TD", sprintf("MIDAS User created (%s)", $hostList[$x]), $color[0], "class=blacksmall align=left") .

    297. 

  297. 				             html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    298. 

  298. 						 "", "");

    299. 

  299. 				$db->clear_res();

    300. 

  300. 

    301. 

  301. 				$db->add_table("db");

    302. 

  302. 				$db->add_data("Host", $hostList[$x]);

    303. 

  303. 				$db->add_data("Db", $_POST['DB']);

    304. 

  304. 				$db->add_data("User", $_POST['MIDAS_USER']);

    305. 

  305. 				$db->add_data("Select_priv", "Y");

    306. 

  306. 				$db->add_data("Insert_priv", "Y");

    307. 

  307. 				$db->add_data("Update_priv", "Y");

    308. 

  308. 				$db->add_data("Delete_priv", "Y");

    309. 

  309. 				$db->add_data("Create_priv", "Y");

    310. 

  310. 				$db->add_data("Drop_priv", "Y");

    311. 

  311. 				$db->add_data("Grant_priv", "Y");

    312. 

  312. 				$db->add_data("References_priv", "Y");

    313. 

  313. 				$db->add_data("Index_priv", "Y");

    314. 

  314. 				$db->add_data("Alter_priv", "Y");

    315. 

  315. 				$ret = $db->compile_query("INSERT");

    316. 

  316. 				if($ret['return']) {

    317. 

  317. 					$db->run_query();

    318. 

  318. 					$inst .= html_tag("TR",

    319. 

  319. 					             html_tag("TD", sprintf("MIDAS User dB privileges (%s)", $hostList[$x]), $color[0], "class=blacksmall align=left") .

    320. 

  320. 				             	 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    321. 

  321. 							 "", "");

    322. 

  322. 				} else {

    323. 

  323. 					$inst .= html_tag("TR",

    324. 

  324. 					             html_tag("TD", sprintf("MIDAS User dB privileges (%s)", $hostList[$x]), $color[0], "class=blacksmall align=left") .

    325. 

  325. 				             	 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    326. 

  326. 							 "", "");

    327. 

  327. 				}

    328. 

  328. 			} else {

    329. 

  329. 				$inst .= html_tag("TR",

    330. 

  330. 				             html_tag("TD", sprintf("MIDAS User created (%s)", $hostList[$x]), $color[0], "class=blacksmall align=left") .

    331. 

  331. 				             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    332. 

  332. 						 "", "");

    333. 

  333. 			}

    334. 

  334. 			$db->clear_res();

    335. 

  335. 		}

    336. 

  336. 

    337. 

  337. 		$db->db = null;

    338. 

  338. 		$db->run_query("FLUSH PRIVILEGES");

    339. 

  339. 		if($db->sqlResults) {

    340. 

  340. 			$inst .= html_tag("TR",

    341. 

  341. 			             html_tag("TD", "Flushing privileges", $color[0], "class=blacksmall align=left") .

    342. 

  342. 			           	 html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    343. 

  343. 					 "", "");

    344. 

  344. 		} else {

    345. 

  345. 			$inst .= html_tag("TR",

    346. 

  346. 			             html_tag("TD", "Flushing privileges", $color[0], "class=blacksmall align=left") .

    347. 

  347. 			           	 html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    348. 

  348. 					 "", "");

    349. 

  349. 		}

    350. 

  350. 	}

    351. 

  351. 

    352. 

  352. 	$db->clear_res();

    353. 

  353. 	$db->db = null;

    354. 

  354. 

    355. 

  355. 	if($_POST['INSTALL_MIDAS_SQL'] || $_POST['INSTALL_SNORT_SQL']) {

    356. 

  356. 		$db->run_query(sprintf("CREATE DATABASE IF NOT EXISTS %s", $_POST['DB']));

    357. 

  357. 		if($db->sqlResults) {

    358. 

  358. 			$inst .= html_tag("TR",

    359. 

  359. 			             html_tag("TD", "MIDAS dB created", $color[0], "class=blacksmall align=left") .

    360. 

  360. 			             html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    361. 

  361. 					 "", "");

    362. 

  362. 			$db->clear_res();

    363. 

  363. 			if($_POST['INSTALL_MIDAS_SQL']) {

    364. 

  364. 				if($SQL = parseSQL($_POST['MIDAS_SQL'])) {

    365. 

  365. 					$ERROR = FALSE;

    366. 

  366. 					$db->db = $_POST['DB'];

    367. 

  367. 					@reset($SQL);

    368. 

  368. 					while(!is_null($key = @key($SQL))) {

    369. 

  369. 						$db->run_query($SQL[$key]);

    370. 

  370. 						if(!$db->sqlResults) {

    371. 

  371. 							$ERROR = TRUE;

    372. 

  372. 						}

    373. 

  373. 						@next($SQL);

    374. 

  374. 					}

    375. 

  375. 					if($ERROR) {

    376. 

  376. 						$inst .= html_tag("TR",

    377. 

  377. 						             html_tag("TD", "MIDAS SQL Import", $color[0], "class=blacksmall align=left") .

    378. 

  378. 						             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    379. 

  379. 								 "", "");

    380. 

  380. 					} else {

    381. 

  381. 						$inst .= html_tag("TR",

    382. 

  382. 						             html_tag("TD", "MIDAS SQL Import", $color[0], "class=blacksmall align=left") .

    383. 

  383. 						             html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    384. 

  384. 								 "", "");

    385. 

  385. 					}

    386. 

  386. 				} else {

    387. 

  387. 					$inst .= html_tag("TR",

    388. 

  388. 					             html_tag("TD", "MIDAS SQL Import", $color[0], "class=blacksmall align=left") .

    389. 

  389. 					             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    390. 

  390. 							 "", "");

    391. 

  391. 				}

    392. 

  392. 			}

    393. 

  393. 

    394. 

  394. 			if($_POST['INSTALL_SNORT_SQL']) {

    395. 

  395. 				if($SQL = parseSQL($_POST['SNORT_SQL'])) {

    396. 

  396. 					$ERROR = FALSE;

    397. 

  397. 					$db->db = $_POST['DB'];

    398. 

  398. 					@reset($SQL);

    399. 

  399. 					while(!is_null($key = @key($SQL))) {

    400. 

  400. 						$db->run_query($SQL[$key]);

    401. 

  401. 						if(!$db->sqlResults) {

    402. 

  402. 							$ERROR = TRUE;

    403. 

  403. 						}

    404. 

  404. 						@next($SQL);

    405. 

  405. 					}

    406. 

  406. 					if($ERROR) {

    407. 

  407. 						$inst .= html_tag("TR",

    408. 

  408. 						             html_tag("TD", "SNORT SQL Import", $color[0], "class=blacksmall align=left") .

    409. 

  409. 						             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    410. 

  410. 								 "", "");

    411. 

  411. 					} else {

    412. 

  412. 						$inst .= html_tag("TR",

    413. 

  413. 						             html_tag("TD", "SNORT SQL Import", $color[0], "class=blacksmall align=left") .

    414. 

  414. 						             html_tag("TD", "OK", $color[12], "class=blacksmall align=center"),

    415. 

  415. 								 "", "");

    416. 

  416. 					}

    417. 

  417. 				} else {

    418. 

  418. 					$inst .= html_tag("TR",

    419. 

  419. 					             html_tag("TD", "SNORT SQL Import", $color[0], "class=blacksmall align=left") .

    420. 

  420. 					             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    421. 

  421. 							 "", "");

    422. 

  422. 				}

    423. 

  423. 			}

    424. 

  424. 		} else {

    425. 

  425. 			$inst .= html_tag("TR",

    426. 

  426. 			             html_tag("TD", "MIDAS dB created", $color[0], "class=blacksmall align=left") .

    427. 

  427. 			             html_tag("TD", "ERROR", $color[2], "class=blacksmall align=center"),

    428. 

  428. 					 "", "");

    429. 

  429. 		}

    430. 

  430. 	}

    431. 

  431. 

    432. 

  432. 	$info = html_tag("TABLE",

    433. 

  433. 	            html_tag("TR",

    434. 

  434. 	                html_tag("TD", "<b>Site Installation Results</b>", $color[9], "colspan=2 class=blacksmall align=center"),

    435. 

  435. 				"", "") .

    436. 

  436. 				$inst .

    437. 

  437. 				html_tag("TR",

    438. 

  438. 				    html_tag("TD", sprintf("Click <A HREF='../index.php'>here</A> to access the logon screen\n"),

    439. 

  439. 				        $color[12], "colspan=2 class=blacksmall align=center"),

    440. 

  440. 				"", ""),

    441. 

  441. 			$color[10], "width=50% cellspacing=1 cellpadding=1 align=center");

    442. 

  442. }

    443. 

  443. 

    444. 

  444. 	echo html_tag("TABLE",

    445. 

  445. 	        html_tag("TR",

    446. 

  446. 	            html_tag("TD",

    447. 

  447. 				sprintf("<SPAN class='titlelarge'>%s %s</SPAN><br><br>\n", _APPNAME, _VERSION), $color[4], "height=50 align=right valign=center"),

    448. 

  448. 	        "", "") .

    449. 

  449. 	        html_tag("TR",

    450. 

  450. 	            html_tag("TD", $info, $color[12], "width=100% height=100% align=center valign=center"),

    451. 

  451. 			"", ""),

    452. 

  452. 	    $color[10], "width=100% height=100% align=center valign=center");

    453. 

  453. 

    454. 

  454. printf("</BODY>\n");

    455. 

  455. printf("</HTML>\n");

    456. 

  456. ?>

    457. 

  457.