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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
<?
# 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-add.php3,v 1.12 2000/05/04 01:30:37 atrus Exp $
#
################################################################################
# CHANGELOG #
################################################################################
# 7/22/99 - Keith Schoenefeld: Cleaned up code, converted all IF(): to if(){. #
# 8/9/99 - Add code for requesting an IRM ID
# 9/10/99 - Finally worked on software carryover. Code is horrible ATM,
# but it seems all I can get to work.
################################################################################
include("../irm.inc");
AuthCheck("admin");
$db = new DB;
if ($flags_server == "yes")
{
$flags_server = 1;
} else
{
$flags_server = 0;
}
if ($reqID != 0)
{
$query = "SELECT ID FROM computers WHERE (ID = $reqID)";
$result = $db->query($query);
if ($db->numrows($result) == 0)
{
$ID = $reqID;
} else
{
commonHeader("Error");
PRINT "A computer with ID $reqID already exists. Please pick a new ID";
commonFooter();
exit();
}
}
if ($reqID == 0) {
$ID = "NULL";
}
$comments = addslashes($comments);
$query = "INSERT INTO computers (ID, name, type, flags_server, os, osver, processor, processor_speed, location, serial, otherserial, ramtype, ram, network, ip, mac, hdspace, contact, contact_num, comments, date_mod) VALUES ($ID, '$name', '$type','$flags_server', '$os',
'$osver', '$processor', '$processor_speed','$location',
'$serial', '$otherserial', '$ramtype', '$ram', '$network',
'$ip','$mac', '$hdspace', '$contact','$contact_num',
'$comments', '$date_mod')";
$result = $db->query($query);
$query = "SELECT ID FROM computers WHERE (date_mod = '$date_mod')";
$result = $db->query($query);
$cID = $db->result($result, 0, "ID");
logevent($cID, "computers", 4, "database", "$IRMName added record");
$query = "SELECT * FROM templ_inst_software WHERE (cID =
$templID)";
$result = $db->query($query);
$number = $db->numrows($result);
$i = 0;
while ($i < $number)
{
$sID = $db->result($result, $i, "sID");
$query = "INSERT INTO inst_software VALUES (NULL, $cID, $sID)";
$trash = $db->query($query);
$i++;
}
if ($iface_do == "yes")
{
$query = "INSERT INTO networking_ports VALUES (NULL, $cID, 1, '$iface', '$ip', '$mac', 1, 'Port 1')";
$result = $db->query($query);
}
if(strstr($HTTP_REFERER, "add=1") != FALSE) {
header("Location: $HTTP_REFERER");
} else {
header("Location: $HTTP_REFERER&add=1\n\n");
}
?>
|
