예제 #1
0
 $myrow = DB_fetchArray($result);
 $secGroup = DB_getItem($_TABLES['groups'], "grp_name", "grp_id='{$myrow['grp_access']}'");
 if (SEC_inGroup($secGroup)) {
     $p->set_var('cid', $myrow['cid']);
     $p->set_var('category_name', $myts->makeTboxData4Show($myrow['title']));
     if ($mydownloads_useshots && $myrow['imgurl'] && $myrow['imgurl'] != "http://") {
         $imgurl = $myts->makeTboxData4Edit($myrow['imgurl']);
         $category_image_link = '<a href="' . $_CONF[site_url] . '/filemgmt/viewcat.php?cid=' . $myrow['cid'] . '">' . '<img src="' . $filemgmt_SnapCatURL . $imgurl . '" width="' . $mydownloads_shotwidth . '" style="border:none;" alt=""' . XHTML . '></a>';
         $p->set_var('category_link', $category_image_link);
     } else {
         $p->set_var('category_link', '');
     }
     $downloadsWaitingSubmission = getTotalItems($myrow['cid'], 0);
     $p->set_var('num_files', getTotalItems($myrow['cid'], 1));
     if ($downloadsWaitingSubmission > 0) {
         $p->set_var('files_waiting_submission', '(' . getTotalItems($myrow['cid'], 0) . ')');
     } else {
         $p->set_var('files_waiting_submission', '');
     }
     // get child category objects
     $subcategories = '';
     $arr = array();
     $arr = $mytree->getFirstChild($myrow['cid'], 'title');
     $space = 0;
     $chcount = 0;
     foreach ($arr as $ele) {
         $chtitle = $myts->makeTboxData4Show($ele['title']);
         if ($chcount >= $numSubCategories2Show) {
             $subcategories .= "...";
             break;
         }
예제 #2
0
//  ------------------------------------------------------------------------ //
include "header.php";
$myts =& MyTextSanitizer::getInstance();
// MyTextSanitizer object
include_once XOOPS_ROOT_PATH . "/class/xoopstree.php";
$mytree = new XoopsTree($xoopsDB->prefix("mylinks_cat"), "cid", "pid");
$xoopsOption['template_main'] = 'mylinks_index.html';
include XOOPS_ROOT_PATH . "/header.php";
$result = $xoopsDB->query("SELECT cid, title, imgurl FROM " . $xoopsDB->prefix("mylinks_cat") . " WHERE pid = 0 ORDER BY title") or exit("Error");
$count = 1;
while ($myrow = $xoopsDB->fetchArray($result)) {
    $imgurl = '';
    if ($myrow['imgurl'] && $myrow['imgurl'] != "http://") {
        $imgurl = $myts->makeTboxData4Edit($myrow['imgurl']);
    }
    $totallink = getTotalItems($myrow['cid'], 1);
    // get child category objects
    $arr = array();
    $arr = $mytree->getFirstChild($myrow['cid'], "title");
    $space = 0;
    $chcount = 0;
    $subcategories = '';
    foreach ($arr as $ele) {
        $chtitle = $myts->makeTboxData4Show($ele['title']);
        if ($chcount > 5) {
            $subcategories .= "...";
            break;
        }
        if ($space > 0) {
            $subcategories .= ", ";
        }
예제 #3
0
$orderby = convertorderbyin($orderby);
$pathstring = '<a href="index.php">' . _MD_MAIN . '</a>&nbsp;:&nbsp;';
$nicepath = $mytree->getNicePathFromId($cid, "title", "{$_CONF['site_url']}/filemgmt/viewcat.php");
$pathstring .= $nicepath;
$p->set_var('category_path_link', $pathstring);
$p->set_var('cid', $cid);
// get child category objects
$subcategories = '';
$arr = array();
$arr = $mytree->getFirstChild($cid, 'title');
if (count($arr) > 0) {
    $count = 1;
    foreach ($arr as $ele) {
        $totalfiles = 0;
        $chtitle = $myts->makeTboxData4Show($ele['title']);
        $totalfiles = $totalfiles + getTotalItems($ele['cid'], 1);
        $subcategories = '<a href="' . $_CONF[site_url] . '/filemgmt/viewcat.php?cid=' . $ele['cid'] . '">' . $chtitle . '</a>&nbsp;(' . $totalfiles . ')&nbsp;&nbsp;';
        $p->set_var('subcategories', $subcategories);
        $p->set_var('new_table_row', $count == 1 ? '<tr>' : '');
        $p->set_var('end_of_row', $count == $numCategoriesPerRow ? '</tr>' : '');
        $count = $count == $numCategoriesPerRow ? 1 : $count + 1;
        $p->parse('category_records', 'category', true);
    }
} else {
    $p->set_var('subcategories', '');
    $p->set_var('new_table_row', '<tr>');
    $p->set_var('end_of_row', '</tr>');
    $p->parse('category_records', 'category');
}
$sql = "SELECT COUNT(*) FROM {$_FM_TABLES['filemgmt_filedetail']} a ";
$sql .= "LEFT JOIN {$_FM_TABLES['filemgmt_cat']} b ON a.cid=b.cid ";
예제 #4
0
            redirect_header("singlefile.php?cid={$cid}&lid={$lid}", 0, "Jump to download");
        }
    }
}
// redirect end
$sql = "SELECT cid, title, imgurl FROM " . $xoopsDB->prefix("mydownloads_cat") . " WHERE pid = 0 ORDER BY title";
$result = $xoopsDB->query($sql);
$count = 1;
while ($myrow = $xoopsDB->fetchArray($result)) {
    $title = $myts->makeTboxData4Show($myrow['title']);
    if ($myrow['imgurl'] && $myrow['imgurl'] != "http://") {
        $imgurl = $myts->makeTboxData4Edit($myrow['imgurl']);
    } else {
        $imgurl = '';
    }
    $totaldownload = getTotalItems($myrow['cid'], 1);
    // get child category objects
    $arr = array();
    $arr = $mytree->getFirstChild($myrow['cid'], "title");
    $space = 0;
    $chcount = 0;
    $subcategories = "";
    $subcat = array();
    foreach ($arr as $ele) {
        $chtitle = $myts->makeTboxData4Show($ele['title']);
        if ($chcount <= 5) {
            if ($space > 0) {
                $subcategories .= ", ";
            }
            $subcategories .= "<a href=\"" . XOOPS_URL . "/modules/mydownloads/viewcat.php?cid=" . $ele['cid'] . "\">" . $chtitle . "</a>";
            $space++;
예제 #5
0
OpenTable();
$result = $xoopsDB->query("select cid, cname, cdesc, cimg, cimgwidth, cimgheight from " . $xoopsDB->prefix("tutorials_categorys") . " where scid=0 order by cname");
$catcount = $xoopsDB->getRowsNum($result);
echo "<center><img src=\"images/tutorials.gif\" border=\"0\" Alt=\"Tutorials\"><br /><br />";
if ($heading == "") {
    printf(_MD_WELCOMETOTUTS, $xoopsConfig['sitename']);
} else {
    echo $heading;
}
echo "<br /><br />";
echo "<table width=80% cellspacing=4 cellpadding=0 border=0 valign=top><tr>";
while ($myrow = $xoopsDB->fetchArray($result)) {
    $cname = $myts->makeTboxData4Show($myrow['cname']);
    $cdesc = $myts->makeTboxData4Show($myrow['cdesc']);
    $cimg = $myts->makeTboxData4Show($myrow['cimg']);
    $number = getTotalItems($myrow['cid'], 1, 3);
    if ($category_visdefault == 1) {
        $show = $category_visualize;
    } else {
        $show = $category_default;
    }
    $arr = array();
    $arr = $mytree->getFirstChild($myrow['cid'], "cname");
    $space = 0;
    $chcount = 0;
    $subcats = "";
    foreach ($arr as $ele) {
        $chtitle = $myts->makeTboxData4Show($ele['cname']);
        if ($chcount > $maxsubcatshow) {
            $subcats .= "...";
            break;
예제 #6
0
        $gchildCategories = '';
        $subCatCount = count($gchildCatObjs);
        $lpLimit = min(array($subCatLimit, $subCatCount));
        $i = 0;
        foreach ($gchildCatObjs as $gchildCatObj) {
            $gchtitle = $myts->htmlSpecialChars($gchildCatObj->getVar('title'));
            $gchildCategories .= $i > 0 ? ', ' : '';
            $gchildCategories .= "<a href='" . XOOPSMYLINKURL . "/viewcat.php?cid=" . $gchildCatObj->getVar('cid') . "'>{$gchtitle}</a>";
            if ($i < $lpLimit) {
                $i++;
            } else {
                break;
            }
        }
        $gchildCategories = $subCatCount > $subCatLimit ? $gchildCategories . '...' : $gchildCategories;
        $totalLinks = getTotalItems($subCatObj->getVar('cid'), 1);
        $xoopsTpl->append('subcategories', array('image' => '', 'id' => $subCatObj->getVar('cid'), 'title' => $myts->htmlSpecialChars($subCatObj->getVar('title')), 'infercategories' => $gchildCategories, 'totallinks' => $totalLinks, 'count' => $count));
        $count++;
    }
    $LinkCountResult = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_links") . " WHERE cid='{$cid}' AND status>0");
} else {
    $list = $_GET['list'];
    $orderby = "title ASC";
    $xoopsTpl->assign('list_mode', true);
    //TODO:  need to filter $_GET['list'] input var
    $categoryPath = sprintf(_MD_MYLINKS_LINKS_LIST, $myts->htmlSpecialChars($_GET['list']));
    $thisPageTitle = $categoryPath;
    $xoopsTpl->assign('category_path', $categoryPath);
    $LinkCountResult = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_links") . " WHERE title LIKE '" . $myts->addSlashes($_GET['list']) . "%' AND status>0");
}
if (1 == $xoopsModuleConfig['useshots']) {
예제 #7
0
    $childCount = intval($mylinksCatHandler->getCount($criteria));
    //now retrieve the info for the first 'subcatLimit' categories
    $criteria->setLimit($subcatLimit);
    $criteria->setSort('title');
    $childFields = array('pid', 'title');
    $childTitleArray = $mylinksCatHandler->getAll($criteria, $childFields, false, false);
    $lpLimit = min(array($subcatLimit, count($childTitleArray)));
    $subcategories = '';
    for ($i = 0; $i < $lpLimit; $i++) {
        $chtitle = $myts->htmlSpecialChars($childTitleArray[$i]['title']);
        $subcategories .= $i > 0 ? ', ' : '';
        $subcategories .= "<a href='" . XOOPSMYLINKURL . "/viewcat.php?cid=" . $childTitleArray[$i]['cid'] . "'>{$chtitle}</a>";
    }
    $subcategories = $childCount > $subcatLimit ? $subcategories . '...' : $subcategories;
    // get number of links in each subcategory
    $totalLink = getTotalItems($catObj->getVar('cid'), 1);
    $xoopsTpl->append('categories', array('image' => $imgurl, 'id' => $catObj->getVar('cid'), 'title' => $myts->htmlSpecialChars($catObj->getVar('title')), 'subcategories' => $subcategories, 'totallink' => $totalLink, 'count' => $count));
    $count++;
}
$sql = "SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_links") . " WHERE status>0";
list($numActiveLinks) = $xoopsDB->fetchRow($xoopsDB->query($sql));
$xoopsTpl->assign('lang_thereare', sprintf(_MD_MYLINKS_THEREARE, $numActiveLinks));
if (1 == $xoopsModuleConfig['useshots']) {
    $xoopsTpl->assign('shotwidth', $xoopsModuleConfig['shotwidth']);
    $xoopsTpl->assign('tablewidth', $xoopsModuleConfig['shotwidth'] + 10);
    $xoopsTpl->assign('show_screenshot', true);
    $xoopsTpl->assign('lang_noscreenshot', _MD_MYLINKS_NOSHOTS);
}
$xoopsTpl->assign('lang_description', _MD_MYLINKS_DESCRIPTIONC);
$xoopsTpl->assign('lang_lastupdate', _MD_MYLINKS_LASTUPDATEC);
$xoopsTpl->assign('lang_hits', _MD_MYLINKS_HITSC);
예제 #8
0
        $chcount = 0;
        $infercategories = "";
        foreach ($sub_arr as $sub_ele) {
            $chtitle = $myts->makeTboxData4Show($sub_ele['title']);
            if ($chcount > 5) {
                $infercategories .= "...";
                break;
            }
            if ($space > 0) {
                $infercategories .= ", ";
            }
            $infercategories .= "<a href=\"" . XOOPS_URL . "/modules/mydownloads/viewcat.php?cid=" . $sub_ele['cid'] . "\">" . $chtitle . "</a>";
            $space++;
            $chcount++;
        }
        $xoopsTpl->append('subcategories', array('title' => $myts->makeTboxData4Show($ele['title']), 'id' => $ele['cid'], 'infercategories' => $infercategories, 'totallinks' => getTotalItems($ele['cid'], 1), 'count' => $scount));
        $scount++;
    }
}
if ($xoopsModuleConfig['useshots'] == 1) {
    $xoopsTpl->assign('shotwidth', $xoopsModuleConfig['shotwidth']);
    $xoopsTpl->assign('tablewidth', $xoopsModuleConfig['shotwidth'] + 10);
    $xoopsTpl->assign('show_screenshot', true);
    $xoopsTpl->assign('lang_noscreenshot', _MD_NOSHOTS);
}
if (!empty($xoopsUser) && $xoopsUser->isAdmin($xoopsModule->mid())) {
    $isadmin = true;
} else {
    $isadmin = false;
}
$fullcountresult = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mydownloads_downloads") . " WHERE cid={$cid} AND status>0");
예제 #9
0
function makeCategoryPart($cid)
{
    global $_CONF, $_DLM_CONF, $LANG_DLM, $mytree;
    $T = new Template($_DLM_CONF['path_layout']);
    $T->set_file(array('categorypart' => 'filelisting_category.thtml', 'categoryrow' => 'filelisting_category_row.thtml', 'categoryitem' => 'filelisting_category_item.thtml'));
    DLM_setDefaultTemplateVars($T);
    $arr = $mytree->getFirstChild($cid, 'corder');
    // all child ID are listed (Affected by the language mode)
    if (count($arr) == 0) {
        return '';
    }
    //  if ($_DLM_CONF['numCategoriesPerRow'] < 1) $_DLM_CONF['numCategoriesPerRow'] = 1; // probably no longer necessary
    //  if ($_DLM_CONF['numCategoriesPerRow'] > 6) $_DLM_CONF['numCategoriesPerRow'] = 6; // probably no longer necessary
    $count = 0;
    foreach ($arr as $ele) {
        // Each category
        $chtitle = DLM_htmlspecialchars($ele['title']);
        $T->set_var('cid', $ele['cid']);
        $T->set_var('chtitle', $chtitle);
        $T->set_var('totaldownload', getTotalItems($ele['cid']));
        $category_image_link = '&nbsp;';
        if ($_DLM_CONF['download_useshots']) {
            if ($ele['imgurl'] && $ele['imgurl'] != "http://") {
                $imgurl = $_DLM_CONF['snapcat_url'] . '/' . DLM_htmlspecialchars($ele['imgurl']);
            } else {
                $imgurl = $_CONF['site_url'] . '/downloads/images/download.png';
            }
            $category_image_link = COM_createImage($imgurl, $chtitle, array('width' => $_DLM_CONF['download_shotwidth']));
            $category_image_link = COM_createLink($category_image_link, $_CONF['site_url'] . '/downloads/index.php?cid=' . $ele['cid']);
        }
        $T->set_var('category_link', $category_image_link);
        $T->parse('category_row', 'categoryitem', true);
        $count++;
        if ($count == $_DLM_CONF['numCategoriesPerRow']) {
            $T->parse('category_records', 'categoryrow', true);
            $T->set_var('category_row', '');
            $count = 0;
        }
    }
    if ($count > 0) {
        $T->parse('category_records', 'categoryrow', true);
    }
    return $T->finish($T->parse('category_part', 'categorypart'));
}