Just another small question before i jump into testing. If output from sub-query is less than 32bit, I can easily store it in Tmp-Integer , But sometimes when the user data usage is null, the sub-query will output more than 32bit ex. 10GB Limit But user downloaded 0 Bytes. In that condition it is impossible to store it in Tmp-Integer . So ultimately the Integer passed by xlat and the stored in Tmp-Integer will differ. Regards Suman Dash On Mon, Aug 8, 2011 at 7:45 PM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 8 Aug 2011, at 16:11, Suman Dash wrote:
So what you say is that i do all comparision within sql sub-query and whatever output i need to define if less than 32bit store it into an Integer and do Unlang control / reply updates ?
Seems quite right .. Will try and get back with results.
Exactly :)
Feel free to post some samples if you get it working and i'll put them up on the wiki.
-Arran
On Mon, Aug 8, 2011 at 3:31 PM, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
Unfortunately I am not much of a programmer .
Ok... but you know SQL right? Which is why i'm suggesting to do the comparison in the SQL database.
Therefore if you can put some examples / pointers based on my requirement, it will be a headstart for me .
http://dev.mysql.com/doc/refman/5.0/en/comparisons-using-subqueries.html
Use SELECT COUNT(*) for the outer query and then compare that value in unlang.
-Arran
Arran Cudbard-Bell a.cudbardb@freeradius.org
RADIUS - Half the complexity of Diameter
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Arran Cudbard-Bell a.cudbardb@freeradius.org
RADIUS - Half the complexity of Diameter
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html