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