RE: Freeze (lock) Users on RadiusNT

Mokrosh Pietro ( pietro@sknet.com )
Mon, 12 Jan 1998 11:14:06 +0100

try running this select. don't forget to switch to your database with
"use emerald" or whatewer.

UPDATE SubAccounts=20
Set Active=3D0
WHERE Login=3D'3soft'=20

if you want to "freeze" all accounts of that customer, you have to do =
it
in MasterAccounts - like this

UPDATE MasterAccounts
Set Active=3D0
WHERE CustomerID=3D333

re-activating is the same but use Active=3D1

pietro

> -----Original Message-----
> From: Endang Rachmawati Adwiarto [SMTP:endang@cbn.net.id]
> Sent: 12. janu=E1r 1998 10:30
> To: radiusnt@iea-software.com
> Subject: Freeze (lock) Users on RadiusNT
>=20
> For users who have not paid their bill, we usually freeze their
> accounts.
> Is there a way to freeze an account on RadiusNT so it can't be used
> (locked)
> temporarily without romoving user data on Materaccounts and
> Subaccounts
> tables?
>=20
> I'm using RadiusNT with SQL Database.
>=20
> Appreciate the help,
> Endang
> --
>=20
>=20
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com