<html >
  <head>
    <meta charset="UTF-8">
    <?php
include ("main/connect.php");

$result6 = $dbh->query("select * from scrap where type='title'");
$row6 = $result6->fetchObject();
$count6 = $result6->rowCount();

?>
    <title><?php echo $row6->item; ?></title>

        <style>
      
body {
  background: #999;
  padding: 40px;
  font-family: "Open Sans Condensed", sans-serif;
}

.btnnicelook{}

#bg {
  position: fixed;
  left: 0;
  top: 0;
  width: 100%;
  height: 100%;
  background: url(bg2.jpg) no-repeat center center fixed;
  background-size: cover;
 -webkit-filter: blur(0px);    
}


form {
  position: relative;
  width: 250px;
  margin: 0 auto;
  background: rgba(130,130,130,.3);
  padding: 20px 22px;
  border: 1px solid;
  border-top-color: rgba(255,255,255,.4);
  border-left-color: rgba(255,255,255,.4);
  border-bottom-color: rgba(60,60,60,.4);
  border-right-color: rgba(60,60,60,.4);
}

form input, form button {
  width: 212px;
  border: 1px solid;
  border-bottom-color: rgba(255,255,255,.5);
  border-right-color: rgba(60,60,60,.35);
  border-top-color: rgba(60,60,60,.35);
  border-left-color: rgba(80,80,80,.45);
  background-color: rgba(0,0,0,.2);
  background-repeat: no-repeat;
  padding: 8px 24px 8px 10px;
  font: bold .875em/1.25em "Open Sans Condensed", sans-serif;
  letter-spacing: .075em;
  color: #fff;
  text-shadow: 0 1px 0 rgba(0,0,0,.1);
  margin-bottom: 19px;
}

form input:focus { background-color: rgba(0,0,0,.4); }

form input.email {
  background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAA8AAAAMCAYAAAC9QufkAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYxIDY0LjE0MDk0OSwgMjAxMC8xMi8wNy0xMDo1NzowMSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNS4xIFdpbmRvd3MiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6M0YwNDIzMTQ3QzIzMTFFMjg3Q0VFQzhDNTgxMTRCRTQiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6M0YwNDIzMTU3QzIzMTFFMjg3Q0VFQzhDNTgxMTRCRTQiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDozRjA0MjMxMjdDMjMxMUUyODdDRUVDOEM1ODExNEJFNCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDozRjA0MjMxMzdDMjMxMUUyODdDRUVDOEM1ODExNEJFNCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PsOChsgAAADUSURBVHjaYvz///9JBgYGMwbSwSkGoOafQPwKiAOBmIEIHAXED0H6QJwPQGwAxE+AOJOAxnwgvgfEKiB9MM0gWg6IbwNxIw6NXUB8HogloHwUzSAsBAoDIJ4DxMxQMRA9H4gPADE/kloMzSCsBcR/gHgj1LAt0HBRR1P3gQktBA2AeBcQZwHxCyB+AsT3gTgFKq6FohrJZnssoW6AxPaDBqoZurP9oBrtCYS2ExA/h9JgzX+gAsZExrMZVP0fmGZ1IjWiBCoL0NsXgPgGGcnzLECAAQD5y8iZ2Z69IwAAAABJRU5ErkJggg==);
  background-position: 220px 10px;
}

form input.pass {
  background-image: url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAA0AAAAQCAYAAADNo/U5AAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAyJpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuMC1jMDYxIDY0LjE0MDk0OSwgMjAxMC8xMi8wNy0xMDo1NzowMSAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvIiB4bWxuczp4bXBNTT0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wL21tLyIgeG1sbnM6c3RSZWY9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9zVHlwZS9SZXNvdXJjZVJlZiMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENTNS4xIFdpbmRvd3MiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NTVFMDg1QzU3QzIzMTFFMjgwQThGODZFM0EwQUZFQ0YiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NTVFMDg1QzY3QzIzMTFFMjgwQThGODZFM0EwQUZFQ0YiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo1NUUwODVDMzdDMjMxMUUyODBBOEY4NkUzQTBBRkVDRiIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo1NUUwODVDNDdDMjMxMUUyODBBOEY4NkUzQTBBRkVDRiIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pv2NSIIAAADYSURBVHjanJAxCsJAEEXXaBMQtvIMqTxDKjtPELC1svMoOYM2WlqIhVcQFMVgG7ATAoIggfGPjrLIrBo/vCzZ+Z+dGUNExiECI7Clhw5gAtqur8YfUQxm4AzGIAMRSIAFXbC8OyUdghwsgH173cp9Lr5XqAeOSsANcj3h/8BpbQ4Ko6uQOvtMQy6noG4+iz3XZ4iHbIEQ9L8EeUlN3t5etvSrMg6RqajAc78BQ7BTq6QrllV3tKLvpZOclyrt/TWTlTP0zVQqba/BAKyUWsmh1BPUxL70JsAABHkyyK1uocIAAAAASUVORK5CYII=);
  background-position: 223px 8px
}

::-webkit-input-placeholder { color: #ccc; text-transform: uppercase; }
::-moz-placeholder { color: #ccc; text-transform: uppercase; }
:-ms-input-placeholder { color: #ccc; text-transform: uppercase; }

form button[type=submit] {
  width: 248px;
  margin-bottom: 0;
  color: #fff;
  letter-spacing: .05em;
  text-shadow: 0 1px 0 #133d3e;
  text-transform: uppercase;
  background: #0B981C;
  border-top-color: #9fb5b5;
  border-left-color: #608586;
  border-bottom-color: #1b4849;
  border-right-color: #1e4d4e;
  cursor: pointer;
}
    </style>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.1/jquery.js"></script>
  <script>
   $(document).ready(function(){
	   $("#forgot").click(function(){
		   $("#read").toggle("slow");
		   })
	   })
  </script>
  <style>
  #read{
  display : none;
  text-align : center;
  margin-left : 20%;
  margin-right : 32%;
  padding : 5px;
  }
  </style>
  </head>

 <body id='bg'>
 <div style="float:right;height:500px;width:18%;margin-right:5%;overflow:scroll; background-color: white; opacity: 0.5; padding-left: 10px; padding-top: 10px;">
<?php 
date_default_timezone_set('Africa/Kampala');
include ("main/connect.php");
$result = $dbh->query("select * from suggestion where public='1' order by autoid desc");
$row = $result->fetchObject();
$rowcount=$result->rowCount();
if ($rowcount>0){
do{
  if($row->suggestion==''){
  echo "";
  }else{
echo" 
<div class='sug1' style='border-radius:10px;'><font color='blue'>".$row->suggestion."</font><p align='right'><font color='black'>-".$row->user."</font></p></div>_ _ _";
  }
}while($row=$result->fetchObject());
}
else {echo "<center>No new reviews</center>";}

?>
</div>

<?php
include("main/connect.php");

$dater = date("m")."-";

$result5 = $dbh->query("select * from users where birthday like '%$dater%'");

$count5 = $result5->rowCount();

?>
</div>

<div align="center">
<!--<img src="ntvfront.jpg" width="170px" style="text-align: center; margin-left:180px; margin-top: 1%">-->

<?php
include ("main/connect.php");

$result6 = $dbh->query("select * from scrap where type='title'");
$row6 = $result6->fetchObject();
$count6 = $result6->rowCount();

?>
<p style="margin-left: 180px;"><font style="color:white; font-size: 30px;"><?php echo $row6->item ?></font></p>
<br><br>
<?php
if($count5>0){
  echo "
<div style='height:50px;width:25%; background-color: white; opacity: 0.5; padding-top: 10px;padding-bottom: 10px; margin-left: -160px;'>
<strong style='color:green;'>
<i>Birthdays this month</i>
</strong><br><br>";


  $row5 = $result5->fetchObject();

  do{
$birthdate=substr($row5->birthday,3);
    if($birthdate < 11 || $birthdate > 13){
         $wordcheck=$birthdate % 10;

         if ($wordcheck=='1'){$wordy='st';}
        elseif ($wordcheck=='2'){$wordy='nd';}
        elseif ($wordcheck=='3'){$wordy='rd';}
        else {$wordy='th';}
    }
else {$wordy='th';}

echo $row5->firstname." ".$row5->lastname." - ".$birthdate.$wordy;
   

  }while($row5 = $result5->fetchObject());

}
?>
</div>
</div>
<?php



if (isset($_GET['wasgoinghere'])){$wasgoinghere="?wasgoinghere=".$_GET['wasgoinghere'];}
else{$wasgoinghere="";}
?>
<form action="checklogin.php" method="post" style="margin-top: 2%;margin-right:45%;">
    
  <label for=""></label>
  <input type="text" name="myusername" placeholder="Username" class="email">
    
  <label for=""></label>
  <input type="password" name="mypassword" placeholder="Password" class="pass">
   <input type="hidden" name="wasgoinghere" value="<?php echo $wasgoinghere; ?>">

  
  <button type="submit" name="submit" class="btnnicelook">Login</button>
    
</form>
<div id="read">
<form action="main/forgot.php" method="post">
<input type="text" name="email" placeholder="Type your Email">

<button type="submit">Remind me</button> 
</form>

</div>
<div style="text-align:center;margin-left:12%;"><button id="forgot" style="padding-right: 0%;
padding-top: 0px;
padding-bottom: 0px;
background-color: cadetblue;
color: beige;">Forgot password</button></div>

<font color="white">

<script>
function lengtha(){
var captcha1 = document.getElementById("captchaz").value;
	
if(captcha1.length <5){
document.getElementById('captchaz').style.borderColor = "red";
}
else if(captcha1.length >5){
document.getElementById('captchaz').style.borderColor = "red";
alert("Length is greater than 5");
}else{
document.getElementById('captchaz').style.borderColor = "green";}
}

function refresher(){
window.location="index.php";

}
</script>

<?php 

include ('main/connect.php');
$ip_ad=$_SERVER['REMOTE_ADDR'];
$previouspage="None";
$kbrowser=$_SERVER['HTTP_USER_AGENT'];
$stage = "0";
$activity = "index.php";
$insertactivity = $dbh->exec("insert into useractivity (activity,browser,previouspage,stage,deviceid) values('$activity','$kbrowser','$previouspage','$stage','$ip_ad')");

	?>
    
  </body>
</html>