欧美日韩国产成人在线,亚洲日韩一欧美,一区二区高清,欧美中文字幕一区二区三区

18038435860

JTBC_PHP版本實現(xiàn)全站搜索功能

時間:2018-10-26 11:55:35 點擊:1224 來源:易速網(wǎng)絡

1、打開search/common/incfiles/module_config.inc.php
覆蓋原來的function jtbc_cms_module_list() 也就是7到71行代碼。
function jtbc_cms_module_list()
{
    global $variable;
  global $ngenre, $npagesize, $nlisttopx;
  global $nsearch_genre, $nsearch_field;
    $tshkeyword = ii_get_safecode($_GET['keyword']);
  $toffset = ii_get_num($_GET['offset']);
  if (ii_isnull($tshkeyword)) mm_imessage(ii_itake('module.keyword_error', 'lng'), -1);
  $tshkeywords = explode(' ', $tshkeyword);
  if (count($tshkeywords) > 5) mm_imessage(ii_itake('module.complex_error', 'lng'), -1);
    $font_red = ii_itake('global.tpl_config.font_red', 'tpl');
  $tmpstr = ii_itake('module.list', 'tpl');
  $tmpastr = ii_ctemplate($tmpstr, '{@recurrence_ida}');
    $tmprstr = '';
        $tndatabases = explode(',', $nsearch_genre);
        $tnfields = explode(',', $nsearch_field);
        $tsqlstr = "";
        for ($ti = 0; $ti < count($tndatabases); $ti ++)
        {
            $tndatabase = $tndatabases[$ti];
            $turltype = ii_get_num($variable[ii_cvgenre($tndatabase) . '.nurltype']);
            $tcreatefolder = $variable[ii_cvgenre($tndatabase) . '.ncreatefolder'];
            $tcreatefiletype = $variable[ii_cvgenre($tndatabase) . '.ncreatefiletype'];
            $tdatabase = $variable[ii_cvgenre($tndatabase) . '.ndatabase'];
            $tidfield = $variable[ii_cvgenre($tndatabase) . '.nidfield'];
            $tfpre = $variable[ii_cvgenre($tndatabase) . '.nfpre'];
            $tunion = " union all ";
            $tsqlstr .= "select * from (";
            $tsqlstr .= "select " . $tidfield . " as un_id,";
            foreach ($tnfields as $tnfield)
            {
                $tsqlstr .= ii_cfnames($tfpre, $tnfield) . " as un_" . $tnfield . ",";
            }
            $tsqlstr .= ii_cfnames($tfpre, 'count') . " as un_count," . ii_cfnames($tfpre, 'time') . " as un_time,'" . $tndatabase . "' as un_genre from " . $tdatabase . " where " . ii_cfnames($tfpre, 'hidden') . "=0";
            foreach ($tshkeywords as $key => $val)
            {
                foreach ($tnfields as $tnfield)
                {
                    if($tnfield == 'topic') $tsqlstr .= " and " . ii_cfnames($tfpre, $tnfield) . " like '%" . $val . "%'";
                    else $tsqlstr .= " or " . ii_cfnames($tfpre, $tnfield) . " like '%" . $val . "%'";
                }
            }
            if($ti == count($tndatabases) - 1) $tsqlstr .= " order by " . ii_cfnames($tfpre, 'time') . " desc) as un_" . $tndatabase;
            else $tsqlstr .= " order by " . ii_cfnames($tfpre, 'time') . " desc) as un_" . $tndatabase . $tunion;
        }
        $tcp = new cc_cutepage;
        $tcp -> id = 'un_id';
        $tcp -> pagesize = $npagesize;
        $tcp -> rslimit = $nlisttopx;
        $tcp -> sqlstr = $tsqlstr;
        $tcp -> offset = $toffset;
        $tcp -> init(); 
        $trsary = $tcp -> get_rs_array();
        if (is_array($trsary))
        {
            foreach($trsary as $trs)
            {
                $tfshkeyword = '';
                $tmptstr = $tmpastr;
                $tfshkeyword = str_replace('{$explain}', $tshkeyword, $font_red);
                $ttopic = ii_htmlencode($trs['un_topic']);
                $tcontent = $trs['un_content'];
                $tmptstr = str_replace('{$topicstr}', $ttopic, $tmpastr);
                if (!ii_isnull($tfshkeyword))
                {
                    $ttopic = str_replace($tshkeyword, $tfshkeyword, $ttopic);
                    $tcontent = str_replace($tshkeyword, $tfshkeyword, $tcontent);
                }
                $tmptstr = str_replace('{$topic}', $ttopic, $tmptstr);
                $tmptstr = str_replace('{$content}', $tcontent, $tmptstr);
                $tmptstr = str_replace('{$time}', ii_get_date($trs['un_time']), $tmptstr);
                $tmptstr = str_replace('{$count}', ii_get_num($trs['un_count']), $tmptstr);
                $tmptstr = str_replace('{$id}', ii_get_num($trs['un_id']), $tmptstr);
                $tmptstr = str_replace('{$baseurl}', ii_get_actual_route($trs['un_genre']) . '/', $tmptstr);
                $tmprstr .= $tmptstr;
            }
        }
        $tmpstr = str_replace(JTBC_CINFO, $tmprstr, $tmpstr);
        $tmpstr = str_replace('{$urltype}', $turltype, $tmpstr);
        $tmpstr = str_replace('{$createfolder}', $tcreatefolder, $tmpstr);
        $tmpstr = str_replace('{$createfiletype}', $tcreatefiletype, $tmpstr);
        $tmpstr = str_replace('{$cpagestr}', $tcp -> get_pagestr(), $tmpstr);
        $tmpstr = str_replace('{$genre}', $ngenre, $tmpstr);
        $tmpstr = ii_creplace($tmpstr);
        return $tmpstr;
}

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2、模版管理-編輯代號search.tpl.module 提交,替換掉之前l(fā)ist節(jié)點的模版
{$=mm_web_head($GLOBALS['nhead'])}
<div id="middle">
  <div id="middleContent">
    <div class="middleSide">
      <div class="box1">
        <h3>{$=ii_itake('global.lng_config.search','lng')}</h3>
        <div class="box1s">
          <form method="get" name="search">
          <table width="100%" cellpadding="0" cellspacing="0" border="0">
            <tr>
              <td height="25"><input type="text" name="keyword" size="15" value="{$=ii_htmlencode($_GET['keyword'])}" class="text" /></td>
            </tr>
            <tr>
              <td height="25"><input type="submit" value="{$=ii_itake('global.lng_config.search','lng')}" class="button" /></td>
            </tr>
          </table>
          </form>
        </div>
      </div>
    </div>
    <div class="middleMain">
      <div class="middleMainContent">
        <table cellpadding="0" cellspacing="0" class="tablen">
          <tr>
            <td class="nav"><span>{$=vv_inavigation('{$genre}', 'strers=module')}</span></td>
          </tr>
          <tr>
            <td class="list" valign="top">
              <table width="100%" cellpadding="0" cellspacing="0" border="0">{@recurrence_ida}
                <tr>
                  <td class="tit1"><img src="{$=#global_images_route}public/small/sico.gif" alt="ICO" /> <a href="{$=ii_curl('{$baseurl}', ii_iurl('detail', {$id}, {$urltype}, 'folder={$createfolder};filetype={$createfiletype};time={$time}'))}" title="{$topicstr}">{$topic}</a></td>
                  <td>{$content}</td>
                                    <td width="130" class="time1"><span>{$time}</span></td>
                                </tr>{@recurrence_ida}
              </table>
            </td>
          </tr>
          <tr>
            <td height="10"></td>
          </tr>
          <tr>
            <td><div id="cutepage" class="cutepage">{$cpagestr}</div></td>
          </tr>
          <tr>
            <td height="10"></td>
          </tr>
        </table>
      </div>
    </div>
    <div class="clear"></div>
  </div>
</div>
{$=mm_web_foot($GLOBALS['nfoot'])}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~·
3、前臺模版調(diào)用代碼
<form method="get" name="search" action="search">
        <table width="100%" cellpadding="0" cellspacing="0" border="0">
          <tr>
            <td width="10" height="10"></td>
            <td></td>
          </tr>
          <tr>
            <td></td>
            <td height="25"><strong>{$=ii_itake('global.lng_config.search', 'lng')}</strong></td>
          </tr>
          <tr>
            <td></td>
            <td height="35">{$=ii_itake('global.lng_config.keyword', 'lng')} <input type="text" name="keyword" size="15" class="text" /> <input type="submit" value="{$=ii_itake('global.lng_config.search','lng')}" class="button" /></td>
          </tr>
          <tr>
            <td height="10"></td>
            <td></td>
          </tr>
        </table>
        </form>

4、找到根目錄/common/incfiles/class.inc.php文件,修改分頁類
  function get_rs_count()
  {
    global $conn;
  //$tsqlstr = 'select count(' . $this -> id . ') from' . ii_get_lrstr($this -> sqlstr, 'from', 'rightr');
    $tsqlstr = $this -> sqlstr;
    $trs = ii_conn_query($tsqlstr, $conn);
    $trs = ii_conn_fetch_array($trs);
    return $trs[0]+1;
  }

影子說明:因修改后的搜索是聯(lián)表查詢,分頁類是針對一個表查詢,所以需要修改。
影子建議,把分頁類復制一份修復,以免對其它處產(chǎn)生影響,請謹慎使用,責任自負。


5、配置管理→(站內(nèi)搜索)search,設置 可被搜索的模塊名,把需要搜索的模塊名加上,把已經(jīng)不存在的模塊名刪掉。然后刪除緩存。(完)

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~·

補充:

分頁出錯,是因為少了一行代碼,加上即可。

$tcp = new cc_cutepage;
        $tcp -> id = 'un_id';
        $tcp -> pagesize = $npagesize;
        $tcp -> rslimit = $nlisttopx;
        $tcp -> sqlstr = $tsqlstr;
        $tcp -> offset = $toffset;
        $tcp -> init(); 
        $trsary = $tcp -> get_rs_array();
        if (is_array($trsary))
添加一行,紅色的部分

//2017.03.16添加修正內(nèi)容
上面一行繼續(xù)添加

再修改分頁類
  function get_rs_count()
  {
    global $conn;
  //$tsqlstr = 'select count(' . $this -> id . ') from' . ii_get_lrstr($this -> sqlstr, 'from', 'rightr');
    $tsqlstr = $this -> sqlstr;
    $trs = ii_conn_query($tsqlstr, $conn);
    $trs = ii_conn_fetch_array($trs);
    return $trs[0]+1;
  }

說明:因修改后的搜索是聯(lián)表查詢,分頁類是針對一個表查詢,所以需要修改。

個人建議,把分頁類復制一份修復,以免對其它處產(chǎn)生影響,請謹慎使用,責任自負。

//2018年7月11日更新 修復多模塊查詢結(jié)果為空的bug
$tsqlstr = 'select count(' . $this -> id . ') from (' . $this -> sqlstr .') as sum';
    $trs = ii_conn_query($tsqlstr, $conn);
    $trs = ii_conn_fetch_array($trs);
    return $trs[0];

国产精品白浆一区二小说| 亚洲欧美国产中文| 97免费国产| 国产高清自拍视频| 国产又粗又猛又爽又黄的视频一区| 久久亚洲综合精品| 精品久久久久久久免费人妻三轩| 女人自慰黄区免费看| 老熟女高潮喷了一地| 日韩在线视频精品| 国产精品一区二555| 狠狠人人| 人妻体内射精一区二区三区| 久久性av| 国产偷窥高潮熟女精品视频| 亚洲成人电影免费在线| 久久国产成人无码一区二区三区 | 97超碰国产精品| 丁香一区二区| 国产成人精品无码免费看在线| 亚洲一区亚洲二区| 欧美日韩亚洲综合一区二区三区| AV无码免费一区二区三区| 国产乱子影视频上线免费观看| 亚洲国产精品成人| 国产精品福利网站| 美女国产一区二区| 色亚洲一区二区| 女生自慰喷水在线观看| 日韩女同互慰一区二区| 亚洲无码综合在线| AV潮喷大喷水系列无码| 无码理伦| 婷婷俺来也| 一起草免费看| 午夜乡村少妇AAAAA片| 国产精品欧美久久久久三级| 色视频在线看| 欧美日韩性爱一区二区| 精品7777| 一本久热|