Ejemplos de PMF_Attachment_Factory::fetchByRecordId en PHP

Ejemplo n.º 1

Archivo: artikel.php Proyecto: nosch/phpMyFAQ

    $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 .= "&nbsp;\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;

Ejemplo n.º 2

Archivo: Faq.php Proyecto: kapljr/Jay-Kaplan-Farmingdale-BCS-Projects

 /**
  * 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;
 }

Ejemplo n.º 3

Archivo: record.edit.php Proyecto: atlcurling/tkt

    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&amp;record_id=%d&amp;id=%d&amp;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&amp;record_lang=%s&amp;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'];
        }
        ?>

Ejemplo n.º 4

Archivo: artikel.php Proyecto: ae120/phpMyFAQ

    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 .= "&nbsp;\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'], ' &raquo; ', true, 'breadcrumb-related-categories');
        if ('' === trim($path)) {