<?php
/*
Plugin Name: Plugin Personnel
Version: 1.0
Description: Plugin Personnel
Plugin URI: http://www.phpwebgallery.net
Author:
Author URI:
*/

function personal_get_random_image()
{
   global $page, $template;
   
   if (isset($page['section']) and $page['section'] == 'categories' and !isset($page['category']))
   {
      $query = '
        SELECT c.name as category, uppercats, path, file, width, height
        FROM '.IMAGES_TABLE.' AS i
        INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
        INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id
        '.get_sql_condition_FandF
        (
          array
            (
              'forbidden_categories' => 'category_id',
              'visible_categories' => 'category_id',
              'visible_images' => 'i.id'
            ),
          'WHERE'
        ).'
        AND width <> \'\' AND height <> \'\'
        ORDER BY RAND(NOW())
        LIMIT 1
      ;';

      $img = mysql_fetch_array(pwg_query($query));
      
      $template->assign_vars(array(
        'PERSONAL_RANDOM_IMAGE' => '<br>'.get_cat_display_name_cache($img['uppercats'], null, false).' / '.$img['file'].'<br><br><img src="' . $img['path'] . '" style="width:'.($img['width'] / 2).'px;height:'.($img['height'] / 2).'px;" alt="' . $img['file'] . '"><br><br>'
      ));
    }
}

?>

<?php
/*
Plugin Name: Plugin Personnel
Version: 1.0
Description: Plugin Personnel
Plugin URI: http://www.phpwebgallery.net
Author:
Author URI:
*/

add_event_handler('loc_begin_index', 'personal_get_random_image');

function personal_get_random_image()
{
   global $page, $template;
    
   if (isset($page['section']) and $page['section'] == 'categories' and !isset($page['category']))
   {
      $query = 'SELECT img.path AS path, img.file AS file
                FROM ' . IMAGE_CATEGORY_TABLE . ' AS ic
                INNER JOIN ' . IMAGES_TABLE . ' AS img
                ON ic.image_id = img.id
                WHERE ' . get_sql_condition_FandF(array ('forbidden_categories' => 'ic.category_id'), '', true) . '
                ORDER BY RAND()
                LIMIT 1;';

      $img = mysql_fetch_array(pwg_query($query));
        
      $template->assign_vars(array(
         'PERSONAL_RANDOM_IMAGE' => '<img src="' . $img['path'] . '" alt="' . $img['file'] . '">'));
    }
}

?>