web_interface/astpp/system/database/drivers/mysql/mysql_driver.php 1 location
|
@@ 405-415 (lines=11) @@
|
| 402 |
|
* @param boolean |
| 403 |
|
* @return string |
| 404 |
|
*/ |
| 405 |
|
function _list_tables($prefix_limit = FALSE) |
| 406 |
|
{ |
| 407 |
|
$sql = "SHOW TABLES FROM ".$this->_escape_char.$this->database.$this->_escape_char; |
| 408 |
|
|
| 409 |
|
if ($prefix_limit !== FALSE AND $this->dbprefix != '') |
| 410 |
|
{ |
| 411 |
|
$sql .= " LIKE '".$this->escape_like_str($this->dbprefix)."%'"; |
| 412 |
|
} |
| 413 |
|
|
| 414 |
|
return $sql; |
| 415 |
|
} |
| 416 |
|
|
| 417 |
|
// -------------------------------------------------------------------- |
| 418 |
|
|
web_interface/astpp/system/database/drivers/mysqli/mysqli_driver.php 1 location
|
@@ 402-412 (lines=11) @@
|
| 399 |
|
* @param boolean |
| 400 |
|
* @return string |
| 401 |
|
*/ |
| 402 |
|
function _list_tables($prefix_limit = FALSE) |
| 403 |
|
{ |
| 404 |
|
$sql = "SHOW TABLES FROM ".$this->_escape_char.$this->database.$this->_escape_char; |
| 405 |
|
|
| 406 |
|
if ($prefix_limit !== FALSE AND $this->dbprefix != '') |
| 407 |
|
{ |
| 408 |
|
$sql .= " LIKE '".$this->escape_like_str($this->dbprefix)."%'"; |
| 409 |
|
} |
| 410 |
|
|
| 411 |
|
return $sql; |
| 412 |
|
} |
| 413 |
|
|
| 414 |
|
// -------------------------------------------------------------------- |
| 415 |
|
|
web_interface/astpp/system/database/drivers/oci8/oci8_driver.php 1 location
|
@@ 490-500 (lines=11) @@
|
| 487 |
|
* @param boolean |
| 488 |
|
* @return string |
| 489 |
|
*/ |
| 490 |
|
protected function _list_tables($prefix_limit = FALSE) |
| 491 |
|
{ |
| 492 |
|
$sql = "SELECT TABLE_NAME FROM ALL_TABLES"; |
| 493 |
|
|
| 494 |
|
if ($prefix_limit !== FALSE AND $this->dbprefix != '') |
| 495 |
|
{ |
| 496 |
|
$sql .= " WHERE TABLE_NAME LIKE '".$this->escape_like_str($this->dbprefix)."%' ".sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 497 |
|
} |
| 498 |
|
|
| 499 |
|
return $sql; |
| 500 |
|
} |
| 501 |
|
|
| 502 |
|
// -------------------------------------------------------------------- |
| 503 |
|
|
web_interface/astpp/system/database/drivers/postgre/postgre_driver.php 1 location
|
@@ 405-415 (lines=11) @@
|
| 402 |
|
* @param boolean |
| 403 |
|
* @return string |
| 404 |
|
*/ |
| 405 |
|
function _list_tables($prefix_limit = FALSE) |
| 406 |
|
{ |
| 407 |
|
$sql = "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'"; |
| 408 |
|
|
| 409 |
|
if ($prefix_limit !== FALSE AND $this->dbprefix != '') |
| 410 |
|
{ |
| 411 |
|
$sql .= " AND table_name LIKE '".$this->escape_like_str($this->dbprefix)."%' ".sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 412 |
|
} |
| 413 |
|
|
| 414 |
|
return $sql; |
| 415 |
|
} |
| 416 |
|
|
| 417 |
|
// -------------------------------------------------------------------- |
| 418 |
|
|
web_interface/astpp/system/database/drivers/sqlite/sqlite_driver.php 1 location
|
@@ 374-383 (lines=10) @@
|
| 371 |
|
* @param boolean |
| 372 |
|
* @return string |
| 373 |
|
*/ |
| 374 |
|
function _list_tables($prefix_limit = FALSE) |
| 375 |
|
{ |
| 376 |
|
$sql = "SELECT name from sqlite_master WHERE type='table'"; |
| 377 |
|
|
| 378 |
|
if ($prefix_limit !== FALSE AND $this->dbprefix != '') |
| 379 |
|
{ |
| 380 |
|
$sql .= " AND 'name' LIKE '".$this->escape_like_str($this->dbprefix)."%' ".sprintf($this->_like_escape_str, $this->_like_escape_chr); |
| 381 |
|
} |
| 382 |
|
return $sql; |
| 383 |
|
} |
| 384 |
|
|
| 385 |
|
// -------------------------------------------------------------------- |
| 386 |
|
|
iNextrix /
ASTPP
