KIA Photo Gallery
Home
::
Login
Album list
::
Last uploads
::
Last comments
::
Most viewed
::
Top rated
::
My Favorites
::
Search
Home
>
User galleries
karateinstitute
1 album(s)
2 file(s)
1 users on 1 page(s)
Debug Info
Select All
USER: ------------------ Array ( [ID] => 1747a487e7931480ebdd5dc559de3fa2 [am] => 1 [lang] => english ) ========================== USER DATA: ------------------ Array ( [user_id] => 0 [user_name] => Guest [groups] => Array ( [0] => 3 ) [group_quota] => 0 [can_rate_pictures] => 1 [can_send_ecards] => 0 [can_post_comments] => 0 [can_upload_pictures] => 0 [can_create_albums] => 0 [pub_upl_need_approval] => 1 [priv_upl_need_approval] => 1 [upload_form_config] => 0 [num_file_upload] => 1 [num_URI_upload] => 0 [custom_user_upload] => 0 [disk_max] => 0 [disk_min] => 0 [ufc_max] => 0 [ufc_min] => 0 [has_admin_access] => 0 [group_name] => Guests [can_see_all_albums] => 0 [group_id] => 3 ) ========================== Queries: ------------------ Array ( [0] => SELECT extension, mime, content, player FROM cpg_filetypes; (0s) [1] => select * from cpg_plugins order by priority asc; (0s) [2] => delete from `kiadm_copp1`.cpg_sessions where time<1283984124 and remember=0; (0s) [3] => delete from `kiadm_copp1`.cpg_sessions where time<1282778124; (0s) [4] => select user_id from `kiadm_copp1`.cpg_sessions where session_id = 'a0b0ac4c85dc194ff87fb8dfe5633f28' (0s) [5] => select user_id as id, user_password as password from `kiadm_copp1`.cpg_users where user_id=0 (0s) [6] => 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(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, 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, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (3) (0s) [7] => SELECT group_name FROM cpg_usergroups WHERE group_id= 3 (0s) [8] => update `kiadm_copp1`.cpg_sessions set time='1283987724' where session_id = 'a0b0ac4c85dc194ff87fb8dfe5633f28' (0s) [9] => DELETE FROM cpg_banned WHERE expiry < '2010-09-08 18:15:24' (0s) [10] => SELECT * FROM cpg_banned WHERE (ip_addr='38.107.191.94' OR ip_addr='38.107.191.94' OR user_id=0) AND brute_force=0 (0s) [11] => SELECT aid FROM cpg_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (3) (0s) [12] => SELECT aid FROM cpg_albums as a WHERE category>=10000 (0s) [13] => SELECT cid FROM cpg_categories WHERE parent = '1' (0s) [14] => SELECT name, parent FROM cpg_categories WHERE cid = '1' (0s) [15] => SELECT cid, name, description, thumb FROM cpg_categories WHERE parent = '1' ORDER BY pos (0s) [16] => SELECT aid FROM cpg_albums as a WHERE category >= 10000 (0s) [17] => select null from cpg_albums as p INNER JOIN cpg_pictures AS pics ON pics.aid = p.aid where ( category>10000 ) group by category; (0.012s) [18] => SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `kiadm_copp1`.cpg_users as u on u.user_id = a.category - 10000 INNER JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000) GROUP BY user_id ORDER BY category LIMIT 0, 12 (0.02s) [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg_pictures WHERE pid='1599' AND approved='YES' (0s) [20] => SELECT count(*) FROM cpg_albums as a WHERE category = '1' (0s) ) ========================== GET : ------------------ Array ( [cat] => 1 ) ========================== POST : ------------------ Array ( ) ========================== Page generated in 0.085 seconds - 21 queries in 0.032 seconds - Album set : AND aid IN (25) ; Meta set: AND aid IN (25) ;