Re: [Emerald] Clear Calls Script

Josh Hillman ( (no email) )
Mon, 26 Jul 1999 13:08:52 -0400

From: PowerNet <psc5@powersupply.net>
> I need to get an SQL script that will clear the online calls table.

To clear everything in there, I use the following:

UPDATE ServerPorts
SET AcctStatusType=2

To clear users on a specific device, do something like the following:

SELECT * FROM Servers /* find out what device is what */

UPDATE ServerPorts
SET AcctStatusType=2
WHERE ServerID = 5 /* specific device */

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart