#命令行查詢時,從數(shù)據(jù)庫讀取原始數(shù)據(jù)信息 sql_query_info = SELECT ARC.*,ART.body FROM dede_archives AS ARC LEFT JOIN dede_addonarticle AS ART ON ARC.id = ART.aid WHERE ARC.id=$id }
# 增量索引,從最大id開始 sql_query = SELECT ARC.id,ARC.typeid,ARC.typeid2,ARC.sortrank,ARC.flag,ARC.channel,ARC.ismake,ARC.arcrank,ARC.click,ARC.title,ARC.shorttitle,ARC.color,ARC.writer,ARC.source,ARC.litpic,ARC.pubdate,ARC.senddate,ARC.mtype,ARC.description,ARC.badpost,ARC.goodpost,ARC.scores,ARC.lastpost,ARC.keywords,ARC.mid,ART.body FROM dede_archives AS ARC LEFT JOIN dede_addonarticle AS ART ON ARC.id = ART.aid WHERE ARC.id > ( SELECT maxaid FROM dede_sphinx WHERE countid=1 ) #從SQL讀取到的值必須為整數(shù) sql_query_post = REPLACE INTO dede_sphinx SELECT 1, MAX(id) FROM dede_archives sql_attr_uint = typeid sql_attr_uint = typeid2 sql_attr_uint = channel sql_attr_uint = click sql_attr_uint = badpost sql_attr_uint = goodpost sql_attr_uint = scores sql_attr_uint = mid sql_attr_timestamp = pubdate #從SQL讀取到的值必須為整數(shù),作為時間屬性 sql_attr_timestamp = senddate sql_attr_timestamp = lastpost
#命令行查詢時,從數(shù)據(jù)庫讀取原始數(shù)據(jù)信息 sql_query_info = SELECT ARC.*,ART.body FROM dede_archives AS ARC LEFT JOIN dede_addonarticle AS ART ON ARC.id = ART.aid WHERE ARC.id=$id }