1: 2: /* ------------------------------------------------------------- 3: This file is part of FreeNATS 4: 5: FreeNATS is (C) Copyright 2008 PurplePixie Systems 6: 7: FreeNATS is free software: you can redistribute it and/or modify 8: it under the terms of the GNU General Public License as published by 9: the Free Software Foundation, either version 3 of the License, or 10: (at your option) any later version. 11: 12: FreeNATS is distributed in the hope that it will be useful, 13: but WITHOUT ANY WARRANTY; without even the implied warranty of 14: MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 15: GNU General Public License for more details. 16: 17: You should have received a copy of the GNU General Public License 18: along with FreeNATS. If not, see www.gnu.org/licenses 19: 20: For more information see www.purplepixie.org/freenats 21: -------------------------------------------------------------- */ 22: 23: ob_start(); 24: require("include.php"); 25: $NATS->Start(); 26: if (!$NATS_Session->Check($NATS->DB)) 27: { 28: header("Location: ./?login_msg=Invalid+Or+Expired+Session"); 29: exit(); 30: } 31: if ($NATS_Session->userlevel<5) UL_Error("Edit View"); 32: 33: function chs($var,$def=0) 34: { 35: if (isset($_REQUEST[$var])) return ss($_REQUEST[$var]); 36: else return $def; 37: } 38: 39: 40: if (isset($_REQUEST['action'])) 41: { 42: switch ($_REQUEST['action']) 43: { 44: case "create": 45: $q="INSERT INTO fnview(vtitle,vclick,vstyle) VALUES(\"".ss($_REQUEST['vtitle'])."\",\"standard\",\"standard\")"; 46: $NATS->DB->Query($q); 47: $_REQUEST['viewid']=$NATS->DB->Insert_Id(); 48: $_REQUEST['show_options']=1; 49: $msg="Created View"; 50: break; 51: 52: case "delete": 53: if (!isset($_REQUEST['confirmed'])) 54: { 55: $back=urlencode("view.edit.php?action=delete&confirmed=1&viewid=".$_REQUEST['viewid']); 56: $link="confirm.php?action=Delete+View&back=".$back; 57: header("Location: ".$link); 58: exit(); 59: } 60: // otherwise delete 61: $qi="DELETE FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid']); 62: $NATS->DB->Query($qi); 63: $idel=$NATS->DB->Affected_Rows(); 64: $q="DELETE FROM fnview WHERE viewid=".ss($_REQUEST['viewid']); 65: $NATS->DB->Query($q); 66: $vdel=$NATS->DB->Affected_Rows(); 67: $msg="Deleted ".$vdel." Views (".$idel." Items)"; 68: header("Location: main.php?message=".urlencode($msg)); 69: exit(); 70: break; 71: 72: case "save_edit": 73: if (isset($_REQUEST['vpublic'])) $public=1; 74: else $public=0; 75: if (isset($_REQUEST['vcolon'])) $colon=1; 76: else $colon=0; 77: if (isset($_REQUEST['vdashes'])) $dashes=1; 78: else $dashes=0; 79: if (isset($_REQUEST['vtimeago'])) $ago=1; 80: else $ago=0; 81: if (!is_numeric($_REQUEST['vrefresh'])) $vref=0; 82: else $vref=ss($_REQUEST['vrefresh']); 83: $q="UPDATE fnview SET vtitle=\"".ss($_REQUEST['vtitle'])."\",vstyle=\"".ss($_REQUEST['vstyle'])."\","; 84: $q.="vclick=\"".ss($_REQUEST['vclick'])."\",vpublic=".$public.",vlinkv=".ss($_REQUEST['vlinkv']).",vrefresh=".$vref; 85: $q.=",vcolumns=".ss($_REQUEST['vcolumns']).",vdashes=".$dashes.",vcolon=".$colon.",vtimeago=".$ago; 86: $q.=" WHERE viewid=".ss($_REQUEST['viewid']); 87: $NATS->DB->Query($q); 88: if ($NATS->DB->Affected_Rows()<=0) $msg="Failed to update or nothing changed"; 89: else $msg="Saved changes ok"; 90: break; 91: 92: case "create_item": 93: $wq="SELECT iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." ORDER BY iweight DESC LIMIT 0,1"; 94: $wr=$NATS->DB->Query($wq); 95: if ($row=$NATS->DB->Fetch_Array($wr)) 96: { 97: $iweight=$row['iweight']+10; 98: } 99: else $iweight=10; 100: $NATS->DB->Free($wr); 101: 102: if (isset($_REQUEST['iname'])) $iname=ss($_REQUEST['iname']); 103: else $iname=""; 104: 105: $itype=ss($_REQUEST['itype']); 106: if ($itype=="node") $ioption=ss($_REQUEST['ioption_node']); 107: else if($itype=="group") $ioption=ss($_REQUEST['ioption_group']); 108: else if($itype=="testgraph") $ioption=ss($_REQUEST['ioption_testgraph']."/".$_REQUEST['ioption_testgraph_time']); 109: else if($itype=="testdetail") 110: { 111: $ioption=ss($_REQUEST['ioption_testdetail']); 112: $iname=ss($_REQUEST['iname_testdetail']); 113: } 114: else if($itype=="title") $ioption=ss($_REQUEST['ioption_title']); 115: else $ioption=""; 116: $q="INSERT INTO fnviewitem(viewid,itype,ioption,iweight,iname) VALUES(".ss($_REQUEST['viewid']).","; 117: $q.="\"".$itype."\",\"".$ioption."\",".$iweight.",\"".$iname."\")"; 118: $NATS->DB->Query($q); 119: if ($NATS->DB->Affected_Rows()>0) $msg="Created Item"; 120: else $msg="Create Item Failed"; 121: break; 122: 123: case "del_item": 124: $q="DELETE FROM fnviewitem WHERE viewitemid=".ss($_REQUEST['viewitemid']); 125: $NATS->DB->Query($q); 126: if ($NATS->DB->Affected_Rows()>0) $msg="Deleted Item"; 127: else $msg="Delete Item Failed"; 128: break; 129: 130: case "save_view_item": 131: $icol=chs("icolour",0); 132: $itxt=chs("itextstatus",0); 133: $isize=chs("isize",0); 134: $igraphic=chs("igraphic",0); 135: $idetail=chs("idetail",0); 136: $q="UPDATE fnviewitem SET "; 137: $q.="icolour=".$icol.","; 138: $q.="itextstatus=".$itxt.","; 139: $q.="isize=".$isize.","; 140: $q.="igraphic=".$igraphic.","; 141: $q.="idetail=".$idetail." "; 142: $q.="WHERE viewitemid=".ss($_REQUEST['viewitemid']); 143: $NATS->DB->Query($q); 144: //echo $q; 145: if ($NATS->DB->Affected_Rows()<=0) $msg="Save Failed or Nothing Changed"; 146: else $msg="Saved Item Changes"; 147: break; 148: 149: case "move_item": 150: if (isset($_REQUEST['dir'])) $dir=$_REQUEST['dir']; 151: else $dir="up"; 152: 153: $mywq="SELECT iweight FROM fnviewitem WHERE viewitemid=".ss($_REQUEST['viewitemid']); 154: $mywr=$NATS->DB->Query($mywq); 155: $row=$NATS->DB->Fetch_Array($mywr); 156: $myweight=$row['iweight']; 157: $NATS->DB->Free($mywr); 158: 159: if ($dir=="up") // get the next lowest one down 160: { 161: $q="SELECT viewitemid,iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." AND iweight<".$myweight." "; 162: $q.="ORDER BY iweight DESC LIMIT 0,1"; 163: $r=$NATS->DB->Query($q); 164: if ($row=$NATS->DB->Fetch_Array($r)) // found one to swap with 165: { 166: $uq="UPDATE fnviewitem SET iweight=".$myweight." WHERE viewitemid=".$row['viewitemid']; 167: $NATS->DB->Query($uq); 168: $uq="UPDATE fnviewitem SET iweight=".$row['iweight']." WHERE viewitemid=".ss($_REQUEST['viewitemid']); 169: $NATS->DB->Query($uq); 170: $msg="Moved Item"; 171: } 172: else $msg="Nowhere to Move Item To"; 173: } 174: else if ($dir=="down") // get the next highest 175: { 176: $q="SELECT viewitemid,iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." AND iweight>".$myweight." "; 177: $q.="ORDER BY iweight DESC LIMIT 0,1"; 178: $r=$NATS->DB->Query($q); 179: if ($row=$NATS->DB->Fetch_Array($r)) // found one to swap with 180: { 181: $uq="UPDATE fnviewitem SET iweight=".$myweight." WHERE viewitemid=".$row['viewitemid']; 182: $NATS->DB->Query($uq); 183: $uq="UPDATE fnviewitem SET iweight=".$row['iweight']." WHERE viewitemid=".ss($_REQUEST['viewitemid']); 184: $NATS->DB->Query($uq); 185: $msg="Moved Item"; 186: } 187: else $msg="Nowhere to Move Item To"; 188: } 189: 190: break; 191: 192: default: $msg="Unknown Action"; 193: } 194: } 195: 196: ob_end_flush(); 197: Screen_Header("View Editor",1); 198: 199: 200: $q="SELECT * FROM fnview WHERE viewid=".ss($_REQUEST['viewid'])." LIMIT 0,1"; 201: $r=$NATS->DB->Query($q); 202: if (!$row=$NATS->DB->Fetch_Array($r)) 203: { 204: echo "No such view.
"; 205: Screen_Footer(); 206: exit(); 207: } 208: 209: $NATS->DB->Free($r); 210: if (isset($msg)) 211: { 212: echo "".$msg."
"; 213: $poplist[]=$msg; 214: } 215: 216: echo "
| "; 217: echo "Editing View: ".$row['vtitle'].""; 218: echo " | Preview View / "; 219: echo "Link to View"; 220: echo " |
"; 222: 223: echo "224: echo "
";
225: echo "";
226:
227: echo "";
228: echo "";
229:
230: echo "
";
328: echo "
";
329: echo "";
330: echo "\n\n";
339:
340: //echo "| View Title"; 231: echo " | "; 232: echo ""; 233: echo " |
| | |
| Public View | "; 237: echo ""; 238: if ($row['vpublic']==1) $s=" checked"; 239: else $s=""; 240: echo " ".hlink("View:Public"); 241: echo " |
| | |
| Page Style | "; 245: echo "";
246: if ($row['vstyle']=="standard") $s=" checked";
247: else $s="";
248: echo " Standard "; 249: echo "Standard full-page headers and footers with "local" page and style includes "; 250: if ($row['vstyle']=="mobile") $s=" checked"; 251: else $s=""; 252: echo " Mobile/Minimal "; 253: echo "Very minimal and absolute page style suitable for mobile browser and/or inline JS usage "; 254: if ($row['vstyle']=="plain") $s=" checked"; 255: else $s=""; 256: echo " Plain "; 257: echo "Totally plain output "; 258: 259: echo " |
| Link Types | "; 262: echo "";
263: if ($row['vclick']=="standard") $s=" checked";
264: else $s="";
265: echo " Standard "; 266: echo "Standard a href links for same window/frame "; 267: if ($row['vclick']=="frametop") $s=" checked"; 268: else $s=""; 269: echo " Same Window (Frame Top) "; 270: echo "a href link to the window/frame top "; 271: if ($row['vclick']=="newwindow") $s=" checked"; 272: else $s=""; 273: echo " New Window "; 274: echo "Open a New Window "; 275: if ($row['vclick']=="disabled") $s=" checked"; 276: else $s=""; 277: echo " Disabled "; 278: echo "No links (disabled) "; 279: if ($row['vlinkv']==0) $s=""; else $s=" selected"; 280: $lq="SELECT viewid,vtitle FROM fnview WHERE viewid!=".ss($_REQUEST['viewid']); 281: $lr=$NATS->DB->Query($lq); 282: echo "Links to Another View: "; 283: echo "284: echo ""; 285: while ($lrow=$NATS->DB->Fetch_Array($lr)) 286: { 287: if ($lrow['viewid']==$row['vlinkv']) $s=" selected"; 288: else $s=""; 289: echo ""; 290: } 291: echo " ".hlink("View:LinkAnotherView")." "; 292: $NATS->DB->Free($lr); 293: echo " |
| Colons (before text status) | "; 296: echo ""; 297: if ($row['vcolon']==1) $s=" checked"; 298: else $s=""; 299: echo " ".hlink("View:Colons"); 300: echo " |
| Dashes (before times) | "; 303: echo ""; 304: if ($row['vdashes']==1) $s=" checked"; 305: else $s=""; 306: echo " ".hlink("View:Public"); 307: echo " |
| Times use XX:XX ago | "; 310: echo ""; 311: if ($row['vtimeago']==1) $s=" checked"; 312: else $s=""; 313: echo " ".hlink("View:TimeAgo"); 314: echo " |
| Columns"; 317: echo " | "; 318: echo " ".hlink("View:Columns"); 319: echo " |
| Refresh"; 321: echo " | "; 322: echo " ".hlink("View:Refresh"); 323: echo " |
| Save | "; 325: echo "Cancel / Abandon Changes"; 326: echo " |
"; 341: $q="SELECT * FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." ORDER BY iweight ASC"; 342: $r=$NATS->DB->Query($q); 343: if ($NATS->DB->Num_Rows($r)<=0) echo "No view objects yet defined.
"; 344: else $l=$NATS->DB->Num_Rows($r); 345: $f=0; 346: 347: 348: while ($row=$NATS->DB->Fetch_Array($r)) 349: { 350: echo ""; 351: echo "
| "; 357: echo "Item Type: "; 358: echo ViewItemTxt($row['itype'],$row['ioption']); 359: echo ""; 360: echo " | |||
| "; 363: echo "Use Colour :"; 364: echo " | "; 365: if ($row['icolour']==1) $s=" checked"; 366: else $s=""; 367: echo ""; 368: echo " ".hlink("View:UseColour"); 369: echo " | "; 370: 371: echo ""; 372: echo "Text Status :"; 373: echo " | "; 374: if ($row['itextstatus']==1) $s=" checked"; 375: else $s=""; 376: echo ""; 377: echo " ".hlink("View:TextStatus"); 378: echo " |
| "; 381: echo "Item Size :"; 382: echo " | "; 383: echo "384: if ($row['isize']>0) echo ""; 385: else echo ""; 386: echo "387: echo "Large"; 388: echo "389: echo "Small"; 390: echo ""; 391: echo " | "; 392: echo ""; 393: echo "Graphics :"; 394: echo " | "; 395: echo "396: if ($row['igraphic']==2) echo ""; 397: else if ($row['igraphic']==1) echo ""; 398: else echo ""; 399: echo "400: echo "Node/Group"; 401: echo "402: echo "Status Light"; 403: echo "404: echo "No Graphic"; 405: echo ""; 406: echo " |
| "; 409: echo "Show Detail :"; 410: echo " | "; 411: if ($row['idetail']>0) $s=" checked"; 412: else $s=""; 413: echo ""; 414: echo " ".hlink("View:ShowDetail"); 415: echo " | "; 416: 417: echo "||
Move: ";
420:
421: if ($f==0) echo " ";
422: else
423: {
424: echo "";
425: echo "![](\"images/arrows/on/arrow_top.png\"){kind=icon} ";
426: echo "";
427: }
428:
429: if ($f>=($l-1)) echo " ";
430: else
431: {
432: echo "";
433: echo "![](\"images/arrows/on/arrow_down.png\"){kind=icon} ";
434: echo "";
435: }
436:
437: $f++;
438:
439: echo " | Delete Item"; 440: echo " | ||
"; 443: } 444: 445: $NATS->DB->Free($r); 446: 447: echo "
"; 448: echo "
| Create New Item | |||
| "; 455: echo ""; 456: echo " | "; 457: echo "Individual Node: "; 458: echo "459: $nq="SELECT nodeid,nodename FROM fnnode"; 460: $nr=$NATS->DB->Query($nq); 461: while ($node=$NATS->DB->Fetch_Array($nr)) 462: { 463: echo ""; 464: } 465: $NATS->DB->Free($nr); 466: echo ""; 467: echo " | ||
| "; 470: echo ""; 471: echo " | "; 472: echo "Individual Group: "; 473: echo "474: $nq="SELECT groupid,groupname FROM fngroup"; 475: $nr=$NATS->DB->Query($nq); 476: while ($group=$NATS->DB->Fetch_Array($nr)) 477: { 478: echo ""; 479: } 480: $NATS->DB->Free($nr); 481: echo ""; 482: echo " | ||
| "; 496: echo ""; 497: echo " | "; 498: echo "List All (Enabled) Nodes"; 499: echo " | ||
| "; 502: echo ""; 503: echo " | "; 504: echo "List All Groups"; 505: echo " | ||
| "; 508: echo ""; 509: echo " | "; 510: echo "List Alerting Nodes"; 511: echo " | ||
| "; 514: echo ""; 515: echo " | "; 516: echo "List Alerting Groups"; 517: echo " | ||
| "; 520: echo ""; 521: echo " | "; 522: echo "List All Current Alerts"; 523: echo " | ||
| "; 526: echo ""; 527: echo " | ";
528: echo "Detail for Test ";
529: echo "530: foreach($tests as $test)
531: {
532: echo "533: if ($test['testname']!="") $tn=$test['testname'];
534: else $tn=$test['testtype']." (".$test['testparam'].")";
535: echo $test['nodeid']." > ".$tn;
536: echo "";
537: }
538: echo "";
539: echo " "; 540: echo "Name: | ||
| "; 543: echo ""; 544: echo " | ";
545: echo "Graph for Test ";
546: echo "547: foreach($tests as $test)
548: {
549: if ($test['testrecord']>0)
550: {
551: echo "552: if ($test['testname']!="") $tn=$test['testname'];
553: else $tn=$test['testtype']." (".$test['testparam'].")";
554: echo $test['nodeid']." > ".$tn;
555: echo "";
556: }
557: }
558: echo " "; 559: echo "Show Last Hours"; 560: echo " | ||
| "; 563: echo ""; 564: echo " | "; 565: echo "Title: "; 566: echo " | ||
| "; 569: echo " "; 570: //echo ""; 571: echo " | |||