<?php

    
    
    if (isset($_POST['update']))
    {
		$db = new SQLite3('./api/.db.db');
		$udpates = $db->querySingle("SELECT COUNT(*) as count FROM updates");
		if ($udpates != 0) {
        $db->exec("UPDATE updates SET version='".$_POST['version']."', version_code='".$_POST['version_code']."', url='".$_POST['url']."' WHERE id='1'");
        header("Location: update.php");
		}else{
			$db->exec("INSERT INTO updates(version,version_code,url) VALUES('".$_POST['version']."', '".$_POST['version_code']."','".$_POST['url']."')");
        header("Location: update.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-window-restore"></i> Add In-App Update</h2>
                        </center>
                    </div>

                    <div class="card-body">
                            <form method="post">
                                <div class="form-group">
                                    <label class="form-label " for="version" >Version</label>
                                    <input class="form-control" id="version" name="version" value="" type="text"/>
                                </div>             
                                <div class="form-group">
                                    <label class="form-label " for="version_code" >Version Code</label>
                                    <input class="form-control" id="version_code" name="version_code" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <label class="form-label " for="url" >APK URL</label>
                                    <input class="form-control" id="url" name="url" value="" type="text"/>
                                </div>
                                <div class="form-group">
                                    <center>
                                        <button class="btn btn-info " name="update" type="submit">
                                            <i class="icon icon-check"></i> Submit
                                        </button>
                                    </center>
                                </div>
                            </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php include ('includes/footer.php');?>

</body>
</html>