1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
<?
# IRM - The Information Resource Manager
# Copyright (C) 1999 Yann Ramin
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License (in file COPYING) for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
#
# $Id: computers-del.php3,v 1.8 2000/05/04 01:30:37 atrus Exp $
#
################################################################################
# CHANGELOG #
################################################################################
# 7/22/99 - Keith Schoenefeld: Cleaned up code, converted all IF(): to if(){. #
################################################################################
include("../irm.inc");
AuthCheck("admin");
$db = new DB;
header("Location: computers-index.php3");
$query = "SELECT * FROM tracking WHERE (computer = \"$ID\")";
$result = $db->query($query);
$number = $db->numrows($result);
$i=0;
while ($i < $number)
{
$job = $db->result($result,$i,"ID");
$query = "DELETE FROM followups WHERE (tracking = \"$job\")";
$db->query($query);
$i++;
}
$query = "DELETE FROM tracking WHERE (computer = \"$ID\")";
$result = $db->query($query);
$query = "DELETE FROM computers WHERE (ID = \"$ID\")";
$result = $db->query($query);
$query = "DELETE FROM inst_software WHERE (cID = \"$ID\")";
$result = $db->query($query);
$query = "DELETE FROM networking_ports WHERE (device_on = $ID AND device_type = 1)";
$result = $db->query($query);
logevent($ID, "computers", 4, "database", "$IRMName deleted record");
?>
|
