示例#1
0
function gf_showattachments($topic, $mode = '')
{
    global $_TABLES, $_CONF, $CONF_FORUM, $_FM_TABLES;
    $retval = '';
    $sql = "SELECT id,repository_id,filename FROM {$_TABLES['gf_attachments']} WHERE topic_id={$topic} ";
    if ($mode != 'edit') {
        $sql .= "AND show_inline=0 ";
    }
    $sql .= "ORDER BY id";
    $query = DB_query($sql);
    $i = 1;
    while (list($id, $lid, $field_value) = DB_fetchArray($query)) {
        $retval .= '<div class="forum_attachment">';
        if ($mode == 'edit') {
            $retval .= '&nbsp;' . $i . '&nbsp;';
        }
        $filename = explode(':', $field_value);
        // Check and see if the file is in the File Mgmt plugin and if user has access
        if ($CONF_FORUM['filestorage_plugin'] == 'filemgmt' and $lid > 0) {
            $groupsql = filemgmt_buildAccessSql();
            $sql = "SELECT COUNT(*) FROM {$_FM_TABLES['filemgmt_filedetail']} a ";
            $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid ";
            $sql .= "WHERE a.lid='{$lid}' {$groupsql}";
            list($testaccess_cnt) = DB_fetchArray(DB_query($sql));
        } elseif ($CONF_FORUM['filestorage_plugin'] == 'nexfile' and $lid > 0) {
            $cid = DB_getItem($_TABLES['nxfile_files'], 'cid', "fid={$lid}");
            if (fm_getPermission($cid, 'view')) {
                $testaccess_cnt = 1;
            } else {
                $testaccess_cnt = 0;
            }
        }
        if ($lid > 0 and $testaccess_cnt == 0) {
            $retval .= "<img src=\"{$CONF_FORUM['imgset']}/document_sm.gif\" border=\"0\">Insufficent Access";
        } elseif (!empty($field_value)) {
            $retval .= "<img src=\"{$CONF_FORUM['imgset']}/document_sm.gif\" border=\"0\">";
            $retval .= "<a href=\"{$_CONF['site_url']}/forum/getattachment.php?id={$id}\" target=\"_new\">";
            $retval .= "{$filename[1]}</a>&nbsp;";
            if ($mode == 'edit') {
                $retval .= "<a href=\"#\" onClick='ajaxDeleteFile({$topic},{$id});'>";
                $retval .= "<img src=\"{$CONF_FORUM['imgset']}/delete.gif\" border=\"0\"></a>";
            }
        } else {
            $retval .= 'N/A&nbsp;';
        }
        $retval .= '</div>';
        $i++;
    }
    return $retval;
}
示例#2
0
 } else {
     $p = new Template($_CONF['path'] . 'plugins/filemgmt/templates');
     $p->set_file(array('page' => 'filelisting.thtml', 'records' => 'filelisting_record.thtml', 'category' => 'filelisting_category.thtml'));
     $p->set_var('layout_url', $_CONF['layout_url']);
     $p->set_var('site_url', $_CONF['site_url']);
     $p->set_var('site_admin_url', $_CONF['site_admin_url']);
     $p->set_var('xhtml', XHTML);
     $p->set_var('target', $CONF_FM['ignore_target'] ? '' : 'target="_blank"');
     $p->set_var('imgset', $_CONF['layout_url'] . '/nexflow/images');
     $p->set_var('tablewidth', $mydownloads_shotwidth + 10);
     $page = COM_applyFilter($_GET['page'], true);
     if (!isset($page) or $page == 0) {
         $page = 1;
     }
     $show = $mydownloads_perpage;
     $groupsql = filemgmt_buildAccessSql();
     $sql = "SELECT cid, title, imgurl, grp_access " . "FROM {$_FM_TABLES['filemgmt_cat']} WHERE pid = 0 " . $groupsql . " ORDER BY cid";
     $result = DB_query($sql);
     $nrows = DB_numRows($result);
     // Need to use a SQL stmt that does a join on groups user has access to  - for file count
     $sql = "SELECT count(*) FROM {$_FM_TABLES['filemgmt_filedetail']} a ";
     $sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid WHERE status > 0 ";
     $sql .= $groupsql;
     $countsql = DB_query($sql);
     list($maxrows) = DB_fetchArray($countsql);
     $numpages = ceil($maxrows / $show);
     $p->set_var('block_header', COM_startBlock(sprintf(_MD_LISTINGHEADING, $maxrows)));
     $p->set_var('block_footer', COM_endBlock());
     $count = 0;
     if ($nrows > 0) {
         // Display the categories - Top Level (plus #files) with links to sub categories
示例#3
0
function _ff_showattachments($topic, $mode = '')
{
    global $_TABLES, $_CONF, $_FF_CONF;
    $retval = '';
    $sql = "SELECT id,repository_id,filename FROM {$_TABLES['ff_attachments']} WHERE topic_id=" . (int) $topic . " ";
    if ($mode != 'edit') {
        $sql .= "AND show_inline=0 ";
    }
    $sql .= "ORDER BY id";
    $query = DB_query($sql);
    // Check and see if the filemgmt plugin is installed and enabled
    if (function_exists('filemgmt_buildAccessSql')) {
        $filemgmtSupport = true;
    } else {
        $filemgmtSupport = false;
    }
    while (list($id, $lid, $field_value) = DB_fetchArray($query)) {
        $retval .= '<div class="tblforumfile">';
        $filename = explode(':', $field_value);
        if ($filemgmtSupport and $lid > 0) {
            // Check and see if user has access to file
            $groupsql = filemgmt_buildAccessSql();
            $sql = "SELECT COUNT(*) FROM {$_TABLES['filemgmt_filedetail']} a ";
            $sql .= "LEFT JOIN {$_TABLES['filemgmt_cat']} b ON a.cid=b.cid ";
            $sql .= "WHERE a.lid='{$lid}' {$groupsql}";
            list($testaccess_cnt) = DB_fetchArray(DB_query($sql));
        }
        if ($lid > 0 and (!$filemgmtSupport or $testaccess_cnt == 0 or DB_count($_TABLES['filemgmt_filedetail'], "lid", $lid) == 0)) {
            $retval .= "<img src=\"{$_CONF['site_url']}/forum/images/document_sm.gif\" border=\"0\" alt=\"\"/>Insufficent Access";
        } elseif (!empty($field_value)) {
            $retval .= "<img src=\"{$_CONF['site_url']}/forum/images/document_sm.gif\" border=\"0\" alt=\"\"/>";
            $retval .= "<a href=\"{$_CONF['site_url']}/forum/getattachment.php?id={$id}\" target=\"_new\">";
            $retval .= "{$filename[1]}</a>&nbsp;";
            if ($mode == 'edit') {
                $retval .= "<a href=\"#\" onclick='ajaxDeleteFile({$topic},{$id});'>";
                $retval .= "<img src=\"{$_CONF['site_url']}/forum/images/delete.gif\" border=\"0\" alt=\"\"/></a>";
            }
        } else {
            $retval .= 'N/A&nbsp;';
        }
        $retval .= '</div>';
    }
    return $retval;
}