File: 0.02.11a/server/web/log.php (View as HTML)

  1: <?php
  2: ob_start();
  3: require("include.php");
  4: $NATS->Start();
  5: if (!$NATS_Session->Check($NATS->DB))
  6: 	{
  7: 	header("Location: ./?login_msg=Invalid+Or+Expired+Session");
  8: 	exit();
  9: 	}
 10: if ($NATS_Session->userlevel<9) UL_Error("View Log");
 11: 
 12: 
 13: ob_end_flush();
 14: Screen_Header("System Event Log",1);
 15: ?>
 16: 
 17: <br>
 18: <b class="minortitle">System Event Log</b><br><br>
 19: 
 20: <?php
 21: 
 22: if (isset($_REQUEST['f_mod'])) $f_mod=$_REQUEST['f_mod'];
 23: else $f_mod="";
 24: if (isset($_REQUEST['f_cat'])) $f_cat=$_REQUEST['f_cat'];
 25: else $f_cat="";
 26: if (isset($_REQUEST['f_lvl'])) $f_lvl=$_REQUEST['f_lvl'];
 27: else $f_lvl="";
 28: if (isset($_REQUEST['f_entry'])) $f_entry=$_REQUEST['f_entry'];
 29: else $f_entry="";
 30: if (isset($_REQUEST['d_show'])) $d_show=$_REQUEST['d_show'];
 31: else $d_show="30";
 32: if (isset($_REQUEST['d_from'])) $d_from=$_REQUEST['d_from'];
 33: else $d_from="0";
 34: 
 35: 
 36: $wc=array();
 37: if ($f_mod!="") $wc[]="modid=\"".ss($f_mod)."\"";
 38: if ($f_cat!="") $wc[]="catid=\"".ss($f_cat)."\"";
 39: if ($f_lvl!="") $wc[]="loglevel<=".ss($f_lvl);
 40: if ($f_entry!="") $wc[]="logevent LIKE \"%".ss($f_entry)."%\"";
 41: 
 42: if (count($wc)==0) $wc[]="1";
 43: 
 44: $q="SELECT * FROM fnlog WHERE";
 45: $first=true;
 46: foreach($wc as $c)
 47: 	{
 48: 	if ($first) $first=false;
 49: 	else $q.=" AND";
 50: 	$q.=" ".$c;
 51: 	}
 52: 
 53: $q.=" ORDER BY logid DESC";
 54: $q.=" LIMIT ".ss($d_from).",".ss($d_show);
 55: 
 56: echo "<table class=\"nicetable\">";
 57: echo "<form action=log.php method=post>";
 58: // posted mod cat lvl entry
 59: echo "<tr>";
 60: echo "<td><b>Filter:</b></td>";
 61: echo "<td><input type=text value=\"".$f_mod."\" name=f_mod size=10></td>";
 62: echo "<td><input type=text value=\"".$f_cat."\" name=f_cat size=10></td>";
 63: echo "<td><input type=text value=\"".$f_lvl."\" name=f_lvl size=2></td>";
 64: echo "<td><input type=text value=\"".$f_entry."\" name=f_entry size=40></td>";
 65: echo "</tr>";
 66: 
 67: echo "<tr><td><b>Show:</b></td>";
 68: echo "<td colspan=3 align=left>";
 69: echo "<input type=text value=\"".$d_show."\" size=4 name=d_show> entries from ";
 70: echo "<input type=text value=\"".$d_from."\" size=6 name=d_from>";
 71: echo "</td><td>";
 72: echo "<input type=submit value=\"Filter Log Entries and Display\"> <a href=log.php>Reset</a>";
 73: echo "</td></tr>";
 74: 
 75: echo "<tr><td colspan=3>";
 76: $dto=$d_from-$d_show;
 77: if ($dto<0) $dto=0;
 78: echo "<a href=log.php?d_from=".$dto."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
 79: echo "&lt;&lt; Previous";
 80: echo "</a></td>";
 81: echo "<td colspan=2 align=right>";
 82: $dto=$d_from+$d_show;
 83: if ($dto<0) $dto=0;
 84: echo "<a href=log.php?d_from=".$dto."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
 85: echo "Next &gt;&gt;";
 86: echo "</a></td></tr>";
 87: 
 88: //echo "<tr><td colspan=5>".$q."</td></tr>";
 89: // <a href=log.php?d_from=".$d_from."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".$fentry.">
 90: $r=$NATS->DB->Query($q);
 91: while ($row=$NATS->DB->Fetch_Array($r))
 92: 	{
 93: 	echo "<tr><td>".nicedt($row['postedx'])."</td>";
 94: 	echo "<td>";
 95: 	echo "<a href=log.php?d_from=".$d_from."&d_show=".$d_show."&f_mod=".$row['modid']."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
 96: 	echo $row['modid']."</a></td>";
 97: 	echo "<td>";
 98: 	echo "<a href=log.php?d_from=".$d_from."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$row['catid']."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
 99: 	echo $row['catid']."</a></td>";
100: 	echo "<td>";
101: 	echo "<a href=log.php?d_from=".$d_from."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$row['loglevel']."&f_entry=".urlencode($f_entry).">";
102: 	echo $row['loglevel']."</a></td>";
103: 	echo "<td>".$row['logevent']."</td>";
104: 	echo "</tr>";
105: 	}
106: $NATS->DB->Free($r);
107: 
108: echo "<tr><td colspan=3>";
109: $dto=$d_from-$d_show;
110: if ($dto<0) $dto=0;
111: echo "<a href=log.php?d_from=".$dto."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
112: echo "&lt;&lt; Previous";
113: echo "</a></td>";
114: echo "<td colspan=2 align=right>";
115: $dto=$d_from+$d_show;
116: if ($dto<0) $dto=0;
117: echo "<a href=log.php?d_from=".$dto."&d_show=".$d_show."&f_mod=".$f_mod."&f_cat=".$f_cat."&f_lvl=".$f_lvl."&f_entry=".urlencode($f_entry).">";
118: echo "Next &gt;&gt;";
119: echo "</a></td></tr>";
120: 
121: 
122: echo "</table>";
123: 
124: //echo $q;
125: 
126: ?>
127: 
128: 
129: <?php
130: Screen_Footer();
131: ?>
132: