Random Images Pal - certain galleries only

[aacircle]

Hello,

Does anyone know how I can select only certain galleries only to being displayed in the Random Images Pal?

Thank you.

[Chuck S]

Hello

There is not specific functionality within photopost to do this secifically so it comes down to modifying your code. if you want to do this.

We do offer a modification forum if you wish to discuss specific modifications to the Photopost code here

http://www.photopost.com/forum/photopost-pro-mod-discussions/

Now if your confortable editing code you can edit your pp-inc.php file find your top_menu function and edit the specific queries adding something like this to the queries

AND cat NOT IN (501,502,504)

Now it would say look like this in the queries when you hack things and of course replace with your direct category numbers you do not wish.

It would look like this as an example

Content visible to verified customers only.

[aacircle]

Thanks for your reply Chuck. Just tried adding:

Content visible to verified customers only.

but without luck.

Am not sure what you meant I was to do with the function topmenu(). I didn't make any changes to this function.

I am assuming though, even if a usergroup doesn't have access to a certain gallery, they can still see it in the random images pal.

[Chuck S]

In the topmenu function as long as your editing the proper query for random you should be fine and you can also use

AND cat = 613

Other than that I dont know how else I can assist in your code modification question there buddy. That would definately work to pull images only from car 613.

[aacircle]

There are no queries in the topmenu function. I think you meant to say the display_gallery function.

[Chuck S]

yes display_gallery

[aacircle]

Ok, will try again in the morning using:

AND cat != 613

Thanks.

[Chuck S]

Okay enjoy let me know how it works out.

[aacircle]

All done and thanks a million Chuck for your help. The reason it wasn't showing immediately was because I had:

Minutes to cache index page data for featured photos, statistics and PALs?

set at 10 minutes.

Thanks again! Much appreciated.

[Chuck S]

have a great weekend

[aacircle]

Hi Chuck,

I upgraded to 6.1 on the weekend and like the new release very much. Thanks for that.

I have though received about 150 email alerts stating:

MySQL error: "SELECT * FROM pp_photos WHERE cat IN (576,Array) ORDER BY date DESC LIMIT 50."

The code I have edited in pp-inc.php is bolded below:

default:
if ( !$cat && !$showuser && !$catquery )
{
if ( $updatecache || empty($cacheq['randomcache']) )
{
$group_title = "{$Globals['pp_lang']['random']}";
$query = "SELECT id,user,userid,cat,storecat,title,ismature,bigimage,height,width, id*0+RAND() as rand_col FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND cat IN (627,628,629,575,576,577) AND storecat=0 ORDER BY rand_col DESC LIMIT $grabnum";

Category 576 does exist. So do you know why I'm getting this SQL error?

Thanks again.
Cheers.

[Chuck S]

Your external.php file try making sure the lines noted here are exactly as I type here replace what you have.

Content visible to verified customers only.

[aacircle]

Thanks Chuck for your fast reply. Have made the changes. Appreciate your pin-point accuracy.

Cheers.

[Chuck S]

Not a problem glad to help.