list_db.html 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  1. <table class="sub-menu" style="background: white;">
  2. <tr>
  3. <td style="padding: 12px 0 8px 6px">
  4. <div style="float:left">
  5. <button style="width:120px; padding: 2px 0px;" onclick="location.href='/add/db/'"> Add Database </button>
  6. </div>
  7. <div style="text-align: right; float: right;">
  8. <form action="/search/" method="get" >
  9. <input type="text" size="30" style="padding: 3px 80px 3px 0; margin: 0 2px 0 0;" name="q">
  10. <input type="submit" value="Search"class="button" style="font-size: 12px; height: 24px;">
  11. </form>
  12. </div>
  13. <div style="float:left; padding-left: 26px;">
  14. <form action="/bulk/db/" method="post" id="objects">
  15. <a style="padding: 0 4px 0 12px" class="select-controls" href='javascript:checkedAll("objects");'> toggle all </a>
  16. <select style="margin:0 2px 0 0px;" name="action">
  17. <option>apply to selected</option>
  18. <option>delete</option>
  19. </select>
  20. <input type="submit" name="ok" value="›" class="button" style="width: 37px; font-size: 12px; height: 24px;">
  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]['TYPE'] == 'mysql') $db_admin = "phpMyAdmin";
  42. if ($data[$key]['TYPE'] == 'mysql') $db_admin_link = "http://".$http_host."/phpMyAdmin/";
  43. if ($data[$key]['TYPE'] == 'pgsql') $db_admin = "phpPgAdmin";
  44. if ($data[$key]['TYPE'] == 'pgsql') $db_admin_link = "http://".$http_host."/phpPgAdmin/";
  45. ?>
  46. <tr class="data-row">
  47. <td class="data-dotted" style="padding: 0px 10px 0px 0px" width="150">
  48. <table class="data-col1">
  49. <tr><td style="padding: 18 0 4 18;"><input type="checkbox" name="database[]" value="<?php echo $key ?>" ></td></tr>
  50. <tr><td><a class="data-date" title="<?php echo $data[$key]['DATE']." ".$data[$key]['TIME'] ?>"><?php echo date("d M Y", strtotime($data[$key]['DATE'])) ?></td></tr>
  51. <tr><td class="data-<?php echo $status ?>"><b><?php echo $status ?></b></td></tr>
  52. </table>
  53. </td>
  54. <td class="data-dotted" width="830px" style="vertical-align:top;">
  55. <table width="830px">
  56. <tr>
  57. <td></td>
  58. <td class="data-controls" width="128px"><a href="<?php echo $db_admin_link; ?>" target="_blank"><img src="/images/new_window.png" width="8px" height="8px"> open <?php echo $db_admin ?> </a></td>
  59. <td class="data-controls" width="50px"><a href="/edit/db/?database=<?php echo $key ?>"><img src="/images/edit.png" width="8px" height="8px"> edit</a></td>
  60. <td class="data-controls do_delete" width="70px">
  61. <img src="/images/delete.png" width="7px" height="7px" class="do_delete">
  62. <a id="delete_link_<?php echo $i ?>" class="do_delete"> delete</a>
  63. <input type="hidden" name="delete_url" value="/delete/db/?database=<?php echo "$key" ?>" />
  64. <div id="delete_dialog_<?php echo $i ?>" class="confirmation-text-delete hidden" title="Confirmation">
  65. <p class="counter-value">Are you sure you want to delete <b><?php echo "$key" ?></b> database?</p>
  66. </div>
  67. </td>
  68. </tr>
  69. </table>
  70. <table class="data-col2" width="830px">
  71. <tr>
  72. <td colspan=3 class="domain" style="padding: 0 0 0 4px;">
  73. <b><?php echo $key ?></b>
  74. </td>
  75. </tr>
  76. <tr>
  77. <td style="vertical-align:top;" >
  78. <table>
  79. <tr>
  80. <td class="counter-name" style="padding: 2px 0 4px 2px">
  81. [<?php echo $data[$key]['TYPE'] ?>] database
  82. </td>
  83. </tr>
  84. <tr>
  85. <td class="chart1" style="padding: 0px 0 0px 2px">Disk: <?php echo humanize_usage($data[$key]['U_DISK']) ?>
  86. <div style="width:160px; height:6px; font-size:0;background-color:#c7d5b3;">
  87. <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>
  88. </div>
  89. </td>
  90. </tr>
  91. </table>
  92. </td>
  93. <td style="vertical-align:top;" width="250">
  94. <table>
  95. <tr>
  96. <td class="counter-name">
  97. User:
  98. </td>
  99. <td class="counter-value">
  100. <?php echo $data[$key]['DBUSER'] ?>
  101. </td>
  102. </tr>
  103. <tr>
  104. <td class="counter-name">
  105. Host:
  106. </td>
  107. <td class="counter-value">
  108. <?php echo $data[$key]['HOST'] ?>
  109. </td>
  110. </tr>
  111. </table>
  112. </td>
  113. <td rowspan=4 style="vertical-align:top;" width="300">
  114. <table>
  115. <tr>
  116. <td class="counter-name">
  117. Charset:
  118. </td>
  119. <td class="counter-value">
  120. <?php echo $data[$key]['CHARSET'] ?>
  121. </td>
  122. </tr>
  123. </table>
  124. </td>
  125. </tr>
  126. </table>
  127. </td>
  128. </tr>
  129. <?php
  130. }
  131. ?>
  132. </table>
  133. </form>
  134. <table class="data-count">
  135. <tr>
  136. <td width="160px"></td>
  137. <td>
  138. <?php
  139. if ( $i == 1) {
  140. echo "1 database ";
  141. } else {
  142. echo "$i databases ";
  143. }
  144. ?>
  145. </td>
  146. </tr>
  147. </table>
  148. </div>