list_db.html 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. <table class="submenu">
  2. <tr>
  3. <td class="wrapper">
  4. <div class="submenu-button-block">
  5. <button class="submenu-button-main" 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-search">
  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 value=""><?php print __('apply to selected');?></option>
  18. <option value="suspend"><?php print __('suspend');?></option>
  19. <option value="unsuspend"><?php print __('unsuspend');?></option>
  20. <option value="delete"><?php print __('delete');?></option>
  21. </select>
  22. <input type="submit" name="ok" value="›" class="submenu-button-select">
  23. </div>
  24. <?php display_error_block(); ?>
  25. </td>
  26. </tr>
  27. </table>
  28. </div>
  29. <div id="vstobjects">
  30. <table class='data'>
  31. <?php
  32. list($http_host, $port) = explode(':', $_SERVER["HTTP_HOST"].":");
  33. foreach ($data as $key => $value) {
  34. ++$i;
  35. if ($data[$key]['SUSPENDED'] == 'yes') {
  36. $status = 'suspended';
  37. $spnd_action = 'unsuspend' ;
  38. $spnd_confirmation = 'UNSUSPEND_DATABASE_CONFIRMATION' ;
  39. } else {
  40. $status = 'active';
  41. $spnd_action = 'suspend' ;
  42. $spnd_confirmation = 'SUSPEND_DATABASE_CONFIRMATION' ;
  43. }
  44. if ($data[$key]['HOST'] != 'localhost' ) $http_host = $data[$key]['HOST'];
  45. if ($data[$key]['TYPE'] == 'mysql') $db_admin = "phpMyAdmin";
  46. if ($data[$key]['TYPE'] == 'mysql') $db_admin_link = "http://".$http_host."/phpmyadmin/";
  47. if (($data[$key]['TYPE'] == 'mysql') && (!empty($_SESSION['DB_PMA_URL']))) $db_admin_link = $_SESSION['DB_PMA_URL'];
  48. if ($data[$key]['TYPE'] == 'pgsql') $db_admin = "phpPgAdmin";
  49. if ($data[$key]['TYPE'] == 'pgsql') $db_admin_link = "http://".$http_host."/phppgadmin/";
  50. if (($data[$key]['TYPE'] == 'pgsql') && (!empty($_SESSION['DB_PGA_URL']))) $db_admin_link = $_SESSION['DB_PGA_URL'];
  51. ?>
  52. <tr class="data-row <? if($status == 'suspended') echo 'suspended';?>">
  53. <td class="data-dotted">
  54. <table class="data-col1">
  55. <tr><td><input type="checkbox" class="ch-toggle" name="database[]" value="<?php echo $key ?>" ></td></tr>
  56. <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'])) ?></a></td></tr>
  57. <tr><td class="data-<?php echo $status ?>"><b><?php echo __($status); ?></b></td></tr>
  58. </table>
  59. </td>
  60. <td class="data-dotted">
  61. <a id="delete_link_<?php echo $i ?>" class="data-controls do_delete">
  62. <span class="do_delete">
  63. <img src="/images/delete.png" width="7px" height="7px">
  64. <?php echo __('delete') ?>
  65. <input type="hidden" name="delete_url" value="/delete/db/?database=<?php echo "$key" ?>" />
  66. <div id="delete_dialog_<?php echo $i ?>" class="confirmation-text-delete hidden" title="<?php print __('Confirmation');?>">
  67. <p class="confirmation"><?php print __('DELETE_DATABASE_CONFIRMATION',$key);?></p>
  68. </div>
  69. </span>
  70. </a>
  71. <a id="<?php echo $spnd_action ?>_link_<?php echo $i ?>" class="data-controls do_<?php echo $spnd_action ?>">
  72. <span class="do_<?php echo $spnd_action ?>">
  73. <img src="/images/suspend.png" width="7px" height="8px">
  74. <?php echo __($spnd_action) ?>
  75. <input type="hidden" name="<?php echo $spnd_action ?>_url" value="/<?php echo $spnd_action ?>/db/?database=<?php echo "$key" ?>" />
  76. <div id="<?php echo $spnd_action ?>_dialog_<?php echo $i ?>" class="confirmation-text-suspention hidden" title="<?php print __('Confirmation');?>">
  77. <p class="confirmation"><?php print __($spnd_confirmation,$key);?></p>
  78. </div>
  79. </span>
  80. </a>
  81. <a href="/edit/db/?database=<?php echo $key ?>" class="data-controls">
  82. <span>
  83. <img src="/images/edit.png" width="8px" height="8px">
  84. <?php print __('edit');?>
  85. </span>
  86. </a>
  87. <a href="<?php echo $db_admin_link; ?>" target="_blank" class="data-controls">
  88. <span>
  89. <img src="/images/db.png" width="8px" height="8px">
  90. <?php print __('open %s',$db_admin);?>
  91. </span>
  92. </a>
  93. <table class="data-col2">
  94. <tr>
  95. <td colspan=3 class="domain">
  96. <?php echo $key ?>
  97. </td>
  98. </tr>
  99. <tr>
  100. <td style="vertical-align:top;" width="239px">
  101. <table>
  102. <tr><td colspan=2><div style="height:10px;"></div></td></tr>
  103. <tr>
  104. <td class="chart">
  105. <?php print __('Disk');?>: <?php echo humanize_usage($data[$key]['U_DISK']) ?>
  106. <div class="bar mini" title="<?php echo get_percentage($data[$key]['U_DISK'],$panel[$user]['DISK_QUOTA']) ?>%">
  107. <div class="fill mini" style="width:<?php echo get_percentage($data[$key]['U_DISK'],$panel[$user]['DISK_QUOTA']) ?>%;"></div>
  108. </div>
  109. </td>
  110. </tr>
  111. </table>
  112. </td>
  113. <td style="vertical-align:top;" width="238px">
  114. <table>
  115. <tr>
  116. <td class="counter-name">
  117. <?php print __('User');?>:
  118. </td>
  119. <td class="counter-value">
  120. <?php echo $data[$key]['DBUSER'] ?>
  121. </td>
  122. </tr>
  123. <tr>
  124. <td class="counter-name">
  125. <?php print __('Host');?>:
  126. </td>
  127. <td class="counter-value">
  128. <?php echo $data[$key]['HOST'] ?>
  129. </td>
  130. </tr>
  131. </table>
  132. </td>
  133. <td style="vertical-align:top;">
  134. <table>
  135. <tr>
  136. <td class="counter-name">
  137. <?php print __('Charset');?>:
  138. </td>
  139. <td class="counter-value">
  140. <?php echo $data[$key]['CHARSET'] ?>
  141. </td>
  142. </tr>
  143. <tr>
  144. <td class="counter-name">
  145. <?php print __('Type');?>:
  146. </td>
  147. <td class="counter-value">
  148. <?php echo $data[$key]['TYPE'] ?>
  149. </td>
  150. </tr>
  151. </table>
  152. </td>
  153. </tr>
  154. </table>
  155. </td>
  156. </tr>
  157. <?php
  158. }
  159. ?>
  160. </table>
  161. </form>
  162. <div class="data-count">
  163. <?php
  164. if ( $i == 1) {
  165. echo __('1 database');
  166. } else {
  167. echo __('%s databases',$i);
  168. }
  169. ?>
  170. </div>
  171. </div>