INSERT INTO `dede_addonarticle` VALUES('1','2','<div class=\"workInfor\" style=\"padding: 5px 50px; line-height: 24px; font-size: 14px; color: rgb(0, 0, 0); font-family: Verdana, Helvetica, sans-serif; \">\r\n	小清新、绿茶、空气、simple、密集恐惧症勿入。</div>\r\n<div class=\"workShow\" style=\"padding: 20px 0px 30px; color: rgb(0, 0, 0); font-family: Verdana, Helvetica, sans-serif; line-height: 19px; \">\r\n	<ul style=\"margin: 0px; padding-right: 0px; padding-left: 0px; list-style: none; \">\r\n		<li style=\"margin: 20px auto 0px; padding: 0px; text-align: center; width: 900px; overflow: hidden; \">\r\n			<div class=\"wsContent\" style=\"display: inline-block; margin: 0px auto; \">\r\n				<img alt=\"查看《PrincessofChina》原图，原图尺寸：720x1280\" class=\"mb10\" id=\"_list_img_0\" src=\"/uploads/allimg/130509/10230V239-0.jpg\" style=\"border: 0px; margin-bottom: 10px; \" /></div>\r\n			<div class=\"wsDes\" style=\"padding: 0px 0px 10px; line-height: 22px; \">\r\n				<p class=\"f14\" style=\"margin: 0px; padding: 0px; font-size: 14px; \">\r\n					&nbsp;</p>\r\n			</div>\r\n		</li>\r\n		<li style=\"margin: 20px auto 0px; padding: 0px; text-align: center; width: 900px; overflow: hidden; \">\r\n			<div class=\"wsContent\" style=\"display: inline-block; margin: 0px auto; \">\r\n				<img alt=\"查看《PrincessofChina》原图，原图尺寸：720x1280\" class=\"mb10\" id=\"_list_img_1\" src=\"/uploads/allimg/130509/10230QD2-1.jpg\" style=\"border: 0px; margin-bottom: 10px; \" /></div>\r\n			<div class=\"wsDes\" style=\"padding: 0px 0px 10px; line-height: 22px; \">\r\n				<p class=\"f14\" style=\"margin: 0px; padding: 0px; font-size: 14px; \">\r\n					&nbsp;</p>\r\n			</div>\r\n		</li>\r\n		<li style=\"margin: 20px auto 0px; padding: 0px; text-align: center; width: 900px; overflow: hidden; \">\r\n			<div class=\"wsContent\" style=\"display: inline-block; margin: 0px auto; \">\r\n				<img alt=\"查看《PrincessofChina》原图，原图尺寸：720x1280\" class=\"mb10\" id=\"_list_img_2\" src=\"/uploads/allimg/130509/10230TU1-2.jpg\" style=\"border: 0px; margin-bottom: 10px; \" /></div>\r\n			<div class=\"wsDes\" style=\"padding: 0px 0px 10px; line-height: 22px; \">\r\n				<p class=\"f14\" style=\"margin: 0px; padding: 0px; font-size: 14px; \">\r\n					&nbsp;</p>\r\n			</div>\r\n		</li>\r\n	</ul>\r\n	<div class=\"center pt30\" style=\"text-align: center; padding-top: 30px; \">\r\n		&nbsp;</div>\r\n</div>\r\n<br />\r\n','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('3','2','','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('4','2','网易即将推出的一款FPS类游戏，目前还在研发阶段，希望给玩家带来更好的游戏感，征集玩家对玩法的偏好，因地制材地调整研发方向。<br />\r\n<br />\r\n这个项目总体来说做得比较顺利，基本上是一稿过，沟通顺畅和谐，美术资源给力，各方配合到位，剩下来看下你们对这游戏的反映，还有对这款即将上市的FPS游戏风格觉得怎样。不要吝啬你的看法，欢迎评论。','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('6','2','&nbsp;源码库本地测试.www.aspku.com','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('7','2','I&nbsp;was&nbsp;recently&nbsp;asked&nbsp;to&nbsp;completely&nbsp;redesign&nbsp;the&nbsp;menu&nbsp;suite&nbsp;for&nbsp;Italian&nbsp;restaurant&nbsp;chain&nbsp;Zizzi&nbsp;Ristorante.<br />\r\n&nbsp;<br />\r\nThe&nbsp;new&nbsp;menu&nbsp;symbolised&nbsp;a&nbsp;change&nbsp;in&nbsp;approach:&nbsp;having&nbsp;greatly&nbsp;reduced&nbsp;the&nbsp;dish&nbsp;count&nbsp;from&nbsp;previous&nbsp;menus,&nbsp;Zizzi&nbsp;wanted&nbsp;someth\r\n<div class=\"wsContent\">\r\n	<img src=\"http://image.zcool.com.cn/img3/28/5/m_1368694014529.jpg\" /></div>\r\ning&nbsp;that&nbsp;would&nbsp;be&nbsp;easier&nbsp;to&nbsp;negotiate,&nbsp;whilst&nbsp;consolidating&nbsp;wine,&nbsp;dessert&nbsp;and&nbsp;main&nbsp;menus&nbsp;into&nbsp;one&nbsp;document.&nbsp;Bespoke&nbsp;hand&nbsp;lettering&nbsp;helped&nbsp;to&nbsp;give&nbsp;the&nbsp;menu&nbsp;an&nbsp;&#39;Individually&nbsp;Italian&#39;&nbsp;feel,&nbsp;in&nbsp;line&nbsp;with&nbsp;the&nbsp;new&nbsp;Zizzi&nbsp;strap&nbsp;line.','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('8','2','感受，思考和改变<br />\r\n&nbsp;<br />\r\n更改公司是一家专业的顾问公司，演变而来质的增长，其变更管理服务。以前被称为&ldquo;频道切换&rdquo;，更改公司聘请我们创建一个新的品牌，一个清晰的定位和品牌架构产品。此外，我们还设计了自己的办事处，服务和通信的品牌指导方针的经验和实施。<br />\r\n&nbsp;<br />\r\n我们设计未来在组织中做出积极的改变。\r\n<div class=\"wsContent\">\r\n	<img src=\"http://image.zcool.com.cn/img3/21/32/m_1368691701711.jpg\" /></div>\r\n<p class=\"c999 mt5\">\r\n	原图尺寸：600x600</p>\r\n','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('9','2','<div class=\"workInfor\">\r\n	前期选稿，图标还没设计，呵呵</div>\r\n<div class=\"wsContent\">\r\n	<img class=\"mb10\" id=\"_list_img_0\" src=\"http://image.zcool.com.cn/img3/30/60/m_1368696234947.jpg\" title=\"yonina2c对此图片选择了版权保护，您无法查看原图。\" /></div>\r\n','','','127.0.0.1');
INSERT INTO `dede_addonarticle` VALUES('17','13','<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	我们使用DedeCMS搭建网站的时候，文章页如果调用相关文章是对优化有好处的，昨天有朋友问我，怎么写了调用代码不出来？这个原因一是可能没有 相同标签的文章，因为织梦相关文章是按相同标签的文章相互关联调用的。二是有相同标签的文章不在同一个栏目，因为织梦相关文章默认是调用同一栏目下同标签 关键词的文章！</p>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	那么如何解决这个相关文章调用不显示的问题呢？详细方法如下，希望能够帮助到大家。</p>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	<a class=\"relatedlink\" href=\"http://www.moke8.com/dedecms/\" style=\"word-wrap: break-word; color: rgb(68, 68, 68) !important; text-decoration: none !important; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: blue;\" target=\"_blank\">织梦模板</a>中调用相关文章的代码：</p>\r\n<div id=\"highlighter_752305\" style=\"word-wrap: break-word; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	<div style=\"word-wrap: break-word;\">\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">01</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;div&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">02</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;dl&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">03</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;dt&gt;&lt;strong&gt;织梦模板调用相关文章&lt;/strong&gt;&lt;/dt&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">04</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;dd&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">05</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;ul&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">06</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">{dede:likearticle col=&#39;2&#39; row=&#39;10&#39; titlelen=&#39;42&#39;}</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">07</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;li&gt;&lt;a href=&quot;[field:arcurl/]&quot;&gt;[field:title/]&lt;/a&gt;&lt;/li&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">08</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">{/dede:likearticle}</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">09</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;/ul&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">10</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;/dd&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">11</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;/dl&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">12</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">&lt;/div&gt;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	以上代码是调用当前栏目相关文章的方法。</p>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	如果我们需要调用整站的相关文章就还需要更改一个系统文件才能起到作用。</p>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	找到DedeCms根目录下的文件：includetagliblikearticle.lib.php<br style=\"word-wrap: break-word;\" />\r\n	找到代码：</p>\r\n<div id=\"highlighter_111226\" style=\"word-wrap: break-word; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	<div style=\"word-wrap: break-word;\">\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">1</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">$typeid</code>&nbsp;<code style=\"word-wrap: break-word;\">=&nbsp;</code><code style=\"word-wrap: break-word;\">&quot;And arc.typeid in($typeid) And arc.id&lt;&gt;$arcid&quot;</code><code style=\"word-wrap: break-word;\">;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	修改为：</p>\r\n<div id=\"highlighter_999229\" style=\"word-wrap: break-word; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	<div style=\"word-wrap: break-word;\">\r\n		<div style=\"word-wrap: break-word;\">\r\n			<table style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse;\">\r\n				<tbody style=\"word-wrap: break-word;\">\r\n					<tr style=\"word-wrap: break-word;\">\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">1</code></td>\r\n						<td style=\"word-wrap: break-word;\">\r\n							<code style=\"word-wrap: break-word;\">$typeid</code>&nbsp;<code style=\"word-wrap: break-word;\">=&nbsp;</code><code style=\"word-wrap: break-word;\">&quot;And arc.id&lt;&gt;$arcid&quot;</code><code style=\"word-wrap: break-word;\">;</code></td>\r\n					</tr>\r\n				</tbody>\r\n			</table>\r\n		</div>\r\n	</div>\r\n</div>\r\n<p style=\"word-wrap: break-word; margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	修改之后保存覆盖，然后重新把文章页重新生成就可以了。</p>\r\n','','','192.168.1.102');
INSERT INTO `dede_addonarticle` VALUES('18','13','<table cellpadding=\"0\" cellspacing=\"0\" class=\"vwtb\" style=\"word-wrap: break-word; empty-cells: show; border-collapse: collapse; table-layout: fixed; width: 850px; height: 300px; color: rgb(0, 0, 0); font-family: 宋体, Arial, Helvetica, sans-serif; font-size: 14px; line-height: 25px;\">\r\n	<tbody style=\"word-wrap: break-word;\">\r\n		<tr style=\"word-wrap: break-word;\">\r\n			<td id=\"article_content\" style=\"word-wrap: break-word; vertical-align: top;\">\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					这下着实让我心惊胆战，因为我的网站已经建了一年半多了，承蒙各路搜索引擎看得起，有一定的流量。一年多的时间都耗在这个网站上面。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					出了问题后，第一时间是在网上搜索相关的教程，及解决的方案。可是每种方案都无效，好在我的网站是默认数据库三天一备份。在咨询了主机提供商后，对主机的数据库进行了备份及还原。然后就能用原来的用户名登陆上去了。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					问题还没有结束，还原后的数据库是三天前的，后面日期的文章已经丢失，以每天30篇文章计算，大约丢失近100篇左右的文章。如果重新发，不可能每一篇文章的url还是原来那个，会给搜索引擎造成很多死链或重复文章。所以我又开始了在原来数据库上面恢复用户名的计划。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					第一步：打开数据库dede_admin表，出现如下界面：</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					<img alt=\"\" border=\"0\" src=\"/uploads/allimg/131113/21060I960-0.jpg\" style=\"word-wrap: break-word; max-width: 850px;\" /></p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					解释：1表示的是登录账号，2表示登录密码（加密后的字符，不是你输入的密码）</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					第二步：把以前能登录的数据库中的账号、密码复制到文本文档中备用。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					第三步：打开不能登录的那个数据库，并且找到dede_admin，打开看看。把第二步中的账号、密码复制到对应的栏目中。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					然后打开织梦后台地址，已经能够登录到织梦后台了。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					至此虽然用户名及密码都有效了，可我们要反思，为什么会出现这种情况呢？今天我们修改过来，会不会过一段时间又被人修改了呢？于是笔者又进入下一步的工作。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					通过360网站卫士检测，发现网站存在&ldquo;DedeCMS最新SQL注入漏洞&rdquo;，此漏洞能够通过SQL注入使用户名和密码变更。解决办法，下载该漏洞补丁进行更新。</p>\r\n				<p style=\"word-wrap: break-word; margin: 0px; padding: 0px;\">\r\n					至此登录织梦后台提示用户名不存在的问题得到解决，希望对给位朋友有借鉴意义。</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n<br />\r\n','','','192.168.1.102');
