Most popular photos time limit

[alzy]

is there a way to make most popular photos time sensitive. i mean making them something like "this months most popular photos" or 'this week's..."
thanks

[Chuck S]

You would need to alter the query in pp-inc.php for function display_gallery and add a time restriction to the query to only pull photos from last month or last week etc.

How many photos you trying to display

[alzy]

my recent and random photos are at 20 and i think the most popularphotos have to be the same because i cannot change the settings individually. the site is www.digitalpick.com and currently i have disabled the most popular photo feature.
the most important part of this question is how i can modify the pp-inc.php to add time function for most popular photos without affecting anything els. could you tell me how, i am not very familiar with coding or php.

[Chuck S]

well in the display_gallery function in pp-inc.php find the query for most_views and you would add something like this to the query

AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 14 DAY) )

[alzy]

i added the above code in and i get an error.
this is how i added it:
case "most_views":
if ( !isset($cat) || empty($catquery) ) {
$group_title = "{$Globals['pp_lang']['popular']}";
$query = "SELECT id,user,userid,cat,storecat,title,bigimage,views,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved='1' AND storecat='0' ORDER BY views DESC LIMIT $grabnum" AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 14 DAY) );

i get the following error:
Parse error: parse error, unexpected T_LNUMBER in ..............

thanks

[Chuck S]

Yeah where is the closing " see how you did not move that. The query has to end with ";

You put the new string in between the ";

[alzy]

thank you, i got that fixed but now i get another error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/......./pp-inc.php on line 600

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/......./pp-inc.php on line 605

this is line 600:

$numimages = mysql_num_rows( $result );

this is line 605:

while ( list($fid, $fuser, $fuserid, $thiscat, $storecat, $ftitle, $fbigimage, $fviews, $fheight, $fwidth, $) = mysql_fetch_array($result) ) {

[Chuck S]

try p.date in the query not date

[alzy]

i changed but it doesn't work.

[Chuck S]

Okay well I am just giving you ideas here we dont support code hacking. Try this as this is what I told you to do.

$query = "SELECT id,user,userid,cat,storecat,title,bigimage,views,height,width FROM {$Globals['pp_db_prefix']}photos WHERE approved='1' AND storecat='0' AND date > UNIX_TIMESTAMP( DATE_SUB(NOW(), INTERVAL 14 DAY) ) ORDER BY views DESC LIMIT $grabnum";

[alzy]

I want to thank you, that did it. Maybe you should consider adding time feature on next updates. The reason i started this is because some viewers complained that the same pictures show on the most viewed page. Now, at least it changes every so often. Once again thanks a lot.