[feladat @ 307]
Minor bug fix: bg.shiny@gmail.com reported that cyrillic characters where not supported. Applied the patch which was supplied.
This closes #93.
<?php
/* Poweradmin, a friendly web-based admin tool for PowerDNS.
* See <https://rejo.zenger.nl/poweradmin> for more details.
*
* Copyright 2007, 2008 Rejo Zenger <rejo@zenger.nl>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*/
require_once("MDB2.php");
function dbError($msg)
{
echo " <div class=\"error\">Error: " . $msg->getDebugInfo() . "</div>\n";
include_once("footer.inc.php");
die();
}
PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, 'dbError');
function dbConnect() {
global $db_type;
global $db_user;
global $db_pass;
global $db_host;
global $db_name;
global $sql_regexp;
if (!(isset($db_user) && $db_user != "")) {
include_once("header.inc.php");
error(ERR_DB_NO_DB_USER);
include_once("footer.inc.php");
exit;
}
if (!(isset($db_pass) && $db_pass != "")) {
include_once("header.inc.php");
error(ERR_DB_NO_DB_PASS);
include_once("footer.inc.php");
exit;
}
if (!(isset($db_host) && $db_host != "")) {
include_once("header.inc.php");
error(ERR_DB_NO_DB_HOST);
include_once("footer.inc.php");
exit;
}
if (!(isset($db_name) && $db_name != "")) {
include_once("header.inc.php");
error(ERR_DB_NO_DB_NAME);
include_once("footer.inc.php");
exit;
}
if ((!isset($db_type)) || (!($db_type == "mysql" || $db_type == "pgsql"))) {
include_once("header.inc.php");
error(ERR_DB_NO_DB_TYPE);
include_once("footer.inc.php");
exit;
}
$dsn = "$db_type://$db_user:$db_pass@$db_host/$db_name";
$db = MDB2::connect($dsn);
$db->setOption('portability', MDB2_PORTABILITY_ALL ^ MDB2_PORTABILITY_EMPTY_TO_NULL);
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 = '';
// Add support for regular expressions in both MySQL and PostgreSQL
if ( $db_type == "mysql" ) {
$sql_regexp = "REGEXP";
} elseif ( $db_type == "pgsql" ) {
$sql_regexp = "~";
} else {
error(ERR_DB_NO_DB_TYPE);
};
return $db;
}
?>