[OpenSIPS-Users] Talking to my own MySQL-table

[Matti Zemack]

Thanks Brett. (This mailing list is fantastic...)


Working fine now with avp_db_query.

I might stick with the 'usr_preferences', but still use the avp_db_query
as it makes coding a bit simpler "controllable" for me as I don't yet
fully understand the avp_db_store-command.

Oh, I wish there would be more config examples easy accesible on one web
page. Probably what I'll do when I know more. :-) 


Best Regards and have a wonderful weekend,
Matti Zemack
Stockholm
Sweden


-----Original Message-----
From: brett at nemeroff.com [mailto:brett at nemeroff.com] 
Sent: den 29 januari 2009 16:15
To: Matti Zemack; users-bounces at lists.opensips.org;
users at lists.opensips.org
Subject: Re: [OpenSIPS-Users] Talking to my own MySQL-table

I do the same. Use avp_db_query.
-Brett


Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Matti Zemack" <Matti.Zemack at rtcfactory.com>

Date: Thu, 29 Jan 2009 15:57:48 
To: <users at lists.opensips.org>
Subject: [OpenSIPS-Users] Talking to my own MySQL-table

Hi all,

Still being a newbie, I've been off and on thinking about the following
for the last few days.
What module should I use (or rather what's the smartest approach) for
the following scenario;
*	If I have my own home made table in the "opensips"-database. How
can I insert and delete rows from it? Basically what I would like to
make is a storage of the latest REGISTER try from any one account. When
a new REGISTER is tried from that account the old gets deleted.
Basically all I want to save is $fu. What module is applicable, and how
could I use it?
Why not in "usr_preferences" you may ask, well I would like a solution
which is easily deployed and upgradeable without interfering with the
standardized database schema. Or is "usr_preferences" the best way to
go?

Thankful for any answers,
Matti Zemack
Stockholm
Sweden
_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users