R: [Users] using AVPs to write into database

Hi guys, I have a similar problem, maybe easier. I'm new in openser so I'd like to have some help. I'd like openser create a table in MySQL db when receive an INVITE, a row with from uri, method and something else, I've look into modules docs but I've not understanding at all...could you help me, please? Thanks for reply Davide ________________________________ Da: users-bounces(a)openser.org [mailto:users-bounces@openser.org] Per conto di Jayesh Nambiar Inviato: mercoledì 5 aprile 2006 15.53 A: Bogdan-Andrei Iancu Cc: openser Oggetto: Re: [Users] using AVPs to write into database Hi Bogdan, Thanks for the reply and sorry for sending the earlier mail 4 times as yahoo was not responding peoperly. When I do an avp_write(), why does the avp name get stored in the uuid column? I am not using any uuid as of now. I also tried to add the username of the person who is calling but it again creates two rows, one with the value as username and other row with the value as forwarded number. I thought if there is a way to insert the username also, it wud be easier to check, if the incoming call for that user is to be forwarded or not. I get the following in my usr_preferences table after I dial 86 followed by any number. +-----------+----------+--------+-----------+------+-----------------------------+---------------------+ | uuid | username | domain | attribute | type | value | modified | +-----------+----------+--------+-----------+------+-----------------------------+---------------------+ | s:callfwd | | | callfwd | 0 | sip:5515551478@202.80.61.10 | 2006-04-05 19:10:49 | +-----------+----------+--------+-----------+------+-----------------------------+---------------------+ The script snippet is as follows: if(uri=~"^sip:86[0-9]*@") { strip(2); avp_write("$ruri", "s:callfwd"); #avp_write("$from/username", "i:999"); #avp_db_store("i:999", "i:/usr_preferences"); avp_db_store("s:callfwd", "s:callfwd/usr_preferences"); sl_send_reply("200", "OK"); exit; }; Bogdan-Andrei Iancu &lt;bogdan(a)voice-system.ro&gt; wrote: Hi, you need two steps: 1) write the ruri (after strip) into an AVP - use avp_write() 2) write the avp into the db - use avp_db_store() regards, bogdan Jayesh Nambiar wrote: ________________________________ Jiyo cricket on Yahoo! India cricket <http://us.rd.yahoo.com/mail/in/mailcricket/*http:/in.sports.yahoo.com/cricket/> Yahoo! Messenger Mobile <http://us.rd.yahoo.com/mail/in/mailmobilemessenger/*http:/in.mobile.yahoo.com/new/messenger/> Stay in touch with your buddies all the time.