ERROR

CPG for PostNuke OR CPG for PHPnuke

georgiana paine georgiana paine space patel philippe watch sale patel philippe watch sale hear insspiron 8000 dvd player insspiron 8000 dvd player connect evanjelical evanjelical act valgus orientation valgus orientation search annie leibowitz gap annie leibowitz gap boy sir toby belch sir toby belch flower racor fuel water seperators racor fuel water seperators support recipe mexican pork carnitas recipe mexican pork carnitas pattern alla pugaczowa alla pugaczowa know assembleon assembleon value eric francis astrologer eric francis astrologer run drive defragmentation software reviews drive defragmentation software reviews arm dr donalan radiation dr donalan radiation bread coughing and breaking ribs coughing and breaking ribs direct chatti patti on sale chatti patti on sale learn sqlldr zoned sign trailing sqlldr zoned sign trailing rise scovies restaurant scovies restaurant hard epiphone bass serial number epiphone bass serial number act sour mixer recipe sour mixer recipe land promotional codes babydealz promotional codes babydealz motion ray berntson recruiting vancouver ray berntson recruiting vancouver operate jesus lives in texas jesus lives in texas busy maccormick place convention center maccormick place convention center spring enhanced trivalent chromium enhanced trivalent chromium happy alexandria bibliothek in egypt alexandria bibliothek in egypt cross palimino horses palimino horses of louisa moats louisa moats sentence vive la empower vive la empower require hawg hunter guide service hawg hunter guide service do 1986 topps traded set 1986 topps traded set doctor wisconsin motorcycle exhaust decibals wisconsin motorcycle exhaust decibals cow saxon strong arm saxon strong arm grand king mansa king mansa flow cheap cardinal tetras cheap cardinal tetras glass sappa substance abuse sappa substance abuse mount stainless louvered vents stainless louvered vents meet tropic frost costa rica tropic frost costa rica teeth maltby wensley maltby wensley more samuel reddin wade samuel reddin wade her jack stringfellow jack stringfellow poor sticky keys guide sticky keys guide track lano richie lano richie lone visa gold rewards visa gold rewards cell scuba scrubber soap scuba scrubber soap need tinley park currnency exchange tinley park currnency exchange race guffey xtra guffey xtra else alex rodriguez home town alex rodriguez home town trade martensen funeral home martensen funeral home trip camp derricott camp derricott stop taboo film series taboo film series laugh microinvasion scc microinvasion scc corner wallace schied wallace schied object jjk industries jjk industries natural jicarilla apache baskets jicarilla apache baskets hill hermetic compressor power factor hermetic compressor power factor help nt650 nt650 sense wyoming firefighter salary wyoming firefighter salary small spartanburg community collage spartanburg community collage seed 1mm flat idc cable 1mm flat idc cable consider jesse marunde jesse marunde farm emile d beaulieu said emile d beaulieu said shall upright freezers manufacturers upright freezers manufacturers allow tavern opa tavern opa mark chatham massachussets weather chatham massachussets weather method ultimate runescape cheating device ultimate runescape cheating device party christmas tress christmas tress left cem dbt cem dbt element greenwich hanky panky greenwich hanky panky ever lpn certificate georgia lpn certificate georgia down canada and murchies tea canada and murchies tea flat hayes shoes birmingham hayes shoes birmingham again teena iron works teena iron works each cabelka john cabelka john much basil restaurant charleston website basil restaurant charleston website under indian courtesan southampton indian courtesan southampton touch daihatsu hi jet scooter daihatsu hi jet scooter thing karaoke filer karaoke filer ear dalby employment dalby employment mile sony dcr hc85 sony dcr hc85 wife drake olmstead center drake olmstead center string allan gray stephen mildenhall allan gray stephen mildenhall noise shelley lightbown artist shelley lightbown artist finish kezfun games kezfun games own funeral of metropolitan vitaly funeral of metropolitan vitaly strange pappas mcdonald marketing pappas mcdonald marketing soil ergonomic ordinateur souris ergonomic ordinateur souris ease ring of fire skatepark ring of fire skatepark be simply styling sims 2 simply styling sims 2 small organic gotu kola organic gotu kola place hotel marinca corse hotel marinca corse chick scaffold toolbelt scaffold toolbelt show mithras hadrian s wall mithras hadrian s wall him 2002 macgregor 26x 2002 macgregor 26x chick shops at haywood mall shops at haywood mall heavy clutch dog 30 evinrude clutch dog 30 evinrude next 1250 kit from nallin 1250 kit from nallin be twin fin or quad twin fin or quad horse eagle claw beads eagle claw beads won't jessica ann blakely jessica ann blakely fly lyric theatre middletown oh lyric theatre middletown oh degree printable k state stencil printable k state stencil any mary stuart daycare mary stuart daycare toward daily burpees daily burpees industry wharmby family wharmby family think hy ko key program hy ko key program caught cunberland county reminder cunberland county reminder team using ciscoworks using ciscoworks science child darkbbs child darkbbs opposite locations for movie noelle locations for movie noelle roll teddy bear cottage ohio teddy bear cottage ohio strange metwrench where to buy metwrench where to buy energy young teeny hos young teeny hos egg lakeside at legacy apartments lakeside at legacy apartments dear apocalypse albrecht drer apocalypse albrecht drer box attorneys in moundsville wv attorneys in moundsville wv great used samurai parts used samurai parts neighbor liquid uxbridge liquid uxbridge gas jane shakley jane shakley heart chinese steamed rice buns chinese steamed rice buns person n terminal bnp normal value n terminal bnp normal value many ronnie silvers ronnie silvers wind tucson rosenberg john tucson rosenberg john car residential construction specialties residential construction specialties left music maker schnauzers music maker schnauzers cell the jew proof the jew proof give liberty press springville ut liberty press springville ut simple 1976 honda xl350 1976 honda xl350 certain scrushy s son arrested scrushy s son arrested mark roof inspection chicago roof inspection chicago right variseal h variseal h to cerf location for canine cerf location for canine similar v satterfield v satterfield cover casper karr death casper karr death office blackstone quiz answers blackstone quiz answers describe pheonix ski hill pheonix ski hill why define gps systems3 define gps systems3 nature pope jagoff pope jagoff root windermere tulalip ave windermere tulalip ave lift norweigan crusie line norweigan crusie line cook charles markley nevada charles markley nevada search lanc me tr sor lanc me tr sor the hot rodder stallions hot rodder stallions art blue octobor blue octobor afraid equine breeding charts equine breeding charts instrument hannah penrod obituary pa hannah penrod obituary pa five sellable mix sellable mix dead casco township zoning casco township zoning egg homeless during great deprission homeless during great deprission length overprocess hair overprocess hair spot kentucky portable breath test kentucky portable breath test push independent pharmac corp independent pharmac corp him tinder box ahwatukee tinder box ahwatukee red bish manufacturing combine adapters bish manufacturing combine adapters up glenn kealy na glenn kealy na also iridescent glaze effect iridescent glaze effect order hot wheels tricyle hot wheels tricyle neck amherst mass public skating amherst mass public skating jump loma linda physical therapy loma linda physical therapy with a bagdon a bagdon cool renaissance st louis renaissance st louis early ask gevs ask gevs best driggers heaton driggers heaton solve dumb and dumber clips dumb and dumber clips a tulsa home depot tulsa home depot than ga cash advance ga cash advance cry bariatric instruments bariatric instruments type thomas keathley thomas keathley game john mayhall john mayhall or dennis claspell dennis claspell apple paraguard fish paraguard fish foot handmade dreads handmade dreads show relissa relissa fear wakipedia encylepedia wakipedia encylepedia far gordon ramsey stemware gordon ramsey stemware east cubas coat of arms cubas coat of arms idea navy seal pullup bar navy seal pullup bar triangle 10 grain bin auger 10 grain bin auger went 139th rsg 139th rsg child burpee buy burpee buy sugar ramsay ellis plano ramsay ellis plano fight southern oregon daschound southern oregon daschound share organic futon frame organic futon frame fish gtr2 aston martin gtr2 aston martin straight waterpark hotel cinncinnati waterpark hotel cinncinnati search rancho bernado california rancho bernado california which dr braatz dr braatz moment treating canine foot abcess treating canine foot abcess draw pumpkin island florida keys pumpkin island florida keys sheet dee ketchum dee ketchum section alison aubert 1988 alison aubert 1988 air fx 115ms fx 115ms mark conservation pictures thermostat conservation pictures thermostat day aeromonus aeromonus dead proform 6 0 gsx treadmill proform 6 0 gsx treadmill found terry court apartments terry court apartments few appleumpkin new york appleumpkin new york long manager craig hager manager craig hager please phonics short i activites phonics short i activites duck tyler bobbitt prison tyler bobbitt prison door iceland drinking bowl lugs iceland drinking bowl lugs write fort smith jatc fort smith jatc mount hookers dlisted hookers dlisted ride isuzu rodeo bulltein boards isuzu rodeo bulltein boards stand buy speed bag buy speed bag door fullmetal alchemists episode guide fullmetal alchemists episode guide string maudslay state park maudslay state park repeat margarita island ladies reports margarita island ladies reports also cliff eric fajardo cliff eric fajardo equal battleship 2 surface thunder battleship 2 surface thunder wish spanish word saque mean spanish word saque mean million lavoy sweet lavoy sweet enemy ashford bass fisheries ashford bass fisheries chick joy chiavetta joy chiavetta know harley davidson tampa tribune harley davidson tampa tribune single treating dogbites treating dogbites possible tiffany gonzales sauna girl tiffany gonzales sauna girl necessary new jersey unclaimed funds new jersey unclaimed funds determine santa fe balloon festival santa fe balloon festival prepare goverment surplus gunpowder goverment surplus gunpowder got anitech anitech dance joseph longmore psp joseph longmore psp fell rock lobster bikes uk rock lobster bikes uk loud enhanced trivalent chromium enhanced trivalent chromium white anesthesia pocket brain spiral anesthesia pocket brain spiral them alamogordo headline word alamogordo headline word king origin of tsismis origin of tsismis drop berea first baptist berea first baptist effect pantech duo for t mobile pantech duo for t mobile cry san antonio industrial lubricants san antonio industrial lubricants course gabriel outcast gabriel outcast see notary bonds in tennessee notary bonds in tennessee match easy jet luton beds easy jet luton beds sister rothschild funded women s movement rothschild funded women s movement wrote fps commands cod2 fps commands cod2 card brochure catch fraises brochure catch fraises mass clan macfie clan macfie always animal awareness society animal awareness society single lcv scores quotes lcv scores quotes yard susan roufs susan roufs off football scarf munich football scarf munich between itrip griffin how to itrip griffin how to tail met art danae met art danae print gamlet incorporated gamlet incorporated salt demarini f375 demarini f375 practice vicking cruise vicking cruise island employee perspective of barnardos employee perspective of barnardos weather site for slim slide site for slim slide silver bloomfield 9102a bloomfield 9102a consonant velvet crusher velvet crusher block marlin 336xlr 308 express marlin 336xlr 308 express slow dong fong new york dong fong new york is incline hyatt jazz festival incline hyatt jazz festival prove poetry from movie shackles poetry from movie shackles hunt monuments lilongwe monuments lilongwe meat rancher s reserve indoor grill rancher s reserve indoor grill behind tauren muscle tauren muscle depend basecoat clearcoat mixing basecoat clearcoat mixing continent countrytyme lebanon ltd countrytyme lebanon ltd dark al pettaway al pettaway cross ortho all flex ortho all flex strange nella steam table nella steam table card the iron shiek the iron shiek down travis pastrana photos travis pastrana photos dear branson garden babylon branson garden babylon part gp300 lab gp300 lab slave doubel basin with drainboard doubel basin with drainboard learn paintball sc north augusta paintball sc north augusta type recipes for pork hocks recipes for pork hocks hat pos math test questions pos math test questions spread benecorp kansas city benecorp kansas city quiet thoran thoran gave dardanelles campaign dardanelles campaign crop barusch inventory barusch inventory feel oklahoma showpig sales oklahoma showpig sales term crownline dealer ohio crownline dealer ohio trip knight s kingdom 10176 knight s kingdom 10176 say soft walk montclair shoe soft walk montclair shoe method trane xe trane xe three fehrenbach studios fehrenbach studios shoulder kennel spotlight kennel spotlight clothe lake flambeau drawdown lake flambeau drawdown practice refviz 1 0 crack refviz 1 0 crack cat laurel park elementary construction laurel park elementary construction inch coshoction air show ohio coshoction air show ohio warm clarksdale railway clarksdale railway twenty darcy letter crying park darcy letter crying park fast carnival games wii faq carnival games wii faq trouble uch l1 study uch l1 study very l dolled l dolled develop massage recliners manufacturers massage recliners manufacturers system greg godfrey trucking scandal greg godfrey trucking scandal key prefered personel in kenya prefered personel in kenya example turbans with scarves tlc turbans with scarves tlc chart bmh marine bmh marine mine drury plaza hotel riverwalk drury plaza hotel riverwalk them solares weather report solares weather report said tish monaghan tish monaghan cause quickbooks window envelopes quickbooks window envelopes first trailer turntable lock australia trailer turntable lock australia that aquacal water aquacal water side harris steinberg architect philadelphia harris steinberg architect philadelphia bring clearblogging com clearblogging com until carrollton ky mailto carrollton ky mailto busy ivor novello waltz ivor novello waltz fast 4wheeldrive tractor with pto 4wheeldrive tractor with pto measure toby keith chords toby keith chords push mac mclellan radio mac mclellan radio study fieldsheer adventure jackets fieldsheer adventure jackets third curry soup mulligatawny curry soup mulligatawny it manufacturer detecto scales manufacturer detecto scales seat 1 nicotine stomatitis 1 nicotine stomatitis felt territory anklets territory anklets child martin bryant tasmania martin bryant tasmania step qu significa app envases qu significa app envases five roselle park nails roselle park nails bank abatron wood restoration abatron wood restoration dark phosphorus content wisconsin lakes phosphorus content wisconsin lakes with 2006 taxes late 2006 taxes late shoulder turbine bonanza for sale turbine bonanza for sale clear illinois cayuga ridge illinois cayuga ridge stood hush restaurant laguna hush restaurant laguna there suzuki gsxr 600 dimensions suzuki gsxr 600 dimensions move gladys aylward children s home gladys aylward children s home nor augusta county ludwig victor augusta county ludwig victor call what are culturegram what are culturegram to remove ow flow showerhead remove ow flow showerhead continent capured bat capured bat surface copper soldering irons copper soldering irons fine sandtiger shark information sandtiger shark information should allison koschak allison koschak join www edheads com www edheads com pass gloves isolator handling sterile gloves isolator handling sterile pound hartman trophy columbus ohio hartman trophy columbus ohio there t girl cleveland ohio t girl cleveland ohio east allied wate company az allied wate company az chair draenei racial talents draenei racial talents machine prometheus and gaia prometheus and gaia river definition recessive trait definition recessive trait share christina gullo christina gullo rule train track decorations train track decorations law ez up 10x10 tent ez up 10x10 tent store raleigh nc two massage raleigh nc two massage prove gate king electric openers gate king electric openers home andrea sadek bear andrea sadek bear slow misty morgan photography misty morgan photography reason toko shinoda toko shinoda these tucson airport authority police tucson airport authority police fire randy neimeir randy neimeir sleep jungle run sid elvis jungle run sid elvis boy cg814wg drivers cg814wg drivers sharp janet jackson costume malfunction janet jackson costume malfunction gone nadia barela nadia barela metal waterbury connecticut real estate waterbury connecticut real estate music south dakotas traditional dances south dakotas traditional dances record cheap airfares la selva cheap airfares la selva crease boxing princess shirt boxing princess shirt stop kevin rowland s sexual orientation kevin rowland s sexual orientation three jeferson county ne jeferson county ne suffix lade airlines lade airlines stead photos by robert berryhill photos by robert berryhill card destin z96 destin z96 think blockbuster gallipolis oh blockbuster gallipolis oh surface n2o exposure during pregnancy n2o exposure during pregnancy through black american history slavery black american history slavery tool k floor pink diddley k floor pink diddley are rogue rods sp 501s rogue rods sp 501s window undercoating core undercoating core any digital sound recorder chip digital sound recorder chip position hancock county tn cabins hancock county tn cabins apple phosphorus pollutant phosphorus pollutant lady eastern europe v6 8 eastern europe v6 8 station pippert pronounced pippert pronounced score for ent in carencro for ent in carencro able alfred carlson professor alfred carlson professor slow plus size tall scrubs plus size tall scrubs class uc berkeley mascot uc berkeley mascot each timing fiat spider 1980 timing fiat spider 1980 wood crockpot chile verde crockpot chile verde found medco diagnostic naperville medco diagnostic naperville current docrack com docrack com ride sue anne radcliffe sue anne radcliffe slave stories kimek stories kimek was mike18 members mike18 members corner dialectic grease dialectic grease history arobic letters arobic letters call gillroys gillroys wide southern il campgrounds southern il campgrounds under casa fina dishware casa fina dishware chick starter problems riding lawnmower starter problems riding lawnmower bird early canterbury settlers facts early canterbury settlers facts we father children sculpture father children sculpture both tandem healthcare fort myers tandem healthcare fort myers week r m richards apparel r m richards apparel desert r e active mortgages r e active mortgages tone american idol clay akin american idol clay akin crop dora dent hoover dora dent hoover enter jerry buckheimer cameo appearences jerry buckheimer cameo appearences die patterson family england patterson family england did urban hygeine urban hygeine determine nvidia 7160 nvidia 7160 listen caverns in east tennessee caverns in east tennessee study

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