inc/database.inc.php
author rejo
Mon, 13 Aug 2007 22:05:06 +0000
changeset 40 ee5300058c9d
parent 13 2ff220cfde13
child 47 ae140472d97c
permissions -rwxr-xr-x
[feladat @ 87] Bugfix. With user level 5 or 10 and lots of zones without an owner, like slave zones that are inserted by a supermaster, the "list all zones" view was broken (not all zones shown, but "show page" and "show letters" were missing as well). Function zone_count matches zones and domains table, but users with level 5 or 10 are allowed to see zones without an entry in the zones table as well.

<?

require_once("MDB2.php");

function dbError($msg)
{
        // General function for printing critical errors.
        include_once("header.inc.php");
        ?>
	<h2><? echo _('Oops! An error occured!'); ?></h2>
	<p class="error"><? echo $msg->getDebugInfo(); ?></p>
	<?        
	include_once("footer.inc.php");
        die();
}

PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'dbError');

$dsn = "$dbdsntype://$dbuser:$dbpass@$dbhost/$dbdatabase";
$db = MDB2::connect($dsn);

if (MDB2::isError($db))
{
	// Error handling should be put.
        error(MYSQL_ERROR_FATAL, $db->getMessage());
}

// Do an ASSOC fetch. Gives us the ability to use ["id"] fields.
$db->setFetchMode(MDB2_FETCHMODE_ASSOC);

/* erase info */
$mysql_pass = $dsn = '';


?>