View difference between Paste ID: tgD4CqzB and hFacmAMb
SHOW: | | - or go back to the newest paste.
1
<?php
2
$server_ip = "localhost";
3
   $mysql_user = "";
4
   $mysql_pass = "";
5
   $database = "";
6
   
7
   $connect = mysql_connect("$server_ip", "$mysql_user", "$mysql_pass") or die(mysql_error()); 
8
   $db_select = mysql_select_db("$database", $connect) or die(mysql_error());
9
   $gm_list = mysql_query("SELECT char_name,accesslevel,online FROM characters WHERE accesslevel>=1") or die(mysql_error()) ;
10
   
11
   echo'<table border="0">';
12
   while($row=mysql_fetch_array($gm_list)){
13
      $nick = $row['char_name'];
14
      $online = $row['online'];
15
         if($online == 1){
16-
            $online = 'Online;
16+
            $online = '<font style='color:green'>Online</font>;
17
         }else{
18-
               $online = 'Offline';
18+
               $online = '<font style='color:red'>Offline</font>';
19
            }
20
      echo'<tr><td>'.$nick.'</td><td>['.$online.']</td></tr>';
21
      
22
   }
23
   echo'</table>';
24
   mysql_close($connect);
25
?>