📄 collect.sql
字号:
insert into [nt_Collect_Site] ([SiteName],[objURL],[Encode],[OtherPara],[MaxNum],[ListSetting],[LinkSetting],[OtherType],[OtherPageSetting],[StartPageNum],[EndPageNum],[PagebodySetting],[PageTitleSetting],[OtherNewsType],[OtherNewsPageSetting],[AuthorSetting],[SourceSetting],[AddDateSetting],[IsAutoCollect],[CollectDate],[TextTF],[SaveRemotePic],[Audit],[IsStyle],[IsDIV],[IsA],[IsClass],[IsFont],[IsSpan],[IsObject],[IsIFrame],[IsScript],[IsReverse],[IsAutoPicNews],[HandSetAuthor],[HandSetSource],[HandSetAddDate],[Folder],[ClassID],[ChannelID]) values ('中保网','http://www.sinoins.com/news/101214/list.html','UTF-8',null,0,'<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><style type="text/css"><!--body,td,th { font-size: 12px;}body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px;}--></style> <link href="http://images.sinoins.com/templates/101184/shebao/css.css" type="text/css" rel="stylesheet" /> <title>中保网·中国保险报：中国最大、最权威的保险门户网站</title></head> <body> <table cellspacing="0" cellpadding="0" width="780" align="center" border="0"> <tbody> <tr> <td><iframe marginwidth="0" marginheight="0" src="http://www.sinoins.com/top/index.html" frameborder="0" width="780" scrolling="no" height="210"></iframe></td> </tr> </tbody> </table> <table cellspacing="0" cellpadding="0" width="780" align="center" border="0"> <tbody> <tr> <td height="8"></td> </tr> </tbody> </table> <table cellspacing="0" cellpadding="0" width="780" align="center" border="0"> <tbody> <tr> <td valign="top" width="589" height="800"> <table cellspacing="1" cellpadding="0" width="100%" bgcolor="#c7c7c7" border="0"> <tbody> <tr> <td valign="top" bgcolor="#f8f8f8" height="880"> <table cellspacing="0" cellpadding="0" width="100%" border="0"> <tbody> <tr> <td width="4%" height="30"> </td> <td width="96%">您所在的位置：<a class="nav" href="http://www.sinoins.com/" target="_blank">中保网</a>>><a class="nav" href="http://www.sinoins.com/news/" target="_blank">新闻中心</a>>><a class="nav" href="http://www.sinoins.com/news/101214/" target="_blank">行业动态</a></td> </tr> </tbody> </table> <table cellspacing="0" cellpadding="0" width="100%" border="0"> <tbody> <tr> <td align="center" height="20"> </td> </tr> </tbody> </table> <table width="93%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td valign="top" class="wz12">[列表内容]','<a href="[列表URL]" title="[变量]" target="_blank" class="main3">[变量]</a>',0,null,null,null,'<table cellspacing="0" cellpadding="0" width="564" align="center" border="0"> <tbody> <tr> <td width="564" class="wz12"><font id="zoom">[内容]</font></td> </tr> <tr> <td align="right" class="wz12"></td> </tr> <tr> <td>','<tr> <td align="center" class="wz11">[标题]</td> </tr>',0,null,'[作者]','[来源]','[加入时间]',0,0,0,1,0,0,0,0,0,0,0,1,1,1,0,1,null,null,null,null,'062958357197','0');
insert into [nt_Collect_Site] ([SiteName],[objURL],[Encode],[OtherPara],[MaxNum],[ListSetting],[LinkSetting],[OtherType],[OtherPageSetting],[StartPageNum],[EndPageNum],[PagebodySetting],[PageTitleSetting],[OtherNewsType],[OtherNewsPageSetting],[AuthorSetting],[SourceSetting],[AddDateSetting],[IsAutoCollect],[CollectDate],[TextTF],[SaveRemotePic],[Audit],[IsStyle],[IsDIV],[IsA],[IsClass],[IsFont],[IsSpan],[IsObject],[IsIFrame],[IsScript],[IsReverse],[IsAutoPicNews],[HandSetAuthor],[HandSetSource],[HandSetAddDate],[Folder],[ClassID],[ChannelID]) values ('四川新闻网——列表分页','http://china.newssc.org/system/more/6130000/0001/6130000_00000157.shtml','GB2312',null,0,'<table border="0" cellspacing="0" width="375" id="table2092" cellpadding="2"> <tr> <td width="377"><!--function latest5($!cur_dir!$,1,27,false,<font color="#84001B" size="2">·</font>,dd日HH:mm,class="2",<font style="font-size: 7pt; color:#808080; font:Arial">) parse begin--><table width=100% >[列表内容]','<a href="[列表URL]" target="_blank" class="2">[变量]',1,'<a href=[其他页面]>下一页</a>',null,null,'<!--function content() parse begin-->[内容]<!--function: content() parse end 0ms cost! -->','<td class="8" height="33"> <p align="center">[标题]</td> </tr>',0,null,'[作者]','[来源]','[加入时间]',0,0,0,1,0,0,0,0,0,0,0,1,1,1,0,1,null,null,null,null,'662359947592','0');
insert into [nt_Collect_SiteFolder] ([SiteFolder],[SiteFolderDetail],[ChannelID]) values ('娱乐采集','采集娱乐新闻','0');⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -