10Syaroslav@ivinco.com<?php 20Syaroslav@ivinco.com/* 30Syaroslav@ivinco.com * To change this template, choose Tools | Templates 40Syaroslav@ivinco.com * and open the template in the editor. 50Syaroslav@ivinco.com */ 60Syaroslav@ivinco.com 70Syaroslav@ivinco.comclass PageMapper 80Syaroslav@ivinco.com{ 91Syaroslav@ivinco.com private $_database = 'pagedata'; 100Syaroslav@ivinco.com private $_table = 'pages'; 110Syaroslav@ivinco.com private $_db = null; 120Syaroslav@ivinco.com public function __construct() 130Syaroslav@ivinco.com { 140Syaroslav@ivinco.com global $conf; 150Syaroslav@ivinco.com 16119Syaroslav $dataPath = fullpath($conf['savedir']); 17119Syaroslav if (!@file_exists($dataPath)) { 18119Syaroslav $dataPath = fullpath(DOKU_INC . $conf['savedir']); 19119Syaroslav } 20119Syaroslav $this->_dbpath = $dataPath . '/sphinxsearch/' . $this->_database; 21119Syaroslav 22119Syaroslav 23119Syaroslav if (false != ($db = new PDO("sqlite:".$this->_dbpath))) { 240Syaroslav@ivinco.com $q = @$db->query("SELECT 1 FROM {$this->_table} limit 1"); 250Syaroslav@ivinco.com if ($q === false) { 2619Syaroslav@ivinco.com $result = $db->query("CREATE TABLE {$this->_table} ( page varchar(1024), page_crc int(11), hid varchar(1024), title_text varchar(1024), title varchar(1024), unique (page, page_crc))"); 2719Syaroslav@ivinco.com if (!$result) { 2819Syaroslav@ivinco.com echo "\nPDO::errorInfo():\n"; 2919Syaroslav@ivinco.com print_r($db->errorInfo()); 3019Syaroslav@ivinco.com exit; 3119Syaroslav@ivinco.com } 3219Syaroslav@ivinco.com 330Syaroslav@ivinco.com } 34119Syaroslav } else { 35119Syaroslav echo "\nPDO::errorInfo():\n"; 36119Syaroslav print_r($db->errorInfo()); 37119Syaroslav exit; 380Syaroslav@ivinco.com } 390Syaroslav@ivinco.com $this->_db = $db; 400Syaroslav@ivinco.com } 410Syaroslav@ivinco.com 4219Syaroslav@ivinco.com public function add($page, $title_text, $title, $hid='') 430Syaroslav@ivinco.com { 4419Syaroslav@ivinco.com $result = $this->_db->query("REPLACE into {$this->_table}(page, page_crc, hid, title, title_text) values(".$this->_db->quote($page).", 45*121Syaroslav@ivinco.com '".sprintf('%u', crc32($page.$hid))."', 4612Syaroslav@ivinco.com ".$this->_db->quote($hid).", 4719Syaroslav@ivinco.com ".$this->_db->quote($title).", 4819Syaroslav@ivinco.com ".$this->_db->quote($title_text).")"); 4912Syaroslav@ivinco.com if (!$result) { 5056Syaroslav@ivinco.com echo "\nPDO::errorInfo():\n"; 5156Syaroslav@ivinco.com print_r($this->_db->errorInfo()); 5212Syaroslav@ivinco.com } 530Syaroslav@ivinco.com } 540Syaroslav@ivinco.com 550Syaroslav@ivinco.com public function getAll() 560Syaroslav@ivinco.com { 570Syaroslav@ivinco.com $result = $this->_db->query("select * from {$this->_table}"); 5812Syaroslav@ivinco.com return $result->fetchAll(PDO::FETCH_ASSOC); 590Syaroslav@ivinco.com } 600Syaroslav@ivinco.com 6139Syaroslav@ivinco.com public function getByCrc($pageCrcList) 620Syaroslav@ivinco.com { 630Syaroslav@ivinco.com $sql = sprintf("select * from {$this->_table} where page_crc in (%s)", implode(",", $pageCrcList)); 640Syaroslav@ivinco.com $result = $this->_db->query($sql); 6512Syaroslav@ivinco.com $rows = $result->fetchAll(PDO::FETCH_ASSOC); 664Syaroslav@ivinco.com 670Syaroslav@ivinco.com $pages = array(); 680Syaroslav@ivinco.com foreach($rows as $row){ 6939Syaroslav@ivinco.com $pages[$row['page_crc']] = array('page' => $row['page'], 'hid' => $row['hid'], 'title' => $row['title'], 'title_text' => $row['title_text']); 700Syaroslav@ivinco.com } 7139Syaroslav@ivinco.com $results = array(); 7239Syaroslav@ivinco.com foreach($pageCrcList as $crc){ 7339Syaroslav@ivinco.com $results[$crc] = $pages[$crc]; 7439Syaroslav@ivinco.com } 7539Syaroslav@ivinco.com return $results; 7639Syaroslav@ivinco.com } 770Syaroslav@ivinco.com} 78