if ($tempDb->dbVersion == 2) {
$tempDb->close();
} else {
$tempDb = null;
}
}
echo "\n\t" . '<tr class="database" style="vertical-align: middle">' . "\n\t\t" . '<td class="img_db" width="18">' . displayPics($dbPics, '', 0, 20) . '</td>' . "\n\t\t" . '<td class="name_db"><a href="index.php?dbsel=' . $ligne['id'] . '" target="_parent" class="dbsel">' . $ligne['name'] . '</a></td>' . "\n\t" . '</tr>';
if ($dbsel == $ligne['id']) {
include_once INCLUDE_LIB . 'SQLiteDbConnect.class.php';
$tempDir = dirname($ligne['location']);
if ($tempDir == '.') {
$baseLocation = DEFAULT_DB_PATH . $ligne['location'];
} else {
$baseLocation = $ligne['location'];
}
$workDb = new SQLiteDbConnect($baseLocation);
if (is_resource($workDb->connId) || is_object($workDb->connId)) {
echo "\n\t" . '<tr valign="middle"><td colspan="2" class="objects" align="right">' . "\n\t\t" . '<table class="items" width="' . (LEFT_FRAME_WIDTH - 25) . '" border="0" cellspacing="0" cellpadding="0">';
foreach ($dbItems as $item) {
$list = $workDb->getPropList($item);
if (is_array($list) && count($list)) {
foreach ($list as $Name) {
$actionLink = '<a href="main.php?dbsel=' . $dbsel . '&' . strtolower($item) . '=' . urlencode($Name) . '" target="main" class="item">';
echo "\n\t\t" . '<tr>';
echo '<td class="image" style="white-space: nowrap">' . $actionLink . displayPics(strtolower($item) . 's.png') . '</a>';
if ($item != 'Function' && $item != 'Trigger') {
echo '<a href="main.php?dbsel=' . $dbsel . '&' . strtolower($item) . '=' . urlencode($Name) . '&action=browseItem" target="main">' . displayPics('browse.png', '', 0, 10) . '</a>';
} else {
echo displayPics('nobrowse.png');
}
echo '</td>';
?>
</div>
</td>
</tr>
</table>
<?php
} elseif (!isset($GLOBALS["action"]) || $GLOBALS["action"] != "auth") {
// gestion de la base selectionné
include_once INCLUDE_LIB . "SQLiteDbConnect.class.php";
$tempDir = dirname($tabInfoDb['location']);
if ($tempDir == '.') {
$baseLocation = DEFAULT_DB_PATH . $tabInfoDb['location'];
} else {
$baseLocation = $tabInfoDb['location'];
}
$workDb = new SQLiteDbConnect($baseLocation);
displayHeader("main");
displayMenuTitle();
$workDb->includeUDF();
if (ALLOW_FULLSEARCH) {
include_once INCLUDE_LIB . "sqlite_fulltextsearchex.class.php";
$sqlite_fts = new sqlite_fulltextsearchex();
$sqlite_fts->register($workDb->connId);
$sqlite_fts->use_against_cache = true;
}
switch ($action) {
case '':
case 'properties':
default:
if ($workDb->isReadable()) {
if ($table || $TableName) {
/**
* Database attachment management and display
*
* @access public
*/
function attachDb()
{
// save form result Or Del attach database
if (isset($_REQUEST['attach_action']) && $_REQUEST['attachId']) {
switch ($_REQUEST['attach_action']) {
case 'add':
$query = 'INSERT INTO attachment (base_id, attach_id) VALUES (' . quotes($GLOBALS['dbsel']) . ', ' . quotes($_REQUEST['attachId']) . ');';
break;
case 'del':
$query = 'DELETE FROM attachment WHERE id=' . quotes($_REQUEST['attachId']) . ';';
break;
}
$GLOBALS['db']->query($query);
}
//echo "<script type=\"text/javascript\">parent.left.location.reload();</script>";
// display attach database attach and form to add it
$out = '<table width="80%"><tr><td align="center">';
$out .= '<fieldset><legend>' . $GLOBALS['traduct']->get(146) . '</legend>
<table class="Browse" cellspacing="0" width="200">
<thead>
<tr class="Browse">
<td colspan=2 align="center" class="tapPropTitle">' . $GLOBALS['traduct']->get(131) . '</td>
</tr>
</thead>' . "\n";
$tabAttach = SQLiteDbConnect::getAttachDb();
$tabAttachId = array();
foreach ($tabAttach as $attach_id => $attachInfo) {
$tabAttachId[] = $attach_id;
$color = $attach_id % 2 ? '#f7f3ef' : '#e7dfce';
$out .= ' <tr class="Browse" bgcolor="' . $color . '">
<td class="Browse">' . $attachInfo['name'] . '</td><td class="Browse" align="center"><a href="?dbsel=' . $GLOBALS['dbsel'] . '&action=options&options_action=attach&attach_action=del&attachId=' . $attachInfo['id'] . '">' . displayPics("supprime.gif", $GLOBALS['traduct']->get(86)) . '</a></td>
</tr>' . "\n";
}
$query = 'SELECT * FROM database';
$tabDb = $GLOBALS['db']->array_query($query, SQLITE_ASSOC);
$out .= ' <tr class="Browse">
<form name="attachDb" method="POST">
<td style="padding:5px" colspan="2" align="center">
<select name="attachId">
<option value="">' . $GLOBALS['traduct']->get(227) . '</option>' . "\n";
foreach ($tabDb as $dbInfo) {
if (!in_array($dbInfo['id'], $tabAttachId) && $dbInfo['id'] != $GLOBALS['dbsel']) {
$tempDb = $GLOBALS["SQLiteFactory"]->sqliteGetInstance($dbInfo["location"]);
if (is_object($tempDb)) {
$versionNum = $tempDb->getVersion();
if ($versionNum == $this->connId->connId->getVersion()) {
$out .= '<option value="' . $dbInfo['id'] . '">' . $dbInfo['name'] . '</option>';
}
}
}
}
$out .= ' </select>
<input class="button" type="submit" value="' . $GLOBALS['traduct']->get(43) . '">
</td>
<input type="hidden" name="dbsel" value="' . $GLOBALS['dbsel'] . '">
<input type="hidden" name="action" value="options">
<input type="hidden" name="options_action" value="attach">
<input type="hidden" name="attach_action" value="add">
</form>
</tr>';
$out .= ' </table>
</fieldset>
</td></tr></table>';
return $out;
}
