| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.2
* Copyright © 2006 MyBB Group, All Rights Reserved
*
|
* MyBB 1.2
* Copyright © 2006 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
| * Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
|
*
|
*
|
* $Id: db_mysql.php 1370 2006-04-16 13:47:01Z chris $
| * $Id: db_mysqli.php 3352 2007-09-30 08:17:16Z chris $
|
*/
class databaseEngine
| */
class databaseEngine
|
| Zeile 83 | Zeile 83 |
|---|
* @param boolean 1 if persistent connection, 0 if not.
* @return resource The database connection resource.
*/
|
* @param boolean 1 if persistent connection, 0 if not.
* @return resource The database connection resource.
*/
|
function connect($hostname="localhost", $username="root", $password="", $pconnect=0)
| function connect($hostname="localhost", $username="root", $password="", $pconnect=0, $newlink=false)
|
{
|
{
|
$this->link = @mysqli_connect($hostname, $username, $password) or $this->dberror();
| list($hostname, $port) = explode(":", $hostname, 2);
if($port)
{
$this->link = @mysqli_connect($hostname, $username, $password, "", $port) or $this->dberror();
}
else
{
$this->link = @mysqli_connect($hostname, $username, $password) or $this->dberror();
}
|
return $this->link;
}
| return $this->link;
}
|
| Zeile 97 | Zeile 105 |
|---|
*/
function select_db($database)
{
|
*/
function select_db($database)
{
|
return @mysqli_select_db($this->link, $database) or $this->dberror();
| global $config;
$success = @mysqli_select_db($this->link, $database) or $this->dberror();
if($success && $config['db_encoding'])
{
$this->query("SET NAMES '{$config['db_encoding']}'");
}
return $success;
|
}
/**
| }
/**
|
| Zeile 136 | Zeile 151 |
|---|
*/
function explain_query($string, $qtime)
{
|
*/
function explain_query($string, $qtime)
{
|
| | global $plugins;
if($plugins->current_hook)
{
$debug_extra = "<div style=\"float_right\">(Plugin Hook: {$plugins->current_hook})</div>";
}
|
if(preg_match("#^\s*select#i", $string))
{
$query = mysqli_query($this->link, "EXPLAIN $string");
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
if(preg_match("#^\s*select#i", $string))
{
$query = mysqli_query($this->link, "EXPLAIN $string");
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
"<td colspan=\"8\" style=\"background-color: #ccc;\"><strong>#".$this->query_count." - Select Query</strong></td>\n".
| "<td colspan=\"8\" style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Select Query</strong></div></td>\n".
|
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
| "</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
|
| Zeile 181 | Zeile 201 |
|---|
else
{
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
|
else
{
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
|
"<tr>\n".
"<td style=\"background-color: #ccc;\"><strong>#".$this->query_count." - Write Query</strong></td>\n".
"</tr>\n".
| "<tr>\n".
"<td style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Write Query</strong></div></td>\n".
"</tr>\n".
|
"<tr style=\"background-color: #fefefe;\">\n".
"<td><span style=\"font-family: Courier; font-size: 14px;\">".htmlspecialchars_uni($string)."</span></td>\n".
|
"<tr style=\"background-color: #fefefe;\">\n".
"<td><span style=\"font-family: Courier; font-size: 14px;\">".htmlspecialchars_uni($string)."</span></td>\n".
|
"</tr>\n".
| "</tr>\n".
|
"<tr>\n".
"<td bgcolor=\"#ffffff\">Query Time: ".$qtime."</td>\n".
"</tr>\n".
| "<tr>\n".
"<td bgcolor=\"#ffffff\">Query Time: ".$qtime."</td>\n".
"</tr>\n".
|
| Zeile 198 | Zeile 218 |
|---|
$this->querylist[$this->query_count]['time'] = $qtime;
}
|
$this->querylist[$this->query_count]['time'] = $qtime;
}
|
|
|
/**
* Return a result array for a query.
*
| /**
* Return a result array for a query.
*
|
| Zeile 207 | Zeile 227 |
|---|
* @return array The array of results.
*/
function fetch_array($query)
|
* @return array The array of results.
*/
function fetch_array($query)
|
{
| {
|
$array = mysqli_fetch_assoc($query);
return $array;
}
| $array = mysqli_fetch_assoc($query);
return $array;
}
|
| Zeile 278 | Zeile 298 |
|---|
*/
function errno()
{
|
*/
function errno()
{
|
if(version_compare(phpversion(), "5", ">="))
| if(!$this->link)
{
return mysqli_connect_errno();
}
else
|
{
return mysqli_errno($this->link);
}
| {
return mysqli_errno($this->link);
}
|