PHP alb_get_subcat_data Examples

Programming Language: PHP

Method/Function: alb_get_subcat_data

Examples at hotexamples.com: 3

PHP alb_get_subcat_data - 3 examples found. These are the top rated real world PHP examples of alb_get_subcat_data extracted from open source projects. You can rate examples to help us improve the quality of examples.

Example #1

Show file

File: albmgr.php Project: CatBerg-TestOrg/coppermine

/**
 * alb_get_subcat_data()
 *
 * @param integer $parent
 * @param string $ident
 **/
function alb_get_subcat_data($parent, $ident = '')
{
    global $CONFIG, $CAT_LIST, $USER_DATA;
    // select cats where the users can change the albums
    $groups = '';
    foreach ($USER_DATA['groups'] as $group) {
        $groups .= "group_id = '{$group}' OR ";
    }
    $groups .= "0";
    $result = cpg_db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '{$parent}' AND cid != 1 ORDER BY pos");
    if ($result->numRows() > 0) {
        $rowset = cpg_db_fetch_rowset($result);
        foreach ($rowset as $subcat) {
            if (!GALLERY_ADMIN_MODE) {
                $check_group = cpg_db_query("SELECT group_id FROM {$CONFIG['TABLE_CATMAP']} WHERE ({$groups}) AND cid = " . $subcat['cid']);
                $check_group_rowset = cpg_db_fetch_rowset($check_group);
                if ($check_group_rowset) {
                    $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']);
                }
            } else {
                $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']);
            }
            alb_get_subcat_data($subcat['cid'], $ident . '&nbsp;&nbsp;&nbsp;');
        }
    }
}

Example #2

Show file

File: albmgr.php Project: alencarmo/OCF

/**
 * alb_get_subcat_data()
 *
 * @param integer $parent
 * @param string $ident
 **/
function alb_get_subcat_data($parent, $ident = '')
{
    global $CONFIG, $CAT_LIST;
    $result = cpg_db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '{$parent}' AND cid != 1 ORDER BY pos");
    if (mysql_num_rows($result) > 0) {
        $rowset = cpg_db_fetch_rowset($result);
        foreach ($rowset as $subcat) {
            $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']);
            alb_get_subcat_data($subcat['cid'], $ident . '&nbsp;&nbsp;&nbsp;');
        }
    }
}

Example #3

Show file

File: albmgr.php Project: phill104/branches

/**
 * alb_get_subcat_data()
 *
 * @param integer $parent
 * @param string $ident
 **/
function alb_get_subcat_data($parent, $ident = '')
{
    global $CONFIG, $CAT_LIST, $USER_DATA;
    //select cats where the users can change the albums
    $group_id = $USER_DATA['group_id'];
    //$result = cpg_db_query("SELECT cats.cid, cats.name, cats.description FROM {$CONFIG['TABLE_CATEGORIES']} AS cats INNER JOIN {$CONFIG['TABLE_CATMAP']} AS catmap ON cats.parent = '$parent' AND cats.cid != 1 AND cats.cid = catmap.cid ORDER BY pos");
    $result = cpg_db_query("SELECT cid, name, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '{$parent}' AND cid != 1 ORDER BY pos");
    if (mysql_num_rows($result) > 0) {
        $rowset = cpg_db_fetch_rowset($result);
        foreach ($rowset as $subcat) {
            $check_group = cpg_db_query("SELECT group_id FROM {$CONFIG['TABLE_CATMAP']} WHERE group_id = '{$group_id}' AND cid=" . $subcat['cid']);
            $check_group_rowset = cpg_db_fetch_rowset($check_group);
            if ($check_group_rowset) {
                $CAT_LIST[] = array($subcat['cid'], $ident . $subcat['name']);
            }
            alb_get_subcat_data($subcat['cid'], $ident . '&nbsp;&nbsp;&nbsp;');
        }
    }
}