inc/record.inc.php
author rejo
Mon, 31 Mar 2008 06:43:38 +0000
changeset 119 f74e4f88b680
parent 115 b1d7998a903e
child 120 982f722376b4
permissions -rwxr-xr-x
[feladat @ 222] Changed case of Poweradmin's name (a is now lowercase).
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
71
e1b918eaf69a [feladat @ 118]
peter
parents: 65
diff changeset
     1
<?php
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     2
119
f74e4f88b680 [feladat @ 222]
rejo
parents: 115
diff changeset
     3
/*  Poweradmin, a friendly web-based admin tool for PowerDNS.
47
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     4
 *  See <https://rejo.zenger.nl/poweradmin> for more details.
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     5
 *
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     6
 *  Copyright 2007, 2008  Rejo Zenger <rejo@zenger.nl>
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     7
 *
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     8
 *  This program is free software: you can redistribute it and/or modify
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
     9
 *  it under the terms of the GNU General Public License as published by
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    10
 *  the Free Software Foundation, either version 3 of the License, or
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    11
 *  (at your option) any later version.
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    12
 *
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    13
 *  This program is distributed in the hope that it will be useful,
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    14
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    15
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    16
 *  GNU General Public License for more details.
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    17
 *
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    18
 *  You should have received a copy of the GNU General Public License
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    19
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
ae140472d97c [feladat @ 94]
rejo
parents: 40
diff changeset
    20
 */
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    21
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    22
function count_zone_records($zone_id) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    23
	global $db;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    24
	$sqlq = "SELECT COUNT(id) FROM records WHERE domain_id = ".$db->quote($zone_id);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    25
	$record_count = $db->queryOne($sqlq);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    26
	return $record_count;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    27
}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    28
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    29
function update_soa_serial($domain_id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    30
{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    31
	global $db;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    32
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
    33
	$sqlq = "SELECT notified_serial FROM domains WHERE id = ".$db->quote($domain_id);
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 5
diff changeset
    34
	$notified_serial = $db->queryOne($sqlq);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    35
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
    36
	$sqlq = "SELECT content FROM records WHERE type = 'SOA' AND domain_id = ".$db->quote($domain_id);
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 5
diff changeset
    37
	$content = $db->queryOne($sqlq);
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    38
	$need_to_update = false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    39
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    40
	// Getting the serial field.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    41
	$soa = explode(" ", $content);
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    42
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    43
	if(empty($notified_serial)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    44
		// Ok native replication, so we have to update.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    45
		$need_to_update = true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    46
	} elseif($notified_serial >= $soa[2]) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    47
		$need_to_update = true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    48
	} elseif(strlen($soa[2]) != 10) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    49
		$need_to_update = true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    50
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    51
		$need_to_update = false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    52
	}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    53
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    54
	if($need_to_update) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    55
		// Ok so we have to update it seems.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    56
		$current_serial = $soa[2];
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    57
		$new_serial = date('Ymd'); // we will add revision number later
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    58
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    59
		if(strncmp($new_serial, $current_serial, 8) === 0) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    60
			$revision_number = (int) substr($current_serial, -2);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    61
			if ($revision_number == 99) return false; // ok, we cannot update anymore tonight
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    62
			++$revision_number;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    63
			// here it is ... same date, new revision
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    64
			$new_serial .= str_pad($revision_number, 2, "0", STR_PAD_LEFT);	
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    65
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    66
			/*
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    67
			 * Current serial is not RFC1912 compilant, so let's make a new one
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    68
			 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    69
			$new_serial .= '00';
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    70
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    71
		$soa[2] = $new_serial; // change serial in SOA array
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    72
		$new_soa = "";		
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    73
		// build new soa and update SQL after that
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    74
		for ($i = 0; $i < count($soa); $i++) {	
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    75
			$new_soa .= $soa[$i] . " "; 
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    76
		}
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
    77
		$sqlq = "UPDATE records SET content = ".$db->quote($new_soa)." WHERE domain_id = ".$db->quote($domain_id)." AND type = 'SOA'";
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    78
		$db->Query($sqlq);
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    79
		return true;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    80
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    81
}  
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    82
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    83
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    84
 * Edit a record.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    85
 * This function validates it if correct it inserts it into the database.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    86
 * return values: true if succesful.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    87
 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    88
function edit_record($record) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    89
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    90
	if (verify_permission(zone_content_edit_others)) { $perm_content_edit = "all" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    91
	elseif (verify_permission(zone_content_edit_own)) { $perm_content_edit = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    92
	else { $perm_content_edit = "none" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    93
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    94
	$user_is_zone_owner = verify_user_is_owner_zoneid($record['zid']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    95
	$zone_type = get_domain_type($record['zid']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    96
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
    97
	if ( $zone_type == "SLAVE" || $perm_content_edit == "none" || $perm_content_edit == "own" && $user_is_zone_owner == "0" ) {
111
0a2342a64b83 [feladat @ 211]
rejo
parents: 106
diff changeset
    98
		error(ERR_PERM_EDIT_RECORD);
0a2342a64b83 [feladat @ 211]
rejo
parents: 106
diff changeset
    99
		return false;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   100
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   101
		if($record['content'] == "") {
111
0a2342a64b83 [feladat @ 211]
rejo
parents: 106
diff changeset
   102
			error(ERR_DNS_CONTENT);
0a2342a64b83 [feladat @ 211]
rejo
parents: 106
diff changeset
   103
			return false;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   104
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   105
		global $db;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   106
		// TODO: no need to check for numeric-ness of zone id if we check with validate_input as well?
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   107
		if (is_numeric($record['zid'])) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   108
			validate_input($record['zid'], $record['type'], $record['content'], $record['name'], $record['prio'], $record['ttl']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   109
			$query = "UPDATE records 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   110
					SET name=".$db->quote($record['name']).", 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   111
					type=".$db->quote($record['type']).", 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   112
					content=".$db->quote($record['content']).", 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   113
					ttl=".$db->quote($record['ttl']).", 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   114
					prio=".$db->quote($record['prio']).", 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   115
					change_date=".$db->quote(time())." 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   116
					WHERE id=".$db->quote($record['rid']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   117
			$result = $db->Query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   118
			if (PEAR::isError($result)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   119
				error($result->getMessage());
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   120
				return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   121
			} elseif ($record['type'] != 'SOA') {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   122
				update_soa_serial($record['zid']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   123
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   124
			return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   125
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   126
		else
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   127
		{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   128
			// TODO change to error style as above (returning directly)
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   129
			error(sprintf(ERR_INV_ARGC, "edit_record", "no zoneid given"));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   130
		}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   131
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   132
	return true;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   133
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   134
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   135
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   136
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   137
 * Adds a record.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   138
 * This function validates it if correct it inserts it into the database.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   139
 * return values: true if succesful.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   140
 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   141
function add_record($zoneid, $name, $type, $content, $ttl, $prio) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   142
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   143
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   144
	if (verify_permission(zone_content_edit_others)) { $perm_content_edit = "all" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   145
	elseif (verify_permission(zone_content_edit_own)) { $perm_content_edit = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   146
	else { $perm_content_edit = "none" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   147
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   148
	$user_is_zone_owner = verify_user_is_owner_zoneid($zoneid);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   149
	$zone_type = get_domain_type($zoneid);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   150
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   151
        if ( $zone_type == "SLAVE" || $perm_content_edit == "none" || $perm_content_edit == "own" && $user_is_zone_owner == "0" ) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   152
		error(ERR_PERM_ADD_RECORD);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   153
		return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   154
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   155
		if (validate_input($zoneid, $type, $content, $name, $prio, $ttl) ) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   156
			$change = time();
106
41d05ff53708 [feladat @ 206]
peter
parents: 98
diff changeset
   157
			$query = "INSERT INTO records (domain_id, name, type, content, ttl, prio, change_date) VALUES ("
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   158
						. $db->quote($zoneid) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   159
						. $db->quote($name) . "," 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   160
						. $db->quote($type) . "," 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   161
						. $db->quote($content) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   162
						. $db->quote($ttl) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   163
						. $db->quote($prio) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   164
						. $db->quote($change) . ")";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   165
			$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   166
			if (PEAR::isError($response)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   167
				error($response->getMessage());
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   168
				return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   169
			} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   170
				if ($type != 'SOA') { update_soa_serial($zoneid); }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   171
				return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   172
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   173
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   174
			return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   175
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   176
		return true;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   177
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   178
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   179
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   180
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   181
function add_supermaster($master_ip, $ns_name, $account)
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   182
{
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   183
        global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   184
        if (!is_valid_ip($master_ip) && !is_valid_ip6($master_ip)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   185
                error(ERR_DNS_IP);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   186
		return false;
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   187
        }
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   188
        if (!is_valid_hostname($ns_name)) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   189
                error(ERR_DNS_HOSTNAME);
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   190
		return false;
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   191
        }
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   192
	if (!validate_account($account)) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   193
		error(sprintf(ERR_INV_ARGC, "add_supermaster", "given account name is invalid (alpha chars only)"));
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   194
		return false;
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   195
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   196
        if (supermaster_exists($master_ip)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   197
                error(ERR_SM_EXISTS);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   198
		return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   199
        } else {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   200
                $db->query("INSERT INTO supermasters VALUES (".$db->quote($master_ip).", ".$db->quote($ns_name).", ".$db->quote($account).")");
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   201
                return true;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   202
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   203
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   204
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   205
function delete_supermaster($master_ip) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   206
	global $db;
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   207
        if (is_valid_ip($master_ip) || is_valid_ip6($master_ip))
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   208
        {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   209
                $db->query("DELETE FROM supermasters WHERE ip = ".$db->quote($master_ip));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   210
                return true;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   211
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   212
        else
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   213
        {
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   214
                error(sprintf(ERR_INV_ARGC, "delete_supermaster", "No or no valid ipv4 or ipv6 address given."));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   215
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   216
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   217
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   218
function get_supermaster_info_from_ip($master_ip)
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   219
{
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   220
	global $db;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   221
        if (is_valid_ip($master_ip) || is_valid_ip6($master_ip))
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   222
	{
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   223
	        $result = $db->queryRow("SELECT ip,nameserver,account FROM supermasters WHERE ip = ".$db->quote($master_ip));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   224
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   225
		$ret = array(
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   226
		"master_ip"	=>              $result["ip"],
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   227
		"ns_name"	=>              $result["nameserver"],
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   228
		"account"	=>              $result["account"]
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   229
		);
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   230
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   231
		return $ret;	
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   232
	}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   233
        else
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   234
	{
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   235
                error(sprintf(ERR_INV_ARGC, "get_supermaster_info_from_ip", "No or no valid ipv4 or ipv6 address given."));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   236
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   237
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   238
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   239
function get_record_details_from_record_id($rid) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   240
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   241
	global $db;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   242
98
9c10fd623368 [feladat @ 198]
rejo
parents: 93
diff changeset
   243
	$query = "SELECT id AS rid, domain_id AS zid, name, type, content, ttl, prio, change_date FROM records WHERE id = " . $db->quote($rid) ;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   244
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   245
	$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   246
	if (PEAR::isError($response)) { error($response->getMessage()); return false; }
98
9c10fd623368 [feladat @ 198]
rejo
parents: 93
diff changeset
   247
	
9c10fd623368 [feladat @ 198]
rejo
parents: 93
diff changeset
   248
	$return = $response->fetchRow();
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   249
	return $return;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   250
}
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   251
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   252
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   253
 * Delete a record by a given id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   254
 * return values: true, this function is always succesful.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   255
 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   256
function delete_record($rid)
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   257
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   258
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   259
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   260
	if (verify_permission(zone_content_edit_others)) { $perm_content_edit = "all" ; } 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   261
	elseif (verify_permission(zone_content_edit_own)) { $perm_content_edit = "own" ; } 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   262
	else { $perm_content_edit = "none" ; }
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   263
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   264
	// Determine ID of zone first.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   265
	$record = get_record_details_from_record_id($rid);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   266
	$user_is_zone_owner = verify_user_is_owner_zoneid($record['zid']);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   267
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   268
	if ( $perm_content_edit == "all" || ($perm_content_edit == "own" && $user_is_zone_owner == "0" )) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   269
		if ($record['type'] == "SOA") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   270
			error(_('You are trying to delete the SOA record. If are not allowed to remove it, unless you remove the entire zone.'));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   271
		} else {
98
9c10fd623368 [feladat @ 198]
rejo
parents: 93
diff changeset
   272
			$query = "DELETE FROM records WHERE id = " . $db->quote($rid);
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   273
			$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   274
			if (PEAR::isError($response)) { error($response->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   275
			return true;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   276
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   277
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   278
		error(ERR_PERM_DEL_RECORD);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   279
		return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   280
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   281
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   282
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   283
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   284
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   285
 * Add a domain to the database.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   286
 * A domain is name obligatory, so is an owner.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   287
 * return values: true when succesful.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   288
 * Empty means templates dont have to be applied.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   289
 * --------------------------------------------------------------------------
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   290
 * This functions eats a template and by that it inserts various records.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   291
 * first we start checking if something in an arpa record
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   292
 * remember to request nextID's from the database to be able to insert record.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   293
 * if anything is invalid the function will error
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   294
 */
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   295
function add_domain($domain, $owner, $webip, $mailip, $empty, $type, $slave_master)
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   296
{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   297
	if(verify_permission(zone_master_add)) { $zone_master_add = "1" ; } ;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   298
	if(verify_permission(zone_slave_add)) { $zone_slave_add = "1" ; } ;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   299
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   300
	// TODO: make sure only one is possible if only one is enabled
86
0205771bf84c [feladat @ 186]
rejo
parents: 82
diff changeset
   301
	if($zone_master_add == "1" || $zone_slave_add == "1") {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   302
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   303
		global $db;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   304
		if (($domain && $owner && $webip && $mailip) || 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   305
				($empty && $owner && $domain) || 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   306
				(eregi('in-addr.arpa', $domain) && $owner) || 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   307
				$type=="SLAVE" && $domain && $owner && $slave_master) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   308
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   309
			$response = $db->query("INSERT INTO domains (name, type) VALUES (".$db->quote($domain).", ".$db->quote($type).")");
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   310
			if (PEAR::isError($response)) { error($response->getMessage()); return false; }
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   311
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   312
			$domain_id = $db->lastInsertId('domains', 'id');
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   313
			if (PEAR::isError($domain_id)) { error($id->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   314
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   315
			$response = $db->query("INSERT INTO zones (domain_id, owner) VALUES (".$db->quote($domain_id).", ".$db->quote($owner).")");
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   316
			if (PEAR::isError($response)) { error($response->getMessage()); return false; }
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   317
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   318
			if ($type == "SLAVE") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   319
				$response = $db->query("UPDATE domains SET master = ".$db->quote($slave_master)." WHERE id = ".$db->quote($domain_id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   320
				if (PEAR::isError($response)) { error($response->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   321
				return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   322
			} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   323
				$now = time();
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   324
				if ($empty && $domain_id) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   325
					$ns1 = $GLOBALS['NS1'];
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   326
					$hm  = $GLOBALS['HOSTMASTER'];
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   327
					$ttl = $GLOBALS['DEFAULT_TTL'];
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   328
106
41d05ff53708 [feladat @ 206]
peter
parents: 98
diff changeset
   329
					$query = "INSERT INTO records (domain_id, name, content, type, ttl, prio, change_date) VALUES (" 
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   330
							. $db->quote($domain_id) . "," 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   331
							. $db->quote($domain) . "," 
106
41d05ff53708 [feladat @ 206]
peter
parents: 98
diff changeset
   332
							. $db->quote('SOA').","
87
654262e698e2 [feladat @ 187]
rejo
parents: 86
diff changeset
   333
							. $db->quote($ns1.' '.$hm.' 1') . ","
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   334
							. $db->quote($ttl) 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   335
							. ", 0, "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   336
							. $db->quote($now).")";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   337
					$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   338
					if (PEAR::isError($response)) { error($response->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   339
				} elseif ($domain_id) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   340
					global $template;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   341
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   342
					foreach ($template as $r) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   343
						if ((eregi('in-addr.arpa', $domain) && ($r["type"] == "NS" || $r["type"] == "SOA")) || (!eregi('in-addr.arpa', $domain)))
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   344
						{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   345
							$name     = parse_template_value($r["name"], $domain, $webip, $mailip);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   346
							$type     = $r["type"];
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   347
							$content  = parse_template_value($r["content"], $domain, $webip, $mailip);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   348
							$ttl      = $r["ttl"];
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   349
							$prio     = intval($r["prio"]);
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   350
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   351
							if (!$ttl) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   352
								$ttl = $GLOBALS["DEFAULT_TTL"];
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   353
							}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   354
106
41d05ff53708 [feladat @ 206]
peter
parents: 98
diff changeset
   355
							$query = "INSERT INTO records (domain_id, name, type, content, ttl, prio, change_date) VALUES (" 
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   356
									. $db->quote($domain_id) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   357
									. $db->quote($name) . ","
87
654262e698e2 [feladat @ 187]
rejo
parents: 86
diff changeset
   358
									. $db->quote($type) . ","
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   359
									. $db->quote($content) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   360
									. $db->quote($ttl) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   361
									. $db->quote($prio) . ","
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   362
									. $db->quote($now) . ")";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   363
							$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   364
							if (PEAR::isError($response)) { error($response->getMessage()); return false; }
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   365
						}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   366
					}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   367
					return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   368
				 } else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   369
					error(sprintf(ERR_INV_ARGC, "add_domain", "could not create zone"));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   370
				 }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   371
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   372
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   373
			error(sprintf(ERR_INV_ARG, "add_domain"));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   374
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   375
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   376
		error(ERR_PERM_ADD_ZONE_MASTER);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   377
		return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   378
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   379
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   380
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   381
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   382
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   383
 * Deletes a domain by a given id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   384
 * Function always succeeds. If the field is not found in the database, thats what we want anyway.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   385
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   386
function delete_domain($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   387
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   388
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   389
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   390
	if (verify_permission(zone_content_edit_others)) { $perm_edit = "all" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   391
	elseif (verify_permission(zone_content_edit_own)) { $perm_edit = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   392
	else { $perm_edit = "none" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   393
	$user_is_zone_owner = verify_user_is_owner_zoneid($id);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   394
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   395
        if ( $perm_edit == "all" || ( $perm_edit == "own" && $user_is_zone_owner == "1") ) {    
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   396
		if (is_numeric($id)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   397
			$db->query("DELETE FROM zones WHERE domain_id=".$db->quote($id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   398
			$db->query("DELETE FROM domains WHERE id=".$db->quote($id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   399
			$db->query("DELETE FROM records WHERE domain_id=".$db->quote($id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   400
			return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   401
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   402
			error(sprintf(ERR_INV_ARGC, "delete_domain", "id must be a number"));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   403
			return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   404
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   405
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   406
		error(ERR_PERM_DEL_ZONE);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   407
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   408
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   409
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   410
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   411
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   412
 * Gets the id of the domain by a given record id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   413
 * return values: the domain id that was requested.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   414
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   415
function recid_to_domid($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   416
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   417
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   418
	if (is_numeric($id))
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   419
	{
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   420
		$result = $db->query("SELECT domain_id FROM records WHERE id=".$db->quote($id));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   421
		$r = $result->fetchRow();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   422
		return $r["domain_id"];
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   423
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   424
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   425
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   426
		error(sprintf(ERR_INV_ARGC, "recid_to_domid", "id must be a number"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   427
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   428
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   429
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   430
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   431
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   432
 * Change owner of a domain.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   433
 * return values: true when succesful.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   434
 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   435
function add_owner_to_zone($zone_id, $user_id)
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   436
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   437
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   438
	if ( (verify_permission(zone_meta_edit_others)) || (verify_permission(zone_meta_edit_own)) && verify_user_is_owner_zoneid($_GET["id"])) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   439
		// User is allowed to make change to meta data of this zone.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   440
		if (is_numeric($zone_id) && is_numeric($user_id) && is_valid_user($user_id))
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   441
		{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   442
			if($db->queryOne("SELECT COUNT(id) FROM zones WHERE owner=".$db->quote($user_id)." AND domain_id=".$db->quote($zone_id)) == 0)
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   443
			{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   444
				$db->query("INSERT INTO zones (domain_id, owner) VALUES(".$db->quote($zone_id).", ".$db->quote($user_id).")");
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   445
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   446
			return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   447
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   448
			error(sprintf(ERR_INV_ARGC, "add_owner_to_zone", "$zone_id / $user_id"));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   449
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   450
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   451
		return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   452
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   453
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   454
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   455
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   456
function delete_owner_from_zone($zone_id, $user_id)
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   457
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   458
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   459
	if ( (verify_permission(zone_meta_edit_others)) || (verify_permission(zone_meta_edit_own)) && verify_user_is_owner_zoneid($_GET["id"])) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   460
		// User is allowed to make change to meta data of this zone.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   461
		if (is_numeric($zone_id) && is_numeric($user_id) && is_valid_user($user_id))
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   462
		{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   463
			// TODO: Next if() required, why not just execute DELETE query?
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   464
			if($db->queryOne("SELECT COUNT(id) FROM zones WHERE owner=".$db->quote($user_id)." AND domain_id=".$db->quote($zone_id)) != 0)
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   465
			{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   466
				$db->query("DELETE FROM zones WHERE owner=".$db->quote($user_id)." AND domain_id=".$db->quote($zone_id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   467
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   468
			return true;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   469
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   470
			error(sprintf(ERR_INV_ARGC, "delete_owner_from_zone", "$zone_id / $user_id"));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   471
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   472
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   473
		return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   474
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   475
	
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   476
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   477
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   478
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   479
 * Retrieves all supported dns record types
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   480
 * This function might be deprecated.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   481
 * return values: array of types in string form.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   482
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   483
function get_record_types()
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   484
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   485
	global $rtypes;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   486
	return $rtypes;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   487
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   488
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   489
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   490
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   491
 * Retrieve all records by a given type and domain id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   492
 * Example: get all records that are of type A from domain id 1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   493
 * return values: a DB class result object
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   494
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   495
function get_records_by_type_from_domid($type, $recid)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   496
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   497
	global $rtypes;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   498
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   499
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   500
	// Does this type exist?
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   501
	if(!in_array(strtoupper($type), $rtypes))
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   502
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   503
		error(sprintf(ERR_INV_ARGC, "get_records_from_type", "this is not a supported record"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   504
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   505
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   506
	// Get the domain id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   507
	$domid = recid_to_domid($recid);
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   508
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   509
	$result = $db->query("select id, type from records where domain_id=".$db->quote($recid)." and type=".$db->quote($type));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   510
	return $result;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   511
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   512
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   513
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   514
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   515
 * Retrieves the type of a record from a given id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   516
 * return values: the type of the record (one of the records types in $rtypes assumable).
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   517
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   518
function get_recordtype_from_id($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   519
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   520
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   521
	if (is_numeric($id))
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   522
	{
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   523
		$result = $db->query("SELECT type FROM records WHERE id=".$db->quote($id));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   524
		$r = $result->fetchRow();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   525
		return $r["type"];
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   526
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   527
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   528
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   529
		error(sprintf(ERR_INV_ARG, "get_recordtype_from_id"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   530
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   531
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   532
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   533
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   534
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   535
 * Retrieves the name (e.g. bla.test.com) of a record by a given id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   536
 * return values: the name associated with the id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   537
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   538
function get_name_from_record_id($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   539
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   540
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   541
	if (is_numeric($id)) {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   542
		$result = $db->query("SELECT name FROM records WHERE id=".$db->quote($id));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   543
		$r = $result->fetchRow();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   544
		return $r["name"];
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   545
	} else {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   546
		error(sprintf(ERR_INV_ARG, "get_name_from_record_id"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   547
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   548
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   549
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   550
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   551
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   552
 * Get domain name from a given id
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   553
 * return values: the name of the domain associated with the id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   554
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   555
function get_domain_name_from_id($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   556
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   557
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   558
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   559
	if (is_numeric($id))
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   560
	{
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   561
		$result = $db->query("SELECT name FROM domains WHERE id=".$db->quote($id));
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   562
		$rows = $result->numRows() ;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   563
		if ($rows == 1) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   564
 			$r = $result->fetchRow();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   565
 			return $r["name"];
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   566
		} elseif ($rows == "0") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   567
			error(sprintf("Zone does not exist."));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   568
			return false;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   569
		} else {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   570
	 		error(sprintf(ERR_INV_ARGC, "get_domain_name_from_id", "more than one domain found?! whaaa! BAD! BAD! Contact admin!"));
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   571
			return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   572
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   573
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   574
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   575
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   576
		error(sprintf(ERR_INV_ARGC, "get_domain_name_from_id", "Not a valid domainid: $id"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   577
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   578
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   579
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   580
function get_zone_info_from_id($zone_id) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   581
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   582
	if (verify_permission(zone_content_view_others)) { $perm_view = "all" ; } 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   583
	elseif (verify_permission(zone_content_view_own)) { $perm_view = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   584
	else { $perm_view = "none" ;}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   585
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   586
	if ($perm_view == "none") { 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   587
		error(ERR_PERM_VIEW_ZONE);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   588
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   589
		global $db;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   590
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   591
		$query = "SELECT 	domains.type AS type, 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   592
					domains.name AS name, 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   593
					domains.master AS master_ip,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   594
					count(records.domain_id) AS record_count
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   595
					FROM domains, records 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   596
					WHERE domains.id = " . $db->quote($zone_id) . "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   597
					AND domains.id = records.domain_id 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   598
					GROUP BY domains.id";
88
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   599
		$result = $db->query($query);
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   600
		if (PEAR::isError($result)) { error($result->getMessage()); return false; }
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   601
88
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   602
		if($result->numRows() != 1) {
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   603
			error(_('Function returned an error (multiple zones matching this zone ID).'));
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   604
			return false;
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   605
		} else {
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   606
			$r = $result->fetchRow();
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   607
			$return = array(
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   608
				"name"		=>	$r['name'],
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   609
				"type"		=>	$r['type'],
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   610
				"master_ip"	=>	$r['master_ip'],
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   611
				"record_count"	=>	$r['record_count']
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   612
				);
fa948cc3727e [feladat @ 188]
rejo
parents: 87
diff changeset
   613
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   614
		return $return;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   615
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   616
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   617
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   618
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   619
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   620
 * Check if a domain is already existing.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   621
 * return values: true if existing, false if it doesnt exist.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   622
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   623
function domain_exists($domain)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   624
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   625
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   626
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   627
	if (is_valid_domain($domain)) {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   628
		$result = $db->query("SELECT id FROM domains WHERE name=".$db->quote($domain));
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   629
		if ($result->numRows() == 0) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   630
			return false;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   631
		} elseif ($result->numRows() >= 1) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   632
			return true;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   633
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   634
	} else {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   635
		error(ERR_DOMAIN_INVALID);
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   636
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   637
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   638
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   639
function get_supermasters()
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   640
{
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   641
        global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   642
        
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   643
	$result = $db->query("SELECT ip, nameserver, account FROM supermasters");
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   644
	if (PEAR::isError($response)) { error($response->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   645
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   646
        $ret = array();
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   647
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   648
        if($result->numRows() == 0) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   649
                return -1;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   650
        } else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   651
                while ($r = $result->fetchRow()) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   652
                        $ret[] = array(
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   653
                        "master_ip"     => $r["ip"],
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   654
                        "ns_name"       => $r["nameserver"],
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   655
                        "account"       => $r["account"],
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   656
                        );
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   657
                }
36
4ec5ab29f634 [feladat @ 83]
rejo
parents: 30
diff changeset
   658
		return $ret;
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   659
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   660
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   661
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   662
function supermaster_exists($master_ip)
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   663
{
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   664
        global $db;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   665
        if (is_valid_ip($master_ip) || is_valid_ip6($master_ip))
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   666
        {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   667
                $result = $db->query("SELECT ip FROM supermasters WHERE ip = ".$db->quote($master_ip));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   668
                if ($result->numRows() == 0)
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   669
                {
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   670
                        return false;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   671
                }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   672
                elseif ($result->numRows() >= 1)
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   673
                {
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   674
                        return true;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   675
                }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   676
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   677
        else
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   678
        {
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   679
                error(sprintf(ERR_INV_ARGC, "supermaster_exists", "No or no valid IPv4 or IPv6 address given."));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   680
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   681
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   682
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   683
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   684
function get_zones($perm,$userid=0,$letterstart=all,$rowstart=0,$rowamount=999999) 
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   685
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   686
	global $db;
55
a885f557678f [feladat @ 102]
peter
parents: 47
diff changeset
   687
	global $sql_regexp;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   688
	if ($perm != "own" && $perm != "all") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   689
		error(ERR_PERM_VIEW_ZONE);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   690
		return false;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   691
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   692
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   693
	{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   694
		if ($perm == "own") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   695
			$sql_add = " AND zones.domain_id = domains.id
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   696
				AND zones.owner = ".$db->quote($userid);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   697
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   698
		if ($letterstart!=all && $letterstart!=1) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   699
			$sql_add .=" AND domains.name LIKE ".$db->quote($letterstart."%")." ";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   700
		} elseif ($letterstart==1) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   701
			$sql_add .=" AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]'";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   702
		}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   703
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   704
	
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   705
	$sqlq = "SELECT domains.id, 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   706
			domains.name,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   707
			domains.type,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   708
			COUNT(DISTINCT records.id) AS count_records
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   709
			FROM domains
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   710
			LEFT JOIN zones ON domains.id=zones.domain_id 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   711
			LEFT JOIN records ON records.domain_id=domains.id
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   712
			WHERE 1=1".$sql_add." 
106
41d05ff53708 [feladat @ 206]
peter
parents: 98
diff changeset
   713
			GROUP BY domains.name, domains.id, domains.type
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   714
			ORDER BY domains.name";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   715
	
74
43c31dc98305 [feladat @ 121]
peter
parents: 71
diff changeset
   716
	$db->setLimit($rowamount, $rowstart);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   717
	$result = $db->query($sqlq);
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   718
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   719
	while($r = $result->fetchRow())
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   720
	{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   721
		$ret[$r["name"]] = array(
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   722
		"id"		=>	$r["id"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   723
		"name"		=>	$r["name"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   724
		"type"		=>	$r["type"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   725
		"count_records"	=>	$r["count_records"]
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   726
		);	
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   727
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   728
	return $ret;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   729
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   730
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   731
// TODO: letterstart limitation and userid permission limitiation should be applied at the same time?
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   732
function zone_count_ng($perm, $letterstart=all) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   733
	global $db;
55
a885f557678f [feladat @ 102]
peter
parents: 47
diff changeset
   734
	global $sql_regexp;
115
b1d7998a903e [feladat @ 218]
peter
parents: 111
diff changeset
   735
b1d7998a903e [feladat @ 218]
peter
parents: 111
diff changeset
   736
	$fromTable = 'domains';
b1d7998a903e [feladat @ 218]
peter
parents: 111
diff changeset
   737
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   738
	if ($perm != "own" && $perm != "all") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   739
		$zone_count = "0";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   740
	} 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   741
	else 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   742
	{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   743
		if ($perm == "own") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   744
			$sql_add = " AND zones.domain_id = domains.id
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   745
					AND zones.owner = ".$db->quote($_SESSION['userid']);
115
b1d7998a903e [feladat @ 218]
peter
parents: 111
diff changeset
   746
			$fromTable .= ',zones';
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   747
		}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   748
		if ($letterstart!=all && $letterstart!=1) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   749
			$sql_add .=" AND domains.name LIKE ".$db->quote($letterstart."%")." ";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   750
		} elseif ($letterstart==1) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   751
			$sql_add .=" AND substring(domains.name,1,1) ".$sql_regexp." '^[[:digit:]]'";
37
b785e54690ce [feladat @ 84]
rejo
parents: 36
diff changeset
   752
		}
b785e54690ce [feladat @ 84]
rejo
parents: 36
diff changeset
   753
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   754
		$sqlq = "SELECT COUNT(distinct domains.id) AS count_zones 
115
b1d7998a903e [feladat @ 218]
peter
parents: 111
diff changeset
   755
			FROM ".$fromTable."	WHERE 1=1
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   756
			".$sql_add.";";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   757
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   758
		$zone_count = $db->queryOne($sqlq);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   759
	}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   760
	return $zone_count;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   761
}
30
380197766e7e [feladat @ 77]
rejo
parents: 21
diff changeset
   762
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   763
function zone_count_for_uid($uid) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   764
	global $db;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   765
	$query = "SELECT COUNT(domain_id) 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   766
			FROM zones 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   767
			WHERE owner = " . $db->quote($uid) . " 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   768
			ORDER BY domain_id";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   769
	$zone_count = $db->queryOne($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   770
	return $zone_count;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   771
}
30
380197766e7e [feladat @ 77]
rejo
parents: 21
diff changeset
   772
380197766e7e [feladat @ 77]
rejo
parents: 21
diff changeset
   773
380197766e7e [feladat @ 77]
rejo
parents: 21
diff changeset
   774
/*
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   775
 * Get a record from an id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   776
 * Retrieve all fields of the record and send it back to the function caller.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   777
 * return values: the array with information, or -1 is nothing is found.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   778
 */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   779
function get_record_from_id($id)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   780
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   781
	global $db;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   782
	if (is_numeric($id))
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   783
	{
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   784
		$result = $db->query("SELECT id, domain_id, name, type, content, ttl, prio, change_date FROM records WHERE id=".$db->quote($id));
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   785
		if($result->numRows() == 0)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   786
		{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   787
			return -1;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   788
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   789
		elseif ($result->numRows() == 1)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   790
		{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   791
			$r = $result->fetchRow();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   792
			$ret = array(
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   793
				"id"            =>      $r["id"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   794
				"domain_id"     =>      $r["domain_id"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   795
				"name"          =>      $r["name"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   796
				"type"          =>      $r["type"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   797
				"content"       =>      $r["content"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   798
				"ttl"           =>      $r["ttl"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   799
				"prio"          =>      $r["prio"],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   800
				"change_date"   =>      $r["change_date"]
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   801
				);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   802
			return $ret;
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   803
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   804
		else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   805
		{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   806
			error(sprintf(ERR_INV_ARGC, "get_record_from_id", "More than one row returned! This is bad!"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   807
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   808
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   809
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   810
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   811
		error(sprintf(ERR_INV_ARG, "get_record_from_id"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   812
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   813
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   814
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   815
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   816
/*
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   817
 * Get all records from a domain id.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   818
 * Retrieve all fields of the records and send it back to the function caller.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   819
 * return values: the array with information, or -1 is nothing is found.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   820
 */
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   821
function get_records_from_domain_id($id,$rowstart=0,$rowamount=999999) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   822
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   823
	if (is_numeric($id)) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   824
		if ($_SESSION[$id."_ispartial"] == 1) {
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   825
			$db->setLimit($rowamount, $rowstart);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   826
			$result = $db->query("SELECT record_owners.record_id as id
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   827
					FROM record_owners,domains,records
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   828
					WHERE record_owners.user_id = " . $db->quote($_SESSION["userid"]) . "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   829
					AND record_owners.record_id = records.id
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   830
					AND records.domain_id = " . $db->quote($id) . "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   831
					GROUP BY record_owners.record_id");
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   832
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   833
			$ret = array();
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   834
			if($result->numRows() == 0) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   835
				return -1;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   836
			} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   837
				$ret[] = array();
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   838
				$retcount = 0;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   839
				while($r = $result->fetchRow())
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   840
				{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   841
					// Call get_record_from_id for each row.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   842
					$ret[$retcount] = get_record_from_id($r["id"]);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   843
					$retcount++;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   844
				}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   845
				return $ret;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   846
			}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   847
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   848
		} else {
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   849
			$db->setLimit($rowamount, $rowstart);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   850
			$result = $db->query("SELECT id FROM records WHERE domain_id=".$db->quote($id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   851
			$ret = array();
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   852
			if($result->numRows() == 0)
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   853
			{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   854
				return -1;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   855
			}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   856
			else
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   857
			{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   858
				$ret[] = array();
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   859
				$retcount = 0;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   860
				while($r = $result->fetchRow())
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   861
				{
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   862
					// Call get_record_from_id for each row.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   863
					$ret[$retcount] = get_record_from_id($r["id"]);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   864
					$retcount++;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   865
				}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   866
				return $ret;
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   867
			}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   868
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   869
		}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   870
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   871
	else
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   872
	{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   873
		error(sprintf(ERR_INV_ARG, "get_records_from_domain_id"));
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   874
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   875
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   876
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   877
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   878
function get_users_from_domain_id($id) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   879
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   880
	$sqlq = "SELECT owner FROM zones WHERE domain_id =" .$db->quote($id);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   881
	$id_owners = $db->query($sqlq);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   882
	if ($id_owners->numRows() == 0) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   883
		return -1;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   884
	} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   885
		while ($r = $id_owners->fetchRow()) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   886
			$fullname = $db->queryOne("SELECT fullname FROM users WHERE id=".$r['owner']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   887
			$owners[] = array(
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   888
				"id" 		=> 	$r['owner'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   889
				"fullname"	=>	$fullname		
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   890
			);		
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   891
		}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   892
	}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   893
	return $owners;	
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   894
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   895
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   896
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   897
function search_zone_and_record($holy_grail,$perm) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   898
	
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   899
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   900
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   901
	$holy_grail = trim($holy_grail);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   902
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   903
	if (verify_permission(zone_content_view_others)) { $perm_view = "all" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   904
	elseif (verify_permission(zone_content_view_own)) { $perm_view = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   905
	else { $perm_view = "none" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   906
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   907
	if (verify_permission(zone_content_edit_others)) { $perm_content_edit = "all" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   908
	elseif (verify_permission(zone_content_edit_own)) { $perm_content_edit = "own" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   909
	else { $perm_content_edit = "none" ; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   910
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   911
	// Search for matching domains
62
ce4919f37489 [feladat @ 109]
rejo
parents: 60
diff changeset
   912
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   913
	if ($perm == "own") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   914
		$sql_add_from = ", zones ";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   915
		$sql_add_where = " AND zones.domain_id = domains.id AND zones.owner = " . $db->quote($userid);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   916
	}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   917
	
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   918
	$query = "SELECT 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   919
			domains.id AS zid,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   920
			domains.name AS name,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   921
			domains.type AS type,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   922
			domains.master AS master
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   923
			FROM domains" . $sql_add_from . "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   924
			WHERE domains.name LIKE " . $db->quote($holy_grail)
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   925
			. $sql_add_where ;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   926
	
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   927
	$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   928
	if (PEAR::isError($response)) { error($response->getMessage()); return false; }
62
ce4919f37489 [feladat @ 109]
rejo
parents: 60
diff changeset
   929
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   930
	while ($r = $response->fetchRow()) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   931
		$return_zones[] = array(
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   932
			"zid"		=>	$r['zid'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   933
			"name"		=>	$r['name'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   934
			"type"		=>	$r['type'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   935
			"master"	=>	$r['master']);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   936
	}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   937
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   938
	// Search for matching records
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   939
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   940
	if ($perm == "own") {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   941
		$sql_add_from = ", zones ";
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   942
		$sql_add_where = " AND zones.domain_id = record.id AND zones.owner = " . $db->quote($userid);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   943
	}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   944
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   945
	$query = "SELECT
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   946
			records.id AS rid,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   947
			records.name AS name,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   948
			records.type AS type,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   949
			records.content AS content,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   950
			records.ttl AS ttl,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   951
			records.prio AS prio,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   952
			records.domain_id AS zid
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   953
			FROM records" . $sql_add_from . "
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   954
			WHERE (records.name LIKE " . $db->quote($holy_grail) . " OR records.content LIKE " . $db->quote($holy_grail) . ")"
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   955
			. $sql_add_where ;
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   956
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   957
	$response = $db->query($query);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   958
	if (PEAR::isError($response)) { error($response->getMessage()); return false; }
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   959
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   960
	while ($r = $response->fetchRow()) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   961
		$return_records[] = array(
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   962
			"rid"		=>	$r['rid'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   963
			"name"		=>	$r['name'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   964
			"type"		=>	$r['type'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   965
			"content"	=>	$r['content'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   966
			"ttl"		=>	$r['ttl'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   967
			"zid"		=>	$r['zid'],
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   968
			"prio"		=>	$r['prio']);
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   969
	}
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   970
	return array('zones' => $return_zones, 'records' => $return_records);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   971
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   972
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   973
function get_domain_type($id) {
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   974
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   975
        if (is_numeric($id)) {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   976
		$type = $db->queryOne("SELECT type FROM domains WHERE id = ".$db->quote($id));
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   977
		if ($type == "") {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   978
			$type = "NATIVE";
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   979
		}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   980
		return $type;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   981
        } else {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   982
                error(sprintf(ERR_INV_ARG, "get_record_from_id", "no or no valid zoneid given"));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   983
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   984
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   985
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   986
function get_domain_slave_master($id){
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   987
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   988
        if (is_numeric($id)) {
65
ce1c4d5e1576 [feladat @ 112]
peter
parents: 63
diff changeset
   989
		$slave_master = $db->queryOne("SELECT master FROM domains WHERE type = 'SLAVE' and id = ".$db->quote($id));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   990
		return $slave_master;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   991
        } else {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   992
                error(sprintf(ERR_INV_ARG, "get_domain_slave_master", "no or no valid zoneid given"));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   993
        }
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   994
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   995
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
   996
function change_zone_type($type, $id)
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
   997
{
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
   998
	global $db;
79
0c0aa144356a [feladat @ 156]
peter
parents: 78
diff changeset
   999
	$add = '';
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1000
        if (is_numeric($id))
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1001
	{
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1002
		// It is not really neccesary to clear the field that contains the IP address 
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1003
		// of the master if the type changes from slave to something else. PowerDNS will
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1004
		// ignore the field if the type isn't something else then slave. But then again,
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1005
		// it's much clearer this way.
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1006
		if ($type != "SLAVE") {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1007
			$add = ", master=''";
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1008
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1009
		$result = $db->query("UPDATE domains SET type = " . $db->quote($type) . $add . " WHERE id = ".$db->quote($id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1010
	} else {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1011
                error(sprintf(ERR_INV_ARG, "change_domain_type", "no or no valid zoneid given"));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1012
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1013
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1014
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1015
function change_zone_slave_master($zone_id, $ip_slave_master) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1016
	global $db;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1017
        if (is_numeric($zone_id)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1018
       		if (is_valid_ip($ip_slave_master) || is_valid_ip6($ip_slave_master)) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1019
			$result = $db->query("UPDATE domains SET master = " .$db->quote($ip_slave_master). " WHERE id = ".$db->quote($zone_id));
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1020
		} else {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1021
			error(sprintf(ERR_INV_ARGC, "change_domain_ip_slave_master", "This is not a valid IPv4 or IPv6 address: $ip_slave_master"));
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1022
		}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1023
	} else {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1024
                error(sprintf(ERR_INV_ARG, "change_domain_type", "no or no valid zoneid given"));
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1025
        }
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1026
}
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1027
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1028
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1029
function validate_account($account) {
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1030
  	if(preg_match("/^[A-Z0-9._-]+$/i",$account)) {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1031
		return true;
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1032
	} else {
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1033
		return false;
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
  1034
	}
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
  1035
}
82
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1036
c255196bc447 [feladat @ 182]
rejo
parents: 81
diff changeset
  1037
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
  1038
?>