船说(ShipSay)CMS小说站群程序长尾词插件使用说明-听书迷

本教程仅限于学习研究，希望帮到有需要的人，如果购买此插件，请到官方购买。

一、源站数据库执行以下语句(不对原数据库做任何改动,只是新建一个表):


<span class="token keyword keyword-CREATE">CREATE</span> <span class="token keyword keyword-TABLE">TABLE</span> <span class="token keyword keyword-IF">IF</span> <span class="token operator">NOT</span> <span class="token keyword keyword-EXISTS">EXISTS</span> <span class="token punctuation">`</span>shipsay_article_langtail<span class="token punctuation">`</span> <span class="token punctuation">(</span>
<span class="token punctuation">`</span>langid<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token keyword keyword-unsigned">unsigned</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-AUTO_INCREMENT">AUTO_INCREMENT</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>langname<span class="token punctuation">`</span> <span class="token keyword keyword-varchar">varchar</span><span class="token punctuation">(</span><span class="token number">50</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token string">''</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>sourcename<span class="token punctuation">`</span> <span class="token keyword keyword-varchar">varchar</span><span class="token punctuation">(</span><span class="token number">50</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token string">''</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>uptime<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token number">0</span><span class="token punctuation">,</span>
<span class="token keyword keyword-PRIMARY">PRIMARY</span> <span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">(</span><span class="token punctuation">`</span>langid<span class="token punctuation">`</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span> <span class="token punctuation">(</span><span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span><span class="token punctuation">,</span><span class="token punctuation">`</span>langid<span class="token punctuation">`</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword keyword-UNIQUE">UNIQUE</span> <span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">`</span>langname<span class="token punctuation">`</span><span class="token punctuation">(</span><span class="token punctuation">`</span>langname<span class="token punctuation">`</span><span class="token punctuation">)</span>
<span class="token punctuation">)</span> <span class="token keyword keyword-ENGINE">ENGINE</span><span class="token operator">=</span><span class="token keyword keyword-InnoDB">InnoDB</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token keyword keyword-CHARSET">CHARSET</span><span class="token operator">=</span>utf8<span class="token punctuation">;</span>
<span class="token keyword keyword-CREATE">CREATE</span> <span class="token keyword keyword-TABLE">TABLE</span> <span class="token keyword keyword-IF">IF</span> <span class="token operator">NOT</span> <span class="token keyword keyword-EXISTS">EXISTS</span> <span class="token punctuation">`</span>shipsay_article_langtail<span class="token punctuation">`</span> <span class="token punctuation">(</span>
<span class="token punctuation">`</span>langid<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token keyword keyword-unsigned">unsigned</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-AUTO_INCREMENT">AUTO_INCREMENT</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>langname<span class="token punctuation">`</span> <span class="token keyword keyword-varchar">varchar</span><span class="token punctuation">(</span><span class="token number">50</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token string">''</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>sourcename<span class="token punctuation">`</span> <span class="token keyword keyword-varchar">varchar</span><span class="token punctuation">(</span><span class="token number">50</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token string">''</span><span class="token punctuation">,</span>
<span class="token punctuation">`</span>uptime<span class="token punctuation">`</span> <span class="token keyword keyword-int">int</span><span class="token punctuation">(</span><span class="token number">11</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token number">0</span><span class="token punctuation">,</span>
<span class="token keyword keyword-PRIMARY">PRIMARY</span> <span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">(</span><span class="token punctuation">`</span>langid<span class="token punctuation">`</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span> <span class="token punctuation">(</span><span class="token punctuation">`</span>sourceid<span class="token punctuation">`</span><span class="token punctuation">,</span><span class="token punctuation">`</span>langid<span class="token punctuation">`</span><span class="token punctuation">)</span><span class="token punctuation">,</span>
<span class="token keyword keyword-UNIQUE">UNIQUE</span> <span class="token keyword keyword-KEY">KEY</span> <span class="token punctuation">`</span>langname<span class="token punctuation">`</span><span class="token punctuation">(</span><span class="token punctuation">`</span>langname<span class="token punctuation">`</span><span class="token punctuation">)</span>
<span class="token punctuation">)</span> <span class="token keyword keyword-ENGINE">ENGINE</span><span class="token operator">=</span><span class="token keyword keyword-InnoDB">InnoDB</span> <span class="token keyword keyword-DEFAULT">DEFAULT</span> <span class="token keyword keyword-CHARSET">CHARSET</span><span class="token operator">=</span>utf8<span class="token punctuation">;</span>
CREATE TABLE IF NOT EXISTS `shipsay_article_langtail` (
`langid` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sourceid` int(11) NOT NULL,
`langname` varchar(50) NOT NULL DEFAULT '',
`sourcename` varchar(50) NOT NULL DEFAULT '',
`uptime` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`langid`),
KEY `sourceid` (`sourceid`,`langid`),
UNIQUE KEY `langname`(`langname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

二、插件包已经一起解压至压缩包

将插件包中的 /www/admin 文件夹名修改为您当前的后台文件夹名
将插件包上传覆盖到船说根目录下 (建议先备份船说)

三、登录后台, 设置长尾词参数后, “保存设置” 至少点击一次, 确认弹出: 保存成功的提示

四、修改模板文件: /themes/当前模板文件夹/ 下的 tpl_info.php 或者 tpl_indexlist.php根据模板设计不同, 可能只有其中一个, 或者二个都有.在模板文件合适的位置添加以下代码（已经在模板中加入，如果使用其他模板自行增加）


<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-if">if</span> <span class="token punctuation">(</span><span class="token operator">!</span><span class="token function">empty</span><span class="token punctuation">(</span><span class="token variable">$langtailrows</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">:</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"><</span>p<span class="token punctuation">></span></span>相关推荐：
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-foreach">foreach</span> <span class="token punctuation">(</span><span class="token variable">$langtailrows</span> <span class="token keyword keyword-as">as</span> <span class="token variable">$v</span><span class="token punctuation">)</span> <span class="token punctuation">:</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"><</span>a <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token php language-php"><span class="token delimiter important"><?=</span> <span class="token variable">$v</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'info_url'</span><span class="token punctuation">]</span> <span class="token delimiter important">?></span></span><span class="token punctuation">"</span></span><span class="token punctuation">></span></span><span class="token php language-php"><span class="token delimiter important"><?=</span> <span class="token variable">$v</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'langname'</span><span class="token punctuation">]</span> <span class="token delimiter important">?></span></span><span class="token tag"><span class="token punctuation"></</span>a<span class="token punctuation">></span></span><span class="token entity" title=" "> </span>
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-endforeach">endforeach</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"></</span>p<span class="token punctuation">></span></span>
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-endif">endif</span><span class="token punctuation">;</span> <span class="token delimiter important">?></span></span>
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-if">if</span> <span class="token punctuation">(</span><span class="token operator">!</span><span class="token function">empty</span><span class="token punctuation">(</span><span class="token variable">$langtailrows</span><span class="token punctuation">)</span><span class="token punctuation">)</span> <span class="token punctuation">:</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"><</span>p<span class="token punctuation">></span></span>相关推荐：
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-foreach">foreach</span> <span class="token punctuation">(</span><span class="token variable">$langtailrows</span> <span class="token keyword keyword-as">as</span> <span class="token variable">$v</span><span class="token punctuation">)</span> <span class="token punctuation">:</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"><</span>a <span class="token attr-name">href</span><span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">"</span><span class="token php language-php"><span class="token delimiter important"><?=</span> <span class="token variable">$v</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'info_url'</span><span class="token punctuation">]</span> <span class="token delimiter important">?></span></span><span class="token punctuation">"</span></span><span class="token punctuation">></span></span><span class="token php language-php"><span class="token delimiter important"><?=</span> <span class="token variable">$v</span><span class="token punctuation">[</span><span class="token single-quoted-string string">'langname'</span><span class="token punctuation">]</span> <span class="token delimiter important">?></span></span><span class="token tag"><span class="token punctuation"></</span>a<span class="token punctuation">></span></span><span class="token entity" title=" "> </span>
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-endforeach">endforeach</span> <span class="token delimiter important">?></span></span>
<span class="token tag"><span class="token punctuation"></</span>p<span class="token punctuation">></span></span>
<span class="token php language-php"><span class="token delimiter important"><?php</span> <span class="token keyword keyword-endif">endif</span><span class="token punctuation">;</span> <span class="token delimiter important">?></span></span>
<?php if (!empty($langtailrows)) : ?>
<p>相关推荐：
<?php foreach ($langtailrows as $v) : ?>
<a href="<?= $v['info_url'] ?>"><?= $v['langname'] ?></a>&nbsp;
<?php endforeach ?>
</p>
<?php endif; ?>