mirror of
https://github.com/myvesta/vesta.git
synced 2024-12-11 14:50:50 -08:00
236 lines
11 KiB
HTML
236 lines
11 KiB
HTML
<div class="l-center">
|
|
<div class="l-sort clearfix noselect">
|
|
<a href="/add/db/" class="l-sort__create-btn" title="<?=__('Add Database')?>"><div id="add-icon"></div><div id="tooltip"><?=__('Add Database')?></div></a>
|
|
<ul class="context-menu sort-order" style="display:none;">
|
|
<li entity="sort-date" sort_as_int="1"><span class="name active"><?=__('Date')?></span><span class="up"> </span></li>
|
|
<li entity="sort-name"><span class="name"><?=__('Database')?></span><span class="up"> </span></li>
|
|
<li entity="sort-disk" sort_as_int="1"><span class="name"><?=__('Disk')?></span><span class="up"> </span></li>
|
|
<li entity="sort-user"><span class="name"><?=__('User')?></span><span class="up"> </span></li>
|
|
<li entity="sort-server"><span class="name"><?=__('Host')?></span><span class="up"> </span></li>
|
|
<li entity="sort-star" sort_as_int="1"><span class="name"><?=__('Starred')?></span><span class="up"> </span></li>
|
|
</ul>
|
|
<div class="l-sort-toolbar clearfix">
|
|
<table>
|
|
<tr>
|
|
<?
|
|
$mysql = 0;
|
|
$pgsql = 0;
|
|
|
|
|
|
list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"].":");
|
|
|
|
foreach ($data as $key => $value) {
|
|
if ($data[$key]['TYPE'] == 'mysql'){
|
|
$mysql = 1;
|
|
|
|
$db_myadmin_link = "http://".$http_host."/phpmyadmin/";
|
|
if (!empty($_SESSION['DB_PMA_URL']))
|
|
$db_myadmin_link = $_SESSION['DB_PMA_URL'];
|
|
}
|
|
if ($data[$key]['TYPE'] == 'pgsql'){
|
|
$pgsql = 1;
|
|
$db_pgadmin_link = "http://".$http_host."/phppgadmin/";
|
|
if (!empty($_SESSION['DB_PGA_URL']))
|
|
$db_pgadmin_link = $_SESSION['DB_PGA_URL'];
|
|
}
|
|
}
|
|
if($mysql){
|
|
echo '<td class="step-right"><a class="vst upper_button" href="'.$db_myadmin_link.'" target="_blank">phpMyAdmin</td>';
|
|
}
|
|
if($pgsql){
|
|
echo '<td class="step-right"><a class="vst upper_button" href="'.$db_pgadmin_link.'" target="_blank">phpPgAdmin</td>';
|
|
}
|
|
?>
|
|
|
|
<td class="l-sort-toolbar__search-box step-left">
|
|
<form action="/search/" method="get">
|
|
<input type="hidden" name="token" value="<?=$_SESSION['token']?>" />
|
|
<input type="text" name="q" class="search-input" value="<? echo isset($_POST['q']) ? htmlspecialchars($_POST['q']) : '' ?>" />
|
|
<input type="submit" value="" class="l-sort-toolbar__search" onClick="return doSearch('/search/')" />
|
|
</form>
|
|
</td>
|
|
<td class="toggle-all">
|
|
<input id="toggle-all" type="checkbox" name="toggle-all" value="toggle-all" onChange="checkedAll('objects');">
|
|
<label for="toggle-all" class="check-label toggle-all"><?=__('toggle all')?></label>
|
|
</td>
|
|
<td>
|
|
<form action="/bulk/db/" method="post" id="objects">
|
|
<input type="hidden" name="token" value="<?=$_SESSION['token']?>" />
|
|
<div class="l-select">
|
|
<select name="action" id="">
|
|
<option value=""><?=__('apply to selected')?></option>
|
|
<option value="delete"><?=__('delete')?></option>
|
|
</select>
|
|
</div>
|
|
<input type="submit" value="" class="l-sort-toolbar__filter-apply" />
|
|
</td>
|
|
<td class="sort-by">
|
|
<?=__('sort by');?>: <span><b><?=__('Date')?></b></span> <i class="l-icon-down-arrow media-top"></i>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<!-- -->
|
|
</div>
|
|
</div>
|
|
<!-- /.l-sort -->
|
|
</div>
|
|
|
|
<div class="l-separator"></div>
|
|
<!-- /.l-separator -->
|
|
|
|
|
|
|
|
<div class="l-center units">
|
|
<?
|
|
list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"].":");
|
|
foreach ($data as $key => $value) {
|
|
++$i;
|
|
if ($data[$key]['SUSPENDED'] == 'yes') {
|
|
$status = 'suspended';
|
|
$spnd_action = 'unsuspend' ;
|
|
$spnd_confirmation = 'UNSUSPEND_DATABASE_CONFIRMATION' ;
|
|
} else {
|
|
$status = 'active';
|
|
$spnd_action = 'suspend' ;
|
|
$spnd_confirmation = 'SUSPEND_DATABASE_CONFIRMATION' ;
|
|
}
|
|
if ($data[$key]['HOST'] != 'localhost' ) $http_host = $data[$key]['HOST'];
|
|
if ($data[$key]['TYPE'] == 'mysql') $db_admin = "phpMyAdmin";
|
|
if ($data[$key]['TYPE'] == 'mysql') $db_admin_link = "http://".$http_host."/phpmyadmin/";
|
|
if (($data[$key]['TYPE'] == 'mysql') && (!empty($_SESSION['DB_PMA_URL']))) $db_admin_link = $_SESSION['DB_PMA_URL'];
|
|
if ($data[$key]['TYPE'] == 'pgsql') $db_admin = "phpPgAdmin";
|
|
if ($data[$key]['TYPE'] == 'pgsql') $db_admin_link = "http://".$http_host."/phppgadmin/";
|
|
if (($data[$key]['TYPE'] == 'pgsql') && (!empty($_SESSION['DB_PGA_URL']))) $db_admin_link = $_SESSION['DB_PGA_URL'];
|
|
?>
|
|
|
|
|
|
<div class="l-unit <? if($status == 'suspended') echo 'l-unit--suspended'; if($_SESSION['favourites']['DB'][$key] == 1) echo ' l-unit--starred'; ?>" v_unit_id="<?=$key?>" v_section="db"
|
|
sort-date="<?=strtotime($data[$key]['DATE'].' '.$data[$key]['TIME'])?>" sort-name="<?=$key?>" sort-disk="<?=$data[$key]['U_DISK']?>"
|
|
sort-user="<?=$data[$key]['DBUSER']?>" sort-server="<?=$data[$key]['HOST']?>" sort-star="<? if($_SESSION['favourites']['DB'][$key] == 1) echo '1'; else echo '0'; ?>">
|
|
<div class="l-unit-toolbar clearfix">
|
|
<div class="l-unit-toolbar__col l-unit-toolbar__col--left">
|
|
<input id="check<?php echo $i ?>" class="ch-toggle" type="checkbox" name="database[]" value="<?php echo $key ?>">
|
|
<label for="check<?php echo $i ?>" class="check-label"></label>
|
|
</div>
|
|
<!-- l-unit-toolbar__col -->
|
|
<div class="l-unit-toolbar__col l-unit-toolbar__col--right noselect">
|
|
<div class="actions-panel clearfix">
|
|
<div class="actions-panel__col actions-panel__edit shortcut-enter" key-action="href"><a href="/edit/db/?database=<?=$key?>"><?=__('edit')?> <i></i></a><span class="shortcut enter"> ↵</span></div>
|
|
<div class="actions-panel__col actions-panel__delete shortcut-delete" key-action="js">
|
|
<a id="delete_link_<?=$i?>" class="data-controls do_delete">
|
|
<?=__('delete')?> <i class="do_delete"></i>
|
|
<input type="hidden" name="delete_url" value="/delete/db/?database=<?=$key?>&token=<?=$_SESSION['token']?>" />
|
|
<div id="delete_dialog_<?=$i?>" class="confirmation-text-delete hidden" title="<?=__('Confirmation')?>">
|
|
<p class="confirmation"><?=__('DELETE_DATABASE_CONFIRMATION',$key)?></p>
|
|
</div>
|
|
</a>
|
|
<span class="shortcut delete"> Del</span>
|
|
</div>
|
|
</div>
|
|
<!-- /.actiona-panel -->
|
|
</div>
|
|
<!-- l-unit-toolbar__col -->
|
|
</div>
|
|
<!-- /.l-unit-toolbar -->
|
|
|
|
<div class="l-unit__col l-unit__col--left clearfix">
|
|
<div class="l-unit__date">
|
|
<?=translate_date($data[$key]['DATE'])?>
|
|
</div>
|
|
<div class="l-unit__suspended"><?=__('suspended')?></div>
|
|
<div class="text-center">
|
|
<i class="l-icon-star" title="<?=__('save to favorites')?>"></i>
|
|
</div>
|
|
</div>
|
|
<!-- /.l-unit__col -->
|
|
<div class="l-unit__col l-unit__col--right">
|
|
<div class="l-unit__name separate">
|
|
<?=$key?>
|
|
</div>
|
|
<!-- /.l-unit__name -->
|
|
<div class="l-unit__stats">
|
|
<table>
|
|
<tr>
|
|
<td>
|
|
<div class="l-unit__stat-cols clearfix graph">
|
|
<div class="l-unit__stat-col l-unit__stat-col--left">
|
|
<?=__('Disk')?>
|
|
</div>
|
|
<div class="l-unit__stat-col l-unit__stat-col--right text-right volume">
|
|
<b><?=humanize_usage_size($data[$key]['U_DISK'])?></b> <?=humanize_usage_measure($data[$key]['U_DISK'])?>
|
|
</div>
|
|
</div>
|
|
<div class="l-percent">
|
|
<div class="l-percent__fill" style="width: <?=get_percentage($data[$key]['U_DISK'],$panel[$user]['DISK_QUOTA'])?>%"></div>
|
|
</div>
|
|
<!-- /.percent -->
|
|
</td>
|
|
<td>
|
|
<div class="l-unit__stat-cols clearfix">
|
|
<div class="l-unit__stat-col l-unit__stat-col--left"><?=__('User')?>:</div>
|
|
<div class="l-unit__stat-col l-unit__stat-col--right">
|
|
<b><?=$data[$key]['DBUSER']?></b>
|
|
</div>
|
|
</div>
|
|
</td>
|
|
<td>
|
|
<div class="l-unit__stat-cols clearfix last">
|
|
<div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Host')?>:</div>
|
|
<div class="l-unit__stat-col l-unit__stat-col--right">
|
|
<b><?=$data[$key]['HOST']?></b>
|
|
</div>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td></td>
|
|
<td>
|
|
<div class="l-unit__stat-cols clearfix">
|
|
<div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Charset')?>:</div>
|
|
<div class="l-unit__stat-col l-unit__stat-col--right">
|
|
<b><?=$data[$key]['CHARSET']?></b>
|
|
</div>
|
|
</div>
|
|
</td>
|
|
<td>
|
|
<div class="l-unit__stat-cols clearfix last">
|
|
<div class="l-unit__stat-col l-unit__stat-col--left"><?=__('Type')?>:</div>
|
|
<div class="l-unit__stat-col l-unit__stat-col--right">
|
|
<b><?=$data[$key]['TYPE']?></b>
|
|
</div>
|
|
</div>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
<!-- /.l-unit__stats -->
|
|
</div>
|
|
<!-- /.l-unit__col -->
|
|
</div>
|
|
<!-- /.l-unit -->
|
|
<!-- div class="l-separator"></div-->
|
|
<!-- /.l-separator -->
|
|
<?}?>
|
|
|
|
</div>
|
|
|
|
|
|
<div id="vstobjects">
|
|
<div class="l-separator"></div>
|
|
<div class="l-center">
|
|
<div class="l-unit-ft">
|
|
<table class='data'></table>
|
|
<div class="l-unit__col l-unit__col--left clearfix"></div>
|
|
<div class="data-count l-unit__col l-unit__col--right clearfix">
|
|
<?php
|
|
if ( $i == 1) {
|
|
echo __('1 database');
|
|
} else {
|
|
echo __('%s databases',$i);
|
|
}
|
|
?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|