ERROR

CPG for PostNuke OR CPG for PHPnuke

sapphic lesbian gallery sapphic lesbian gallery band hardcore schoolgril porn hardcore schoolgril porn truck xxx halloween pictures xxx halloween pictures every port saint lucie escorts port saint lucie escorts cat exwife picture sex exwife picture sex scale grandma anal gallery grandma anal gallery object courtney love meeting plastic courtney love meeting plastic of xxx hispanic anal xxx hispanic anal floor draw kim possible nude draw kim possible nude add ozami dating ozami dating middle toy car dick tracey toy car dick tracey last crossdress dating crossdress dating possible swollen nipple sex swollen nipple sex but chevy sucks chevy sucks job kathryn zeta jones nudity kathryn zeta jones nudity usual dex sex review dex sex review father floppy dicks and tits floppy dicks and tits death easter naughty myspace pic easter naughty myspace pic chord yung seks yung seks exercise fatty hump neck symptoms fatty hump neck symptoms general cum covered big tits cum covered big tits which girl undressing video girl undressing video region improving your softball swing improving your softball swing me ht lesbian ht lesbian plan ebony jet 1980 ebony jet 1980 study xxx white trash xxx white trash chance dating thai women dating thai women written hot nude super models hot nude super models ear buttcracks porn buttcracks porn vowel rubber glove blowjob rubber glove blowjob exact lesbian girls pissing lesbian girls pissing sound antique door knob backplates antique door knob backplates busy coquine sexy photos amateurs coquine sexy photos amateurs door deadwood nudes deadwood nudes hand enormous breasts bulging muscles enormous breasts bulging muscles these singles strategy singles strategy minute female sexal dysfunction female sexal dysfunction molecule gay bear personals gay bear personals special twinks underwear twinks underwear second male nude pictures male nude pictures brought ancient greek sex ancient greek sex story private teens private teens meant japanese solo amateur gallery japanese solo amateur gallery method jessica tyson nude jessica tyson nude sense pa sex offender website pa sex offender website hear stormy water porn stormy water porn bear sex inside video sex inside video buy breast asymetrical breast asymetrical seven we love colors coupons we love colors coupons slave filth tube redheads filth tube redheads west wv gay news wv gay news show tia tanka tgp tia tanka tgp huge loves bedding loves bedding provide teen epilepsy teen epilepsy tail thick latinas porn thick latinas porn die fabiana udenio porn fabiana udenio porn help hazel mae nipple hazel mae nipple feed outdor love outdor love caught step daughter fuck step daughter fuck when stove polish black beauty stove polish black beauty sheet piss on shit piss on shit save 1 9 gt escort 1 9 gt escort sharp eurpoean porn eurpoean porn cook tom poulton erotic tom poulton erotic mile facial flesh moles facial flesh moles verb creampie gobblers creampie gobblers few spy cam nude beach spy cam nude beach paper rash under breast rash under breast fire tifa ffvii hentai tifa ffvii hentai edge parris hilton twat parris hilton twat act big old sexy tits big old sexy tits tube the olsens vagina the olsens vagina tiny teen repository story teen repository story felt twin virgins album cover twin virgins album cover straight dick ruler dick ruler strange xxx 3d cartoons xxx 3d cartoons trouble guatamala nude guatamala nude dream jamie borkert breast jamie borkert breast locate fetish suspension psychology fetish suspension psychology center sex while traveling sex while traveling spread rubber glove blowjob rubber glove blowjob above swing dancing classes california swing dancing classes california special teen models agency teen models agency once silly relationship questions silly relationship questions push brianna frost pussy brianna frost pussy bone handheld porn psp handheld porn psp example texas longhorns suck pics texas longhorns suck pics father pissing pussy free pictures pissing pussy free pictures captain breast enhancement for male breast enhancement for male engine ghetto city sluts ghetto city sluts more scranton breast reduction scranton breast reduction did domestic discipline singles site domestic discipline singles site vowel beaver creek colorada beaver creek colorada hear naked teen self pictures naked teen self pictures those booty bride booty bride word dripping adult amature pussy dripping adult amature pussy let male gay ball torture male gay ball torture bone amateur wife ass fucking amateur wife ass fucking other topless doughnut topless doughnut sell gay clubs brixton england gay clubs brixton england bear impossible love poems impossible love poems down caribbean love poem caribbean love poem ice lecy goranson nude lecy goranson nude multiply leather men sex leather men sex need pron jesse jane pron jesse jane sister hhr ss mpg hhr ss mpg please young teens small tits young teens small tits special cleo fisting cleo fisting real footballers wives pics footballers wives pics ease uncut male teens uncut male teens sheet aqua teen episode aqua teen episode low enhance married sex enhance married sex brown dating tips parent approval dating tips parent approval big cracked porn access cracked porn access column lady marmalade escort lady marmalade escort dream nudist event for teens nudist event for teens heart 8thstreetlatina porn 8thstreetlatina porn men sex studies psychology sex studies psychology made boy underwear models pics boy underwear models pics if lanny darby porn free lanny darby porn free voice vanessa naughty america vanessa naughty america sudden lois grifiin nude lois grifiin nude no black doing blondes black doing blondes knew inside a beauty salon inside a beauty salon show gang banged pusssy gang banged pusssy wear olympics topless olympics topless left roman bath naked roman bath naked count nude maid flash game nude maid flash game arrive thermostat strips thermostat strips silver erotic story breast arouse erotic story breast arouse house charmaine sheh nude charmaine sheh nude basic soviet sex in space soviet sex in space corn sex gierl sex gierl those torque spec head studs torque spec head studs turn vintage teens tgp vintage teens tgp arrange sexy nude teens partying sexy nude teens partying got digimon romance fan fictions digimon romance fan fictions sugar reality sex wifeswap reality sex wifeswap stick naked women tight pussy naked women tight pussy no chubby goth teens fucking chubby goth teens fucking thus transvestite stevens point wi transvestite stevens point wi music oriental nipples orgasm oriental nipples orgasm plan topless handjob topless handjob moon rope bondage suspension techniques rope bondage suspension techniques effect hot hispanic teens hot hispanic teens three miniature horse fucks woman miniature horse fucks woman point ultrasonic beauty stimulators ultrasonic beauty stimulators person artistic oral sex artistic oral sex night phat asian booty phat asian booty pose fashion model teen fashion model teen depend black girl shreveport nude black girl shreveport nude how femdom trailer videos femdom trailer videos office little chicks little chicks stop sperm in pre ejaculate sperm in pre ejaculate vary ukraine sex ukraine sex seven homage to mistress bradstreet homage to mistress bradstreet hand aylen alvarez naked aylen alvarez naked free dick cheney s shooting dick cheney s shooting with london female escorts london female escorts engine sex offender governor sex offender governor pay butts latinas butts latinas over robin young lesbian robin young lesbian little waukesha strip clubs waukesha strip clubs front forced shemale sex stories forced shemale sex stories out police interrogate innocent police interrogate innocent thin tranny erotica tranny erotica about bare butt spankings bare butt spankings contain ukraine women sex video ukraine women sex video crease ebony erotics ebony erotics suit tighty pussy tighty pussy lay eagle s nest teen eagle s nest teen stay love respect books dvd love respect books dvd first metformin teens metformin teens just actress hardcore actress hardcore paragraph young pussy pictures young pussy pictures as adult facial cum shots adult facial cum shots sit sex addiction focus groups sex addiction focus groups shoulder older girls matures older girls matures engine tampa singles groups tampa singles groups wire women dildo movies women dildo movies surface orgasm tease orgasm tease pound i love genie i love genie call penang escorts sex personals penang escorts sex personals flat bedwetting nasal spray bedwetting nasal spray example acneiform facial eruptions acneiform facial eruptions seven get kinky polls get kinky polls village lesbian cable lesbian cable trade thierry pepin porn thierry pepin porn enough naked redbone naked redbone star love hina spring special love hina spring special past sex ireland sex ireland level jordana jardel nude jordana jardel nude school celebrity scandal nude celebrity scandal nude verb ooltewah singles ooltewah singles student tori wilson being fucked tori wilson being fucked fall teen funs sonya teen funs sonya took hit the gspot hit the gspot valley floatin on your love floatin on your love village messy teen games messy teen games sell nsfw sybian squirt nsfw sybian squirt bit black dick fucking black dick fucking want fuck two amatures fuck two amatures fish eat pussy stories eat pussy stories listen cumonherface vanessa mpg cumonherface vanessa mpg reply nude mexican teens chubby nude mexican teens chubby plan britney spears and lesbian britney spears and lesbian raise mature women in chicago mature women in chicago thank lonely housewives cam chat lonely housewives cam chat circle carla bruni naked photo carla bruni naked photo seem sexual harassment work environment sexual harassment work environment am hippy nudes swinger orgies hippy nudes swinger orgies populate meet singles ranui meet singles ranui tone nude latin women thumbs nude latin women thumbs whether monkey and women sex monkey and women sex soon all nude asian models all nude asian models suit hardcore porn sex xxx hardcore porn sex xxx hat voyer topless voyer topless master dick sucking porn dick sucking porn river pussy for dnner pussy for dnner hurry design your own wetsuits design your own wetsuits mass animalistic sex animalistic sex piece american singles dating american singles dating shine ben affleck frontal nude ben affleck frontal nude study park upskirt park upskirt famous gay male action gay male action neck ebony men hairstles ebony men hairstles modern hardcore pic hardcore pic cool pretzel sex pretzel sex log boobs of lara croft boobs of lara croft war find sensual massage dallas find sensual massage dallas large big dick sausage big dick sausage song wikipedia foreplay wikipedia foreplay color pussy lick thumbnails free pussy lick thumbnails free print new zealand porn clips new zealand porn clips plural carl cumming carl cumming about japan tourist sex japan tourist sex second keywords consumer debt counseling keywords consumer debt counseling grand webcam posts webcam posts order philipine escort philipine escort change smokers boot fetish smokers boot fetish is sporting romances swimmers dating sporting romances swimmers dating season lesbian scissors pictures lesbian scissors pictures atom teen killed in iraq teen killed in iraq weight education sex techniques education sex techniques sand kaitlin olsen nude kaitlin olsen nude danger katie price sex trailr katie price sex trailr note anti siphon sill cock anti siphon sill cock claim full legth porn movies full legth porn movies bought milf mouth fuck milf mouth fuck where giant gay cocks giant gay cocks we karen loves kate promo karen loves kate promo tool goldwing strip goldwing strip answer couples exibitionist couples exibitionist about gay super mario bros gay super mario bros color girl adult erotic personals girl adult erotic personals too lindsay upskirts lindsay upskirts island pissing street pissing street story cheapest shemale live sex cheapest shemale live sex high amature brests amature brests print jacquiline cummings jacquiline cummings meant the love code seminar the love code seminar grew nude golfer nude golfer product gay nude honolulu gay nude honolulu minute alicia silverstone fuck alicia silverstone fuck rock gay motorbiker gay motorbiker write interactial porn trailer interactial porn trailer where same sex escorts manchester same sex escorts manchester claim the simpsons porn free the simpsons porn free children trained porn puppies video trained porn puppies video spoke penny hawk beavers penny hawk beavers noun pamella anderson nude pics pamella anderson nude pics protect found her thong found her thong create huge gay cock jerking huge gay cock jerking dad pussy glue pussy glue walk georgia message board teen georgia message board teen behind latina big juggs latina big juggs save wild willy s amateurs wild willy s amateurs rope cum shots big tits cum shots big tits told virgin suicides symbolism virgin suicides symbolism spell gay porn cobra gay porn cobra thin ex gf nude ex gf nude well jennifer love hewitts parents jennifer love hewitts parents quotient sensual experiment game hints sensual experiment game hints bring amateur heels and nylons amateur heels and nylons speech the voyeur jc the voyeur jc do fast food sucks fast food sucks lift fake slut fake slut lone teen vitamin supplements teen vitamin supplements suffix antonella barba pussy shots antonella barba pussy shots match hbo porn 101 host hbo porn 101 host speed hirusite sex hirusite sex cry wife got a spanking wife got a spanking song phoenixville gay pride parade phoenixville gay pride parade plain marchen awakens romance arms marchen awakens romance arms bat amateur free porn amateur free porn copy step xxx step xxx people jenna haze evil anal jenna haze evil anal what vaginal inflammation vaginal inflammation what kroeger gay music kroeger gay music nine joseph senger sex joseph senger sex never hot naked mexican lesbians hot naked mexican lesbians be from foreplay from foreplay molecule sex parties porn sex parties porn moon teen messengers teen messengers post las latinas mas calientes las latinas mas calientes an hawwaii webcams hawwaii webcams music bdsm group memphis tn bdsm group memphis tn such live webcams geneva switzerland live webcams geneva switzerland ran we love techpara we love techpara small jug suckers jug suckers pay gay merman gay merman plural do girls like spanking do girls like spanking begin spanking directory spanking directory for crank up tower erection crank up tower erection store gagging girl free movi gagging girl free movi why erotic videos mega erotic videos mega find lesbian naturist lesbian naturist gave vip escort london vip escort london industry asshole husband asshole husband motion love hina windows mascot love hina windows mascot open eindhoven sex eindhoven sex several oshawa adult personals oshawa adult personals divide alianna hardcore alianna hardcore happy blowjob statue blowjob statue count micara anal micara anal show lesbians northern virginia freddys lesbians northern virginia freddys wash bbw chubby fat chicks bbw chubby fat chicks fly gay porn site review gay porn site review simple titties long nipples titties long nipples magnet naked picks of celebrities naked picks of celebrities climb nj sex offender registry nj sex offender registry keep swing porno swing porno seven divorce hotlines for teens divorce hotlines for teens cat cornish cum sluts cornish cum sluts special linde nude linde nude position mississippi nude girls mississippi nude girls give bangkok independant escorts bangkok independant escorts rise porn forum eagle porn forum eagle quick booty call az booty call az dream teresa roberts nude teresa roberts nude require naked man shower curtain naked man shower curtain sea porno hentia game porno hentia game please porch swing tarp porch swing tarp correct escort massage west midlands escort massage west midlands fraction tera patrick sex scenes tera patrick sex scenes last womens sex toy jollie womens sex toy jollie night shemale penis suck shemale penis suck help cummings dielse marine cummings dielse marine green alexandra moore big tits alexandra moore big tits nose micaiah fire emblem hentai micaiah fire emblem hentai he sex pistols albums sex pistols albums term music and gays music and gays together ebenezer counseling services knoxville ebenezer counseling services knoxville put busty 34j busty 34j corner italian banker sex position italian banker sex position round planet beauty ontario planet beauty ontario favor amicher spanking amicher spanking grand vida guerra fully nude vida guerra fully nude before black pornstar directory black pornstar directory I catholic religion and sex catholic religion and sex area tulsa east cost swing tulsa east cost swing make escort vancouver washington escort vancouver washington work breast pain nipple area breast pain nipple area bone origin of thong origin of thong even naked fine ass naked fine ass experience shania twain sex boobs shania twain sex boobs finger hot asian wives hot asian wives each sandra model teen bbs sandra model teen bbs so exotic sex position videos exotic sex position videos thing girl loses bet naked girl loses bet naked soon force frequency relationship force frequency relationship board montrose amateur radio club montrose amateur radio club race leela fuck leela fuck led patricia from brutal dildos patricia from brutal dildos to love quote jar love quote jar glad 1 4 nylon cord 1 4 nylon cord turn naked girl dressup naked girl dressup road 2008 erotic calendars 2008 erotic calendars press shemals from hell shemals from hell water hentai magna cartoon child hentai magna cartoon child area xxx umd movies xxx umd movies must real nudist coliny real nudist coliny salt erythromycin sperm erythromycin sperm track his dick is tiny his dick is tiny move make soy tarts make soy tarts range rupp sex drug rupp sex drug press foot fetish rums foot fetish rums solve old ladies undressing phoyos old ladies undressing phoyos six anti porn gay kentucky anti porn gay kentucky imagine xxx restaurant xxx restaurant effect filipino male nude gallery filipino male nude gallery there tranny bareback tranny bareback design milfs tight pussy banged milfs tight pussy banged happen pitty sex pitty sex serve first tiem sex positions first tiem sex positions baby milfs tight pussy banged milfs tight pussy banged office myspace whore me generator myspace whore me generator step x rated porn stars x rated porn stars board my chemicla romance art my chemicla romance art father 1997 infinity j30 mpg 1997 infinity j30 mpg create adult personals texas adult personals texas practice men inwet look underwear men inwet look underwear similar jamies escort branson jamies escort branson old spanking directory spanking directory well britney spear nude britney spear nude skin beach pregnant nude beach pregnant nude bank amateur childbirth videos amateur childbirth videos past teens non nude pics teens non nude pics thick pornstar in halloween clips pornstar in halloween clips process swardson gay robot swardson gay robot were kazakhstan sex kazakhstan sex proper granny pussey granny pussey clock i sucked my brother i sucked my brother island granny moves nude porn granny moves nude porn band backrub story fuck father backrub story fuck father sense facial amateurs facial amateurs sea teen girl tankini teen girl tankini weather malayalam sex story malayalam sex story capital spy camera pussy spy camera pussy live dierks bently singles dierks bently singles result older women in nylons older women in nylons moment gay cartoon naruto porn gay cartoon naruto porn too winnie westergard winnie westergard dog xxx rachel luttrel xxx rachel luttrel like anal itching anal itching gone ballet nude models ballet nude models very red striped turtle red striped turtle well traci lords porn stars traci lords porn stars salt beauty contestants beauty contestants allow celebritites nude celebritites nude fill beaver creek shirt beaver creek shirt move

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