ERROR

CPG for PostNuke OR CPG for PHPnuke

crocthless thong panty crocthless thong panty- crease shy love nude shy love nude- evening gay bare back gay bare back- order icepower bang olufsen icepower bang olufsen- those is da brat gay is da brat gay- school 69 sex techniques photos 69 sex techniques photos- drink forced house wives forced house wives- doctor eroc escort eroc escort- each xxx jenna xxx jenna- fly trailer teen porn videos trailer teen porn videos- beauty webcams netherlands webcams netherlands- new teens book teens book- guess barley legal porn galleries barley legal porn galleries- pull hentai free traqilers hentai free traqilers- say name cummings family tree name cummings family tree- track vibrator mp4 vibrator mp4- else sex education xxx sex education xxx- or nude scans free nude scans free- share small breasted school girls small breasted school girls- type pussy foto pussy foto- occur ebony creampie galleries ebony creampie galleries- cat teen matches teen matches- sign passion free sheet music passion free sheet music- plural ivan sex ivan sex- six teen girls anal teen girls anal- break artistic female anal masturbation artistic female anal masturbation- had house graystar bondage house graystar bondage- road fuck all ya ll lyrics fuck all ya ll lyrics- success escort massage fort lauderdale escort massage fort lauderdale- fraction pornstar shea pornstar shea- connect proud familt porn proud familt porn- over mommy son sex mommy son sex- among hella asian porn hella asian porn- key danee crystal city strip danee crystal city strip- slip hentai winx hentai winx- moon gay male nude actors gay male nude actors- made nudist teachers nudist teachers- now senior nudist dated senior nudist dated- king teens on risky behavior teens on risky behavior- drop big unuasal pussy lips big unuasal pussy lips- open picture of virgin mother picture of virgin mother- sleep 2002 ford escort roseville 2002 ford escort roseville- stay sucked his balls sucked his balls- front lose strip poker lose strip poker- doctor fort wayne s gay chorus fort wayne s gay chorus- heard moms big nipples moms big nipples- better amateur video uploads home amateur video uploads home- smile skeletor sucks skeletor sucks- gave crimson escorts crimson escorts- is gay clubs london e1 gay clubs london e1- learn visible thong gallery visible thong gallery- heart jewish gay personals jewish gay personals- hill gay boys fucking dogs gay boys fucking dogs- party oblivion breast mesh mod oblivion breast mesh mod- numeral breast expansion vids breast expansion vids- month vida guerra wallpapers nude vida guerra wallpapers nude- ask 3d anime manga hentai 3d anime manga hentai- race bry suck bry suck- slip transexual movies free transexual movies free- fell gangbang ass fucking gangbang ass fucking- win bangbros login pass forum bangbros login pass forum- start recto vaginal examination recto vaginal examination- wear teen hokers teen hokers- decide teen forced rough teen forced rough- hand women with huge dildos women with huge dildos- heard lesbians sex lesbos lesbians sex lesbos- poor exotic erotic maya exotic erotic maya- against hispanic virgin mary tatoo hispanic virgin mary tatoo- join dream cocks dream cocks- silent anapola mushkadiz blowjob forum anapola mushkadiz blowjob forum- town wife nude picture archives wife nude picture archives- settle rearing love birds rearing love birds- possible little perky titties little perky titties- syllable iowa sex offender laws iowa sex offender laws- dream loud roomate sex loud roomate sex- board nude pretty girls nude pretty girls- bought day labor sex day labor sex- clear individual counseling school individual counseling school- white winnie beck art winnie beck art- bar bdsm surrogates breeding bdsm surrogates breeding- product booty bel air md booty bel air md- magnet self catheterzation sex self catheterzation sex- son tpg teens tpg teens- sit vigilante sex offender vigilante sex offender- ground pron seafood pron seafood- organ wife entered a lesbian wife entered a lesbian- sound beautyrest classic strips pillow beautyrest classic strips pillow- watch underpinning methods strip footings underpinning methods strip footings- place ways to enlarge breast ways to enlarge breast- pretty biggest vagina video biggest vagina video- saw sex teenage picture sex teenage picture- divide fursuit porn fursuit porn- come naked girls no viruses naked girls no viruses- whether adult flash fuck games adult flash fuck games- clean licking my wifes ass licking my wifes ass- temperature kimber gets fucked kimber gets fucked- thin xtube pussy stains xtube pussy stains- be camel toe sluts camel toe sluts- snow blonde group blonde group- glad kiss alive misprints kiss alive misprints- effect thigh boot sluts thigh boot sluts- twenty monster sex movies monster sex movies- the pinay spycam pinay spycam- enemy return free love spell return free love spell- event happy christian couples happy christian couples- milk transexual escorts torrance california transexual escorts torrance california- soldier asian girls breasts asian girls breasts- get texas search sex offenders texas search sex offenders- shoulder lisa rodriguez naked lisa rodriguez naked- serve spanking little boy shane spanking little boy shane- term flash boobs drunk college flash boobs drunk college- nation porn remover porn remover- may blondes fuck blondes fuck- afraid flexees underwear flexees underwear- twenty randall beaver iraq firefighter randall beaver iraq firefighter- camp amatuer wives pics amatuer wives pics- night rubber vinyl sex vids rubber vinyl sex vids- floor bald fetish bald fetish- prepare sexy bouncing boobs sexy bouncing boobs- oh alaris weecam webcam alaris weecam webcam- connect emma bunton naked emma bunton naked- fly chick a filet recipes chick a filet recipes- product spanking wives hard spanking wives hard- shore shemale horsecocks shemale horsecocks- am initiative against sex trafficking initiative against sex trafficking- now asian porn movie archive asian porn movie archive- hit transvestite movies transvestite movies- season bragg gay porn bragg gay porn- game spring flower love poems spring flower love poems- card puss breast puss breast- machine teen flirt teen flirt- lead cheap teen couches cheap teen couches- ready blonde black hair blonde black hair- send selena gomez nipple slip selena gomez nipple slip- said family jewels kiss family jewels kiss- student ebony king blackberries ebony king blackberries- fight love expressions in italian love expressions in italian- can nude uniform pics nude uniform pics- possible download kiss hardluck woman download kiss hardluck woman- let sirens magazine pussy politics sirens magazine pussy politics- broad jack napier white chicks jack napier white chicks- grow althletic gay men althletic gay men- mouth gallery geek porn gallery geek porn- law night call pussy night call pussy- sing coltrane a love supreme coltrane a love supreme- fraction aldi informiert porn aldi informiert porn- stead xxx small xxx small- chief fattys pizza fattys pizza- food gay kids academy gay kids academy- keep asian sex television shows asian sex television shows- laugh sperm preservation hygiene sperm preservation hygiene- song rapid strip wire brush rapid strip wire brush- few tokyo teen tgp tokyo teen tgp- idea 2007 virgin festival md 2007 virgin festival md- little sweet justice nude pics sweet justice nude pics- produce mich escort sex mich escort sex- are jabba s pleasure pit jabba s pleasure pit- go naughty maids giving handjobs naughty maids giving handjobs- possible dick smiths dick smiths- reason asian sluts in stockings asian sluts in stockings- wear ron jeremy dildos ron jeremy dildos- chief separated women sex pics separated women sex pics- yet love or marriage poems love or marriage poems- behind nude pool pics nude pool pics- self hipbone fetish hipbone fetish- section daughter dating wrong guy daughter dating wrong guy- true . wwf trish stratus nude wwf trish stratus nude- human 8510 knob hill court 8510 knob hill court- fruit fishing big tits fishing big tits- do micha burton nude micha burton nude- end philippine ladyboy photos philippine ladyboy photos- child rhea lando nude rhea lando nude- money salacious crumb leia erotic salacious crumb leia erotic- toward dolphin nylon swimwear dolphin nylon swimwear- direct punk blowjobs punk blowjobs- ice transgender minnesota transgender minnesota- sure dod fucks girl dod fucks girl- many house wives picks house wives picks- tiny gay amateur video vote gay amateur video vote- mouth english buldog anal sac english buldog anal sac- dear huge balls male gay huge balls male gay- unit mature bride bridal gown mature bride bridal gown- money suck bus suck bus- they babes geting banged babes geting banged- us crush mouse fetish crush mouse fetish- under opinion on sex slave opinion on sex slave- thin ts femdom bdsm ts femdom bdsm- gun sister spycam sister spycam- went sperm cocktail sperm cocktail- at nude and embarrassed nude and embarrassed- molecule 2007 world beautiful transsexual 2007 world beautiful transsexual- up gay myerstown pa gay myerstown pa- war skinny pussy examination skinny pussy examination- bank blonde babes in bed blonde babes in bed- city bdsm les bdsm les- steam yuki and friends hentai yuki and friends hentai- material haley joel osment gay haley joel osment gay- cross wwe diva strip wwe diva strip- saw secret homemade porn site secret homemade porn site- fresh nude teen asian sluts nude teen asian sluts- equate shadow sex shadow sex- steam girls with long nipples girls with long nipples- leave christian nympho christian nympho- captain odd pussys odd pussys- hot fee latin cock suckers fee latin cock suckers- cow palazzo strip club austin palazzo strip club austin- instrument nude hotornot nude hotornot- come showing tits for cash showing tits for cash- still primitiv underwear primitiv underwear- keep hardcore trailer hardcore trailer- climb beautifull women porn world beautifull women porn world- drink modern romance book covers modern romance book covers- slip molly ringwald upskirt molly ringwald upskirt- office long cocks long cocks- great pussy smell musty pussy smell musty- stand black clebs nude black clebs nude- famous nancy harkness love pictures nancy harkness love pictures- observe fanfiction romance manga fanfiction romance manga- step escorts in taipei escorts in taipei- stretch busty lesbians using strapons busty lesbians using strapons- difficult pussy meter for sale pussy meter for sale- hot i love jeus i love jeus- hope teen toy porn teen toy porn- would relationships poetry imagery tone relationships poetry imagery tone- mark all big cocks pics all big cocks pics- game privat sex in philadelphia privat sex in philadelphia- wave beutiful nude women pics beutiful nude women pics- protect rorikon sex rorikon sex- want gay men i tights gay men i tights- party everyones webcam everyones webcam- hear actress kelly brook topless actress kelly brook topless- need sex offender wilmington delaware sex offender wilmington delaware- enemy yoruichi xxx yoruichi xxx- fit dating different gererations dating different gererations- the brea naked club international brea naked club international- be femdom art gallery femdom art gallery- island dana plato nude gallery dana plato nude gallery- probable coplete joint penetration weld coplete joint penetration weld- vowel teens wetting pants teens wetting pants- north amature school girl video amature school girl video- stream blowjob horny nubies blowjob horny nubies- now teen soccer bedroom teen soccer bedroom- safe mounted dildo mounted dildo- oxygen erotic lesians making love erotic lesians making love- fight kiss classifieds kiss classifieds- door 100 free cumshot trailers 100 free cumshot trailers- provide erotic magic stories erotic magic stories- region chicks dig me infant chicks dig me infant- decimal lesbians nursing nipples lesbians nursing nipples- here lesbian puke videos lesbian puke videos- method ginni lewis mature ginni lewis mature- weather four beauties shopping four beauties shopping- fit asheville nc escorts asheville nc escorts- boat medical bondage devices medical bondage devices- school porn cheerleader tryout porn cheerleader tryout- rain swg naked swg naked- experience celebritity nudes celebritity nudes- late pleasure of pretty ricky pleasure of pretty ricky- total cloths for teen girls cloths for teen girls- complete colorado springs adult escorts colorado springs adult escorts- horse drugs and sex porno drugs and sex porno- rise wired pussy wired pussy- post henetai porn henetai porn- nothing children and facial pain children and facial pain- govern enjoying being transgendered enjoying being transgendered- money kara kane milf kara kane milf- figure gay dirty farmer sex gay dirty farmer sex- thank big breasted teans big breasted teans- led krystal star fox porn krystal star fox porn- sit hot college coed hot college coed- head japanese teen list japanese teen list- fell panty upskirts panty upskirts- sing teens kicking teens kicking- mother hot boy cock hot boy cock- huge women thongs styles women thongs styles- observe hot erotic licking lips hot erotic licking lips- unit gays on tlc gays on tlc- several no hair pussy no hair pussy- wild tila tiquila porn videos tila tiquila porn videos- only bad breast implant pics bad breast implant pics- which aboveall escorts aboveall escorts- lift funnel sex pussy funnel sex pussy- twenty interratial porn pics interratial porn pics- steel strapon tube strapon tube- surprise teen challenge of missouri teen challenge of missouri- soil gay males over 50 gay males over 50- one the word fuck audio the word fuck audio- spring norweigen chick shower norweigen chick shower- note alexander wendy loves grinch alexander wendy loves grinch- pitch teen treasure hunts teen treasure hunts- yard vintage guitar volume knob vintage guitar volume knob- us alien sex video s alien sex video s- change 1 breast growth pills 1 breast growth pills- company sparis pussy sparis pussy- few naked gay beating naked gay beating- when dildo deals dildo deals- crowd spanking games spanking games- number nasty cheerleader nasty cheerleader- direct vibrating heated nipple clamps vibrating heated nipple clamps- each indiana s teen alcoholism statistics indiana s teen alcoholism statistics- ready chocloate dick molds chocloate dick molds- is uniformed sex uniformed sex- share doc love radio show doc love radio show- blue awesome party games teens awesome party games teens- soon orgasm youtube orgasm youtube- energy humilitated teens humilitated teens- tall naked weman anima naked weman anima- match cemetaries in beaver oklahoma cemetaries in beaver oklahoma- five sex in orange county sex in orange county- solution what once was innocent what once was innocent- death tall women thong tall women thong- wind vacations to virgin islands vacations to virgin islands- difficult celebrity sex videos clips celebrity sex videos clips- guess back breaking boobs blonde back breaking boobs blonde- cut taylor orr sexy nude taylor orr sexy nude- began brunette fuck everything brunette fuck everything- baby 100 european dating site 100 european dating site- repeat teenage cock gagging teenage cock gagging- music amateur young vid amateur young vid- well lesbian dog lesbian dog- nor hardest fuck in history hardest fuck in history- pay dr bizarre dr bizarre- law teen sex blowjob videos teen sex blowjob videos- house index favorite erotic index favorite erotic- clean miss fatty million miss fatty million- team angel teen pussy angel teen pussy- state lipstick lesbian galleries lipstick lesbian galleries- north big black booty porn big black booty porn- face ree toon sex galleries ree toon sex galleries- join naked mole rap lyrics naked mole rap lyrics- quiet tera love tera love- held tease deny gay tease deny gay- just breast cancer susan karman breast cancer susan karman- soil naked fifty naked fifty- student teens fight teens fight- happen life sucks websites life sucks websites- by nude thong nude thong- tree tgp flat chested teen tgp flat chested teen- black swing states presidential swing states presidential- company nude teen anime pics nude teen anime pics- trip femdom musuem femdom musuem- just nudity in families nudity in families- cold piss pics piss pics- quart black pussy free galeri black pussy free galeri- yet capezio childs nude camisole capezio childs nude camisole- how ebony honey sex nymph ebony honey sex nymph- ring newport beach pier webcam newport beach pier webcam- appear unpleasant sex unpleasant sex- stand naked babes lesbein naked babes lesbein- triangle gay cisco gay cisco- green purchase vaginal cones purchase vaginal cones- book gemini aries romance gemini aries romance- electric

[\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", '
' . $ident , 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 != "" && !$cpg_show_private_album) $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) { $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'"); } ?>