source: extensions/MenuRandomPhoto/main.inc.php @ 31780

<?php
/*
Plugin Name: Menu Random Photo
Version: 2.7.c
Description: Adds a random picture block into menu
Plugin URI: http://piwigo.org/ext/extension_view.php?eid=778
Author: JanisV
Fixes: romanf
*/

global $conf;

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

define('MRP_ID',    basename(dirname(__FILE__)));
define('MRP_PATH' , PHPWG_PLUGINS_PATH . MRP_ID . '/');
define('MRP_ADMIN', get_root_url() . 'admin.php?page=plugin-' . MRP_ID);

add_event_handler('init', 'MRP_init');
add_event_handler('blockmanager_register_blocks', 'MRP_register_menubar_blocks', EVENT_HANDLER_PRIORITY_NEUTRAL-1);

if (defined('IN_ADMIN'))
{
  add_event_handler('get_admin_plugin_menu_links', 'MRP_admin_menu');
}
else
{
  add_event_handler('blockmanager_apply', 'MRP_blockmanager_apply');
  add_event_handler('loc_end_page_header', 'MRP_end_page_header');
}

function MRP_init()
{
  global $conf, $user;

  load_language('plugin.lang', MRP_PATH);

  $conf['MRP'] = unserialize($conf['MRP']);
}

function MRP_register_menubar_blocks($menu_ref_arr)
{
  $menu = & $menu_ref_arr[0];
  if ($menu->get_id() != 'menubar')
    return;
  $menu->register_block( new RegisteredBlock('mbRandomPhoto', 'Menu Random Photo', 'MRP'));
}

function MRP_blockmanager_apply($menu_ref_arr)
{
  global $user, $conf;

  $menu = & $menu_ref_arr[0];
  
  if((
      ($block=$menu->get_block('mbRandomPhoto'))!=null) and
      ($user['nb_total_images']>0)
    )
  {
    $block->set_title($conf['MRP']['title']);
    $block->template=realpath(MRP_PATH.'template/menu_random_photo.tpl');
  }
}

  function MRP_end_page_header()
  {
    global $user, $template, $page, $conf;

    if(!array_key_exists('body_id', $page))
    {
      /*
       * it seems the error message reported on mantis:1476 is displayed because
       * the 'body_id' doesn't exist in the $page
       *
       * not abble to reproduce the error, but initializing the key to an empty
       * value if it doesn't exist may be a sufficient solution
       */
      $page['body_id']="";
    }

    if($page['body_id'] == 'theCategoryPage')
    {
      $randomPictProp = array(
        'delay' => $conf['MRP']['delay'],
        'blockHeight' => $conf['MRP']['height'],
//        'showname' => $this->config['amm_randompicture_showname'],
//        'showcomment' => $this->config['amm_randompicture_showcomment'],
        'pictures' => getRandomPictures($conf['MRP']['randompicture_preload']),
      );

      if (count($randomPictProp['pictures']) > 0)
      {
        $local_tpl = new Template(MRP_PATH.'/template', "");
        $local_tpl->set_filename('body_page', realpath(MRP_PATH.'/template/menu_random_photo.js.tpl'));

        $local_tpl->assign('data', $randomPictProp);

        $template->append('head_elements', $local_tpl->parse('body_page', true));
      }
    }
  }

  /**
   * return a list of thumbnails
   * each array items is an array
   *  'imageId'   => (integer)
   *  'imageFile' => (String)
   *  'comment'   => (String)
   *  'path'      => (String)
   *  'catId'     => (String)
   *  'name'      => (String)
   *  'permalink' => (String)
   *  'imageName' => (String)
   *
   * @param Integer $number : number of returned images
   * @return Array
   */
  function getRandomPictures($num=25)
  {
    global $user, $conf;

    $returned=array();

    if (preg_match('/(Googlebot|bingbot|Baiduspider|yandex|AhrefsBot|msnbot|NCollector)/', $_SERVER["HTTP_USER_AGENT"]))
    {
      return($returned);
    }

    $sql=array();

    // because ORDER BY RAND() can be very slow on a big database, let's
    // make a first query with no join and by security take 5 times
    // $num. We keep the result in session for 5 minutes.
    if (!isset($_SESSION['mrp_random_pics'])
        or !isset($_SESSION['mrp_random_pics_generated_on'])
        or $_SESSION['mrp_random_pics_generated_on'] < time() - 5*60) // 5 minutes ago
    {
      $query = '
SELECT id
  FROM '.IMAGES_TABLE.'
  WHERE level <= '.$user['level'].'
  ORDER BY RAND() LIMIT '.($num*5).'
;';
      $_SESSION['mrp_random_pics'] = query2array($query, null, 'id');
      $_SESSION['mrp_random_pics_generated_on'] = time();
    }
    
    $sql['select'] = '
SELECT
    i.id as image_id,
    i.file as image_file,
    i.comment,
    i.path,
    c.id as catid,
    c.name,
    c.permalink,
    i.name as imgname
';
    
    $sql['from'] = '
  FROM '.CATEGORIES_TABLE.' c
    JOIN '.IMAGE_CATEGORY_TABLE.' ic ON ic.category_id = c.id
    JOIN '.IMAGES_TABLE.' i ON i.id = ic.image_id
';
    
    $sql['where'] = '
  WHERE i.id IN ('.implode(',', $_SESSION['mrp_random_pics']).')
    AND i.level <= '.$user['level'].'
';

    if($user['forbidden_categories']!="")
    {
      $sql['where'].=" AND c.id NOT IN (".$user['forbidden_categories'].") ";
    }
/*
    switch($this->config['amm_randompicture_selectMode'])
    {
      case 'f':
        $sql['from'].=", ".USER_INFOS_TABLE." ui
          LEFT JOIN ".FAVORITES_TABLE." f ON ui.user_id=f.user_id ";
        $sql['where'].=" AND ui.status='webmaster'
                         AND f.image_id = i.id ";
        break;
      case 'c':
        $sql['where'].="AND (";
        foreach($this->config['amm_randompicture_selectCat'] as $key => $val)
        {
          $sql['where'].=($key==0?'':' OR ')." FIND_IN_SET($val, c.uppercats) ";
        }
        $sql['where'].=") ";
        break;
    }
*/
    $sql = $sql['select'].$sql['from'].$sql['where']." ORDER BY RAND() LIMIT $num;";

    $result = pwg_query($sql);
    if($result)
    {
      if ($conf['MRP']['square'])
      {
        $height = $conf['MRP']['height'];
        if($height == 0)
          $derivative_params = ImageStdParams::get_by_type(IMG_SQUARE);
        else
          $derivative_params = ImageStdParams::get_custom($height, $height, 1, $height, $height);
      }
      else
      {
        $derivative_params = IMG_THUMB;
      }

      while($row=pwg_db_fetch_assoc($result))
      {
        $row['section']='categories';
        $row['category']=array(
          'id' => $row['catid'],
          'name' => $row['name'],
          'permalink' => $row['permalink']
        );

        $row['link']=make_picture_url($row);
        $infos = array('id'=>$row['image_id'], 'path'=>$row['path']);
        $row['thumb']=DerivativeImage::url($derivative_params, $infos);

        $returned[]=$row;
      }
    }

    return($returned);
  }

function MRP_admin_menu($menu)
{
  $menu[] = array(
    'NAME' => 'Menu Random Photo',
    'URL'  => MRP_ADMIN,
  );

  return $menu;
}