Viewing file:  export.main.php (6.07 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/**
* $Id: export.main.php,v 1.14.2.11.2.7 2007/04/24 20:28:55 matteo Exp $
*
* XML, XML DocBook, XHTML and PDF export - main page
*
* @author Thorsten Rinne <thorsten@phpmyfaq.de>
* @author Peter Beauvain <pbeauvain@web.de>
* @since 2003-04-17
* @copyright (c) 2003-2007 phpMyFAQ Team
*
* The contents of this file are subject to the Mozilla Public License
* Version 1.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.mozilla.org/MPL/
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*/
if (!defined('IS_VALID_PHPMYFAQ_ADMIN')) {
header('Location: http://'.$_SERVER['SERVER_NAME'].dirname($_SERVER['SCRIPT_NAME']));
exit();
}
?>
<h2><?php print $PMF_LANG["ad_menu_export"]; ?></h2>
<?php
if (isset($_REQUEST["submit"])) {
$submit = $_REQUEST["submit"];
}
if (isset($submit[0])) {
$tree = new Category();
generateXMLFile();
print "<p><a href=\"../xml/phpmyfaq.xml\" target=\"_blank\">XML File okay!</a></p>";
}
if (isset($submit[1])) {
$tree = new Category();
generateXHTMLFile();
print "<p><a href=\"../xml/phpmyfaq.html\" target=\"_blank\">XHTML File okay!</a></p>";
}
if (isset($submit[2])) {
// Full PDF Export
require (PMF_ROOT_DIR."/inc/pdf.php");
$tree = new Category();
$arrRubrik = array();
$arrThema = array();
$arrContent = array();
$result = $db->query('SELECT '.SQLPREFIX.'faqdata.id AS id, '.SQLPREFIX.'faqdata.lang AS lang, '.SQLPREFIX.'faqdata.solution_id AS solution_id, '.SQLPREFIX.'faqcategoryrelations.category_id AS category_id, '.SQLPREFIX.'faqdata.thema AS thema, '.SQLPREFIX.'faqdata.content AS content, '.SQLPREFIX.'faqdata.author AS author, '.SQLPREFIX.'faqdata.datum AS datum FROM '.SQLPREFIX.'faqdata LEFT JOIN '.SQLPREFIX.'faqcategoryrelations ON '.SQLPREFIX.'faqdata.id = '.SQLPREFIX.'faqcategoryrelations.record_id AND '.SQLPREFIX.'faqdata.lang = '.SQLPREFIX.'faqcategoryrelations.record_lang WHERE '.SQLPREFIX.'faqdata.active = \'yes\' ORDER BY '.SQLPREFIX.'faqcategoryrelations.category_id, '.SQLPREFIX.'faqdata.id');
if ($db->num_rows($result) > 0) {
$i = 0;
while ($row = $db->fetch_object($result)) {
$arrRubrik[$i] = $row->category_id;
$arrThema[$i] = $row->thema;
$arrContent[$i] = $row->content;
$arrDatum[$i] = $row->datum;
$arrAuthor[$i] = $row->author;
$i++;
}
}
$pdf = new PDF();
$pdf->enableBookmarks = TRUE;
$pdf->Open();
$pdf->AliasNbPages();
$pdf->SetDisplayMode("real");
foreach ($arrContent as $key => $value) {
$pdf->category = $arrRubrik[$key];
$pdf->thema = $arrThema[$key];
$pdf->categories = $tree->categoryName;
$date = $arrDatum[$key];
$author = $arrAuthor[$key];
$pdf->AddPage();
$pdf->SetFont("Arial", "", 12);
$pdf->WriteHTML(unhtmlentities($value));
}
$pdfFile = PMF_ROOT_DIR."/pdf/faq.pdf";
$pdf->Output($pdfFile);
print "<p>".$PMF_LANG["ad_export_full_faq"]."<a href=\"../pdf/faq.pdf\" target=\"_blank\">".PMF_htmlentities($PMF_CONF["title"], ENT_QUOTES, $PMF_LANG['metaCharset'])."</a></p>";
}
if (isset($submit[3])) {
// XML DocBook export
require (PMF_ROOT_DIR."/inc/docbook.php");
$parentID = 0;
$rubrik = 0;
$sql = '';
$selectString ='';
$export = new DocBook_XML_Export($DB);
$export->delete_file();
// Set the FAQ title
$faqtitel = htmlspecialchars($PMF_CONF["title"]);
// Print the title of the FAQ
$export-> xmlContent='<?xml version="1.0" encoding="'.$PMF_LANG['metaCharset'].'"?>'
.'<book lang="en">'
.'<title> phpMyFAQ </title>'
.'<bookinfo>'
.'<title>'. $faqtitel. '</title>'
.'</bookinfo>';
// include the news
$result = $db->query("SELECT id, header, artikel, datum FROM ".SQLPREFIX."faqnews");
// Write XML file
$export->write_file();
// Transformation of the news entries
if ($db->num_rows($result) > 0)
{
$export->xmlContent.='<part><title>News</title>';
while ($row = $db->fetch_object($result)){
$datum = $export->aktually_date($row->datum);
$export->xmlContent .='<article>'
. '<title>'.$row->header.'</title>'
. '<para>'.wordwrap($datum,20).'</para>';
$replacedString = ltrim(ereg_replace('<br />','',$row->artikel));
$export->TableImageText($replacedString);
$export->xmlContent.='</article>';
}
$export->xmlContent .= '</part>';
}
$export->write_file();
// Transformation of the articles
$export->xmlContent .='<part>'
. '<title>Artikel</title>'
. '<preface>'
. '<title>Rubriken</title>';
// Selection of the categories
$export->recursive_category($parentID);
$export->xmlContent .='</preface>'
. '</part>'
. '</book>';
$export->write_file();
print "<p>XML DocBook file: <a href=\"../xml/docbook/docbook.xml\" target=\"_blank\">".PMF_htmlentities($PMF_CONF["title"], ENT_QUOTES, $PMF_LANG['metaCharset'])."</a></p>";
}
if (!emptyTable(SQLPREFIX."faqdata")) {
?>
<form action="<?php print $_SERVER["PHP_SELF"].$linkext; ?>" method="post">
<input type="hidden" name="aktion" value="export" />
<fieldset>
<legend><?php print $PMF_LANG["ad_menu_export"]; ?></legend>
<label class="left">XML export</label>
<input class="submit" type="submit" name="submit[0]" value="XML export" /><br /><br />
<label class="left">XHTML export</label>
<input class="submit" type="submit" name="submit[1]" value="XHTML export" /><br /><br />
<label class="left"><?php print $PMF_LANG["ad_export_pdf"]; ?></label>
<input class="submit" type="submit" name="submit[2]" value="<?php print $PMF_LANG["ad_export_generate_pdf"]; ?>" /><br /><br />
<label class="left">XML DocBook export</label>
<input class="submit" type="submit" name="submit[3]" value="XML DocBook export" /><br />
</fieldset>
</form>
<?php
} else {
print $PMF_LANG["err_noArticles"];
}
|