<?php

//ini_set('display_errors', 1);
//ini_set('display_startup_errors', 1);
//error_reporting(E_ALL);
    $activeid = $_GET['id'];
	$db = new SQLite3('./api/.db.db');
    
    $res2 = $db->query("SELECT version FROM store");
	$res = $db->query("SELECT * FROM store WHERE id='".$activeid."'");
	$catss = array();
	while($rows = $res2->fetchArray() ){
		array_push($catss, $rows['version']);
	}
	//print_r($cats);
	$cats = array_unique($catss);
	//print_r($cats);
	$row = $res->fetchArray();
	$app = $row['name'];
	$ver = $row['version'];
	$vercode = $row['version_code'];
	$app = $row['name'];
	$vidz = $row['vidz'];
	$url = $row['url'];
	$base64 = base64_decode($row['base64']);
	$icon =$row['icon'];

	if (isset($_POST['edit_links']))
    {
		$icon = $_POST['icon'];
		if ($icon != ""){
			$icon = str_replace("'", "&apos;", $icon);
			$icon = str_replace('"', '&quot;', $icon);
			$icon = str_replace("<", "&lt;", $icon);
			$icon = str_replace(">", "&gt;", $icon);
			$icon = str_replace("&", "&amp;", $icon);
		}
		$name = $_POST['name'];
		if ($name != ""){
			$name = str_replace("'", "&apos;", $name);
			$name = str_replace('"', '&quot;', $name);
			$name = str_replace("<", "&lt;", $name);
			$name = str_replace(">", "&gt;", $name);
			$name = str_replace("&", "&amp;", $name);
		}
		$url = $_POST['url'];
		if ($url != ""){
			$url = str_replace("'", "&apos;", $url);
			$url = str_replace('"', '&quot;', $url);
			$url = str_replace("<", "&lt;", $url);
			$url = str_replace(">", "&gt;", $url);
			$url = str_replace("&", "&amp;", $url);
		}
		$vidz = $_POST['vidz'];
		if ($vidz != ""){
			$vidz = str_replace("'", "&apos;", $vidz);
			$vidz = str_replace('"', '&quot;', $vidz);
			$vidz = str_replace("<", "&lt;", $vidz);
			$vidz = str_replace(">", "&gt;", $vidz);
			$vidz = str_replace("&", "&amp;", $vidz);
		}
        $db->exec("UPDATE store SET	version='" . $_POST['version'] . "', version_code='" . $_POST['version_code'] . "', url='" . $url. "', icon='" . $icon . "', name='" . $name . "', base64='" . base64_encode($_POST['base64']) . "', vidz='" . $vidz . "' WHERE id='".$activeid."'");
        header("Location: store.php");
    }


	include ('includes/header.php');
?>

<div class="has-sidebar-left has-sidebar-tabs">
    <div class="container-fluid relative animatedParent animateOnce p-lg-5">
    	<div class="col-md-8 mx-auto">
			<div class="card-body">
				<div class="card bg-primary text-white">
					<div class="card-header card-header-warning">
                        <center>
                            <h2><i class="icon icon-user"></i> Update Links</h2>
                        </center>
                    </div>
					

					<div class="card-body">
						<form  method="post">

							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">Category Name</label>
                                    <input class="form-control" list="catlist" name="version" autocomplete="off"  value="<?= $ver ?>">
									  <datalist id="catlist">
									   <?php
									  foreach($cats as $value) { ?>
									  <option value="<?= $value ?>"<?php if ($ver == $value){echo 'selected="selected"';}?>><?= $value ?></option>
									  <?php } ?>
									</datalist>
									</div>
								</div>
							</div>
							
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">App Name</label>
										<input type="text" class="form-control" name="name" value="<?php echo $app ?>">
									</div>
								</div>
							</div>
							
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">Icon</label>
										<input type="text" class="form-control" name="icon" value="<?php echo $icon ?>">
									</div>
								</div>
							</div>

							
							
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">Description</label>
										<input type="text" class="form-control" name="base64" value="<?php echo $base64 ?>">
									</div>
								</div>
							</div>
							
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">URL</label>
										<input type="text" class="form-control" name="url" value="<?php echo $url ?>">
									</div>
								</div>
							</div>
							
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">Preview Video</label>
										<input type="text" class="form-control" name="vidz" value="<?php echo $vidz ?>">
									</div>
								</div>
							</div>
						
							<div class="form-group">
								<div class="form-group form-float form-group-lg">
                                    <div class="form-line">
                                        <label class="form-label">PIN</label>
										<input type="text" class="form-control" name="version_code" value="<?php echo $vercode ?>">
									</div>
								</div>
							</div>

							<hr>

							<center>
								<button type="submit" name="edit_links" class="btn btn-info">
									<i class="icon icon-check"></i>Update Links
								</button>
							</center>
						</form>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>

<?php include ('includes/footer.php'); ?>

</body>
</html>