list_db.html 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158
  1. <table class="submenu">
  2. <tr>
  3. <td style="padding: 2px 0 0 6px">
  4. <div class="submenu-button-block">
  5. <button class="submenu-button" onclick="location.href='/add/db/'"> <?php print _('Add Database');?> </button>
  6. </div>
  7. <div class="submenu-search-block">
  8. <form action="/search/" method="get">
  9. <input type="text" name="q" class="submenu-search-field">
  10. <input type="submit" value="<?php print _('Search');?>" class="submenu-button" style="width: 96px;">
  11. </form>
  12. </div>
  13. <div class="submenu-select-block">
  14. <form action="/bulk/db/" method="post" id="objects">
  15. <a class="submenu-select-link" href='javascript:checkedAll("objects");'> <?php print _('toggle all');?> </a>
  16. <select class="submenu-select-dropdown" name="action">
  17. <option><?php print _('apply to selected');?></option>
  18. <option><?php print _('delete');?></option>
  19. </select>
  20. <input type="submit" name="ok" value="›" class="submenu-button" style="width: 36px;">
  21. </div>
  22. </td>
  23. </tr>
  24. </table>
  25. </td>
  26. </tr>
  27. </table>
  28. <div id="vstobjects">
  29. <table class='data'>
  30. <?php
  31. list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"] . ":");
  32. foreach ($data as $key => $value) {
  33. ++$i;
  34. if ($data[$key]['SUSPENDED'] == 'yes') {
  35. $status = 'suspended';
  36. $spnd_action = 'unsuspend' ;
  37. } else {
  38. $status = 'active';
  39. $spnd_action = 'suspend' ;
  40. }
  41. if ($data[$key]['HOST'] != 'localhost' ) $http_host = $data[$key]['HOST'];
  42. if ($data[$key]['TYPE'] == 'mysql') $db_admin = "phpMyAdmin";
  43. if ($data[$key]['TYPE'] == 'mysql') $db_admin_link = "http://".$http_host."/phpMyAdmin/";
  44. if ($data[$key]['TYPE'] == 'pgsql') $db_admin = "phpPgAdmin";
  45. if ($data[$key]['TYPE'] == 'pgsql') $db_admin_link = "http://".$http_host."/phpPgAdmin/";
  46. ?>
  47. <tr class="data-row">
  48. <td class="data-dotted" style="padding: 0px 10px 0px 0px" width="150">
  49. <table class="data-col1">
  50. <tr><td style="padding: 18 0 4 18;"><input type="checkbox" name="database[]" value="<?php echo $key ?>" ></td></tr>
  51. <tr><td><a class="data-date" title="<?php echo $data[$key]['DATE']." ".$data[$key]['TIME'] ?>"><?php echo strftime("%d %b %Y", strtotime($data[$key]['DATE'])) ?></td></tr>
  52. <tr><td class="data-<?php echo $status ?>"><b><?php echo _($status); ?></b></td></tr>
  53. </table>
  54. </td>
  55. <td class="data-dotted" width="830px" style="vertical-align:top;">
  56. <a id="delete_link_<?php echo $i ?>" class="data-controls do_delete">
  57. <span class="do_delete">
  58. <img src="/images/delete.png" width="7px" height="7px">
  59. <?php echo _('delete') ?>
  60. <input type="hidden" name="delete_url" value="/delete/db/?database=<?php echo "$key" ?>" />
  61. <div id="delete_dialog_<?php echo $i ?>" class="confirmation-text-delete hidden" title="<?php print _('Confirmation');?>">
  62. <p class="counter-value"><?php print _('DATABASE_ACTION_CONFIRMATION',_('delete'),$key);?></p>
  63. </div>
  64. </span>
  65. </a>
  66. <a href="/edit/db/?database=<?php echo $key ?>" class="data-controls">
  67. <span>
  68. <img src="/images/edit.png" width="8px" height="8px">
  69. <?php print _('edit');?>
  70. </span>
  71. </a>
  72. <a href="<?php echo $db_admin_link; ?>" target="_blank" class="data-controls">
  73. <span>
  74. <img src="/images/new_window.png" width="8px" height="8px">
  75. <?php print _('open %s',$db_admin);?>
  76. </span>
  77. </a>
  78. <table class="data-col2" width="830px">
  79. <tr>
  80. <td colspan=3 class="domain" style="padding: 0 0 0 4px;">
  81. <b><?php echo $key ?></b>
  82. </td>
  83. </tr>
  84. <tr>
  85. <td style="vertical-align:top;" >
  86. <table>
  87. <tr>
  88. <td class="counter-name" style="padding: 2px 0 4px 2px">
  89. [<?php echo $data[$key]['TYPE'] ?>] <?php print _('database');?>
  90. </td>
  91. </tr>
  92. <tr>
  93. <td class="chart1" style="padding: 0px 0 0px 2px"><?php print _('Disk');?>: <?php echo humanize_usage($data[$key]['U_DISK']) ?>
  94. <div style="width:160px; height:6px; font-size:0;background-color:#c7d5b3;">
  95. <div style="width:<?php echo get_percentage($data[$key]['U_DISK'],$panel[$user]['DISK_QUOTA']) ?>%; height:6px; background-color:#9bbb62; border-right:1px #9bbb62 solid;"></div>
  96. </div>
  97. </td>
  98. </tr>
  99. </table>
  100. </td>
  101. <td style="vertical-align:top;" width="250">
  102. <table>
  103. <tr>
  104. <td class="counter-name">
  105. <?php print _('User');?>:
  106. </td>
  107. <td class="counter-value">
  108. <?php echo $data[$key]['DBUSER'] ?>
  109. </td>
  110. </tr>
  111. <tr>
  112. <td class="counter-name">
  113. <?php print _('Host');?>:
  114. </td>
  115. <td class="counter-value">
  116. <?php echo $data[$key]['HOST'] ?>
  117. </td>
  118. </tr>
  119. </table>
  120. </td>
  121. <td rowspan=4 style="vertical-align:top;" width="300">
  122. <table>
  123. <tr>
  124. <td class="counter-name">
  125. <?php print _('Charset');?>:
  126. </td>
  127. <td class="counter-value">
  128. <?php echo $data[$key]['CHARSET'] ?>
  129. </td>
  130. </tr>
  131. </table>
  132. </td>
  133. </tr>
  134. </table>
  135. </td>
  136. </tr>
  137. <?php
  138. }
  139. ?>
  140. </table>
  141. </form>
  142. <table class="data-count">
  143. <tr>
  144. <td width="160px"></td>
  145. <td>
  146. <?php
  147. if ( $i == 1) {
  148. echo _('1 database');
  149. } else {
  150. echo _('%s databases',$i);
  151. }
  152. ?>
  153. </td>
  154. </tr>
  155. </table>
  156. </div>