Coppermine Photo Gallery

Your online photo album

Home

Login
Album list

Last uploads

Last comments

Most viewed

Top rated

My Favorites

Search

Home > Royal Palm Estates > clean_up_042107

Return to the thumbnail page

FILE 133/444

Return to start

See previous file

See next file

Skip to end

Debug Info

Debug Output: show / hide USER: ------------------ Array ( [ID] => d1aa73a383c08adaec1a7be6f2078ace [am] => 1 [liv] => Array ( [0] => 961 [1] => 7782 [2] => 2692 [3] => 968 [4] => 2580 ) ) ========================== USER DATA: ------------------ Array ( [user_id] => 0 [user_name] => Guest [groups] => Array ( [0] => 3 ) [group_quota] => 0 [can_rate_pictures] => 0 [can_send_ecards] => 0 [can_post_comments] => 0 [can_upload_pictures] => 0 [can_create_albums] => 0 [pub_upl_need_approval] => 0 [priv_upl_need_approval] => 0 [access_level] => 3 [disk_max] => 0 [disk_min] => 0 [has_admin_access] => 0 [group_name] => Guests [can_create_public_albums] => 0 [can_see_all_albums] => 0 [group_id] => 3 [allowed_albums] => Array ( ) ) ========================== Queries: ------------------ Array ( [0] => SELECT name, value FROM pics_config [include/init.inc.php:177] (0.33 ms) [1] => SELECT * FROM pics_plugins ORDER BY priority [include/plugin_api.inc.php:48] (0.21 ms) [2] => SELECT user_id, time FROM `photodb`.pics_sessions WHERE session_id = 'faff767f0ecfa9569e015239d33f8427' [bridge/coppermine.inc.php:241] (0.2 ms) [3] => SELECT MAX(group_quota) AS disk_max, MIN(group_quota) AS disk_min, MAX(can_rate_pictures) AS can_rate_pictures, MAX(can_send_ecards) AS can_send_ecards, MAX(can_post_comments) AS can_post_comments, MAX(can_upload_pictures) AS can_upload_pictures, MAX(can_create_albums) AS can_create_albums, MAX(has_admin_access) AS has_admin_access, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM pics_usergroups WHERE group_id in (3) [bridge/udb_base.inc.php:357] (0.24 ms) [4] => SELECT group_name FROM pics_usergroups WHERE group_id= 3 [bridge/udb_base.inc.php:362] (0.16 ms) [5] => SELECT COUNT() FROM pics_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.16 ms) [6] => SELECT aid FROM pics_albums WHERE moderator_group IN (3) [include/init.inc.php:271] (0.19 ms) [7] => SELECT lang_id FROM pics_languages WHERE enabled='YES' [include/init.inc.php:334] (0.24 ms) [8] => DELETE FROM pics_banned WHERE expiry < '2025-04-20 19:44:54' [include/init.inc.php:448] (0.15 ms) [9] => SELECT null FROM pics_banned WHERE ('18.119.11.206' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:464] (0.17 ms) [10] => SELECT aid FROM pics_albums WHERE (1 AND visibility != 0 AND visibility != 10000 AND visibility NOT IN (3)) [include/functions.inc.php:1107] (0.36 ms) [11] => SELECT rgt, lft, depth FROM pics_categories WHERE cid = 17 LIMIT 1 [include/functions.inc.php:44] (0.19 ms) [12] => SELECT cid FROM pics_categories WHERE lft BETWEEN 29 AND 30 [include/functions.inc.php:49] (0.2 ms) [13] => SELECT keyword FROM pics_albums WHERE category IN (17) [include/functions.inc.php:57] (0.28 ms) [14] => SELECT hits FROM pics_pictures WHERE pid = 2580 [include/functions.inc.php:2310] (0.17 ms) [15] => SELECT COUNT() FROM pics_pictures AS p INNER JOIN pics_albums AS r ON r.aid = p.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND (hits > 33 OR hits = 33 AND pid < 2580) [include/functions.inc.php:2321] (3.55 ms) [16] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.83 ms) [17] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title, r.keywords, r.votes, pic_rating, hits, caption, r.owner_id FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 132 ,1 [include/functions.inc.php:1731] (5.58 ms) [18] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.84 ms) [19] => SELECT r.pid FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 131 ,1 [include/functions.inc.php:1731] (3.1 ms) [20] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.8 ms) [21] => SELECT r.pid FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 133 ,1 [include/functions.inc.php:1731] (3.1 ms) [22] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.81 ms) [23] => SELECT r.pid FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 0 ,1 [include/functions.inc.php:1731] (3.04 ms) [24] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.81 ms) [25] => SELECT r.pid FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits ASC, pid DESC LIMIT 0 ,1 [include/functions.inc.php:1731] (3.02 ms) [26] => SELECT title, comments, votes, category, aid FROM pics_albums WHERE aid='82' LIMIT 1 [displayimage.php:420] (0.2 ms) [27] => SELECT p.cid, p.name FROM pics_categories AS c, pics_categories AS p WHERE c.lft BETWEEN p.lft AND p.rgt AND c.cid = 17 ORDER BY p.lft [include/functions.inc.php:2940] (0.27 ms) [28] => UPDATE pics_pictures SET hits = hits + 1, lasthit_ip = '18.119.11.206', mtime = CURRENT_TIMESTAMP WHERE pid = 2580 [include/functions.inc.php:2839] (0.26 ms) [29] => SELECT extension, mime, content, player FROM pics_filetypes [include/functions.inc.php:5949] (0.28 ms) [30] => SELECT user_name as user_name FROM `photodb`.pics_users WHERE user_id = '1' [bridge/udb_base.inc.php:59] (0.17 ms) [31] => SELECT COUNT(msg_id) FROM pics_comments WHERE pid='2580' [include/themes.inc.php:3757] (0.16 ms) [32] => SELECT COUNT() FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 [include/functions.inc.php:1714] (2.79 ms) [33] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title FROM pics_pictures AS r INNER JOIN pics_albums AS a ON a.aid = r.aid INNER JOIN pics_categories AS c2 ON c2.cid = category WHERE (c2.lft BETWEEN 29 AND 30) AND r.aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) AND approved = 'YES' AND hits > 0 ORDER BY hits DESC, pid ASC LIMIT 132 ,1 [include/functions.inc.php:1731] (3.5 ms) ) ========================== GET : ------------------ Array ( [album] => topn [cat] => 17 [pid] => 2580 ) ========================== POST : ------------------ Array ( ) ========================== COOKIE : ------------------ Array ( [cpg143_data] => YTozOntzOjI6IklEIjtzOjMyOiJkMWFhNzNhMzgzYzA4YWRhZWMxYTdiZTZmMjA3OGFjZSI7czoyOiJhbSI7aToxO3M6MzoibGl2IjthOjU6e2k6MDtzOjQ6IjQ4MTciO2k6MTtzOjM6Ijk2MSI7aToyO3M6NDoiNzc4MiI7aTozO3M6NDoiMjY5MiI7aTo0O3M6MzoiOTY4Ijt9fQ== [c25b1c558c4647a3a4e6d4a029f3535c] => bf30ce7fe6625de132d4e40a353eaed2 ) ==========================