<?php include admintpl('header'); ?>

<?php echo $menu; ?>

<form id="formgetmails" name="formgetmails" method="post" action="?mod=<?php echo $mod; ?>&file=mail&action=config&submit=1">

  <table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="tableborder">
    <tr>
      <th colspan="2">獲取列表</th>
    </tr>
    <tr>
      <td class="tablerowhighlight" colspan="2" align="center"><b>外部數(shù)據(jù)提取參數(shù)配置</b></td>
    </tr>
    <tr>
      <td width="30%" class="tablerow"><b>數(shù)據(jù)庫(kù)來(lái)源</b><font color="red">*</font></td>
      <td width="70%"  class="tablerow">
	  <input type="radio" name="newdata[dbfrom]" value="1" <?php if(!$data['dbfrom'] || $data['dbfrom']==1) echo 'checked="checked"'; ?> onclick="javascript:db.style.display='none'" />當(dāng)前系統(tǒng)數(shù)據(jù)庫(kù)
	  <input type="radio" name="newdata[dbfrom]" value="2" <?php if($data['dbfrom']==2) echo 'checked="checked"'; ?> onclick="javascript:db.style.display='block'" />其他數(shù)據(jù)庫(kù)	  </td>
    </tr>
    <tbody style="display:<?php if(!$data['dbfrom'] || $data['dbfrom']==1){ ?>none<?php } ?>" id="db">
      <tr>
        <td class="tablerow"><b>數(shù)據(jù)庫(kù)系統(tǒng)類型</b><font color="red">*</font></td>
        <td  class="tablerow">
		<input type="radio" name="newdata[database]" value="mysql" <?php if(!$data['database'] || $data['database']=='mysql') echo 'checked="checked"'; ?> />MYSQL
		<input type="radio" name="newdata[database]" value="mssql" <?php if($data['database']=='mssql') echo 'checked="checked"';?> />MSSQL		</td>
      </tr>
      <tr>
        <td class="tablerow"><b>數(shù)據(jù)庫(kù)主機(jī)地址</b><font color="red">*</font><br />
          你的數(shù)據(jù)庫(kù)所在的主機(jī)地址，一般為localhost</td>
        <td  class="tablerow">
		<input name="newdata[dbhost]" type="text" size="20" value="<?php if($data['dbhost']) echo $data['dbhost']; else echo 'localhost'; ?>" /></td>
      </tr>
      <tr>
        <td class="tablerow"><b>數(shù)據(jù)庫(kù)用戶名</b><font color="red">*</font><br />
          MYSQL數(shù)據(jù)庫(kù)帳號(hào)</td>
        <td class="tablerow">
		<input name="newdata[dbuser]" type="text" size="20" value="<?php echo $data['dbuser']; ?>" />		</td>
      </tr>
      <tr>
        <td class="tablerow"><b>數(shù)據(jù)庫(kù)密碼</b><font color="red">*</font><br />
          MYSQL數(shù)據(jù)庫(kù)密碼</td>
        <td class="tablerow">
		<input name="newdata[dbpw]" type="password" size="20" value="<?php echo $data['dbpw']; ?>" />		</td>
      </tr>
      <tr>
        <td class="tablerow"><b>數(shù)據(jù)庫(kù)名稱</b><font color="red">*</font><br />
          MYSQL數(shù)據(jù)庫(kù)名稱</td>
        <td class="tablerow">
		<input name="newdata[dbname]" type="text" size="20" value="<?php echo $data['dbname']; ?>" />		</td>
      </tr>
    </tbody>
    <tr>
      <td class="tablerow"><b>數(shù)據(jù)表</b><font color="red">*</font><br />
        源數(shù)據(jù)表名稱</td>
      <td  class="tablerow">
	  <input name="newdata[table]" type="text" size="30" value="<?php echo $data['table']; ?>" /></td>
    </tr>
    <tr>
      <td class="tablerow"><b>電子郵件字段</b><font color="red">*</font><br />
        源數(shù)據(jù)表中對(duì)應(yīng)于電子郵件的字段</td>
      <td  class="tablerow">
	  <input name="newdata[field]" type="text" id="newdata[field]" value="<?php echo $data['field']; ?>" size="20" /></td>
    </tr>
	<tr>
	  <td class="tablerow"><strong>獲取條件（SQL語(yǔ)句）</strong><br />
      可以不填寫(xiě)</td>
	  <td class="tablerow"><input name="newdata[condition]" type="text" id="newdata[condition]" value="<?php echo $data['condition']; ?>" size="40" /></td>
    </tr>
	<tr>
      <td class="tablerow"><strong>保存郵件列表的文件名</strong><font color="red">*</font><br />
      只能是英文，字母，下劃線組成</td>
      <td class="tablerow">
	  <input name="newdata[file]" type="text" value="<?php if($data['file']) echo $data['file']; else echo date('Ymd'); ?>" size="20" />
	  .txt</td>
	</tr>
	<tr>
      <td class="tablerowhighlight" colspan="2" align="center"><b>數(shù)據(jù)提取導(dǎo)入執(zhí)行設(shè)置</b></td>
    </tr>
	
	<tr>
      <td class="tablerow"><b>每次提取并導(dǎo)入數(shù)據(jù)條數(shù)</b><br />
        如果數(shù)據(jù)較多可分步提取導(dǎo)入</td>
	  <td class="tablerow">
	  <input name="newdata[number]" type="text" size="5" value="<?php if($data['number']) echo $data['number']; else echo 1000; ?>" />條
	  </td>
    </tr>
	<tr>
      <td class="tablerow"><b>php腳本執(zhí)行超時(shí)時(shí)限</b><br />
        當(dāng)數(shù)據(jù)較多時(shí)程序執(zhí)行時(shí)間會(huì)較長(zhǎng)</td>
	  <td class="tablerow">
	  <input name="newdata[timelimit]" type="text" size="5" value="<?php if($data['timelimit']) echo $data['timelimit']; else echo 60; ?>" />秒
	  </td>
    </tr>
	<tr>
      <td class="tablerow"></td>
      <td class="tablerow">
	  <input name="submit" type="submit" id="submit" value=" 獲取并保存 " />
	  <input name="reset" type="reset" id="reset" value=" 重新填寫(xiě) " /> 
	  <input name="importtype" type="hidden" value="database" />	  </td>
    </tr>
  </table>
</form>

</body>
</html>