forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: bimages on July 15, 2005, 02:01:37 pm

Title: How can I limit number of comments to be displayed with big picture
Post by: bimages on July 15, 2005, 02:01:37 pm

A number of pictures on my site have a large number of comments. I have noticed that it take toooooooo much time to display a big image if the number of comments is more than say 20. How can I limit the number of comments to be displayed with the big image.

Thanks for your help....

Title: Re: How can I limit number of comments to be displayed with big picture
Post by: Nibbler on July 15, 2005, 02:54:16 pm

Find this query in displayimage.php, and add a LIMIT and chnage the ORDER BY too if you like

Code: [Select]

$result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id ASC");

Code: [Select]

$result = db_query("SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid' ORDER BY msg_id ASC LIMIT 20");


Title: Re: How can I limit number of comments to be displayed with big picture
Post by: bimages on July 16, 2005, 07:17:23 am

Thanks a lot for your help...

Can I also place a link or an option if someone wish to read all the comments.