| Zeile 30 | Zeile 30 |
|---|
* @var string
*/
public $type;
|
* @var string
*/
public $type;
|
| |
/**
* PDOStatement objects of performed queries.
*
* @var array
*/
public $query_objects = array();
|
/**
* A count of the number of queries.
|
/**
* A count of the number of queries.
|
| Zeile 44 | Zeile 51 |
|---|
* @var array
*/
public $querylist = array();
|
* @var array
*/
public $querylist = array();
|
/**
|
/**
|
* 1 if error reporting enabled, 0 if disabled.
*
* @var boolean
| * 1 if error reporting enabled, 0 if disabled.
*
* @var boolean
|
| Zeile 58 | Zeile 65 |
|---|
* @var resource
*/
public $link;
|
* @var resource
*/
public $link;
|
/**
|
/**
|
* Explanation of a query.
*
* @var string
| * Explanation of a query.
*
* @var string
|
| Zeile 68 | Zeile 75 |
|---|
/**
* The current version of SQLite.
|
/**
* The current version of SQLite.
|
*
| *
|
* @var string
*/
public $version;
|
* @var string
*/
public $version;
|
/**
|
/**
|
* The current table type in use (myisam/innodb)
*
* @var string
| * The current table type in use (myisam/innodb)
*
* @var string
|
| Zeile 82 | Zeile 89 |
|---|
/**
* The table prefix used for simple select, update, insert and delete queries
|
/**
* The table prefix used for simple select, update, insert and delete queries
|
*
| *
|
* @var string
*/
public $table_prefix;
|
* @var string
*/
public $table_prefix;
|
/**
|
/**
|
* The extension used to run the SQL database
*
* @var string
| * The extension used to run the SQL database
*
* @var string
|
| Zeile 96 | Zeile 103 |
|---|
/**
* Weather or not this engine can use the search functionality
|
/**
* Weather or not this engine can use the search functionality
|
*
| *
|
* @var boolean
*/
public $can_search = true;
| * @var boolean
*/
public $can_search = true;
|
| Zeile 105 | Zeile 112 |
|---|
* The database encoding currently in use (if supported)
*
* @var string
|
* The database encoding currently in use (if supported)
*
* @var string
|
*/
| */
|
public $db_encoding = "";
/**
| public $db_encoding = "";
/**
|
| Zeile 179 | Zeile 186 |
|---|
$this->error_msg = "near \"{$queryparts[0]}\": syntax error";
}
else
|
$this->error_msg = "near \"{$queryparts[0]}\": syntax error";
}
else
|
{
| {
|
// SQLITE 3 supports ADD and RENAME TO alter statements
if(strtolower(substr(ltrim($alterdefs), 0, 3)) == 'add' || strtolower(substr(ltrim($alterdefs), 0, 9)) == "rename to")
{
| // SQLITE 3 supports ADD and RENAME TO alter statements
if(strtolower(substr(ltrim($alterdefs), 0, 3)) == 'add' || strtolower(substr(ltrim($alterdefs), 0, 9)) == "rename to")
{
|
| Zeile 190 | Zeile 197 |
|---|
{
$query = $this->alter_table_parse($tablename, $alterdefs, $string);
}
|
{
$query = $this->alter_table_parse($tablename, $alterdefs, $string);
}
|
}
| }
|
}
else
{
try
{
$query = $this->db->query($string);
|
}
else
{
try
{
$query = $this->db->query($string);
|
}
| }
|
catch(PDOException $exception)
{
$error = array(
"message" => $exception->getMessage(),
"code" => $exception->getCode()
);
|
catch(PDOException $exception)
{
$error = array(
"message" => $exception->getMessage(),
"code" => $exception->getCode()
);
|
|
|
$this->error($error['message'], $error['code']);
}
}
|
$this->error($error['message'], $error['code']);
}
}
|
| |
$this->query_objects[] = $query;
|
if($this->error_number($query) > 0 && !$hide_errors)
{
|
if($this->error_number($query) > 0 && !$hide_errors)
{
|
| Zeile 252 | Zeile 261 |
|---|
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fff;\">Query Time: ".format_time_duration($qtime)."</td>\n".
|
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fff;\">Query Time: ".format_time_duration($qtime)."</td>\n".
|
"</tr>\n".
"</table>\n".
| "</tr>\n".
"</table>\n".
|
"<br />\n";
}
else
| "<br />\n";
}
else
|
| Zeile 290 | Zeile 299 |
|---|
/**
* Return a result array for a query.
|
/**
* Return a result array for a query.
|
*
| *
|
* @param PDOStatement $query The result data.
* @param int $resulttype One of PDO's constants: FETCH_ASSOC, FETCH_BOUND, FETCH_CLASS, FETCH_INTO, FETCH_LAZY, FETCH_NAMED, FETCH_NUM, FETCH_OBJ or FETCH_BOTH
* @return array The array of results.
| * @param PDOStatement $query The result data.
* @param int $resulttype One of PDO's constants: FETCH_ASSOC, FETCH_BOUND, FETCH_CLASS, FETCH_INTO, FETCH_LAZY, FETCH_NAMED, FETCH_NUM, FETCH_OBJ or FETCH_BOTH
* @return array The array of results.
|
| Zeile 299 | Zeile 308 |
|---|
{
$array = $this->db->fetch_array($query, $resulttype);
return $array;
|
{
$array = $this->db->fetch_array($query, $resulttype);
return $array;
|
}
| }
|
/**
* Return a specific field from a query.
|
/**
* Return a specific field from a query.
|
*
* @param PDOStatement $query The query ID.
| *
* @param PDOStatement $query The query ID.
|
* @param string $field The name of the field to return.
* @param int|bool $row The number of the row to fetch it from.
* @return mixed
| * @param string $field The name of the field to return.
* @param int|bool $row The number of the row to fetch it from.
* @return mixed
|
| Zeile 314 | Zeile 323 |
|---|
if($row !== false)
{
$this->data_seek($query, $row);
|
if($row !== false)
{
$this->data_seek($query, $row);
|
}
| }
|
$array = $this->fetch_array($query);
return $array[$field];
|
$array = $this->fetch_array($query);
return $array[$field];
|
}
| }
|
/**
* Moves internal row pointer to the next row
*
| /**
* Moves internal row pointer to the next row
*
|
| Zeile 328 | Zeile 337 |
|---|
function data_seek($query, $row)
{
$this->db->seek($query, $row);
|
function data_seek($query, $row)
{
$this->db->seek($query, $row);
|
| | }
/**
* Closes cursors of registered queries.
*
*/
function close_cursors()
{
$result = true;
foreach($this->query_objects as $query)
{
if(!$query->closeCursor())
{
$result = false;
}
}
return $result;
|
}
/**
| }
/**
|
| Zeile 1084 | Zeile 1112 |
|---|
*
* @param string $table The table
* @param array $replacements The replacements
|
*
* @param string $table The table
* @param array $replacements The replacements
|
* @param mixed $default_field The default field(s)
| * @param string|array $default_field The default field(s)
* @param boolean $insert_id Whether or not to return an insert id. True by default
|
* @return int|PDOStatement|bool Returns either the insert id (if a new row is inserted), the query resource (if a row is updated) or false on failure
*/
|
* @return int|PDOStatement|bool Returns either the insert id (if a new row is inserted), the query resource (if a row is updated) or false on failure
*/
|
function replace_query($table, $replacements=array(), $default_field="")
| function replace_query($table, $replacements=array(), $default_field="", $insert_id=true)
|
{
global $mybb;
| {
global $mybb;
|