Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Online użytkowników</title>
- <meta http-equiv='content-type' content='text/html; charset=utf-8' />
- <style>
- body{
- text-align: center;
- margin: 0px auto;
- }
- table{
- width: 600px;
- margin: 0px auto;
- text-align: center;
- }
- tr {
- font-size: 11pt;
- }
- .tytul{
- height: 28px;
- color: #FFFFFF;
- font-weight: bold;
- background-image: url(images/tytul.jpg);
- }
- </style>
- </head>
- <body>
- <table cellspacing="0">
- <?php
- try
- {
- //Pobieranie konfiguracji SQL
- require_once 'sqlconfig.php';
- //Nawiązywanie połączeń z baza SQL Realmd i Characters
- $charactersdb = new PDO(sprintf('%s:host=%s;port=%d;dbname=%s', 'mysql', $host, 3306, $charactersdb), $user, $password);
- $charactersdb-> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $realmd = new PDO(sprintf('%s:host=%s;port=%d;dbname=%s', 'mysql', $host, 3306, $realmdb), $user, $password);
- $realmd-> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- //zmienne pomocnicze
- if ((isset($_GET["pid"])) && (!$_GET["pid"] <= '1')) {$pid = intval($_GET["pid"]);} else {$pid = 1;}
- $limitstart = ($pid - 1) * $limit;
- //inne obliczenia i funkcje
- if ($pid <= 1)
- $licz = 1;
- else{
- $licz = ($pid - 1) * $limit;
- $licz++;
- }
- function tlo($licz){
- if (($licz % 2) > 0){
- return 'areny_tlo_02.gif';}
- else{
- return 'areny_tlo_04.gif';}
- }
- //pobieranie danych dla stronicowania
- $query = $charactersdb-> query("SELECT count(*) FROM `characters` WHERE `online`='1' AND (NOT `extra_flags` & 1 AND NOT `extra_flags` & 16)");
- $num = $query-> fetchColumn();
- $pages = ceil($num/$limit);
- $query-> closeCursor();
- //Sprawdzanie statusu serwera...
- if ($query_status = $realmd-> query('SELECT `color` FROM `realmlist` WHERE `id` = 1')) {
- $fetch = $query_status-> fetch(PDO::FETCH_ASSOC);
- if ($fetch[0] === 2)
- echo '<td><img src=\'images/offline.gif\' alt=\'Offline\' style=\'padding-right: 2pt\' /> <font color=\'red\'>Offline</font></td></tr>';
- else {
- echo '<tr class="tytul"><td colspan="6">Gates of Azeroth</td></tr>';
- echo '<tr class="tytul"><td colspan="6">';
- //stronicowanie
- if ($pages >= 1) {
- for ($pnum = 1; $pnum <= $pages; $pnum++) {
- if (isset($_GET["pid"])) {
- if ($_GET["pid"] == $pnum) {
- echo '['.$pnum.'] ';
- }
- else {
- echo '<a href="playersonline.php?pid='.$pnum.'" style="color: #000000; text-decoration: none;">'.$pnum.'</a> ';
- }
- }
- else {
- if ($pnum === 1) {echo '['.$pnum.'] ';}
- else {echo '<a href="playersonline.php?pid='.$pnum.'" style="color: #000000; text-decoration: none;">'.$pnum.'</a> ';}
- }
- }
- }
- else
- echo 'Błąd stronicowania!';
- echo'</td></tr>';
- echo '<tr class="tytul"><td>#</td><td>Nick</td><td>Rasa</td><td>Klasa</td><td >Lvl</td><td>Lokacja</td></tr>';
- //pobieranie danych graczy z bazy
- $query_players = $charactersdb-> query("SELECT guid, name, race, class, gender, level, zone FROM `characters` WHERE `online`='1' AND (NOT `extra_flags` & 1 AND NOT `extra_flags` & 16) ORDER BY `name` LIMIT $limitstart,$limit");
- //wyswietlanie danych
- while($row = $query_players-> fetch())
- {
- echo '<tr style="background-image: url(images/'.tlo($licz).'); height: 28px; "><td>'.$licz++.'</td>
- <td><a href="armory/character-sheet.xml?r=GatesOfAzeroth&cn='.$row['name'].'" target="_blank" style="color: #000000; text-decoration: underline;"><b>'.$row['name'].'</b></a></td>
- <td>'.rasa($row['race'], $row['gender']).'</td>
- <td>'.klasa($row['class']).'</td>
- <td>'.$row['level'].'</td>
- <td>'.lokacja($row['zone']).'</td></tr>';
- }
- $query_players -> closeCursor();
- }
- $query_status-> closeCursor();
- }
- }
- catch(PDOException $e)
- {
- echo 'Połączenie nie mogło zostać utworzone: ' . $e->getMessage();
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement