<?php
if (isset($_GET['sair'])){
    session_destroy();
    unset ($_SESSION['uname']);
    unset ($_SESSION['upass']);
    header('location:login.php');
}
include 'connect.php';
session_start();
if ( !isset($_SESSION['uname']) and !isset($_SESSION['upass']) ) {
    session_destroy();
    unset ($_SESSION['uname']);
    unset ($_SESSION['upass']);
    header('location:login.php');
}else{

if(!isset($_GET['a']) || !is_string($_GET['a'])) echo 'Digite um Username';
$sth = $pdo->prepare("SELECT id , username , password , avatar , email FROM admcount WHERE username = :a");
$sth->bindParam(':a', $_GET['a'], PDO::PARAM_INT);
$sth->execute();
while($row = $sth->fetch(PDO::FETCH_ASSOC)){
$id = $row['id'];

$username = $row['username'];
$spassword = $row['password'];
$savatar = !is_numeric($row['avatar']) ? $row['avatar'] : 'http://starxat.pl/web_gear/chat/av/'.$row['avatar'].'.png';

$email = $row['email'];
}
if (isset($_POST['update'])) {
$sql = "UPDATE admcount SET  username = :username , avatar = :avatar , email = :email  WHERE id = '".$id."'";
$stmt = $pdo->prepare($sql);


$stmt->bindParam(':username', $_POST['username'], PDO::PARAM_INT);
$stmt->bindParam(':password', $_POST['password'], PDO::PARAM_INT);
$stmt->bindParam(':avatar', $_POST['avatar'], PDO::PARAM_INT);

$stmt->bindParam(':email', $_POST['email'], PDO::PARAM_INT);
$stmt->execute();
}

    $check = $pdo->prepare("SELECT username FROM admcount WHERE username=?");
    $check->execute(array($_GET['u']));
    if ($check->rowCount() == 0):




$avatar = "avatar";

    else:

    endif;
$nAdm = $pdo->query('select count(*) from admcount')->fetchColumn();

}
?>
<?php include("nav.php");?>



    <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <h1>
        Profil
        <small>Kontrol panel</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="index.php"><i class="fa fa-users"></i> Strona Główna</a></li>
        <li class="active">Edycja Profilu</li>
      </ol>
    </section>


    <!-- Main content -->
    <section class="content">




	<div class="col-xs-12">
          <div class="box">
            <div class="box-header">

            </div>
            <!-- /.box-header -->
            <div class="box-body">
			<form method="POST" id="configform" style="position:relative;">
              <div id="example2_wrapper" class="dataTables_wrapper form-inline dt-bootstrap"><div class="row"><div class="col-sm-6"></div><div class="col-sm-6"></div></div><div class="row"><div class="col-sm-12"><table id="example2" class="table table-bordered table-hover dataTable" role="grid" aria-describedby="example2_info">
			  <style>
			  td {
    background-color: #3c8dbc;
}
</style>
              <tr>
     <td rowspan="11" style="width:5%"><img height="200" width="200" src="<?php echo $savatar;?>" class="img-circle" alt="User Image"><center><br><font size="3" color="#ffc000" style="text-shadow: 1px 0px 1px #000000;"><strong><?php echo ucfirst($username);?></strong></font></center></br></td>

    </tr>




                    <tr>
                      <td class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><strong><font color="#ffc000" style="text-shadow: 1px 0px 1px #000000;">Nazwa</strong></font>

					  <p class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><input type="text" style="width:80%"  name="username" value="<?php echo $username;?>"></p></td>
                    </tr>

                    <tr>
                      <td class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><strong><font color="#ffc000" style="text-shadow: 1px 0px 1px #000000;">Zdjęcie</strong></font>
                      <p class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><input type="text" style="width:80%"  name="avatar" value="<?php echo $savatar;?>"></p></td>
                    </tr>

					<tr>
                      <td class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><strong><font color="#ffc000" style="text-shadow: 1px 0px 1px #000000;">Adres Email</strong></font>
                      <p class="sorting_asc" tabindex="0" aria-controls="example2" rowspan="1" colspan="1" aria-sort="ascending" aria-label="Rendering engine: activate to sort column descending"><input type="text" style="width:80%"  name="email" value="<?php echo $email;?>"></p></td>
                    </tr>

                  <tr>

                      <td>
					  <strong><font color="#ffc000" style="text-shadow: 1px 0px 1px #000000;">Aby zapisac ustawienia kliknij ---></strong></font> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="green"><b><input type="submit" value="Zapisz ustawienia dla <?php echo $username;?>" name="update" class="button primary"></b></font>
					  </td>

                    </tr>
                  </table>

				  </form>

			  </div>
			  </div>
			  </div>
            </div>
            <!-- /.box-body -->
          </div>
          <!-- /.box -->


            <!-- /.box-body -->
          </div>
          <!-- /.box -->

	 </section>
    <!-- /.content -->
  </div>
  <?php include('foot.php');?>