1021        <form action="install.php?mode=database" method="post">

  1021       <form action="install.php?mode=database" method="post">

  1022          <table border="0">

  1022         <table border="0">

  1023          <tr>

  1023         <tr>

  1024            <td>

  1024           <td>

  1025              <input type="submit" value="Continue" />

  1025             <input type="submit" value="<?php echo $lang->get('meta_btn_continue'); ?>" />

  1026            </td>

  1026           </td>

  1027            <td>

  1027           <td>

  1028              <p>

  1028             <p>

  1029                <span style="font-weight: bold;"><?php echo $lang->get('meta_lbl_before_continue'); ?></span><br />

  1029               <span style="font-weight: bold;"><?php echo $lang->get('meta_lbl_before_continue'); ?></span><br />

  1030                &bull; Review the list above to ensure that you are satisfied with any of Enano's workarounds for your server. If you need a particular feature and that feature is listed as disabled above, you should take the opportunity now to correct the problem.<br />

  1030               &bull; <?php echo $lang->get('sysreqs_objective_scalebacks'); ?><br />

  1031                • Have your database host, name, username, and password available

  1031               &bull; <?php echo $lang->get('license_objective_have_db_info'); ?>

  1032              </p>

  1032             </p>

  1033            </td>

  1033           </td>

  1034          </tr>

  1034         </tr>

  1035          </table>

  1035         </table>

  1036        </form>

  1036       </form>

  1037      </div>

  1037       </div>

  1038      <?php

  1038     <?php

  1039     } else {

  1039     }

  1040       if($failed) {

  1040     else

  1041     {

  1042       if ( $failed )

  1043       {

  1091           alert('One or more of the form fields is incorrect. Please correct any information in the form that has an "X" next to it.');

  1094           alert($lang.get('meta_msg_err_verification'));

  1114                 if(t.match(/_creating_db/)) document.getElementById('e_db_name').innerHTML = '<b>Warning:<\/b> The database you specified does not exist. It will be created during installation.';

  1117                 if(t.match(/_creating_db/)) document.getElementById('e_db_name').innerHTML = $lang.get('database_msg_warn_creating_db');

  1115                 if(t.match(/_creating_user/)) document.getElementById('e_db_auth').innerHTML = '<b>Warning:<\/b> The specified regular user does not exist or the password is incorrect. The user will be created during installation. If the user already exists, the password will be reset.';

  1118                 if(t.match(/_creating_user/)) document.getElementById('e_db_auth').innerHTML = $lang.get('database_msg_warn_creating_user');

  1117                 document.getElementById('e_mysql_version').innerHTML = 'Your version of MySQL meets Enano requirements.';

  1120                 document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_info_mysql_good');

  1128                   document.getElementById('e_db_host').innerHTML = '<b>Error:<\/b> The database server "'+document.forms.dbinfo.db_host.value+'" couldn\'t be contacted.<br \/>'+t;

  1131                   document.getElementById('e_db_host').innerHTML = $lang.get('database_msg_err_mysql_connect', { db_host: document.forms.dbinfo.db_host.value, mysql_error: t });

  1129                   document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

  1132                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_warn_mysql_version');

  1136                   document.getElementById('e_db_auth').innerHTML = '<b>Error:<\/b> Access to MySQL under the specified credentials was denied.<br \/>'+t;

  1139                   document.getElementById('e_db_auth').innerHTML = $lang.get('database_msg_err_mysql_auth', { mysql_error: t });

  1137                   document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

  1140                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_warn_mysql_version');

  1144                   document.getElementById('e_db_name').innerHTML = '<b>Error:<\/b> Access to the specified database using those login credentials was denied.<br \/>'+t;

  1147                   document.getElementById('e_db_name').innerHTML = $lang.get('database_msg_err_mysql_dbperm', { mysql_error: t });

  1145                   document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

  1148                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_warn_mysql_version');

  1152                   document.getElementById('e_db_name').innerHTML = '<b>Error:<\/b> The specified database does not exist<br \/>'+t;

  1155                   document.getElementById('e_db_name').innerHTML = $lang.get('database_msg_err_mysql_dbexist', { mysql_error: t });

  1153                   document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

  1156                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_warn_mysql_version');

  1160                   document.getElementById('e_db_root').innerHTML = '<b>Error:<\/b> Access to MySQL under the specified credentials was denied.<br \/>'+t;

  1163                   document.getElementById('e_db_root').innerHTML = $lang.get('database_msg_err_mysql_auth', { mysql_error: t });

  1161                   document.getElementById('e_mysql_version').innerHTML = 'The MySQL version that your server is running could not be determined.';

  1164                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_warn_mysql_version');

  1168                   if(t.match(/_creating_db/)) document.getElementById('e_db_name').innerHTML = '<b>Warning:<\/b> The database you specified does not exist. It will be created during installation.';

  1171                   if(t.match(/_creating_db/)) document.getElementById('e_db_name').innerHTML = $lang.get('database_msg_warn_creating_db');

  1169                   if(t.match(/_creating_user/)) document.getElementById('e_db_auth').innerHTML = '<b>Warning:<\/b> The specified regular user does not exist or the password is incorrect. The user will be created during installation. If the user already exists, the password will be reset.';

  1172                   if(t.match(/_creating_user/)) document.getElementById('e_db_auth').innerHTML = $lang.get('database_msg_warn_creating_user');

  1171                   document.getElementById('e_mysql_version').innerHTML = '<b>Error:<\/b> Your version of MySQL ('+t+') is older than 4.1.17. Enano will still work, but there is a known bug with the comment system and MySQL 4.1.11 that involves some comments not being displayed, due to an issue with the PHP function mysql_fetch_row().';

  1174                   document.getElementById('e_mysql_version').innerHTML = $lang.get('database_msg_err_mysql_version', { mysql_version: t });

  1244     <p>Now we need some information that will allow Enano to contact your database server. Enano uses MySQL as a data storage backend,

  1247     <p><?php echo $lang->get('database_blurb_needdb'); ?></p>

  1245        and we need to have access to a MySQL server in order to continue.</p>

  1248     <p><?php echo $lang->get('database_blurb_howtomysql'); ?></p>

  1246     <p>If you do not have access to a MySQL server, and you are using your own server, you can download MySQL for free from

  1247        <a href="http://www.mysql.com/">MySQL.com</a>. <b>Please note that, like Enano, MySQL is licensed under the GNU GPL.</b>

  1248        If you need to modify MySQL and then distribute your modifications, you must either distribute them under the terms of the GPL

  1249        or purchase a proprietary license.</p>

  1253       echo '<p><b>MySQL login information for this virtual appliance:</b><br /><br />Database hostname: localhost<br />Database login: username "enano", password: "clurichaun" (without quotes)<br />Database name: enano_www1</p>';

  1252       echo '<p>

  1253               ' . $lang->get('database_vm_login_info', array( 'host' => 'localhost', 'user' => 'enano', 'pass' => 'clurichaun', 'name' => 'enano_www1' )) . '

  1254             </p>';

  1258         <tr><td colspan="3" style="text-align: center"><h3>Database information</h3></td></tr>

  1259         <tr>

  1259         <tr><td><b>Database hostname</b><br />This is the hostname (or sometimes the IP address) of your MySQL server. In many cases, this is "localhost".<br /><span style="color: #993300" id="e_db_host"></span></td><td><input onkeyup="verify();" name="db_host" size="30" type="text" /></td><td><img id="s_db_host" alt="Good/bad icon" src="images/bad.gif" /></td></tr>

  1260           <td colspan="3" style="text-align: center">

  1260         <tr><td><b>Database name</b><br />The name of the actual database. If you don't already have a database, you can create one here, if you have the username and password of a MySQL user with administrative rights.<br /><span style="color: #993300" id="e_db_name"></span></td><td><input onkeyup="verify();" name="db_name" size="30" type="text" /></td><td><img id="s_db_name" alt="Good/bad icon" src="images/bad.gif" /></td></tr>

  1261             <h3><?php echo $lang->get('database_table_title'); ?></h3>

  1261         <tr><td rowspan="2"><b>Database login</b><br />These fields should be the username and password of a user with "select", "insert", "update", "delete", "create table", and "replace" privileges for your database.<br /><span style="color: #993300" id="e_db_auth"></span></td><td><input onkeyup="verify();" name="db_user" size="30" type="text" /></td><td rowspan="2"><img id="s_db_auth" alt="Good/bad icon" src="images/bad.gif" /></td></tr>

  1262           </td>

  1262         <tr><td><input name="db_pass" size="30" type="password" /></td></tr>

  1263         </tr>

  1263         <tr><td colspan="3" style="text-align: center"><h3>Optional information</h3></td></tr>

  1264         <tr>

  1264         <tr><td><b>Table prefix</b><br />The value that you enter here will be added to the beginning of the name of each Enano table. You may use lowercase letters (a-z), numbers (0-9), and underscores (_).</td><td><input onkeyup="verify();" name="table_prefix" size="30" type="text" /></td><td><img id="s_table_prefix" alt="Good/bad icon" src="images/good.gif" /></td></tr>

  1265           <td>

  1265         <tr><td rowspan="2"><b>Database administrative login</b><br />If the MySQL database or username that you entered above does not exist yet, you can create them here, assuming that you have the login information for an administrative user (such as root). Leave these fields blank unless you need to use them.<br /><span style="color: #993300" id="e_db_root"></span></td><td><input onkeyup="verify();" name="db_root_user" size="30" type="text" /></td><td rowspan="2"><img id="s_db_root" alt="Good/bad icon" src="images/good.gif" /></td></tr>

  1266             <b><?php echo $lang->get('database_field_hostname_title'); ?></b>

  1266         <tr><td><input onkeyup="verify();" name="db_root_pass" size="30" type="password" /></td></tr>

  1267             <br /><?php echo $lang->get('database_field_hostname_body'); ?>

  1267         <tr><td><b>MySQL version</b></td><td id="e_mysql_version">MySQL version information will be checked when you click "Test Connection".</td><td><img id="s_mysql_version" alt="Good/bad icon" src="images/unknown.gif" /></td></tr>

  1268             <br /><span style="color: #993300" id="e_db_host"></span>

  1268         <tr><td><b>Delete existing tables?</b><br />If this option is checked, all the tables that will be used by Enano will be dropped (deleted) before the schema is executed. Do NOT use this option unless specifically instructed to.</td><td><input type="checkbox" name="drop_tables" id="dtcheck" />  <label for="dtcheck">Drop existing tables</label></td></tr>

  1269           </td>

  1269         <tr><td colspan="3" style="text-align: center"><input type="button" value="Test connection" onclick="ajaxTestConnection();" /></td></tr>

  1270           <td>

  1271             <input onkeyup="verify();" name="db_host" size="30" type="text" />

  1272           </td>

  1273           <td>

  1274             <img id="s_db_host" alt="Good/bad icon" src="images/bad.gif" />

  1275           </td>

  1276         </tr>

  1277         <tr>

  1278           <td>

  1279             <b><?php echo $lang->get('database_field_dbname_title'); ?></b><br />

  1280             <?php echo $lang->get('database_field_dbname_body'); ?><br />

  1281             <span style="color: #993300" id="e_db_name"></span>

  1282           </td>

  1283           <td>

  1284             <input onkeyup="verify();" name="db_name" size="30" type="text" />

  1285           </td>

  1286           <td>

  1287             <img id="s_db_name" alt="Good/bad icon" src="images/bad.gif" />

  1288           </td>

  1289         </tr>

  1290         <tr>

  1291           <td rowspan="2">

  1292             <b><?php echo $lang->get('database_field_dbauth_title'); ?></b><br />

  1293             <?php echo $lang->get('database_field_dbauth_body'); ?><br />

  1294             <span style="color: #993300" id="e_db_auth"></span>

  1295           </td>

  1296           <td>

  1297             <input onkeyup="verify();" name="db_user" size="30" type="text" />

  1298           </td>

  1299           <td rowspan="2">

  1300             <img id="s_db_auth" alt="Good/bad icon" src="images/bad.gif" />

  1301           </td>

  1302         </tr>

  1303         <tr>

  1304           <td>

  1305             <input name="db_pass" size="30" type="password" />

  1306           </td>

  1307         </tr>

  1308         <tr>

  1309           <td colspan="3" style="text-align: center">

  1310             <h3><?php echo $lang->get('database_heading_optionalinfo'); ?></h3>

  1311           </td>

  1312         </tr>

  1313         <tr>

  1314           <td>

  1315             <b><?php echo $lang->get('database_field_tableprefix_title'); ?></b><br />

  1316             <?php echo $lang->get('database_field_tableprefix_body'); ?>

  1317           </td>

  1318           <td>

  1319             <input onkeyup="verify();" name="table_prefix" size="30" type="text" />

  1320           </td>

  1321           <td>

  1322             <img id="s_table_prefix" alt="Good/bad icon" src="images/good.gif" />

  1323           </td>

  1324         </tr>

  1325         <tr>

  1326           <td rowspan="2">

  1327             <b><?php echo $lang->get('database_field_rootauth_title'); ?></b><br />

  1328             <?php echo $lang->get('database_field_rootauth_body'); ?><br />

  1329             <span style="color: #993300" id="e_db_root"></span>

  1330           </td>

  1331           <td>

  1332             <input onkeyup="verify();" name="db_root_user" size="30" type="text" />

  1333           </td>

  1334           <td rowspan="2">

  1335             <img id="s_db_root" alt="Good/bad icon" src="images/good.gif" />

  1336           </td>

  1337         </tr>

  1338         <tr>

  1339           <td>

  1340             <input onkeyup="verify();" name="db_root_pass" size="30" type="password" />

  1341           </td>

  1342         </tr>

  1343         <tr>

  1344           <td>

  1345             <b><?php echo $lang->get('database_field_mysqlversion_title'); ?></b>

  1346           </td>

  1347           <td id="e_mysql_version">

  1348             <?php echo $lang->get('database_field_mysqlversion_blurb_willbechecked'); ?>

  1349           </td>

  1350           <td>

  1351             <img id="s_mysql_version" alt="Good/bad icon" src="images/unknown.gif" />

  1352           </td>

  1353         </tr>

  1354         <tr>

  1355           <td>

  1356             <b><?php echo $lang->get('database_field_droptables_title'); ?></b><br />

  1357             <?php echo $lang->get('database_field_droptables_body'); ?>

  1358           </td>

  1359           <td>

  1360             <input type="checkbox" name="drop_tables" id="dtcheck" />  <label for="dtcheck"><?php echo $lang->get('database_field_droptables_lbl'); ?></label>

  1361           </td>

  1362         </tr>

  1363         <tr>

  1364           <td colspan="3" style="text-align: center">

  1365             <input type="button" value="<?php echo $lang->get('database_btn_testconnection'); ?>" onclick="ajaxTestConnection();" />

  1366           </td>

  1367         </tr>

  1272        <table border="0">

  1370         <table border="0">

  1273        <tr>

  1371           <tr>

  1274        <td><input type="submit" value="Continue" onclick="return verify();" name="_cont" /></td><td><p><span style="font-weight: bold;"><?php echo $lang->get('meta_lbl_before_continue'); ?></span><br />&bull; Check your MySQL connection using the "Test Connection" button.<br />&bull; Be aware that your database information will be transmitted unencrypted several times.</p></td>

  1372             <td>

  1275        </tr>

  1373               <input type="submit" value="<?php echo $lang->get('meta_btn_continue'); ?>" onclick="return verify();" name="_cont" />

  1276        </table>

  1374             </td>

  1277      </div>

  1375             <td>

  1376               <p>

  1377                 <span style="font-weight: bold;"><?php echo $lang->get('meta_lbl_before_continue'); ?></span><br />

  1378                 &bull; <?php echo $lang->get('database_objective_test'); ?><br />

  1379                 &bull; <?php echo $lang->get('database_objective_uncrypt'); ?>

  1380               </p>

  1381             </td>

  1382           </tr>

  1383         </table>

  1384       </div>

  1282     if(!isset($_POST['_cont'])) {

  1389     if ( !isset($_POST['_cont']) )

  1390     {