<?php include('header.php');?>


<div id="admin-left-box">

<?php include('menu.php');?>

</div><!--admin-left-box-->
<div class="admin-right-box">

<div class="title"><h1>Site Settings</h1></div>

<?php
$act=isset($_GET['act'])?$_GET['act']:"";
 
if($act=='sub'){
$name = $mysqli->escape_string($_POST['site-name']);
$siteurl = $mysqli->escape_string($_POST['site-url']);
$keys = $mysqli->escape_string($_POST['meta-keyword']);
$description = $mysqli->escape_string($_POST['meta-description']);
$email = $mysqli->escape_string($_POST['email']);
$facebook = $mysqli->escape_string($_POST['fblink']);
$google_plus = $mysqli->escape_string($_POST['google_plus']);
$twitter = $mysqli->escape_string($_POST['twitter']);
$pinterest = $mysqli->escape_string($_POST['twitter']);
$reddit = $mysqli->escape_string($_POST['reddit']);
$approve = $mysqli->escape_string($_POST['autoapprove']);


	
$mysqli->query("UPDATE settings SET site_name='$name',site_url='$siteurl',meta_keywords='$keys',meta_description='$description',email='$email',facebook='$facebook',google_plus='$google_plus',twitter='$twitter',pinterest='$pinterest',reddit='$reddit',approve='$approve' WHERE id=1");

if($_FILES["site-logo"]["name"]!=''){
	 	   move_uploaded_file($_FILES["file"]["tmp_name"], "../images/logo.png");
	}?>
    
<div class="msg-ok">Settings updated successfully.</div>  

<?php } 
$SQL = $mysqli->query("SELECT * FROM settings WHERE id=1");
$Row = mysqli_fetch_array($SQL);

$approve = $Row['approve'];

?>

<form id="settings-form" class="theform" action="index.php?act=sub" method="post" enctype="multipart/form-data">


<label for="site-name">Site Name</label>
<input type="text" name="site-name" id="site-name" value="<?php echo $Row['site_name'];?>"/>

<label for="site-url">Site URL</label>
<input type="text" name="site-url" id="site-url" value="<?php echo $Row['site_url'];?>"/>

<label for="site-logo">Site Logo</label>
<input type="file" name="site-logo" id="site-logo" value=""/>

<label for="meta-description">Meta Description</label>
<textarea name="meta-description" id="meta-description"><?php echo $Row['meta_description'];?></textarea>

<label for="meta-keyword">Meta Keywords</label>
<textarea name="meta-keyword" id="meta-keyword"><?php echo $Row['meta_keywords'];?></textarea>

<label for="email">E-mail</label>
<input type="text" name="email" id="email" value="<?php echo $Row['email'];?>"/>

<label for="fblink">Facebook Fan Page URL</label>
<input type="text" name="fblink" id="fblink" value="<?php echo $Row['facebook'];?>"/>

<label for="google_plus">Google+ URL</label>
<input type="text" name="google_plus" id="google_plus" value="<?php echo $Row['google_plus'];?>"/>

<label for="twitter">Twitter URL</label>
<input type="text" name="twitter" id="twitter" value="<?php echo $Row['twitter'];?>"/>

<label for="pinterests">Pinterest URL</label>
<input type="text" name="pinterest" id="pinterest" value="<?php echo $Row['pinterest'];?>"/>

<label for="reddit">Reddit URL</label>
<input type="text" name="reddit" id="reddit" value="<?php echo $Row['reddit'];?>"/>

<label for="autoapprove">Auto Approve</label>
<select id="autoapprove" name="autoapprove">
<?php if ($approve==1){?>
<option value="1">Yes</option>
<option value="0">No</option>
<?php }else{?>
<option value="0">No</option>
<option value="1">Yes</option>
<?php }?>
</select>


<button type="submit" id="submit">Submit</button>
</form>

</div><!--admin-right-box-->
<!--admin-container-->

<?php include('footer.php');?>