Uplinkkart

From 1670071c058a2676a4a880a93acd57b35d6dc24e Mon Sep 17 00:00:00 2001 From: Joachim Tingvold Date: Fri, 25 Mar 2016 15:25:16 +0100 Subject: Moved old NMS-files to historical. --- .../web/nms.gathering.org/uplinkkart-text.pl | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100755 examples/historical/web/nms.gathering.org/uplinkkart-text.pl (limited to 'examples/historical/web/nms.gathering.org/uplinkkart-text.pl') diff --git a/examples/historical/web/nms.gathering.org/uplinkkart-text.pl b/examples/historical/web/nms.gathering.org/uplinkkart-text.pl new file mode 100755 index 0000000..c4b31a9 --- /dev/null +++ b/examples/historical/web/nms.gathering.org/uplinkkart-text.pl @@ -0,0 +1,38 @@ +#! /usr/bin/perl +use CGI; +use DBI; +use lib '../../include'; +use nms; +my $cgi = CGI->new; + +my $dbh = nms::db_connect(); +print $cgi->header(-type=>'text/html; charset=utf-8', -refresh=>'10; ' . CGI::url()); + +print <<"EOF"; + + + Uplinkkart + + + +EOF + +my $q = $dbh->prepare("SELECT * FROM switches NATURAL JOIN placements WHERE switchtype = 'ex2200'"); +$q->execute(); +while (my $ref = $q->fetchrow_hashref()) { + $ref->{'placement'} =~ /$(\d+),(\d+)$,$(\d+),(\d+)$/; + + my $ttext = 'FIXME: Put something here'; + printf " \n", + $3, $4, $1, $2, $ref->{'switch'}, $ref->{'sysname'}, + $ttext, $ref->{'sysname'}, $ttext; +} +$dbh->disconnect; + +print <<"EOF"; + + +

+ + +EOF -- cgit v1.2.3