commit | author | age
|
aa1500
|
1 |
<?php |
T |
2 |
|
|
3 |
/* |
|
4 |
Copyright (c) 2008, Till Brehm, projektfarm Gmbh |
|
5 |
All rights reserved. |
|
6 |
|
|
7 |
Redistribution and use in source and binary forms, with or without modification, |
|
8 |
are permitted provided that the following conditions are met: |
|
9 |
|
|
10 |
* Redistributions of source code must retain the above copyright notice, |
|
11 |
this list of conditions and the following disclaimer. |
|
12 |
* Redistributions in binary form must reproduce the above copyright notice, |
|
13 |
this list of conditions and the following disclaimer in the documentation |
|
14 |
and/or other materials provided with the distribution. |
|
15 |
* Neither the name of ISPConfig nor the names of its contributors |
|
16 |
may be used to endorse or promote products derived from this software without |
|
17 |
specific prior written permission. |
|
18 |
|
|
19 |
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND |
|
20 |
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED |
|
21 |
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. |
|
22 |
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, |
|
23 |
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, |
|
24 |
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, |
|
25 |
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY |
|
26 |
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING |
|
27 |
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, |
|
28 |
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
|
29 |
*/ |
|
30 |
|
|
31 |
class custom_datasource { |
|
32 |
|
|
33 |
function master_templates($field, $record) { |
|
34 |
global $app, $conf; |
|
35 |
$records = $app->db->queryAllRecords("SELECT template_id,template_name FROM client_template WHERE template_type ='m'"); |
|
36 |
$records_new[0] = $app->lng('Custom'); |
|
37 |
foreach($records as $rec) { |
|
38 |
$key = $rec['template_id']; |
|
39 |
$records_new[$key] = $rec['template_name']; |
|
40 |
} |
|
41 |
return $records_new; |
|
42 |
} |
8c4aa3
|
43 |
|
T |
44 |
function dns_servers($field, $record) { |
|
45 |
global $app, $conf; |
|
46 |
|
|
47 |
if($_SESSION["s"]["user"]["typ"] == 'user') { |
|
48 |
// Get the limits of the client |
|
49 |
$client_group_id = $_SESSION["s"]["user"]["default_group"]; |
|
50 |
$client = $app->db->queryOneRecord("SELECT default_dnsserver FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); |
|
51 |
$sql = "SELECT server_id,server_name FROM server WHERE server_id = ".$client['default_dnsserver']; |
|
52 |
} else { |
|
53 |
$sql = "SELECT server_id,server_name FROM server WHERE dns_server = 1 ORDER BY server_name"; |
|
54 |
} |
|
55 |
$records = $app->db->queryAllRecords($sql); |
|
56 |
$records_new = array(); |
|
57 |
if(is_array($records)) { |
|
58 |
foreach($records as $rec) { |
|
59 |
$key = $rec['server_id']; |
|
60 |
$records_new[$key] = $rec['server_name']; |
|
61 |
} |
|
62 |
} |
|
63 |
return $records_new; |
|
64 |
} |
|
65 |
|
|
66 |
|
|
67 |
function client_servers($field, $record) { |
|
68 |
global $app, $conf; |
|
69 |
|
|
70 |
$server_type = $field['name']; |
|
71 |
|
542146
|
72 |
switch($server_type) { |
T |
73 |
case 'default_mailserver': |
|
74 |
$field = 'mail_server'; |
|
75 |
break; |
|
76 |
case 'default_webserver': |
|
77 |
$field = 'web_server'; |
|
78 |
break; |
|
79 |
case 'default_dnsserver': |
|
80 |
$field = 'dns_server'; |
|
81 |
break; |
|
82 |
case 'default_fileserver': |
|
83 |
$field = 'file_server'; |
|
84 |
break; |
|
85 |
case 'default_dbserver': |
|
86 |
$field = 'db_server'; |
|
87 |
break; |
|
88 |
case 'default_vserverserver': |
|
89 |
$field = 'vserver_server'; |
|
90 |
break; |
|
91 |
default: |
|
92 |
$field = 'web_server'; |
|
93 |
break; |
|
94 |
} |
|
95 |
|
8c4aa3
|
96 |
if($_SESSION["s"]["user"]["typ"] == 'user') { |
T |
97 |
// Get the limits of the client |
|
98 |
$client_group_id = $_SESSION["s"]["user"]["default_group"]; |
|
99 |
$sql = "SELECT $server_type as server_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"; |
|
100 |
$client = $app->db->queryOneRecord($sql); |
542146
|
101 |
if($client['server_id'] > 0) { |
T |
102 |
//* Select the default server for the client |
|
103 |
$sql = "SELECT server_id,server_name FROM server WHERE server_id = ".$client['server_id']; |
|
104 |
} else { |
|
105 |
//* Not able to find the clients defaults, use this as fallback and add a warning message to the log |
|
106 |
$app->log('Unable to find default server for client in custom_datasource.inc.php',1); |
|
107 |
$sql = "SELECT server_id,server_name FROM server WHERE $field = 1 ORDER BY server_name"; |
|
108 |
} |
8c4aa3
|
109 |
} else { |
542146
|
110 |
//* The logged in user is admin, so we show him all available servers of a specific type. |
T |
111 |
$sql = "SELECT server_id,server_name FROM server WHERE $field = 1 ORDER BY server_name"; |
8c4aa3
|
112 |
} |
542146
|
113 |
|
8c4aa3
|
114 |
$records = $app->db->queryAllRecords($sql); |
T |
115 |
$records_new = array(); |
|
116 |
if(is_array($records)) { |
|
117 |
foreach($records as $rec) { |
|
118 |
$key = $rec['server_id']; |
|
119 |
$records_new[$key] = $rec['server_name']; |
|
120 |
} |
|
121 |
} |
|
122 |
return $records_new; |
|
123 |
} |
|
124 |
|
|
125 |
|
aa1500
|
126 |
|
T |
127 |
} |
|
128 |
|
|
129 |
?> |