view.php

<?php
session_start();
$_SESSION['lastpage'] = "/";
$SELF = basename(__FILE__);

/********** PARSE URL OPTIONS **********/

$show = get_param("show", "all");		// filters
$ccg = strtoupper(get_param("ccg", "ALL"));	// country group
$tier = get_param("tier", 2);			// tier
$sort = strtolower(get_param("sort", "host"));	// sort order
$search = $_POST['search'];
//if ($search) { $show = ""; $ccg = ""; }

//echo "$search<br>\n";
//echo time()."<br>\n";
//echo "SESSION<pre>"; print_r($_SESSION); echo "</pre>";
//echo "COOKIE<pre>"; print_r($_COOKIE); echo "</pre>";


/********** LOAD DATA TO DISPLAY PAGE **********/

include("config.php");
$pagetitle = "OpenNIC Public Servers";
include("CC.php");
if (($ccg != "ALL") && (! $ccTLD[$ccg])) $ccg = "ALL";


// Check if user is T1 op
$dn = "o=admins,".$LDAP['base'];
$filter = "tier1operator=".$_SESSION['user_dn'];
$attr = array("tier1operator");
$ldapbind = ldap_bind($LDAP['conn'], $LDAP['admin_dn'], $LDAP['admin_pass']);
$query = @ldap_search($LDAP['conn'], $dn, $filter, $attr);
$res = @ldap_get_entries($LDAP['conn'], $query);
if ($res['count']) $ADMIN = true;


// Get list of all servers //
$dn = "o=servers,".$LDAP['base'];
$filter = "(opennicserverrole=tier$tier)";
if ($search) {
  $search = preg_replace('/\*/', '', $search);
  $filter = "(&$filter(|";
  $filter .= "(dc=*$search*)";
  $filter .= "(arecord=*$search*)";
  $filter .= "(aaaarecord=*$search*)";

  $dx = "o=users,".$LDAP['base'];
  $fx = "uid=*$search*";
  $ax = array("uid");

  $query = ldap_search($LDAP['conn'], $dx, $fx, $ax);
  $uid = ldap_get_entries($LDAP['conn'], $query);
  unset($uid['count']);
//echo "<pre>"; print_r($uid); echo "</pre>"; die;
  foreach((array)$uid as $ux)  $filter .= "(manager=".$ux['dn'].")";
  //$filter .= "(manager=uid=$search,o=users,".$LDAP['base'].")";
  $filter .= "))";
}
if ($show == "mine")
  $filter = "(&$filter(manager=".$_SESSION['user_dn']."))";
  else if ($show) {
    $zs = "(zonestatus=$show)";
    if ($show == "new") $zs .= "(zonestatus=updated)";
    if ($show == "updated") $zs .= "(zonestatus=new)";
    if ($show == "updt") $zs .= "(zonestatus=new)(zonestatus=updated)";
    if ($show == "fail") $zs .= "(zonestatus=down)(zonestatus=offline)";
    if ($show == "down") $zs .= "(zonestatus=fail)(zonestatus=offline)";
    if ($show == "offline") $zs .= "(zonestatus=fail)(zonestatus=down)";
    if ($show == "err") $zs .= "(zonestatus=fail)(zonestatus=down)(zonestatus=offline)";
    $filter = "(&$filter(|$zs))";
  }
if ((! $ADMIN) && (! $show)) $filter = "(&$filter(!(zonestatus=deleted)))";
//echo "FILTER: $filter<br>";
$attr = array("*", "createtimestamp");

$query = @ldap_search($LDAP['conn'], $dn, $filter, $attr);
@ldap_sort($LDAP['conn'], $query, "dc");
$servers = @ldap_get_entries($LDAP['conn'], $query);
unset($servers['count']);
if (count($servers)) uasort($servers, "sort$sort");

//echo "<pre>"; print_r($servers); echo "</pre>"; die;

$count = 0;
//echo "Show: '$show'";
foreach ((array)$servers as $id => $srv) {
  $stat = strtoupper($srv['zonestatus'][0]);
  if ($stat != "DELETED")  $count++;

  $btn = $stat;
  if (! $show) {
    if (($btn=="NEW") || ($btn=="UPDATED")) $btn = "UPDT";
    if (($btn=="FAIL") || ($btn=="DOWN") || ($btn=="OFFLINE")) $btn = "ERR";
  }
  $stats[$btn]++;
  if ($srv['manager'][0] == $_SESSION['user_dn']) $stats['MINE']++;

  if ($tier == 2) {
    preg_match('#(.*)\.([a-z]{1,3})(\.dns?)\.opennic\.glue#i', $srv['dc'][0], $match);
    $cc = strtoupper($match[2]);
    if ($ccTLD[$cc]) $CC[$cc][] = $srv;
  } else $CC["T$tier"][] = $srv;
}
//echo "<pre>"; print_r($CC); echo "</pre>"; die;
//echo "<pre>"; print_r($stats); echo "</pre>";


/********** FUNCTIONS **********/

function get_param($parm, $default="") {
  global $SELF;
  $cookie_expire = 604800;	// Value in seconds

  if ($val = strtolower($_GET[$parm])) {
    if ($val == $default) unset($_SESSION[$parm], $_COOKIE[$parm]);
    setcookie($parm, $val, time() + $cookie_expire);
    $_SESSION[$parm] = $val;
    header("Location: .");
  }
  if (($val = $_SESSION[$parm]) === false) $val = $_COOKIE[$parm];
//echo "[$parm] '$val'<br>";
  if ($parm == "show") $default = "";
  if (($parm == "show") && (strtolower($val) == "all")) $val = "";
  if ($val == "") {
    unset($_SESSION[$parm], $_COOKIE[$parm]);
    $val = $default;
  } else {
    $_SESSION[$parm] = $val;
    setcookie($parm, $val, time() + $cookie_expire);
  }
  return $val;
}

function DMStoDEC($deg,$min,$sec) {
  // Converts degrees/minutes/seconds to decimal format
  return $deg+((($min*60)+($sec))/3600);
}

function DECtoDMS($dec) {
  // Converts decimal format to degrees/minutes/seconds
  $vars = explode(".",$dec);
  $deg = $vars[0];
  $tempma = "0.".$vars[1];

  $tempma = $tempma * 3600;
  $min = floor($tempma / 60);
  $sec = $tempma - ($min*60);

  return array("deg"=>$deg,"min"=>$min,"sec"=>$sec);
}

function button($val) {
  if (is_array($val)) $val = $val[0];
  $val = strtoupper($val);
  $bool = 0;
  if ($val > 0) $bool = 1;
  if ($val == "TRUE") $bool = 1;
  return $bool;
}

function sorthost($a, $b) {
  $pcsA = explode(".", $a['dc'][0]);
  unset($a0, $a1, $a2, $a3);
  $a2 = trim($pcsA[0], "ns");
  $a0 = $pcsA[1];
  if ($pcsA[0] == "ipv6") { $a0="";  $a2=trim($pcsA[1],"ns"); $a3=$pcsA[0]; }
  if (count($pcsA) > 2) { $a0=$pcsA[2]; $a1=$pcsA[1]; }
  if ($a0 == "dns") { $a0=$a1; $a1=$a2; $a2=""; }

  $pcsB = explode(".", $b['dc'][0]);
  unset($b0, $b1, $b2, $b3);
  $b2 = trim($pcsB[0], "ns");
  $b0 = $pcsB[1];
  if ($pcsB[0] == "ipv6") { $b0=""; $b2=trim($pcsB[1],"ns"); $b3=$pcsB[0]; }
  if (count($pcsB) > 2) { $b0=$pcsB[2]; $b1=$pcsB[1]; }
  if ($b0 == "dns") { $b0=$b1; $b1=$b2; $b2=""; }

//  echo "[$a0][$a1][$a2] -- [$b0][$b1][$b2]<br>";

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);

  if ($a1 < $b1) return (-1);
  if ($a1 > $b1) return (1);

  if ($a2 < $b2) return (-1);
  if ($a2 > $b2) return (1);

  if ($a3 < $b3) return (-1);
  if ($a3 > $b3) return (1);

  return (0);
}

function sortownr($a, $b) {
  $a0 = $a['manager'];
  $b0 = $b['manager'];

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);
  return (0);
}

function sortipv4($a, $b) {
  $a0 = $a['arecord'];
  $b0 = $b['arecord'];

  if ((! $a0) && (! $b0)) return sorthost($a, $b);
  if (! $a0) return 1;
  if (! $b0) return -1;

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);
  return (0);
}

function sortipv6($a, $b) {
  $a0 = $a['aaaarecord'];
  $b0 = $b['aaaarecord'];

  if ((! $a0) && (! $b0)) return sorthost($a, $b);
  if (! $a0) return 1;
  if (! $b0) return -1;

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);
  return (0);
}

function sortstat($a, $b) {
  $a0 = $a['zonestatus'];
  $b0 = $b['zonestatus'];

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);
  return (0);
}

function sortcrtd($a, $b) {
  $a0 = $a['datecreated'];
  $b0 = $b['datecreated'];

  if ($a0 < $b0) return (-1);
  if ($a0 > $b0) return (1);
  return (0);
}

function sortby($tab, $col) {
  // $tab = name of tab on page
  // $col = code for tab column

  $sort = $_SESSION['sort'];
    if (! $sort) $sort = "host";
  $a0 = ""; $a1 = "";
  $class = "sort";
  if ($col != $sort) {
    $a0 = "<a href='?sort=$col'>";
    $a1 = "</a>";
    $class = "sel";
  }
  echo "<span class='$class $col'>$a0$tab$a1</span>\n";
}

?>
<!DOCTYPE html>
<head>
  <meta content="text/html; charset=UTF-8" http-equiv="content-type">
  <title><?=$pagetitle?></title>
  <link rel="stylesheet" href="style.css" type="text/css" media="all">
  <link rel='icon' type='image/png' href='network.png'>
  <script type="text/javascript">
    function ccg(cc) {
      var obj = document.querySelectorAll("div[name^='ccg[']")
      var dsp = "";
      for (var i=0; i<obj.length; i++) {
        var grp = obj[i].getAttribute("name");
        dsp = ((cc == "all") || ("ccg["+cc+"]" == grp)) ? "table-row-group" : "none";
        obj[i].style.display = dsp;
      }
      httpGet("setcc.php?"+cc);
    }
    function httpGet(url) {
      var xmlHttp = null;
      xmlHttp = new XMLHttpRequest();
      xmlHttp.open( "GET", url, false );
      xmlHttp.send( null );
      return xmlHttp.responseText;
    }
  </script>
</head>

<body onload="document.getElementById('errmsg').style.opacity='0'">
<h3><?=$pagetitle?>
  <div id='search'>
  <form action="." method="post">
<? if ($search) { ?>
  <a href='<?=$SELF?>'><button type='button'>Clear</button></a>
<? } ?>
  <input type='text' name='search' value='<?=$search?>' autofocus=1 title='Search on hostname, IP, or owner'>
  <button type='submit'>Search</button>
</form></div></h3>

<div id="frame">
 <div id="view">
<? if ($_SESSION['user']) { ?>
  <!-- ADMIN BUTTONS -->
  <a href='logoff.php' class='fn r logoff'><button type='button'>Sign off</button></a>
  <a href='new.php' class='fn l' style='margin-right:20px'><button type='button'>Add new server</button></a>
<? } else { ?>
  <a href='login.php' class='fn r login'><button type='button'>Log in</button></a>
<? } ?>

  <!-- TIER BUTTONS -->
  <ul id='tier' class='cbx fn l'>
    <a href='?tier=1'><li onclick="window.location='?tier=1'">
      <input type='radio' id='tier1' name='tier'<?if ($tier==1) echo " checked"?>>
      <label for='tier1'>Tier1</label></li></a>
    <a href='?tier=2'><li onclick="window.location='?tier=2'">
      <input type='radio' id='tier2' name='tier'<?if ($tier==2) echo " checked"?>>
      <label for='tier2'>Tier2</label></li></a>
  </ul>

  <!-- STATUS BUTTONS -->
<?  /********** SHOW STATUS BUTTONS **********/
echo "  <div class='stats'>";
if ($show) {
  if (! $search) echo "<a href='?show=all' class='stats'>";
  echo "<div class='stats mine' title='Click to show all servers'>";
  echo "&nbsp;show ALL servers&nbsp;</div>";
  if (! $search) echo "</a>";
  echo "&nbsp;&nbsp;";
} else if ($_SESSION['user']) {
  if (! $search) echo "<a href='?show=mine' class='stats'>";
  echo "<div class='stats mine' title='Click to show only your servers'>";
  echo "Mine: ".$stats['MINE']."</div>";
  if (! $search) echo "</a>";
  echo "&nbsp;&nbsp;";
}

foreach((array)$STATUS as $id => $val) {
  if ($stats[$id] > 0) {
    if ((! $show) && (! $search)) echo "<a href='?show=$id' class='stats'>";
    echo "<div class='stats'";
    echo " title='".$STATUS[$id]['title']."'>";
    echo $STATUS[$id]['abbr'].": ".$stats[$id];
    echo "</div>";
    if ((! $show) && (! $search)) echo "</a>";
  }
}
echo "&nbsp;&nbsp;<div class='stats mine'>Total: $count</div></div>\n";


/********** SHOW ERROR MESSAGE **********/
$err = $_SESSION['err'];
if (! $err) $err = "&nbsp;";
unset($_SESSION['err']);
echo "  <div id='errmsg' class='err'>$err</div>\n";


/********** SHOW COUNTRY BUTTONS **********/
if (($tier != 1) && (! $show) && (! $search)) {
  $ht = 33 * (1 + intval((count($CC)+1.5) / 27.5));
?>

  <!-- COUNTRY CODE BUTTONS -->
  <div id='ccg' style='height:<?=$ht?>px;'>
  <ul id='cc' class='cbx'>
    <li style='width:44px' onclick="ccg('all')">
    <input type='radio' id='cc[all]' name='cc'<?if($ccg=="ALL") echo " checked"?>>
    <label for='cc[all]'>&lt;ALL&gt;</label></li>
<?
  foreach((array)$CC as $cc => $val) {
    echo "    <li onclick=\"ccg('$cc')\" title=\"" . $ccTLD[$cc] . "\">";
    echo "<input type='radio' id='cc[$cc]' name='cc'";
    if ($ccg == $cc) echo " checked";
    echo "><label for='cc[$cc]'>$cc</label></li>\n";
  }
?>
  </ul>
  </div>
<? } ?>

  <!-- DISPLAY TABLE OF SERVERS -->
  <div id='srvlist'>
    <p class='th'>
      <button class='bttn'></button>
<? /*
      <button></button>
      <button></button>
*/ ?>
      <? sortby("Hostname <label>(Click for details)</label>", "host"); ?>
      <? sortby("IPv4", "ipv4"); ?>
      <? sortby("IPv6", "ipv6"); ?>
      <? sortby("Owner(s)", "ownr"); ?>
      <? sortby("Added", "crtd"); ?>
      <? sortby("Status", "stat"); ?>
    </p>
<? /********** SHOW SERVERS, GROUPED BY COUNTRY **********/
foreach ((array)$CC as $grp => $grpcc) {
  $dis = "table-row-group";
  if (($tier == 2) && ($ccg != "ALL") && ($ccg != $grp) && (! $show) && (! $search)) $dis = "none";
  echo "    <div name='ccg[$grp]' style='display:$dis;'>\n";
  foreach ((array)$grpcc as $srv) {
    $status = strtoupper($srv['zonestatus'][0]);
      if (! $status) $status = "PASS";
    if (($status == "DELETED") && (! $show)) continue;
    $dc = $srv['dc'][0];
    $short = preg_replace('#(?:\.dns)\.opennic\.glue#', '', $dc);
    $desc = $srv['description'][0];

    unset($owner, $srv['manager']['count']);
    $alt = array();
    foreach((array)$srv['manager'] as $key => $mng) {
      preg_match('#uid=([a-z0-9]*)#i', $mng, $match);
      if ($match[1]) {
        $owner[$key] = $match[1];
        foreach((array)$srv['displayname'] as $val) {
          $tmp = explode("=", $val);
          if ($tmp[0] == $match[1]) $alt[$key] = $tmp[1];
        }
      }
    }

    $location = $srv['locrecordtxt'][0];
/*
    $LOC = explode(" ", $srv['locrecord'][0]);
    $tmp = $LOC[0]; if (strtoupper($LOC[4]) == "S") $tmp = -$tmp;
    $lat = DMStoDEC($tmp, $LOC[1], $LOC[2]);
    $tmp = $LOC[4]; if (strtoupper($LOC[7]) == "E") $tmp = -$tmp;
    $lon = DMStoDEC($tmp, $LOC[5], $LOC[6]);
*/
    $logpol = $srv['loggingpolicy'][0];
      $logpol = preg_replace('/"/', '&quot;', $logpol);

    unset($srv['arecord']['count']);
    unset($ip4, $ip6);
    if ($ADMIN)  foreach((array)$srv['arecord'] as $key => $val)
      $srv['arecord'][$key] = "<a href='http://report.opennicproject.org/t2log/t2.php?ip_addr=$val' target='_blank'>$val</a>";
    if (count($srv['arecord'])) $ip4 = implode("<br>", $srv['arecord']);
    if (! $ip4) $ip4 = "&nbsp;";
    unset($srv['aaaarecord']['count']);
    foreach((array)$srv['aaaarecord'] as $key => $val) {
      $wbr = preg_replace('/:/', ':<wbr>', $val);
      if ($ADMIN)
        $srv['aaaarecord'][$key] = "<a href='http://report.opennicproject.org/t2log/t2.php?ip_addr=$val' target='_blank'>$wbr</a>";
        else $srv['aaaarecord'][$key] = $wbr;
    }
    if (count($srv['aaaarecord'])) $ip6 = implode("<br>", $srv['aaaarecord']);
    if (! $ip6) $ip6 = "&nbsp;";

    // Get extra info for admins
    if ($ADMIN) {
      $dn = "o=users,".$LDAP['base'];
      $attr = array("mail");
      unset($mail);
      foreach((array)$owner as $mng) {
        $filter = "uid=$mng";
        $query = @ldap_search($LDAP['conn'], $dn, $filter, $attr);
        $res = @ldap_get_entries($LDAP['conn'], $query);
        $mail[] = ($res['count']) ? $res[0]['mail'][0] : "";
      }
    }

    $class = $STATUS[$status]['css'] . " ";
    foreach((array)$srv['manager'] as $mng)
      if ($_SESSION['user_dn'] == $mng) { $class .= "mine "; break; }
    if ($class = trim($class, " ")) $class = " class='$class'";
    echo "   <p$class><span>";
    echo "<button disabled class=btn" . button($srv['logginganonymous']) . " title=\"$logpol\">Log Anon</button>";
    echo "<button disabled class=btn" . button($srv['usewhitelisting']) . ">Whitelist</button>";
    echo "<button disabled class=btn" . button($srv['usednscrypt']) . ">DNSCrypt</button>";
    echo "</span>";

    $tmp = $desc;
    if ($location) $tmp = trim("($location) $tmp");
    $tmp = preg_replace('/"/', '&quot;', $tmp);
    echo "<span class='host' title=\"$tmp\"><a id='$dc' href='edit.php?srv=$dc'>$dc</a></span>";
    $ports = "";
    if ($srv['listenport']['count']) {
      unset($srv['listenport']['count']);
      $ports = implode(", ", $srv['listenport']);
      if ($ports) $ports = "title='Additional ports: $ports'";
    }
    echo "<span class='mono ipv4'$ports>$ip4</span>";
    $ports = "";
    if ($srv['listenport6']['count']) {
      unset($srv['listenport6']['count']);
      $ports = implode(", ", $srv['listenport6']);
      if ($ports) $ports = "title='Additional ports: $ports'";
    }
    echo "<span class='mono ipv6'$ports>$ip6</span>";

    //echo "<span>$lat</span>";
    //echo "<span>$lon</span>";

    echo "<span class='ownr'>";
    foreach((array)$owner as $key => $val) {
      if ($alt[$key]) $val = $alt[$key];
      if (($ADMIN) && ($m = $mail[$key])) {
        echo "<a class='mail' href='mailto:$m'>$val</a><br>";
      } else echo "$val<br>";
    }
    echo "</span>";

    //$ts = $srv['datecreated'][0];
    if (! $ts = $srv['datecreated'][0]) $ts = $srv['createtimestamp'][0];
    $up = ($ts) ? gmdate("Y-M-d", strtotime($ts)) : "";
    echo "<span class='crtd'>$up</span>";

    $down = "";
    if ($tm = strtotime($srv['zonestatussince'][0])) {
      $df = diffdate($tm);
      $down = " since " . gmdate("M d, H:i", $tm) . " UTC";
      if ($str = $df['string']) $down .= " ($str)";
    }
    echo "<span class='stat'";
    if ($title = $STATUS[$status]['title']) echo " title='$title$down'";
    echo ">" . $STATUS[$status]['button'] . "</span>";
    echo "</p>\n";
  }
  echo "    </div>\n";
}
?>
  </div>
  <br>
  <div><i>Click server hostname to view full details</i></div>
 </div>
</div>

<!-- ADDITION INFORMATION -->
<div class='instr'>
Some features on this page require javascript.
Servers which are offline or fail testing for more than 48 hours
will be automatically moved to a &quot;pending deletion&quot; status.
If you resolve the issue and wish to have your server re-listed, please
ask a Tier-1 operator to update the status.
</div>

</body>
</html>