<?php
$title = 'Codebase Editor';
template::inc('skybox', 'top');
$selected_codebase = $_GET['codebase'];
$table = $_GET['table'];
$codebase_list = get_codebases();
$codebase_arr = array();
$aql = "dev_codebase\t{\n\t\t\t\t\t\t\tname\n\t\t\t\t\t\t}";
$codebase_arr = array();
$rs = aql::select($aql);
foreach ($rs as $r) {
$codebase_arr[$r['name']] = $r['name'];
}
foreach ($codebase_list as $codebase) {
$codebase_arr[$codebase['codebase']] = $codebase['codebase'];
}
$param = array('id' => 'codebase_name', 'name' => 'name', 'selected_value' => $selected_codebase);
snippet::dropdown($codebase_arr, $param);
?>
<br><br>
<div>
<input type="hidden" id = "table_name" value = "<?php
echo $table;
?>
" />
<input type="submit" value="Save" onclick = "save_codebase()" />
</div>
<?php
template::inc('skybox', 'bottom');
}
?>
</div>
<textarea id="sql_editor"><?php
echo str_replace('\\n', "\n", $SQL);
?>
</textarea>
<input type = "hidden" value = "<?php
echo $fn;
?>
" name = "fn" id = "fn" />
<div style="margin: 15px 0 15px 0;">
<?php
if ($fn == 'create_table') {
$list = get_codebases();
$codebase_arr = array();
foreach ($list as $codebase) {
if ($codebase['official_db']) {
$codebase_arr[$codebase['codebase']] = $codebase['codebase'];
}
}
$param = array('id' => 'codebase_name', 'name' => 'name', 'onchange' => 'enter_codebase();', 'selected_value' => $codebase);
snippet::dropdown($codebase_arr, $param);
}
?>
<input type="button" value="Execute" onclick="if (confirm('Are you sure?')) execute_sql('<?php
echo $table;
?>
');" />
<div id="execute"></div>
template::inc('intranet', 'top');
include INCPATH . '/../dev-nav.php';
?>
<div>
<h2>This website uses the following codebases:</h2>
</div>
<table class="listing">
<tr>
<th>Codebase</th>
<th>Code Version</th>
<th>DB Version</th>
<th></th>
<th></th>
</tr>
<?php
$codebases = get_codebases();
foreach ($codebases as $cb) {
$codebase_name = $cb['codebase'];
$database = $schemas[$codebase_name];
$latest_version = get_latest_version($codebase_name);
?>
<tr>
<td><?php
echo $codebase_name;
?>
</td>
<td>
<?php
if ($cb['release'] == 'stable') {
echo $cb['version'];
} else {
template::inc('global', 'top');
//find backup files
$backup_directory = '/backup';
$backup_folder_path = '';
$files = @scandir($backup_directory);
if ($files) {
foreach ($files as $file) {
$file_path = $backup_directory . '/' . $file;
if (is_dir($file_path) && strpos($file, '.') !== 0) {
$backup_folder_path = $file_path;
break;
}
}
}
// get array of codebases
$codebase_array = get_codebases();
template::breadcrumb();
include INCPATH . '/../dev-nav.php';
?>
<h1><?php
echo $title;
?>
</h1>
<?php
if (slony::sniff_cluster()) {
echo "A Slony cluster is defined but \$slony_cluster_name is not!<br/><br/>";
echo "Using this interface has the potential to seriously disrupt replication, so we're stopping you now...";
die;
}
