blob: e426d60171780e298a2e85930d63915916a0e424 [file] [log] [blame]
<head>
<link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Open+Sans" />
<link rel="stylesheet" href="./css/basic.css" />
<link rel="stylesheet" href="./css/main.css" />
<?php
require './credentials.php';
require './php/utils.php';
$credentials = new Credentials();
$usersdb = $credentials->usersdb;
$mortsdb = $credentials->mortsdb;
date_default_timezone_set("Europe/Madrid");
$user = $_COOKIE['user']; // (int)$_POST['user'];
$password = $_COOKIE['password']; // isset($_POST['password']) ? md5($_POST['password']) : '';
if (!isset($_COOKIE['user']) or $_COOKIE['user'] == '') {
die("<script>window.location.href = './'</script>");
} else if (isset($_COOKIE['password'])) {
$query_password = "SELECT password FROM $usersdb WHERE id=$user";
if (query($query_password)->fetch_row()[0] != $password) {
// Unset variables
setcookie('user', '', -1, "/");
setcookie('password', '', -1, "/");
die("<script>window.location.href = './?passwordchanged=1'</script>");
}
}
?>
<?php
$user = get_users($user);
$victim = get_users($user->quimata);
if ($user->mort) die("<script>window.location.href = './dead.php'</script>");
?>
<meta charset="UTF-8">
<title>PastanagAPP</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="manifest" href="https://api.myjson.com/bins/u6r41">
<!-- Apple web app -->
<link rel="apple-touch-icon" href="./bin/images/icons/icon-72x72.png">
<meta name="apple-mobile-web-app-title" content="PastanagAPP">
<meta name="apple-mobile-web-app-capable" content="yes">
<meta name="apple-mobile-web-app-status-bar-style" content="green">
</head>
<body>
<div id="outter-container">
<div id="inner-container">
<div><a href="./main.php">Tornar a la pàgina principal</a></div>
<div id="message-board">
<div id="victim-messages">
<div class="messages-sent">
<?php
// Create connection
$credentials = new Credentials();
$conn = new mysqli($credentials->servername, $credentials->username, $credentials->password, $credentials->dbname);
if ($conn->connect_error) die("Connection failed: " . $conn->connect_error);
$conn->set_charset("utf8");
// Execute query and save result
$query_msgs = "SELECT * FROM `missatges` WHERE (`sender_id` = ".$user->id." AND `receiver_id` = ".$user->quimata .
") OR (`sender_id` = ".$user->quimata." AND `receiver_id` = ".$user->id . ")";
$result = $conn->query($query_msgs);
while($res = $result->fetch_row()) {
if ($res[1] == $user->id) {
echo "<div class='from-me'><div class='msg-content'>$res[4]</div><div class='meta-data'><span class='timestamp'>$res[3]</span><span class='seen'>".($res[5] == 0 ? 'Enviat' : 'Vist')."</span></div></div>";
} else {
echo "<div class='to-me'><div class='msg-content'>$res[4]</div><div class='meta-data'><span class='timestamp'>$res[3]</span><span class='seen'>".($res[5] == 0 ? 'Nou!' : '')."</span></div></div>";
}
}
// Update 'seen' messages
$query_seen = "UPDATE missatges SET `seen` = 1 WHERE `receiver_id` = " . $user->id . " AND `sender_id` = " . $user->quimata;
$conn->query($query_seen);
// Close the connection
$conn->close();
?>
</div>
<form action="./php/send_thread.php" method="POST">
<input type="text" name="msg-content" placeholder="Que es cagui de por" />
<input type="hidden" name="killer-id" value="<?=(int)$user->id?>">
<input type="hidden" name="victim-id" value="<?=(int)$user->quimata?>">
<input type="hidden" name="origin" value="victim">
<input type="submit" value="Enviar amenaça" />
</form>
</div>
</div>
</div>
</div>
</body>