281
281
$paths = $this->getPaths();
282
282
if (count($paths['aPath_clean']) > 3) {
285
foreach ($this->parent->children as $child) {
287
&& ($child->type == Node::OBJECT || $child->hasChildren(false))
287
foreach ($this->parent->children as $child) {
289
&& ($child->type == Node::OBJECT || $child->hasChildren(false))
360
361
public function getData($type, $pos, $searchClause = '')
362
363
$query = "SELECT `SCHEMA_NAME` ";
363
$query .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA` ";
364
$query .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA`, ";
366
$query .= "select DB_first_level ";
368
$query .= "SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, ";
369
$query .= "'{$GLOBALS['cfg']['NavigationTreeDbSeparator']}', 1) ";
370
$query .= "DB_first_level ";
371
$query .= "FROM INFORMATION_SCHEMA.SCHEMATA ";
364
372
$query .= $this->_getWhereClause($searchClause);
365
$query .= "ORDER BY `SCHEMA_NAME` ASC ";
366
$query .= "LIMIT $pos, {$GLOBALS['cfg']['MaxNavigationItems']}";
374
$query .= "ORDER BY DB_first_level ASC ";
375
$query .= "LIMIT $pos, {$GLOBALS['cfg']['FirstLevelNavigationItems']}";
377
$query .= "where 1 = locate(concat(DB_first_level, ";
378
$query .= "'{$GLOBALS['cfg']['NavigationTreeDbSeparator']}'), ";
379
$query .= "concat(SCHEMA_NAME, ";
380
$query .= "'{$GLOBALS['cfg']['NavigationTreeDbSeparator']}')) ";
381
$query .= "order by SCHEMA_NAME ASC";
367
383
return $GLOBALS['dbi']->fetchResult($query);
381
396
public function getPresence($type = '', $searchClause = '')
383
$query = "SELECT COUNT(*) ";
384
$query .= "FROM `INFORMATION_SCHEMA`.`SCHEMATA` ";
398
$query = "select COUNT(*) ";
400
$query .= "SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, ";
401
$query .= "'{$GLOBALS['cfg']['NavigationTreeDbSeparator']}', 1) ";
402
$query .= "DB_first_level ";
403
$query .= "FROM INFORMATION_SCHEMA.SCHEMATA ";
385
404
$query .= $this->_getWhereClause($searchClause);
386
406
$retval = (int)$GLOBALS['dbi']->fetchValue($query);