/** * This function generates the list with the five latest published records * * @param string * @return string * @access public * @author Thorsten Rinne <*****@*****.**> * @since 2002-05-07 */ function generateFiveNewest($language = '') { global $PMF_LANG; $result = generateNewestData($language, PMF_NUMBER_RECORDS_LATEST); if (count($result) > 0) { $output = '<ol>'; foreach ($result as $row) { $output .= '<li><a href="' . $row['url'] . '">' . makeShorterText(PMF_htmlentities($row['thema'], ENT_NOQUOTES, $PMF_LANG['metaCharset']), 8) . '</a> (' . makeDate($row['datum']) . ')</li>'; } $output .= '</ol>'; } else { $output = $PMF_LANG["err_noArticles"]; } return $output; }
require_once PMF_ROOT_DIR . "/lang/" . $PMF_CONF["language"]; $query = 'SELECT ' . SQLPREFIX . 'faqdata.id AS id, ' . SQLPREFIX . 'faqdata.lang AS lang, ' . SQLPREFIX . 'faqdata.thema AS thema, ' . SQLPREFIX . 'faqcategoryrelations.category_id AS category_id, ' . SQLPREFIX . 'faqvisits.visits AS visits, ' . SQLPREFIX . 'faqdata.datum AS datum, ' . SQLPREFIX . 'faqvisits.last_visit AS last_visit FROM ' . SQLPREFIX . 'faqvisits, ' . 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.id = ' . SQLPREFIX . 'faqvisits.id AND ' . SQLPREFIX . 'faqdata.lang = ' . SQLPREFIX . 'faqvisits.lang AND ' . SQLPREFIX . 'faqdata.active = \'yes\' ORDER BY ' . SQLPREFIX . 'faqvisits.visits DESC'; $result = $db->query($query); $rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG["msgTopTen"]) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/topten/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($db->num_rows($result) > 0) { $i = 1; $counter = 0; $oldId = 0; while (($row = $db->fetch_object($result)) && $counter < 10) { $counter++; if ($oldId != $row->id) { $rss .= "\t<item>\n"; $rss .= "\t\t<title><![CDATA[" . makeShorterText($row->thema, 8) . " (" . $row->visits . " " . $PMF_LANG["msgViews"] . ")]]></title>\n"; $rss .= "\t\t<description><![CDATA[[" . $i . ".] " . $row->thema . " (" . $row->visits . " " . $PMF_LANG["msgViews"] . ")]]></description>\n"; $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("feed/topten/rss.php", "index.php", $_SERVER["PHP_SELF"]) . "?action=artikel&cat=" . $row->category_id . "&id=" . $row->id . "&artlang=" . $row->lang . "</link>\n"; $rss .= "\t\t<!-- The real FAQ publication date -->\n"; // $$row->datum is a phpMyFAQ date $rss .= "\t\t<!-- " . makeRFC822Date($row->datum) . " -->\n"; // $row->last_visit is a mktime timpestamp date $rss .= "\t\t<pubDate>" . makeRFC822Date($row->last_visit, false) . "</pubDate>\n"; $rss .= "\t</item>\n"; $i++; } $oldId = $row->id; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml");
function arrayToFacic($dataCollection) { if (is_array($dataCollection)) { reset($dataCollection); $data = array(); if ($_GET['debug'] == 'yes') { var_dump($dataCollection); } while (list($key, $val) = each($dataCollection)) { $INV = implode('; ', $dataCollection[$key]["917"]); $data[] = array("MFN" => $dataCollection[$key]["mfn"], "SEQN" => $dataCollection[$key]["920"], "teste" => $dataCollection[$key]["920"], "previous" => $dataCollection[$key - 1]["920"], "YEAR" => $dataCollection[$key]["911"], "VOLU" => $dataCollection[$key]["912"], "FASC" => $dataCollection[$key]["913"], "TYPE" => $dataCollection[$key]["916"] == NULL || $dataCollection[$key]["916"] == 'null' ? '' : $dataCollection[$key]["916"], "INVENTORY" => $INV ? $INV : '', "STAT" => $dataCollection[$key]["914"], "QTD" => $dataCollection[$key]["915"], "FORMERSTAT" => $dataCollection[$key]["914"], "FORMERQTD" => $dataCollection[$key]["915"], "MASK" => $dataCollection[$key]["910"], "NOTE" => makeShorterText($dataCollection[$key]["900"], 30)); } } return $data; }
require_once PMF_ROOT_DIR . "/lang/" . $PMF_CONF["language"]; // Get the open questions result set with a time descedant order (the first is the last entered) $query = "SELECT id, ask_username, ask_usermail, ask_rubrik, ask_content, ask_date FROM " . SQLPREFIX . "faqfragen ORDER BY ask_date DESC"; $result = $db->query($query); $rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG['msgOpenQuestions']) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/openquestions/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($num = $db->num_rows($result) > 0) { $counter = 0; while (($row = $db->fetch_object($result)) && $counter < PMF_RSS_OPENQUESTIONS_MAX) { $counter++; $rss .= "\t<item>\n"; // Get the content $content = $row->ask_content; $rss .= "\t\t<title><![CDATA[" . makeShorterText($row->ask_content, 8) . " (" . $row->ask_username . ")]]></title>\n"; $rss .= "\t\t<description><![CDATA[" . $content . "]]></description>\n"; // Let the PMF administrator manually choose between (1) (default) and (2) // 1. This link below goes to the "Open questions page" $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("feed/openquestions/rss.php", "index.php", $_SERVER["PHP_SELF"]) . "?action=open#openq_" . $row->id . "</link>\n"; // 2. This link below is a shortcut for a fast reply ("Add content" page within the context of the current question) //$rss .= "\t\t<link><![CDATA[http".(isset($_SERVER['HTTPS']) ? 's' : '')."://".$_SERVER["HTTP_HOST"].str_replace("feed/openquestions/rss.php", "index.php", $_SERVER["PHP_SELF"])."?action=add&question=".rawurlencode($content)."&cat=".$row->ask_rubrik."]]></link>\n"; $rss .= "\t\t<pubDate>" . makeRFC822Date($row->ask_date) . "</pubDate>\n"; $rss .= "\t</item>\n"; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml"); header("Content-Length: " . strlen($rss)); print $rss; $db->dbclose();
/** * The header of the PDF file * * @return void * @access private */ function Header() { $title = $this->categories[$this->category]["name"] . ": " . $this->thema; $currentTextColor = $this->TextColor; $this->SetTextColor(0, 0, 0); $this->SetFont("Arial", "I", 18); $this->MultiCell(0, 9, $title, 1, 1, "C", 1); $this->Ln(8); if ($this->enableBookmarks == true) { $this->Bookmark(makeShorterText($this->thema, 5)); } $this->TextColor = $currentTextColor; }
function getIssues($titleId, $sort) { $dataCollection = $this->setRecodsByTitle($titleId, 'all'); if (is_array($dataCollection)) { reset($dataCollection); $data = array(); while (list($key, $val) = each($dataCollection)) { $issue = new facicData(); $issue->set_mfn($dataCollection[$key]["mfn"]); $issue->set_year($dataCollection[$key]["911"]); $issue->set_vol($dataCollection[$key]["912"]); $issue->set_num($dataCollection[$key]["913"]); $issue->set_type($dataCollection[$key]["916"]); $issue->set_status($dataCollection[$key]["914"]); $issue->setData('sequentialNumber', $dataCollection[$key]["920"]); $issue->set_qtd($dataCollection[$key]["915"]); $issue->set_mask($dataCollection[$key]["910"]); $issue->set_note(makeShorterText($dataCollection[$key]["900"], 30)); $issue->set_idmfn($dataCollection[$key]["mfn"]); $data[] = $issue; } } return $data; }
</script> <script type="text/javascript" src="editor/htmlarea.js"></script> <script type="text/javascript" src="editor/plugins/ImageManager/image-manager.js"></script> <script type="text/javascript"> //<![CDATA[ HTMLArea.init(); HTMLArea.loadPlugin('ImageManager'); HTMLArea.onload = function() { var editor = new HTMLArea('content'); var config = new HTMLArea.Config(); var phpMyFAQLinks = { <?php $output = "'Include internal links' : '',\n"; $result = $db->query('SELECT ' . SQLPREFIX . 'faqdata.id AS id, ' . SQLPREFIX . 'faqdata.lang AS lang, ' . SQLPREFIX . 'faqcategoryrelations.category_id AS category_id, ' . SQLPREFIX . 'faqdata.thema AS thema FROM ' . SQLPREFIX . 'faqdata LEFT JOIN ' . SQLPREFIX . 'faqcategoryrelations ON ' . SQLPREFIX . 'faqdata.id = ' . SQLPREFIX . 'faqcategoryrelations.record_id AND ' . SQLPREFIX . 'faqdata.lang = ' . SQLPREFIX . 'faqcategoryrelations.record_lang ORDER BY ' . SQLPREFIX . 'faqcategoryrelations.category_id, ' . SQLPREFIX . 'faqdata.id'); while ($row = $db->fetch_object($result)) { $_title = makeShorterText(addslashes(PMF_htmlentities(str_replace(array("\n", "\r", "\r\n"), "", $row->thema), ENT_NOQUOTES, $PMF_LANG['metaCharset'])), 8); $output .= sprintf("'%s' : '<a href=\"index.php?action=artikel&cat=%d&id=%d&artlang=%s\">%s<\\/a>',\n", $_title, $row->category_id, $row->id, $row->lang, $_title); } $output = substr($output, 0, -2); print $output; ?> }; var internalLinks = { id : 'internalLinks', tooltip : 'internal Link', options : phpMyFAQLinks, action : function(editor) { var elem = editor._toolbarObjects[this.id].element; editor.insertHTML(elem.value);
require_once PMF_ROOT_DIR . "/inc/category.php"; require_once PMF_ROOT_DIR . "/lang/" . $PMF_CONF["language"]; $query = 'SELECT ' . SQLPREFIX . 'faqdata.id AS id, ' . SQLPREFIX . 'faqdata.lang AS lang, ' . SQLPREFIX . 'faqcategoryrelations.category_id AS category_id, ' . SQLPREFIX . 'faqdata.thema AS thema, ' . SQLPREFIX . 'faqdata.content AS content, ' . SQLPREFIX . 'faqdata.datum AS datum, ' . SQLPREFIX . 'faqvisits.visits AS visits FROM ' . SQLPREFIX . 'faqvisits, ' . 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.id = ' . SQLPREFIX . 'faqvisits.id AND ' . SQLPREFIX . 'faqdata.lang = ' . SQLPREFIX . 'faqvisits.lang AND ' . SQLPREFIX . 'faqdata.active = \'yes\' ORDER BY ' . SQLPREFIX . 'faqdata.datum DESC'; $result = $db->query($query); $rss = "<?xml version=\"1.0\" encoding=\"" . $PMF_LANG["metaCharset"] . "\" standalone=\"yes\" ?>\n<rss version=\"2.0\">\n<channel>\n"; $rss .= "<title>" . htmlspecialchars($PMF_CONF["title"]) . " - " . htmlspecialchars($PMF_LANG['msgLatestArticles']) . "</title>\n"; $rss .= "<description>" . htmlspecialchars($PMF_CONF["metaDescription"]) . "</description>\n"; $rss .= "<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("/feed/latest/rss.php", "", $_SERVER["PHP_SELF"]) . "</link>"; if ($num = $db->num_rows($result) > 0) { $counter = 0; $oldId = 0; while (($row = $db->fetch_object($result)) && $counter < 5) { $counter++; if ($oldId != $row->id) { $rss .= "\t<item>\n"; $rss .= "\t\t<title><![CDATA[" . makeShorterText($row->thema, 8) . "]]></title>\n"; // Get the content $content = $row->content; // Fix the content internal image references $content = str_replace("<img src=\"/", "<img src=\"http" . (isset($_SERVER["HTTPS"]) ? "s" : "") . "://" . $_SERVER["HTTP_HOST"] . "/", $content); $rss .= "\t\t<description><![CDATA[<p><b>" . $row->thema . "</b> <em>(" . $row->visits . " " . $PMF_LANG["msgViews"] . ")</em></p>" . $content . "]]></description>\n"; $rss .= "\t\t<link>http" . (isset($_SERVER['HTTPS']) ? 's' : '') . "://" . $_SERVER["HTTP_HOST"] . str_replace("feed/latest/rss.php", "index.php", $_SERVER["PHP_SELF"]) . "?action=artikel&cat=" . $row->category_id . "&id=" . $row->id . "&artlang=" . $row->lang . "</link>\n"; $rss .= "\t\t<pubDate>" . makeRFC822Date($row->datum) . "</pubDate>\n"; $rss .= "\t</item>\n"; } $oldId = $row->id; } } $rss .= "</channel>\n</rss>"; header("Content-Type: text/xml"); header("Content-Length: " . strlen($rss));
/** * Funcao que busca os dados na base de dados MASK * e ordena os dados para enviar ao YUI exibir uma lista * com os dados da base MASK * @param array dataCollection * @return array with DB data */ function arrayToMask($dataCollection) { if (is_array($dataCollection)) { reset($dataCollection); $data = array(); while (list($key, $val) = each($dataCollection)) { switch ($_SESSION["lang"]) { case 'pt': $noteMask = makeShorterText($dataCollection[$key]["900"][2], 30); break; case 'es': $noteMask = makeShorterText($dataCollection[$key]["900"][3], 30); break; case 'en': $noteMask = makeShorterText($dataCollection[$key]["900"][0], 30); break; case 'fr': $noteMask = makeShorterText($dataCollection[$key]["900"][1], 30); break; } $data[] = array("MFN" => $dataCollection[$key]["mfn"], "MASK" => $dataCollection[$key]["801"], "NOTE" => $noteMask, "usedMask" => $dataCollection[$key]["113"]); } } return $data; }