ERROR

CPG for PostNuke OR CPG for PHPnuke

racially divided friendships racially divided friendships our rachel blake huntington wv rachel blake huntington wv now ralph nader political cartoons ralph nader political cartoons sentence replacing old light fixtures replacing old light fixtures arm quark resize pages proportionately quark resize pages proportionately mind quiznos chicken carbonara price quiznos chicken carbonara price egg range rd 282 calgary range rd 282 calgary basic restaurant equipment lease austin restaurant equipment lease austin better quaker cemeteries new jersey quaker cemeteries new jersey teeth qualcomm technology grants qualcomm technology grants last residental flat roof construction residental flat roof construction then provo orem retail dell provo orem retail dell edge princeton bank and trust princeton bank and trust boat princess colouring page princess colouring page white rich haney carrollton rich haney carrollton dry profane illumination margaret cohen profane illumination margaret cohen so randy johnson roger clemens randy johnson roger clemens total remax in thomasville remax in thomasville climb rhett a butler iraq rhett a butler iraq opposite rebecca morrow rebecca morrow especially quincy s cafe birmingham alabama quincy s cafe birmingham alabama case red deer travel agents red deer travel agents cold range rover wireing range rover wireing tube princeton country store princeton country store character propane pilot light propane pilot light far radiant rider wright tarot radiant rider wright tarot vowel pschiatrist in cleveland ohio pschiatrist in cleveland ohio spell priscilla diary gene edwards priscilla diary gene edwards east q port chester ny q port chester ny column property management bonita property management bonita follow psychiatrists anchorage alaska psychiatrists anchorage alaska case public schools columbus ohio public schools columbus ohio well rh anderson corp rh anderson corp red receipe for blue velvet receipe for blue velvet watch pyramid lake paiute indians pyramid lake paiute indians experience rca keystone jacks rca keystone jacks family princeton medical school princeton medical school been residential homes in leeds residential homes in leeds thousand range ck mb range ck mb skin richard glen campbell jr richard glen campbell jr group printer drivers hp6100 printer drivers hp6100 result quinton bradley quinton bradley say rimfire magazines rimfire magazines consider reflexology magazine reflexology magazine liquid rachel carson s birth date rachel carson s birth date sister regions bank lafayette indiana regions bank lafayette indiana half quarter master branch telephone quarter master branch telephone metal ralph lauren puffer ralph lauren puffer this ramona orange book ramona orange book both regina pacis brooklyn regina pacis brooklyn molecule revival tabernacle kansas city revival tabernacle kansas city dead restaurants in bryant ar restaurants in bryant ar hole rick lytle mobile detailing rick lytle mobile detailing danger property ownership calgary alberta property ownership calgary alberta fruit printed jersey shirts printed jersey shirts evening richard scott bloustine richard scott bloustine ago richelieu valley regional high richelieu valley regional high success rhodora lenox rhodora lenox expect ralph the warewolf said ralph the warewolf said except printable valentines pattern printable valentines pattern brown rebecca bradley myspace rebecca bradley myspace when retail store fixtures nashville retail store fixtures nashville speech randy samson ameriprise randy samson ameriprise indicate replacement china houston texas replacement china houston texas thing rentals lexington ky rentals lexington ky slow redwing casuals highland redwing casuals highland think ralph sacco columbia ralph sacco columbia bit radeon x300 driver radeon x300 driver chief production operative scotland production operative scotland tiny rio vista horse shampoo rio vista horse shampoo test rare stamps of austria rare stamps of austria won't remax property fairfield ca remax property fairfield ca who rectal temperature roll over rectal temperature roll over buy rio vista porter texas rio vista porter texas village regal movies lancaster regal movies lancaster stream regan williams alaska regan williams alaska receive recommended doctors mesa arizona recommended doctors mesa arizona love realty executives augusta ga realty executives augusta ga black retail fabric morris county retail fabric morris county tube property management portland me property management portland me build radio en salina kansas radio en salina kansas send private british columbia bc private british columbia bc second proctor inc proctor inc original reo construction springfield mo reo construction springfield mo salt record breakers jesse ventura record breakers jesse ventura catch richelle ward richelle ward division private cheerleader camp maryland private cheerleader camp maryland front pythagorean theorem garfield pythagorean theorem garfield insect pw geneva pw geneva space printronix drivers printronix drivers head ravenden springs history ravenden springs history body richie fontana richie fontana electric richard dean tucson arizona richard dean tucson arizona box red deer pet cemetery red deer pet cemetery event resort surfside texas resort surfside texas trade racing 1984 fox bodys racing 1984 fox bodys race ringneck dove new york ringneck dove new york why ralphs transmission ralphs transmission with restaraunt sage restaraunt sage he recipe chicken fricassee recipe chicken fricassee climb q tip janet jackson q tip janet jackson fruit quilt vendors in indianapolis quilt vendors in indianapolis letter queen elizabeth hospital barbados queen elizabeth hospital barbados contain richard weaver storytellers richard weaver storytellers fact ravena central school ravena central school quiet restorative justice scotland 2006 restorative justice scotland 2006 person rigaudeau hamburg rigaudeau hamburg heard restaurants hartford conneticut restaurants hartford conneticut trade properties for rent wales properties for rent wales corn range of cow killer range of cow killer segment rickenbackers ogden rickenbackers ogden next riflemans winchester riflemans winchester between quality inn long beach quality inn long beach hard reforendum 2007 ontario reforendum 2007 ontario sea richard gordon hawkins richard gordon hawkins huge restaurant green light trenton restaurant green light trenton she raymond johnson in wisconsin raymond johnson in wisconsin object reform pilates reform pilates boy prioity toyota chester va prioity toyota chester va object rayovac rocket light rayovac rocket light body prosavageddr 420 drivers prosavageddr 420 drivers school purple heart pasadena tx purple heart pasadena tx insect prothrombin time normals prothrombin time normals pose replacement glass lamp globes replacement glass lamp globes bird refillable pages spiral refillable pages spiral sheet princeton calkins princeton calkins least race results lexington ky race results lexington ky station prison locations england prison locations england open quincey walcott cpa quincey walcott cpa stream ricky clifford hamilton ricky clifford hamilton quiet prim porch sping decor prim porch sping decor change red deer cycling club red deer cycling club child restaurant at kennedy center restaurant at kennedy center my ranger roll pans ranger roll pans four rehersal dinners in houston rehersal dinners in houston few raptors jerseys raptors jerseys subtract reba scott reba scott less prudhoe bay store prudhoe bay store her pubs in woodbridge ontario pubs in woodbridge ontario hit rebecca ward ross rebecca ward ross new pueblo indians astronomy pueblo indians astronomy stone richard anderson ceo richard anderson ceo connect ram hermitage road ram hermitage road busy princeton monitor parts princeton monitor parts bone recipe for royal glacage recipe for royal glacage red pug jack russel mix pug jack russel mix fresh recipes black eyed peas recipes black eyed peas rain printing slow with vista printing slow with vista never princes schol melbourne princes schol melbourne cause raf sweatheart wings raf sweatheart wings copy ribbon page stud horse ribbon page stud horse who ricky justice knoxville ricky justice knoxville bought pws brooklyn pws brooklyn cent red wing minnesota toursim red wing minnesota toursim separate rick hensley rick hensley shore rehoboth delaware hotel rehoboth delaware hotel ocean psyclone blue flying v psyclone blue flying v too ralph lauren percale ralph lauren percale copy professional organizer peoria arizona professional organizer peoria arizona suggest revolving page revolving page each princeton pbx princeton pbx work realty 2000 sidney ohio realty 2000 sidney ohio kill ralph lauren womens pants ralph lauren womens pants back replating silver miami replating silver miami floor provision visalia provision visalia sight prop art studio detroit prop art studio detroit die resturants close to coronado resturants close to coronado wide quote for valentines day quote for valentines day process psalm 23 stories psalm 23 stories kept rideau carlton rideau carlton reason record delta buckhannon wv record delta buckhannon wv earth reebok indianapolis colts super reebok indianapolis colts super under rainbow radio columbia sc rainbow radio columbia sc as rawle henderson in media rawle henderson in media reason recreational parks grant recreational parks grant write ray realty conway ray realty conway fill ramada inn hampton virginia ramada inn hampton virginia broke psp vista shockwave psp vista shockwave truck puddle lights subaru puddle lights subaru bell radio free minturn radio free minturn wing recipe for chicken hawaaian recipe for chicken hawaaian duck ramona cavanagh mun mun ramona cavanagh mun mun material rain forrest coloring pages rain forrest coloring pages tube restaurants district of columbia restaurants district of columbia wheel rapha campbell and arkansas rapha campbell and arkansas duck reformed judaism baton rouge reformed judaism baton rouge insect ralph pickering ralph pickering hot red wing metguard boot red wing metguard boot will reflexology classes in sedona reflexology classes in sedona list qoutes about jack london qoutes about jack london tool refurbishing a mobile home refurbishing a mobile home written repo cost portland repo cost portland quick prompt care new jersey prompt care new jersey eight repair broken branch repair broken branch word recc auburn il recc auburn il cover regal cinimas hunt valley regal cinimas hunt valley idea prostitution oakland prostitution oakland each quizzes on ruby dee quizzes on ruby dee ice raymond cruz indio ca raymond cruz indio ca soil prison industries ludlow ma prison industries ludlow ma brown proctor gamble cincinnati proctor gamble cincinnati speak racing decals honda wings racing decals honda wings women process specialties roanoke process specialties roanoke visit public libraries of saginaw public libraries of saginaw only queen elizabeth s succesor queen elizabeth s succesor fun rasing meat chickens rasing meat chickens boy regional director noreen russell regional director noreen russell hour reel ceiling light reel ceiling light print radio 106 3 texarkana radio 106 3 texarkana your red deer alberta golf red deer alberta golf wonder rice sage recipe rice sage recipe map proven air portland or proven air portland or position recipe stripped delight recipe stripped delight record regents school austin texas regents school austin texas consonant redline rock band redline rock band brown princeton association human rights princeton association human rights word ravished bride stories ravished bride stories note providence ri section 8 providence ri section 8 language richie sambora sells home richie sambora sells home raise richard pate austin richard pate austin sense ralph lotion ralph lotion during radiant barrier arlington texas radiant barrier arlington texas boat richard rector government contracts richard rector government contracts wear quantity sales needles quantity sales needles sea restaurants norwalk ct restaurants norwalk ct before redmund linden tree redmund linden tree dear randy jackson new cd randy jackson new cd ball razor bistro phoenix az razor bistro phoenix az month ps60 fellows paper shredder ps60 fellows paper shredder noise racine wi white pages racine wi white pages among queen bee designs queen bee designs soil rickenbacker light show rickenbacker light show finger reposesed mobile homes ohio reposesed mobile homes ohio skin red mountain white trash red mountain white trash numeral repair flouresent lights repair flouresent lights morning psychic in new jersey psychic in new jersey line reaql clear reaql clear block rapid pump floor jack rapid pump floor jack heavy property management scottsboro alabama property management scottsboro alabama sit retractable downdraft ranges retractable downdraft ranges meat ralph lauren bracelet ralph lauren bracelet language rialto high school stadium rialto high school stadium hole recruiters jacksonville recruiters jacksonville this rai san diego rai san diego over printers butler nj thermography printers butler nj thermography word richard s mayflower richard s mayflower both racial demographics of anchorage racial demographics of anchorage wrong rbc central raleigh rbc central raleigh word rechargeable patio light rechargeable patio light yard relatives of magnolia grandiflora relatives of magnolia grandiflora bad pros of homeland security pros of homeland security take reliabe online tarot oracles reliabe online tarot oracles lift restaurants in anchorage alaska restaurants in anchorage alaska sleep retirement living leisure magazine retirement living leisure magazine sign proto jersey proto jersey chance red restaurant kirkland wa red restaurant kirkland wa tree raddison hotel san diego raddison hotel san diego were rio vista kite boarding rio vista kite boarding root rein s deli vernon ct rein s deli vernon ct tie redding california rv parks redding california rv parks spread prostitutes in moscow prostitutes in moscow pattern residual cash income residual cash income them redondo beach and gay redondo beach and gay slave reducing fractions in excel reducing fractions in excel reason richard railey jr courtland richard railey jr courtland kind rdb contractor athens alabama rdb contractor athens alabama country rain screen saver vista rain screen saver vista insect replace vista with xp replace vista with xp middle reginald f butler reginald f butler large ramada limited austin north ramada limited austin north cool rights political marshall islands rights political marshall islands bar randy rogers lyrics randy rogers lyrics quite reggie wilson smile reggie wilson smile since prudential realty washington state prudential realty washington state twenty remax highland in remax highland in size retirement homes everett washington retirement homes everett washington kind rentals in new jersey rentals in new jersey held ralph s ninth street ralph s ninth street green regency inn phenix city regency inn phenix city far psc2110xi me driver psc2110xi me driver red red light district malaga red light district malaga once rainbow greensboro rainbow greensboro molecule recipe harvest salad recipe harvest salad vowel rhode island food stamps rhode island food stamps ever religions congress homosexuality religions congress homosexuality rich propane foreman grill propane foreman grill fall ps2 cheat code central ps2 cheat code central room ring christmas bells lyrics ring christmas bells lyrics good rainbow community church fallbrook rainbow community church fallbrook soil redlands wma redlands wma circle rarity bay real estate rarity bay real estate save rental ny lake ontario rental ny lake ontario pick princeton health center princeton health center floor public parks in boston public parks in boston has production test foreman production test foreman friend ralph w winters prostitute ralph w winters prostitute syllable quizzes from magazines printable quizzes from magazines printable guide q b enterprises q b enterprises told resturant sylvania georgia resturant sylvania georgia men red pony in nashville red pony in nashville please randyblue sweat stories randyblue sweat stories melody resorts sonoma valley resorts sonoma valley village restoring johnson front panels restoring johnson front panels bank restaurants in lakewood ohio restaurants in lakewood ohio point range hood connection range hood connection quart recipe for pineapple delight recipe for pineapple delight sugar printer driver deployment tool printer driver deployment tool industry queen mattress austin tx queen mattress austin tx slip rio hondo collect whittier rio hondo collect whittier lost rbgh fox news rbgh fox news full range rover grills range rover grills radio ps2 black screenshots ps2 black screenshots here rachel levering delaware ohio rachel levering delaware ohio shoe richard mansfield clover park richard mansfield clover park prepare psychics cambridge ontario canada psychics cambridge ontario canada north recipe for deer mix recipe for deer mix done raymond juliano chester raymond juliano chester rail retirement homes anchorage retirement homes anchorage rich rassini international inc eagle rassini international inc eagle period rentals henderson nevada rentals henderson nevada special rental red deer rental red deer milk rei camp dome rei camp dome capital rhinestone rosie rhinestone rosie less resistance weld peel test resistance weld peel test experiment province wales europe province wales europe start rhonda langston alabama rhonda langston alabama sat rio nilo in riverside rio nilo in riverside yet restaurants merchants dr knoxville restaurants merchants dr knoxville swim qualit dell aria qualit dell aria cold quotes equality women quotes equality women stead restaurant guide york maine restaurant guide york maine ago richard marshall english artist richard marshall english artist street raymond chandler racism raymond chandler racism held report illegal gun detroit report illegal gun detroit kept ralph nault ralph nault wild recipes kentucky fried chicken recipes kentucky fried chicken money public storage arlington ohio public storage arlington ohio a public libraries birmingham al public libraries birmingham al period ralph lauren blue miniature ralph lauren blue miniature include restraunts in norman oklahoma restraunts in norman oklahoma wire puttanesca recipe fitness magazine puttanesca recipe fitness magazine pose range rover sales data range rover sales data give professional gardener calgary alberta professional gardener calgary alberta care recycled plastic bag chicken recycled plastic bag chicken metal rebekah palmer rebekah palmer sugar remax agent maggie johnson remax agent maggie johnson cell rick hutcheson palm springs rick hutcheson palm springs liquid rare stamps germany rare stamps germany order ramen phoenix az ramen phoenix az poem reed barton antique spoon reed barton antique spoon drop queen garden resort bangkok queen garden resort bangkok quart ralphs food store ralphs food store party restaurants in westminster maryland restaurants in westminster maryland claim princess margaret bio princess margaret bio summer professional hair new jersey professional hair new jersey afraid ridgefield county washington ridgefield county washington men prosser fields springfield ohio prosser fields springfield ohio page quilter catherine roberts quilter catherine roberts rub radon chinle radon chinle broad ramona bell murdered ramona bell murdered inch richland mall ontario ohio richland mall ontario ohio night

[\r\n]*/i", '
' . $ident , bb_decode($subcat['description'])); $link = $ident . "{$subcat['name']}"; if ($album_count) { $cat_data[] = array($link, $ident . $subcat['description'], $album_count, $pic_count); $HIDE_USER_CAT = 0; } else { $HIDE_USER_CAT = 1; } } else { $unaliased_album_filter = str_replace('a.','',$album_filter); $result = db_query("SELECT aid FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$subcat['cid']}".$unaliased_album_filter); $album_count = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { $album_set_array[] = $row['aid']; } // while mysql_free_result($result); $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} as p, {$CONFIG['TABLE_ALBUMS']} as a WHERE p.aid = a.aid AND category = {$subcat['cid']}".$album_filter); $nbEnr = mysql_fetch_array($result); mysql_free_result($result); $pic_count = $nbEnr[0]; if ($subcat['thumb']>0) { $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight ". "FROM {$CONFIG['TABLE_PICTURES']} ". "WHERE pid='{$subcat['thumb']}'".$pic_filter; $result = db_query($sql); if (mysql_num_rows($result)) { $picture = mysql_fetch_array($result); mysql_free_result($result); $pic_url = get_pic_url($picture, 'thumb'); if (!is_image($picture['filename'])) { $image_info = getimagesize($pic_url); $picture['pwidth'] = $image_info[0]; $picture['pheight'] = $image_info[1]; } $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['alb_list_thumb_size']); $user_thumb = " $\"\"$ "; $user_thumb = "".$user_thumb.""; } }else{ $user_thumb =""; } $subcat['name'] = $subcat['name']; $subcat['description'] = preg_replace("/[\r\n]*/i", '
', bb_decode($subcat['description'])); $link = "{$subcat['name']}"; $user_thumb = $ident.$user_thumb; if ($pic_count == 0 && $album_count == 0) { $user_thumb = $ident; $cat_data[] = array($link, $subcat['description'],'cat_thumb' =>$user_thumb); } else { // Check if you need to show subcat_level if ($level == $CONFIG['subcat_level']) { $cat_albums = list_cat_albums($subcat['cid']); } else { $cat_albums = ''; } $cat_data[] = array($link, $subcat['description'], $album_count, $pic_count, 'cat_albums' => $cat_albums,'cat_thumb' =>$user_thumb); } } if ($level > 1) get_subcat_data($subcat['cid'], $cat_data, $album_set_array, $level -1, $ident . "

"); } } } // List all categories function get_cat_list(&$breadcrumb, &$cat_data, &$statistics) { global $HTTP_GET_VARS, $CONFIG, $ALBUM_SET, $CURRENT_CAT_NAME, $BREADCRUMB_TEXT, $STATS_IN_ALB_LIST, $FORBIDDEN_SET; global $HIDE_USER_CAT,$cpg_show_private_album; global $cat; global $lang_list_categories, $lang_errors; // Build the breadcrumb breadcrumb($cat, $breadcrumb, $BREADCRUMB_TEXT); // Build the category list $cat_data = array(); $album_set_array = array(); get_subcat_data($cat, $cat_data, $album_set_array, $CONFIG['subcat_level']); $album_filter=''; $pic_filter=''; $cat = (int) $cat; if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) { $album_filter = ' and '.str_replace('p.','a.',$FORBIDDEN_SET); $pic_filter = ' and '.$FORBIDDEN_SET; } // Add the albums in the current category to the album set //if ($cat) { if ($cat == USER_GAL_CAT) { $sql = "SELECT aid FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE category >= " . FIRST_USER_CAT.$album_filter; $result = db_query($sql); } else { $sql = "SELECT aid FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE category = '$cat'".$album_filter; $result = db_query($sql); } while ($row = mysql_fetch_array($result)) { $album_set_array[] = $row['aid']; } // while mysql_free_result($result); //} if (count($album_set_array)&&$cat) { $set = ''; foreach ($album_set_array as $album) $set .= $album . ','; $set = substr($set, 0, -1); $current_album_set = "AND aid IN ($set) "; $ALBUM_SET .= $current_album_set; } elseif ($cat) { $current_album_set = "AND aid IN (-1) "; $ALBUM_SET .= $current_album_set; } // Gather gallery statistics if ($cat == 0) { $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE 1".$album_filter); $nbEnr = mysql_fetch_array($result); $album_count = $nbEnr[0]; mysql_free_result($result); $sql = "SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} as p ". 'LEFT JOIN '.$CONFIG['TABLE_ALBUMS'].' as a '. 'ON a.aid=p.aid '. 'WHERE 1'.$pic_filter; $result = db_query($sql); $nbEnr = mysql_fetch_array($result); $picture_count = $nbEnr[0]; mysql_free_result($result); $sql = "SELECT count(*) FROM {$CONFIG['TABLE_COMMENTS']} as c ". 'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '. 'ON c.pid=p.pid '. 'LEFT JOIN '.$CONFIG['TABLE_ALBUMS'].' as a '. 'ON a.aid=p.aid '. 'WHERE 1'.$pic_filter; $result = db_query($sql); $nbEnr = mysql_fetch_array($result); $comment_count = $nbEnr[0]; mysql_free_result($result); $sql = "SELECT count(*) FROM {$CONFIG['TABLE_CATEGORIES']} WHERE 1"; $result = db_query($sql); $nbEnr = mysql_fetch_array($result); $cat_count = $nbEnr[0] - $HIDE_USER_CAT; mysql_free_result($result); $sql = "SELECT sum(hits) FROM {$CONFIG['TABLE_PICTURES']} as p ". 'LEFT JOIN '.$CONFIG['TABLE_ALBUMS'].' as a '. 'ON p.aid=a.aid '. 'WHERE 1'.$pic_filter; $result = db_query($sql); $nbEnr = mysql_fetch_array($result); $hit_count = (int)$nbEnr[0]; mysql_free_result($result); if (count($cat_data)) { $statistics = strtr($lang_list_categories['stat1'], array('[pictures]' => $picture_count, '[albums]' => $album_count, '[cat]' => $cat_count, '[comments]' => $comment_count, '[views]' => $hit_count)); } else { $STATS_IN_ALB_LIST = true; $statistics = strtr($lang_list_categories['stat3'], array('[pictures]' => $picture_count, '[albums]' => $album_count, '[comments]' => $comment_count, '[views]' => $hit_count)); } } elseif ($cat >= FIRST_USER_CAT && $ALBUM_SET) { $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} WHERE 1 $current_album_set"); $nbEnr = mysql_fetch_array($result); $album_count = $nbEnr[0]; mysql_free_result($result); $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1 $current_album_set"); $nbEnr = mysql_fetch_array($result); $picture_count = $nbEnr[0]; mysql_free_result($result); $result = db_query("SELECT sum(hits) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1 $current_album_set"); $nbEnr = mysql_fetch_array($result); $hit_count = (int)$nbEnr[0]; mysql_free_result($result); $statistics = strtr($lang_list_categories['stat2'], array('[pictures]' => $picture_count, '[albums]' => $album_count, '[views]' => $hit_count)); } else { $statistics = ''; } } function list_users() { global $CONFIG, $PAGE, $FORBIDDEN_SET; global $lang_list_users, $lang_errors, $template_user_list_info_box, $cpg_show_private_album; if (defined('UDB_INTEGRATION')) { $result = udb_list_users_query($user_count); } else { // $sql = "SELECT user_id," . " user_name," . " COUNT(DISTINCT a.aid) as alb_count," . " COUNT(DISTINCT pid) as pic_count," . " MAX(pid) as thumb_pid " . "FROM {$CONFIG['TABLE_USERS']} AS u " . "INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON category = " . FIRST_USER_CAT . " + user_id " . "INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.aid = a.aid " . "WHERE approved = 'YES' " . "$FORBIDDEN_SET " . "GROUP BY user_id " . "ORDER BY user_name "; // Fixed correct album count DJMaze $sql = "SELECT user_id, " . "user_name, " . "COUNT(DISTINCT a.aid) as alb_count, " . "COUNT(DISTINCT pid) as pic_count, " . "MAX(pid) as thumb_pid " . "FROM {$CONFIG['TABLE_USERS']} AS u " . "INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON category = " . FIRST_USER_CAT . " + user_id " . "LEFT JOIN {$CONFIG['TABLE_PICTURES']} AS p ON (p.aid = a.aid AND approved = 'YES') "; if ($FORBIDDEN_SET != "") $sql .= "WHERE $FORBIDDEN_SET "; $sql .= "GROUP BY user_id " . "ORDER BY user_name"; $result = db_query($sql); $user_count = mysql_num_rows($result); } if (!$user_count) { msg_box($lang_list_users['user_list'], $lang_list_users['no_user_gal'], '', '', '100%'); mysql_free_result($result); return; } $user_per_page = $CONFIG['thumbcols'] * $CONFIG['thumbrows']; $totalPages = ceil($user_count / $user_per_page); if ($PAGE > $totalPages) $PAGE = 1; $lower_limit = ($PAGE-1) * $user_per_page; $upper_limit = min($user_count, $PAGE * $user_per_page); $row_count = $upper_limit - $lower_limit; if (defined('UDB_INTEGRATION')) { $rowset = udb_list_users_retrieve_data($result, $lower_limit, $row_count); } else { $rowset = array(); $i = 0; mysql_data_seek($result, $lower_limit); while (($row = mysql_fetch_array($result)) && ($i++ < $row_count)) $rowset[] = $row; mysql_free_result($result); } $user_list = array(); foreach ($rowset as $user) { $user_thumb = '

'; $user_pic_count = $user['pic_count']; $user_thumb_pid = $user['thumb_pid']; $user_album_count = $user['alb_count']; if ($user_pic_count) { if ($CONFIG['show_private']){ $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']); $user_thumb = " $\"\"$ "; } $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE pid='$user_thumb_pid'"; $result = db_query($sql); if (mysql_num_rows($result)) { $picture = mysql_fetch_array($result); mysql_free_result($result); $pic_url = get_pic_url($picture, 'thumb'); if (!is_image($picture['filename'])) { $image_info = getimagesize($pic_url); $picture['pwidth'] = $image_info[0]; $picture['pheight'] = $image_info[1]; } $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['alb_list_thumb_size']); $user_thumb = " $\"\"$ "; } } $albums_txt = sprintf($lang_list_users['n_albums'], $user_album_count); $pictures_txt = sprintf($lang_list_users['n_pics'], $user_pic_count); $params = array('{USER_NAME}' => $user['user_name'], '{USER_ID}' => $user['user_id'], '{ALBUMS}' => $albums_txt, '{PICTURES}' => $pictures_txt, ); $caption = template_eval($template_user_list_info_box, $params); $user_list[] = array('cat' => FIRST_USER_CAT + $user['user_id'], 'image' => $user_thumb, 'caption' => $caption, ); } theme_display_thumbnails($user_list, $user_count, '', '', 1, $PAGE, $totalPages, false, true, 'user'); } // List all albums function list_albums() { global $CONFIG, $USER, $USER_DATA, $PAGE, $lastup_date_fmt,$FORBIDDEN_SET; global $cat; global $lang_list_albums, $lang_errors,$cpg_show_private_album; $alb_per_page = $CONFIG['albums_per_page']; $maxTab = $CONFIG['max_tabs']; $album_filter=''; $pic_filter=''; $pic_subquery=''; if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) { $album_filter = ' and '.str_replace('p.','a.',$FORBIDDEN_SET); $pic_filter = ' and '.$FORBIDDEN_SET; } $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE category = '$cat'".$album_filter); $nbEnr = mysql_fetch_array($result); $nbAlb = $nbEnr[0]; mysql_free_result($result); if (!$nbAlb) return; $totalPages = ceil($nbAlb / $alb_per_page); if ($PAGE > $totalPages) $PAGE = 1; $lower_limit = ($PAGE-1) * $alb_per_page; $upper_limit = min($nbAlb, $PAGE * $alb_per_page); $limit = "LIMIT " . $lower_limit . "," . ($upper_limit - $lower_limit); $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '. 'filename, url_prefix, pwidth, pheight '. 'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '. 'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '. 'ON a.thumb=p.pid '. 'WHERE category='.$cat.$album_filter. ' ORDER BY a.pos '. $limit; $alb_thumbs_q = db_query($sql); $alb_thumbs = db_fetch_rowset($alb_thumbs_q); mysql_free_result($alb_thumbs_q); $disp_album_count = count($alb_thumbs); $album_set = ''; foreach($alb_thumbs as $value) { $album_set .= $value['aid'] . ', '; } $album_set = '(' . substr($album_set, 0, -2) . ')'; $sql = "SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload ". "FROM {$CONFIG['TABLE_PICTURES']} ". "WHERE aid IN $album_set AND approved = 'YES' ". "GROUP BY aid"; $alb_stats_q = db_query($sql); $alb_stats = db_fetch_rowset($alb_stats_q); mysql_free_result($alb_stats_q); foreach($alb_stats as $key => $value) { $cross_ref[$value['aid']] = &$alb_stats[$key]; } for ($alb_idx = 0; $alb_idx < $disp_album_count; $alb_idx++) { $alb_thumb = &$alb_thumbs[$alb_idx]; $aid = $alb_thumb['aid']; if (isset($cross_ref[$aid])) { $alb_stat = $cross_ref[$aid]; $count = $alb_stat['pic_count']; } else { $alb_stat = array(); $count = 0; } // Inserts a thumbnail if the album contains 1 or more images $visibility = $alb_thumb['visibility']; if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || in_array($visibility, $USER_DATA['groups']) || $USER_DATA['can_see_all_albums'] || $CONFIG['allow_private_albums']==0) { if ($count > 0) { if ($alb_thumb['filename']) { $picture = &$alb_thumb; } else { $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight ". "FROM {$CONFIG['TABLE_PICTURES']} ". "WHERE pid='{$alb_stat['last_pid']}'"; $result = db_query($sql); $picture = mysql_fetch_array($result); mysql_free_result($result); } $pic_url = get_pic_url($picture, 'thumb'); if (!is_image($picture['filename'])) { $image_info = getimagesize($pic_url); $picture['pwidth'] = $image_info[0]; $picture['pheight'] = $image_info[1]; } $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"{$picture['filename']}\"$ "; } else { // Inserts an empty thumbnail if the album contains 0 images $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"\"$ "; } } elseif ($CONFIG['show_private']) { $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"\"$ "; } // Prepare everything if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || in_array($visibility, $USER_DATA['groups']) || $USER_DATA['can_see_all_albums'] || $CONFIG['allow_private_albums']==0) { $last_upload_date = $count ? localised_date($alb_stat['last_upload'], $lastup_date_fmt) : ''; $alb_list[$alb_idx]['aid'] = $alb_thumb['aid']; $alb_list[$alb_idx]['album_title'] = $alb_thumb['title']; $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']); $alb_list[$alb_idx]['pic_count'] = $count; $alb_list[$alb_idx]['last_upl'] = $last_upload_date; $alb_list[$alb_idx]['album_info'] = sprintf($lang_list_albums['n_pictures'], $count) . ($count ? sprintf($lang_list_albums['last_added'], $last_upload_date) : ""); $alb_list[$alb_idx]['album_adm_menu'] = (GALLERY_ADMIN_MODE || (USER_ADMIN_MODE && $cat == USER_ID + FIRST_USER_CAT)) ? html_albummenu($alb_thumb['aid']) : ' '; } elseif ($CONFIG['show_private']) { // uncomment this else block to show private album description $last_upload_date = $count ? localised_date($alb_stat['last_upload'], $lastup_date_fmt) : ''; $alb_list[$alb_idx]['aid'] = $alb_thumb['aid']; $alb_list[$alb_idx]['album_title'] = $alb_thumb['title']; $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']); $alb_list[$alb_idx]['pic_count'] = $count; $alb_list[$alb_idx]['last_upl'] = $last_upload_date; $alb_list[$alb_idx]['album_info'] = sprintf($lang_list_albums['n_pictures'], $count) . ($count ? sprintf($lang_list_albums['last_added'], $last_upload_date) : ""); $alb_list[$alb_idx]['album_adm_menu'] = (GALLERY_ADMIN_MODE || (USER_ADMIN_MODE && $cat == USER_ID + FIRST_USER_CAT)) ? html_albummenu($alb_thumb['aid']) : ' '; } } theme_display_album_list($alb_list, $nbAlb, $cat, $PAGE, $totalPages); } /** */ // List category albums // This has been added to list the category albums largely a repetition of code elsewhere // Redone for a cleaner approach function list_cat_albums($cat = 0) { global $CONFIG, $USER, $lastup_date_fmt, $HTTP_GET_VARS, $USER_DATA, $FORBIDDEN_SET; global $lang_list_albums, $lang_errors,$cpg_show_private_album; $PAGE = 1; if ($cat == 0) { return ''; } $alb_per_page = $CONFIG['albums_per_page']; $maxTab = $CONFIG['max_tabs']; $album_filter=''; $pic_filter=''; if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) { $album_filter = ' and '.str_replace('p.','a.',$FORBIDDEN_SET); $pic_filter = ' and '.$FORBIDDEN_SET; } $sql = "SELECT count(*) FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE category = '$cat'".$album_filter; $result = db_query($sql); $nbEnr = mysql_fetch_array($result); $nbAlb = $nbEnr[0]; mysql_free_result($result); if ($nbAlb == 0) { return; } $totalPages = ceil($nbAlb / $alb_per_page); if ($PAGE > $totalPages) $PAGE = 1; $lower_limit = ($PAGE-1) * $alb_per_page; $upper_limit = min($nbAlb, $PAGE * $alb_per_page); $limit = "LIMIT " . $lower_limit . "," . ($upper_limit - $lower_limit); /* $sql = "SELECT a.aid, a.title, a.description, visibility, filepath, ". "filename, url_prefix, pwidth, pheight ". "FROM {$CONFIG['TABLE_ALBUMS']} as a ". "LEFT JOIN {$CONFIG['TABLE_PICTURES']} as p ON thumb=pid ". "WHERE category = $cat ORDER BY a.pos ".$limit; */ $sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '. 'filename, url_prefix, pwidth, pheight '. 'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '. 'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '. 'ON a.thumb=p.pid '. 'WHERE category='.$cat.$album_filter. ' ORDER BY a.pos '. $limit; $alb_thumbs_q = db_query($sql); $alb_thumbs = db_fetch_rowset($alb_thumbs_q); mysql_free_result($alb_thumbs_q); $disp_album_count = count($alb_thumbs); $album_set = ''; foreach($alb_thumbs as $value) { $album_set .= $value['aid'] . ', '; } $album_set = '(' . substr($album_set, 0, -2) . ')'; $sql = "SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload ". "FROM {$CONFIG['TABLE_PICTURES']} ". "WHERE aid IN $album_set AND approved = 'YES' ". "GROUP BY aid"; $alb_stats_q = db_query($sql); $alb_stats = db_fetch_rowset($alb_stats_q); mysql_free_result($alb_stats_q); foreach($alb_stats as $key => $value) { $cross_ref[$value['aid']] = &$alb_stats[$key]; } for ($alb_idx = 0; $alb_idx < $disp_album_count; $alb_idx++) { $alb_thumb = &$alb_thumbs[$alb_idx]; $aid = $alb_thumb['aid']; if (isset($cross_ref[$aid])) { $alb_stat = $cross_ref[$aid]; $count = $alb_stat['pic_count']; } else { $alb_stat = array(); $count = 0; } // Inserts a thumbnail if the album contains 1 or more images $visibility = $alb_thumb['visibility']; if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || in_array($visibility, $USER_DATA['groups']) || $USER_DATA['can_see_all_albums'] || $CONFIG['allow_private_albums']==0) { // test for visibility if ($count > 0) { // Inserts a thumbnail if the album contains 1 or more images if ($alb_thumb['filename']) { $picture = &$alb_thumb; } else { $sql = "SELECT filepath, filename, url_prefix, pwidth, pheight " . "FROM {$CONFIG['TABLE_PICTURES']} " . "WHERE pid='{$alb_stat['last_pid']}'"; $result = db_query($sql); $picture = mysql_fetch_array($result); mysql_free_result($result); } $pic_url = get_pic_url($picture, 'thumb'); if (!is_image($picture['filename'])) { $image_info = getimagesize($pic_url); $picture['pwidth'] = $image_info[0]; $picture['pheight'] = $image_info[1]; } $image_size = compute_img_size($picture['pwidth'], $picture['pheight'], $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"{$picture['filename']}\"$ "; } else { // Inserts an empty thumbnail if the album contains 0 images $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"\"$ "; } } elseif ($CONFIG['show_private']) { $image_size = compute_img_size(100, 75, $CONFIG['alb_list_thumb_size']); $alb_list[$alb_idx]['thumb_pic'] = " $\"\"$ "; } // Prepare everything if ($visibility == '0' || $visibility == (FIRST_USER_CAT + USER_ID) || in_array($visibility, $USER_DATA['groups']) || $USER_DATA['can_see_all_albums']) { $last_upload_date = $count ? localised_date($alb_stat['last_upload'], $lastup_date_fmt) : ''; $alb_list[$alb_idx]['aid'] = $alb_thumb['aid']; $alb_list[$alb_idx]['album_title'] = $alb_thumb['title']; $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']); $alb_list[$alb_idx]['pic_count'] = $count; $alb_list[$alb_idx]['last_upl'] = $last_upload_date; $alb_list[$alb_idx]['album_info'] = sprintf($lang_list_albums['n_pictures'], $count) . ($count ? sprintf($lang_list_albums['last_added'], $last_upload_date) : ""); $alb_list[$alb_idx]['album_adm_menu'] = (GALLERY_ADMIN_MODE || (USER_ADMIN_MODE && $cat == USER_ID + FIRST_USER_CAT)) ? html_albummenu($alb_thumb['aid']) : ''; } elseif ($CONFIG['show_private']) { // uncomment this else block to show private album description $last_upload_date = $count ? localised_date($alb_stat['last_upload'], $lastup_date_fmt) : ''; $alb_list[$alb_idx]['aid'] = $alb_thumb['aid']; $alb_list[$alb_idx]['album_title'] = $alb_thumb['title']; $alb_list[$alb_idx]['album_desc'] = bb_decode($alb_thumb['description']); $alb_list[$alb_idx]['pic_count'] = $count; $alb_list[$alb_idx]['last_upl'] = $last_upload_date; $alb_list[$alb_idx]['album_info'] = sprintf($lang_list_albums['n_pictures'], $count) . ($count ? sprintf($lang_list_albums['last_added'], $last_upload_date) : ""); $alb_list[$alb_idx]['album_adm_menu'] = (GALLERY_ADMIN_MODE || (USER_ADMIN_MODE && $cat == USER_ID + FIRST_USER_CAT)) ? html_albummenu($alb_thumb['aid']) : ''; } } ob_start(); theme_display_album_list_cat($alb_list, $nbAlb, $cat, $PAGE, $totalPages); $cat_albums = ob_get_contents(); ob_end_clean(); return $cat_albums; } /** */ /** * Main code */ if (isset($HTTP_GET_VARS['page'])) { $PAGE = max((int)$HTTP_GET_VARS['page'], 1); $USER['lap'] = $PAGE; } elseif (isset($USER['lap'])) { $PAGE = max((int)$USER['lap'], 1); } else { $PAGE = 1; } if (isset($HTTP_GET_VARS['cat'])) { $cat = (int)$HTTP_GET_VARS['cat']; } // Gather data for categories $breadcrumb = ''; $cat_data = array(); $statistics = ''; $STATS_IN_ALB_LIST = false; $cpg_show_private_album = ($CONFIG['allow_private_albums'])?($CONFIG['show_private']):(true); get_cat_list($breadcrumb, $cat_data, $statistics); pageheader($BREADCRUMB_TEXT ? $BREADCRUMB_TEXT : $lang_index_php['welcome']); $elements = preg_split("|/|", $CONFIG['main_page_layout'], -1, PREG_SPLIT_NO_EMPTY); foreach ($elements as $element) { if (preg_match("/(\w+),*(\d+)*/", $element, $matches)) switch ($matches[1]) { case 'breadcrumb': // Added breadcrumb as a separate listable block from config if (($breadcrumb != '' || count($cat_data) > 0) && $cat !=0 ) theme_display_breadcrumb($breadcrumb, $cat_data); break; case 'catlist': if ($breadcrumb != '' || count($cat_data) > 0) theme_display_cat_list($breadcrumb, $cat_data, $statistics); if (isset($cat) && $cat == USER_GAL_CAT) list_users(); flush(); break; case 'alblist': list_albums(); flush(); break; case 'random': display_thumbnails('random', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'lastup': display_thumbnails('lastup', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'lastalb': display_thumbnails('lastalb', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); break; case 'topn': display_thumbnails('topn', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'toprated': display_thumbnails('toprated', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'lastcom': display_thumbnails('lastcom', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'lasthits': display_thumbnails('lasthits', $cat, 1, $CONFIG['thumbcols'], max(1, $matches[2]), false); flush(); break; case 'anycontent': if ($cat == 0) { include('anycontent.php'); } flush(); break; } } pagefooter(); ob_end_flush(); // Speed-up the random image query by 'keying' the image table if (time() - $CONFIG['randpos_interval'] > 86400) { $result = db_query("SELECT count(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE 1"); $nbEnr = mysql_fetch_array($result); mysql_free_result($result); $pic_count = $nbEnr[0]; $granularity = floor($pic_count / RANDPOS_MAX_PIC); $result = db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET randpos = ROUND(RAND()*$granularity) WHERE 1"); $result = db_query("UPDATE {$CONFIG['TABLE_CONFIG']} SET value = '" . time() . "' WHERE name = 'randpos_interval'"); } ?>