dns_dkim_edit.php 6.96 KB
Newer Older
Florian Schaal's avatar
Florian Schaal committed
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
<?php

/*
Copyright (c) 2007, Till Brehm, projektfarm Gmbh
Copyright (c) 2013, Florian Schaal, info@schaal-24.de
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
are permitted provided that the following conditions are met:

    * Redistributions of source code must retain the above copyright notice,
      this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright notice,
      this list of conditions and the following disclaimer in the documentation
      and/or other materials provided with the distribution.
    * Neither the name of ISPConfig nor the names of its contributors
      may be used to endorse or promote products derived from this software without
      specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

/******************************************
* Begin Form configuration
******************************************/

$tform_def_file = "form/dns_dkim.tform.php";

/******************************************
* End Form configuration
******************************************/

42
43
require_once '../../lib/config.inc.php';
require_once '../../lib/app.inc.php';
Florian Schaal's avatar
Florian Schaal committed
44
45
46
47
48
49
50
51
52

//* Check permissions for module
$app->auth->check_module_permissions('dns');

// Loading classes
$app->uses('tpl,tform,tform_actions,validate_dns');
$app->load('tform_actions');

class page_action extends tform_actions {
53

Florian Schaal's avatar
Florian Schaal committed
54
55
56
57
	function onShowNew() {
		global $app, $conf;
		// we will check only users, not admins
		if($_SESSION["s"]["user"]["typ"] == 'user') {
58

Florian Schaal's avatar
Florian Schaal committed
59
			// Get the limits of the client
60
			$client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
61
			$client = $app->db->queryOneRecord("SELECT limit_dns_record FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
62

Florian Schaal's avatar
Florian Schaal committed
63
64
			// Check if the user may add another record.
			if($client["limit_dns_record"] >= 0) {
65
				$tmp = $app->db->queryOneRecord("SELECT count(id) as number FROM dns_rr WHERE sys_groupid = ?", $client_group_id);
Florian Schaal's avatar
Florian Schaal committed
66
67
68
69
70
71
72
				if($tmp["number"] >= $client["limit_dns_record"]) {
					$app->error($app->tform->wordbook["limit_dns_record_txt"]);
				}
			}
		}

		parent::onShowNew();
Florian Schaal's avatar
Florian Schaal committed
73

Florian Schaal's avatar
Florian Schaal committed
74
        $soa = $app->db->queryOneRecord("SELECT * FROM dns_soa WHERE id = ? AND ?", $_GET['zone'], $app->tform->getAuthSQL('r'));
Florian Schaal's avatar
Florian Schaal committed
75
76
77
78
79
80
        $sql=$app->db->queryOneRecord("SELECT dkim_public, dkim_selector FROM mail_domain WHERE domain = ? AND dkim = 'y' AND ?", substr_replace($soa['origin'],'',-1), $app->tform->getAuthSQL('r'));
        $public_key=str_replace(array('-----BEGIN PUBLIC KEY-----','-----END PUBLIC KEY-----',"\r","\n"),'',$sql['dkim_public']);
		$app->tpl->setVar('public_key', $public_key);
		$app->tpl->setVar('selector', $sql['dkim_selector']);
		$app->tpl->setVar('name', $soa['origin']);

Florian Schaal's avatar
Florian Schaal committed
81
82
83
84
85
	}

	function onSubmit() {
		global $app, $conf;
		// Get the parent soa record of the domain
Florian Schaal's avatar
Florian Schaal committed
86
		$soa = $app->db->queryOneRecord("SELECT * FROM dns_soa WHERE id = ? AND ?", $_POST["zone"], $app->tform->getAuthSQL('r'));
Florian Schaal's avatar
Florian Schaal committed
87
88
		// Check if Domain belongs to user
		if($soa["id"] != $_POST["zone"]) $app->tform->errorMessage .= $app->tform->wordbook["no_zone_perm"];
89

Florian Schaal's avatar
Florian Schaal committed
90
91
92
		// Check the client limits, if user is not the admin
		if($_SESSION["s"]["user"]["typ"] != 'admin') { // if user is not admin
			// Get the limits of the client
93
			$client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
94
			$client = $app->db->queryOneRecord("SELECT limit_dns_record FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
Florian Schaal's avatar
Florian Schaal committed
95
96
			// Check if the user may add another record.
			if($this->id == 0 && $client["limit_dns_record"] >= 0) {
97
				$tmp = $app->db->queryOneRecord("SELECT count(id) as number FROM dns_rr WHERE sys_groupid = ?", $client_group_id);
Florian Schaal's avatar
Florian Schaal committed
98
99
100
101
102
				if($tmp["number"] >= $client["limit_dns_record"]) {
					$app->error($app->tform->wordbook["limit_dns_record_txt"]);
				}
			}
		} // end if user is not admin
103

Florian Schaal's avatar
Florian Schaal committed
104
105
		// Set the server ID of the rr record to the same server ID as the parent record.
		$this->dataRecord["server_id"] = $soa["server_id"];
106

Florian Schaal's avatar
Florian Schaal committed
107
		// add dkim-settings to the public-key in the txt-record
108
109
110
		if (!empty($this->dataRecord['data'])) {
			$this->dataRecord['data']='v=DKIM1; t=s; p='.$this->dataRecord['data'];
			$this->dataRecord['name']=$this->dataRecord['selector'].'._domainkey.'.$this->dataRecord['name'];
Florian Schaal's avatar
Florian Schaal committed
111
			$this->dataRecord['ttl']=60;
112
		}
Florian Schaal's avatar
Florian Schaal committed
113
114
115
116
117
118
119
120
121
			// Update the serial number  and timestamp of the RR record
			$soa = $app->db->queryOneRecord("SELECT serial FROM dns_rr WHERE id = ?", $this->id);
			$this->dataRecord["serial"] = $app->validate_dns->increase_serial($soa["serial"]);
			$this->dataRecord["stamp"] = date('Y-m-d H:i:s');

			// check for duplicate entry
			$check=$app->db->queryOneRecord("SELECT * FROM dns_rr WHERE zone = ? AND type = ? AND data = ? AND name = ?", $this->dataRecord["zone"], $this->dataRecord["type"], $this->dataRecord["data"], $this->dataRecord['name']);
			if ($check!='') $app->tform->errorMessage .= $app->tform->wordbook["record_exists_txt"];
			if (empty($this->dataRecord['data'])) $app->tform->errorMessage .= $app->tform->wordbook["dkim_disabled_txt"];
Florian Schaal's avatar
Florian Schaal committed
122
123
		parent::onSubmit();
	}
124

Florian Schaal's avatar
Florian Schaal committed
125
126
	function onAfterInsert() {
		global $app, $conf;
127

Florian Schaal's avatar
Florian Schaal committed
128
		//* Set the sys_groupid of the rr record to be the same then the sys_groupid of the soa record
Florian Schaal's avatar
Florian Schaal committed
129
		$soa = $app->db->queryOneRecord("SELECT sys_groupid,serial FROM dns_soa WHERE id = ? AND ?", $this->dataRecord["zone"], $app->tform->getAuthSQL('r'));
Florian Schaal's avatar
Florian Schaal committed
130
131
132
133
134
135
136
		$app->db->datalogUpdate('dns_rr', "sys_groupid = ".$soa['sys_groupid'], 'id', $this->id);

		//* Update the serial number of the SOA record
		$soa_id = $app->functions->intval($_POST["zone"]);
		$serial = $app->validate_dns->increase_serial($soa["serial"]);
		$app->db->datalogUpdate('dns_soa', "serial = $serial", 'id', $soa_id);
	}
137

Florian Schaal's avatar
Florian Schaal committed
138
139
	function onAfterUpdate() {
		global $app, $conf;
140

Florian Schaal's avatar
Florian Schaal committed
141
		//* Update the serial number of the SOA record
Florian Schaal's avatar
Florian Schaal committed
142
		$soa = $app->db->queryOneRecord("SELECT serial FROM dns_soa WHERE id = ? AND ?", $this->dataRecord["zone"], $app->tform->getAuthSQL('r'));
Florian Schaal's avatar
Florian Schaal committed
143
144
145
146
		$soa_id = $app->functions->intval($_POST["zone"]);
		$serial = $app->validate_dns->increase_serial($soa["serial"]);
		$app->db->datalogUpdate('dns_soa', "serial = $serial", 'id', $soa_id);
	}
147

Florian Schaal's avatar
Florian Schaal committed
148
149
150
151
152
153
}

$page = new page_action;
$page->onLoad();

?>