[cisco-voip] Inserting Cisco AVPairs from accounting request into database

[vignesh]

Hello all
I want to insert cisco AV Pairs from accounting request packet into
database. Here is the accounting request packet for a single leg.
        Acct-Session-Id = "00000B93"
        Calling-Station-Id = "216"
        Called-Station-Id = "9833515315"
        Cisco-AVPair = "call-id=19421006761822000202723 at 202.80.61.42"
        h323-setup-time = "h323-setup-time=*14:42:31.708 PCTime Fri May
26 2006"
        h323-conf-id = "h323-conf-id=989CA2C5 EBCE11DA 81EF9672
750B1B97"
        h323-call-type = "h323-call-type=VoIP"
        Cisco-AVPair = "h323-incoming-conf-id=989CA2C5 EBCE11DA 81EF9672
750B1B97"
        Cisco-AVPair = "session-protocol=sipv2"
        h323-connect-time = "h323-connect-time=*14:42:34.904 PCTime Fri
May 26 2006"
        Acct-Session-Time = 4
        h323-disconnect-time = "h323-disconnect-time=*14:42:39.020
PCTime Fri May 26 2006"
        h323-disconnect-cause = "h323-disconnect-cause=10"
        h323-remote-address = "h323-remote-address=202.80.61.42"
        h323-voice-quality = "h323-voice-quality=0"
        Cisco-AVPair = "remote-media-address=202.80.61.42"
        Cisco-AVPair = "gw-rxd-cgn=ton:0,npi:0,pi:0,si:0,#:216"
        User-Name = "202.80.61.42"
        Acct-Status-Type = Stop
        Service-Type = Login-User
        NAS-IP-Address = 202.80.61.1
        Acct-Delay-Time = 0

I changed the default table structure to include the extra columns. Also
made changes in sql.conf to add values in the respective columns.
Here is my problem. I insert h323-remote-address by adding
'%{h323-remote-address}' in the insert query
But I get the value as h323-remote-address=202.80.61.42 whereas I wanted
only the ip address not the complete string after the '=' sign.
Also I want to insert other fields like callid, remote-media-address
both of which are Cisco AVPair. So how do I include them into my
database coz I cant refer them direcly by their attribute name like
'%{remote-media-address}.  I tried that but it doesn't return any value.
So how do I insert all these values.

Thanks 
Vignesh