diferent questions

[zom]

1/ How to limit to a certain number the comments displayed under an image? for exemple the last 10.

2/ How to reinit to 0 all the count of stats (images most seen ...)

3/ I would like to insert by frame in my home (html page) some top 5 images what should contain the page called by the sript ?

thanks


 

[Joachim Müller]

Next time: only one question per thread! :evil:

2/ How to reinit to 0 all the count of stats (images most seen ...)

log in as admin, admin mode, choose a category, click "edit pics" next to the album thumbnail: notice the "Reset view counter" thingy?

3/ I would like to insert by frame in my home (html page) some top 5 images what should contain the page called by the sript ?

take a look at http://forum.coppermine-gallery.net/index.php?topic=625

GauGau

[zom]

thanks gaugau I'm sorry for asking 3 questions in the same subject.
I was ignorant about the rule 1 question per subject.


for

1/ How to limit to a certain number the comments displayed under an image? for exemple the last 10 ?

is there a way ?

[Joachim Müller]

out-of-the-box: no (and I don't know of a hack which could do this). If you need it, you'll have to code it.

GauGau

[Nibbler]

If you open displayimage.php line 308-ish and replace:

Code Select Expand


$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");



with:

Code Select Expand


$result_prelim = 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");
$numrows = (max(mysql_num_rows($result_prelim) - 10,0));
$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 " .$numrows. ",10");


Change the 10 in both places to however many comments you want to display.

That will give what you want, but it's a bit of mess, there must be a better way.