{if $formSubmitted}
<div class="resultMessage">
{if $submitResult.mode == 'optimize'}
    {foreach from=$submitResult.message item=table}
        {"Optimize '%s': %s"|i18n:$table.Table:$table.Msg_text}<br>
    {/foreach}
{elseif $submitResult.mode == 'repair'}
    {foreach from=$submitResult.message item=table}
        {"Repair '%s': %s"|i18n:$table.Table:$table.Msg_text}<br>
    {/foreach}
{elseif $submitResult.mode == 'backup_textbox'}
    {"Backup Complete"|i18n}
{elseif $submitResult.mode == 'clean'}
    {"Database has been cleaned."|i18n}
{/if}
</div>
{/if}
<h1 class="header">{"Database Utilities"|i18n}</h1>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr valign="top">
    <td width="45%">
    <fieldset><legend class="sheader">{"Database Repair/Optimization"|i18n}</legend><br>
        <table width="100%" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="50%"><div align="center">
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <form action="main.php" method="post" name="" id="">
            <input name="mode" type="hidden" value="optimize">
            <input type="submit" value="{"Optimize Database"|i18n}">
            <input name="action" type="hidden" value="settings_database">
            </form>
      {/if}
              </div></td>
            <td width="50%"><div align="center">
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <form action="main.php" method="post" name="" id="">
            <input name="mode" type="hidden" value="repair">
            <input type="submit" value="{"Repair Database"|i18n}">
            <input name="action" type="hidden" value="settings_database">
            </form>
      {/if}

              </div></td>
          </tr>
        </table>
      <br>
      </fieldset>
      <br>
        <fieldset ><legend class="sheader">{"Database Backup"|i18n}</legend>
        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td width="50%"><FORM ACTION="main.php" METHOD=POST>
              <div align="center">
                <p>
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
                  <INPUT TYPE="submit" VALUE="{"Save to File"|i18n}" name="backup2">
                  <input name="mode" type="hidden" id="mode"  value="backup_file">
                  <input name="action" type="hidden" id="action" value="settings_database">
      {/if}
                </p>
              </div>
            </FORM></td>
            <td width="50%"><FORM ACTION="main.php" METHOD=POST>
              <div align="center">
                <p>
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
                  <INPUT TYPE="submit" VALUE="{"Show in Textbox"|i18n}" name="backup">
                  <input name="mode" type="hidden" id="mode"  value="backup_textbox">
                  <input name="action" type="hidden" id="action" value="settings_database">
      {/if}
                </p>
              </div>
            </FORM></td>
          </tr>
        </table>


{if $formSubmitted && $submitResult.mode == 'backup_textbox'}
<FORM name="database_backup_results">
      <textarea style="width:100%; " rows=10 wrap="off" name="db_contents">Contents are loading, one moment please...</textarea>
</form>
{/if}
</fieldset>
            </td>
    <td width="10%">&nbsp;</td>
    <td width="45%">

    <fieldset style="width:80%"><legend class="sheader">{"Database Cleaning"|i18n}</legend>

<script>
function are_you_sure () {ldelim}
    return confirm('{"THIS CAN NOT BE UNDONE!\n\nAre you sure that you would like to run this utility?\n\nThis will delete data without recovery options."|i18n|escape:"javascript"}');
{rdelim}
</script>

    <FORM ACTION="main.php" METHOD=POST onsubmit="return are_you_sure()">
      <div style="font-size:12px; color: red;">
        <div align="left">
          <p>{"Warning - Do not run any of these utilities unless you are sure you know what they will do. All of these utilities remove / delete portions of your database and the information is not recoverable."|i18n}</p>
          <hr>
          <p>
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <INPUT TYPE="submit" VALUE="{"Delete Stats"|i18n}" style="width:100%">
                <input name="mode" type="hidden"  value="clean">
                <input name="cleaning_mode" type="hidden"  value="stats">
              <input name="action" type="hidden" value="settings_database">
      {/if}
          </p>
        </div>
      </div>

          <div align="left">{"This will delete all statistics for all lists. Including read/open, bounce, and link tracking stats."|i18n} <br>
            <hr>
         </div>
    </FORM>
            <FORM ACTION="main.php" METHOD=POST onsubmit="return are_you_sure()">

              <p align="left">
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <INPUT TYPE="submit" VALUE="{"Delete Messages"|i18n}"  style="width:100%">
                <input name="mode" type="hidden"  value="clean">
                <input name="cleaning_mode" type="hidden"  value="messages">
            <input name="action" type="hidden" value="settings_database">
      {/if}
              </p>
              <div align="left">{"This will delete all messages for all lists. Which includes the messages and stats."|i18n} <br>
                <hr>
              </div>
            </FORM>
            <FORM ACTION="main.php" METHOD=POST onsubmit="return are_you_sure()">

              <p align="left">
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <INPUT TYPE="submit" VALUE="{"Delete Subscribers"|i18n}" style="width:100%">
                <input name="mode" type="hidden"  value="clean">
                <input name="cleaning_mode" type="hidden"  value="subscribers">
            <input name="action" type="hidden" value="settings_database">
      {/if}
              </p>
              <div align="left">{"This will delete all subscribers from all lists. Including subscriber fields data."|i18n} <br>
                <hr>
              </div>
            </FORM>
            <FORM ACTION="main.php" METHOD=POST onsubmit="return are_you_sure()">

              <p align="left">
      {if $admin.brand_demo}
        {"Disabled in demo"|i18n}
      {else}
            <INPUT TYPE="submit" VALUE="{"Delete Subscriber Fields"|i18n}" style="width:100%">
                <input name="mode" type="hidden"  value="clean">
                <input name="cleaning_mode" type="hidden"  value="subscriber_fields">
            <input name="action" type="hidden" value="settings_database">
      {/if}
              </p>
              <div align="left">{"This will delete all of the subscriber fields and subscriber fields data."|i18n} </div>
            </FORM>
      </fieldset>
    </td>
  </tr>

</table>

{if $formSubmitted && $submitResult.mode == 'backup_textbox'}
<FORM name="database_backup_contents">
<textarea style="visibility: hidden;" name="db_contents" >{$submitResult.db_contents}</textarea>
</form>
<script language="JavaScript">
document.database_backup_results.db_contents.value = document.database_backup_contents.db_contents.value;
</script>
{/if}