On Fri, 2003-06-13 at 11:39, Roberto Pioli wrote:
> > It's possible for sure, I'm using start/stop date/time, in Dialup-Admin
> > is implemented something for callduration per month if I remember
> > correctly. I changed the sql query in the Authorization Queries:
> >
> > authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM
> > ${authcheck_table} WHERE Username = '%{SQL-User-Name}' AND onhold<>'Y'
> > AND NOW() BETWEEN StartDate AND StopDate ORDER BY id"
>
> Thanks,but how is the table ?I don't know very well sql .do you have an
> example of the table?
It's very simple, I've added the onhold field and the StartDate and
StopDate. The onhold field is used to disable users. Btw, I don't know
sql very well either ;-)
I've created a simple php frontend also, not that DialupAdmin isn't
good, but other people need to use it and DA has to much features for
them...
mysql> describe radcheck;
+-----------+------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-----------+------------------+------+-----+---------------------+----------------+
| id | int(11) unsigned | | PRI | NULL |
auto_increment |
| UserName | varchar(64) | | MUL |
| |
| Attribute | varchar(32) | | |
| |
| Value | varchar(253) | | |
| |
| op | char(2) | YES | | NULL
| |
| onhold | char(1) | | | N
| |
| StartDate | datetime | | | 0000-00-00 00:00:00
| |
| StopDate | datetime | | | 0000-00-00 00:00:00
| |
+-----------+------------------+------+-----+---------------------+----------------+
8 rows in set (0.00 sec)
Chris
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
