TheRepository/user.php at master · EnergyCrafter/TheRepository · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
<?php
  include 'config.php';
  include 'headers.php';

  // open connection to the database
  include 'opendb.php';

  $userID = NULL;
  $media = $mediaDir;
  $username = $_GET["username"];

  try {
    // get clip properties
    $userResult = mysqli_query($conn, "SELECT id, email FROM users WHERE username='" . $username . "'");

    if(mysqli_num_rows($userResult) == 0){
        $userID = NULL;
    } else {
        $userRow = mysqli_fetch_row($userResult);
        $userID = $userRow[0];
        $email = $userRow[1];
    }

  } catch (Exception $e) {
    $userID = NULL;
  }
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
    <link rel="icon" href="/favicon.ico" type="image/x-icon">

    <title>Completely Digital Clips<?php if($clip != NULL){echo " - $title";} ?></title>

    <!-- Bootstrap core CSS -->
    <link href="/static/css/bootstrap.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
      <script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
    <![endif]-->

    <!-- Custom styles for this template -->
    <link href="/static/css/carousel.css" rel="stylesheet">

    <script src="/lib/jquery.js"></script>
    <script src="/lib/mediaelement-and-player.min.js"></script>
    <link rel="stylesheet" href="./lib/mediaelementplayer.css" />
    <script src="/static/js/bootstrap.min.js"></script>
  </head>
<!-- NAVBAR
================================================== -->
  <body>
    <div class="navbar-wrapper">
      <div class="container">

        <div class="navbar navbar-inverse navbar-static-top" role="navigation">
          <div class="container">
            <div class="navbar-header">
              <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
                <span class="sr-only">Toggle navigation</span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
                <span class="icon-bar"></span>
              </button>
              <a class="navbar-brand" href="#">Completely Digital Clips</a>
              <?php echo "<!-- Hosted by $APPLICATION_HOSTNAME -->"; ?>
            </div>
            <div class="navbar-collapse collapse">
              <ul class="nav navbar-nav">
                <li><a href="/index.php">Home</a></li>
                <?php if(isset($_COOKIE["PHPSESSID"])): ?>
                  <li><a href="/post.php">Post Video</a></li>
                  <li><a href="/logout.php">Logout</a></li>
                <?php else: ?>
                  <li><a href="/login.php">Login</a></li>
                  <li><a href="/registration.php">Register</a></li>
                <?php endif; ?>
              </ul>
            </div>
          </div>
        </div>
      </div>
    </div>
    <br />
    <div class="container marketing">
      <hr class="featurette-divider">
      <center>
      <?php if(isset($_COOKIE["PHPSESSID"])): ?>
        <h1>Account Information</h1>
        <p><b>Username: </b> <?php echo $username; ?></p>
        <p><b>Email: </b> <?php echo $email; ?></p>
      <?php endif; ?>
      <?php
        if($userID){
          echo "<h1>User Videos</h1>";
          // get user videos
          $clipsResult = mysqli_query($conn, "SELECT host, title, shortname, posted, views FROM clips WHERE user='" . $userID . "' ORDER BY views DESC, posted DESC");
          $postedClips = FALSE;
          while($clipsRow = mysqli_fetch_row($clipsResult)){
            $postedClips = TRUE;
            $host = $clipsRow[0];
            $title = $clipsRow[1];
            $shortname = $clipsRow[2];
            $posted = $clipsRow[3];
            $views = $clipsRow[4];
            echo "<a href=\"/view.php?video=$shortname\"><h2>$title</h2></a>";
            echo "<a href=\"/view.php?video=$shortname\"><img src=\"http://$host$media/$shortname.png\" /></a>";
            echo "<p>$views views since $posted</p><br />";
          }
          if($postedClips == FALSE){
            echo "<p>This user hasn't posted any videos :(</p>";
          }
        } else {
          echo "<h1>Sorry we couldn't find that user :(</h1>";
        }
      ?>
      </center>
      <!-- FOOTER -->
      <hr class="featurette-divider">
      <footer>
        <p class="pull-right"><a href="#">Back to top</a></p>
        <p>&copy; <?php echo date("Y"); ?> Completely Digital Clips &middot; <a href="/privacy.php">Privacy</a> &middot; <a href="/terms.php">Terms</a></p>
      </footer>
    </div>
  </body>
</html>