<html>
<head>
<title>Instalasi - Aplikasi Bengkel v2.0</title>
<link rel="shortcut icon" href="logo.jpg" type="image/x-icon"/>
<SCRIPT type="text/javascript" src="time.js"></SCRIPT>
<link href="css.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="noselect.js"></script>
<script type="text/javascript" src="disable.js"></script>
<script type="text/javascript">
      function loginf() {
        document.installasi.input_sn.focus();
    }
</script>
<style>
	body {
		top:10;
		left:0;
		right:0; 
		font: normal 14px helvetica, sans-serif; color: #FFF;	
	}
	#box1 {
		width:450px;
		text-align:left;
		FONT-WEIGHT:normal;
		font-size:14px;
		color:#419514;
		float:center;
		vertical-align:middle;
		/*position: fixed;*/
		padding:10px 20px 0px 20px;
		margin-top:10px;
		margin-left:15px;
		margin-right:15px;
		margin-bottom:0px;
		//margin:50px auto;
		//margin-left:350px;
		//margin-top:0px;
		//margin-bottom:5px;
		border-radius:7px;
		border:0px solid white;
		background-color:#fff;
		box-shadow:1px 1px 12px gray;
	}
</style>
</head>

<body ONLOAD="startTime(),loginf();">
<script type="text/javascript">disableSelection(document.body);</script>
<?php include('date.php');?>
<p style='float:left; color:#FFF; font-weight:bold; height:1px; vertical-align:middle; padding:5px auto;'><b><?php echo "$hari, $tgl $bln $thn";?> | <font id="txtjam"></font></b></p>
<BR><BR><BR><BR><BR>
<CENTER>
	<span style='font-size:20px;font-weight:bold;'>INSTALASI APLIKASI BENGKEL v2.0</span>

<?php
///$mycompid=exec('whoami');$mycompidexpl = explode('\\', $mycompid);$mycompid1=$mycompidexpl[0];$mycompid2=$mycompidexpl[1];$mycompidciper1=md5($mycompid1);$mycompid1a=strrev($mycompid1);$mycompid2a=strrev($mycompid2);$mycompidciper2=md5($mycompid2a);$myendchipper=$mycompidciper1.$mycompidciper2;$pcidmd5=strtoupper(md5($mycompid1a.$mycompid2a));
//match
///$codeidpc = strtolower('KOSWARA1482\Dedi Koswara');$codeidpc1 = explode('\\', $codeidpc);$codeidpc1a=strrev($codeidpc1[0]);$codeidpc1b=strrev($codeidpc1[1]);$code_idpc=strtoupper(md5($codeidpc1a.$codeidpc1b));
//$pcidmd52=strtoupper(md5('hadiwin81'));
///echo"<script>alert('pcname: $mycompid / $mycompid1$mycompid2 \\n chiper1: $pcidmd5 \\n chiper2: $code_idpc');</script>";
//echo "".strrev($mycompid1)."  ".strrev($mycompid2)."";
?>

<?php
if (isset($_POST['go_install'])){
//Config Koneksi DB
	// Establishing koneksi with Server by passing server_name, user_id and password as a parameter
	$koneksi = mysql_connect("localhost", "root", "") or die ('Error connecting to MySQL');;
	// Selecting Database
	$dbase="carwash2";
	$input_sn = strtoupper($_POST['input_sn']);$codeidpc=strtolower('KOSWARA1482\Dedi Koswara');$codeidpc1 = explode('\\', $codeidpc);$codeidpc1a=strrev($codeidpc1[0]);$codeidpc1b=strrev($codeidpc1[1]);$code_idpc=strtoupper(md5($codeidpc1a.$codeidpc1b));
	
	if ($code_idpc!=$input_sn){
		//echo"<br><br><br><br><br><br><center>Login Anda Salah !, Klik <a href='javascript:history.back(-1)'>Back</a> untuk login.</center>";
		//echo"<SCRIPT>alert(\"USERNAME & PASSWORD SALAH\");history.go(-1)</SCRIPT>";
		echo"<SCRIPT>window.location.href='install.php?err1=1&sn=$input_sn';</SCRIPT>"; //LOGIN SALAH
	}else {
		//KONEKSI DISPLAY RESULT
		echo"<div id='box1' style='color:#77B222; width:450px; text-align:left;'>";
			if ($koneksi) {
				//CREATE DB
				$q = "CREATE DATABASE IF NOT EXISTS $dbase";
				$r = mysql_query($q);
				echo"<br>#Koneksi ke server MySQL <b>BERHASIL</b> dibuat.";
				if ($q) {
					echo"<br>#Database <b>$dbase</b> berhasil dibuat.";
					}
				//Koneksi ke DB yg baru dibuat
				$dblink = mysql_select_db($dbase, $koneksi) or die ("Database tidak konek!");
				if ($dblink) {
					echo"<br>#Koneksi ke Database <b>$dbase</b> BERHASIL.";
				}
			}
			echo"<BR><BR>";

//buat table
$q1="CREATE TABLE IF NOT EXISTS `biaya_srv` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `id` varchar(6) NOT NULL DEFAULT '',
  `tgl_input` date NOT NULL DEFAULT '0000-00-00',
  `jam_input` time NOT NULL DEFAULT '00:00:00',
  `waktu_update` datetime DEFAULT NULL,
  `nama` varchar(40) NOT NULL DEFAULT '',
  `hrg` int(13) NOT NULL DEFAULT '0',
  `diskon` tinyint(3) NOT NULL DEFAULT '0',
  `inputer` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;";
$r1=mysql_query($q1) or die('sql1 error:'.mysql_error());


$q2="CREATE TABLE IF NOT EXISTS `gaji_krywn` (
  `no` int(4) NOT NULL AUTO_INCREMENT,
  `id` varchar(20) NOT NULL,
  `nama_krywn` varchar(30) NOT NULL,
  `bulan` date NOT NULL,
  `tgl_input` date NOT NULL,
  `tgl_update` date NOT NULL,
  `gaji_pokok` int(6) NOT NULL,
  `lainnya` varchar(200) NOT NULL,
  `subtotal` int(7) NOT NULL,
  `officer` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;";
$r2=mysql_query($q2) or die('sql2 error:'.mysql_error());

$q3="CREATE TABLE IF NOT EXISTS `jenis_spl` (
  `no` int(2) NOT NULL AUTO_INCREMENT,
  `jenis_brg` varchar(20) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;";
$r3=mysql_query($q3) or die('sql3 error:'.mysql_error());

$q4="CREATE TABLE IF NOT EXISTS `konsumen` (
  `no` int(8) NOT NULL AUTO_INCREMENT,
  `id` varchar(10) NOT NULL DEFAULT '',
  `tgl_reg` varchar(20) NOT NULL DEFAULT '' COMMENT 'tgl_jam',
  `nopol` varchar(10) NOT NULL DEFAULT '',
  `pemilik` varchar(40) NOT NULL DEFAULT '',
  `alamat` varchar(60) NOT NULL DEFAULT '',
  `kota` varchar(30) NOT NULL,
  `provinsi` varchar(30) NOT NULL,
  `no_hp` varchar(20) NOT NULL DEFAULT '',
  `merk` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(60) NOT NULL DEFAULT '',
  `thn` varchar(4) NOT NULL DEFAULT '',
  `silinder` int(3) NOT NULL DEFAULT '0',
  `no_mesin` varchar(20) NOT NULL DEFAULT '',
  `officer` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;";
$r4=mysql_query($q4) or die('sql4 error:'.mysql_error());

$q5="CREATE TABLE IF NOT EXISTS `krywn` (
  `no` int(8) NOT NULL AUTO_INCREMENT,
  `id` varchar(20) NOT NULL DEFAULT '',
  `tgl_input` varchar(20) NOT NULL DEFAULT '' COMMENT 'tgl_jam',
  `tgl_update` varchar(20) NOT NULL COMMENT 'tgl_jam',
  `tgl_masuk` date NOT NULL,
  `nama_lengkap` varchar(30) NOT NULL,
  `alamat` varchar(100) NOT NULL DEFAULT '',
  `no_hp` varchar(20) NOT NULL DEFAULT '',
  `jabatan` varchar(20) NOT NULL,
  `officer` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;";
$r5=mysql_query($q5) or die('sql5 error:'.mysql_error());

$q6="CREATE TABLE IF NOT EXISTS `login` (
  `no` tinyint(2) NOT NULL AUTO_INCREMENT,
  `username` varchar(20) NOT NULL DEFAULT '',
  `password` varchar(20) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL,
  `time_reg` varchar(20) NOT NULL,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  `waktu_masuk` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `waktu_keluar` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ip_address` varchar(32) NOT NULL DEFAULT '',
  `timelog` varchar(20) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;";
$r6=mysql_query($q6) or die('sql6 error:'.mysql_error());

$q7="CREATE TABLE IF NOT EXISTS `logs` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `menu` varchar(20) NOT NULL DEFAULT '',
  `rincian` varchar(250) NOT NULL DEFAULT '',
  `aksi` varchar(30) NOT NULL DEFAULT '',
  `officer` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=76 ;";
$r7=mysql_query($q7) or die('sql7 error:'.mysql_error());

$q8="CREATE TABLE IF NOT EXISTS `pembelian` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(10) NOT NULL DEFAULT '',
  `no_faktur` varchar(30) NOT NULL,
  `tgl_faktur` date NOT NULL,
  `sis_byr` varchar(20) NOT NULL,
  `tgl_jth_tmp` date NOT NULL,
  `salesman` varchar(30) NOT NULL,
  `barcode` varchar(20) NOT NULL,
  `kode_brg` varchar(8) NOT NULL DEFAULT '',
  `waktu` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `waktu_update` varchar(20) NOT NULL,
  `nama_barang` varchar(100) NOT NULL DEFAULT '',
  `satuan_brg` varchar(15) NOT NULL DEFAULT '0',
  `jenis` varchar(20) NOT NULL DEFAULT '0',
  `suplier` varchar(30) NOT NULL DEFAULT '0',
  `kode_suplier` varchar(20) NOT NULL DEFAULT '',
  `alamat_suplier` varchar(150) NOT NULL,
  `harga_beli` int(12) NOT NULL DEFAULT '0',
  `qty_awal` int(6) NOT NULL DEFAULT '0',
  `qty_add` int(4) NOT NULL DEFAULT '0',
  `subtotal` int(12) NOT NULL DEFAULT '0',
  `ttl_diskon` int(9) NOT NULL,
  `ttl_dpp` int(9) NOT NULL,
  `ttl_ppn` int(9) NOT NULL,
  `ttl_nett` int(9) NOT NULL,
  `user` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;";
$r8=mysql_query($q8) or die('sql8 error:'.mysql_error());

$q9="CREATE TABLE IF NOT EXISTS `penjualan` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `token` int(4) NOT NULL DEFAULT '0',
  `invoice` varchar(11) NOT NULL DEFAULT '',
  `tgl` varchar(10) NOT NULL DEFAULT '',
  `jam` time NOT NULL DEFAULT '00:00:00',
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `barcode` varchar(20) NOT NULL,
  `nama_brg` varchar(40) NOT NULL DEFAULT '',
  `satuan` varchar(20) NOT NULL DEFAULT '',
  `hrg_satuan` int(13) NOT NULL DEFAULT '0',
  `jml` int(3) NOT NULL DEFAULT '0',
  `diskon` int(6) NOT NULL DEFAULT '0',
  `persen_disc` int(2) NOT NULL,
  `disc_sale` int(6) NOT NULL,
  `subtotal` int(13) NOT NULL DEFAULT '0',
  `bayar` int(6) NOT NULL DEFAULT '0',
  `kasir` varchar(30) NOT NULL DEFAULT '',
  `nama_pembeli` varchar(50) NOT NULL,
  `alamat_pembeli` varchar(150) NOT NULL,
  `hp_pembeli` varchar(20) NOT NULL,
  `retur` tinyint(4) NOT NULL,
  `waktu_retur` varchar(20) NOT NULL,
  `kasir_retur` varchar(25) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;";
$r9=mysql_query($q9) or die('sql9 error:'.mysql_error());

$q10="CREATE TABLE IF NOT EXISTS `produsen_brg` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `produsen` varchar(30) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;";
$r10=mysql_query($q10) or die('sql10 error:'.mysql_error());

$q11="CREATE TABLE IF NOT EXISTS `retur` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `token` int(4) NOT NULL DEFAULT '0',
  `invoice` varchar(11) NOT NULL DEFAULT '',
  `tgl` varchar(10) NOT NULL DEFAULT '',
  `jam` time NOT NULL DEFAULT '00:00:00',
  `waktu_retur` varchar(40) NOT NULL,
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `barcode` varchar(20) NOT NULL,
  `nama_brg` varchar(40) NOT NULL DEFAULT '',
  `satuan` varchar(20) NOT NULL DEFAULT '',
  `hrg_satuan` int(13) NOT NULL DEFAULT '0',
  `jml` int(3) NOT NULL DEFAULT '0',
  `diskon` int(6) NOT NULL DEFAULT '0',
  `subtotal` int(13) NOT NULL DEFAULT '0',
  `kasir_jual` varchar(30) NOT NULL DEFAULT '',
  `kasir_retur` varchar(30) NOT NULL DEFAULT '',
  `nama_pembeli` varchar(50) NOT NULL,
  `alamat_pembeli` varchar(150) NOT NULL,
  `hp_pembeli` varchar(20) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;";
$r11=mysql_query($q11) or die('sql11 error:'.mysql_error());

$q12="CREATE TABLE IF NOT EXISTS `service` (
  `no` int(6) NOT NULL AUTO_INCREMENT,
  `id` varchar(12) NOT NULL DEFAULT '',
  `nopol` varchar(11) NOT NULL,
  `no_kwitansi` varchar(10) NOT NULL DEFAULT '',
  `hari` varchar(10) NOT NULL DEFAULT '',
  `tgl` varchar(10) NOT NULL DEFAULT '',
  `jam` time NOT NULL DEFAULT '00:00:00',
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `nama_brg` varchar(40) NOT NULL DEFAULT '',
  `hrg_satuan` int(13) NOT NULL DEFAULT '0',
  `jml` int(3) NOT NULL DEFAULT '0',
  `diskon` int(6) NOT NULL DEFAULT '0',
  `subtotal` int(13) NOT NULL DEFAULT '0',
  `bayar` int(9) NOT NULL DEFAULT '0',
  `jam_selesai` varchar(8) NOT NULL DEFAULT '00:00:00',
  `mekanik` varchar(60) NOT NULL,
  `officer` varchar(30) NOT NULL DEFAULT '',
  `keluhan` varchar(100) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;";
$r12=mysql_query($q12) or die('sql12 error:'.mysql_error());


$q13="CREATE TABLE IF NOT EXISTS `sparepart` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `barcode` varchar(20) NOT NULL,
  `id_brg` varchar(10) NOT NULL DEFAULT '',
  `tgl_input` date NOT NULL DEFAULT '0000-00-00',
  `jam_input` time NOT NULL DEFAULT '00:00:00',
  `waktu_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `nama_brg` varchar(50) NOT NULL DEFAULT '',
  `kode_suplier` varchar(8) NOT NULL DEFAULT '',
  `nama_suplier` varchar(40) NOT NULL DEFAULT '',
  `stok` int(4) NOT NULL DEFAULT '0',
  `min_stok` int(3) NOT NULL DEFAULT '0',
  `satuan` varchar(30) NOT NULL DEFAULT '',
  `hrg_beli` int(13) NOT NULL DEFAULT '0',
  `hrg_jual` int(13) NOT NULL DEFAULT '0',
  `diskon` tinyint(3) NOT NULL DEFAULT '0',
  `jenis` varchar(30) NOT NULL DEFAULT '',
  `produsen` varchar(30) NOT NULL,
  `inputer` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;";
$r13=mysql_query($q13) or die('sql13 error:'.mysql_error());


$q14="CREATE TABLE IF NOT EXISTS `suplier` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `id_suplier` varchar(8) NOT NULL DEFAULT '',
  `tgl_reg` date NOT NULL DEFAULT '0000-00-00',
  `nama` varchar(50) NOT NULL DEFAULT '',
  `alamat` varchar(100) NOT NULL DEFAULT '',
  `cp` varchar(30) NOT NULL DEFAULT '',
  `telp` varchar(30) NOT NULL DEFAULT '',
  `jenis` varchar(30) NOT NULL DEFAULT '',
  `type_spl` varchar(60) NOT NULL,
  `inputer` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;";
$r14=mysql_query($q14) or die('sql14 error:'.mysql_error());

$q15="CREATE TABLE IF NOT EXISTS `transaksi` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `kode` varchar(6) NOT NULL DEFAULT '',
  `tgl` date NOT NULL DEFAULT '0000-00-00',
  `jam` time NOT NULL,
  `nama_tr` varchar(100) NOT NULL DEFAULT '',
  `jenis_tr` varchar(100) NOT NULL DEFAULT '',
  `alokasi_tr` varchar(100) NOT NULL DEFAULT '',
  `nominal` int(12) NOT NULL DEFAULT '0',
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;";
$r15=mysql_query($q15) or die('sql15 error:'.mysql_error());

$q16="CREATE TABLE IF NOT EXISTS `type_spl` (
  `no` int(3) NOT NULL AUTO_INCREMENT,
  `tipe_spl` varchar(60) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
$r16=mysql_query($q16) or die('sql16 error:'.mysql_error());


$q16="CREATE TABLE IF NOT EXISTS `appcode` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `codemyapps` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;";
$r16=mysql_query($q16) or die('sql16 error:'.mysql_error());
$mycompid=exec('whoami');
$mycompidexpl = explode('\\', $mycompid);
$mycompid1=$mycompidexpl[0];
$mycompid2=$mycompidexpl[1];
$mycompidciper1=md5($mycompid1);
$mycompid2a=strrev($mycompid2);
$mycompidciper2=md5($mycompid2a);
$myendchipper=$mycompidciper1.$mycompidciper2;
$q16a="INSERT INTO appcode VALUES ('1', '$myendchipper');";
$r16a=mysql_query($q16a) or die('sql16a error:'.mysql_error());

$q1a="INSERT INTO `login` (`no`, `username`, `password`, `email`, `time_reg`, `admin`, `waktu_masuk`, `waktu_keluar`, `ip_address`, `timelog`, `status`)
VALUES(1, 'admin', 'admin', '', '2018-05-01 10:08:01', '1', '', '', '', '', '', 'admin');";
$r1a=mysql_query($q1a) or die('q1a error:'.mysql_error());

$q1b="INSERT INTO `setting` (`nama_bengkel`, `alamat`, `tlp`, `manager`) VALUES
('Bengkel Motor XXX', 'Jl. RAYA XXX NO.123 BANDUNG', '(022) 8452012', 'Pak Manager');";
$r1b=mysql_query($q1b) or die('sq1b error:'.mysql_error());

//RESULT REPORT
$i=0;
$table=array("biaya_srv", "gaji_krywn","jenis_spl","konsumen","krywn","login","logs","pembelian","penjualan","produsen_brg","retur","service","setting","sparepart","suplier","transaksi","appcode");
foreach ($table as $tblbengkel) {
	$i++;
	if ($q[$i]) {
		echo"<br>$i. Tabel <b>$tblbengkel</b> SUKSES dibuat.";
	}else {
		echo"<br>$i. Tabel <b>$tblbengkel</b> sudah ADA.";
	}
}
//echo"<br><i>Your App Code is: <b>$myendchipper</b><i>.<br>";
echo"<br><br><br><center><a href='http://localhost/bengkel-v2/'>Go to Aplication</a></center><br><br>";
echo"<script>setTimeout(\"window.location='http://localhost/bengkel-v2'\",30000);</script>";
echo"</div>";	
	}//End Else sukses	
}else{	
?>
<!-- BORDER FRAME -->
<table width='35%' align='center' border='0' cellSpacing='0' cellPadding='0'>
										<tr>
											<td width='1%'><img src='frame_01.png'></td>
											<td width='100%' background='frame_02.png'></td>
											<td width='1%'><img src='frame_03.png'></td>
										</tr>
										<tr>
											<td height=100% background='frame_04.png'></td>
											<td colspan='1' background='frame_05.png'>
											
<TABLE align='center' style="no-repeat center center fixed; background-size: cover;" background='topgradient.jpg' border='0' WIDTH='100%' CELLPADDING='5' CELLSPACING='0'>
  <tr><td align='center' bgcolor='#156EF4' style="font-family:verdana; font-size:16px;color:#FFF;font-weight:bold;">Masukan S/N Instalasi:</td></tr>
  	<TR>
		<td align='center'>
			<BR>
			<form name='installasi' method='POST' align='center' action='' autocomplte='off'>
			<table border='0' width='100%' cellpadding='0' cellspacing='0'>
				<tr><td align='center' width='100%'>
					<table border='0' width='100%' cellpadding='1' cellspacing='1'>
							<?php
								$err1=$_GET['err1'];
								$ersn=$_GET['sn'];
								if ($err1 == 1){
									echo"<tr height='25'><td colspan='3' align='center'><font color='#F10A11' size='3'><b>Serial Number Salah!</b></font></td></tr>";
									//echo"<script>setTimeout('window.history.back()', 2000);</script>";
								}
							?>
							<tr>
								<td width='15%' valign='center' align='right'><img src='lock.png' width='30' height='30'></td>
								<td width='65%'><input TYPE='text' style='width:100%;text-align:center;' NAME='input_sn' maxlength='32' placeholder='SN: 32 CHARS' autocomplete='off' value='<?php echo $ersn;?>'></td>
								<td width='15%' align='left'><input type='submit' style='padding:4px;width:AUTO;' value='GO' name='go_install' class='btn'></td>
							</tr>
					</table>
				</td></tr>
			</table>
			</form>
		</td>
 </TR>
 <tr bgcolor='#4D91F7'><td></td></tr>
	<tr bgcolor='#156EF4'><td align=center>
	<font size='1' color='white'>Copyright&copy; 2017 - <?php echo date('Y');?> - Jahada Media Informatika.  All Rights Reserved.</font><br>
	<!--<a href="" rel="sidebar" onclick="if(document.all && !window.opera){ window.external.AddFavorite(location.href, document.title);return false; }else{ this.title = document.title; }" title="bookmark this page">Bookmark This Page!</a><br>
	-->
	</td></tr>
 </TABLE> 
 <!-- END TABEL BORDER ALL CONTENT-->
</td>
										<td background='frame_06.png'></td>
									</tr>
									<tr>
										<td width='1'><img src=frame_07.png></td>
										<td width='100%' background='frame_08.png'></td>
										<td><img src='frame_09.png'></td>
									</tr>
</table>
<?php } ?>

</CENTER>
</body>
</html>