forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: zom on January 25, 2004, 12:36:43 pm

Title: diferent questions
Post by: zom on January 25, 2004, 12:36:43 pm

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


 :)

Title: Re: diferent questions
Post by: Joachim Müller on January 25, 2004, 02:42:54 pm

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

Quote from: "zom"

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?

Quote from: "zom"

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

Title: diferent questions
Post by: zom on January 26, 2004, 08:22:25 am

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 ? :)

Title: diferent questions
Post by: Joachim Müller on January 26, 2004, 09:52:37 am

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

Title: diferent questions
Post by: Nibbler on January 26, 2004, 09:03:48 pm

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

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



with:

Code: [Select]


$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.