Beispiel #1
0
 public function query($sql, $params = null)
 {
     try {
         $stmt = $this->pdo->prepare($sql);
         if (!$stmt) {
             return false;
         }
         if (is_array($params) && strpos($sql, '?')) {
             foreach ($params as $k => $v) {
                 $k += 1;
                 $stmt->bindValue($k, $v);
             }
         }
         if (is_scalar($params) && strpos($sql, '?')) {
             $stmt->bindValue(1, $params);
         }
         $stmt->execute();
         if (stripos($sql, 'SELECT') < 20 && stripos($sql, 'SELECT') !== false) {
             $items = array();
             while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                 $items[] = $row;
             }
             return $items;
         }
         return true;
     } catch (PDOException $e) {
         $log = Logger::getLog();
         $log->writeLog($e, Config::LOGS);
     }
 }
Beispiel #2
0
    /**
     *  Статический метод, который записывает новые конфигурации в файле
     *  @param array $arrConst Массив новых значений для конфигурационного файла
     *  @param string $configClass Наименование класса конфигураций
     *  @param string $path Путь до файла конфигураций, который нужно переписать
     *  @return bool Вернет истину если удалось произвести запись в файл конфигураций
     */
    private static function writeConfig($arrConst, $configClass, $path)
    {
        $config = '<?php
	class ' . $configClass . '
	{
		';
        foreach ($arrConst as $k => $v) {
            $config .= 'const ' . $k . ' = "' . $v . '";
		';
        }
        $config .= '
	}';
        try {
            if (!file_put_contents($path, $config)) {
                throw new Exception('Возникла ошибка при попытке изменения файла конфигураций', 3);
            } else {
                return true;
            }
        } catch (Exception $e) {
            $log = Logger::getLog();
            $log->writeLog($e);
        }
    }
$log->logLine("Add Chapter 7.2.0.0");
// We went deep with Chapter 7.1.3.x, and sometimes the generating class knows exactly where it is anyway,
//  so instead of relying on multiple ->backLevel() calls, you can set the target level directly.
// This only works for going back in the hieracy. ->setCurrentLevel(1) (or less) equals ->rootLevel();
$book->setCurrentLevel(2);
$book->addChapter("Chapter 7.2", "Chapter00720.html", $content_start . "<h2>Chapter 7.2.0</h2>\n" . $chapter7Body, false, EPub::EXTERNAL_REF_ADD, $fileDir);
$log->logLine("Add Chapter 7.3.0.0");
$book->addChapter("Chapter 7.3", "Chapter00730.html", $content_start . "<h2>Chapter 7.3.0</h2>\n" . $chapter7Body, false, EPub::EXTERNAL_REF_ADD, $fileDir);
$log->logLine("Add Chapter 7.3.1.0");
$book->subLevel();
$book->addChapter("Chapter 7.3.1", "Chapter00731.html", $content_start . "<h2>Chapter 7.3.1</h2>\n" . $chapter7Body, false, EPub::EXTERNAL_REF_ADD, $fileDir);
// If you have nested chapters, you can call ->rootLevel() to return your hierachy to the root of the navMap.
$book->rootLevel();
$log->logLine("Add TOC");
$book->buildTOC();
$book->addChapter("Log", "Log.html", $content_start . $log->getLog() . "\n</pre>" . $bookEnd);
if ($book->isLogging) {
    // Only used in case we need to debug EPub.php.
    $epuplog = $book->getLog();
    $book->addChapter("ePubLog", "ePubLog.html", $content_start . $epuplog . "\n</pre>" . $bookEnd);
}
$book->finalize();
// Finalize the book, and build the archive.
// This is not really a part of the EPub class, but IF you have errors and want to know about them,
//  they would have been written to the output buffer, preventing the book from being sent.
//  This behaviour is desired as the book will then most likely be corrupt.
//  However you might want to dump the output to a log, this example section can do that:
/*
if (ob_get_contents() !== false && ob_get_contents() != '') {
   $f = fopen ('./log.txt', 'a') or die("Unable to open log.txt.");
   fwrite($f, "\r\n" . date("D, d M Y H:i:s T") . ": Error in " . __FILE__ . ": \r\n");
 /**
  * handle ePub
  */
 public function produceEpub()
 {
     Tools::logm('Starting to produce ePub 3 file');
     try {
         $content_start = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:epub=\"http://www.idpf.org/2007/ops\">\n" . "<head>" . "<meta http-equiv=\"Default-Style\" content=\"text/html; charset=utf-8\" />\n" . "<title>" . _("wallabag articles book") . "</title>\n" . "</head>\n" . "<body>\n";
         $bookEnd = "</body>\n</html>\n";
         $log = new Logger("wallabag", TRUE);
         $fileDir = CACHE;
         $book = new EPub(EPub::BOOK_VERSION_EPUB3, DEBUG_POCHE);
         $log->logLine("new EPub()");
         $log->logLine("EPub class version: " . EPub::VERSION);
         $log->logLine("EPub Req. Zip version: " . EPub::REQ_ZIP_VERSION);
         $log->logLine("Zip version: " . Zip::VERSION);
         $log->logLine("getCurrentServerURL: " . $book->getCurrentServerURL());
         $log->logLine("getCurrentPageURL..: " . $book->getCurrentPageURL());
         Tools::logm('Filling metadata for ePub...');
         $book->setTitle($this->bookTitle);
         $book->setIdentifier("http://{$_SERVER['HTTP_HOST']}", EPub::IDENTIFIER_URI);
         // Could also be the ISBN number, prefered for published books, or a UUID.
         //$book->setLanguage("en"); // Not needed, but included for the example, Language is mandatory, but EPub defaults to "en". Use RFC3066 Language codes, such as "en", "da", "fr" etc.
         $book->setDescription(_("Some articles saved on my wallabag"));
         $book->setAuthor($this->author, $this->author);
         $book->setPublisher("wallabag", "wallabag");
         // I hope this is a non existant address :)
         $book->setDate(time());
         // Strictly not needed as the book date defaults to time().
         //$book->setRights("Copyright and licence information specific for the book."); // As this is generated, this _could_ contain the name or licence information of the user who purchased the book, if needed. If this is used that way, the identifier must also be made unique for the book.
         $book->setSourceURL("http://{$_SERVER['HTTP_HOST']}");
         $book->addDublinCoreMetadata(DublinCore::CONTRIBUTOR, "PHP");
         $book->addDublinCoreMetadata(DublinCore::CONTRIBUTOR, "wallabag");
         $cssData = "body {\n margin-left: .5em;\n margin-right: .5em;\n text-align: justify;\n}\n\np {\n font-family: serif;\n font-size: 10pt;\n text-align: justify;\n text-indent: 1em;\n margin-top: 0px;\n margin-bottom: 1ex;\n}\n\nh1, h2 {\n font-family: sans-serif;\n font-style: italic;\n text-align: center;\n background-color: #6b879c;\n color: white;\n width: 100%;\n}\n\nh1 {\n margin-bottom: 2px;\n}\n\nh2 {\n margin-top: -2px;\n margin-bottom: 2px;\n}\n";
         $log->logLine("Add Cover");
         $fullTitle = "<h1> " . $this->bookTitle . "</h1>\n";
         $book->setCoverImage("Cover.png", file_get_contents("themes/_global/img/appicon/apple-touch-icon-152.png"), "image/png", $fullTitle);
         $cover = $content_start . '<div style="text-align:center;"><p>' . _('Produced by wallabag with PHPePub') . '</p><p>' . _('Please open <a href="https://github.com/wallabag/wallabag/issues" >an issue</a> if you have trouble with the display of this E-Book on your device.') . '</p></div>' . $bookEnd;
         //$book->addChapter("Table of Contents", "TOC.xhtml", NULL, false, EPub::EXTERNAL_REF_IGNORE);
         $book->addChapter("Notices", "Cover2.html", $cover);
         $book->buildTOC();
         Tools::logm('Adding actual content...');
         foreach ($this->entries as $entry) {
             //set tags as subjects
             $tags = $this->wallabag->store->retrieveTagsByEntry($entry['id']);
             foreach ($tags as $tag) {
                 $book->setSubject($tag['value']);
             }
             $log->logLine("Set up parameters");
             $chapter = $content_start . $entry['content'] . $bookEnd;
             $book->addChapter($entry['title'], htmlspecialchars($entry['title']) . ".html", $chapter, true, EPub::EXTERNAL_REF_ADD);
             $log->logLine("Added chapter " . $entry['title']);
         }
         if (DEBUG_POCHE) {
             $book->addChapter("Log", "Log.html", $content_start . $log->getLog() . "\n</pre>" . $bookEnd);
             // log generation
             Tools::logm('Production log available in produced file');
         }
         $book->finalize();
         $zipData = $book->sendBook($this->bookFileName);
         Tools::logm('Ebook produced');
     } catch (Exception $e) {
         Tools::logm('PHPePub has encountered an error : ' . $e->getMessage());
         $this->wallabag->messages->add('e', $e->getMessage());
     }
 }
Beispiel #5
0
 /**
  * handle epub
  */
 public function createEpub()
 {
     switch ($_GET['method']) {
         case 'id':
             $entryID = filter_var($_GET['id'], FILTER_SANITIZE_NUMBER_INT);
             $entry = $this->store->retrieveOneById($entryID, $this->user->getId());
             $entries = array($entry);
             $bookTitle = $entry['title'];
             $bookFileName = substr($bookTitle, 0, 200);
             break;
         case 'all':
             $entries = $this->store->retrieveAll($this->user->getId());
             $bookTitle = sprintf(_('All my articles on '), date(_('d.m.y')));
             #translatable because each country has it's own date format system
             $bookFileName = _('Allarticles') . date(_('dmY'));
             break;
         case 'tag':
             $tag = filter_var($_GET['tag'], FILTER_SANITIZE_STRING);
             $tags_id = $this->store->retrieveAllTags($this->user->getId(), $tag);
             $tag_id = $tags_id[0]["id"];
             // we take the first result, which is supposed to match perfectly. There must be a workaround.
             $entries = $this->store->retrieveEntriesByTag($tag_id, $this->user->getId());
             $bookTitle = sprintf(_('Articles tagged %s'), $tag);
             $bookFileName = substr(sprintf(_('Tag %s'), $tag), 0, 200);
             break;
         case 'category':
             $category = filter_var($_GET['category'], FILTER_SANITIZE_STRING);
             $entries = $this->store->getEntriesByView($category, $this->user->getId());
             $bookTitle = sprintf(_('All articles in category %s'), $category);
             $bookFileName = substr(sprintf(_('Category %s'), $category), 0, 200);
             break;
         case 'search':
             $search = filter_var($_GET['search'], FILTER_SANITIZE_STRING);
             $entries = $this->store->search($search, $this->user->getId());
             $bookTitle = sprintf(_('All articles for search %s'), $search);
             $bookFileName = substr(sprintf(_('Search %s'), $search), 0, 200);
             break;
         case 'default':
             die(_('Uh, there is a problem while generating epub.'));
     }
     $content_start = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n" . "<html xmlns=\"http://www.w3.org/1999/xhtml\" xmlns:epub=\"http://www.idpf.org/2007/ops\">\n" . "<head>" . "<meta http-equiv=\"Default-Style\" content=\"text/html; charset=utf-8\" />\n" . "<title>wallabag articles book</title>\n" . "</head>\n" . "<body>\n";
     $bookEnd = "</body>\n</html>\n";
     $log = new Logger("wallabag", TRUE);
     $fileDir = CACHE;
     $book = new EPub(EPub::BOOK_VERSION_EPUB3, DEBUG_POCHE);
     $log->logLine("new EPub()");
     $log->logLine("EPub class version: " . EPub::VERSION);
     $log->logLine("EPub Req. Zip version: " . EPub::REQ_ZIP_VERSION);
     $log->logLine("Zip version: " . Zip::VERSION);
     $log->logLine("getCurrentServerURL: " . $book->getCurrentServerURL());
     $log->logLine("getCurrentPageURL..: " . $book->getCurrentPageURL());
     $book->setTitle(_('wallabag\'s articles'));
     $book->setIdentifier("http://{$_SERVER['HTTP_HOST']}", EPub::IDENTIFIER_URI);
     // Could also be the ISBN number, prefered for published books, or a UUID.
     //$book->setLanguage("en"); // Not needed, but included for the example, Language is mandatory, but EPub defaults to "en". Use RFC3066 Language codes, such as "en", "da", "fr" etc.
     $book->setDescription(_("Some articles saved on my wallabag"));
     $book->setAuthor("wallabag", "wallabag");
     $book->setPublisher("wallabag", "wallabag");
     // I hope this is a non existant address :)
     $book->setDate(time());
     // Strictly not needed as the book date defaults to time().
     //$book->setRights("Copyright and licence information specific for the book."); // As this is generated, this _could_ contain the name or licence information of the user who purchased the book, if needed. If this is used that way, the identifier must also be made unique for the book.
     $book->setSourceURL("http://{$_SERVER['HTTP_HOST']}");
     $book->addDublinCoreMetadata(DublinCore::CONTRIBUTOR, "PHP");
     $book->addDublinCoreMetadata(DublinCore::CONTRIBUTOR, "wallabag");
     $cssData = "body {\n margin-left: .5em;\n margin-right: .5em;\n text-align: justify;\n}\n\np {\n font-family: serif;\n font-size: 10pt;\n text-align: justify;\n text-indent: 1em;\n margin-top: 0px;\n margin-bottom: 1ex;\n}\n\nh1, h2 {\n font-family: sans-serif;\n font-style: italic;\n text-align: center;\n background-color: #6b879c;\n color: white;\n width: 100%;\n}\n\nh1 {\n margin-bottom: 2px;\n}\n\nh2 {\n margin-top: -2px;\n margin-bottom: 2px;\n}\n";
     $log->logLine("Add Cover");
     $fullTitle = "<h1> " . $bookTitle . "</h1>\n";
     $book->setCoverImage("Cover.png", file_get_contents("themes/baggy/img/apple-touch-icon-152.png"), "image/png", $fullTitle);
     $cover = $content_start . '<div style="text-align:center;"><p>' . _('Produced by wallabag with PHPePub') . '</p><p>' . _('Please open <a href="https://github.com/wallabag/wallabag/issues" >an issue</a> if you have trouble with the display of this E-Book on your device.') . '</p></div>' . $bookEnd;
     //$book->addChapter("Table of Contents", "TOC.xhtml", NULL, false, EPub::EXTERNAL_REF_IGNORE);
     $book->addChapter("Notices", "Cover2.html", $cover);
     $book->buildTOC();
     foreach ($entries as $entry) {
         //set tags as subjects
         $tags = $this->store->retrieveTagsByEntry($entry['id']);
         foreach ($tags as $tag) {
             $book->setSubject($tag['value']);
         }
         $log->logLine("Set up parameters");
         $chapter = $content_start . $entry['content'] . $bookEnd;
         $book->addChapter($entry['title'], htmlspecialchars($entry['title']) . ".html", $chapter, true, EPub::EXTERNAL_REF_ADD);
         $log->logLine("Added chapter " . $entry['title']);
     }
     if (DEBUG_POCHE) {
         $epuplog = $book->getLog();
         $book->addChapter("Log", "Log.html", $content_start . $log->getLog() . "\n</pre>" . $bookEnd);
         // log generation
     }
     $book->finalize();
     $zipData = $book->sendBook($bookFileName);
 }