예제 #1
0
        $num_items = $db->query($db->sql())->fetchColumn();
        $db->select('a.album_id, a.name, a.category_id, a.alias, a.capturelocal, a.description, a.num_photo, a.date_added, a.viewed, a.author, r.file, r.thumb')->order('a.date_added DESC')->limit($per_page)->where('a.status= 1 AND r.defaults = 1')->offset(($page - 1) * $per_page);
        $result = $db->query($db->sql());
        while ($item = $result->fetch()) {
            $sql = 'SELECT userid, username, first_name, last_name, photo FROM ' . NV_USERS_GLOBALTABLE . ' WHERE active=1 AND userid= ' . $item['author'];
            $array_user = nv_db_cache($sql, 'userid', $module_name);
            if (!empty($array_user)) {
                foreach ($array_user as $array_user_i) {
                    if (!empty($array_user_i['first_name']) && !empty($array_user_i['last_name'])) {
                        $item['author_upload'] = $array_user_i['first_name'] . ' ' . $array_user_i['last_name'];
                    } else {
                        $item['author_upload'] = $array_user_i['username'];
                    }
                    if (!empty($array_user_i['photo'])) {
                        $item['author_image'] = $array_user_i['photo'];
                    } else {
                        $item['author_image'] = 'themes/default/images/users/no_avatar.png';
                    }
                }
            }
            $item['link'] = $global_photo_cat[$item['category_id']]['link'] . '/' . $item['alias'] . '-' . $item['album_id'];
            $array_album[] = $item;
        }
        $result->closeCursor();
    }
    $generate_page = nv_alias_page($page_title, $base_url, $num_items, $per_page, $page);
    $contents = home_view_grid_by_album($array_album, $generate_page);
}
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';
예제 #2
0
                while ($item = $result->fetch()) {
                    $item['link'] = $global_photo_cat[$_category_id]['link'] . '/' . $item['alias'] . '-' . $item['album_id'] . $global_config['rewrite_exturl'];
                    $array_cat[$key]['content'][] = $item;
                }
                $result->closeCursor();
                ++$key;
            }
        }
    }
    $contents = home_view_grid_by_cat($array_cat);
} elseif ($photo_config['home_view'] == 'home_view_grid_by_album') {
    $array_album = array();
    if (!empty($global_photo_cat)) {
        $sql = 'SELECT a.album_id, a.name, a.category_id, a.alias, a.capturelocal, a.description, a.num_photo, a.date_added, r.file, r.thumb FROM ' . TABLE_PHOTO_NAME . '_album a 
				LEFT JOIN  ' . TABLE_PHOTO_NAME . '_rows r ON ( a.album_id = r.album_id )
				WHERE a.status= 1 AND r.defaults = 1 
				ORDER BY a.date_added DESC 
				LIMIT 0 , ' . $photo_config['per_page_album'];
        $result = $db->query($sql);
        while ($item = $result->fetch()) {
            $item['link'] = $global_photo_cat[$item['category_id']]['link'] . '/' . $item['alias'] . '-' . $item['album_id'] . $global_config['rewrite_exturl'];
            $array_album[] = $item;
        }
        $result->closeCursor();
    }
    $contents = home_view_grid_by_album($array_album);
}
// $numalbum = $db->query( 'SELECT COUNT(*) FROM ' . NV_PREFIXLANG . '_' . $module_data . '_album' )->fetchColumn();
include NV_ROOTDIR . '/includes/header.php';
echo nv_site_theme($contents);
include NV_ROOTDIR . '/includes/footer.php';