<?
#Main Database
$maintablessql	= array ();
#user
$deftab = "
	`user_pass` varchar(64) NOT NULL default '',
	`user_realname` varchar(80)  NOT NULL default '',
	`user_nicename` varchar(50) NOT NULL default '',
	`user_photo` varchar(64) NOT NULL default '',
	`user_email` varchar(100) NOT NULL default '',
	`user_renewpass` INT(1) NOT NULL default '1',
	`user_renewpcode` varchar(64) NOT NULL default '',
	`user_multilogin` INT(1) NOT NULL default '2',
	`user_privilid` INT(11) UNSIGNED NOT NULL default 0,
	`user_status` INT(1) NOT NULL default '3',
	`user_cid` INT(11) UNSIGNED NOT NULL default 0,
	`user_cdate` DATETIME NULL default NULL,
	`user_cip` varchar(31) NOT NULL default '',
	`user_uid` INT(11) UNSIGNED NOT NULL default 0,
	`user_udate` DATETIME NULL default NULL,
	`user_uip` varchar(31) NOT NULL default '',
	`user_hiscol` TEXT,
";
// additional user for deftab
$deftab .= "
";
$maintablessql["user"] = "
CREATE TABLE `".$table_prefix."user` (
	`user_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`user_login` varchar(20) UNIQUE,
	$deftab
	PRIMARY KEY  (`user_id`)
) ENGINE=INNODB character set utf8;
";
$maintablessql["userhistory"] = "
CREATE TABLE `".$table_prefix."userhistory` (
	`userhistory_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`user_id` INT(11) UNSIGNED NOT NULL,
	`user_login` varchar(20) NOT NULL default '',
	$deftab
	PRIMARY KEY  (`userhistory_id`)
) ENGINE=INNODB character set utf8;
";
#privil
$deftab = "
	`privil_sort` INT(3) UNSIGNED NOT NULL default 0,
	`privil_name` varchar(50)  NOT NULL default '',
	`privil_val` TEXT,
	`privil_status` INT(1) UNSIGNED NOT NULL default 3,
	`privil_cid` INT(11) UNSIGNED NOT NULL default 0,
	`privil_cdate` DATETIME NULL default NULL,
	`privil_cip` VARCHAR(31)  NOT NULL default '',
	`privil_uid` INT(11) UNSIGNED NOT NULL default 0,
	`privil_udate` DATETIME NULL default NULL,
	`privil_uip` VARCHAR(31)  NOT NULL default '',
	`privil_hiscol` TEXT,
";
$maintablessql["privil"] = "
CREATE TABLE `".$table_prefix."privil` (
	`privil_id` INT(11) UNSIGNED NOT NULL auto_increment,
	$deftab
	PRIMARY KEY  (`privil_id`)
) ENGINE=INNODB character set utf8;		 
";
$maintablessql["privilhistory"] = "
CREATE TABLE `".$table_prefix."privilhistory` (
	`privilhistory_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`privil_id` INT(11) UNSIGNED NOT NULL,
	$deftab
	PRIMARY KEY  (`privilhistory_id`)
) ENGINE=INNODB character set utf8;		 
";
#userloginhis
$maintablessql["userloginhis"] = "
CREATE TABLE `".$table_prefix."userloginhis` (
	`userloginhis_id` INT(11) NOT NULL auto_increment,
	`userloginhis_userid` INT(11) NOT NULL default '0',
	`userloginhis_ip` varchar(31) NOT NULL default '',
	`userloginhis_agent` varchar(255) NOT NULL default '',
	`userloginhis_sid` varchar(32) NOT NULL default '',
	`userloginhis_inout` INT(1) NOT NULL default '0',
	`userloginhis_intime` DATETIME NULL default NULL,
	`userloginhis_lasttime` DATETIME NULL default NULL,
	PRIMARY KEY  (`userloginhis_id`)
) ENGINE=INNODB character set utf8;
";
#var
$deftab = "
	`var_group` varchar(10) NOT NULL default '',
	`var_value` TEXT,
	`var_uid` INT(11) UNSIGNED NOT NULL default 0,
	`var_udate` DATETIME NULL default NULL,
	`var_uip` varchar(31) NOT NULL default '',
	`var_hiscol` TEXT,
";
#
$maintablessql["var"] = "
CREATE TABLE `".$table_prefix."var` (
	`var_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`var_name` varchar(255) NOT NULL UNIQUE,
	$deftab
	PRIMARY KEY  (`var_id`)
) ENGINE=INNODB character set utf8;
";
$maintablessql["varhistory"] = "
CREATE TABLE `".$table_prefix."varhistory` (
	`varhistory_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`var_id` INT(11) UNSIGNED NOT NULL,
	`var_name` varchar(255) NOT NULL,
	$deftab
	PRIMARY KEY  (`varhistory_id`)
) ENGINE=INNODB character set utf8;
";
#uscook
$deftab = "
	`uscook_userid` INT(11) UNSIGNED NOT NULL,
	`uscook_varname` varchar(64) NOT NULL default '',
	`uscook_varvalue` TEXT,
";
$maintablessql["uscook"] = "
CREATE TABLE `".$table_prefix."uscook` (
	`uscook_id` INT(11) UNSIGNED NOT NULL auto_increment,
	$deftab
	PRIMARY KEY  (`uscook_id`)
) ENGINE=INNODB character set utf8;
";
#akey
$deftab = "
	`akey_name` varchar(50)  NOT NULL default '',
	`akey_val` varchar(64)  NULL default NULL,
	`akey_chipher` varchar(64)  NULL default NULL,
	`akey_defval` TEXT,
	`akey_dodecrypt` ENUM('1','0') NOT NULL DEFAULT '1',
	`akey_doencrypt` ENUM('1','0') NOT NULL DEFAULT '1',
	`akey_status` INT(1) UNSIGNED NOT NULL default 3,
	`akey_cid` INT(11) UNSIGNED NOT NULL default 0,
	`akey_cdate` DATETIME NULL default NULL,
	`akey_cip` VARCHAR(31)  NOT NULL default '',
	`akey_uid` INT(11) UNSIGNED NOT NULL default 0,
	`akey_udate` DATETIME NULL default NULL,
	`akey_uip` VARCHAR(31)  NOT NULL default '',
	`akey_hiscol` TEXT,
";
$maintablessql["akey"] = "
CREATE TABLE `".$table_prefix."akey` (
	`akey_id` INT(11) UNSIGNED NOT NULL auto_increment,
	$deftab
	PRIMARY KEY  (`akey_id`)
) ENGINE=INNODB character set utf8;		 
";
$maintablessql["akeyhistory"] = "
CREATE TABLE `".$table_prefix."akeyhistory` (
	`akeyhistory_id` INT(11) UNSIGNED NOT NULL auto_increment,
	`akey_id` INT(11) UNSIGNED NOT NULL,
	$deftab
	PRIMARY KEY  (`akeyhistory_id`)
) ENGINE=INNODB character set utf8;		 
";
#alog
$deftab = "
	`alog_url` TEXT,
	`alog_token` varchar(64) NOT NULL default '',
	`alog_agent` varchar(255) NOT NULL default '',
	`alog_method` varchar(10) NOT NULL default '',
	`alog_akeyid` INT(11) UNSIGNED NOT NULL,
	`alog_sid` varchar(32) NOT NULL default '',
	`alog_auth` TEXT,
	`alog_get` TEXT,
	`alog_post` TEXT,
	`alog_cdate` DATETIME NULL default NULL,
	`alog_cip` VARCHAR(31)  NOT NULL default '',
";
$maintablessql["alog"] = "
CREATE TABLE `".$table_prefix."alog` (
	`alog_id` BIGINT(20) UNSIGNED NOT NULL auto_increment,
	$deftab
	PRIMARY KEY  (`alog_id`)
) ENGINE=INNODB character set utf8;		 
";
#---------- End Main Tables SQL
?><!DOCTYPE html>
<html lang="en">

	<!-- begin::Head -->
	<head>
		<meta charset="utf-8" />
		<title>Login</title>
		<meta name="description" content="Latest updates and statistic charts">
		<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

		<!--begin::Page Vendors Styles(used by this page) -->
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/custom/fullcalendar/fullcalendar.bundle.css" rel="stylesheet" type="text/css" />

		<!--end::Page Vendors Styles -->

		<!--begin:: Global Mandatory Vendors -->
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/perfect-scrollbar/css/perfect-scrollbar.css" rel="stylesheet" type="text/css" />

		<!--end:: Global Mandatory Vendors -->

		<!--begin:: Global Optional Vendors -->
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/tether/dist/css/tether.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-datepicker/dist/css/bootstrap-datepicker3.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-datetime-picker/css/bootstrap-datetimepicker.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-timepicker/css/bootstrap-timepicker.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-select/dist/css/bootstrap-select.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-switch/dist/css/bootstrap3/bootstrap-switch.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/select2/dist/css/select2.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/ion-rangeslider/css/ion.rangeSlider.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/nouislider/distribute/nouislider.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/owl.carousel/dist/assets/owl.carousel.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/owl.carousel/dist/assets/owl.theme.default.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/dropzone/dist/dropzone.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/summernote/dist/summernote.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/bootstrap-markdown/css/bootstrap-markdown.min.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/animate.css/animate.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/toastr/build/toastr.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/morris.js/morris.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/sweetalert2/dist/sweetalert2.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/socicon/css/socicon.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/custom/vendors/line-awesome/css/line-awesome.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/custom/vendors/flaticon/flaticon.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/custom/vendors/flaticon2/flaticon.css" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/custom/vendors/fontawesome5/css/all.min.css" rel="stylesheet" type="text/css" />

		<!--end:: Global Optional Vendors -->

		<!--begin::Layout Skins(used by all pages) -->

		<!--end::Layout Skins -->
		<link rel="shortcut icon" href="https://amalku.lawu.adythree.web.id/amalku/dd.tpl/default/images/logo.png?v.1.0.2" />
		<? if (isset($ddvar["appsfavicon"]) AND $ddvar["appsfavicon"] AND file_exists(UPLPATH.$ddvar["appsfavicon"])) { ?><link id="iconfav" rel="shortcut icon" href="https://amalku.lawu.adythree.web.id/amalku/upload/appsfavicon_20191020205412.png?v.1.0.2" /><?}?>
		
		<script src="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/jquery/dist/jquery.js" type="text/javascript"></script>
		<script src="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/fineupload/jquery.fineuploader-3.1.1.min.js"></script>
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.assets/vendors/general/fineupload/fineuploader.min.css" rel="stylesheet">
		<!-- jqAlert -->
		<link rel='stylesheet' href='https://amalku.lawu.adythree.web.id/amalku/dd.js/jalert/jAlert.min.css?v.1.0.2'>
		<script src='https://amalku.lawu.adythree.web.id/amalku/dd.js/jalert/jAlert.min.js?v.1.0.2'></script>
		<script src='https://amalku.lawu.adythree.web.id/amalku/dd.js/jalert/jAlert-functions.min.js?v.1.0.2'></script>
		<!-- autoNumeric -->
		<script type="text/javascript" src="https://amalku.lawu.adythree.web.id/amalku/dd.js/autonumeric/autoNumeric-min.js?v.1.0.2"></script>
		<? html_jqueryui(); ?>
		<!--begin::Global Theme Styles(used by all pages) -->
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.tpl/default/images/style.bundle.css?v.1.0.2" rel="stylesheet" type="text/css" />
		<link href="https://amalku.lawu.adythree.web.id/amalku/dd.tpl/default/images/dd.css?v.1.0.2" rel="stylesheet" type="text/css" />
		<!--end::Global Theme Styles -->

		<script>
		var lastfocusformsubmit;
		var lastformval = [];
		var jAlertshowAnimation = 'fadeInLeft';
		var jAlerthideAnimation = 'fadeOutRight';
		var jax_sending = 'Harap Menunggu, Terdapat Proses Input yang sedang berjalan.';
		var jax_errornull = 'Error Return null';
		var global_noaccess = 'Anda tidak diperkenankan untuk Mengakses Modul ini.';
		var jax_errorjson = 'Error Return JSON';
		var jax_errorstatus = 'Error Return Status';
		var global_delmsg = ' Anda Yakin akan menghapus data ini ?';
		var global_ok = 'Ya';
		var global_cancel = 'Tidak';
		var global_submitmsg = 'Anda Yakin Submit Data Berikut ?';
		var global_lofotimeout = 'Form di Lock Timeout, Tambah Waktu ?';
		var global_openform = 'Anda Yakin Akan Membuka Form ';
		var global_htmlnooption = ' Pilihan tidak ditemukan';
		var global_inputempty = ' harus di isi';
		var global_datasame = 'Tidak ada Perubahan Data';
		var defdd = 'https://amalku.lawu.adythree.web.id/profil/';
		var dd_jsdefyear = <? if (!isset($dd_jsdefyear)) { ?>false;<?} else {?>2019;<?}?>
		var dd_jsnowyear = 2026;
		var global_sadd = 'Sukses Menambah Data.';
		var global_sedit = 'Sukses Mengubah Data';
		var global_sdelete = 'Sukses Menghapus Data.';
		var global_dataexists = ' Data Sudah Ada';
		</script>
	</head>
	<body class="kt-header--fixed kt-header-mobile--fixed kt-subheader--enabled kt-subheader--transparent kt-aside--enabled kt-aside--fixed kt-aside--minimize kt-page--loading"><style>
.appicon {
	width:50px;
	margin-bottom:15px;
}
.kt-widget1 {
	text-align:center;
	padding:25px 0px;
}
.kt-widget1--botop  {
	border-top:1px solid #ededed;
}
</style>
<link href="https://amalku.lawu.adythree.web.id/amalku/dd.tpl/default/images/login-3.css" rel="stylesheet" type="text/css" />
<div class="kt-grid kt-grid--ver kt-grid--root kt-page">
	<div class="kt-grid kt-grid--hor kt-grid--root  kt-login kt-login--v3 kt-login--signin" id="kt_login">
		<div class="kt-grid__item kt-grid__item--fluid kt-grid kt-grid--hor">
			<div class="kt-grid__item kt-grid__item--fluid kt-login__wrapper">
				<div class="kt-login__container">
					<div class="kt-login__logo">
							<a href="#">
																<img src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-profil.png?v.1.0.2" style="width:100px;" />							</a>
					</div>
					<div class="kt-login__signin">
																		<form class="kt-form" method="post" action="./" name="ddf_install" id="ddf_install">
							<div class="kt-portlet">
								<div class="kt-portlet__head">
										<div style="display:block;width:100%;padding:20px;text-align:center;">
										<h1><b>PROFIL KELURAHAN</span></h1>
										</div>
								</div>
								<div class="kt-portlet__body">
									<div class="kt-section kt-section--first">
																														<div class="form-group">
											<input class="form-control" type="text" placeholder="Username" value="<?isset($_POST["adminuser"]) ? $_POST["adminuser"] : "";?>" id="adminuser" name="adminuser" autocomplete="off">
										</div>
										<div class="form-group">
											<input class="form-control" type="password" placeholder="Password" id="password1" name="adminpass1">
										</div>
										<div class="kt-login__actions">
											<button id="kt_dbinstall_submit" class="btn btn-brand btn-elevate kt-login__btn-primary wi100">Submit</button>
										</div>
									</div>
								</div>
							</div>
							<input type="hidden" value="gologin" name="go">
						</form>
					</div>
				</div>
				<div style="text-align:center;padding:25px;color:#c12326;"><h5><a href="https://amalku.lawu.adythree.web.id/">Aplikasi Manajemen Layanan Kelurahan</a></h5></div>
				<div class="kt-portlet">
					<div class="kt-portlet__body kt-portlet__body--fit">
<div class="row row-no-padding row-col-separator-xl kt-widget1--botop">							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/musrenbang"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-musrenbang.png" />
									<h6>MUSRENBANG KELURAHAN</h6></a>
								</div>
							</div>
							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/profil"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-profil.png" />
									<h6>PROFIL KELURAHAN</h6></a>
								</div>
							</div>
</div><div class="row row-no-padding row-col-separator-xl kt-widget1--botop">							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/basisdata"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-bdt.png" />
									<h6>BASIS DATA KESEJAHTERAAN SOSIAL KELURAHAN</h6></a>
								</div>
							</div>
							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/surat"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-surat.png" />
									<h6>SURAT KETERANGAN</h6></a>
								</div>
							</div>
</div><div class="row row-no-padding row-col-separator-xl kt-widget1--botop">							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/keluhan"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-keluhan.png" />
									<h6>KELUHAN MASYARAKAT</h6></a>
								</div>
							</div>
							<div class="col-sm-6">
								<div class="kt-widget1">
									<a href="https://amalku.lawu.adythree.web.id/amalku"><img class="appicon" src="https://amalku.lawu.adythree.web.id/amalku/dd.webtpl/default/images/app-admin.png" />
									<h6>AMALKU ADMIN</h6></a>
								</div>
							</div>
</div>					</div>
				</div>
			</div>
		</div>
	</div>	
</div>
<!-- end:: Page -->
<? include("tpl.bot.php"); ?>