Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "149.202.89.200";
- $username = "Cheeze439";
- $password = "ChunkyCheeze439";
- $dbname = "rustserver";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- ?>
- <table>
- <thead>
- <tr>
- <th data-column-id="name">UKW</th>
- <th data-column-id="player" data-type="numeric">Longest Time Online</th>
- </tr>
- </thead>
- <tbody>
- <?php
- $sql = "SELECT name FROM stats_player";
- $ss = "SELECT online_seconds FROM stats_player";
- $result = $conn->query($sql);
- $result2 = $conn->query($ss);
- if ($result->num_rows > 0) {
- // output data of each row
- while($row = $result->fetch_assoc()) {
- // echo "Name: " . $row["name"]."<br>";
- $seconds = $result2; //example
- $hours = floor($seconds / 3600);
- $mins = floor(($seconds - $hours*3600) / 60);
- $s = $seconds - ($hours*3600 + $mins*60);
- $mins = ($mins<10?"0".$mins:"".$mins);
- $s = ($s<10?"0".$s:"".$s);
- $time = ($hours>0?$hours.":":"").$mins.":".$s;
- echo "<tr><td>".$row["name"]."</td><td>$time</td></tr>";
- }
- } else {
- echo "0 results";
- }
- ?>
- </div>
- <?php
- $conn->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement