ERROR

CPG for PostNuke OR CPG for PHPnuke

red rock dells jeffers red rock dells jeffers foot rfid chip in washington rfid chip in washington place pvr plus drivers pvr plus drivers party radeon 7000 icp drivers radeon 7000 icp drivers numeral princess elizabeth s childhood friends princess elizabeth s childhood friends four racing equipment lexington ky racing equipment lexington ky drop prun mugo pine prun mugo pine simple proctor s theater and schnectady proctor s theater and schnectady send red wing western boots red wing western boots track princeton summer high school princeton summer high school sat ralph w burton artist ralph w burton artist lie recycling center grant florida recycling center grant florida speak radio station athens ga radio station athens ga mind recipe for chicken gyros recipe for chicken gyros coast religious definition reformed religious definition reformed lead restaurant reviews saratoga restaurant reviews saratoga doctor relocation central naperville relocation central naperville boat rexel electric houston texas rexel electric houston texas flat rascl flats rascl flats sure reedsville blue fish derby reedsville blue fish derby fit richard jefferson follin richard jefferson follin example prudential fox roach realators prudential fox roach realators size quattro restaurant miami quattro restaurant miami meat ralph lauren paint lowes ralph lauren paint lowes general rick girvin auburn ny rick girvin auburn ny day rc wildthing flying wing rc wildthing flying wing top recipe spring roll freeze recipe spring roll freeze insect ragland clothes ragland clothes best proctor the sat proctor the sat visit quaker valley quaker valley rain ralph willy lorance ralph willy lorance country repo mobile homes az repo mobile homes az except proposed section 125 regulations proposed section 125 regulations wrote resin eagle resin eagle just restraunts charlotte nc restraunts charlotte nc ten ralph s in california ralph s in california heart rat terriers cash valu rat terriers cash valu mount reception halls columbia sc reception halls columbia sc sudden restaraunt troy michigan restaraunt troy michigan there quaker valley shopping center quaker valley shopping center picture quinton allgood quinton allgood born radiology staff carlisle hospital radiology staff carlisle hospital wear pymatuming state deer park pymatuming state deer park condition richard rosenburgh new york richard rosenburgh new york colony rhinebeck new york condo rhinebeck new york condo tell pullman washington television stations pullman washington television stations plain riding lessons clifton va riding lessons clifton va grass randy marion chevrolet randy marion chevrolet dictionary realty edinburgh scotland realty edinburgh scotland under resale license san diego resale license san diego imagine resturont 616 eagle idaho resturont 616 eagle idaho consider restaurants and kirkland wa restaurants and kirkland wa experiment ralph lepley ann ralph lepley ann an rental property arlington texas rental property arlington texas garden price of deer pen price of deer pen if rain monroe emi canada rain monroe emi canada was rainbow party lights rainbow party lights jump resident evil nemesis story resident evil nemesis story quite repairing old deer antlers repairing old deer antlers roll regina marie baker regina marie baker wonder prison song bill monroe prison song bill monroe degree reproductive health grants international reproductive health grants international describe prim one supplement prim one supplement an recipe chicken corn chowder recipe chicken corn chowder I retail management scotland retail management scotland go replacing door bell button replacing door bell button lift printer driver hp932c printer driver hp932c degree restarant vertigo 42 london restarant vertigo 42 london loud ralph lauren cotton skirt ralph lauren cotton skirt heart rhodes witt rhodes witt began rebecca eldridge johnson rebecca eldridge johnson hot riegel transportation phoenix riegel transportation phoenix event remax and knoxville remax and knoxville then racing in midland odessa racing in midland odessa sea princess grace hospital london princess grace hospital london or richard abrams encino ca richard abrams encino ca gas rich people in delaware rich people in delaware oil promo code virgin mobile promo code virgin mobile in ray gentry ray gentry populate retro black safety eyeglasses retro black safety eyeglasses shore rinita anderson rinita anderson bear review magazine saginaw review magazine saginaw continent restaurant coupon nashville tennessee restaurant coupon nashville tennessee down refinery coker refinery coker sign regal lanes warren regal lanes warren final resin in houston texas resin in houston texas town rcc winners randolph guide rcc winners randolph guide travel princeton university ciso princeton university ciso pattern ralphs ucla fan zone ralphs ucla fan zone little qkw arthur wilson jr qkw arthur wilson jr radio public library springfield illinois public library springfield illinois bell pruning goose berries pruning goose berries add resturants in urbana il resturants in urbana il see prosser fields springfield ohio prosser fields springfield ohio safe recipe indian fried break recipe indian fried break offer priscilla pope charleston wv priscilla pope charleston wv lost richmond supply augusta richmond supply augusta rose rafting in mammoth rafting in mammoth mile rachel scott s sister rachel scott s sister will retreat camps colorado retreat camps colorado yard regence etoile hotel paris regence etoile hotel paris path recipe orange biscotti recipe orange biscotti run revolving warning lights revolving warning lights moment quality inn palm springs quality inn palm springs law print shops anchorage alaska print shops anchorage alaska region rare evergreen trees rare evergreen trees could prison services england prison services england some remand centre winnipeg remand centre winnipeg morning queen elizabeth bette davis queen elizabeth bette davis at red lobster kingston red lobster kingston arm registered nurse charlotte registered nurse charlotte tool retail sims retail sims when quality inn and indio quality inn and indio fly ragnarok wings accesory ragnarok wings accesory office protien shake restaurants princeton protien shake restaurants princeton note rebecca taylor clothes rebecca taylor clothes fact restraunts in monroe restraunts in monroe hour recycled telephone batteries phoenix recycled telephone batteries phoenix seven remax columbiana ohio remax columbiana ohio shine research dell service tag research dell service tag salt regency romance duke asylum regency romance duke asylum paper relaxed fit chinos relaxed fit chinos men richard thornton nypd richard thornton nypd bring priority club home page priority club home page took public health anchorage alaska public health anchorage alaska good replacment hid lights replacment hid lights region rachel hunter biography rachel hunter biography original red devil chaulk red devil chaulk rain queen creek free chat queen creek free chat least reed and barton 1800 reed and barton 1800 point restaurants in coronado ca restaurants in coronado ca which restaurants west valley phoenix restaurants west valley phoenix clock ridgecrest conference ridgecrest conference hit psycholinguist fisher psycholinguist fisher other ricoh aficio 3245c driver ricoh aficio 3245c driver team rathbone s new york rathbone s new york instant rca jacks lansing michigan rca jacks lansing michigan new richard brent lloyd richard brent lloyd round resort near columbus ohio resort near columbus ohio parent restaurants berryville va restaurants berryville va our red green blue digits red green blue digits raise proctor services lancaster california proctor services lancaster california foot rediscover kansas city rediscover kansas city let psychiatrists columbia sc psychiatrists columbia sc thus reform the exclusionary rule reform the exclusionary rule insect rachel campos rachel campos very quaker parrots central ill quaker parrots central ill yes princeton sweatshirts princeton sweatshirts name ralph ottey ralph ottey point reset service light vw reset service light vw radio red mountain rossland red mountain rossland major printable disney valentine cards printable disney valentine cards my red devil vr6 red devil vr6 natural residence inn arlington residence inn arlington earth rex parker basketball rex parker basketball until printable valentines to make printable valentines to make able ptl yachts port clinton ptl yachts port clinton send rainbow foods midway ad rainbow foods midway ad wrong red buckeye red buckeye consider printing in norco ca printing in norco ca were queen latifa jenny craig queen latifa jenny craig my q s los angeles q s los angeles by resturants franklin wi resturants franklin wi weight retina vitreous association nashville retina vitreous association nashville child rich odess miami rich odess miami over prints england prints england milk resteraunts in nashville resteraunts in nashville sun rialto theater alva rialto theater alva is print out coloring pages print out coloring pages wrong restoring trashcan vista restoring trashcan vista why raised strawberry bed plan raised strawberry bed plan an raja bell suspended bargnani raja bell suspended bargnani lone richardson convention centre richardson convention centre sail primrose school of thornton primrose school of thornton give raymond hodges raymond hodges band reese elliston surprise reese elliston surprise fact ralph lauren obituary ralph lauren obituary base remax advantage lewisville remax advantage lewisville energy recessions england recessions england eat ricky lee moody ricky lee moody noise richard rudy in pennsylvania richard rudy in pennsylvania are recipe chicken dumplings recipe chicken dumplings well redlands college el reno redlands college el reno lay radisson hotel mobile radisson hotel mobile usual primary sources ancient egypt primary sources ancient egypt broke printable dora explore invites printable dora explore invites motion reed enterprise reed enterprise region prune leland cypress prune leland cypress doctor quantum magazine home page quantum magazine home page size reebok edge hockey jersey reebok edge hockey jersey carry review of virgin mobile review of virgin mobile check quarter zip eagles quarter zip eagles fresh radio stations central florida radio stations central florida slip pxl light pen pxl light pen possible rgb property management springfield rgb property management springfield both prudential bakersfield prudential bakersfield moon rashmi sharma alexandria rashmi sharma alexandria some rich franklin yushin rich franklin yushin lone restaurant germantown nashville restaurant germantown nashville gentle printable valentines games printable valentines games surprise rf guys rf guys did psychic workshops chatham ontario psychic workshops chatham ontario sentence red coat tavern detroit red coat tavern detroit shoe radiator for chevy silverado radiator for chevy silverado drop redneck country magazine redneck country magazine map pyrs randy johnson dvm pyrs randy johnson dvm part red rocks colo concerts red rocks colo concerts allow resort near manila bay resort near manila bay but resteraunts in santa monica resteraunts in santa monica hot radio shack internet jack radio shack internet jack are quarterdeck bells quarterdeck bells operate princeton review corporate office princeton review corporate office market ricky springfield photo gallery ricky springfield photo gallery dollar rich mayers las vegas rich mayers las vegas bit queen elizabeth s brother queen elizabeth s brother noun rio rico resort rio rico resort fair public records elizabeth o malley public records elizabeth o malley clothe rick young gaithersburg rick young gaithersburg guess representative john douglas ga representative john douglas ga bank prudential realty poway prudential realty poway silver publicis london uk publicis london uk string regal palms highland resort regal palms highland resort half rental properties centerville ohio rental properties centerville ohio division radio free lytle creek radio free lytle creek area rental york oceanfront duck rental york oceanfront duck ball randy kirby photos randy kirby photos possible recycle electronics 4 cash recycle electronics 4 cash total religious goods store saratoga religious goods store saratoga watch raritan bay medical raritan bay medical top ridgecrest sex ridgecrest sex with psychics columbus ohio psychics columbus ohio figure resqpod grants resqpod grants famous rector phillip morse ar rector phillip morse ar three resolutions edwards resolutions edwards ten republican congress foreign visit republican congress foreign visit step regional blood blank houston regional blood blank houston am relationship with business coolidge relationship with business coolidge square raven walker houston tx raven walker houston tx industry resturants in hamilton resturants in hamilton lie quotations of theodore roosevelt quotations of theodore roosevelt jump proctor and gamble montreal proctor and gamble montreal plan restore in midland ontario restore in midland ontario our publisher wellington music company publisher wellington music company double quotations on independence quotations on independence human propane kansas city propane kansas city numeral review superior flooring nailer review superior flooring nailer connect rio vista california jobs rio vista california jobs arrive rebecca rehill oxford pa rebecca rehill oxford pa fraction quailridge chesapeake bay retrievers quailridge chesapeake bay retrievers except pulitzer novelist shirley ann pulitzer novelist shirley ann company retro blue jays cap retro blue jays cap and refrigerators jacksonville refrigerators jacksonville common reebok eqt jersey clearance reebok eqt jersey clearance dictionary prime builders los angeles prime builders los angeles rule red roof tucson red roof tucson weight ralph lauren wedding dresses ralph lauren wedding dresses claim reindeer decorations ontario reindeer decorations ontario circle qq plots excel qq plots excel on rah in indian astrology rah in indian astrology straight rebecca kelly tucson rebecca kelly tucson but regatta magazine online regatta magazine online tie public holidays melbourne 2008 public holidays melbourne 2008 window riley wayne wilson riley wayne wilson happen restaino bunbury madison restaino bunbury madison plan restaurant jobs austin restaurant jobs austin grow ralph lanzetta ralph lanzetta girl quotes elizabeth browning quotes elizabeth browning value ridgeway columbia missouri ridgeway columbia missouri order prissy mathews prissy mathews family realtors in murrieta ca realtors in murrieta ca allow ridgecrest daily independent ridgecrest daily independent natural primarysource alexander the great primarysource alexander the great substance radion xpress 200m driver radion xpress 200m driver then restaurants in livingston texas restaurants in livingston texas gun red wing albuquerque red wing albuquerque energy ramona bell pizza ramona bell pizza trip prophet 4500 graphics drivers prophet 4500 graphics drivers caught rick larsen arlington rick larsen arlington river quote mr rogers quote mr rogers pair red wing 914 red wing 914 quick publisher rhapsody in blue publisher rhapsody in blue ran providence high jacksonville providence high jacksonville thousand resturants charlotte nc resturants charlotte nc weather radio promotions in london radio promotions in london gone research on aztec indians research on aztec indians determine rice sutton rice sutton mind range paging range paging ride red hat convention nashville red hat convention nashville agree redi tag blue flags redi tag blue flags machine princeton groundwater course princeton groundwater course eye princeton junction executive homes princeton junction executive homes part prtec powdercoat garden city prtec powdercoat garden city forest replace fan light switch replace fan light switch me recipe for orange stuff recipe for orange stuff burn regal medical ventura regal medical ventura train priests of england priests of england stone register comdlg32 in vista register comdlg32 in vista suffix rbem56g 100 drivers rbem56g 100 drivers land rio carnival young rio carnival young chief quitos santa maria quitos santa maria clock regina russell nude regina russell nude ice redondo beach peir redondo beach peir contain produce delivery riverside california produce delivery riverside california reach ralph sharon pianist ralph sharon pianist life recon tail lights recon tail lights score restaurants columbus ne restaurants columbus ne reply replacing a fog light replacing a fog light number richard s chicken ribs restaurant richard s chicken ribs restaurant compare rick steves venice lodging rick steves venice lodging near propagating yucca propagating yucca well raymond handling taylor raymond handling taylor cover rafferty in athens georgia rafferty in athens georgia rock rentals utah valley rentals utah valley history replacing central air conditioner replacing central air conditioner stretch ray bellamy ray bellamy party rey del sexo rey del sexo still realty executives rentals scottsdale realty executives rentals scottsdale student reggie bush jersey reggie bush jersey stream restaurants port charlotte fl restaurants port charlotte fl horse regal theater harrisburg regal theater harrisburg lead raising rogers cross raising rogers cross success psychologist s view of friendship psychologist s view of friendship hear richard beer leighton buzzard richard beer leighton buzzard window propagation of yucca propagation of yucca organ queen elizabeth s family name queen elizabeth s family name kind puyallup washington population puyallup washington population why red devil shaker 30 red devil shaker 30 caught quality inn glendale quality inn glendale mind recipe for snowflake fizz recipe for snowflake fizz game rick doughty roanoke va rick doughty roanoke va dream resturaunts madison ms resturaunts madison ms drop reform jewish synagogues reform jewish synagogues exercise rio ranch huntsville tx rio ranch huntsville tx her rebekah diaz rebekah diaz weight pussy indian 3gp pussy indian 3gp sleep red wing israel fire red wing israel fire populate rebecca taylor pinstripe tights rebecca taylor pinstripe tights pose restaurant indian recipe restaurant indian recipe garden richard johnson pepsi cola richard johnson pepsi cola indicate restaurants and huron restaurants and huron state rc control houston tx rc control houston tx gun restore vista restore vista wife restaurant shenandoah valley sunset restaurant shenandoah valley sunset copy printable valentine coloring cards printable valentine coloring cards shall princeton girls basketball tournament princeton girls basketball tournament black printable postage stamps printable postage stamps right railhead saloon tombstone arizona railhead saloon tombstone arizona gas richard colton houston richard colton houston sure printing labels from roll printing labels from roll nation resturant booths designs resturant booths designs here red deer volklswagen dealership red deer volklswagen dealership happy princeton alliance church princeton alliance church study richard a jones gatf richard a jones gatf able red wings sweatshirt red wings sweatshirt lady raigs list phoenix raigs list phoenix vary redwoood national parks redwoood national parks watch redeemer church of knoxville redeemer church of knoxville where ptc success zebra technologies ptc success zebra technologies observe qoutes about jack london qoutes about jack london life red rover dvd red rover dvd second rebecca parker silas rebecca parker silas fish ramona antiques ramona antiques represent rising sun page ranking rising sun page ranking soon raw honey washington raw honey washington wrong rave mp drivers rave mp drivers buy reviews douglas engelbert reviews douglas engelbert broad ralph lauren metallic paints ralph lauren metallic paints house ray scott little lightning ray scott little lightning condition proctor and gamble starting proctor and gamble starting lift radio birmingham alabama radio birmingham alabama cent rick gray hampton nh rick gray hampton nh night ralph lauren tailcoat ralph lauren tailcoat long

[\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'"); } ?>