I have made a small improvment, so the representative picture of a category will be updated each time a sub-category AND the main category is browsed.

Tested with phpwebgallery 1.4.1.

1°) First: remove the first modification posted here, if you don't know how, just use the defaut (unmodified) ./include/category_subcats.inc.php file

2°) Then: modify the ./include/category_subcats.inc.php file as follow:

SEARCH AND ADD AFTER:
if (mysql_num_rows($result) > 0)
{
  $template->assign_block_vars('thumbnails', array());
  // first line
  $template->assign_block_vars('thumbnails.line', array());
  // current row displayed
  $row_number = 0;

THIS CODE:
  // VBR Randomize the representative picture for categories with nb of images > 0
  $get_all_cat = '
  SELECT id, nb_images
  FROM '.CATEGORIES_TABLE.'
  WHERE id_uppercat ';  
  $get_all_cat_res = pwg_query($get_all_cat);

  while ($get_all_cat_res_row = mysql_fetch_array($get_all_cat_res))
  {
    if ($get_all_cat_res_row['nb_images'] > 0) 
    {
      //Get the new reprentative picture of the category
      $get_new_representative_pic_id = '
      SELECT id
      FROM '.IMAGES_TABLE.'
      WHERE storage_category_id = '.$get_all_cat_res_row['id'].'
      ORDER BY RAND()
      LIMIT 0,1';
      $new_representative_pic_id = pwg_query($get_new_representative_pic_id);
      $data_row = mysql_fetch_array($new_representative_pic_id);

      //Save the new representative picture category into the database
      $update = '
      UPDATE '.CATEGORIES_TABLE.' set representative_picture_id = '.$data_row['id'].' 
      WHERE id = '.$get_all_cat_res_row['id'];      
      $res_update= pwg_query($update);
    }
  }
  // VBR End of modification for randomizing the representative picture of the categorie

Now you will always have a random picture displayed for all categories/sub-categories...

Note: This modification can be a problem if your website has a lot of categories/sub-categories AND a lot of visits, due to updates made on the database

Enjoy it :)

Any comments are welcomed ;)

z0rglub wrote:

vbrille wrote:

Any comments are welcomed ;)

Why not make a real MOD ?

Yeh! A real MOD.


Comments:
Just an idea, what do you think about doing a test before the update to reduce them as much as possible (to be faster and reduce concurent update access on the db).
I don't know exactly how but saving a new representative picture should be done only time to time, do you agree?

"Guest users" and "odd seconds"
or
"Admin" and "User's name containg..."
or
"special users set with a specific option"
or
any idea

Here is the version 1.0.2 of this phpwebgallery modification.

##############################################################
## Author Notes:
##
##    ### English ###
##
##    This MOD permits to get on the fly a random representative picture for a category or a sub category each time
##    a user is browsing the main category or a sub category.
##
##    If you haven't modifiy the file category_subcats.inc.php, you can just replace the
##    file ./include/category_subcats.inc.php of your phpwebgallery website by the one included
##    in the './Modified category_subcats.inc.php/' directory of this package.   
##
##    You can also find the original (unmodified) file in the directory './Original category_subcats.inc.php file/'.
##
##############################################################
## MOD History:
##
##   2005-07-24 - version 1.0.2
##    - Fix to get the representative picture on the fly, no more updates onto the database :)
##
##   2005-07-23 - Version 1.0.1
##      - Fix the mod to get a random representative picture also while browsing a main category
##
##   2005-07-10 - Version 1.0.0
##      - Initial Release
##
##############################################################


You can get it there: http://vincent.brille.free.fr/pwg_MOD_r … icture.rar

As usual, any comments are welcomed :)

Hello Yann,

I've found something wrong, if a category doesn't have any image... (this could occur if you create a new directory without synchronizing images)
I've made the correction and tested also with virtual category, it seems to be ok now...

You can get the last version 1.0.3 of this MOD here: http://vincent.brille.free.fr/pwg_MOD_r … icture.rar

Can you tell me if it's ok for you now ?

Thank you :)

Gooood!
and nice gallery ;)

Thank you,
Vincent

Salut,

Si tu as fais un mauvaise manip et si tu n'as jamais modifié le fichier category_subcats.inc.php le plus simple est de copier directement le fichier modifié contenu dans le repertoire './Modified category_subcats.inc.php/'.

La modification va chercher une image au pif contenu dans le repertoire (dans la categorie) en question.

Tiens moi au courant...
A+
Vincent