Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: How can I limit number of comments to be displayed with big picture  (Read 4226 times)

0 Members and 1 Guest are viewing this topic.

bimages

  • Coppermine newbie
  • Offline Offline
  • Posts: 5

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....
« Last Edit: July 16, 2005, 01:02:58 pm by GauGau »
Logged

Nibbler

  • Guest
Re: How can I limit number of comments to be displayed with big picture
« Reply #1 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");
Logged

bimages

  • Coppermine newbie
  • Offline Offline
  • Posts: 5
Re: How can I limit number of comments to be displayed with big picture
« Reply #2 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.
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 20 queries.