Re: [SR-Users] Prepaid system using dialog and sqlops

Hi, I am still struggling to get a prepaid system for my service. After installing SIREMIS, I am able to get the CDRs updated. But even after adding the cron settings, the call duration doesn't get updated. And also in http://lists.sip-router.org/pipermail/sr-users/2012-January/071517.html it has been mentioned that "If it is the case of 1 call per user at a time, then practically can be done from kamailio config only. When call starts, compute the max duration for that call based on caller/destination (e.g., call a stored procedure via sqlops) and set the dialog timeout to that duration. When call ends (BYE in main route or timeout route) update the credit accordingly." Can somebody let me know if my understanding is correct. 1) Add a field called "credits" in the database. And topup that field. 2) First compute max permitted duration for that user by multiplying the cost for number prefix (say +91) and pulse. 3) And finally add this value to timeout of dialog. modparam("dialog", "default_timeout", 100000) $dlg_ctx(timeout_bye) = 1; Will this work? Any help would be appreciated.