Why not create a view in the database that joins the two tables? Then you can get the login time in a single query.
On 28/09/2011, at 1:23 AM, shiv <shivkumar.j...@gmail.com> wrote: > Update - I've managed to get it working against a custom table in the mysql > radius database. The sites-enabled/default authorize section is as below:- > > update request { > Huntgroup-Name := "%{sql:SELECT `groupname` FROM > `radhuntgroup` WHERE rtrmac='%{Called-Station-Id}'}" > } > > if ("%{Huntgroup-Name}" != "") { > update request{ > Tmp-String-0 = "%{sql:SELECT `logintime` FROM > `wifihotspots` WHERE hotspotname='%{Huntgroup-Name}'}" > } > } > > if ( "%{Tmp-String-0}" != "") { > update control{ > Login-Time := "%{Tmp-String-0}" > } > > } > > > The wifihotspots table contains Huntgroup-Name and its Corresponding > Login-Time > Thanks again for the help! > > > -- > View this message in context: > http://freeradius.1045715.n5.nabble.com/Enforcing-Login-Time-on-NAS-tp4845142p4845762.html > Sent from the FreeRadius - User mailing list archive at Nabble.com. > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html