$switchLanguage .= "<p>\n"; $switchLanguage .= "<fieldset>\n"; $switchLanguage .= "<legend>" . $PMF_LANG["msgLangaugeSubmit"] . "</legend>\n"; $switchLanguage .= "<form action=\"" . $changeLanguagePath . "\" method=\"post\" style=\"display: inline;\">\n"; $switchLanguage .= "<select name=\"language\" size=\"1\">\n"; $switchLanguage .= $check4Lang; $switchLanguage .= "</select>\n"; $switchLanguage .= " \n"; $switchLanguage .= "<input class=\"submit\" type=\"submit\" name=\"submit\" value=\"" . $PMF_LANG["msgLangaugeSubmit"] . "\" />\n"; $switchLanguage .= "</fieldset>\n"; $switchLanguage .= "</form>\n"; $switchLanguage .= "</p>\n"; } // List all faq attachments if ($faqconfig->get('main.disableAttachments') && 'yes' == $faq->faqRecord['active']) { $attList = PMF_Attachment_Factory::fetchByRecordId($record_id); $outstr = ""; while (list(, $att) = each($attList)) { $outstr .= sprintf('<a href="%s">%s</a>, ', $att->buildUrl(), $att->getFilename()); } if (count($attList) > 0) { $content .= '<p>' . $PMF_LANG['msgAttachedFiles'] . ' ' . PMF_String::substr($outstr, 0, -2) . '</p>'; } } // List all categories for this faq $writeMultiCategories = ''; $multiCategories = array(); $categoryRelations = new PMF_Category_Relations(); foreach ($categoryRelations->fetchAll() as $relation) { if ($relation->record_id == $record_id) { $multiCategories[] = $relation->category_id;
/** * Deletes a record and all the dependencies * * @param integer $recordId Record id * @param string $recordLang Record language * * @return boolean */ public function deleteRecord($recordId, $recordLang) { $queries = array(sprintf("DELETE FROM %sfaqchanges WHERE beitrag = %d AND lang = '%s'", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqcategoryrelations WHERE record_id = %d AND record_lang = '%s'", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqdata WHERE id = %d AND lang = '%s'", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqdata_revisions WHERE id = %d AND lang = '%s'", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqvisits WHERE id = %d AND lang = '%s'", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqdata_user WHERE record_id = %d", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqdata_group WHERE record_id = %d", PMF_Db::getTablePrefix(), $recordId, $recordLang), sprintf("DELETE FROM %sfaqdata_tags WHERE record_id = %d", PMF_Db::getTablePrefix(), $recordId), sprintf('DELETE FROM %sfaqdata_tags WHERE %sfaqdata_tags.record_id NOT IN (SELECT %sfaqdata.id FROM %sfaqdata)', PMF_Db::getTablePrefix(), PMF_Db::getTablePrefix(), PMF_Db::getTablePrefix(), PMF_Db::getTablePrefix()), sprintf("DELETE FROM %sfaqcomments WHERE id = %d", PMF_Db::getTablePrefix(), $recordId), sprintf("DELETE FROM %sfaqvoting WHERE artikel = %d", PMF_Db::getTablePrefix(), $recordId)); foreach ($queries as $query) { $this->_config->getDb()->query($query); } // Delete possible attachments $attId = PMF_Attachment_Factory::fetchByRecordId($this->_config, $recordId); $attachment = PMF_Attachment_Factory::create($attId); $attachment->delete(); return true; }
if ($action == 'copyentry') { $faqData['lang'] = PMF_Filter::filterInput(INPUT_GET, 'lang', FILTER_SANITIZE_STRING); } if ($permission['addattachment']) { ?> <p> <label><?php print $PMF_LANG['ad_menu_attachments']; ?> :</label> <?php if (isset($faqData['id']) && $faqData['id'] != "") { ?> <ul class="adminAttachments"> <?php $attList = PMF_Attachment_Factory::fetchByRecordId($faqData['id']); foreach ($attList as $att) { printf('<li><a href="../%s">%s</a> ', $att->buildUrl(), $att->getFilename()); if ($permission['delattachment']) { printf('[ <a href="?action=delatt&record_id=%d&id=%d&lang=%s">%s</a> ]', $faqData['id'], $att->getId(), $faqData['lang'], $PMF_LANG['ad_att_del']); } print "</li>\n"; } printf('<li><a href="#;" onclick="addAttachment(\'attachment.php?record_id=%d&record_lang=%s&rubrik=%d\', \'Attachment\', 550, 130); return false;">%s</a></li>', $faqData['id'], $faqData['lang'], $selectedCategory, $PMF_LANG['ad_att_add']); ?> </ul> <?php } else { print $PMF_LANG['ad_att_nope']; } ?>
foreach ($arrLanguage as $language) { $check4Lang .= "<option value=\"" . $language . "\""; $check4Lang .= $lang == $language ? ' selected="selected"' : ''; $check4Lang .= ">" . $languageCodes[strtoupper($language)] . "</option>\n"; } $switchLanguage .= "<form accept-charset=\"utf-8\" action=\"" . $changeLanguagePath . "\" method=\"post\" style=\"display: inline;\">\n"; $switchLanguage .= "<select name=\"artlang\" size=\"1\">\n"; $switchLanguage .= $check4Lang; $switchLanguage .= "</select>\n"; $switchLanguage .= " \n"; $switchLanguage .= "<input class=\"submit\" type=\"submit\" name=\"submit\" value=\"" . $PMF_LANG["msgLangaugeSubmit"] . "\" />\n"; $switchLanguage .= "</form>\n"; } // List all faq attachments if ($faqConfig->get('records.disableAttachments') && 'yes' == $faq->faqRecord['active']) { $attList = PMF_Attachment_Factory::fetchByRecordId($faqConfig, $recordId); $outstr = ''; while (list(, $att) = each($attList)) { $outstr .= sprintf('<a href="%s">%s</a>, ', $att->buildUrl(), $att->getFilename()); } if (count($attList) > 0) { $answer .= '<p>' . $PMF_LANG['msgAttachedFiles'] . ' ' . PMF_String::substr($outstr, 0, -2) . '</p>'; } } // List all categories for this faq $htmlAllCategories = ''; $multiCategories = $category->getCategoriesFromArticle($recordId); if (count($multiCategories) > 1) { foreach ($multiCategories as $multiCat) { $path = $category->getPath($multiCat['id'], ' » ', true, 'breadcrumb-related-categories'); if ('' === trim($path)) {