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

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

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

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

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

";
240: 241: echo "
Link Types"; 245: if ($row['vclick']=="standard") $s=" checked"; 246: else $s=""; 247: echo " Standard
";
248: echo "Standard a href links for same window/frame

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

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

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

";
261: 262: echo "
Refresh"; 264: echo ""; 265: echo " ".hlink("View:Refresh"); 266: echo "
Save "; 268: echo "Cancel / Abandon Changes"; 269: echo "
";
271: echo "
";
272: echo "";
273: echo "\n\n"; 282: 283: //echo "

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

";
287: else $l=$NATS->DB->Num_Rows($r); 288: $f=0; 289: 290: 291: while ($row=$NATS->DB->Fetch_Array($r)) 292: { 293: echo ""; 294: echo ""; 295: echo "
";
296: echo ""; 297: echo ""; 298: echo ""; 299: echo ""; 304: 305: echo ""; 313: 314: echo ""; 322: 323: echo ""; 335: echo ""; 350: 351: echo ""; 359: 360: echo ""; 361: 362: echo ""; 384: 385: echo "
"; 300: echo "Item Type: "; 301: echo ViewItemTxt($row['itype'],$row['ioption']); 302: echo ""; 303: echo "
"; 306: echo "Use Colour :"; 307: echo ""; 308: if ($row['icolour']==1) $s=" checked"; 309: else $s=""; 310: echo ""; 311: echo " ".hlink("View:UseColour"); 312: echo ""; 315: echo "Text Status :"; 316: echo ""; 317: if ($row['itextstatus']==1) $s=" checked"; 318: else $s=""; 319: echo ""; 320: echo " ".hlink("View:TextStatus"); 321: echo "
"; 324: echo "Item Size :"; 325: echo ""; 326: echo ""; 334: echo ""; 336: echo "Graphics :"; 337: echo ""; 338: echo ""; 349: echo "
"; 352: echo "Show Detail :"; 353: echo ""; 354: if ($row['idetail']>0) $s=" checked"; 355: else $s=""; 356: echo ""; 357: echo " ".hlink("View:ShowDetail"); 358: echo "
Move: "; 363: 364: if ($f==0) echo ""; 365: else 366: { 367: echo ""; 368: echo ""; 369: echo ""; 370: } 371: 372: if ($f>=($l-1)) echo ""; 373: else 374: { 375: echo ""; 376: echo ""; 377: echo ""; 378: } 379: 380: $f++; 381: 382: echo "Delete Item"; 383: echo "

";
386: } 387: 388: $NATS->DB->Free($r); 389: 390: echo "

";
391: echo ""; 392: echo "
";
393: echo ""; 394: echo ""; 395: echo ""; 396: 397: echo ""; 411: 412: echo ""; 426: 427: echo ""; 432: 433: echo ""; 438: 439: echo ""; 444: 445: echo ""; 450: 451: echo ""; 456: 457: echo ""; 461: /* TODO - if ok don't be lazy and put the def options in here */ 462: 463: echo "
Create New Item
"; 398: echo ""; 399: echo ""; 400: echo "Individual Node: "; 401: echo ""; 410: echo "
"; 413: echo ""; 414: echo ""; 415: echo "Individual Group: "; 416: echo ""; 425: echo "
"; 428: echo ""; 429: echo ""; 430: echo "List All (Enabled) Nodes"; 431: echo "
"; 434: echo ""; 435: echo ""; 436: echo "List All Groups"; 437: echo "
"; 440: echo ""; 441: echo ""; 442: echo "List Alerting Nodes"; 443: echo "
"; 446: echo ""; 447: echo ""; 448: echo "List Alerting Groups"; 449: echo "
"; 452: echo ""; 453: echo ""; 454: echo "List All Current Alerts"; 455: echo "
 "; 458: echo " "; 459: //echo ""; 460: echo "
";
464: ?> 465: 466: 467: 468: Screen_Footer(); 469: ?> 470: