Home  >  Article  >  CMS Tutorial  >  How to batch index DeDeCms V5.6 data into Taote search engine

How to batch index DeDeCms V5.6 data into Taote search engine

藏色散人
藏色散人Original
2019-12-20 09:55:552274browse

How to batch index DeDeCms V5.6 data into Taote search engine

How to batch index DeDeCms V5.6 data into Taote search engine?

DeDeCms V5.6 data batch indexing to Taote search engine

Since DedeCms does not save the generated address of the article in the database, what needs to be done It is to index a field: LinkUrl to save the article generation address.

Recommended study: 梦Weavercms

1. Run Sql statement through Mysql: alter table dede_archives add LinkUrl varchar(255);

2. Back up makehtml_archives_action.php in the backend directory

3. Modify it, change line 110, $rurl = $ac->MakeHtml($isremote); to:

$lnk=$cfg_basehost.$ac->GetTrueUrl($id);
  $ac->dsql->ExecuteNoneQuery("Update `dede_archives` set LinkUrl='".$lnk."' where id='".$id."'");
  echo $lnk;
  echo "<br>";

4. Go to the background-HTML update-update document HTML and enter the starting ID. Just batch update will do.

5. After updating, restore makehtml_archives_action.php to the original file you just backed up.

6. Create a new table: t_tot

 CREATE TABLE `t_tot` (
  `id` int(11) NOT NULL auto_increment,
  `typeid` int(11) default &#39;0&#39;,
  `title` varchar(100) default &#39;&#39;,
  `description` varchar(250) default &#39;&#39;,
  `Datestr` varchar(100) default &#39;&#39;,
  `LinkUrl` varchar(200) default &#39;&#39;,
  `body` text,
  PRIMARY KEY (`id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=gbk;

7. Copy the content to the index table

  insert into t_tot(id,typeid,title,description,Datestr,LinkUrl,body) SELECT a.id,a.typeid,a.title,a.description,now(),a.LinkUrl,b.body
  FROM dede_archives a,dede_addonarticle b where a.id=b.aid

8. Import the t_tot table into Sqlserver through Mysql Odbc. Pay attention when connecting. , please choose to compile to GBK, as shown below:

9. Run Reset.aspx index table t_tot

The above is the detailed content of How to batch index DeDeCms V5.6 data into Taote search engine. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn