inc/database.inc.php
author rejo
Tue, 10 Jul 2007 21:24:06 +0000
changeset 37 b785e54690ce
parent 13 2ff220cfde13
child 47 ae140472d97c
permissions -rwxr-xr-x
[feladat @ 84] Bugfix. The function zone_count() now also counts zones an owner has only partial access to, not just those zones the owner has full access to. This fixes just the count, the zones a user has partial access to are not (yet!) shown in the "list zones" page. Bugfix. In the zone listing the "edit" button is now show for users with access level 1. Untill now they were presented an overview of the zones they could change, but there was no link for them to actually edit the zone. Bugfix. Some of the buttons in the "edit zone" interface that are of no use to a user with access level 1 have been hidden. Bugfix. Make sure a user with access level 1 with only partial access to a zone cannot add new records to that zone. Only the zone owner should be able to add new record. Bugfix. If a user with access level 1 edits a record in a zone he has only partial access to, an error was shown because of call to a non- existing function in the PEAR:MDB2. This bug was most likely introduced while migrating from PEAR:DB to PEAR:MDB2. Bugfix. A user with access level 1 was able to delete all records of a zone he has only partial access to. Some additional checks have been added. Bugfix. If a user with accees level 1 has partial access to one or more zones starting with a certain character, but did not own at least one entire zone starting with the same character, the character wasn't clickable in the "list zone" page. Interface. If no record or zone id is given for delete_record.php or delete_domain.php, don't just die but echo a nice message. The i18n files have not yet been updated to reflect this change. Interface. If no master IP is given in delete_supermaster.php, don't just die but echo a nice message. The i18n files have not yet been updated to reflect this change. [All fixes by Peter Beernink.]
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     1
<?
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     2
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 4
diff changeset
     3
require_once("MDB2.php");
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     4
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     5
function dbError($msg)
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     6
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     7
        // General function for printing critical errors.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     8
        include_once("header.inc.php");
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
     9
        ?>
13
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
    10
	<h2><? echo _('Oops! An error occured!'); ?></h2>
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
    11
	<p class="error"><? echo $msg->getDebugInfo(); ?></p>
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
    12
	<?        
2ff220cfde13 [feladat @ 60]
rejo
parents: 8
diff changeset
    13
	include_once("footer.inc.php");
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    14
        die();
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    15
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    16
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    17
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'dbError');
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    18
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    19
$dsn = "$dbdsntype://$dbuser:$dbpass@$dbhost/$dbdatabase";
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 4
diff changeset
    20
$db = MDB2::connect($dsn);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    21
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 4
diff changeset
    22
if (MDB2::isError($db))
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    23
{
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    24
	// Error handling should be put.
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    25
        error(MYSQL_ERROR_FATAL, $db->getMessage());
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    26
}
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    27
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    28
// Do an ASSOC fetch. Gives us the ability to use ["id"] fields.
8
47dd15d8bb8c [feladat @ 20]
rejo
parents: 4
diff changeset
    29
$db->setFetchMode(MDB2_FETCHMODE_ASSOC);
1
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    30
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    31
/* erase info */
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    32
$mysql_pass = $dsn = '';
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    33
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    34
58094faf794d [feladat @ 2]
rejo
parents:
diff changeset
    35
?>