Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head lang="en">
- <meta charset="UTF-8">
- <title></title>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
- <script src="ajaxTest.js"></script>
- </head>
- <body>
- <div class="repeatTimers">
- <style type="text/css">
- .tg {border-collapse:collapse;border-spacing:0;}
- .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
- .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
- .tg .tg-egay{font-weight:bold;font-size:26px;font-family:Impact, Charcoal, sans-serif !important;;background-color:#9a0000;text-align:center;vertical-align:top}
- .tg .tg-yw4l{vertical-align:top}
- </style>
- <table class="tg">
- <tr>
- <th class="tg-egay" colspan="4"> Cooldowns </th>
- </tr>
- <?php
- $dbhost = 'rdbms.strato.de';
- $dbuser = 'U2658295';
- $dbpass = 'ABC123456789';
- $dbname = 'DB2658295';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
- mysql_select_db($dbname, $conn);
- $result = mysql_query("SELECT * FROM Timer", $conn);
- date_default_timezone_set("Europe/Berlin");
- $timestamp = date('Y-m-d G:i:s');
- while ($row = mysql_fetch_array($result)) {
- $Ready = date(htmlspecialchars($row['Clear']));
- echo '<tr align="center"><td class="tg-yw4l"> ' . htmlspecialchars($row['Name']) . ' </td>';
- if ($timestamp > strtotime("+45 minutes",$Ready)) {
- echo '<td class="tg-yw4l">Ready on -> '. $timestamp .'</td>';
- } else {
- echo '<td class="tg-yw4l">Ready - '. $Ready .'</td>';
- }
- echo '</td><td class="tg-yw4l"> Got it!</td></tr>';
- #<td class="tg-yw4l"> ' . htmlspecialchars($row['Cooldown']) . ' </td><td class="tg-yw4l"> ' . htmlspecialchars($row['Clear']) .
- }
- ?>
- </table>
- </div>
- <br \>
- <a class="timer" timerid="1">atrgha</a>
- <a class="timer" timerid="2">athrsa</a>
- <a class="timer" timerid="3">aetrha</a>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement