SSYT

Server Stats Live

Nov 8th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.16 KB | None | 0 0
  1. <?php
  2.     include_once 'includes/class_connection.php';
  3.     include_once 'includes/class_functions.php';
  4.     header("Cache-Control: no-cache, must-revalidate");
  5.     header("Expires: Sat, 26 Jul 1997 05:00:00 GMT");
  6.     header("Access-Control-Allow-Origin: http://www.frannnta-design.com");
  7.    
  8.     $servers_data = $PDO->query('SELECT * FROM server_stats');
  9.     $active_servers = $PDO->query('SELECT * FROM server_stats WHERE activate = 1');
  10.     $padding_servers = $PDO->query('SELECT * FROM server_stats WHERE activate = 0');
  11.    
  12.     if($_GET['mode'] == "get_servers")
  13.     {
  14.         $getservers = 'Active Servers: ' . $active_servers->rowCount() . ' | ';
  15.         $getservers .= 'Pending Servers: ' . $padding_servers->rowCount() . '';
  16.         echo "document.write('". $getservers ."')";
  17.     }
  18.    
  19.     # Get active servers of database
  20.     # active_servers
  21.     if($_GET['mode'] == "active_servers")
  22.     {
  23.         if($active_servers->rowCount() > 0)
  24.         {
  25.             while($server_info = $active_servers->fetch(PDO::FETCH_ASSOC))
  26.             {
  27.                 if($server_info['activate'] == 1) $status = '<b><font style="color: green;">Activat</font></b>';
  28.                 $sv_data_active .= '<tr id="server_row"><td colspan="2">#'. $server_info['id'] .'</td><td colspan="2" class="hostname">'. $q['hostname'] .' <a class="btn-stats" href="?mode=live_stats">Live Stats</a></td><td colspan="2">0 / '. $server_info['slots'] .'</td><td colspan="2" class="ip_row">'. $server_info['ip'] .':27015</td><td colspan="2" class="map">'. $q['map'] .'</td><td colspan="2">'. $status .'</td></tr>';
  29.             }
  30.         } else
  31.             $sv_data_active = "Nu au fost gasite server active !";
  32.     }
  33.    
  34.     # Get no active servers of database
  35.     # inactive_servers
  36.     if($_GET['mode'] == "inactive_servers")
  37.     {
  38.         if($padding_servers->rowCount() > 0)
  39.         {
  40.             $sv_data_inactive = '<table class="servere" width="98%" border="1" cellpading="0" cellspacing="0">';
  41.                 $sv_data_inactive .= '<tr><th>Nume server</th><th>Adresa ip</th><th>Sloturi</th><th>Mod</th><th>Status</th></tr>';
  42.                 while($server_data = $padding_servers->fetch(PDO::FETCH_ASSOC))
  43.                 {
  44.                     if($server_data['activate'] == 0)
  45.                         $status = '<b><font style="color: #FFC107;">In Asteptare</font></b>';
  46.                     $sv_data_inactive .= '<tr><td>'. $server['hostname'] .'</td><td>'. $server['map'] .'</td><td>'. $server['slots'] .'</td><td>'. $server['mode'] .'</td><td>'. $status .'</td></tr>';
  47.                 }
  48.             $sv_data_inactive .= '</table>';
  49.         } else
  50.             $sv_data_inactive = "Nu au fost gasite server inactive !";
  51.     }
  52.    
  53.     # Add server to datebase from post
  54.     # add_servers
  55.     if($_GET['mode'] == "add_servers")
  56.     {  
  57.         if(isset($_POST['server_name']))
  58.         {
  59.             $post_data_name = $_POST['server_name'];
  60.             $post_data_ip = $_POST['server_ip'];
  61.             $post_data_mode = $_POST['server_mode'];
  62.             $post_data_slots = $_POST['server_slots'];
  63.             $post_data_email = $_POST['server_email'];
  64.                
  65.             $add = $PDO->query('INSERT INTO server_stats (`sv_name`, `ip`, `slots`, `mod`, `activate`, `contact`) VALUES ("'.$post_data_name.'","'.$post_data_ip.'","'.$post_data_slots.'","'.$post_data_mode.'","0","'.$post_data_email.'")');
  66.                
  67.             # Send email for activate server !
  68.             # activate_server
  69.             $to = "". $_POST['server_email'] ."";
  70.             $subject = 'Servers.ro | Server activation';
  71.             $message = 'Server: '. $post_data_name .'' . "\r\n" . '<a href="http://forumotiondb.tk/FD%20Servers/index.php?action=activate_server&server='. $post_data_name .'&token='. tokenKeys(32) .'">Activeaza Server</a>';
  72.             $headers  = 'MIME-Version: 1.0' . "\r\n";
  73.             $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
  74.             $headers .= "From: server@frannnta-design.com";
  75.             mail($to, $subject, $message, $headers);
  76.         }
  77.     }
  78.  
  79.     $sv_data_form = '<form method="POST" id="submit_server">';
  80.         $sv_data_form .= '<input type="text" maxlength="128" name="server_name" placeholder="CS.SERVER.RO" />';
  81.         $sv_data_form .= '<input type="text" min="16" max="16" maxlength="16" name="server_ip" placeholder="127.0.0.1" />';
  82.         $sv_data_form .= '<input type="number" min="14" max="32" maxlength="2" name="server_slots" placeholder="32" />';
  83.         $sv_data_form .= '<input type="text" maxlength="10" name="server_mode" placeholder="Clasic" />';
  84.         $sv_data_form .= '<input type="email" maxlength="255" name="server_email" placeholder="exemple@server.ro" />';
  85.  
  86.         $sv_data_form .= '<input type="submit" name="submit" value="Add Server" />';
  87.     $sv_data_form .= '</form>';
  88. ?>
  89. <?php
  90.  
  91. function getServerData($ip)
  92. {
  93.     //$qy = server_source_query($ip);
  94.     //$q = server_read_query($qy);
  95.     $hostname = "de_dust";
  96.     echo $hostname;
  97. }
  98. ?>
  99.  
  100. document.write("<script type=\"text/javascript\">$('#server_row').each(function() {var ip_addres = $('.ip_row', this).text();$('.hostname').html('<?php getServerData("'+ ip_addres +'"); ?>');});</script>");
  101.  
  102. <?php
  103. if($_GET['mode'] == "active_servers")
  104. {
  105. ?>
  106.     document.write('<?=$sv_data_active;?>');
  107. <?
  108. } else if($_GET['mode'] == "inactive_servers")
  109. {
  110. ?>
  111.     document.write('<?=$sv_data_inactive;?>');
  112. <?
  113. } else if($_GET['mode'] == "add_servers")
  114. {
  115. ?>
  116.     document.write('<?=$sv_data_form;?>');
  117. <?
  118. }
  119. ?>
  120.  
  121. <?php
  122.  
  123. function getServerDatax($ip)
  124. {
  125.     $qy = server_source_query($ip);
  126.     $q = server_read_query($qy);
  127.     $sv = $q['map'];
  128.     echo $sv;
  129. }
  130. ?>
  131. document.write("<?php getServerDatax("93.119.24.47:27015"); ?>");
Add Comment
Please, Sign In to add comment