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
|
<?php
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** 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 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.
**/
?>
<?php
function add_screen($name,$cols,$rows)
{
if(!check_right("Screen","A",0))
{
error("Insufficient permissions");
return 0;
}
$sql="insert into screens (name,cols,rows) values ('$name',$cols,$rows)";
return DBexecute($sql);
}
function update_screen($screenid,$name,$cols,$rows)
{
if(!check_right("Screen","U",0))
{
error("Insufficient permissions");
return 0;
}
$sql="update screens set name='$name',cols=$cols,rows=$rows where screenid=$screenid";
return DBexecute($sql);
}
function delete_screen($screenid)
{
$sql="delete from screens_items where screenid=$screenid";
$result=DBexecute($sql);
if(!$result)
{
return $result;
}
$sql="delete from screens where screenid=$screenid";
return DBexecute($sql);
}
function add_screen_item($resource,$screenid,$x,$y,$resourceid,$width,$height,$colspan,$rowspan,$elements)
{
$sql="delete from screens_items where screenid=$screenid and x=$x and y=$y";
DBexecute($sql);
$sql="insert into screens_items (resource,screenid,x,y,resourceid,width,height,colspan,rowspan,elements) values ($resource,$screenid,$x,$y,$resourceid,$width,$height,$colspan,$rowspan,$elements)";
return DBexecute($sql);
}
function update_screen_item($screenitemid,$resource,$resourceid,$width,$height,$colspan,$rowspan,$elements)
{
$sql="update screens_items set resource=$resource,resourceid=$resourceid,width=$width,height=$height,colspan=$colspan,rowspan=$rowspan,elements=$elements where screenitemid=$screenitemid";
return DBexecute($sql);
}
function delete_screen_item($screenitemid)
{
$sql="delete from screens_items where screenitemid=$screenitemid";
return DBexecute($sql);
}
function get_screen_by_screenid($screenid)
{
$sql="select * from screens where screenid=$screenid";
$result=DBselect($sql);
if(DBnum_rows($result) == 1)
{
return DBfetch($result);
}
else
{
error("No screen with screenid=[$screenid]");
}
return $result;
}
?>
|