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_up041809

Return to the thumbnail page

FILE 8/31

Return to start

See previous file

See next file

Skip to end

The mess after the clean up.

The mess after the clean up.

Debug Info

Debug Output: show / hide USER: ------------------ Array ( [ID] => f8357be5ac14421538d2d565e61e57da [am] => 1 [liv] => Array ( [0] => 1171 [1] => 6961 [2] => 689 [3] => 7385 [4] => 5845 ) ) ========================== 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.32 ms) [1] => SELECT * FROM pics_plugins ORDER BY priority [include/plugin_api.inc.php:48] (0.2 ms) [2] => SELECT user_id, time FROM `photodb`.pics_sessions WHERE session_id = '067fdb0e9c2acbec5ae2e3193c84d325' [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.17 ms) [5] => SELECT COUNT() FROM pics_categorymap WHERE group_id in (3) [bridge/udb_base.inc.php:375] (0.15 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 < '2024-05-19 12:23:37' [include/init.inc.php:448] (0.14 ms) [9] => SELECT null FROM pics_banned WHERE ('3.137.170.14' 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 title, keyword FROM pics_albums WHERE aid = 187 [include/functions.inc.php:2458] (0.18 ms) [12] => SELECT filename, title, pid, position, ctime FROM pics_pictures WHERE pid = 5845 [include/functions.inc.php:2171] (0.2 ms) [13] => SELECT COUNT() FROM pics_pictures WHERE ((aid='187' AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270)) ) AND approved='YES' AND (filename < 'dscn1007.jpg' OR filename = 'dscn1007.jpg' AND pid < 5845) [include/functions.inc.php:2195] (0.53 ms) [14] => SELECT title, keyword FROM pics_albums WHERE aid = 187 [include/functions.inc.php:2458] (0.18 ms) [15] => SELECT COUNT(*) FROM pics_pictures WHERE ((aid='187' AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) ) AND approved='YES' [include/functions.inc.php:1405] (0.3 ms) [16] => 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 WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename ASC, pid ASC LIMIT 7 ,1 [include/functions.inc.php:1436] (0.57 ms) [17] => SELECT r.pid FROM pics_pictures AS r WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename ASC, pid ASC LIMIT 6 ,1 [include/functions.inc.php:1436] (0.49 ms) [18] => SELECT r.pid FROM pics_pictures AS r WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename ASC, pid ASC LIMIT 8 ,1 [include/functions.inc.php:1436] (0.48 ms) [19] => SELECT r.pid FROM pics_pictures AS r WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename ASC, pid ASC LIMIT 0 ,1 [include/functions.inc.php:1436] (0.48 ms) [20] => SELECT r.pid FROM pics_pictures AS r WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename DESC, pid DESC LIMIT 0 ,1 [include/functions.inc.php:1436] (0.49 ms) [21] => SELECT title, comments, votes, category, aid FROM pics_albums WHERE aid='187' LIMIT 1 [displayimage.php:420] (0.2 ms) [22] => 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.28 ms) [23] => UPDATE pics_pictures SET hits = hits + 1, lasthit_ip = '3.137.170.14', mtime = CURRENT_TIMESTAMP WHERE pid = 5845 [include/functions.inc.php:2839] (0.26 ms) [24] => SELECT extension, mime, content, player FROM pics_filetypes [include/functions.inc.php:5949] (0.28 ms) [25] => SELECT user_name as user_name FROM `photodb`.pics_users WHERE user_id = '1' [bridge/udb_base.inc.php:59] (0.17 ms) [26] => SELECT COUNT(msg_id) FROM pics_comments WHERE pid='5845' [include/themes.inc.php:3757] (0.16 ms) [27] => SELECT r.pid, r.aid, filepath, filename, url_prefix, pwidth, pheight, filesize, ctime, r.title FROM pics_pictures AS r WHERE ((aid = 187 AND aid NOT IN (49, 50, 59, 62, 64, 134, 149, 186, 240, 268, 269, 270) ) )AND approved='YES' ORDER BY filename ASC, pid ASC LIMIT 7 ,1 [include/functions.inc.php:1436] (0.54 ms) [28] => SELECT null FROM pics_albums WHERE category < 10000 AND uploads='YES' AND (visibility = '0' OR visibility IN (3)) AND aid = '187' [include/themes.inc.php:2063] (0.22 ms) [29] => SELECT null FROM pics_albums WHERE category < 10000 AND uploads='YES' AND (visibility = '0' OR visibility IN (3)) AND aid = '187' [include/themes.inc.php:2063] (0.21 ms) ) ========================== GET : ------------------ Array ( [album] => 187 [pid] => 5845 ) ========================== POST : ------------------ Array ( ) ========================== COOKIE : ------------------ Array ( [c25b1c558c4647a3a4e6d4a029f3535c] => be1660eb4e42b6949e61eec455dc2abc [cpg143_data] => YTozOntzOjI6IklEIjtzOjMyOiJmODM1N2JlNWFjMTQ0MjE1MzhkMmQ1NjVlNjFlNTdkYSI7czoyOiJhbSI7aToxO3M6MzoibGl2IjthOjU6e2k6MDtzOjQ6IjIyMjgiO2k6MTtzOjQ6IjExNzEiO2k6MjtzOjQ6IjY5NjEiO2k6MztzOjM6IjY4OSI7aTo0O3M6NDoiNzM4NSI7fX0= ) ==========================