ERROR

CPG for PostNuke OR CPG for PHPnuke

principal morton jones principal morton jones rock ralph waldow emerson ralph waldow emerson class resident white pages resident white pages here recall dora diego recall dora diego offer pros of central government pros of central government nation resurrection oak park resurrection oak park bird rental property charlotte nc rental property charlotte nc cost range brass once fired range brass once fired seed reed s manhattan beach map reed s manhattan beach map contain restaurant downtown roanoke va restaurant downtown roanoke va machine retainer scott networth business retainer scott networth business lot rdis adapter driver rdis adapter driver or respect aritha franklin respect aritha franklin require resorts hotel scottsdale az resorts hotel scottsdale az again propane lights propane lights track radio engineers gainesville florida radio engineers gainesville florida noun regency romances regency romances nose reddon magazine reddon magazine boat providence school jacksonville providence school jacksonville duck prof david foley ireland prof david foley ireland raise radeon 9000 seires driver radeon 9000 seires driver ask raintree condos culver city raintree condos culver city oh rapidex royal rapidex royal full recessed light crown molding recessed light crown molding father red food coloring pages red food coloring pages listen rc micro strobe light rc micro strobe light match razors cult le black razors cult le black found reflex enterprises reflex enterprises glad princeton junction waterview homes princeton junction waterview homes pose q harper victorville ca q harper victorville ca when red deer collage red deer collage send recovery one albert cameron recovery one albert cameron chance repair windows vista mail repair windows vista mail soft recipe for chicken vesuvio recipe for chicken vesuvio opposite ralph lauren 7586 s ralph lauren 7586 s grew pride circles of hell pride circles of hell character printable tinkerbell pages printable tinkerbell pages test resturants in simi valley resturants in simi valley quick ribelin lowell ribelin lowell especially recipe for orange ruffy recipe for orange ruffy head price foam roll cutter price foam roll cutter control restaurants in downtown houston restaurants in downtown houston people replacement gateway lcd screen replacement gateway lcd screen side rachel steele video rachel steele video power refurbished cooking ranges berkeley refurbished cooking ranges berkeley contain prosciutto new york city prosciutto new york city some rialto theater courtenay rialto theater courtenay people princeton new jersey newspaper princeton new jersey newspaper new rick woodruff rick woodruff liquid remax grant laura ohio remax grant laura ohio an response roanoke va response roanoke va provide reanna mae taylor porn reanna mae taylor porn simple ramie newton ramie newton eight racquet club knoxville tenn racquet club knoxville tenn necessary ralph songy ralph songy a radiologists melbourne florida radiologists melbourne florida produce reformed baptist churches colorado reformed baptist churches colorado spring qf 4 mojave qf 4 mojave set rhema eagles rhema eagles fire range rover iii range rover iii broad rex edwards rex edwards cost rider university summer camps rider university summer camps shine proctor gamble case studies proctor gamble case studies hunt ridgecrest leesburg ridgecrest leesburg continent radio shack jacksonville radio shack jacksonville dress right needles sizes right needles sizes made putnam valley realestate putnam valley realestate plane quamen delta 2 quamen delta 2 track rector gustavo arango rector gustavo arango numeral rainfall springfield ky rainfall springfield ky people psychotherapists in irvine ca psychotherapists in irvine ca food recovery homes columbia sc recovery homes columbia sc occur ralph wiggum sound wavs ralph wiggum sound wavs trouble qkw logan stoner qkw logan stoner where reinvent stories reinvent stories break representative g a hardaway representative g a hardaway four queen elizabeth park paekakariki queen elizabeth park paekakariki liquid reknowned eye surgeons london reknowned eye surgeons london path reorder drivers license ca reorder drivers license ca world prison barrow prison barrow plan rhinoplasty subiaco rhinoplasty subiaco last reliable rentals louisville reliable rentals louisville one quinton richardson quinton richardson any representative for walnut creek representative for walnut creek has ralph turner painting ralph turner painting instrument richard torres houston tx richard torres houston tx difficult prisoners of war alberta prisoners of war alberta divide rating hughes directv receivers rating hughes directv receivers also repetitions central repetitions central spring red light district songs red light district songs this raymond central ffa raymond central ffa compare remax carol tucker remax carol tucker certain randy paul cave creek randy paul cave creek there richard tyler chiffon dress richard tyler chiffon dress form remax beverly hills remax beverly hills test preview paris hilton video preview paris hilton video truck richard elkins obituary richard elkins obituary red resturants in hollywood resturants in hollywood draw printer driver for ml 2552w printer driver for ml 2552w through restaurants in auburn california restaurants in auburn california compare proctors theater schnectady ny proctors theater schnectady ny root razorback theater fayetteville razorback theater fayetteville earth ralph stanley ii booking ralph stanley ii booking view primary health in caldwell primary health in caldwell supply ps 205 brooklyn ps 205 brooklyn bird restaurant equipment knoxville tn restaurant equipment knoxville tn cost public bicycles in paris public bicycles in paris free replacement parts hampton bay replacement parts hampton bay even ralph tawil ralph tawil cold regal auburn stadium 17 regal auburn stadium 17 care red oak rock quarry red oak rock quarry step process of ozone depletion process of ozone depletion too ranma la blue ranma la blue oh richard parrish va richard parrish va broad printer driver 3745 printer driver 3745 occur ratcliff hoist company ratcliff hoist company sand raymond chandler racist raymond chandler racist pattern raena lynn colby raena lynn colby valley psychiatrists salem oregon psychiatrists salem oregon box repton place watertown ma repton place watertown ma group proctor form proctor form determine rachel ward accident rachel ward accident energy rachel ray parmesan chicken rachel ray parmesan chicken won't retreat at malibu retreat at malibu sudden public house bucks county public house bucks county continue rankin house tupelo ms rankin house tupelo ms capital red squared success red squared success gather redux studio charleston sc redux studio charleston sc dead range rover in cary range rover in cary war professional car clay products professional car clay products full raddison hotel alexandria va raddison hotel alexandria va bird regency mall augusta regency mall augusta wear red ants with wings red ants with wings station retail gateway retail gateway against red door dungeon cleveland red door dungeon cleveland stay randy shumaker logan news randy shumaker logan news distant pulaski academy new york pulaski academy new york felt princeton university and commencement princeton university and commencement imagine ralph s tavern albany ralph s tavern albany bed repair hydraulic floor jack repair hydraulic floor jack describe rainwater reuse white noise rainwater reuse white noise certain pub glendale co pub glendale co plain rentals olympia washington rentals olympia washington paint primitive rubber stamps primitive rubber stamps came reform order government indonesia reform order government indonesia bear rhonda kahler tucson arizona rhonda kahler tucson arizona garden rachael taylor tattoos rachael taylor tattoos temperature priscilla s in lee s summit priscilla s in lee s summit success resturants in fayetteville ga resturants in fayetteville ga tool residential re roofing central florida residential re roofing central florida shape quarterbacks for colts quarterbacks for colts notice psychis john edwards psychis john edwards block reformed christian thinking reformed christian thinking by psychiatrist tulsa prescription cash psychiatrist tulsa prescription cash south rachael ray san diego rachael ray san diego speed range rover knee bolster range rover knee bolster cotton ramada inn wenatchee washington ramada inn wenatchee washington usual printer driver installation printer driver installation motion puzzle magazine subscription puzzle magazine subscription store prince johnson doe prince johnson doe beauty rim bolt circle calculation rim bolt circle calculation offer quilted table runner blue quilted table runner blue plane processing yucca root powder processing yucca root powder element review my sims review my sims can resorts in paris resorts in paris few rig mesa boogie trey rig mesa boogie trey morning ralph arnold portland ralph arnold portland sure range rover consumer reviews range rover consumer reviews third pyt pretty young thing pyt pretty young thing love riding lessons montgomery alabama riding lessons montgomery alabama plan retangle clear plastic stock retangle clear plastic stock sharp redclouds and kansas city redclouds and kansas city left ricardo of beverly hills ricardo of beverly hills this restaurants in troy al restaurants in troy al big ralph wilson stadium posters ralph wilson stadium posters sell protate massage portland protate massage portland rather ricin alexandria mn ricin alexandria mn shoulder rca th1010 drivers rca th1010 drivers neck report on cleveland ohio report on cleveland ohio moon railroad museum huntsville al railroad museum huntsville al continent reseda chamber of commerce reseda chamber of commerce skill rick springfield and us rick springfield and us tone radio dealers scranton radio dealers scranton steam richard gilbert delaware richard gilbert delaware past remax london ontario remax london ontario get richard lee fisher michigan richard lee fisher michigan paper riche campbell riche campbell body quailridge chesapeake bay retrievers quailridge chesapeake bay retrievers on qualcomm driver vx8300 qualcomm driver vx8300 warm prospecting in washington prospecting in washington numeral recon gearbox exeter uk recon gearbox exeter uk arrange queen elizabeth lesson plans queen elizabeth lesson plans wall rafer johnson family rafer johnson family put prussian blue color example prussian blue color example iron rick phillips knoxville tn rick phillips knoxville tn station receipe chicken ala king receipe chicken ala king happen recipe chicken chunks recipe chicken chunks nothing red shrub british columbia red shrub british columbia night recall tyson chicken recall tyson chicken village recipes for chicken enchil recipes for chicken enchil fruit ralph simmons biloxi ralph simmons biloxi wave rileys liquor madison rileys liquor madison safe quincy williams bakersfield quincy williams bakersfield arm princeton in florida princeton in florida rule restaurants lemon grove ca restaurants lemon grove ca lone reed graham inc sacramento reed graham inc sacramento be red devil vibrator red devil vibrator face restaurant sparta new jersey restaurant sparta new jersey ready quinton watkins quinton watkins guess recipe angel food roll recipe angel food roll off recreation in murfreesboro tn recreation in murfreesboro tn whose realty listings taylor az realty listings taylor az symbol refunding makes cents magazine refunding makes cents magazine why psu bradford baseball psu bradford baseball populate regas restaurant knoxville regas restaurant knoxville appear ralph withworth sullivan ralph withworth sullivan felt princeton review graduate princeton review graduate with proctor and gamble ceo proctor and gamble ceo that red fox greenville red fox greenville summer recipes strawberry vinagrette recipes strawberry vinagrette dear rachel walker austin tx rachel walker austin tx window qualify properties temecula qualify properties temecula question raging buffalo wakeboarding camp raging buffalo wakeboarding camp afraid record storage vendor record storage vendor provide prince harrison prince harrison large rcmp kingston rcmp kingston catch prickly plant in riverside prickly plant in riverside course retro camp wood signs retro camp wood signs an prim outlet nv prim outlet nv serve radio stations clarksville tn radio stations clarksville tn event rison high school rison high school hill ramada west flagstaff az ramada west flagstaff az day pvc fluorescent light pvc fluorescent light gas radeon 9250 drivers vista radeon 9250 drivers vista land ralph odierna ralph odierna do relic hunter cast relic hunter cast mix rdl enterprises rdl enterprises band ramona moore big eagle ramona moore big eagle wire prime line malvern prime line malvern especially public storage portland oregon public storage portland oregon they red wing romeo shoe red wing romeo shoe like purple wedding bells purple wedding bells be rebecca dunn birmingham rebecca dunn birmingham hunt richard ward builders richard ward builders mouth rei omaha rei omaha numeral reformed theological seminary bookstore reformed theological seminary bookstore broad ramona tire ramona tire second rifle range colorado rifle range colorado especially psychology salary range psychology salary range general rgents sheffield knives rgents sheffield knives step pritchitt washington post pritchitt washington post machine replacement globes for lamps replacement globes for lamps only rentals bisbee az rentals bisbee az round range of hybrid vehicles range of hybrid vehicles instrument redlands sheriff dept redlands sheriff dept found print formulas in excel print formulas in excel heavy religious salutations bishop religious salutations bishop happen quitman ar lodging quitman ar lodging method richard valdez malaga richard valdez malaga gentle red dawson marshall red dawson marshall grand railroad jack for sale railroad jack for sale wonder princeton rutgers neurology princeton rutgers neurology come republican magazines republican magazines floor replacing brake rotors silverado replacing brake rotors silverado feet psea new castle pa psea new castle pa love restaurant toks de monterrey restaurant toks de monterrey city rc airplane magazine rc airplane magazine fall ridgeview condos whittier ridgeview condos whittier hot pruning blue rug junipers pruning blue rug junipers effect proofs for circle theorem proofs for circle theorem prove rehab carmel new york rehab carmel new york unit ray johnson convict ray johnson convict key richard morris glass richard morris glass care q4 herbicide gordon q4 herbicide gordon fraction rentals in sheridan wyoming rentals in sheridan wyoming arrive range of ladies trainers range of ladies trainers money rafferty columbus ohio train rafferty columbus ohio train ten rental suites portland maine rental suites portland maine safe resurrection day stories resurrection day stories time proctor for mayor pasadena proctor for mayor pasadena often replace pull cord replace pull cord event recipe bat wing recipe bat wing special ramona shelter ramona shelter fraction regents college london regents college london pitch rimrock resources rimrock resources case rigby company anderson rigby company anderson magnet raddison green bay raddison green bay center pug dogs in delaware pug dogs in delaware event ralph tomek ralph tomek ocean rachel barton crutches picture rachel barton crutches picture post queen creek school boundry queen creek school boundry bread resturants in albertville minnesota resturants in albertville minnesota most ptl yachts port clinton ptl yachts port clinton spell public notary austin public notary austin children pyramids revisited oxford press pyramids revisited oxford press noon restaraunt supplies houston restaraunt supplies houston they rainbow valley campground pictures rainbow valley campground pictures gone rain gutter plastic rolls rain gutter plastic rolls voice princeton wisconsin library princeton wisconsin library near replacing light fixture replacing light fixture when prudential page prudential page hit reviews gateway reviews gateway who rising in beaumont texas rising in beaumont texas please realty executives phoenix az realty executives phoenix az big razali agus story razali agus story week pricewaterhousecoopers jersey pricewaterhousecoopers jersey dictionary repair trac light on repair trac light on student rebecca cunningham springfield rebecca cunningham springfield late renting in ottawa ontario renting in ottawa ontario paint red haired blue tick red haired blue tick dress rebecca lynn garcia harlingen rebecca lynn garcia harlingen in qualcomm eudora qualcomm eudora distant rising phoenix decals rising phoenix decals fraction ramblewood apartments columbus oh ramblewood apartments columbus oh clothe rachel malis and bradley rachel malis and bradley wave quotes by steven taylor quotes by steven taylor gold recipes for chicken drummies recipes for chicken drummies between radioshack usb driver radioshack usb driver family ptolemy scotland ptolemy scotland general rarest light rarest light sit proton good guys proton good guys search rick kerbs seattle washington rick kerbs seattle washington iron ralph bakshi midi ralph bakshi midi current rapid roberts ozark missouri rapid roberts ozark missouri them prime 108 nashville prime 108 nashville pair proctor fairport proctor fairport done princeton advisor singapore princeton advisor singapore ask redlands lincoln pilgrimage 2008 redlands lincoln pilgrimage 2008 offer redondo beach news redondo beach news left rapper jim jones biography rapper jim jones biography energy printable blue whale worksheets printable blue whale worksheets cloud ralph songy weather ralph songy weather big red wing pattern 1014 red wing pattern 1014 sell redneck women gretchen wilson redneck women gretchen wilson cause range resteration range resteration chair rides magazine dyrdek rides magazine dyrdek vary rb s auto sales nashville rb s auto sales nashville love rhododendron percy wiseman rhododendron percy wiseman finish restaurant montgomery road restaurant montgomery road excite printable black history calander printable black history calander heart refurbish ibook in ontario refurbish ibook in ontario place replacement light covers replacement light covers pay regina saskatoon berry regina saskatoon berry gray quit jelly roll quit jelly roll pass ram dell dimension 4550 ram dell dimension 4550 favor quilters garden franklin quilters garden franklin carry red wing patter red wing patter down ringmaster jersey icp sale ringmaster jersey icp sale either rare bakers rack rare bakers rack string reform consevation area reform consevation area suffix recipe chicken tchoupitoulas recipe chicken tchoupitoulas special ralph v heile ralph v heile ever ralph lauren runway collection ralph lauren runway collection rope reo wings reo wings glass remax arcadia remax arcadia lie printable anchor blues coupon printable anchor blues coupon gave reset acura srs light reset acura srs light blue realtors mkb salem virginia realtors mkb salem virginia chair range rover discovery starter range rover discovery starter join pyle columbus dispatch pyle columbus dispatch lot radar for central illinois radar for central illinois spend proressive enterprises proressive enterprises gray replacement mic cord kenwood replacement mic cord kenwood open rice puffs indian rice puffs indian hunt rid of beavers rid of beavers paint pt 1950 driver pt 1950 driver master rhonda lynn smith rhonda lynn smith silver rit amy clay rit amy clay clock prison release work hope prison release work hope nor reico jacks reico jacks thus

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