Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = 'db.mysql-01.gsp-europe.net';
- $dbuser = 'sql_3984';
- $dbpass = '******';
- $dbname = 'sql_3984';
- $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
- $conn->set_charset("utf8");
- php?>
- <style>
- .col-lg-12 {
- position:relative;
- min-height:1px;
- padding-left:15px;
- padding-right:15px
- }
- .row {
- margin-left:-15px;
- margin-right:-15px
- }
- .table {
- width:100%;
- max-width:100%;
- margin-bottom:21px
- }
- </style>
- <div class="row">
- <div class="col-lg-12">
- <center><table class="table">
- <head>
- <tr>
- <th>
- <center>Jmeno Hraci</center>
- </th>
- <th>
- <center>Admin ktery udelil Ban</center>
- </th>
- <th>
- <center>Duvod</center>
- </th>
- <th>
- <center>Čas zabanovani</center>
- </th>
- <th>
- <center>Doba Trvani Banu</center>
- </th>
- </tr>
- </head>
- <tbody>
- <?php
- while ($row = $retval->fetch_assoc()) {
- $row['banner'] == null;
- $row['banner'] = 'IP+ System';
- }
- $timeEpoch = $row['time'];
- $timeConvert = $timeEpoch / 1000;
- $timeResult = date('F j, Y, g:i a', $timeConvert);
- $expiresEpoch = $row['expires'];
- $expiresConvert = $expiresEpoch / 1000;
- $expiresResult = date('F j, Y, g:i a', $expiresConvert);
- ?>
- <tr>
- <td><?php echo "<img src='https://mcapi.ca/avatar/2d/" . $row['name'] . "/25' style='margin-bottom:5px;margin-right:5px;border-radius:2px;' />" . $row['name'];?></td>
- <td><?php echo "<img src='https://mcapi.ca/avatar/2d/" . $row['banner'] . "/25' style='margin-bottom:5px;margin-right:5px;border-radius:2px;' />" . $row['banner'];?></td>
- <td style="width: 30%;"><?php echo $row['reason'];?></td>
- <td><?php echo $timeResult;?></td>
- <td><?php if($row['expires'] == 0) {
- echo 'Infinity';
- } else {
- echo $expiresResult; }?></td>
- </tr>
- </tbody>
- </table></center>
- </div>
- </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement