ICDBNavigator/setup.php at master · WallaceIT/ICDBNavigator · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title>ICDB Navigator - SETUP</title>
	<link rel="icon" type="image/ico" href="favicon.ico">
	<link rel="stylesheet" href="css/colorbox.css" />
	<script src="js/jquery.min.js" type="text/javascript" charset="utf-8"></script>
	<script src="js/jquery.colorbox-min.js" type="text/javascript" charset="utf-8"></script>
	<script src="js/jquery.qtip.min.js" type="text/javascript" charset="utf-8"></script>
	<script type="text/javascript" charset="utf-8">
	window.onload = function() {

		$('#tdMySQL').hide();

		$('.radio_setupDB_Type').change(function(){
			if ($('#radio_setupDB_Type_MySQL').is(':checked')) $('#tdMySQL').slideDown();
			else $('#tdMySQL').slideUp();
		});

	};
	</script>
	<style type="text/css">
		body {
	    background: url(../../images/metal.gif) repeat;
	    color: #000;
		}
		div#setupcontainer{
			width: 550px;
			border: dashed 1px #000000;
			margin: 30px auto;
			padding: 20px;
		}
		table#dbtable{
		width: 100%;
		border: 0px;
		margin: 0 auto;
		text-align: left;
		}
		table#dbtable td{
		padding: 10px;
		}
		div.center{
		text-align: center;
		}
	</style>
</head>
<body>
	<div id="setupcontainer">
<?php
if(!isset($_POST['gosetup'])){?>

		<div class="center"><p>ICDBNavigator SETUP</p></div>
		<hr>
		<form id="setupForm" action="setup.php" method="post">
			<table id="dbtable">
				<tr>
					<td><b>Select DB type:</b></td>
					<td></td>
				</tr>
				<tr>
					<td><input type="radio" class="radio_setupDB_Type" id="radio_setupDB_Type_MySQL" name="setupDB_Type" value="mysql"> MySQL</td>
					<td>
						<div id="tdMySQL">
							<input type="text" size="30" name="setupDB_MySQLHost" placeholder="MySQL Hostname"><br>
							<input type="text" size="30" name="setupDB_MySQLDBName" placeholder="MySQL Database Name"><br>
							<input type="text" size="30" name="setupDB_MySQLUser" placeholder="MySQL User"><br>
							<input type="password" size="30" name="setupDB_MySQLPassword" placeholder="MySQL Password"><br>
							<br>
							<input type="checkbox" name="setupDB_MySQLPopulated"> Database is already Populated
						</div>
					</td>
				</tr>
				<tr>
					<td><input type="radio" class="radio_setupDB_Type" name="setupDB_Type" value="sqlite" checked> SQLite</td>
					<td></td>
				</tr>
			</table>
			<hr><br>
			<b>Path to ICDBNavigator root folder</b><br>
			<input type="text" size="60" name="setupRootPath" value="<?php echo $_SERVER['DOCUMENT_ROOT'];?>"><br>
			<br><hr><br>
			<b>Other Options:</b>
			<br><br>
			<input type="checkbox" name="setupDownloadPdf" value="true"> Download Datasheets and Application Notes<br>
			<br>
			<input type="checkbox" name="setupMobilePdfOnly" value="true"> Show only the datasheets to mobile (cellphone) users<br>
			<br><hr><br>
			<input type="text" name="username" placeholder="Username..."><br>
			<input type="password" name="password" placeholder="Password...">
			<br><hr><br>
			<input type="hidden" name="gosetup" value="TRUE">
			<div class="center"><input type="submit" value="Install!"></div>
		</form>

<?php ;}
else{
	/*	SETUP:
	 *  - creates data directory
	 *  - creates config.php file
	 *  - creates the database
	 *  - creates data subdirectories
	 *  - creates default packages
	 *  - all DONE! :)
	 *
	 */

	// creating data directory...
	echo 'creating data directories...';
	//if(is_dir('data/pindescs')) exit(' data directories already exists, aborting!');
	if(!is_writable('.')) exit('ICDBN root not writable, please make manually a writable \'data\' directory into it and re-run this script!');

	if(!is_dir('data')) mkdir('data');

	echo '[OK]<br><br>';

	// writing config.php file...
	echo 'writing config.php file...';
	$file_contents = '<?php'.PHP_EOL;
	$file_contents .= "// path to ICDBNavigator root folder (in the filesystem)".PHP_EOL;
	$file_contents .= '$_CONFIG_ICDB_ROOT = "'.$_POST['setupRootPath'].'";'.PHP_EOL;
	$file_contents .= '// DB connection'.PHP_EOL;
	if($_POST['setupDB_Type'] == 'sqlite') $file_contents .= '$db = new PDO("sqlite:$_CONFIG_ICDB_ROOT/data/icdb.sqlite");'.PHP_EOL.'$_CONFIG_DB_USE_SQLITE = TRUE;'.PHP_EOL;
	elseif($_POST['setupDB_Type'] == 'mysql'){
		$file_contents .= '$db = new PDO(
			\'mysql:host='.$_POST['setupDB_MySQLHost'].';dbname='.$_POST['setupDB_MySQLDBName'].'\',
			\''.$_POST['setupDB_MySQLUser'].'\',
			\''.$_POST['setupDB_MySQLPassword'].'\',
			array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")
		);'.PHP_EOL.'$_CONFIG_DB_USE_SQLITE = FALSE;'.PHP_EOL;
	}
	$file_contents .= '// config'.PHP_EOL.PHP_EOL;
	$file_contents .= '/* $_CONFIG_PDFDOWNLOAD: TRUE to download datasheets and appnotes and save their URLs in the DB, FALSE to only save URLs in the DB */'.PHP_EOL;

	if(isset($_POST['setupDownloadPdf'])) $file_contents .= '$_CONFIG_PDFDOWNLOAD = TRUE;'.PHP_EOL;
	else $file_contents .= '$_CONFIG_PDFDOWNLOAD = FALSE;'.PHP_EOL;

	$file_contents .= '/* /* $_CONFIG_MOBILE_DATASHEET_ONLY: view only datasheet for the selected part on mobile */'.PHP_EOL;

	if(isset($_POST['setupMobilePdfOnly'])) $file_contents .= '$_CONFIG_MOBILE_DATASHEET_ONLY = TRUE;'.PHP_EOL;
	else $file_contents .= '$_CONFIG_MOBILE_DATASHEET_ONLY = FALSE;'.PHP_EOL;

	$file_contents .= '?>';

	file_put_contents('data/config.php', $file_contents);

	echo '[OK]<br><br>';

	// creating new database...
	echo 'creating new database...';
	include ('data/config.php');

	if(!$db) exit('<b>[FAILED!]</b>');

	if($_CONFIG_DB_USE_SQLITE || !isset($_POST["setupDB_MySQLPopulated"])){

		// table 'appnotes'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "appnotes" ("ID" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "name" TEXT NOT NULL , "description" TEXT NOT NULL , "url" TEXT)';
		else $sql = 'CREATE TABLE appnotes (ID INTEGER PRIMARY KEY  AUTO_INCREMENT  NOT NULL  UNIQUE , name TEXT NOT NULL , description TEXT NOT NULL , url TEXT)';
		$st = $db -> prepare($sql);
		$st -> execute();

		// table 'categories'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "categories" ("category" TEXT NOT NULL  UNIQUE )';
		else $sql = 'CREATE TABLE categories (ID INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE, category TEXT NOT NULL)';
		$st = $db -> prepare($sql);
		$st -> execute();
		$sql = "INSERT INTO categories (category) VALUES ('Miscellaneous')";
		$st = $db -> prepare($sql);
		$st -> execute();

		// table 'manufacturers'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "manufacturers" ("name" TEXT NOT NULL  UNIQUE , "website" TEXT)';
		else $sql = 'CREATE TABLE manufacturers (ID INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE, name TEXT NOT NULL, website TEXT)';
		$st = $db -> prepare($sql);
		$st -> execute();
		$sql = "INSERT INTO manufacturers (name) VALUES ('Various')";
		$st = $db -> prepare($sql);
		$st -> execute();

		// table 'packages'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "packages" ("pkgname" TEXT NOT NULL ,"pinsnum" INTEGER NOT NULL )';
		else $sql = 'CREATE TABLE packages (ID INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE, pkgname TEXT NOT NULL, pinsnum INTEGER NOT NULL )';
		$st = $db -> prepare($sql);
		$st -> execute();

		// table 'parts'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "parts" ("ID" INTEGER PRIMARY KEY  NOT NULL ,"name" TEXT NOT NULL ,"description" TEXT NOT NULL ,"manufacturer" TEXT NOT NULL ,"category" TEXT NOT NULL ,"appnotes" TEXT,"datasheeturl" TEXT,"package" TEXT NOT NULL ,"quantity" INTEGER NOT NULL ,"summary" TEXT)';
		else $sql = 'CREATE TABLE parts (ID INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL UNIQUE, name TEXT NOT NULL ,description TEXT NOT NULL ,manufacturer TEXT NOT NULL ,category TEXT NOT NULL ,appnotes TEXT,datasheeturl TEXT,package TEXT NOT NULL ,quantity INTEGER NOT NULL ,summary TEXT)';
		$st = $db -> prepare($sql);
		$st -> execute();

		// table 'login'
		if($_CONFIG_DB_USE_SQLITE) $sql = 'CREATE TABLE "login" ("ID" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , "username" TEXT NOT NULL  UNIQUE , "password" TEXT NOT NULL )';
		else $sql = 'CREATE TABLE login (ID INTEGER PRIMARY KEY  AUTO_INCREMENT  NOT NULL  UNIQUE , username TEXT NOT NULL  UNIQUE , password TEXT NOT NULL )';
		$st = $db -> prepare($sql);
		$st -> execute();
		$username = hash('sha224', $_POST['username']);
    		$password = hash('sha224', $_POST['password']);
		$sql = "INSERT INTO login (username,password) VALUES ('$username','$password')";
		$st = $db -> prepare($sql);
		$st -> execute();


		echo '[OK]<br><br>';
	}
	else echo 'Database already Existent and Populated, skipping creation...<br><br>';

	// creating data subdirectories...
	echo 'creating data subdirectories...';
	mkdir('data/appnotes');
	mkdir('data/datasheets');
	mkdir('data/logos');
	mkdir('data/packages');
	mkdir('data/pindescs');

	echo '[OK]<br><br>';

	// creating default packages...
	echo 'creating default packages...';
	$packagefolder = "data/packages/";
	include 'pages/pkggen/dipgen.php';
	include 'pages/pkggen/soicgen.php';
	include 'pages/pkggen/ssopgen.php';
	include 'pages/pkggen/qfpgen.php';
	include 'pages/pkggen/to92gen.php';
	include 'pages/pkggen/to220gen.php';
	include 'pages/pkggen/sot23gen.php';
	include 'pages/pkggen/othergen.php';

	echo '[OK]<br><br>';

	echo '<div class="center"><b>ICDBNavigator Installed!</b><br>(Please remove this file...)</div>';
	echo '<br><div class="center"><a href="index.php">Go to ICDBN Homepage</a></div>';

}
?>
	</div>
</body>
</html>