I can't get my album list to work here is my debug:
USER:
------------------
Array
(
[ID] => 2fdb78ac0c928ccd77f89becaf99d8a2
[am] => 1
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[1] => 1
[user_group] => 1
[2] => YES
[user_active] => YES
[3] => admin
[user_name] => admin
[4] => 8235
[user_password] => ********
[5] => 2004-05-27 22:12:24
[user_lastvisit] => 2004-05-27 22:12:24
[6] => 2004-05-16 22:07:44
[user_regdate] => 2004-05-16 22:07:44
[7] =>
[user_lang] =>
[8] =>
[user_email] =>
[9] =>
[user_website] =>
[10] =>
[user_location] =>
[11] =>
[user_interests] =>
[12] =>
[user_occupation] =>
[13] =>
[user_actkey] =>
[14] => 1
[group_id] => 1
[15] => Administrators
[group_name] => Administrators
[16] => 0
[group_quota] => 0
[17] => 1
[has_admin_access] => 1
[18] => 1
[can_rate_pictures] => 1
[19] => 1
[can_send_ecards] => 1
[20] => 1
[can_post_comments] => 1
[21] => 1
[can_upload_pictures] => 1
[22] => 1
[can_create_albums] => 1
[23] => 0
[pub_upl_need_approval] => 0
[24] => 0
[priv_upl_need_approval] => 0
[25] => 3
[upload_form_config] => 3
[26] => 0
[custom_user_upload] => 0
[27] => 5
[num_file_upload] => 5
[28] => 3
[num_URI_upload] => 3
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg130_filetypes;
[1] => SELECT * FROM cpg130_users, cpg130_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '9f9a2e9ab3dc74b58ef7c5b974807751'
[2] => DELETE FROM cpg130_banned WHERE expiry < 1085721348
[3] => SELECT * FROM cpg130_banned WHERE ip_addr='68.124.46.100' OR ip_addr='68.124.46.100' OR user_id=1
[4] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '' ORDER BY pos
[5] => SELECT aid FROM cpg130_albums WHERE category >= 10000
[6] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category >= 10000
[7] => SELECT thumb FROM cpg130_categories WHERE cid = '1' LIMIT 1
[8] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p,cpg130_albums AS a WHERE p.aid = a.aid AND a.category > 10000 AND approved='YES' ORDER BY RAND()
[9] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '1' ORDER BY pos
[10] => SELECT aid FROM cpg130_albums WHERE category = 23
[11] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 23
[12] => SELECT thumb FROM cpg130_categories WHERE cid = 23
[13] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 23 ORDER BY RAND()
[14] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '23' ORDER BY pos
[15] => SELECT aid FROM cpg130_albums WHERE category = 24
[16] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 24
[17] => SELECT thumb FROM cpg130_categories WHERE cid = 24
[18] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 24 ORDER BY RAND()
[19] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '24' ORDER BY pos
[20] => SELECT aid FROM cpg130_albums WHERE category = 25
[21] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 25
[22] => SELECT thumb FROM cpg130_categories WHERE cid = 25
[23] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 25 ORDER BY RAND()
[24] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '25' ORDER BY pos
[25] => SELECT aid FROM cpg130_albums WHERE category = 26
[26] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 26
[27] => SELECT thumb FROM cpg130_categories WHERE cid = 26
[28] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 26 ORDER BY RAND()
[29] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '26' ORDER BY pos
[30] => SELECT aid FROM cpg130_albums WHERE category = 27
[31] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 27
[32] => SELECT thumb FROM cpg130_categories WHERE cid = 27
[33] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 27 ORDER BY RAND()
[34] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '27' ORDER BY pos
[35] => SELECT aid FROM cpg130_albums WHERE category = 28
[36] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 28
[37] => SELECT thumb FROM cpg130_categories WHERE cid = 28
[38] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 28 ORDER BY RAND()
[39] => SELECT count(*) FROM cpg130_albums WHERE category = '28'
[40] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg130_albums as a LEFT JOIN cpg130_pictures as p ON thumb=pid WHERE category = '28' ORDER BY pos LIMIT 0,1
[41] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg130_pictures WHERE aid IN (3) AND approved = 'YES' GROUP BY aid
[42] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '28' ORDER BY pos
[43] => SELECT aid FROM cpg130_albums WHERE category = 29
[44] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 29
[45] => SELECT thumb FROM cpg130_categories WHERE cid = 29
[46] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 29 ORDER BY RAND()
[47] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '29' ORDER BY pos
[48] => SELECT aid FROM cpg130_albums WHERE category = 30
[49] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 30
[50] => SELECT thumb FROM cpg130_categories WHERE cid = 30
[51] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 30 ORDER BY RAND()
[52] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '30' ORDER BY pos
[53] => SELECT aid FROM cpg130_albums WHERE category = 31
[54] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 31
[55] => SELECT thumb FROM cpg130_categories WHERE cid = 31
[56] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 31 ORDER BY RAND()
[57] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '31' ORDER BY pos
[58] => SELECT aid FROM cpg130_albums WHERE category = 32
[59] => SELECT count(*) FROM cpg130_pictures, cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND category = 32
[60] => SELECT thumb FROM cpg130_categories WHERE cid = 32
[61] => SELECT pid, filepath, filename, url_prefix FROM cpg130_pictures AS p, cpg130_albums AS a WHERE p.aid = a.aid AND approved='YES' AND a.category = 32 ORDER BY RAND()
[62] => SELECT cid, name, description, thumb FROM cpg130_categories WHERE parent = '32' ORDER BY pos
[63] => SELECT count(*) FROM cpg130_albums WHERE 1
[64] => SELECT count(*) FROM cpg130_pictures WHERE 1
[65] => SELECT count(*) FROM cpg130_comments WHERE 1
[66] => SELECT count(*) FROM cpg130_categories WHERE 1
[67] => SELECT sum(hits) FROM cpg130_pictures WHERE 1
[68] => SELECT count(*) FROM cpg130_albums WHERE category = ''
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.3 - OK
------------------
mySQL version: 4.0.18-standard
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.15 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 7
Active Links 8
Client API version 4.0.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/maderaam:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.097 seconds - 69 queries in 0.011 seconds - Album set :