[Astpp-commit] SF.net SVN: astpp:[2234] trunk/scripts/astpp-device-monitor.pl
Brought to you by:
darrenkw
From: <dar...@us...> - 2009-02-21 18:17:54
|
Revision: 2234 http://astpp.svn.sourceforge.net/astpp/?rev=2234&view=rev Author: darrenkw Date: 2009-02-21 18:17:40 +0000 (Sat, 21 Feb 2009) Log Message: ----------- Update code to more record more information in astpp-device-monitor.pl Modified Paths: -------------- trunk/scripts/astpp-device-monitor.pl Modified: trunk/scripts/astpp-device-monitor.pl =================================================================== --- trunk/scripts/astpp-device-monitor.pl 2009-02-21 18:12:03 UTC (rev 2233) +++ trunk/scripts/astpp-device-monitor.pl 2009-02-21 18:17:40 UTC (rev 2234) @@ -127,9 +127,10 @@ $astpp_db = &connect_db( $config, @output ); } $ASTPP->debug( debug=> "Peer: @extension1[0] Answer"); - my $tmp = "INSERT INTO extensions_status (tech,extension,status,number) VALUES (" + my $tmp = "INSERT INTO extensions_status (tech,extension,status,UniqueID,number) VALUES (" . $astpp_db->quote(@extension[0]) . "," . $astpp_db->quote(@extension1[0]) . ",'Answer'," + . $astpp_db->quote($_[ARG0]->{Uniqueid}) . "," . $astpp_db->quote($_[ARG0]->{Extension}) . ")"; $ASTPP->debug( debug=> "SQL: $tmp"); $astpp_db->do($tmp); @@ -168,8 +169,9 @@ $astpp_db = &connect_db( $config, @output ); } $ASTPP->debug( debug=> "Peer: @extension2[0] HUNGUP"); - my $tmp = "INSERT INTO extensions_status (tech,extension,status) VALUES (" + my $tmp = "INSERT INTO extensions_status (tech,extension,UniqueID,status) VALUES (" . $astpp_db->quote(@extension[0]) . "," + . $astpp_db->quote($_[ARG0]->{Uniqueid}) . "," . $astpp_db->quote(@extension2[0]) . ",'Hungup')"; $ASTPP->debug( debug=> "SQL: $tmp"); $astpp_db->do($tmp); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |