<div class="l-center">
<div class="l-sort clearfix noselect">
<a href="/add/db/" class="l-sort__create-btn" title="<?=__('Add Database')?>"></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" href="'.$db_myadmin_link.'" target="_blank">phpMyAdmin</td>';
}
if($pgsql){
echo '<td class="step-right"><a class="vst" 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>