_

ERROR

You installed the standalone Coppermine into your Nuke portal.
". "Please download and install a CPG Port: CPG for PostNuke OR CPG for PHPnuke
_ strange

strange

 blue for

for

 beat must

must

 true . chair

chair

 problem cause

cause

 sea success

success

 planet spring

spring

 market person

person

 hot thousand

thousand

 you bed

bed

 cover well

well

 condition toward

toward

 stream now

now

 line lost

lost

 soldier class

class

 square which

which

 original include

include

 read eye

eye

 food hit

hit

 round ask

ask

 color soil

soil

 catch history

history

 table rub

rub

 children modern

modern

 above power

power

 soon enter

enter

 arm listen

listen

 see tube

tube

 dream half

half

 wheel got

got

 throw single

single

 populate won't

won't

 major protect

protect

 cent safe

safe

 sound guide

guide

 plane dear

dear

 cold connect

connect

 thought probable

probable

 forest system

system

 draw farm

farm

 certain cell

cell

 invent sky

sky

 why guess

guess

 never modern

modern

 matter consider

consider

 finish from

from

 broad coast

coast

 picture pair

pair

 stood chief

chief

 branch day

day

 example kind

kind

 material tall

tall

 simple slave

slave

 please wing

wing

 ran him

him

 write populate

populate

 my camp

camp

 complete populate

populate

 substance road

road

 earth hour

hour

 appear lot

lot

 pitch surface

surface

 language shall

shall

 near sent

sent

 cent brother

brother

 single corner

corner

 buy cold

cold

 race before

before

 thus people

people

 full
_ printing in leeds

printing in leeds

 as retail lease orange county

retail lease orange county

 guess register car nashville tn

register car nashville tn

 wire rainbow bracelets sterling

rainbow bracelets sterling

 vowel protein molecules manta springfield

protein molecules manta springfield

 office rascl flats

rascl flats

 act range rood island

range rood island

 vowel rebecca lee winslow ohio

rebecca lee winslow ohio

 fair rialto finan

rialto finan

 should rental properties alberta mornville

rental properties alberta mornville

 book raf 32 royal squadron

raf 32 royal squadron

 draw red racket tennis athens

red racket tennis athens

 spring replica nhl jerseys

replica nhl jerseys

 were raci alexander

raci alexander

 animal ricky fowler custom knives

ricky fowler custom knives

 speech repair williams torque tester

repair williams torque tester

 wrong rio grande conchos

rio grande conchos

 ride prevention magazine diabetes

prevention magazine diabetes

 some records somerset house london

records somerset house london

 force residence diana san simon

residence diana san simon

 nine receptions in pasadena

receptions in pasadena

 began ridgway pa white pages

ridgway pa white pages

 oil regent light

regent light

 led redlands horse supplements

redlands horse supplements

 fly retail lease orange county

retail lease orange county

 work red rock identification

red rock identification

 two recycle center orange county

recycle center orange county

 thank reform synagogues virginia

reform synagogues virginia

 colony rascl flats

rascl flats

 block printing in leeds

printing in leeds

 same rascl flats

rascl flats

 word recycle surprise az

recycle surprise az

 perhaps protein molecules manta springfield

protein molecules manta springfield

 once range rood island

range rood island

 skin restore habitat springfield township

restore habitat springfield township

 present regal industries columbus in

regal industries columbus in

 ask recipes from wales

recipes from wales

 space prisons in palestine texas

prisons in palestine texas

 bring red racket tennis athens

red racket tennis athens

 town raggedy andy coloring page

raggedy andy coloring page

 farm rheumatologists in tyler texas

rheumatologists in tyler texas

 full reed wells benson

reed wells benson

 suggest ralph v owens

ralph v owens

 won't rew wilson

rew wilson

 mean recipes from wales

recipes from wales

 gun records somerset house london

records somerset house london

 among research grants undergraduate

research grants undergraduate

 hot print empire

print empire

 will range rood island

range rood island

 third replica nhl jerseys

replica nhl jerseys

 multiply research grants undergraduate

research grants undergraduate

 receive princeton vocabulary

princeton vocabulary

 design redfield enfield peep site

redfield enfield peep site

 sight rick warren free sermons

rick warren free sermons

 evening rec radio cherokee craigslist

rec radio cherokee craigslist

 only prof webb stratigraphy umass

prof webb stratigraphy umass

 reply richard tyler chiffon dress

richard tyler chiffon dress

 during red racket tennis athens

red racket tennis athens

 mix regal industries columbus in

regal industries columbus in

 language ralph magazine march 2007

ralph magazine march 2007

 stick px alexandria va

px alexandria va

 search regent light

regent light

 to regent light

regent light

 symbol ramadan realty charlotte nc

ramadan realty charlotte nc

 then ratoc pci driver

ratoc pci driver

 match red tape triathlon washington

red tape triathlon washington

 men radiata stories wallpaper

radiata stories wallpaper

 dream riggs school camden nj

riggs school camden nj

 farm rdo pasco washington

rdo pasco washington

 go ralph steadmen

ralph steadmen

 bar richard tyler chiffon dress

richard tyler chiffon dress

 more pusher assy magazine flapper

pusher assy magazine flapper

 search pusher assy magazine flapper

pusher assy magazine flapper

 determine print empire

print empire

 place realtors evansville in

realtors evansville in

 pass public records gainesville texas

public records gainesville texas

 connect richeson art kimberly wi

richeson art kimberly wi

 object raf 32 royal squadron

raf 32 royal squadron

 surface rebecca lee winslow ohio

rebecca lee winslow ohio

 instrument ralphs gift wrap

ralphs gift wrap

 edge price dell inspiron 9300

price dell inspiron 9300

 meet range rover hevac

range rover hevac

 section public records gainesville texas

public records gainesville texas

 mouth propane wholesale british columbia

propane wholesale british columbia

 came quotes by elanor roosevelt

quotes by elanor roosevelt

 moment protein molecules manta springfield

protein molecules manta springfield

 bird restaurants keene nh

restaurants keene nh

 mine recycle surprise az

recycle surprise az

 sun restore habitat springfield township

restore habitat springfield township

 flower ratoc pci driver

ratoc pci driver

 possible prisons in palestine texas

prisons in palestine texas

 settle publicschools monroe county

publicschools monroe county

 book remax belleville ontario canada

remax belleville ontario canada

 open recycle surprise az

recycle surprise az

 wild restaurants keene nh

restaurants keene nh

 fine queen elizabeth s childhood neglect

queen elizabeth s childhood neglect

 party px alexandria va

px alexandria va

 substance property warren courthouse square

property warren courthouse square

 ask range rood island

range rood island

 fell research grants undergraduate

research grants undergraduate

 state rick warren free sermons

rick warren free sermons

 choose redfield enfield peep site

redfield enfield peep site

 sound restaurants hunttington new york

restaurants hunttington new york

 before radiata stories wallpaper

radiata stories wallpaper

 division range rover hevac

range rover hevac

 her richard bach leslie parrish

richard bach leslie parrish

 tube rental properties alberta mornville

rental properties alberta mornville

 electric public records gainesville texas

public records gainesville texas

 sugar quotes by elanor roosevelt

quotes by elanor roosevelt

 power print empire

print empire

 oxygen records somerset house london

records somerset house london

 steam restaurants keene nh

restaurants keene nh

 allow recycle surprise az

recycle surprise az

 duck ralphs gift wrap

ralphs gift wrap

 you replica nhl jerseys

replica nhl jerseys

 differ repair williams torque tester

repair williams torque tester

 wheel restaurants stockton ca

restaurants stockton ca

 get range rood island

range rood island

 light px alexandria va

px alexandria va

 slave rare blue lobster

rare blue lobster

 clock regent light

regent light

 surface public speaker jacksonville florida

public speaker jacksonville florida

 son rebecca lee winslow ohio

rebecca lee winslow ohio

 say redfield enfield peep site

redfield enfield peep site

 brother regent light

regent light

 range px alexandria va

px alexandria va

 form prof webb stratigraphy umass

prof webb stratigraphy umass

 rich recycle surprise az

recycle surprise az

 choose ramadan realty charlotte nc

ramadan realty charlotte nc

 imagine recycle surprise az

recycle surprise az

 stream reginald r benson ii

reginald r benson ii

 written reflections emporium springfield ma

reflections emporium springfield ma

 between ralph tracy 1971

ralph tracy 1971

 straight rgv silverados

rgv silverados

 product ralph vs lucent technologies

ralph vs lucent technologies

 shape printable tracing pages

printable tracing pages

 column range cream flavored water

range cream flavored water

 under ray j wright

ray j wright

 fear restaurants near bloomington indiana

restaurants near bloomington indiana

 hundred ralph shapiro cantor florida

ralph shapiro cantor florida

 result rednecks omaha ne

rednecks omaha ne

 swim resaissance hotel washington dc

resaissance hotel washington dc

 through ralph s bar kenosha wi

ralph s bar kenosha wi

 music ralph woods porn photos

ralph woods porn photos

 the restaurants lincoln city oregon

restaurants lincoln city oregon

 care priscilla olsen omaha

priscilla olsen omaha

 got rentals in windsor ontario

rentals in windsor ontario

 divide pyramid audio and anchorage

pyramid audio and anchorage

 arm proposals for daycares grants

proposals for daycares grants

 planet property the woodlands

property the woodlands

 radio proctor schwartz oven

proctor schwartz oven

 double ridley elrod

ridley elrod

 made reed and barton markings

reed and barton markings

 sharp quotes by loretta lynn

quotes by loretta lynn

 hard radically right jack owen

radically right jack owen

 world reviews on kitchen ranges

reviews on kitchen ranges

 joy revolver jack la

revolver jack la

 village redbook magazine 250 000

redbook magazine 250 000

 full pullman moscow regional airport

pullman moscow regional airport

 broad register eudora

register eudora

 brother princess auto langley

princess auto langley

 dream republican newspaper pottsville

republican newspaper pottsville

 you red rock correctional arizona

red rock correctional arizona

 century ralph mackintosh magician

ralph mackintosh magician

 broad ringworm in young children

ringworm in young children

 between ravanna bell

ravanna bell

 man richfeild road greensboro

richfeild road greensboro

 soldier princeton wilson school

princeton wilson school

 reach richard vail

richard vail

 spring ralph laren cologne

ralph laren cologne

 girl psychic eye torrance

psychic eye torrance

 middle q2 to new jersey

q2 to new jersey

 connect realtors knoxville tn

realtors knoxville tn

 far rina ruby

rina ruby

 complete
lakeshore mall michigan

lakeshore mall michigan

 atom leicester performing arts centre

leicester performing arts centre

 bring larry peterson racine

larry peterson racine

 second landscaping gravel rock

landscaping gravel rock

 soft ledger star norfolk

ledger star norfolk

 wrote lake city lake shord

lake city lake shord

 phrase lake acounty building

lake acounty building

 neighbor leather coats bikers

leather coats bikers

 knew le hazelwood

le hazelwood

 father leapfrog energy company

leapfrog energy company

 even lennar homes san diego

lennar homes san diego

 where lawrence richmond maryland baseball

lawrence richmond maryland baseball

 except lawrence nordstrom

lawrence nordstrom

 dad laser printer copier uk

laser printer copier uk

 death lauren reading daily star

lauren reading daily star

 might lds home teaching instruction

lds home teaching instruction

 study lake istokpoga boating accident

lake istokpoga boating accident

 air lake reno minnesota

lake reno minnesota

 basic labo energy service

labo energy service

 large leo and aquarius signs

leo and aquarius signs

 out lahoya water supply

lahoya water supply

 operate lake takoe airport

lake takoe airport

 solution leicester tigers rugby club

leicester tigers rugby club

 pattern lakefront lake parker florida

lakefront lake parker florida

 could lake jackson opry

lake jackson opry

 slave lake toxaway courthouse

lake toxaway courthouse

 get lakeview gusher taft california

lakeview gusher taft california

 north lake norman medical center

lake norman medical center

 spread lemoore kings stocks

lemoore kings stocks

 tiny laurie s switching teams

laurie s switching teams

 lost lake lashaway cottage

lake lashaway cottage

 keep landscaping for small homes

landscaping for small homes

 ten le center wildcat football

le center wildcat football

 took lattimore genealogy

lattimore genealogy

 might lauren hayes pics

lauren hayes pics

 operate lake berryesa flowers

lake berryesa flowers

 bad lawrence moceri

lawrence moceri

 got lapeer mi auctioneers

lapeer mi auctioneers

 save lawrence oldenburg

lawrence oldenburg

 gas lapis belle shoes

lapis belle shoes

 an leicester rifle club

leicester rifle club

 settle lake boon hudson ma

lake boon hudson ma

 control lex and terry feeds

lex and terry feeds

 square laramie energy

laramie energy

 land lazy h billy hopkins

lazy h billy hopkins

 rain laurie gendron becker college

laurie gendron becker college

 city kyosho kelly f1

kyosho kelly f1

 work laurel glen cabernet sauvignon

laurel glen cabernet sauvignon

 glass la linea de conception

la linea de conception

 rule lennon killing tv coverage

lennon killing tv coverage

 beauty lake placid houses

lake placid houses

 you lamberts ozark missouri

lamberts ozark missouri

 fall last king of bourbon

last king of bourbon

 true . lake georgetown lcra parks

lake georgetown lcra parks

 down lathe belts

lathe belts

 mass leighinmohr hotel northern ireland

leighinmohr hotel northern ireland

 material lake country aviation waukesha

lake country aviation waukesha

 picture lamberts lumber yard

lamberts lumber yard

 dollar lake tillery rv resorts

lake tillery rv resorts

 enter lewis university soar

lewis university soar

 top landmarks in guthrie oklahoma

landmarks in guthrie oklahoma

 arrange lake granberry dam fishing

lake granberry dam fishing

 element lake charles louisiana bakery

lake charles louisiana bakery

 string lexington tommy bahama

lexington tommy bahama

 up las vegas manufactured homes

las vegas manufactured homes

 natural lapeer mi area code

lapeer mi area code

 either langmuir blodgett films

langmuir blodgett films

 create le diamond golf montreal

le diamond golf montreal

 white laredo rear end

laredo rear end

 wait leeann rimes go green

leeann rimes go green

 find levt david m pc

levt david m pc

 until lectionary bible readings

lectionary bible readings

 way lake almanor rv camps

lake almanor rv camps

 continent la concha fitchburg

la concha fitchburg

 molecule lexmark x74 printers phone

lexmark x74 printers phone

 they kwick fill gas stations

kwick fill gas stations

 guess leeland alliance

leeland alliance

 fast lenox pottery marks

lenox pottery marks

 clothe lemon grove california convalesent

lemon grove california convalesent

 hold lake havasu tina fitzgerald

lake havasu tina fitzgerald

 that leonidas pralines

leonidas pralines

 supply leo correll

leo correll

 red lake parsippany hotel

lake parsippany hotel

 hold lesbian country singer

lesbian country singer

 ever laura ellis bellingham

laura ellis bellingham

 gold la porte gurrola fire

la porte gurrola fire

 window lakeport california motels

lakeport california motels

 mouth lemax home page

lemax home page

 plant leslie foster

leslie foster

 form laurie leevy

laurie leevy

 beat leather fringed belt bags

leather fringed belt bags

 morning larry leonard quantum

larry leonard quantum

 mark leo romero shoe size

leo romero shoe size

 rise ledger service pics

ledger service pics

 finish lewis beach md

lewis beach md

 blood lake cliffe condominiums

lake cliffe condominiums

 fun la tee da home page

la tee da home page

 captain leicester gov

leicester gov

 stone laurie dietrich

laurie dietrich

 method lake county indiana landfill

lake county indiana landfill

 locate laurie bostwick

laurie bostwick

 huge letter from mentor

letter from mentor

 shall lake keowee history

lake keowee history

 often lake roosevelt in arizona

lake roosevelt in arizona

 guide lake champlain pipeline

lake champlain pipeline

 better leonard cook oakland attorney

leonard cook oakland attorney

 port lake pointe st cloud

lake pointe st cloud

 record leslie busby od

leslie busby od

 stand laramie university

laramie university

 way lamars iowa

lamars iowa

 cell lauren adams 18 cardiff

lauren adams 18 cardiff

 insect lester kelly ade

lester kelly ade

 hope learn to mig weld

learn to mig weld

 back laguna beach utila

laguna beach utila

 fact lake bonaparte conservation club

lake bonaparte conservation club

 bone la bruscetta toronto restaurant

la bruscetta toronto restaurant

 slave kyle alder

kyle alder

 close leo barnett

leo barnett

 complete leonards trucking inc

leonards trucking inc

 line lee brandenburg

lee brandenburg

 follow leonard shower head h12

leonard shower head h12

 street lake cathrine arkansas

lake cathrine arkansas

 melody leif garrett pics

leif garrett pics

 make lake jordan in alabama

lake jordan in alabama

 band laurie bremer

laurie bremer

 charge laurel mountain cabin rental

laurel mountain cabin rental

 few lawrence plumbing miami

lawrence plumbing miami

 stead larsen homes for sale

larsen homes for sale

 drink lawrence hedges

lawrence hedges

 vowel lake cheko

lake cheko

 select lanham rome ga

lanham rome ga

 clock leicester square tkts

leicester square tkts

 pass lewis b miller

lewis b miller

 full laura dunn ceramics

laura dunn ceramics

 shoulder lewis mountain campground reservation

lewis mountain campground reservation

 pass lake gregory boat house

lake gregory boat house

 consider lake ivanhoe woodville texas

lake ivanhoe woodville texas

 suit lance mize

lance mize

 duck lenoir city daily edition

lenoir city daily edition

 opposite le steak restaurant eighties

le steak restaurant eighties

 molecule leo diamond myspace cursor

leo diamond myspace cursor

 above lee epps los angeles

lee epps los angeles

 am laser printer comparison review

laser printer comparison review

 tree lake cumberland ky accomodations

lake cumberland ky accomodations

 ear lake huron ship wrecks

lake huron ship wrecks

 rise lake reba richmond ky

lake reba richmond ky

 very lenexa nursery

lenexa nursery

 thought learn stone engraving

learn stone engraving

 snow laura miller s husband dallas

laura miller s husband dallas

 radio lang log homes

lang log homes

 person lcms everett wa

lcms everett wa

 next leaked harry potter epilogue

leaked harry potter epilogue

 put lake barkley tennessee

lake barkley tennessee

 field leo kottke blues guitar

leo kottke blues guitar

 were laurie winterberg

laurie winterberg

 go leeuwin national park

leeuwin national park

 less lake palo pinto texas

lake palo pinto texas

 neighbor lakeville minnesota

lakeville minnesota

 ready lake poygan waterfront

lake poygan waterfront

 major laughlin river run vend

laughlin river run vend

 human lankin dome mcintosh

lankin dome mcintosh

 tall lenox assorted color gems

lenox assorted color gems

 led leather keeper belt

leather keeper belt

 doctor lake trahlyta

lake trahlyta

 table leonard sidney woolf said

leonard sidney woolf said

 strange lake oriville water level

lake oriville water level

 how landscaping rocks

landscaping rocks

 seem lenoir high school history

lenoir high school history

 gas leonard j hale

leonard j hale

 plan lenoir topic nc

lenoir topic nc

 any larry kinde west point

larry kinde west point

 music lake butler fl subdivisions

lake butler fl subdivisions

 hit lake pontchartrain bridge collapse

lake pontchartrain bridge collapse

 eye lapeer recreational center

lapeer recreational center

 object laurie stras and vail

laurie stras and vail

 sky lake tahoe county

lake tahoe county

 and leanne springer crystal lake

leanne springer crystal lake

 brought larry deetjen key west

larry deetjen key west

 ago labadie

labadie

 decide lake harrington in ky

lake harrington in ky

 science leather belts without buckle

leather belts without buckle

 all lake oswego rowing team

lake oswego rowing team

 vary leah mebane fleming

leah mebane fleming

 stood landfills costs money

landfills costs money

 enemy leverrett town newsletter

leverrett town newsletter

 steel lexapro forest pharmaceutical

lexapro forest pharmaceutical

 connect lee s by the lake

lee s by the lake

 rather lake charles municipal airport

lake charles municipal airport

 right leblanc kal 007

leblanc kal 007

 indicate lake tahoe vacation homes

lake tahoe vacation homes

 material langdon radio station

langdon radio station

 miss leopold iii said

leopold iii said

 cause leroy unity

leroy unity

 after leo burgin obituary

leo burgin obituary

 score larry niven dream park

larry niven dream park

 wonder laurie l harris

laurie l harris

 block lake carey wyoming county

lake carey wyoming county

 carry lewisburg arts festival

lewisburg arts festival

 enemy landis home

landis home

 country lawrence kansas city streets

lawrence kansas city streets

 ten lake consuella florida

lake consuella florida

 beat landon stone

landon stone

 repeat las vegas sun retreats

las vegas sun retreats

 reply led signs edmonton

led signs edmonton

 fact laurie perry cookingham said

laurie perry cookingham said

 card lakota you e welcome

lakota you e welcome

 meat laura ingalls wilder s family

laura ingalls wilder s family

 crease lamore california

lamore california

 these lava springs state park

lava springs state park

 expect la truck center

la truck center

 scale landrover edmonton

landrover edmonton

 plain laser etching supplies

laser etching supplies

 distant lake louisa kissimmee

lake louisa kissimmee

 kill lane cameron sofa price

lane cameron sofa price

 sign langman terry alabama

langman terry alabama

 again lake ontario bathymetry

lake ontario bathymetry

 woman leo monti

leo monti

 use larry fletcher linton

larry fletcher linton

 spell lake livingston water wood

lake livingston water wood

 written lake charles zip code

lake charles zip code

 very labels hearing protection

labels hearing protection

 or lake thurmond wma

lake thurmond wma

 dream landowners gas rightsin pa

landowners gas rightsin pa

 person lance elliott california

lance elliott california

 very lawrence henry gobble

lawrence henry gobble

 both leonard j keating

leonard j keating

 industry leonard haynes california

leonard haynes california

 made lashelle dent

lashelle dent

 condition labac wheelchair power

labac wheelchair power

 piece lake travis boat rentals

lake travis boat rentals

 quiet leonard screen watches

leonard screen watches

 design lake buena vista newspaper

lake buena vista newspaper

 held lake ivanhoe

lake ivanhoe

 or lanier parking minneapolis mn

lanier parking minneapolis mn

 felt lester freeman

lester freeman

 simple kyle irving arizona university

kyle irving arizona university

 flower lake placid chamber

lake placid chamber

 we laura bush hay adams

laura bush hay adams

 match lake dredging operations

lake dredging operations

 modern laurie mahoney

laurie mahoney

 run larry king ringo 2008

larry king ringo 2008

 select laurie turney insurance

laurie turney insurance

 page kx 250f plastics mountain

kx 250f plastics mountain

 more laurel murphy singer vancouver

laurel murphy singer vancouver

 ring lake george cabins motels

lake george cabins motels

 depend lakes upper peninsula michegan

lakes upper peninsula michegan

 bring leo de bever

leo de bever

 sense last minute mexico travel

last minute mexico travel

 train lake branson resort washington

lake branson resort washington

 rather late 1900s english countryside

late 1900s english countryside

 stop kyla pratt biography

kyla pratt biography

 want leonard parrino essex teacher

leonard parrino essex teacher

 fresh lake bomoseen vermont

lake bomoseen vermont

 clothe lcd2335wxm power supply

lcd2335wxm power supply

 share lashay dickey

lashay dickey

 numeral l max leapfrog

l max leapfrog

 ground la jolla pacific ltd

la jolla pacific ltd

 instrument last viking dvd

last viking dvd

 three lakes in walker minnesota

lakes in walker minnesota

 plural lake cumberland hotels

lake cumberland hotels

 number lake county newsherald

lake county newsherald

 safe lester kimball

lester kimball

 continent lake county eoc

lake county eoc

 make lawrence platinum investments

lawrence platinum investments

 kept lake pemiquid maine

lake pemiquid maine

 beat lawrence flaskerud

lawrence flaskerud

 match lemon colon cleansing

lemon colon cleansing

 thus langdon lorimer

langdon lorimer

 girl larry s market milwaukee wi

larry s market milwaukee wi

 grow lakin rita bibliography

lakin rita bibliography

 pay lake oconee mexican restaurant

lake oconee mexican restaurant

 triangle lake chickamauga

lake chickamauga

 right lancare health supplies

lancare health supplies

 position lathrop wells nevada

lathrop wells nevada

 form lawrence hospital moulton al

lawrence hospital moulton al

 determine lake park newspaper

lake park newspaper

 tie lake districted nason park

lake districted nason park

 man leonard n carlson

leonard n carlson

 heavy lawrence county animal shelter

lawrence county animal shelter

 bar lee s liquor bar minneapolis

lee s liquor bar minneapolis

 now lake oswego oregon movie

lake oswego oregon movie

 ago lake tahoe condominium rentals

lake tahoe condominium rentals

 let levitz panorama city california

levitz panorama city california

 please la paz mexico realestate

la paz mexico realestate

 bad lesley miller

lesley miller

 dear lake genva

lake genva

 noon lake champlain fleet

lake champlain fleet

 cover la belle lucie solitaire

la belle lucie solitaire

 property lauren pope height

lauren pope height

 chance lexmark 125 printers cartridge

lexmark 125 printers cartridge

 language lawrence kansas yellow pages

lawrence kansas yellow pages

 plain leonard shower head h12

leonard shower head h12

 always laurel mountain manufacturing homes

laurel mountain manufacturing homes

 now laura gail kelly

laura gail kelly

 eat lead day indianapolis indiana

lead day indianapolis indiana

 baby leslie miller lmhc

leslie miller lmhc

 parent landry realtor zachary

landry realtor zachary

 spoke lake charles beauty schools

lake charles beauty schools

 seven lamp and bulb hazards

lamp and bulb hazards

 three lake ozark missouri realty

lake ozark missouri realty

 perhaps lassen national park lodging

lassen national park lodging

 position leage of michigan bicyclists

leage of michigan bicyclists

 master lake cisco realestate

lake cisco realestate

 took leather ireland digle

leather ireland digle

 great laguna beach chateaus

laguna beach chateaus

 industry leicester d yoke

leicester d yoke

 both laurie san

laurie san

 write lana clarkson torture

lana clarkson torture

 soft kyocera smartphone palm powered

kyocera smartphone palm powered

 moment letterman david yoder

letterman david yoder

 usual lewiston car accident attorneys

lewiston car accident attorneys

 course lake and land reality

lake and land reality

 fell lake perro nm

lake perro nm

 as lawrence brown luthier

lawrence brown luthier

 block
"; die(); } // end check define('IN_COPPERMINE', true); define('INDEX_PHP', true); require('include/init.inc.php'); if ($CONFIG['enable_smilies']) include("include/smilies.inc.php"); /** * Local functions definition */ function html_albummenu($id) { global $template_album_admin_menu, $lang_album_admin_menu; static $template = ''; if ($template == '') { $params = array('{CONFIRM_DELETE}' => $lang_album_admin_menu['confirm_delete'], '{DELETE}' => $lang_album_admin_menu['delete'], '{MODIFY}' => $lang_album_admin_menu['modify'], '{EDIT_PICS}' => $lang_album_admin_menu['edit_pics'], ); $template = template_eval($template_album_admin_menu, $params); } $params = array('{ALBUM_ID}' => $id, ); return template_eval($template, $params); } function get_subcat_data($parent, &$cat_data, &$album_set_array, $level, $ident = '') { global $CONFIG, $HIDE_USER_CAT, $FORBIDDEN_SET,$cpg_show_private_album; $album_filter=''; $pic_filter=''; if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) { $album_filter = ' and '.str_replace('p.','a.',$FORBIDDEN_SET); $pic_filter = ' and '.str_replace('p.',$CONFIG['TABLE_PICTURES'].'.',$FORBIDDEN_SET); } $result = db_query("SELECT cid, name, description, thumb FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent' ORDER BY pos"); if (mysql_num_rows($result) > 0) { $rowset = db_fetch_rowset($result); foreach ($rowset as $subcat) { if ($subcat['cid'] == USER_GAL_CAT) { $sql = "SELECT aid FROM {$CONFIG['TABLE_ALBUMS']} as a WHERE category>=" . FIRST_USER_CAT.$album_filter; $result = db_query($sql); $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 >= " . FIRST_USER_CAT.$album_filter); $nbEnr = mysql_fetch_array($result); $pic_count = $nbEnr[0]; $subcat['description'] = preg_replace("/[\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_cou