Hello again gaugau - As I am new to this, I'm not sure which are the "relevant parts" so I hope you do not mind me posting the whole thing.
Server Details:Operating system Linux
Kernel version 2.4.20-28.9
Apache version 1.3.29 (Unix)
PERL version 5.8.0
Installed Perl Modules Click to View
PHP version 4.3.4
MySQL version 4.0.15-standard
Debug Output:USER:
Array
(
[ID] => e85eb211cab4f3e72193e6b3ce61a56c
[am] => 1
)
USER DATA:
Array
(
[user_id] => 1
[1] => 1
[user_group] => 1
[2] => YES
[user_active] => YES
[3] => maddog
[user_name] => maddog
[4] => mypassword
[5] => 2004-01-22 14:36:45
[user_lastvisit] => 2004-01-22 14:36:45
[6] => 2004-01-22 14:36:45
[user_regdate] => 2004-01-22 14:36:45
[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] => 10000
[group_quota] => 10000
[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
)
Queries:
Array
(
- => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '20d15651b3b6e1a344d6f0ecbbbfc9c1'
[1] => DELETE FROM cpg11d_banned WHERE expiry < 1075382016
[2] => SELECT * FROM cpg11d_banned WHERE ip_addr='62.13.131.108' OR ip_addr='62.13.131.108' OR user_id=1
[3] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '' ORDER BY pos
[4] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
[5] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
[6] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1' ORDER BY pos
[7] => SELECT count(*) FROM cpg11d_albums WHERE 1
[8] => SELECT count(*) FROM cpg11d_pictures WHERE 1
[9] => SELECT count(*) FROM cpg11d_comments WHERE 1
[10] => SELECT count(*) FROM cpg11d_categories WHERE 1
[11] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
[12] => SELECT count(*) FROM cpg11d_albums WHERE category = ''
[13] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[14] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8
[15] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
[16] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8
)
GET :
Array
(
)
POST :
Array
(
)
Thanks for your time and help
Regards
Colin