Automatic Suspension of Packages

[Shivkumar]

hi,
I have a freeside server up and running with the following config:
debian sarge/testing kernel 2.4.27-1
freeside v1.5.0 pre6
HTML::Mason
apache-ssl-1.3.33+mod_perl-1.29
postgresql-7.4.7-2

I was wondering if there was some way for packages like say
introductory -10 hr or 3 day free trial packages, to become suspended
automatically after that period based on the RADIUS accounting
information.
~ For example, I create a package with 1 hr usage and provision it to a
customer.
I then log in as the customer on another machine ( through my hotspot
controller). I see that the user could stay logged on well past the 1
hr limit. and in fact logout and login subsequently after  the 1 hour
period is over.
I know that there is a way to do it in freeradius wherein an SQL query
is run checking for SUM(Max-All-Sessions) where Max-All-Sessions is a
value defined in the radcheck table. The RADIUS sends an Access-Reject
for requests that exceed this value. Currently, I am forced to add
this value manually as soon as each user is created if I want to
enforce this because the Freeside Insert query just inserts the
UserName and Password value into the database.

Bottom-Line is: Can the Insert query be changed in Freeside without
palying with the source code?

-- 
Regards,

Shivkumar