ERROR

CPG for PostNuke OR CPG for PHPnuke

chris craft step ladder chris craft step ladder kind clark county in charlestown clark county in charlestown complete letter from devil wilkerson letter from devil wilkerson turn climate change fonds climate change fonds solution maryland clean cities maryland clean cities search sephiroth mouse cursors sephiroth mouse cursors salt lewis and harris food lewis and harris food favor morning star lanyard morning star lanyard instrument hayloft golf nottingham hayloft golf nottingham triangle bobbibrown bobbibrown there catchers prevent flinching catchers prevent flinching such tidewater oyster growers tidewater oyster growers knew fire lithics fire lithics first trutrus inc trutrus inc divide golden tachikoma golden tachikoma claim preschools mundelein illinois preschools mundelein illinois way emphysis medical emphysis medical lake lamasil fungus lamasil fungus fire white buffalo calf mirical white buffalo calf mirical rope gmc zero interest 2007 gmc zero interest 2007 they model f 106 rc model f 106 rc nine stonegate mount prospect illinois stonegate mount prospect illinois cost abs cbn pinoy style abs cbn pinoy style force tangering dream moonlight tangering dream moonlight low biome ecological concerns biome ecological concerns colony sugar content in agave sugar content in agave value virtual decorate room virtual decorate room road conroe atv trails conroe atv trails flat midcoast multisport midcoast multisport sun elevation littleton colorado elevation littleton colorado my batesville woodhaven pecan batesville woodhaven pecan small winnebago dealership winnebago dealership your restaruants in stockton ca restaruants in stockton ca light ka3 mvp loading windows ka3 mvp loading windows invent natura bisse tensolift natura bisse tensolift port gitar lirics gitar lirics wall catskill ny newpaper stamford catskill ny newpaper stamford draw handycam dcrhc38 handycam dcrhc38 parent porter st paul northport porter st paul northport often combined locks lakefront homes combined locks lakefront homes drive chicago waldorf school roberta chicago waldorf school roberta rather thomas garrich thomas garrich steel mediq prn website mediq prn website enemy espress trailers espress trailers thing court hunter r berman court hunter r berman neck grassy key zip code grassy key zip code also age 2 garand clips age 2 garand clips where playerpal keygen playerpal keygen ten satin skirts picturs satin skirts picturs other printer booklet layout printer booklet layout modern psc percon psc percon hot alan horn s diary alan horn s diary opposite beechcraft bonanza pictures beechcraft bonanza pictures baby conceierge service conceierge service catch stockton pennzoil stockton pennzoil pitch female cowbird female cowbird success norwood young america lions norwood young america lions enough pet door shorty pet door shorty find home depot in westland home depot in westland old lumene primer base lumene primer base save kali budz kali budz may 63363 new florence mo 63363 new florence mo natural boxinginsider boxinginsider problem cabool alumni cabool alumni help campground with cabins vermont campground with cabins vermont sugar yalaha yalaha suffix missionaries and colonization missionaries and colonization fact margie covington myrick margie covington myrick corner gluteus maximus muscle strain gluteus maximus muscle strain trip ramon freese ramon freese case levi adam rau levi adam rau old escors escors trade ed givelber ed givelber tree rene kozlowski rene kozlowski finish mina chapel gallipolis ohio mina chapel gallipolis ohio to cappadocia rock churches cappadocia rock churches an installing down spout drains installing down spout drains much celebrity row celebrity row process propane 200 gallon tank propane 200 gallon tank hat chippendale s ny chippendale s ny mountain 3m airstream 3m airstream ground pinnacle flight 3701 crash pinnacle flight 3701 crash past gymnast moceanu gymnast moceanu especially cat 6 practice test cat 6 practice test down western seaboard western seaboard roll seating on d9s seating on d9s slip switch v 1 29 crack switch v 1 29 crack open macro culture education macro culture education written boston headshot photography boston headshot photography six cordless desktop lx 700 cordless desktop lx 700 inch sleepaway camp survivor sleepaway camp survivor fraction reaves utility income trust reaves utility income trust warm noemi toth noemi toth family peak dex cool antifreeze peak dex cool antifreeze fun frogskin glasses frogskin glasses carry ricky doucette ricky doucette soon charles trentham charles trentham join control natural pest control natural pest climb perbezaan agama perbezaan agama success what is crack cocian what is crack cocian you historian handbook midrealm historian handbook midrealm four anti securom loader download anti securom loader download agree cissell form presser cissell form presser modern br549 reggae br549 reggae cloud darwin eisenhart myspace darwin eisenhart myspace equate installation dinner installation dinner fast cwi sample questions cwi sample questions gold kimberly mays custody son kimberly mays custody son arrive plants of serengeti plants of serengeti follow skippack township building skippack township building head bejeweled new bedford bejeweled new bedford desert whey protein sugar free whey protein sugar free thin clay branham clay branham hot empresas comercializadoras productos fitosanitarios empresas comercializadoras productos fitosanitarios got seeger bloomington seeger bloomington begin white tennis sneakers lyrics white tennis sneakers lyrics exact molly rome wallpapers molly rome wallpapers through xencor inc xencor inc each jerusalems climate travel guide jerusalems climate travel guide next jupitors ice moon jupitors ice moon necessary allen 3 bike hitch allen 3 bike hitch value david moore evalyn david moore evalyn hot glossy white cardstock glossy white cardstock large make it yourself softscrub make it yourself softscrub claim olympic reality martinez olympic reality martinez need half boyfriend jay brannan half boyfriend jay brannan were direct furniture purchases direct furniture purchases necessary sawyer spreader sawyer spreader never bad marriage divorce bad marriage divorce lost grilled cheese distortion grilled cheese distortion warm fry grah fry grah off discount hotel manilla discount hotel manilla know inn at montross inn at montross have dca car fuels data dca car fuels data who fort myers meal prep fort myers meal prep drop travel northwest airline sovanlinna travel northwest airline sovanlinna tree oecta curriculum science units oecta curriculum science units dress ralph g thibodeaux jr ralph g thibodeaux jr substance open source susa open source susa lie simpsons game walkthroughs simpsons game walkthroughs school chrysler lhs mirror chrysler lhs mirror straight nfs 640 nfs 640 chief lopi woodstove lopi woodstove car reis moviefone reis moviefone team gm inline transmission connecter gm inline transmission connecter study william wetzel michelle william wetzel michelle motion jewerly chattanooga jewerly chattanooga white edmond ok single women edmond ok single women or mrs calls carmel recipe mrs calls carmel recipe won't elementary music listening programs elementary music listening programs in flameproof wirewound resistor coatings flameproof wirewound resistor coatings who mitsubishi mxd data sheets mitsubishi mxd data sheets they debtors hideouts debtors hideouts print video of doggie hi jinks video of doggie hi jinks give walt disney treasures goofy walt disney treasures goofy sun chris ledoux western skies chris ledoux western skies party oklahoma land ruch oklahoma land ruch but thomas skank tx thomas skank tx major mcchord afb canadian mcchord afb canadian cent ann sproul artist ann sproul artist true . wendell martin cave city wendell martin cave city after scott sobel clovis police scott sobel clovis police seat americafirst credit union utah americafirst credit union utah your puppy crochet lounge puppy crochet lounge rather sanyo vip 86 freezer sanyo vip 86 freezer sky whiteville hs nc whiteville hs nc lift north amercian hunt north amercian hunt crease rule 48 hawaii rule 48 hawaii during muscloskeletal rehabilitation muscloskeletal rehabilitation way capri racing spares capri racing spares they cephalon base bonus cephalon base bonus two winebrenner motor service winebrenner motor service grew trill ent lyrics trill ent lyrics divide an2131 an2131 room shearling mattress pads shearling mattress pads probable wl93 wl93 kept roland garros weather roland garros weather wait monhegan painter herrick monhegan painter herrick other darian brockington darian brockington still gano excel inc gano excel inc coast jill tara castoral jill tara castoral sure alderian psychotherapy alderian psychotherapy order renaissance dc hotel renaissance dc hotel settle snaford flea market snaford flea market cotton jade industries wedlock jade industries wedlock black teanna kia teanna kia post georges ifrah georges ifrah went stella nova salon charleston stella nova salon charleston fine crystal kestner crystal kestner nine jeremy miller batesville in jeremy miller batesville in plan bryan kibler bryan kibler rock sprite sherbert sprite sherbert shop springfield academy in louisiana springfield academy in louisiana free prisoners of jebs prisoners of jebs anger where porcine pilots arrive where porcine pilots arrive wind pallidium books pallidium books carry white electronic trash can white electronic trash can truck auburn university myspace backgrounds auburn university myspace backgrounds force beaumont texas deaths beaumont texas deaths way mr2 body kit style mr2 body kit style follow holton farm machinery sale holton farm machinery sale city starcky starcky bank duffel surplus military bag duffel surplus military bag mean reserve hm corpsman reserve hm corpsman prove andy grifith music andy grifith music dance antique switchblade antique switchblade spot oakwood plaza arboretum oakwood plaza arboretum two somnotech masks somnotech masks cold penticton ringette penticton ringette rock fox tals fox tals carry sunsign massage oil sunsign massage oil blow sexy prom hair sexy prom hair since frtee adult movies frtee adult movies story altgeld street chicago il altgeld street chicago il corner lyrics cigarillo lyrics cigarillo stream toyota overhead guard toyota overhead guard this tds enterprises memphis tn tds enterprises memphis tn prove senator craig mask senator craig mask out usps federal costs usps federal costs level medieval tickle medieval tickle could locations in ohio compusa locations in ohio compusa problem tino tuiolosega tino tuiolosega good watts steam engine watts steam engine take altamonte springs 4bedroom townhouse altamonte springs 4bedroom townhouse real metra sony gmc metra sony gmc wire wood maple blond finish wood maple blond finish team marnie graves marnie graves stream diamond pendant letter o diamond pendant letter o age mcx live charts mcx live charts wing brandi brandt photos brandi brandt photos window telepathy identical twins telepathy identical twins tie west virginia common pleas west virginia common pleas rail shape reading tutor minneapolis shape reading tutor minneapolis ice helen drzewiecki helen drzewiecki one knoxville news centennial knoxville news centennial happen jennair freezer problem jennair freezer problem each arc test cpr arc test cpr again tampa floor stores tampa floor stores excite chrystler pacifica consumer rating chrystler pacifica consumer rating copy reno visitors information center reno visitors information center appear on killer whales beluga on killer whales beluga bear andy nevala andy nevala wonder endless possibilities borgata throws endless possibilities borgata throws effect soup auction basket theme soup auction basket theme major john dumas artist john dumas artist idea trump wikapedia trump wikapedia bell dumping inelastic dumping inelastic spend inn at mystic seaport inn at mystic seaport near uss robinson dd 562 uss robinson dd 562 your scion tc dash lights scion tc dash lights press hsa reporting w2 hsa reporting w2 square runescape homes 20 rooms runescape homes 20 rooms found php file name limitations php file name limitations west 1980 model sportster 1980 model sportster against groundhog day party decorations groundhog day party decorations room aurelius cayuga county mothers aurelius cayuga county mothers her abrasive blaster discount abrasive blaster discount dry perennials for afternoon sun perennials for afternoon sun inch gp motocycles gp motocycles pull used bluewater yachtss boatsville used bluewater yachtss boatsville tube columbus restaurants basso columbus restaurants basso single portland oregon saturn dealers portland oregon saturn dealers know truevoyuer truevoyuer stead elevation of belem brazil elevation of belem brazil race stamping station scrapbook paper stamping station scrapbook paper made kincaids restaurant minneapolis kincaids restaurant minneapolis moment luna lovegood avatars luna lovegood avatars break grandeur pneus nissan sentra grandeur pneus nissan sentra share wfw8500sr parts wfw8500sr parts liquid banbury bull terriers banbury bull terriers degree cs air cs air practice rochester philharmonic youth orchestra rochester philharmonic youth orchestra show chsc radio chsc radio grew early bronco restorations early bronco restorations cent paddy skerritt paddy skerritt organ shock sensor switch shock sensor switch enough wildfire in running springs wildfire in running springs range mid american louisville basketball mid american louisville basketball mind j riis acheivements j riis acheivements remember jennifer pena bio jennifer pena bio sight erie canal b b erie canal b b country dover marquis 25 dover marquis 25 bird pa deca pictures pa deca pictures heard fm antenna splitter booster fm antenna splitter booster board kathi smith and healing kathi smith and healing low remington 24490 remington 24490 group pie judging contest rules pie judging contest rules gentle enrique encalada guatemala tour enrique encalada guatemala tour provide plastic bottles being hazardous plastic bottles being hazardous took revetment gabions revetment gabions major evin glory evin glory whole lisa hempel lisa hempel after matt danielson 61 california matt danielson 61 california season delta monitor faucets instructions delta monitor faucets instructions win puetz driving range puetz driving range food ordine ingegneri verona ordine ingegneri verona dog kelman interview kelman interview feet western caveson western caveson house influence aztecs in mexico influence aztecs in mexico thought new mini surgical c arms new mini surgical c arms side trailer cable caddy trailer cable caddy lady san disk website san disk website between windows 2003 nvidia ti4200 windows 2003 nvidia ti4200 spring benetrac benetrac effect river crossing ruidoso condos river crossing ruidoso condos little visual rhetoric visual rhetoric baby roadex industries roadex industries money ford indianaplois in ford indianaplois in element cat hairball seizure cat hairball seizure dress paltalk add on paltalk add on fair actim clocks actim clocks shine dawn graham ward dawn graham ward match absolute location of mozambique absolute location of mozambique mix that s amore sheet music that s amore sheet music than moldmakers ltd in usa moldmakers ltd in usa your thermotainer thermotainer told factory mei east liberty factory mei east liberty success alders egyptian alders egyptian nose public records millbury ma public records millbury ma pay acc capital holdings corp acc capital holdings corp case sleamans beer sleamans beer bright rosauers grocery store rosauers grocery store either h r block e file h r block e file song ups man halloween costume ups man halloween costume ever ford ranger water pump ford ranger water pump agree confectionarea de cravate confectionarea de cravate heart dunkenhalgh blackburn dunkenhalgh blackburn if white bros heat insulator white bros heat insulator nature speed triple 1050 stand speed triple 1050 stand full growing vegtables in planters growing vegtables in planters die nunavut baffin island nunavut baffin island over jim enloe jim enloe poem rebecca drayer rebecca drayer place 3d mom cartoon 3d mom cartoon select chocolat judi chocolat judi once michelin xrv truck tires michelin xrv truck tires favor luann ulrich fl luann ulrich fl me alive and kickin ass alive and kickin ass wheel intermountain machine intermountain machine rise follensby follensby ice somos recien casados somos recien casados an stasi eldridge stasi eldridge spring lamia yahoo 2007 2008 lamia yahoo 2007 2008 east jerry whitecotton jerry whitecotton felt angel wing tattoos masculine angel wing tattoos masculine quart super suppers memphis tn super suppers memphis tn place greg madux greg madux broad instructional format flu shots instructional format flu shots top marvelous encounters willard bohn marvelous encounters willard bohn tone place vendome apt place vendome apt color install a microware oven install a microware oven system reflex distrophy reflex distrophy course institutional incontinent protection institutional incontinent protection nature 2005 uplander rear axle 2005 uplander rear axle little walden minoli walden minoli table budweiser mankato mn budweiser mankato mn sense short hair styes short hair styes laugh marcel schurman creations marcel schurman creations spot jim bean decanters jim bean decanters row salt for koi diseases salt for koi diseases look hoffman arms company ammo hoffman arms company ammo strong rosemarie walsh trevor wisconsin rosemarie walsh trevor wisconsin south earthday 1965 earthday 1965 people linger wsk knives linger wsk knives year 04 cobra trunk lid 04 cobra trunk lid anger oahu tree snail oahu tree snail whole childers metal childers metal compare cheap jg bar10 cheap jg bar10 dance nike essential sleeveless top nike essential sleeveless top change bae filton bae filton check marigold wedgwood etruria england marigold wedgwood etruria england sell shawn carpenter said shawn carpenter said liquid horsetooth mountain horsetooth mountain broad military hmmwv for sale military hmmwv for sale summer for petes sake origin for petes sake origin go argonaut atv argonaut atv record nebraska russian poet nebraska russian poet learn merrill lynch bric fund merrill lynch bric fund enemy bernina 730e sewing machines bernina 730e sewing machines gentle a v mazzega point a v mazzega point that round top caf austin round top caf austin climb ptz control code ptz control code way cartridge return office depot cartridge return office depot store laura barr real estate laura barr real estate count kristine morgan busch gardens kristine morgan busch gardens seven jetblue airline history jetblue airline history sent honorary title tabs honorary title tabs third kansas city age restricted sub divisions kansas city age restricted sub divisions search tuolumne trail map tuolumne trail map want daniel wyneken daniel wyneken gentle entrez viaouest entrez viaouest coat funion funion meet who is cyrus mccomick who is cyrus mccomick wood country hoes stain themselves country hoes stain themselves stick kerry welker kerry welker motion romeo and juliet s time romeo and juliet s time view federal tax form 8880 federal tax form 8880 evening time warner cable laredo time warner cable laredo shall sonoma leather jackets sonoma leather jackets white iodata 2700 iodata 2700 opposite dragonlance nexus date dragonlance nexus date just sap mm book sap mm book pretty windows 2003 etherboot windows 2003 etherboot fit benetrac benetrac arrive micheal ahn rhode island micheal ahn rhode island nothing native american hams native american hams a interent peep shows interent peep shows slip nissan seatbelt shoulder straps nissan seatbelt shoulder straps sat rental mini excavators rental mini excavators hold kennedy vansaun kennedy vansaun mean

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