PHP text::splitWords方法代码示例

 /**
  * Ajout/modification des textes internationnalisés d'un élément.
  *
  * @param integer $iItemId
  * @param array $aItemLocalesData
  */
 protected function setItemI18n($iItemId, $aItemLocalesData)
 {
     foreach ($this->okt->languages->list as $aLanguage) {
         if (empty($aItemLocalesData[$aLanguage['code']]['title'])) {
             continue;
         }
         $oCursor = $this->db->openCursor($this->t_items_locales);
         $oCursor->item_id = $iItemId;
         $oCursor->language = $aLanguage['code'];
         foreach ($aItemLocalesData[$aLanguage['code']] as $k => $v) {
             $oCursor->{$k} = $v;
         }
         $oCursor->content = $this->okt->HTMLfilter($oCursor->content);
         $oCursor->words = implode(' ', array_unique(text::splitWords($oCursor->title . ' ' . $oCursor->subtitle . ' ' . $oCursor->content . ' ' . $oCursor->author . ' ' . $oCursor->place)));
         $oCursor->meta_description = html::clean($oCursor->meta_description);
         $oCursor->meta_keywords = html::clean($oCursor->meta_keywords);
         $oCursor->insertUpdate();
         $this->setItemSlug($iItemId, $aLanguage['code']);
     }
 }

 private function getCommentCursor($cur)
 {
     if ($cur->comment_content !== null && $cur->comment_content == '') {
         throw new Exception(__('You must provide a comment'));
     }
     if ($cur->comment_author !== null && $cur->comment_author == '') {
         throw new Exception(__('You must provide an author name'));
     }
     if ($cur->comment_email != '' && !text::isEmail($cur->comment_email)) {
         throw new Exception(__('Email address is not valid.'));
     }
     if ($cur->comment_site !== null && $cur->comment_site != '') {
         if (!preg_match('|^http(s?)://|i', $cur->comment_site, $matches)) {
             $cur->comment_site = 'http://' . $cur->comment_site;
         } else {
             $cur->comment_site = strtolower($matches[0]) . substr($cur->comment_site, strlen($matches[0]));
         }
     }
     if ($cur->comment_status === null) {
         $cur->comment_status = (int) $this->settings->system->comments_pub;
     }
     # Words list
     if ($cur->comment_content !== null) {
         $cur->comment_words = implode(' ', text::splitWords($cur->comment_content));
     }
 }

 /**
 Recreates comments search engine index.
 
 @param	start	<b>integer</b>		Start comment index
 @param	limit	<b>integer</b>		Number of comments to index
 
 @return	<b>integer</b>		<var>$start</var> and <var>$limit</var> sum
 */
 public function indexAllComments($start = null, $limit = null)
 {
     $strReq = 'SELECT COUNT(comment_id) ' . 'FROM ' . $this->prefix . 'comment';
     $rs = $this->con->select($strReq);
     $count = $rs->f(0);
     $strReq = 'SELECT comment_id, comment_content ' . 'FROM ' . $this->prefix . 'comment ';
     if ($start !== null && $limit !== null) {
         $strReq .= $this->con->limit($start, $limit);
     }
     $rs = $this->con->select($strReq);
     $cur = $this->con->openCursor($this->prefix . 'comment');
     while ($rs->fetch()) {
         $cur->comment_words = implode(' ', text::splitWords($rs->comment_content));
         $cur->update('WHERE comment_id = ' . (int) $rs->comment_id);
         $cur->clean();
     }
     if ($start + $limit > $count) {
         return null;
     }
     return $start + $limit;
 }

 /**
  * Reconstruction des index de recherche de tous les produits
  *
  */
 public function indexAllProducts()
 {
     $rsProducts = $this->getProds(array('visibility' => 2));
     while ($rsProducts->fetch()) {
         $words = $rsProducts->title . ' ' . $rsProducts->subtitle . ' ' . $rsProducts->content_short . ' ' . $rsProducts->content . ' ';
         $words = implode(' ', text::splitWords($words));
         $query = 'UPDATE ' . $this->t_products . ' SET ' . 'words=\'' . $this->db->escapeStr($words) . '\' ' . 'WHERE id=' . (int) $rsProducts->id;
         $this->db->execute($query);
     }
     return true;
 }

 /**
  * Retourne la liste des thèmes disponibles avec les infos de l'administration.
  *
  * @return array
  */
 public function getThemesAdminList()
 {
     $aThemes = $this->getThemesList();
     foreach ($aThemes as $iThemeId => $aTheme) {
         # search indexes
         $aThemes[$iThemeId]['index'] = text::splitWords($aThemes[$iThemeId]['name'] . ' ' . $aThemes[$iThemeId]['desc'] . ' ' . $aThemes[$iThemeId]['tags']);
         $aThemes[$iThemeId]['index'] = array_map('strtolower', $aThemes[$iThemeId]['index']);
         $aThemes[$iThemeId]['index'] = array_unique($aThemes[$iThemeId]['index']);
         array_unshift($aThemes[$iThemeId]['index'], $iThemeId);
         # is active ?
         if ($aTheme['id'] == $this->okt->config->theme) {
             $aThemes[$iThemeId]['is_active'] = true;
             array_unshift($aThemes[$iThemeId]['index'], 'active');
             array_unshift($aThemes[$iThemeId]['index'], 'actif');
         } else {
             $aThemes[$iThemeId]['is_active'] = false;
         }
         # is mobile ?
         if ($aTheme['id'] == $this->okt->config->theme_mobile) {
             $aThemes[$iThemeId]['is_mobile'] = true;
             array_unshift($aThemes[$iThemeId]['index'], 'mobile');
             array_unshift($aThemes[$iThemeId]['index'], 'mobil');
             array_unshift($aThemes[$iThemeId]['index'], 'active');
             array_unshift($aThemes[$iThemeId]['index'], 'actif');
         } else {
             $aThemes[$iThemeId]['is_mobile'] = false;
         }
         # is tablet ?
         if ($aTheme['id'] == $this->okt->config->theme_tablet) {
             $aThemes[$iThemeId]['is_tablet'] = true;
             array_unshift($aThemes[$iThemeId]['index'], 'tablet');
             array_unshift($aThemes[$iThemeId]['index'], 'tablette');
             array_unshift($aThemes[$iThemeId]['index'], 'active');
             array_unshift($aThemes[$iThemeId]['index'], 'actif');
         } else {
             $aThemes[$iThemeId]['is_tablet'] = false;
         }
         # has screenshot ?
         if (file_exists($this->sPath . '/' . $aTheme['id'] . '/screenshot.jpg')) {
             $aThemes[$iThemeId]['screenshot'] = true;
         } else {
             $aThemes[$iThemeId]['screenshot'] = false;
         }
         # has config ?
         if (file_exists($this->sPath . '/' . $aTheme['id'] . '/admin/config.php')) {
             $aThemes[$iThemeId]['has_config'] = true;
         } else {
             $aThemes[$iThemeId]['has_config'] = false;
         }
     }
     return $aThemes;
 }

 protected function importComments($post_id, $new_post_id, $db)
 {
     $count_c = $count_t = 0;
     $rs = $db->select('SELECT * FROM ' . $this->vars['db_prefix'] . 'comment ' . 'WHERE post_id = ' . (int) $post_id . ' ');
     while ($rs->fetch()) {
         $cur = $this->con->openCursor($this->prefix . 'comment');
         $cur->post_id = (int) $new_post_id;
         $cur->comment_author = $this->cleanStr($rs->comment_auteur);
         $cur->comment_status = (int) $rs->comment_pub;
         $cur->comment_dt = $rs->comment_dt;
         $cur->comment_upddt = $rs->comment_upddt;
         $cur->comment_email = $this->cleanStr($rs->comment_email);
         $cur->comment_content = $this->cleanStr($rs->comment_content);
         $cur->comment_ip = $rs->comment_ip;
         $cur->comment_trackback = (int) $rs->comment_trackback;
         $cur->comment_site = $this->cleanStr($rs->comment_site);
         if ($cur->comment_site != '' && !preg_match('!^http://.*$!', $cur->comment_site)) {
             $cur->comment_site = substr('http://' . $cur->comment_site, 0, 255);
         }
         if ($rs->exists('spam') && $rs->spam && ($rs->comment_status = 0)) {
             $cur->comment_status = -2;
         }
         $cur->comment_words = implode(' ', text::splitWords($cur->comment_content));
         $cur->comment_id = $this->con->select('SELECT MAX(comment_id) FROM ' . $this->prefix . 'comment')->f(0) + 1;
         $cur->insert();
         if ($cur->comment_trackback && $cur->comment_status == 1) {
             $count_t++;
         } elseif ($cur->comment_status == 1) {
             $count_c++;
         }
     }
     if ($count_t > 0 || $count_c > 0) {
         $this->con->execute('UPDATE ' . $this->prefix . 'post SET ' . 'nb_comment = ' . $count_c . ', ' . 'nb_trackback = ' . $count_t . ' ' . 'WHERE post_id = ' . (int) $new_post_id . ' ');
     }
 }

 protected function importComments($post_id, $new_post_id, &$db)
 {
     $count_c = $count_t = 0;
     $rs = $db->select('SELECT * FROM ' . $this->vars['db_prefix'] . 'comments ' . 'WHERE comment_post_ID = ' . (int) $post_id . ' ');
     while ($rs->fetch()) {
         $cur = $this->con->openCursor($this->prefix . 'comment');
         $cur->post_id = (int) $new_post_id;
         $cur->comment_author = $this->cleanStr($rs->comment_author);
         $cur->comment_status = (int) $rs->comment_approved;
         $cur->comment_dt = $rs->comment_date;
         $cur->comment_email = $this->cleanStr($rs->comment_author_email);
         $cur->comment_content = $this->core->callFormater($this->vars['comment_formater'], $this->cleanStr($rs->comment_content));
         $cur->comment_ip = $rs->comment_author_IP;
         $cur->comment_trackback = $rs->comment_type == 'trackback' ? 1 : 0;
         $cur->comment_site = substr($this->cleanStr($rs->comment_author_url), 0, 255);
         if (!isset($cur->comment_site)) {
             $cur->comment_site = NULL;
         }
         if ($rs->comment_approved == 'spam') {
             $cur->comment_status = -2;
         }
         $cur->comment_words = implode(' ', text::splitWords($cur->comment_content));
         $cur->comment_id = $this->con->select('SELECT MAX(comment_id) FROM ' . $this->prefix . 'comment')->f(0) + 1;
         $cur->insert();
         if ($cur->comment_trackback && $cur->comment_status == 1) {
             $count_t++;
         } elseif ($cur->comment_status == 1) {
             $count_c++;
         }
     }
     if ($count_t > 0 || $count_c > 0) {
         $this->con->execute('UPDATE ' . $this->prefix . 'post SET ' . 'nb_comment = ' . $count_c . ', ' . 'nb_trackback = ' . $count_t . ' ' . 'WHERE post_id = ' . (int) $new_post_id . ' ');
     }
 }

 /**
  * Renvoie les données concernant un ou plusieurs utilisateurs.
  * La méthode renvoie false si elle échoue.
  *
  * @param	array	params		Les paramètres
  * @param	boolean	count_only	Permet de ne retourner que le compte
  * @return	recordset
  */
 public function getUsers($aParams = array(), $count_only = false)
 {
     $sReqPlus = 'WHERE 1 ';
     if (isset($aParams['id'])) {
         $sReqPlus .= 'AND u.id=' . (int) $aParams['id'] . ' ';
     }
     if (isset($aParams['username'])) {
         $sReqPlus .= 'AND u.username=\'' . $this->db->escapeStr($aParams['username']) . '\' ';
     }
     if (isset($aParams['active'])) {
         if ($aParams['active'] == 0) {
             $sReqPlus .= 'AND u.active=0 ';
         } elseif ($aParams['active'] == 1) {
             $sReqPlus .= 'AND u.active=1 ';
         } elseif ($aParams['active'] == 2) {
             $sReqPlus .= '';
         }
     }
     if (isset($aParams['group_id'])) {
         if (is_array($aParams['group_id'])) {
             $aParams['group_id'] = array_map('intval', $aParams['group_id']);
             $sReqPlus .= 'AND u.group_id IN (' . implode(',', $aParams['group_id']) . ') ';
         } else {
             $sReqPlus .= 'AND u.group_id=' . (int) $aParams['group_id'] . ' ';
         }
     }
     if (!empty($aParams['group_id_not'])) {
         if (is_array($aParams['group_id_not'])) {
             $aParams['group_id_not'] = array_map('intval', $aParams['group_id_not']);
             $sReqPlus .= 'AND u.group_id NOT IN (' . implode(',', $aParams['group_id_not']) . ') ';
         } else {
             $sReqPlus .= 'AND u.group_id<>' . (int) $aParams['group_id_not'] . ' ';
         }
     }
     if (!empty($aParams['search'])) {
         $aWords = text::splitWords($aParams['search']);
         if (!empty($aWords)) {
             foreach ($aWords as $i => $w) {
                 $aWords[$i] = 'u.username LIKE \'%' . $this->db->escapeStr($w) . '%\' OR ' . 'u.lastname LIKE \'%' . $this->db->escapeStr($w) . '%\' OR ' . 'u.firstname LIKE \'%' . $this->db->escapeStr($w) . '%\' OR ' . 'u.email LIKE \'%' . $this->db->escapeStr($w) . '%\' ';
             }
             $sReqPlus .= ' AND ' . implode(' AND ', $aWords) . ' ';
         }
     }
     if ($count_only) {
         $sQuery = 'SELECT COUNT(u.id) AS num_users ' . 'FROM ' . $this->t_users . ' AS u ' . $sReqPlus;
     } else {
         $sQuery = 'SELECT u.*, g.* ' . 'FROM ' . $this->t_users . ' AS u ' . 'LEFT JOIN ' . $this->t_groups . ' AS g ON g.group_id=u.group_id ' . $sReqPlus;
         if (isset($aParams['order'])) {
             $sQuery .= 'ORDER BY ' . $aParams['order'] . ' ';
         } else {
             $sQuery .= 'ORDER BY u.username DESC ';
         }
         if (isset($aParams['limit'])) {
             $sQuery .= 'LIMIT ' . $aParams['limit'] . ' ';
         }
     }
     if (($rs = $this->db->select($sQuery)) === false) {
         return new recordset(array());
     }
     if ($count_only) {
         return (int) $rs->num_users;
     } else {
         return $rs;
     }
 }

 /**
  * Reconstruction des index de recherche de tous les articles.
  *
  */
 public function indexAllPosts()
 {
     $rsPosts = $this->db->select('SELECT post_id, language, title, subtitle, content FROM ' . $this->t_news_locales);
     while ($rsPosts->fetch()) {
         $words = $rsPosts->title . ' ' . $rsPosts->subtitle . ' ' . $rsPosts->content . ' ';
         $words = implode(' ', text::splitWords($words));
         $query = 'UPDATE ' . $this->t_news . ' SET ' . 'words=\'' . $this->db->escapeStr($words) . '\' ' . 'WHERE post_id=' . (int) $rsPosts->id . ' ' . 'AND language=\'' . $this->db->escapeStr($rsPosts->language) . '\' ';
         $this->db->execute($query);
     }
     return true;
 }

 /**
  * Enregistrement des textes internationalisés
  *
  * @return boolean
  */
 protected function setQuestionI18n()
 {
     foreach ($this->okt->languages->list as $aLanguage) {
         $this->params['content'][$aLanguage['code']] = $this->okt->HTMLfilter($this->params['content'][$aLanguage['code']]);
         $words = implode(' ', text::splitWords($this->params['title'][$aLanguage['code']] . ' ' . $this->params['content'][$aLanguage['code']]));
         $query = 'INSERT INTO ' . $this->t_faq_locales . ' ' . '(faq_id, language, title, title_tag, title_seo, slug, content, meta_description, meta_keywords, words) ' . 'VALUES (' . (int) $this->params['id'] . ', ' . '\'' . $this->db->escapeStr($aLanguage['code']) . '\', ' . (empty($this->params['title'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['title_tag'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title_tag'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['title_seo'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title_seo'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['slugs'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['slugs'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['content'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['content'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['meta_description'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['meta_description'][$aLanguage['code']]) . '\'') . ', ' . (empty($this->params['meta_keywords'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['meta_keywords'][$aLanguage['code']]) . '\'') . ', ' . (empty($words) ? 'NULL' : '\'' . $this->db->escapeStr($words) . '\'') . ' ' . ') ON DUPLICATE KEY UPDATE ' . 'title=' . (empty($this->params['title'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title'][$aLanguage['code']]) . '\'') . ', ' . 'title_tag=' . (empty($this->params['title_tag'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title_tag'][$aLanguage['code']]) . '\'') . ', ' . 'title_seo=' . (empty($this->params['title_seo'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['title_seo'][$aLanguage['code']]) . '\'') . ', ' . 'slug=' . (empty($this->params['slugs'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['slugs'][$aLanguage['code']]) . '\'') . ', ' . 'content=' . (empty($this->params['content'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['content'][$aLanguage['code']]) . '\'') . ', ' . 'meta_description=' . (empty($this->params['meta_description'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['meta_description'][$aLanguage['code']]) . '\'') . ', ' . 'meta_keywords=' . (empty($this->params['meta_keywords'][$aLanguage['code']]) ? 'NULL' : '\'' . $this->db->escapeStr($this->params['meta_keywords'][$aLanguage['code']]) . '\'') . ', ' . 'words=' . (empty($words) ? 'NULL' : '\'' . $this->db->escapeStr($words) . '\'') . ' ';
         if (!$this->db->execute($query)) {
             return false;
         }
         if (!$this->setQuestionSlug($this->params['id'], $aLanguage['code'])) {
             return false;
         }
     }
     return true;
 }