<?php
$link = mysqli_connect("hostname", "username", "password", "database");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$time = date_timestamp_get(date_create());
$pid = $_GET['player'];
if(isset($pid))
{
$uid = mysqli_real_escape_string($link,$pid);
$row = mysqli_fetch_array(mysqli_query($link,"SELECT user_name, next_breset, mushroom, ssid FROM user_data WHERE user_id='". $uid ."' LIMIT 1"));
$username = mysqli_real_escape_string($link,$row['user_name']);
$next = mysqli_real_escape_string($link,$row['next_breset']);
$shrooms = mysqli_real_escape_string($link,$row['mushroom']);
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="de" dir="ltr">
<title>Beers Reset</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="expires" content="0">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="pragma" content="no-cache">
<meta name="robots" content="noindex,nofollow,noarchive">
<link rel="stylesheet" href="css.css" type="text/css"/>
</head>
<body>
<center>
<table align="center" width="570px" style="font-family: Arial; color: #FFFFFF;">
<tbody>
<tr>
<td style="padding: 0; margin:0">
<div style="overflow: auto; height: 360px; padding: 10px">
<br><br><br>
<?php
if(!isset($_POST["doit"]))
{
if($next <= $time || $next == "0")
{
?>
<center>
<h1>Hello <b><?=$username?></b>!</h1>
Reset your beers so u can continue your adventure!<br>
Tavern owner needs <?=$shrooms;?>/50 to reset you!<br>
If you don't have them you will not be reseted!<br>
<br>
<form action="<?=$_SERVER["PHP_SELF"] ?>" method="post" enctype="multipart/form-data" target="_self">
<input type="password" name="password" size="10" value=""><br><br>
<input type="submit" value="Ok!" name="button">
<input type="hidden" name="doit" value="yes">
<input type="hidden" name="uid" value="<?=$uid?>">
</form>
</center>
<?php
}
else
{
?>
<center>
<h2>I'm sorry <b><?=$username?></b>!</h2>
<p>Your next reset will be available at: <?echo date('d.m.Y H:i:s', $next); /*Convert timestamp to GMT*/?></p>
</center>
<?php
}
}
if(isset($_POST["doit"]))
{
$userid = $_POST["uid"];
$pass = $_POST["password"];
$row = mysqli_fetch_array(mysqli_query($link,"SELECT password,next_breset FROM user_data WHERE user_id='". $userid ."' LIMIT 1"));
if($row["password"] == md5($pass))
{
$next = $time+21600;
mysqli_query($link,"UPDATE user_data
SET next_breset = '" . $next . "', beers = '0', mushroom = mushroom-50 WHERE user_id = '" . $userid . "' LIMIT 1");
echo '<script>window.close();</script><META HTTP-EQUIV="REFRESH" CONTENT="0; URL=../">';
}
else
{
echo '<script>window.close();</script><META HTTP-EQUIV="REFRESH" CONTENT="0; URL=../">';
}
}
?>
</div>
</td>
</tr>
</tbody>
</table>
</center>
</body>
</html>
> \r\n'
