Viewing File server/web/view.edit.php of 0.02.59a
Home or version:
File: 0.02.59a/server/web/view.edit.php (View as Code)

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 (!is_numeric($_REQUEST['vrefresh'])) $vref=0; 76: else $vref=ss($_REQUEST['vrefresh']); 77: $q="UPDATE fnview SET vtitle=\"".ss($_REQUEST['vtitle'])."\",vstyle=\"".ss($_REQUEST['vstyle'])."\","; 78: $q.="vclick=\"".ss($_REQUEST['vclick'])."\",vpublic=".$public.",vlinkv=".ss($_REQUEST['vlinkv']).",vrefresh=".$vref; 79: $q.=",vcolumns=".ss($_REQUEST['vcolumns']); 80: $q.=" WHERE viewid=".ss($_REQUEST['viewid']); 81: $NATS->DB->Query($q); 82: if ($NATS->DB->Affected_Rows()<=0) $msg="Failed to update or nothing changed"; 83: else $msg="Saved changes ok"; 84: break; 85: 86: case "create_item": 87: $wq="SELECT iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." ORDER BY iweight DESC LIMIT 0,1"; 88: $wr=$NATS->DB->Query($wq); 89: if ($row=$NATS->DB->Fetch_Array($wr)) 90: { 91: $iweight=$row['iweight']+10; 92: } 93: else $iweight=10; 94: $NATS->DB->Free($wr); 95: 96: $itype=ss($_REQUEST['itype']); 97: if ($itype=="node") $ioption=ss($_REQUEST['ioption_node']); 98: else if($itype=="group") $ioption=ss($_REQUEST['ioption_group']); 99: else $ioption=""; 100: $q="INSERT INTO fnviewitem(viewid,itype,ioption,iweight) VALUES(".ss($_REQUEST['viewid']).","; 101: $q.="\"".$itype."\",\"".$ioption."\",".$iweight.")"; 102: $NATS->DB->Query($q); 103: if ($NATS->DB->Affected_Rows()>0) $msg="Created Item"; 104: else $msg="Create Item Failed"; 105: break; 106: 107: case "del_item": 108: $q="DELETE FROM fnviewitem WHERE viewitemid=".ss($_REQUEST['viewitemid']); 109: $NATS->DB->Query($q); 110: if ($NATS->DB->Affected_Rows()>0) $msg="Deleted Item"; 111: else $msg="Delete Item Failed"; 112: break; 113: 114: case "save_view_item": 115: $icol=chs("icolour",0); 116: $itxt=chs("itextstatus",0); 117: $isize=chs("isize",0); 118: $igraphic=chs("igraphic",0); 119: $idetail=chs("idetail",0); 120: $q="UPDATE fnviewitem SET "; 121: $q.="icolour=".$icol.","; 122: $q.="itextstatus=".$itxt.","; 123: $q.="isize=".$isize.","; 124: $q.="igraphic=".$igraphic.","; 125: $q.="idetail=".$idetail." "; 126: $q.="WHERE viewitemid=".ss($_REQUEST['viewitemid']); 127: $NATS->DB->Query($q); 128: //echo $q; 129: if ($NATS->DB->Affected_Rows()<=0) $msg="Save Failed or Nothing Changed"; 130: else $msg="Saved Item Changes"; 131: break; 132: 133: case "move_item": 134: if (isset($_REQUEST['dir'])) $dir=$_REQUEST['dir']; 135: else $dir="up"; 136: 137: $mywq="SELECT iweight FROM fnviewitem WHERE viewitemid=".ss($_REQUEST['viewitemid']); 138: $mywr=$NATS->DB->Query($mywq); 139: $row=$NATS->DB->Fetch_Array($mywr); 140: $myweight=$row['iweight']; 141: $NATS->DB->Free($mywr); 142: 143: if ($dir=="up") // get the next lowest one down 144: { 145: $q="SELECT viewitemid,iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." AND iweight<".$myweight." "; 146: $q.="ORDER BY iweight DESC LIMIT 0,1"; 147: $r=$NATS->DB->Query($q); 148: if ($row=$NATS->DB->Fetch_Array($r)) // found one to swap with 149: { 150: $uq="UPDATE fnviewitem SET iweight=".$myweight." WHERE viewitemid=".$row['viewitemid']; 151: $NATS->DB->Query($uq); 152: $uq="UPDATE fnviewitem SET iweight=".$row['iweight']." WHERE viewitemid=".ss($_REQUEST['viewitemid']); 153: $NATS->DB->Query($uq); 154: $msg="Moved Item"; 155: } 156: else $msg="Nowhere to Move Item To"; 157: } 158: else if ($dir=="down") // get the next highest 159: { 160: $q="SELECT viewitemid,iweight FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." AND iweight>".$myweight." "; 161: $q.="ORDER BY iweight DESC LIMIT 0,1"; 162: $r=$NATS->DB->Query($q); 163: if ($row=$NATS->DB->Fetch_Array($r)) // found one to swap with 164: { 165: $uq="UPDATE fnviewitem SET iweight=".$myweight." WHERE viewitemid=".$row['viewitemid']; 166: $NATS->DB->Query($uq); 167: $uq="UPDATE fnviewitem SET iweight=".$row['iweight']." WHERE viewitemid=".ss($_REQUEST['viewitemid']); 168: $NATS->DB->Query($uq); 169: $msg="Moved Item"; 170: } 171: else $msg="Nowhere to Move Item To"; 172: } 173: 174: break; 175: 176: default: $msg="Unknown Action"; 177: } 178: } 179: 180: ob_end_flush(); 181: Screen_Header("View Editor",1); 182: 183: 184: $q="SELECT * FROM fnview WHERE viewid=".ss($_REQUEST['viewid'])." LIMIT 0,1"; 185: $r=$NATS->DB->Query($q); 186: if (!$row=$NATS->DB->Fetch_Array($r)) 187: { 188: echo "No such view.

"; 189: Screen_Footer(); 190: exit(); 191: } 192: 193: $NATS->DB->Free($r); 194: if (isset($msg)) 195: { 196: echo "".$msg."

"; 197: $poplist[]=$msg; 198: } 199: 200: echo "
"; 201: echo "Editing View: ".$row['vtitle'].""; 202: echo "Preview View / "; 203: echo "Link to View"; 204: echo "
"; 205: echo "
"; 206: 207: echo "
"; 208: echo "
"; 209: echo ""; 210: 211: echo ""; 212: echo ""; 213: 214: echo ""; 218: echo ""; 219: 220: echo ""; 221: echo ""; 226: echo ""; 227: 228: echo ""; 229: echo ""; 244: 245: echo ""; 246: echo ""; 278: echo ""; 282: echo ""; 286: echo ""; 289: echo "
View Title"; 215: echo ""; 216: echo ""; 217: echo "
 
Public View"; 222: if ($row['vpublic']==1) $s=" checked"; 223: else $s=""; 224: echo " ".hlink("View:Public"); 225: echo "
 
Page Style"; 230: if ($row['vstyle']=="standard") $s=" checked"; 231: else $s=""; 232: echo " Standard
"; 233: echo "Standard full-page headers and footers with "local" page and style includes

"; 234: if ($row['vstyle']=="mobile") $s=" checked"; 235: else $s=""; 236: echo " Mobile/Minimal
"; 237: echo "Very minimal and absolute page style suitable for mobile browser and/or inline JS usage

"; 238: if ($row['vstyle']=="plain") $s=" checked"; 239: else $s=""; 240: echo " Plain
"; 241: echo "Totally plain output

"; 242: 243: echo "
Link Types"; 247: if ($row['vclick']=="standard") $s=" checked"; 248: else $s=""; 249: echo " Standard
"; 250: echo "Standard a href links for same window/frame

"; 251: if ($row['vclick']=="frametop") $s=" checked"; 252: else $s=""; 253: echo " Same Window (Frame Top)
"; 254: echo "a href link to the window/frame top

"; 255: if ($row['vclick']=="newwindow") $s=" checked"; 256: else $s=""; 257: echo " New Window
"; 258: echo "Open a New Window

"; 259: if ($row['vclick']=="disabled") $s=" checked"; 260: else $s=""; 261: echo " Disabled
"; 262: echo "No links (disabled)

"; 263: if ($row['vlinkv']==0) $s=""; else $s=" selected"; 264: $lq="SELECT viewid,vtitle FROM fnview WHERE viewid!=".ss($_REQUEST['viewid']); 265: $lr=$NATS->DB->Query($lq); 266: echo "Links to Another View: "; 267: echo " ".hlink("View:LinkAnotherView")."

"; 276: $NATS->DB->Free($lr); 277: echo "
Columns"; 279: echo ""; 280: echo " ".hlink("View:Columns"); 281: echo "
Refresh"; 283: echo ""; 284: echo " ".hlink("View:Refresh"); 285: echo "
Save "; 287: echo "Cancel / Abandon Changes"; 288: echo "
"; 290: echo "
"; 291: echo "";
292: echo "\n\n"; 301: 302: //echo "

"; 303: $q="SELECT * FROM fnviewitem WHERE viewid=".ss($_REQUEST['viewid'])." ORDER BY iweight ASC"; 304: $r=$NATS->DB->Query($q); 305: if ($NATS->DB->Num_Rows($r)<=0) echo "No view objects yet defined.

"; 306: else $l=$NATS->DB->Num_Rows($r); 307: $f=0; 308: 309: 310: while ($row=$NATS->DB->Fetch_Array($r)) 311: { 312: echo ""; 313: echo ""; 314: echo "
"; 315: echo ""; 316: echo ""; 317: echo ""; 318: echo ""; 323: 324: echo ""; 332: 333: echo ""; 341: 342: echo ""; 354: echo ""; 369: 370: echo ""; 378: 379: echo ""; 380: 381: echo ""; 403: 404: echo "
"; 319: echo "Item Type: "; 320: echo ViewItemTxt($row['itype'],$row['ioption']); 321: echo ""; 322: echo "
"; 325: echo "Use Colour :"; 326: echo ""; 327: if ($row['icolour']==1) $s=" checked"; 328: else $s=""; 329: echo ""; 330: echo " ".hlink("View:UseColour"); 331: echo ""; 334: echo "Text Status :"; 335: echo ""; 336: if ($row['itextstatus']==1) $s=" checked"; 337: else $s=""; 338: echo ""; 339: echo " ".hlink("View:TextStatus"); 340: echo "
"; 343: echo "Item Size :"; 344: echo ""; 345: echo ""; 353: echo ""; 355: echo "Graphics :"; 356: echo ""; 357: echo ""; 368: echo "
"; 371: echo "Show Detail :"; 372: echo ""; 373: if ($row['idetail']>0) $s=" checked"; 374: else $s=""; 375: echo ""; 376: echo " ".hlink("View:ShowDetail"); 377: echo "
Move: "; 382: 383: if ($f==0) echo ""; 384: else 385: { 386: echo ""; 387: echo ""; 388: echo ""; 389: } 390: 391: if ($f>=($l-1)) echo ""; 392: else 393: { 394: echo ""; 395: echo ""; 396: echo ""; 397: } 398: 399: $f++; 400: 401: echo "Delete Item"; 402: echo "

"; 405: } 406: 407: $NATS->DB->Free($r); 408: 409: echo "

"; 410: echo ""; 411: echo "
"; 412: echo ""; 413: echo ""; 414: echo ""; 415: 416: echo ""; 430: 431: echo ""; 445: 446: $tests=array(); 447: $tq="SELECT localtestid,nodeid,testname,testtype,testparam,testrecord FROM fnlocaltest ORDER BY nodeid"; 448: $tr=$NATS->DB->Query($tq); 449: while ($test=$NATS->DB->Fetch_Array($tr)) 450: { 451: $tid="L".$test['localtestid']; 452: $tests[$tid]=$test; 453: $tests[$tid]['testid']=$tid; 454: } 455: $NATS->DB->Free($tr); 456: 457: echo ""; 462: 463: echo ""; 468: 469: echo ""; 474: 475: echo ""; 480: 481: echo ""; 486: 487: echo ""; 502: 503: echo ""; 522: 523: echo ""; 527: /* TODO - if ok don't be lazy and put the def options in here */ 528: 529: echo "
Create New Item
"; 417: echo ""; 418: echo ""; 419: echo "Individual Node: "; 420: echo ""; 429: echo "
"; 432: echo ""; 433: echo ""; 434: echo "Individual Group: "; 435: echo ""; 444: echo "
"; 458: echo ""; 459: echo ""; 460: echo "List All (Enabled) Nodes"; 461: echo "
"; 464: echo ""; 465: echo ""; 466: echo "List All Groups"; 467: echo "
"; 470: echo ""; 471: echo ""; 472: echo "List Alerting Nodes"; 473: echo "
"; 476: echo ""; 477: echo ""; 478: echo "List Alerting Groups"; 479: echo "
"; 482: echo ""; 483: echo ""; 484: echo "List All Current Alerts"; 485: echo "
"; 488: echo ""; 489: echo ""; 490: echo "Detail for Test "; 491: echo ""; 501: echo "
"; 504: echo ""; 505: echo ""; 506: echo "Graph for Test "; 507: echo "
"; 520: echo "Show Last Hours"; 521: echo "
 "; 524: echo " "; 525: //echo ""; 526: echo "
"; 530: ?> 531: 532: 533: 534: Screen_Footer(); 535: ?> 536:
CodeXplore for FreeNATS by David Cutting, all rights reserved.