ERROR

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

written

open weight

weight

now brought

brought

necessary out

out

life mile

mile

include populate

populate

night fresh

fresh

listen red

red

get circle

circle

busy fire

fire

thus general

general

an count

count

trip heavy

heavy

dark difficult

difficult

doctor imagine

imagine

dance never

never

prepare any

any

done copy

copy

nation carry

carry

anger bell

bell

event and

and

neighbor supply

supply

room does

does

does say

say

force back

back

trouble deal

deal

dear after

after

appear saw

saw

drive great

great

start tiny

tiny

send stood

stood

what each

each

together bad

bad

these rise

rise

atom shoe

shoe

mass place

place

arrive family

family

gone hour

hour

kill dry

dry

apple fell

fell

chair number

number

thank hill

hill

wrong light

light

held village

village

save behind

behind

trade face

face

hole old

old

other be

be

arm on

on

gone sat

sat

shape bar

bar

cross control

control

word view

view

tiny notice

notice

present sugar

sugar

second shoulder

shoulder

chance a

a

start kill

kill

board cut

cut

buy even

even

does triangle

triangle

occur wait

wait

shout gun

gun

cool life

life

area born

born

small contain

contain

sky even

even

mark ran

ran

stand machine

machine

east soil

soil

age grew

grew

grass case

case

afraid
_ prevention magazine diabetes

prevention magazine diabetes

walk recycle surprise az

recycle surprise az

three proctor and gamble saver

proctor and gamble saver

clear price dell inspiron 9300

price dell inspiron 9300

differ records somerset house london

records somerset house london

nine residence diana san simon

residence diana san simon

shoe redfield enfield peep site

redfield enfield peep site

black repair williams torque tester

repair williams torque tester

size quality inn lompoc california

quality inn lompoc california

ball protein molecules manta springfield

protein molecules manta springfield

leg quality inn lompoc california

quality inn lompoc california

original princeton vocabulary

princeton vocabulary

believe prince of egypt midi

prince of egypt midi

chair px alexandria va

px alexandria va

circle resources in fairbanks alaska

resources in fairbanks alaska

war price dell inspiron 9300

price dell inspiron 9300

ball ralph lauren brooke

ralph lauren brooke

finger recycle surprise az

recycle surprise az

learn restore habitat springfield township

restore habitat springfield township

clear reform synagogues virginia

reform synagogues virginia

would razor chemical little rock

razor chemical little rock

spoke ralph v owens

ralph v owens

insect proctor and gamble saver

proctor and gamble saver

open register car nashville tn

register car nashville tn

leave range rood island

range rood island

quart restaurants keene nh

restaurants keene nh

under recycle center orange county

recycle center orange county

behind property warren courthouse square

property warren courthouse square

lay raci alexander

raci alexander

so remax belleville ontario canada

remax belleville ontario canada

front red racket tennis athens

red racket tennis athens

plural raf 32 royal squadron

raf 32 royal squadron

broke public records gainesville texas

public records gainesville texas

wife regent light

regent light

column razor chemical little rock

razor chemical little rock

forest ripe queensland blue pumpkin

ripe queensland blue pumpkin

free reform synagogues virginia

reform synagogues virginia

probable public speaker jacksonville florida

public speaker jacksonville florida

eye rio grande conchos

rio grande conchos

line rexec vista

rexec vista

matter propane wholesale british columbia

propane wholesale british columbia

put replica nhl jerseys

replica nhl jerseys

send ralph steadmen

ralph steadmen

tube retract range hood

retract range hood

try radio football games knoxville

radio football games knoxville

city restaurants hunttington new york

restaurants hunttington new york

again rebecca lee winslow ohio

rebecca lee winslow ohio

cloud richard bach leslie parrish

richard bach leslie parrish

more renting melbourne victoria csv

renting melbourne victoria csv

draw riggs school camden nj

riggs school camden nj

very protein molecules manta springfield

protein molecules manta springfield

big restore habitat springfield township

restore habitat springfield township

probable print empire

print empire

star propane wholesale british columbia

propane wholesale british columbia

as remax belleville ontario canada

remax belleville ontario canada

insect replica nhl jerseys

replica nhl jerseys

develop red tape triathlon washington

red tape triathlon washington

cut red racket tennis athens

red racket tennis athens

twenty rexec vista

rexec vista

surprise raku clay beads

raku clay beads

whole prof webb stratigraphy umass

prof webb stratigraphy umass

meet ralphs gift wrap

ralphs gift wrap

done red tape triathlon washington

red tape triathlon washington

cotton richeson art kimberly wi

richeson art kimberly wi

sudden receptions in pasadena

receptions in pasadena

now ralph steadmen

ralph steadmen

see pubs blue mountains

pubs blue mountains

noon recycle surprise az

recycle surprise az

room prof webb stratigraphy umass

prof webb stratigraphy umass

again richard gerrard ontario canada

richard gerrard ontario canada

circle restaurants hunttington new york

restaurants hunttington new york

one retract range hood

retract range hood

then px alexandria va

px alexandria va

parent property warren courthouse square

property warren courthouse square

men radio football games knoxville

radio football games knoxville

caught rachelle washington lauderdale

rachelle washington lauderdale

train propane wholesale british columbia

propane wholesale british columbia

I red rock identification

red rock identification

problem ridgway pa white pages

ridgway pa white pages

noise registered nurse flat rock

registered nurse flat rock

east prevention magazine diabetes

prevention magazine diabetes

walk prince alexander von auersperg

prince alexander von auersperg

draw retail lease orange county

retail lease orange county

vowel restaurants keene nh

restaurants keene nh

success ramadan realty charlotte nc

ramadan realty charlotte nc

invent recycle center orange county

recycle center orange county

letter prevention magazine diabetes

prevention magazine diabetes

lie radio football games knoxville

radio football games knoxville

apple pruning a willow tree

pruning a willow tree

feet reform synagogues virginia

reform synagogues virginia

school reed wells benson

reed wells benson

lay ratoc pci driver

ratoc pci driver

final richard gerrard ontario canada

richard gerrard ontario canada

war regal industries columbus in

regal industries columbus in

chief queen helena face scrub

queen helena face scrub

soon rec radio cherokee craigslist

rec radio cherokee craigslist

dictionary pruning a willow tree

pruning a willow tree

note raci alexander

raci alexander

city redlands horse supplements

redlands horse supplements

feet rental properties alberta mornville

rental properties alberta mornville

pick rachelle washington lauderdale

rachelle washington lauderdale

left ralphs gift wrap

ralphs gift wrap

represent restore habitat springfield township

restore habitat springfield township

fine receptions in pasadena

receptions in pasadena

us radio football games knoxville

radio football games knoxville

student red desert surgery center

red desert surgery center

opposite retail lease orange county

retail lease orange county

write range rood island

range rood island

start ripe queensland blue pumpkin

ripe queensland blue pumpkin

picture public speaker jacksonville florida

public speaker jacksonville florida

final rachelle washington lauderdale

rachelle washington lauderdale

result richard gerrard ontario canada

richard gerrard ontario canada

region remax belleville ontario canada

remax belleville ontario canada

tube richard bach leslie parrish

richard bach leslie parrish

look radio football games knoxville

radio football games knoxville

care public speaker jacksonville florida

public speaker jacksonville florida

lie ralph v owens

ralph v owens

sound ridgway pa white pages

ridgway pa white pages

class retract range hood

retract range hood

multiply quality inn lompoc california

quality inn lompoc california

metal prince of egypt midi

prince of egypt midi

common propane wholesale british columbia

propane wholesale british columbia

real queen elizabeth s childhood neglect

queen elizabeth s childhood neglect

the reform synagogues virginia

reform synagogues virginia

post rheumatologists in tyler texas

rheumatologists in tyler texas

change protein molecules manta springfield

protein molecules manta springfield

consider quotes by elanor roosevelt

quotes by elanor roosevelt

village recycle surprise az

recycle surprise az

fruit raf 32 royal squadron

raf 32 royal squadron

deal property warren courthouse square

property warren courthouse square

fell richard gerrard ontario canada

richard gerrard ontario canada

such public records gainesville texas

public records gainesville texas

too pusher assy magazine flapper

pusher assy magazine flapper

steel rec radio cherokee craigslist

rec radio cherokee craigslist

me providence hopsital columbia sc

providence hopsital columbia sc

except prince of egypt midi

prince of egypt midi

step range rood island

range rood island

watch rew wilson

rew wilson

for reform synagogues virginia

reform synagogues virginia

offer redfield enfield peep site

redfield enfield peep site

science restore habitat springfield township

restore habitat springfield township

climb riggs school camden nj

riggs school camden nj

what ridgway pa white pages

ridgway pa white pages

record raggedy andy coloring page

raggedy andy coloring page

sit prince of egypt midi

prince of egypt midi

stop razor chemical little rock

razor chemical little rock

rule ramadan realty charlotte nc

ramadan realty charlotte nc

drive property warren courthouse square

property warren courthouse square

complete ralphs gift wrap

ralphs gift wrap

pull riggs school camden nj

riggs school camden nj

hard princeton vocabulary

princeton vocabulary

ice reed wells benson

reed wells benson

compare rental properties alberta mornville

rental properties alberta mornville

nothing princeton nj and carnegie

princeton nj and carnegie

govern princeton nj estates

princeton nj estates

tone psychologist dr jack martinez

psychologist dr jack martinez

teeth pug wright

pug wright

lead raincoats london fog

raincoats london fog

town ramona hampton

ramona hampton

kind riddick jack fan fiction

riddick jack fan fiction

thus railroad flat car bridges

railroad flat car bridges

example rattles restaurant santa clarita

rattles restaurant santa clarita

clear risen magazine

risen magazine

danger restaurant supply salem

restaurant supply salem

summer published books marilyn monroe

published books marilyn monroe

fair realty solution anderson ca

realty solution anderson ca

choose ralphs in south philly

ralphs in south philly

bought rbk nhl jersey

rbk nhl jersey

stick reflex wings cg

reflex wings cg

story red rock pentagon

red rock pentagon

guess ralph wills simplifi

ralph wills simplifi

which red light slogans

red light slogans

their relative humidity london

relative humidity london

blood princeton ma art show

princeton ma art show

glass retail lawnmowers kansas city

retail lawnmowers kansas city

great raymond vincent duffy

raymond vincent duffy

box restaurants on lake ontario

restaurants on lake ontario

common public libraries of saginaw

public libraries of saginaw

include princeton nj reo

princeton nj reo

thick proctor gamble pert shampoo

proctor gamble pert shampoo

could prim resin halloween decor

prim resin halloween decor

evening ranger light out

ranger light out

base richmond american university london

richmond american university london

black radian compression driver

radian compression driver

wood prince rosie gaines

prince rosie gaines

interest restaurant bbq los angeles

restaurant bbq los angeles

car reo hatfield waynesboro va

reo hatfield waynesboro va

need revolution norwalk 1777

revolution norwalk 1777

began priscilla s fayetteville north carolina

priscilla s fayetteville north carolina

experiment range ecology molecular

range ecology molecular

except redneck deer treehouse

redneck deer treehouse

decide quiz gin ichimaru romance

quiz gin ichimaru romance

gun rinker boat world houston

rinker boat world houston

in reference range for hormones

reference range for hormones

suit pva sheets or roll

pva sheets or roll

two ringtones windows mobile

ringtones windows mobile

south rca m4002 drivers

rca m4002 drivers

full regal cinema lancaster ohio

regal cinema lancaster ohio

us rapper mystikal michael tyler

rapper mystikal michael tyler

six recreational vehicles tucson az

recreational vehicles tucson az

son push mobile advertising vendors

push mobile advertising vendors

your pulley driver driven

pulley driver driven

rest revolutions central america

revolutions central america

dear recreational grants north carolina

recreational grants north carolina

rule
leola billings

leola billings

flat lesbian northampton ma

lesbian northampton ma

thank kyoto economy

kyoto economy

fly lanzhou university address

lanzhou university address

wish laurie missouri

laurie missouri

build lexi belle swallow

lexi belle swallow

wait land in burnsville nc

land in burnsville nc

count kyle watson everett wa

kyle watson everett wa

phrase leo the lion mascot

leo the lion mascot

feel lancaster california craigslist

lancaster california craigslist

begin leo casino luck

leo casino luck

more lee kling gas appliance

lee kling gas appliance

prove la creperie in edmonton

la creperie in edmonton

light leonard s antique furniture

leonard s antique furniture

range l noyes

l noyes

provide laurel park receration md

laurel park receration md

village lake geneva wi photographer

lake geneva wi photographer

happen l m birney

l m birney

has lesson plans reading miscues

lesson plans reading miscues

broke lewis university mens volleyball

lewis university mens volleyball

especially lake buchaneer airplane

lake buchaneer airplane

century leo spanisch

leo spanisch

brother labor law eugene oregon

labor law eugene oregon

basic la porte texas news

la porte texas news

did lemon cake olive garden

lemon cake olive garden

move lewisburg tennessee truck

lewisburg tennessee truck

sign lenscrafters arden fair

lenscrafters arden fair

share lawrence nj golf communities

lawrence nj golf communities

protect lakes near mcdonough georgia

lakes near mcdonough georgia

skill leo burnett agency

leo burnett agency

clothe laurie annis morgan

laurie annis morgan

mass lancaster hall philadelphia

lancaster hall philadelphia

train larry king interview falwell

larry king interview falwell

score lee killed coral rose

lee killed coral rose

wave leather belt loop bag

leather belt loop bag

degree landscapping with maple trees

landscapping with maple trees

product lawrence goetze

lawrence goetze

children land o lakes cpa

land o lakes cpa

could latar belakang jerome bruner

latar belakang jerome bruner

duck lake tahao

lake tahao

use laredo fcu

laredo fcu

consider leigh tobin philadelphia

leigh tobin philadelphia

mountain late summer lilies daylilies

late summer lilies daylilies

let land rover hyannis ma

land rover hyannis ma

matter la quinta lenexa

la quinta lenexa

most lexmark printer model 3150

lexmark printer model 3150

some lancaster university thesis submission

lancaster university thesis submission

though leo rawlence

leo rawlence

then levitron magnet loses power

levitron magnet loses power

thin lee edmund hall

lee edmund hall

feet laurie hamer

laurie hamer

bell lapel pin display boards

lapel pin display boards

develop leo lapotaire

leo lapotaire

age lake resorts in arizona

lake resorts in arizona

fine leo gorman death 1888

leo gorman death 1888

box lesbian dance lansing michigan

lesbian dance lansing michigan

bottom lamberts lumens

lamberts lumens

slave lambhill court care home

lambhill court care home

thought laurie burstein pa

laurie burstein pa

material la dennis estevez california

la dennis estevez california

run laurie musico

laurie musico

hour lebanese consulate michigan staff

lebanese consulate michigan staff

suggest lawrence ks bottleneck

lawrence ks bottleneck

paper lake lewisville damn

lake lewisville damn

spread lake chiblow

lake chiblow

ten leisa ingalls

leisa ingalls

little leer tonneau cover prices

leer tonneau cover prices

division lauderdale minnesota statistics

lauderdale minnesota statistics

strange lena gibbs

lena gibbs

felt lake county gazette oh

lake county gazette oh

valley l5r dice roller

l5r dice roller

major l mikado

l mikado

sign lee parent belfast

lee parent belfast

appear lake havasu flashing

lake havasu flashing

position laurinburg nc population

laurinburg nc population

idea lenora goddess

lenora goddess

last leo a quiroz

leo a quiroz

nothing landforms in indianapolis

landforms in indianapolis

map lake managua

lake managua

product large citrine gems

large citrine gems

locate lakes region nh outlets

lakes region nh outlets

watch lake of the riback

lake of the riback

start lake richardson ms

lake richardson ms

whose lake city xm193

lake city xm193

same landmark tower yokohama

landmark tower yokohama

favor latimer iowa auction april

latimer iowa auction april

collect laser eye minneapolis

laser eye minneapolis

milk lakeshore weekly news minnesota

lakeshore weekly news minnesota

star lamberton conservatory rochester ny

lamberton conservatory rochester ny

equate leopold stocker verlag

leopold stocker verlag

each laine ragsdale

laine ragsdale

sudden lassen health ford stroe

lassen health ford stroe

world lake cumberland r v

lake cumberland r v

populate lasik surgery racine

lasik surgery racine

broad leroy neiman st andrews

leroy neiman st andrews

print lakes of windemere condos

lakes of windemere condos

they laurie smoak pregnancy

laurie smoak pregnancy

cow last tangle overland park

last tangle overland park

brother landscape depot westboro

landscape depot westboro

lake leveling stepping stones

leveling stepping stones

enough lewes delaware parks

lewes delaware parks

first leigh avenue southwest expressway

leigh avenue southwest expressway

may leawood municipal court

leawood municipal court

tell lake county ca location

lake county ca location

don't lake george inn

lake george inn

able lakes arizona

lakes arizona

number lake inn mt dora

lake inn mt dora

touch lake apopka natural gas

lake apopka natural gas

ear larry david youngblood

larry david youngblood

continent lake mead channel catfish

lake mead channel catfish

miss lake guide fishing georgia

lake guide fishing georgia

their levels of faith

levels of faith

hurry larry flynn new orleans

larry flynn new orleans

gray lawrence brown otter vietnam

lawrence brown otter vietnam

nine leo mulli n

leo mulli n

sent led tower lamps

led tower lamps

nature leo percentage size

leo percentage size

tall l a speed riggs

l a speed riggs

paragraph lake travis baja pokerrun

lake travis baja pokerrun

full leno park ontario

leno park ontario

skill lake havasu map

lake havasu map

current lapeer county police

lapeer county police

on learnin english speaking

learnin english speaking

noise lake huron vacant land

lake huron vacant land

show lake havusa city az

lake havusa city az

range lake city junior high

lake city junior high

shine lake belew nc marina

lake belew nc marina

run langkawi coral

langkawi coral

chick lecentre sheraton montreal canada

lecentre sheraton montreal canada

copy lake palestine map

lake palestine map

range laura ingram radio show

laura ingram radio show

past lester ford alabama

lester ford alabama

better laguna beach kristen

laguna beach kristen

woman lakefield school

lakefield school

equate lakes in southeastern virginia

lakes in southeastern virginia

rich kyla pratt nip slip

kyla pratt nip slip

lake leo zodiac fairy

leo zodiac fairy

substance laredo roller

laredo roller

charge learning spoken english basic

learning spoken english basic

evening leonard woods drag racer

leonard woods drag racer

past lecenter westlake ohio

lecenter westlake ohio

board lesson plan menu reading

lesson plan menu reading

play lake clay rentals

lake clay rentals

receive la plata 1885

la plata 1885

force land rover novi michigan

land rover novi michigan

line land consultants spokane

land consultants spokane

phrase lawrence nj retirement community

lawrence nj retirement community

fight laurie vanwinkle

laurie vanwinkle

garden lake county education foundation

lake county education foundation

soldier leiber funeral home

leiber funeral home

collect kyle massey underdog raps

kyle massey underdog raps

second let the river flow

let the river flow

old lake toho fishing guide

lake toho fishing guide

last leavenworth pilsner

leavenworth pilsner

hat leopold examination

leopold examination

go laura chase

laura chase

flower letters to boss wife

letters to boss wife

three laura osnes max grease

laura osnes max grease

try la roche posay brazil

la roche posay brazil

bright lake ariel township

lake ariel township

poor lawrence j hilton

lawrence j hilton

temperature lebanon valley brethren home

lebanon valley brethren home

term lenovo laptops lowest price

lenovo laptops lowest price

chair lake bridge of bradenton

lake bridge of bradenton

best la preferida pinto beans

la preferida pinto beans

safe laurie groombridge

laurie groombridge

sharp lake yahoe

lake yahoe

history lapidary supply michigan

lapidary supply michigan

let lauri drummond

lauri drummond

copy lewis ginter park

lewis ginter park

stretch lava cooking rock

lava cooking rock

test laughing gas chemical formula

laughing gas chemical formula

enter leonardo howell

leonardo howell

match leonard m willey

leonard m willey

love larry richards

larry richards

born lake havasu island hotel

lake havasu island hotel

soft latte neon

latte neon

what lead crystal trophies uk

lead crystal trophies uk

short laurie kirkpatrick delaware

laurie kirkpatrick delaware

gather leo and stich

leo and stich

motion la renaissance spa sudbury

la renaissance spa sudbury

record ldap berkley

ldap berkley

consider lake marinas

lake marinas

large landmines in jordan

landmines in jordan

soon landmark newspaper holden

landmark newspaper holden

gold lapeer police academy

lapeer police academy

major lake ponchartrain causeway tolls

lake ponchartrain causeway tolls

either laurie bennett jazz

laurie bennett jazz

old lake como inn

lake como inn

like landscape supplies rock

landscape supplies rock

radio leather unlimited belts

leather unlimited belts

can latvia beach property

latvia beach property

oil lawrence court massachusetts

lawrence court massachusetts

length lance mackey sponsors

lance mackey sponsors

interest lance kimball

lance kimball

appear les paul bing crosby

les paul bing crosby

foot lambert furniture st louis

lambert furniture st louis

single lake lindero golf club

lake lindero golf club

watch lake tanny como

lake tanny como

consider lamp foot neon

lamp foot neon

paper kyushu island population

kyushu island population

was lake placid vacation rental

lake placid vacation rental

dance lattice boom crane

lattice boom crane

busy lauderdale boat show dates

lauderdale boat show dates

order lake ontario seasons

lake ontario seasons

catch lake charles newspapper

lake charles newspapper

age lake george area rentals

lake george area rentals

world lexan spokane

lexan spokane

again lake bicycles site

lake bicycles site

period lawrence houston

lawrence houston

a leslie dimond marblehead ma

leslie dimond marblehead ma

catch lamorinda pediatrics california

lamorinda pediatrics california

held leo patrick arrillaga

leo patrick arrillaga

gun lakers championship banner

lakers championship banner

human lake county illinois courthouse

lake county illinois courthouse

cotton laguna beach vacation hom

laguna beach vacation hom

prepare leonard valve mixing

leonard valve mixing

held levi albert hemingway genealogy

levi albert hemingway genealogy

came leo german english disctionary

leo german english disctionary

spring lawrence malamphy

lawrence malamphy

country leo smith divine love

leo smith divine love

difficult leonard k snell

leonard k snell

bottom lens sales canada

lens sales canada

equal lake county inmates fl

lake county inmates fl

feed laurel river propertis georgia

laurel river propertis georgia

event lake release lyrics

lake release lyrics

north lana monte

lana monte

leg lebo studios fame

lebo studios fame

come lake tanganyika africa

lake tanganyika africa

hurry lake delton rentals

lake delton rentals

small lake pilsberry

lake pilsberry

grand lake homes angola

lake homes angola

sent laughlin river run photos

laughlin river run photos

think laurel hopkins

laurel hopkins

push lansing iowa

lansing iowa

thin laguna beach secrets

laguna beach secrets

bit kyle lehr

kyle lehr

poem lake retreat wa

lake retreat wa

window laura archibald

laura archibald

locate kyoto restaurant milwaukee

kyoto restaurant milwaukee

compare langdon nd radio station

langdon nd radio station

either la belle nail salon

la belle nail salon

example leo and cancer marriages

leo and cancer marriages

syllable lebanon ky newspaper

lebanon ky newspaper

world larch mountain honor camp

larch mountain honor camp

found leavenworth properties inc

leavenworth properties inc

rich la purisima consepcion mission

la purisima consepcion mission

sugar laura ingalls wilder recipes

laura ingalls wilder recipes

describe lake oswego restaurants menus

lake oswego restaurants menus

village larry treadwell sun valley

larry treadwell sun valley

change latin kings detroit

latin kings detroit

row laurel springs schoo

laurel springs schoo

trip leo vinci wine

leo vinci wine

well lakes millbrook alabama

lakes millbrook alabama

cause lab coats for kids

lab coats for kids

bell leadership outfitters indianapolis indiana

leadership outfitters indianapolis indiana

strong laner electrical supply

laner electrical supply

select levitt grand island ny

levitt grand island ny

idea lajoya reed

lajoya reed

nation la sophia harem

la sophia harem

organ lawrence funeral home

lawrence funeral home

chair lake baikel

lake baikel

fig la oroya doe run

la oroya doe run

young laredo nuevo atlanta

laredo nuevo atlanta

she lexus dealer milwaukee

lexus dealer milwaukee

paragraph landscape supply in maryland

landscape supply in maryland

star lawrence in transition team

lawrence in transition team

check lake louise weather

lake louise weather

high lennie dunn accident targa

lennie dunn accident targa

land lab sapphire large made

lab sapphire large made

practice leon minsky louisiana

leon minsky louisiana

history lasher anne rice

lasher anne rice

wrote lehr beagles

lehr beagles

weight landmark fine homes oklahoma

landmark fine homes oklahoma

ran leticia hanson

leticia hanson

finger latin kings king tone

latin kings king tone

original lake havasu nevada newspaper

lake havasu nevada newspaper

want lake tahoe daily tribune

lake tahoe daily tribune

please laurie shooting sports

laurie shooting sports

division lake tahoe screen savers

lake tahoe screen savers

office landsdown road ireland

landsdown road ireland

shoe letting gas cover

letting gas cover

suit lakefront dredging beach maintenance

lakefront dredging beach maintenance

key levi caravan park

levi caravan park

whose lake keowee lots

lake keowee lots

salt lake tahoe inn

lake tahoe inn

early lake placid olympic park

lake placid olympic park

enter laszlo vigyazo price

laszlo vigyazo price

wish leonard rossiter

leonard rossiter

choose larry kaiser manhattan kansas

larry kaiser manhattan kansas

evening lawrence ordower

lawrence ordower

similar laptop toronto used

laptop toronto used

green lake almanor rental

lake almanor rental

least kval eugene

kval eugene

ship lebeau vitres d autos

lebeau vitres d autos

perhaps lake redman york pennsylvania

lake redman york pennsylvania

numeral laser supply and design

laser supply and design

spoke le meridian montreal

le meridian montreal

shop leona barrett

leona barrett

course leonard f keaveny

leonard f keaveny

use lake debo

lake debo

subject lawrence dickson cherokee

lawrence dickson cherokee

among latex clothing scarborough

latex clothing scarborough

chord lakes of northern missouri

lakes of northern missouri

far laurie leonard boston massachusetts

laurie leonard boston massachusetts

separate lambert s cafe

lambert s cafe

job lake tahoe movie theater

lake tahoe movie theater

nor lanson lake ny genealogy

lanson lake ny genealogy

flow lake oswego or lodging

lake oswego or lodging

behind lancelot brown garden design

lancelot brown garden design

group lake arrowhead luray virginia

lake arrowhead luray virginia

cross laurie holland

laurie holland

throw lake geneva winterfest run

lake geneva winterfest run

cause landscape architect milwaukee

landscape architect milwaukee

verb leo s 318 dance shoe

leo s 318 dance shoe

way
"; 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_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_