Bevenhall Photo Gallery

Array
(
    [ID] => 543d1ac63abd509f2db7f112a099eb9d
    [am] => 1
)

Array
(
    [0] => 3
    [group_id] => 3
    [1] => Anonymous
    [group_name] => Anonymous
    [2] => 0
    [group_quota] => 0
    [3] => 0
    [has_admin_access] => 0
    [4] => 1
    [can_rate_pictures] => 1
    [5] => 0
    [can_send_ecards] => 0
    [6] => 0
    [can_post_comments] => 0
    [7] => 0
    [can_upload_pictures] => 0
    [8] => 0
    [can_create_albums] => 0
    [9] => 1
    [pub_upl_need_approval] => 1
    [10] => 1
    [priv_upl_need_approval] => 1
)

Array
(
    [0] => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='0' AND user_active = 'YES' AND user_password != ''  AND BINARY MD5(user_password) = '*'
    [1] => SELECT * FROM cpg11d_usergroups WHERE group_id = 3
    [2] => DELETE FROM cpg11d_banned WHERE expiry = 0
    [3] => SELECT * FROM cpg11d_banned WHERE ip_addr='3.17.150.163' OR ip_addr='3.17.150.163' OR user_id=0
    [4] => SELECT aid FROM cpg11d_albums WHERE visibility != '0' AND visibility !='0' AND visibility NOT IN (3)
    [5] => SELECT user_name FROM cpg11d_users WHERE user_id = '1'
    [6] => SELECT cid, name, parent FROM cpg11d_categories WHERE cid = '1'
    [7] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
    [8] => SELECT aid FROM cpg11d_albums WHERE category >= 0
    [9] => SELECT count(*) FROM cpg11d_albums WHERE 1 AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17) 
    [10] => SELECT count(*) FROM cpg11d_pictures WHERE 1 AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17) 
    [11] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1 AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17) 
    [12] => SELECT count(*) FROM cpg11d_albums WHERE category = '1'
    [13] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES' AND aid NOT IN (1,5,15) AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17) 
    [14] => SELECT pid, filename, url_prefix, filesize, pwidth, pheight, ctime, aid FROM cpg11d_pictures WHERE approved = 'YES' AND aid NOT IN (1,5,15) AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17)  ORDER BY RAND() LIMIT 12
    [15] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES' AND aid NOT IN (1,5,15) AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17) 
    [16] => SELECT pid, filename, url_prefix, filesize, pwidth, pheight, ctime, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES' AND aid NOT IN (1,5,15) AND aid IN (1,2,3,4,5,9,6,7,10,11,12,13,14,15,16,17)  ORDER BY pid DESC  LIMIT 0 ,12
)