[SR-Users] Limiting calls from users in prepaid scenerio

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, We are thinking about launching a different "usage policy". The usage policy will be prepaid in some sense. but instead of limiting "number of minutes" we are thinking about limiting "number of calls". That means if you pay this X amount of doller, you can make Y amount of calls. calls can last whatever the user wants given that its under 1 hr. I've seen how to limit concurrent calls using SER, but the usage i have described, is not seen by me. So please help me out with this thing. My initial understanding about how it can be done : 1) when a dialog is confirmed with ACK(we have both callid, from tag, to tag), we can make an entry to the database by increasing "number of calls" field by one. 2) A field in database will be used as flag for usage limit. when "number of calls" exceeds the usage limit, it will flag it as "finished usage limit". 3) when a INVITE arrives, a check will be made with $fU against DB. With this framework in mind, I have read "db_mysql" module. And to my surprise, no direct the database functions are not exported to the cfg. I don't know if any module in kamailio exports mysql_queury() to cfg, which i need for my purpose. And may be there is some built in module which provides a higher level layer which will enable myself achieving my goal. If in the end i need "exported" mysql functions, then i can develop it myself. So which way i should go? Thanks in advance - -- - -aft