Does anyone know where that nice .php is that was written to access the CDRs from mysql DB? Bruce W. Hedreen Computer Technologies of Eastern Carolina, LLC --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031209/112e9ba2/attachment.htm
like that but poor :-)
// CDR access
$connect = @mysql_connect
("localhost","USERNAME","PASSWORD");
mysql_select_db("asteriskcdrdb");
$result = mysql_query ("select dstchannel from cdr where dstchannel like
'%IAX%'",$connect);
$iax = mysql_num_rows($result);
$result = mysql_query ("select dstchannel from cdr where dstchannel like
'%SIP%'",$connect);
$sip = mysql_num_rows($result);
$result = mysql_query ("select dstchannel from cdr where dstchannel like
'%Zap%'",$connect);
$pstn = mysql_num_rows($result);
$result = mysql_query ("select dstchannel from cdr where dstchannel like
'%H323%'",$connect);
$h323 = mysql_num_rows($result);
mysql_close($connect);
print<<<EOH
IAX {$iax}
SIP {$sip}
PSTN {$pstn}
H323 {$h323}
EOH;
mack_jpn
On Tue, 9 Dec 2003 09:55:33 -0500
"Bruce Hedreen" <luvbeach@clis.com> wrote:
> Does anyone know where that nice .php is that was written to access the
> CDRs from mysql DB?
>
> Bruce W. Hedreen
> Computer Technologies of Eastern Carolina, LLC
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
>
http://sourceforge.net/projects/astweb/ On Tue, 2003-12-09 at 15:55, Bruce Hedreen wrote:> Does anyone know where that nice .php is that was written to access > the CDRs from mysql DB? > > > > Bruce W. Hedreen > > Computer Technologies of Eastern Carolina, LLC > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 > >
I've written that ugly one :) I'll try to see if I can find it, if that was what you meant... On Tue, 2003-12-09 at 15:55, Bruce Hedreen wrote:> Does anyone know where that nice .php is that was written to access > the CDRs from mysql DB? > > > > Bruce W. Hedreen > > Computer Technologies of Eastern Carolina, LLC > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 > >