Hi,<br>

&nbsp;&nbsp;&nbsp; You can do like this:<br>

&nbsp;1. When a customer signs up for his W-Fi service, after an insert
into hsi 'subsriber' table, the same record should be passed to you for
inserting into your 'subscriber' table so that his users are
autheinticated succesfully against your AAA requests.<br>

&nbsp;&nbsp;&nbsp; For implementing this, you give him your db
credentials+schema , so that he can run the query one after another in
hsi registration script.<br>

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 and users
from the Wi-Fi provider.<br>

3. Finally, At the time of settlement, do query something like &quot;select
CDR where flag='ON' &quot; and present the records to him for settlement.<br>

<br>

Regard,<br>

Ashutosh<br><br><div><span class="gmail_quote">On 4/26/06, <b class="gmail_sendername">Nhadie</b> &lt;<a href="mailto:nhadie@tbgi.net.ph">nhadie@tbgi.net.ph</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi All,<br><br>I have built an ser server and offering postpaid voip right now. It's just a<br>basic ser setup, authenticate then make calls then i bill them.<br><br>But one client that offers Wi-Fi pepaid card would like to offer VoIP
<br>service using their card and he's going to use my system. My main problem is<br>how to integrate it to their billing system.<br><br>how can i do it in such a way that his customer can use my voip service and<br>deduct the amount of usage on their Wi-Fi credit? And then I'll just bill my
<br>client for the usage of all his customers.<br><br>hope my question was clear, thank you in advance.<br><br>Regards<br>Nhadie<br><br>________________________________________________<br>Message sent using UebiMiau 2.7<br>
<br>_______________________________________________<br>Serusers mailing list<br><a href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br><a href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers
</a><br></blockquote></div><br><br clear="all"><br>-- <br>-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.2.7 (GNU/Linux)
iD8DBQBEPo9P/OykOp7fM/wRAjw8AKCOlSsiHl7cyfCiitFJyEIEMhinHgCfb6YX
lrreitIO+tLZKrpjm81hsbY= =MEGA<br> -----END PGP SIGNATURE----- &quot;<br><br>There are 10 kinds of people in this world, those who understand Binary and those who dont&quot;.