<?xml version="1.0"?>
<TaskInfo Version="1.2">
  <SpiderTaskName>新浪科技</SpiderTaskName>
  <RuleName>新浪科技</RuleName>
  <RuleType>新闻</RuleType>
  <FileName>E:\000\混淆处理\发布版本\免费版\TaskData\新浪科技.xml</FileName>
  <Description>选择您使用的数据库类型，并修改你的数据库配置：包括数据库地址，用户名，密码，数据库名称
如果使用FTP上传功能需一并修改FTP的配置信息。
执行动作说明参看各自的说明信息。
简单说明：１，上传本地图像文件到服务器上，并删除本地图像文件。２，上传本地数据到网站数据库指定表中。３，删除本地数据。</Description>
  <DbAccess>False</DbAccess>
  <DbSqlServer>True</DbSqlServer>
  <DbMySql>False</DbMySql>
  <AccessFile>
  </AccessFile>
  <AccessUser>
  </AccessUser>
  <AccessPass>
  </AccessPass>
  <MsSqlAddress>127.0.0.1</MsSqlAddress>
  <MsSqlPort>1433</MsSqlPort>
  <WindowsCheck>False</WindowsCheck>
  <MsSqlCheck>True</MsSqlCheck>
  <MsSqlUser>sa</MsSqlUser>
  <MsSqlPass>password</MsSqlPass>
  <MsSqlDbName>mynews</MsSqlDbName>
  <MySqlAddress>127.0.0.1</MySqlAddress>
  <MySqlPort>3306</MySqlPort>
  <MySqlUser>
  </MySqlUser>
  <MySqlPass>
  </MySqlPass>
  <MySqlDbCode>
  </MySqlDbCode>
  <MySqlDbName>
  </MySqlDbName>
  <MySqlVer3>False</MySqlVer3>
  <MySqlVer4>False</MySqlVer4>
  <MySqlVer5>True</MySqlVer5>
  <PlanOption>
    <TimingEnabled>False</TimingEnabled>
    <TimingType>每当</TimingType>
    <TimingHours>0</TimingHours>
    <TimingMinutes>0</TimingMinutes>
  </PlanOption>
  <ActionInfos>
    <ActionInfo id="0">
      <ActionName>上传图像文件</ActionName>
      <ActionType>FTP上传</ActionType>
      <SelectCon>本地数据库</SelectCon>
      <ActionSQL>delete from 新浪新闻内容</ActionSQL>
      <UsProcedure>False</UsProcedure>
      <UseKey>False</UseKey>
      <WebTable>
      </WebTable>
      <LocalTable>
      </LocalTable>
      <TableOrder>False</TableOrder>
      <FtpServer>127.0.0.1</FtpServer>
      <FtpPort>21</FtpPort>
      <FtpUser>username</FtpUser>
      <FtpPass>password</FtpPass>
      <FtpPath>\userfiles\news\images\</FtpPath>
      <LocalPath>2=任务根目录+图片文件夹</LocalPath>
      <DelLocalFiles>True</DelLocalFiles>
      <InfoDetail>使用内置ＦＴＰ工具将下载的图像文件上传到您的服务器相应目录
上传结束后删除本地下载图像文件

根据您的实际配置填写ＦＴＰ地址，端口，用户名，密码，上传目录（ FTP保存路径）等信息</InfoDetail>
      <FieldInfos />
    </ActionInfo>
    <ActionInfo id="1">
      <ActionName>上传数据表</ActionName>
      <ActionType>发布数据</ActionType>
      <SelectCon>本地数据库</SelectCon>
      <ActionSQL>
      </ActionSQL>
      <UsProcedure>False</UsProcedure>
      <UseKey>False</UseKey>
      <WebTable>m_newspaper</WebTable>
      <LocalTable>新浪新闻内容</LocalTable>
      <TableOrder>False</TableOrder>
      <FtpServer>127.0.0.1</FtpServer>
      <FtpPort>21</FtpPort>
      <FtpUser>
      </FtpUser>
      <FtpPass>
      </FtpPass>
      <FtpPath>\</FtpPath>
      <LocalPath>2=任务根目录+图片文件夹</LocalPath>
      <DelLocalFiles>False</DelLocalFiles>
      <InfoDetail>需要通过标签定义，将网站数据库表的字段与本地表的字段一一对应起来。</InfoDetail>
      <FieldInfos>
        <FieldInfo id="0">
          <WebField>class_id</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>4104</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="1">
          <WebField>sub_id</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="2">
          <WebField>title</WebField>
          <FieldOpt>本地字段</FieldOpt>
          <LocalField>标题</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="3">
          <WebField>content</WebField>
          <FieldOpt>本地字段</FieldOpt>
          <LocalField>内容</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="4">
          <WebField>author</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>管理员</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="5">
          <WebField>scoure</WebField>
          <FieldOpt>本地字段</FieldOpt>
          <LocalField>出处</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="6">
          <WebField>department_id</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>办公室</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="7">
          <WebField>img_url</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>无</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="8">
          <WebField>all_url</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>无</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="9">
          <WebField>is_img</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="10">
          <WebField>is_top</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="11">
          <WebField>user_id</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>admin</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="12">
          <WebField>hit_nums</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="13">
          <WebField>is_html</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="14">
          <WebField>is_secret</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>0</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="15">
          <WebField>add_ip</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>127.0.0.1</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="16">
          <WebField>add_date</WebField>
          <FieldOpt>现在时间</FieldOpt>
          <LocalField>今天时间</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="17">
          <WebField>edit_ip</WebField>
          <FieldOpt>固定字符串</FieldOpt>
          <LocalField>127.0.0.1</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="18">
          <WebField>edit_date</WebField>
          <FieldOpt>现在时间</FieldOpt>
          <LocalField>今天时间</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
        <FieldInfo id="19">
          <WebField>auditing_sign</WebField>
          <FieldOpt>固定数字</FieldOpt>
          <LocalField>1</LocalField>
          <CheckKey>False</CheckKey>
        </FieldInfo>
      </FieldInfos>
    </ActionInfo>
    <ActionInfo id="2">
      <ActionName>删除本地数据</ActionName>
      <ActionType>执行SQL</ActionType>
      <SelectCon>本地数据库</SelectCon>
      <ActionSQL>delete from 新浪新闻内容</ActionSQL>
      <UsProcedure>False</UsProcedure>
      <UseKey>False</UseKey>
      <WebTable>
      </WebTable>
      <LocalTable>
      </LocalTable>
      <TableOrder>False</TableOrder>
      <FtpServer>127.0.0.1</FtpServer>
      <FtpPort>21</FtpPort>
      <FtpUser>
      </FtpUser>
      <FtpPass>
      </FtpPass>
      <FtpPath>\</FtpPath>
      <LocalPath>
      </LocalPath>
      <DelLocalFiles>False</DelLocalFiles>
      <InfoDetail>发布结束后删除本地下载表中的数据。</InfoDetail>
      <FieldInfos />
    </ActionInfo>
  </ActionInfos>
</TaskInfo>