CREATE TRIGGER calls_insert ON dbo.Calls
FOR INSERT
AS
UPDATE sp
Set sp.Username = i.Username,
sp.AcctStatusType = i.AcctStatusType,
sp.CallDate = i.CallDate,
sp.FramedAddress = i.FramedAddress,
sp.CallerID = i.CallerID,
sp.ConnectInfo = i.ConnectInfo,
sp.AcctSessionID = i.AcctSessionID
FROM Servers s, ServerPorts sp, inserted i
WHERE s.IPAddress = i.NASIdentifier AND
s.ServerID = sp.ServerID AND
sp.Port = i.NASPort AND
(i.CallDate >= sp.CallDate OR
sp.CallDate IS NULL)
UPDATE sa
Set sa.TimeLeft = sa.TimeLeft - (i.AcctSessionTime/60 + 1),
sa.LastModifyDate = getdate()
FROM SubAccounts sa, inserted i
WHERE sa.Login = i.Username
AND sa.TimeLeft IS NOT NULL
AND i.AcctStatusType = 2
-----Original Message-----
From: Peter Deacon [mailto:peterd@iea-software.com]
Sent: Friday, May 05, 2000 10:38 AM
To: radiusnt@iea-software.com
Subject: Re: [RadiusNT] Radius 3.0 Crashes
On Fri, 5 May 2000, NCKCN wrote:
> Peter,
> Is the RadiusNT 3 updated from 3.0.163? There doesn't seem to be any
> descriptor on the FTP site. It just says RadiusNT30.exe.
Ya, the one on the ftp site is 3.0.172.
ciao,
Peter
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart