add_db.html 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212
  1. <?php
  2. $back = $_SESSION['back'];
  3. if (empty($back)) {
  4. $back = "location.href='/list/db/'";
  5. } else {
  6. $back = "location.href='".$back."'";
  7. }
  8. ?>
  9. <table class="submenu">
  10. <tr>
  11. <td style="padding: 18px 8px;" ><a class="name"><b><?php print __('Adding database');?></b></a>
  12. <?php
  13. if (!empty($_SESSION['error_msg'])) {
  14. echo "<span class=\"vst-error\"> → ".$_SESSION['error_msg']."</span>";
  15. } else {
  16. if (!empty($_SESSION['ok_msg'])) {
  17. echo "<span class=\"vst-ok\"> → ".$_SESSION['ok_msg']."</span>";
  18. }
  19. }
  20. ?>
  21. </td>
  22. </tr>
  23. </table>
  24. </div>
  25. <form id="vstobjects" name="v_add_db" method="post">
  26. <script type="text/javascript">
  27. function elementHideShow(elementToHideOrShow) {
  28. var el = document.getElementById(elementToHideOrShow);
  29. if (el.style.display == "block") {
  30. el.style.display = "none";
  31. } else {
  32. el.style.display = "block";
  33. }
  34. }
  35. function randomString() {
  36. var chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXTZabcdefghiklmnopqrstuvwxyz";
  37. var string_length = 10;
  38. var randomstring = '';
  39. for (var i=0; i<string_length; i++) {
  40. var rnum = Math.floor(Math.random() * chars.length);
  41. randomstring += chars.substring(rnum,rnum+1);
  42. }
  43. document.v_add_db.v_password.value = randomstring;
  44. }
  45. </script>
  46. <table class='data'>
  47. <tr class="data-add">
  48. <td class="data-dotted" width="150">
  49. <table class="data-col1">
  50. <tr><td></td></tr>
  51. </table>
  52. </td>
  53. <td class="data-dotted" width="830px">
  54. <table width="830px">
  55. <tr>
  56. <td></td>
  57. </tr>
  58. </table>
  59. <table class="data-col2" width="600px">
  60. <tr>
  61. <td style="padding: 20px 0 0 2px; color:#777;" >
  62. <?php print __('Prefix will be automaticaly added to database name and database user',$user."_");?>
  63. </td>
  64. </tr>
  65. <tr>
  66. <td class="vst-text" style="padding: 10px 0 0 2px;">
  67. <?php print __('Database');?>
  68. </td>
  69. </tr>
  70. <tr>
  71. <td>
  72. <input type="text" size="20" class="vst-input" name="v_database" <?php if (!empty($v_database)) echo "value=".$v_database; ?>>
  73. <small class="hint"></small>
  74. </td>
  75. </tr>
  76. <tr>
  77. <td class="vst-text" style="padding: 10px 0 0 2px;">
  78. <?php print __('User');?>
  79. </td>
  80. </tr>
  81. <tr>
  82. <td>
  83. <input type="text" size="20" class="vst-input" name="v_dbuser" <?php if (!empty($v_dbuser)) echo "value=".$v_dbuser; ?>>
  84. <small class="hint"></small>
  85. </td>
  86. </tr>
  87. <tr>
  88. <td class="vst-text" style="padding: 10px 0 0 2px;">
  89. <?php print __('Password');?> <a href="javascript:randomString();" class="genpass"><?php print __('generate');?></a>
  90. </td>
  91. </tr>
  92. <tr>
  93. <td>
  94. <input type="text" size="20" class="vst-input" name="v_password">
  95. </td>
  96. </tr>
  97. <tr>
  98. <td class="vst-text" style="padding: 10px 0 0 2px;">
  99. <?php print __('Type');?>
  100. </td>
  101. </tr>
  102. <tr>
  103. <td>
  104. <select class="vst-list" name="v_type">
  105. <?php
  106. foreach ($db_types as $key => $value) {
  107. echo "\n\t\t\t\t\t\t\t\t\t\t<option value=\"".$value."\"";
  108. if ((!empty($v_type)) && ( $value == $v_type )) echo ' selected';
  109. echo ">".$value."</option>";
  110. }
  111. ?>
  112. </select>
  113. </td>
  114. </tr>
  115. <tr>
  116. <td class="vst-text" style="padding: 10px 0 0 2px;">
  117. <?php print __('Host');?>
  118. </td>
  119. </tr>
  120. <tr>
  121. <td>
  122. <select class="vst-list" name="v_host">
  123. <?php
  124. foreach ($db_hosts as $key => $value) {
  125. echo "\n\t\t\t\t\t\t\t\t\t\t<option value=\"".$key."\"";
  126. if ((!empty($v_host)) && ( $key == $v_host )) echo ' selected';
  127. echo ">".$key."</option>";
  128. }
  129. ?>
  130. </select>
  131. </td>
  132. </tr>
  133. <tr>
  134. <td class="vst-text" style="padding: 10px 0 0 2px;">
  135. <?php print __('Charset');?>
  136. </td>
  137. </tr>
  138. <tr>
  139. <td>
  140. <select class="vst-list" name="v_charset">
  141. <option value=big5 <?php if ((!empty($v_charset)) && ( $v_charset == 'big5')) echo 'selected';?> >big5</option>
  142. <option value=dec8 <?php if ((!empty($v_charset)) && ( $v_charset == 'dec8')) echo 'selected';?> >dec8</option>
  143. <option value=cp850 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp850')) echo 'selected';?> >cp850</option>
  144. <option value=hp8 <?php if ((!empty($v_charset)) && ( $v_charset == 'hp8')) echo 'selected';?> >hp8</option>
  145. <option value=koi8r <?php if ((!empty($v_charset)) && ( $v_charset == 'koi8r')) echo 'selected';?> >koi8r</option>
  146. <option value=latin1 <?php if ((!empty($v_charset)) && ( $v_charset == 'latin1')) echo 'selected';?> >latin1</option>
  147. <option value=latin2 <?php if ((!empty($v_charset)) && ( $v_charset == 'latin2')) echo 'selected';?> >latin2</option>
  148. <option value=swe7 <?php if ((!empty($v_charset)) && ( $v_charset == 'swe7')) echo 'selected';?> >swe7</option>
  149. <option value=ascii <?php if ((!empty($v_charset)) && ( $v_charset == 'ascii')) echo 'selected';?> >ascii</option>
  150. <option value=ujis <?php if ((!empty($v_charset)) && ( $v_charset == 'ujis')) echo 'selected';?> >ujis</option>
  151. <option value=sjis <?php if ((!empty($v_charset)) && ( $v_charset == 'sjis')) echo 'selected';?> >sjis</option>
  152. <option value=hebrew <?php if ((!empty($v_charset)) && ( $v_charset == 'hebrew')) echo 'selected';?> >hebrew</option>
  153. <option value=tis620 <?php if ((!empty($v_charset)) && ( $v_charset == 'tis620')) echo 'selected';?> >tis620</option>
  154. <option value=euckr <?php if ((!empty($v_charset)) && ( $v_charset == 'euckr')) echo 'selected';?> >euckr</option>
  155. <option value=koi8u <?php if ((!empty($v_charset)) && ( $v_charset == 'koi8u')) echo 'selected';?> >koi8u</option>
  156. <option value=gb2312 <?php if ((!empty($v_charset)) && ( $v_charset == 'gb2312')) echo 'selected';?> >gb2312</option>
  157. <option value=greek <?php if ((!empty($v_charset)) && ( $v_charset == 'greek')) echo 'selected';?> >greek</option>
  158. <option value=cp1250 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp1250')) echo 'selected';?> >cp1250</option>
  159. <option value=gbk <?php if ((!empty($v_charset)) && ( $v_charset == 'gbk')) echo 'selected';?> >gbk</option>
  160. <option value=latin5 <?php if ((!empty($v_charset)) && ( $v_charset == 'latin5')) echo 'selected';?> >latin5</option>
  161. <option value=armscii8 <?php if ((!empty($v_charset)) && ( $v_charset == 'armscii8')) echo 'selected';?> >armscii8</option>
  162. <option value=utf8 <?php if ((!empty($v_charset)) && ( $v_charset == 'utf8')) echo 'selected';?> <?php if (empty($v_charset)) echo 'selected';?> >utf8</option>
  163. <option value=ucs2 <?php if ((!empty($v_charset)) && ( $v_charset == 'ucs2')) echo 'selected';?> >ucs2</option>
  164. <option value=cp866 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp866')) echo 'selected';?> >cp866</option>
  165. <option value=keybcs2 <?php if ((!empty($v_charset)) && ( $v_charset == 'keybcs2')) echo 'selected';?> >keybcs2</option>
  166. <option value=macce <?php if ((!empty($v_charset)) && ( $v_charset == 'macce')) echo 'selected';?> >macce</option>
  167. <option value=macroman <?php if ((!empty($v_charset)) && ( $v_charset == 'macroman')) echo 'selected';?> >macroman</option>
  168. <option value=cp852 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp852')) echo 'selected';?> >cp852</option>
  169. <option value=latin7 <?php if ((!empty($v_charset)) && ( $v_charset == 'latin7')) echo 'selected';?> >latin7</option>
  170. <option value=cp1251 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp1251')) echo 'selected';?> >cp1251</option>
  171. <option value=cp1256 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp1256')) echo 'selected';?> >cp1256</option>
  172. <option value=cp1257 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp1257')) echo 'selected';?> >cp1257</option>
  173. <option value=binary <?php if ((!empty($v_charset)) && ( $v_charset == 'binary')) echo 'selected';?> >binary</option>
  174. <option value=geostd8 <?php if ((!empty($v_charset)) && ( $v_charset == 'geostd8')) echo 'selected';?> >geostd8</option>
  175. <option value=cp932 <?php if ((!empty($v_charset)) && ( $v_charset == 'cp932')) echo 'selected';?> >cp932</option>
  176. <option value=eucjpms <?php if ((!empty($v_charset)) && ( $v_charset == 'eucjpms')) echo 'selected';?> >eucjpms</option>
  177. </select>
  178. </td>
  179. <tr>
  180. <td class="vst-text" style="padding: 10px 0 0 2px;">
  181. <?php print __('Send login credentials to email address') ?>
  182. </td>
  183. </tr>
  184. <tr>
  185. <td>
  186. <input type="text" class="vst-input" name="v_db_email" <?php if (!empty($v_db_email)) echo "value=".$v_db_email; ?>>
  187. </td>
  188. </tr>
  189. </table>
  190. <table class="data-col2">
  191. <tr>
  192. <td style="padding: 24px 0 0 0;" width="116px">
  193. <input type="submit" name="ok" value="<?php print __('Add');?>" class="button">
  194. </td>
  195. <td style="padding: 24px 0 0 0;">
  196. <input type="button" class="button" value="<?php print __('Back');?>" onclick="<?php echo $back ?>">
  197. </td>
  198. </tr>
  199. </table>
  200. </td>
  201. </tr>
  202. </table>
  203. </form>
  204. <script type="text/javascript">
  205. GLOBAL.DB_USER_PREFIX = '<?php echo $user; ?>_';
  206. GLOBAL.DB_DBNAME_PREFIX = '<?php echo $user; ?>_';
  207. </script>
  208. <script type="text/javascript" src="/js/pages/add.db.js"></script>