Highest Rated Pal SEO Link Wrong

[LissaE]

I've just noticed on my newest gallery that the link in the highest rated pal is wrong...it's missing the category name between the // and so leading to page not found errors. This is when SEO links are activated, the link works fine when I turn it off...and all the other linkages on the page are fine lol

Gallery Home - A Moment In Scrap Gallery

Where would I look to try and fix this? To note...the undercat section of the gallery has been customised but the highest rating pal template hasn't been touched in any way

Using Photopost Pro 7.01 integrated with vBulletin 3.8.4

[Chuck S]

This line in pp-inc.php in the get_ratingcache function make sure it is this. The variable should be $popcat not $cat

Content visible to verified customers only.

[LissaE]

You are da bomb Chuck LOL thanx so much! That took care of it

[LissaE]

Now that that's sorted, I have another question for you lol

The one image it's showing in the highest rated pal hasn't actually been rated so it's showing 0.0 ... it has 2 comments on it though so I am guessing that's why it's showing as the top.

There are a few others that actually have been rated but they only have one comment and they aren't showing at all...is there a way to have the highest rated pal show the photos that actually have ratings, even if it's only one?

Otherwise the pal should be called Most Commented and show the comment count instead LOL

[Chuck S]

yes the ratings pal is based rating then number of comments descending.

[LissaE]

lolis there any way I can change that then? It looks a bit silly showing only a photo that has no rating lol

[Chuck S]

well you would have to change your code to suit your needs in the ratingcache function in pp-inc.php

[LissaE]

Hmm...I'll have a look lol and see what I can do...and hopefully not kill the gallery LOL thanx

[LissaE]

K so the easy part was having it display rated photos regardless of post count...what in the following would I need to remove/change to have it not show photos with no ratings?

Content visible to verified customers only.

I'm thinking it has something to do with vcount?
Thanx Chuck

[Chuck S]

How about maybe changing this

Content visible to verified customers only.

to maybe

Content visible to verified customers only.

[LissaE]

Perfect! Thanx so much Chuck...have a wonderful day

[Chuck S]

You too.

[LissaE]

Hi Chuck, since the upgrade this entire section has changed and nothing displays in the Highest Rated Pal, how can I change that in this code?

function get_ratingcache( $cat = 0, $ppuser = 0 )
{
global $Globals, $pplang, $link, $cache;

$catquery = null;
if ( $cat == 500 && $ppuser > 0 )
{
// We want to see all their images
$catquery = "userid=$ppuser";
}
elseif ( $cat > 0 )
{
$catname = $CatPerms['catname'][$cat];
$cattype = $CatPerms['cattype'][$cat];
$catchildren = $CatPerms['children'][$cat];

$catquery = $cat;
if ( $catchildren )
{
$catquery .= ",$catchildren";
}

$catquery = "cat IN ($catquery)";
}
else
{
$catquery = "cat=500";
}

$catquery = " WHERE $catquery $userq";

// Lets get the Most Popular Photos
$queryz = ppmysql_query("SELECT numcom,rating,cat,id,title FROM {$Globals['pp_db_prefix']}photos $catquery ORDER BY rating DESC LIMIT {$Globals['mostpoppal']}", $link);

$tpfound = 1;

while ( list(, $avgrate, $cat, $popid, $poptitle, $popviews ) = mysql_fetch_row($queryz) )
{
$tmptitle = ( strlen($poptitle) > 20 ? substr($poptitle,0,20)."..." : $poptitle );
$tmptitle = htmlspecialchars( $tmptitle );
$poptitle = htmlspecialchars( $poptitle );

$cache['popular']['views'][$tpfound] = number_format($popviews,1);
$avgrate = number_format( $avgrate, 2 );

$tmpurl = construct_newppurl( "showphoto.php", array( 'photo' => $popid ) );
$cache['popular']['link'][$tpfound] = "<a href=\"$tmpurl\" title=\"$poptitle\">&raquo; $tmptitle</a>";


$tpfound++;
}

return;
}

[Chuck S]

You would need to make sure you have uploaded ALL the new files and templates as everything has changed in the program.

[LissaE]

I have, the upgrade was completed nicely, just there is nothing showing in the Highest Rated box and there are rated photos and photos with comments.

In previous posts in this thread you gave me help on how to show the most rated photos rather than the most commented photos, but the section of code the change was made in has changed and I don't know what to change there now to get anything to show lol

[Chuck S]

A community photo gallery - PhotoPost Photo Gallery

well I know the highest rated works in the default code if everything is uploaded. You might need to actually turn off your category cache to dump that.

Basically all the most popular photos does is gets photos out of the photos table based on highest rating to low and shows them.

[LissaE]

Not sure why it shows nothing then as I overwrote all the files. I don't like the way it looks in the demo now that I can see it so I have just disabled it LOL

I have another question though, in the Top Posters Pal there are two blank cells at the bottom, this also shows on your demo. Can I remove them?

topposters.jpg

[Chuck S]

I am not really sure I see nothing in the code that should be printing out an extra row and if I run the query in phpmyadmin I only get x number of results.

I will see what I can find.

[LissaE]

Could have sworn I replied to this lol thanx Chuck....did you have a chance to look into this yet?

[Chuck S]

I have no resolution yet no.