File: computers-groups-batch-add.php

package info (click to toggle)
irm 1.5.3.1-1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 2,436 kB
  • ctags: 3,308
  • sloc: php: 16,796; sh: 127; perl: 97; pascal: 56; makefile: 48
file content (56 lines) | stat: -rw-r--r-- 1,795 bytes parent folder | download | duplicates (2)
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
<?php
#    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.
#

require("../include/irm.inc");
require_once 'lib/Config.php';
require_once 'include/i18n.php';

$outquery = stripslashes(stripslashes($outquery));
echo $outquery;
AuthCheck("tech");
commonHeader(_("Computers") . " - " . _("Add to Group Completed"));

$DB = Config::Database();
// Group ID, quoted for DB select
$qg = $DB->getTextValue($sID);

$data = $DB->getAll($outquery);
print "<UL>\n";
foreach ($data as $result)
{
	$qc = $DB->getTextValue($result['ID']);
	if (0 == $DB->getOne("SELECT COUNT(*) FROM comp_group WHERE comp_id=$qc AND group_id=$qg"))
	{
		$vals = array(
			'comp_id' => $result['ID'],
			'group_id' => $sID
			);
			$DB->InsertQuery('comp_group', $vals);
		
		print "<LI>".sprintf(_("Computer ID %s added to group %s"), $result['ID'], $sID)."</LI>\n";
	}
	else
	{
		print "<LI>".sprintf(_("Computer ID %s already in this group."), $result['ID'])."</LI>\n";
	}
}
print "</UL>\n";

__("The add to group operation has been completed.");
commonFooter();