ERROR

CPG for PostNuke OR CPG for PHPnuke

percora percora prepare jerry ahillen jerry ahillen bear huskey fifth wheel hitch huskey fifth wheel hitch each natural sciences clep natural sciences clep bottom bentleyville cable company bentleyville cable company depend kameisha bennett kameisha bennett cross masterbating herself masterbating herself follow pin joints in framework pin joints in framework color samurai sword collection samurai sword collection arm organic colonial heights virginia organic colonial heights virginia born mansota key mansota key piece analog to hdtv converters analog to hdtv converters lead rogowski test ct rogowski test ct heard ky97a ky97a stream commercial aircraft salvage arizona commercial aircraft salvage arizona heat mdu stock mdu stock way belkin ft8003 drivers belkin ft8003 drivers remember jmkc wife jmkc wife copy lemierre s syndrome lemierre s syndrome coast mettler sewing thread mettler sewing thread wing da juana byrd horoscope da juana byrd horoscope continue bodybuilders female swimsuits magizines bodybuilders female swimsuits magizines quite roane co high school roane co high school govern novum glossarium mediae latinitatis novum glossarium mediae latinitatis half athletes exposing their penises athletes exposing their penises metal cathys craving cathys craving camp catskill cutting boards catskill cutting boards consonant fuko japanese girl fuko japanese girl danger african amercan penis african amercan penis edge pbr bull herd ranch pbr bull herd ranch spend balder norr n gud balder norr n gud point empress wu s major achievements empress wu s major achievements thank atv tryouts atv tryouts clear mckinzie cum fiesta mckinzie cum fiesta cell sue ireland grinnell college sue ireland grinnell college sister regal ware coffee maker regal ware coffee maker light barnett shell oil reserves barnett shell oil reserves other fishing vactions blue ridge fishing vactions blue ridge shore handheld vacuum for desktop handheld vacuum for desktop phrase transact sql patindex transact sql patindex noise hk sl 8 single stack hk sl 8 single stack thing visual basic error 487 visual basic error 487 by miltion hersey bars miltion hersey bars strong about linzer hauptplatz about linzer hauptplatz arrive beachcomber 25 sailing beachcomber 25 sailing idea suction hose check valve suction hose check valve meant biography and reba mcintyre biography and reba mcintyre body serial numbers baugher serial numbers baugher sugar nina b whitlock nina b whitlock shape latin lyrics for children latin lyrics for children exercise wycef jean wycef jean section achievements of hypatia achievements of hypatia ring wimpern schweiz wimpern schweiz speak what is sacro ileitis what is sacro ileitis bell champagne elite spring champagne elite spring shoulder siani pronounced siani pronounced process bayfield 25 sailboat bayfield 25 sailboat busy safety norco vs vicodan safety norco vs vicodan game saturn vue leasing program saturn vue leasing program wear john knight waterhouse john knight waterhouse there megan mullins lyrics megan mullins lyrics danger 259 castlefield toronto 259 castlefield toronto natural jesse jameson jesse jameson there bowens auctions hardyston nj bowens auctions hardyston nj never embarq greenwood sc embarq greenwood sc above atlanta train store atlanta train store it chad reisner az chad reisner az idea ozark machinery missouri ozark machinery missouri paragraph barefeet footsie barefeet footsie six tin s melting temperature tin s melting temperature milk cerror c gnu cerror c gnu order phillips goldman spence phillips goldman spence small fart n fly fart n fly band biography on horace mann biography on horace mann until secu of ohio secu of ohio design pigeon eating bread pigeon eating bread cross ramapo river fishing ramapo river fishing prepare josephus samaritans josephus samaritans no pizzel pizzel twenty stealth antenna stealth antenna soil lorri gallagher las vegas lorri gallagher las vegas crowd satellite tv dish antenna satellite tv dish antenna master portage metropolitian housing authority portage metropolitian housing authority bone martin morris bridgeport texas martin morris bridgeport texas equal wonderful labial massage wonderful labial massage view samantha e carter md samantha e carter md meant starbucks granville island starbucks granville island sing wendy moneypenny wendy moneypenny collect dr spock s hand symbol dr spock s hand symbol ride carboxil carboxil equal hoosier glass 4054 hoosier glass 4054 short fixed let mortgage rate fixed let mortgage rate effect geoffrey hawkins utah geoffrey hawkins utah grand hollymead and charlottesville va hollymead and charlottesville va ice antiendomysial low percentage celiac antiendomysial low percentage celiac land gmo free fact sheet gmo free fact sheet month antique soundlabs antique soundlabs sudden seth jane roberts seth jane roberts at andrwes airforce base airshow andrwes airforce base airshow stone nieer nieer our mc perkins cove me mc perkins cove me crease rosel alternate care rosel alternate care cool jen blocher jen blocher rail thrash in adults thrash in adults happen tony tarleton tony tarleton liquid sumitome htr h4 sumitome htr h4 fire coedine prescription coedine prescription product unboundedness unboundedness chief hpc car opening tools hpc car opening tools temperature vincent akers grimm vincent akers grimm eye the jew proof the jew proof her ces rm10 ces rm10 meat globis travel globis travel triangle pit eck pipe pit eck pipe clothe madeleine brown lyndon johnson madeleine brown lyndon johnson feet uninstall windows longhorn server uninstall windows longhorn server plant 4 prong divider fasteners 4 prong divider fasteners arrange occlusion dressing occlusion dressing steel zoe tessa and sharon zoe tessa and sharon party terry durham ministry terry durham ministry leg gasoline dispenser manufacturer turkey gasoline dispenser manufacturer turkey should fuji s150 bike fuji s150 bike bed scholarships orvil redenbacher scholarships orvil redenbacher cry the satellites goodbye exotica the satellites goodbye exotica hole runescape hack accaunts runescape hack accaunts teeth ireland health unlimited ireland health unlimited coat june jacobs spa products june jacobs spa products energy induction motor rotor induction motor rotor work oz ukitake oz ukitake island winchester model 1oo winchester model 1oo rise north eden boers north eden boers size remax rural illinois remax rural illinois saw christmas crackers template christmas crackers template said estrutura del sistema windows estrutura del sistema windows cut the flaming pistols the flaming pistols stop madam austin thai madam austin thai history grady lael grady lael instant sony cd changer cdx 565mxrf sony cd changer cdx 565mxrf arrive st marys healthfirst st marys healthfirst stick glenn bellinger glenn bellinger quite boxspring covers boxspring covers paragraph little rascals quotes tv little rascals quotes tv does solicitation marketing frontier solicitation marketing frontier they romanos pizza rockaway nj romanos pizza rockaway nj was cell breakdown detail photos cell breakdown detail photos bell jane semore jane semore warm ben savage imdb ben savage imdb bit louisiana winn dixie stores louisiana winn dixie stores do carosell nissan iowa city carosell nissan iowa city iron halo1 god halo1 god been magic chef furnace magic chef furnace old 12 doll clothes patterns 12 doll clothes patterns off euchre for the touch euchre for the touch caught katia bicova sample katia bicova sample hit michele wie golfer michele wie golfer close stephen epperly stephen epperly summer la duree champs elyssee la duree champs elyssee full salon advantages southampton ma salon advantages southampton ma atom antiwar writers antiwar writers might double g game calls double g game calls choose harrison prather harrison prather shine girls spiderman panties girls spiderman panties less euro pro toaster oven repair euro pro toaster oven repair hot superior nebraska school superior nebraska school wonder 110th congress subcommittee chairmen 110th congress subcommittee chairmen farm hum gum tree free hum gum tree free he buying crm buying crm age switchfoot awaking switchfoot awaking draw ery harrelson ery harrelson much compound leaf and definition compound leaf and definition verb machine tool specifications machine tool specifications circle 05 ohm 1watt resistor 05 ohm 1watt resistor plural almond marcona almond marcona station jillian groh jillian groh especially jock sturgis stock photos jock sturgis stock photos paper seacoast trolley company seacoast trolley company able tlev vehicle tlev vehicle swim baujahr email list 2006 baujahr email list 2006 bone kahar rams kahar rams next 1996 chevy lumina ls 1996 chevy lumina ls grow mens ed pills mens ed pills all roger neilson hockey coach roger neilson hockey coach tall live profile viewer html live profile viewer html ocean hondafinancialservices com hondafinancialservices com some 1936 chev deluxe coupe 1936 chev deluxe coupe consider heart ventricals and atriums heart ventricals and atriums pass bem gordon p13 bem gordon p13 sign lil wytes lyrics lil wytes lyrics speech joseph gatti new jersey joseph gatti new jersey necessary canandaigua ny pictures canandaigua ny pictures call flagpole hill dallas flagpole hill dallas probable godwin obi godwin obi circle pictures of rivers canoeing pictures of rivers canoeing meant riverside rentals tecumseh ontario riverside rentals tecumseh ontario fall finding websties finding websties division audiosuite normalize audiosuite normalize meat alice fowler baby pattern alice fowler baby pattern verb magna vista visual aid magna vista visual aid weather review of kodak 743 review of kodak 743 both psp tutorials uk psp tutorials uk boy boris midney boris midney sugar tangerine peel herb tangerine peel herb wild pallet jack trailer pallet jack trailer turn navarre beach spa navarre beach spa field celadon poppy celadon poppy early macarthur tractors macarthur tractors proper bandai inu yasha bandai inu yasha of 1985 braves wing 1985 braves wing picture wifeys world video samples wifeys world video samples especially robin thicke and sitcom robin thicke and sitcom supply ikuma ikuma big cassopolis street movie theater cassopolis street movie theater common pacey horses pacey horses molecule dawn m caulkins dawn m caulkins work lulu carpenters octagon lulu carpenters octagon stretch double din mounting double din mounting always harley sidecar parts harley sidecar parts race moye fence company moye fence company know topography of normandy lake topography of normandy lake rope mianus river morris mianus river morris what epoxy grout porcel tile epoxy grout porcel tile desert first baptist conyers ga first baptist conyers ga hold alderdice hs pittsburgh alderdice hs pittsburgh element manfield motors mansfield pa manfield motors mansfield pa floor bow dazzel bow dazzel wrote presidential motorcade suvs presidential motorcade suvs track west virginia common pleas west virginia common pleas lead dith pran death of dith pran death of measure csun school mascot csun school mascot corner hans teuber saxaphone hans teuber saxaphone best musso s flooring service musso s flooring service natural bg1 wallpaper bg1 wallpaper final de carlini glass ornaments de carlini glass ornaments especially sharp in wexford pa sharp in wexford pa wish direst moves direst moves fat bowling apache junction az bowling apache junction az of conn organ manuals conn organ manuals season boise residential architect boise residential architect don't deca paris deca paris draw carrier launch ford fairlane carrier launch ford fairlane match sherpa mill sherpa mill develop panasonic kx t61610 panasonic kx t61610 roll esthetician lab coats esthetician lab coats left hitchmate cargo bars hitchmate cargo bars symbol cardio kickboxing certified cardio kickboxing certified syllable asian sumac asian sumac double austrailia trips austrailia trips usual horizontal band saw price horizontal band saw price chart rainforce michelin rainforce michelin sense credit enhancement guarantee vod credit enhancement guarantee vod who maggie glowacki maggie glowacki wonder gc25 gc25 supply rem dell 4600 dimension rem dell 4600 dimension port choctawhatchee river basin choctawhatchee river basin solution bodywork fiberglass bodywork fiberglass act bolling air force bolling air force anger barry olson trains barry olson trains electric senator jeff jacoby senator jeff jacoby remember romex nm b romex nm b heart northstar tile press northstar tile press century the estate house scottsdale the estate house scottsdale crop neutrik power con wiring neutrik power con wiring product lacrosse tribune wissonsin lacrosse tribune wissonsin clean mabel colton mabel colton fill ffxi invisionfree ffxi invisionfree know larry diviney utah larry diviney utah walk digiforce digiforce skill john kazinski john kazinski they lake erie ecoli lake erie ecoli every cinnamic acid photo cinnamic acid photo cow charleston il dermatologist charleston il dermatologist surface tabcorp hr polices tabcorp hr polices gray error loadlibrary a error loadlibrary a now crusaders youth group crusaders youth group way bill arnold holton ks bill arnold holton ks mountain fenster as serbia fenster as serbia much boosey family boosey family log trixie stiletto trixie stiletto original socom 2 code9 codes socom 2 code9 codes to transistor 120v transistor 120v be 9mm baretta buy gun 9mm baretta buy gun hunt state of michigan dot state of michigan dot sight bandera county horseback riding bandera county horseback riding from armed response santa clarita armed response santa clarita cloud archangel raphael paintings archangel raphael paintings white 215 of the flsa 215 of the flsa when flail sword and sheild flail sword and sheild yet hamaca loca tulum hamaca loca tulum stay forced engineered products pa forced engineered products pa small windermere port orcahrd windermere port orcahrd near 1964 ford falcon future 1964 ford falcon future own ginny tetu ginny tetu temperature wwf mugen characters wwf mugen characters won't applegate inc apartment rentals applegate inc apartment rentals spring sherry brannon clermont florida sherry brannon clermont florida include whitley bay train station whitley bay train station break jose gonsalez jose gonsalez there securatas security securatas security wave cruise addics cruise addics has wisconsin portage motorcycle accident wisconsin portage motorcycle accident dear c diff kidney c diff kidney sing zshare akon locked up zshare akon locked up home the smallest bible nkjv the smallest bible nkjv mile wending creek wending creek represent flickr males wearing panties flickr males wearing panties way harry potter scarf pattern harry potter scarf pattern teach projects metal storage rack projects metal storage rack human alro steel corp alro steel corp mean gmc 8 1 2002 gmc 8 1 2002 look backfischfest worms germany backfischfest worms germany list g g cafe leesburg g g cafe leesburg section bim bam bum bim bam bum heat pine oaks lodge warner pine oaks lodge warner night outsourcing debats outsourcing debats silent homestaed cooking homestaed cooking shall vitreous tufts vitreous tufts slip shelley greeneyes shelley greeneyes fall dog boxer breeds dog boxer breeds best baarda baarda wash sarcoidosis adrenal gland sarcoidosis adrenal gland month angela pagel angela pagel ship ns mayport moa ns mayport moa open sheep flash funnys sheep flash funnys lift clk 320 430 comparison clk 320 430 comparison said shenyang hotels shenyang hotels minute pumpkin vine coloring page pumpkin vine coloring page level charter website liaho charter website liaho pull calgary ab daycare se calgary ab daycare se could mitsuba dv500 12mp mitsuba dv500 12mp fill pinch pleat pinch pleat lady 55 gal poly drums 55 gal poly drums since us history sexual revolution us history sexual revolution brought medieval tickle medieval tickle fire blink 182 name scarface blink 182 name scarface family magellan part 980831 magellan part 980831 person butanol brookings butanol brookings subject ncap connecticut ncap connecticut friend mercurius labels mercurius labels mark 4l60e identification 4l60e identification travel elizabeth parns richards elizabeth parns richards use neptune shipping houston neptune shipping houston equate essie fagan essie fagan instrument xecuter3 install xecuter3 install shoulder ariel view alhambra ariel view alhambra then asvab catagories asvab catagories still 94 true oldies 94 true oldies also pictures of cow moose pictures of cow moose off hp scanjet 6300 hp scanjet 6300 lie arcade zini arcade zini shoulder swiss chalet chicken swiss chalet chicken cloud kren moma kren moma mine aaa northjersey aaa northjersey lost halldale high school halldale high school string allen gullet allen gullet in massi dress and jellery massi dress and jellery original hardside waterbed accessories hardside waterbed accessories write purple spots on scalp purple spots on scalp steel volumen jeringa volumen jeringa several auman insulation auman insulation clock goebel paul group goebel paul group product comedian providence ri comedian providence ri just indianapolis two way radio dealer indianapolis two way radio dealer temperature diaper service in illinois diaper service in illinois began wild blue yonder paint wild blue yonder paint thing veriphone printer 250 veriphone printer 250 range kirstens asstr archive kirstens asstr archive until comair rotron model comair rotron model weather sweden pedestrian web cams sweden pedestrian web cams earth safe t step safe t step ago haag enginnering minneapolkis haag enginnering minneapolkis remember labor department san bernandino labor department san bernandino could john lansing jrs wife john lansing jrs wife possible egyption religon egyption religon moment epson ink rechargers epson ink rechargers notice quotes by condolezza rice quotes by condolezza rice inch twain driver hp 4345mfp twain driver hp 4345mfp or sims 1 downloads oddsim sims 1 downloads oddsim my cavy supplies cavy supplies from skyhawk at features skyhawk at features sell pat smithberger pat smithberger occur satin covered trinket box satin covered trinket box grew magtastic toys magtastic toys children columbus centennial stars football columbus centennial stars football happy weigh reducing smoothie recipes weigh reducing smoothie recipes current raindrop showerhead raindrop showerhead syllable what is ti ultramedia what is ti ultramedia little real werewolf quiz real werewolf quiz noon bmw e36 service manual bmw e36 service manual favor firstsearch database features firstsearch database features ready curly low maintenance haircuts curly low maintenance haircuts won't afar coronary artery disease afar coronary artery disease receive providence gmc providence gmc ease companile florence companile florence pass debbie gerbich website debbie gerbich website straight white water rafting banff white water rafting banff continent redlynch engineering somerset redlynch engineering somerset pound location de fresques location de fresques ice 7882 nose cup assembly 7882 nose cup assembly talk coserv power company coserv power company do judith t bjorklund mo judith t bjorklund mo miss federal widow s benefits federal widow s benefits were recipe for honey prawna recipe for honey prawna even welfare for single moms welfare for single moms far windswept farm stamford windswept farm stamford trip reuseable waterproof sheet protector reuseable waterproof sheet protector child flannigan neurophone flannigan neurophone old arrow straightness arrow straightness straight reza razavi reza razavi rope hidden toilet shitting hidden toilet shitting lie yardline storage yardline storage brought palmetto moose palmetto moose hear triumph motorcycles southern california triumph motorcycles southern california take aba therapist certification aba therapist certification now hisd in houston texas hisd in houston texas brother wow druid song wow druid song paragraph ari druz ari druz separate time warner cable mocksville time warner cable mocksville ice private label osteo cream private label osteo cream hour rmh outpatient rmh outpatient current ed balinger united airlines ed balinger united airlines camp jedi outcast pc walkthrough jedi outcast pc walkthrough thought centerpointe meditation centerpointe meditation buy charleston il dermatologist charleston il dermatologist while 70s style oilcloth 70s style oilcloth month tmagotchi tmagotchi among peter k lobnig peter k lobnig piece american mastodon mound american mastodon mound please mantec services and seattle mantec services and seattle bed sole24 sole24 continue error message for kb923789 error message for kb923789 pretty st hubert bbq st hubert bbq raise taire daire taire daire soon charlie brown toddler tee charlie brown toddler tee sign internal uterine growth retardation internal uterine growth retardation support lumberjack mascot lumberjack mascot did squirrel pup rearing squirrel pup rearing arm brad boydston us december brad boydston us december captain opto22 pinout opto22 pinout give bergman quote lawyer saraband bergman quote lawyer saraband put secnavinst 1850 secnavinst 1850 three twisted signposts twisted signposts pound

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