Hi, See my answers inline. On 4/27/06, *Ronald Ramos* &lt;nhadie(a)tbgi.net.ph <mailto:nhadie@tbgi.net.ph>> wrote: Hi, I'm sorry didn't understand swhat eeds to be done please see inline for some more of my questions Kumar, Ashutosh wrote: > Hi, > You can do like this: > 1. When a customer signs up for his Wi-Fi service, after an

> into hsi 'subsriber' table, the same record should be passed to

when you say his subscriber table, do you mean wi-fi subscriber table? or he should have a voip subscriber table of his own? By "his subscriber table' i mean the WIFI subscriber table. In addition, you will have voip table for your own use. So it is like, - WIFI provider has wifi subscriber table -VOIP provider has voip subscriber table. > For implementing this, you give him your db credentials+schema

registration script. what type of query will he run? The query will be a simple SQL insert statement, which will insert the record into the VOIP subsriber table. It may be noted that there are two ways to do the insert. 1. The WIFI sends/redirects the insertion page after hsi wifi registration to the VOIP web'site inserion script. 2. The VOIP provider gives database access to WIFI provider to to the insertion. Here the VOIP insertion will be almost same as WIFI insertion, differing only in DB info. > 2. Create/Use a flag set to 'ON' for all such customers which have > been created in such a manner.This will differentiate your users

I'm also not familiar with flags, i'll try to read more on that, but basically what does that flag do? FLAG here denotes a database BOOL field (it may be char, int whaterver, serving the same purpose), which will have two values,; one for your users, and another for the users in the table who are created 'from' the WIFI provider side. For eg, Here you might set the default flag value as 0 (ZERO or OFF), and when you add a WIFI user record, set the flag in that case=1 (ON). "select > CDR where flag='ON' " and present the records to him for

For Billing, create a cron script, which genertate a report of successful based on the following query SELECT * FROM CDR WHERE flag=1 AND DISCONNECT_CAUSE='SUCESS' (Of course, the above might differ from your chema) . The generated report can be presented for billing to your WIFI provider. when his user login to their wi-fi system the billing already

meaning the credit already starts to go down, then on that duration he decided he wants to make a phone call: 1. how can i make it in such a way that the username and password on his card, will be the one configured on the phone (example an XPRO) that will authenticate to mine (or maybe his subcriber table if that's what you mean on number 1). If the subscriber table you created is integrated with a radius server (freeqrduius?), and you are using an appropriate call flow route in ser.cfg, then the authentication will be automatic, no need to do anything extra. 2. next will be how can i send him the update of how much he has already consume fo VoIP alone to deduct it to hisWi-Fi credit simultaneously with his Wi-Fi usage? See Answer 3. Here, automaitically, the charge you will present to him will be automatcally only for the charges incurred by your switch, irrespective of the fact that the subscirber was latched up to WIFI, dialup or whatever. <mailto:nhadie@tbgi.net.ph> <mailto:nhadie@tbgi.net.ph <mailto:nhadie@tbgi.net.ph>>> now. > It's just a > basic ser setup, authenticate then make calls then i bill

offer VoIP main > problem is > how to integrate it to their billing system. > > how can i do it in such a way that his customer can use my

> service and > deduct the amount of usage on their Wi-Fi credit? And then

serusers(a)lists.iptel.org <mailto:serusers@lists.iptel.org>> ------------------------------------------------------------------------ -- There are 10 kinds of people in this world, those who understand Binary and those who dont".