[  * It is possible to mark individual sip traces as public 
Adrian Georgescu <ag@ag-projects.com>**20061127152430] hunk ./cdrlib_ser.phtml 4094
-        global $DATASOURCES;
+        global $DATASOURCES, $auth;
+        $this->cdrtool  = new DB_CDRTool();
hunk ./cdrlib_ser.phtml 4103
+
+            $query="select count(*) as c,
+            min(date) as min,
+            max(date) as max
+            from $this->table";
+            dprint($query);
+            if ($this->db->query($query) && $this->db->next_record()) {
+            	$this->summary=array(
+                                 "count"     => $this->db->f('c'),
+                                 "startDate" => $this->db->f('min'),
+                                 "endDate"   => $this->db->f('max')
+                                 );
+            } else {
+                print "<p>Error: database error. ";
+                return 0;
+            }
+
hunk ./cdrlib_ser.phtml 4121
+            if (is_object($auth)) {
+                $this->isAuthorized=1;
+            }
+
hunk ./cdrlib_ser.phtml 4127
-            print "<pre>";
-            print_r($this);
-            print "</pre>";
hunk ./cdrlib_ser.phtml 4130
-        $query="select count(*) as c,
-        min(date) as min,
-        max(date) as max
-        from $this->table";
-        dprint($query);
-        $this->db->query($query);
-        $this->db->next_record();
-        $this->summary=array(
-                             "count"     => $this->db->f('c'),
-                             "startDate" => $this->db->f('min'),
-                             "endDate"   => $this->db->f('max')
-                             );
-
hunk ./cdrlib_ser.phtml 4138
+        $action           = $_REQUEST['action'];
+        $toggleVisibility = $_REQUEST['toggleVisibility'];
+
+        if ($action=='toggleVisibility') {
+			$this->togglePublicVisibility($callid,$fromtag,$toggleVisibility);
+        }
+
hunk ./cdrlib_ser.phtml 4165
-		$fullURL=$protocolURL.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
-
hunk ./cdrlib_ser.phtml 4167
-            <h3>SIP session trace $callid</h3>
+            <h3>SIP session trace $callid $authorize</h3>
hunk ./cdrlib_ser.phtml 4171
-            <td><a href=$fullURL>URL for this trace</a></td>
-            <td align=right>Click on the SIP message to see the trace</a>
+            <form method=post>
+            <td align=left width=50%>
+            ";
+            if ($this->isAuthorized) {
+		        $key="callid-".trim($callid).trim($fromtag);
+
+                $query=sprintf("select * from memcache where `key` = '%s'",addslashes($key));
+                dprint($query);
+                $this->cdrtool->query($query);
+
+                if ($this->cdrtool->num_rows()) {
+                	$selected_toggleVisibility['public']="selected";
+					$fullURL=$protocolURL.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI']."&public=1";
+                } else {
+                	$selected_toggleVisibility['private']="selected";
+        			$fullURL=$protocolURL.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
+                }
+
+                print "
+                Trace is visible
+                <select name=toggleVisibility>
+                <option $selected_toggleVisibility[public] value=1>without authorization
+                <option $selected_toggleVisibility[private] value=0>only for authorized users
+                </select>
+                <input type=hidden name=action value=toggleVisibility>
+                <input type=submit value=\"Save\">
+                ";
+          		print "<a href=$fullURL>URL for this trace</a></td>";
+            }
+
+
+            print "</td>
+            </form>
+            <td align=right width=50%>
+            Click on each trace entry to see the full message.
+            </td>
hunk ./cdrlib_ser.phtml 4482
-                	print "
-                    <td class=bbot align=$arrow_align>";
+                	print "<td class=bbot align=$arrow_align>";
hunk ./cdrlib_ser.phtml 4485
-                        print "
-                        <img src=images/$arrow border=0>
-                        ";
+                        print "<img src=images/$arrow border=0>";
hunk ./cdrlib_ser.phtml 4491
-                        print "
-                        <img src=images/$arrow border=0>
-                        ";
+                        print "<img src=images/$arrow border=0>";
hunk ./cdrlib_ser.phtml 4494
-                	print "<td class=bbot>&nbsp;";
+                	print "<td class=bbot>";
hunk ./cdrlib_ser.phtml 4499
+                } else {
+                	print "&nbsp;";
hunk ./cdrlib_ser.phtml 4555
-            <td valign=top class=border colspan=2 width=100%>
-            $status_color $msg </font></td>
+            <td valign=top class=border colspan=2 width=100%>$status_color $msg </font></td>
hunk ./cdrlib_ser.phtml 4570
+    }
+
+    function togglePublicVisibility($callid,$fromtag,$public='0') {
hunk ./cdrlib_ser.phtml 4574
+        $key="callid-".trim($callid).trim($fromtag);
+
+        if (!$public) {
+        	$query=sprintf("delete from memcache where `key` = '%s'",addslashes($key));
+            dprint($query);
+            $this->cdrtool->query($query);
+        } else {
+        	$query=sprintf("delete from memcache where `key` = '%s'",addslashes($key));
+            dprint($query);
+            $this->cdrtool->query($query);
+        	$query=sprintf("insert into memcache values ('%s','public')",addslashes($key));
+            dprint($query);
+            $this->cdrtool->query($query);
+        }
hunk ./debian/changelog 8
-  * CDRTool version number points to the changelog 
+  * CDRTool version number points to the changelog
+  * It is possible to mark individual sip traces as public
hunk ./debian/changelog 11
- -- Adrian Georgescu <ag@ag-projects.com>  Sun, 26 Nov 2006 14:35:58 +0100
+ -- Adrian Georgescu <ag@ag-projects.com>  Mon, 27 Nov 2006 16:23:59 +0100
hunk ./sip-trace.phtml 3
-page_open(array(
+
+if ($_REQUEST['public']) {
+    $db = new DB_CDRTool;
+    $key="callid-".trim($callid).trim($fromtag);
+    $query=sprintf("select * from memcache where `key` = '%s'",addslashes($key));
+    sleep(1);
+    dprint($query);
+    if ($db->query($query)) {
+	    if ($db->num_rows()) {
+    	    $authorize=0;
+    	} else {
+        	$authorize=1;
+	    }
+    } else {
+		$authorize=1;
+    }
+} else {
+	$authorize=1;
+}
+
+if ($authorize==1) {
+	page_open(array(
hunk ./sip-trace.phtml 30
+} else {
+	unset($auth);
+	unset($sess);
+	unset($perm);
+}
+
hunk ./sip-trace.phtml 43
-if (in_array($cdr_source,$CDRTool[dataSourcesAllowed])) {
+if (!$authorize || in_array($cdr_source,$CDRTool[dataSourcesAllowed])) {
hunk ./sip-trace.phtml 60
-page_close();
+if ($authorize=1) {
+	page_close();
+}
hunk ./style.css 169
-  vertical-align: top;
+  vertical-align: middle;