source: extensions/ThumbnailTooltip/include/class.inc.php

<?php

class Thumbnail_Tooltip_IMG {
  var $plugin_name, $plugin_path, $plugin_url;
  var $my_config;

  function __construct($plugin_name, $plugin_path, $plugin_url) {
    $this->plugin_name = $plugin_name;
    $this->plugin_path = $plugin_path;
    $this->plugin_url = $plugin_url;
    $this->initialize_event_handler($plugin_name, $plugin_path, $plugin_url);
  }

  function initialize_event_handler() {
    add_event_handler('loc_end_index_thumbnails', array($this, 'thumbnail_tooltip_affich'), 50, 2);
    add_event_handler('loc_end_index_category_thumbnails', array($this, 'Author_Description_affich'), 50, 2);
  }

  function thumbnail_tooltip_affich($tpl_var) {
    global $user;

        $query = 'SELECT param, value, comment FROM ' . CONFIG_TABLE . ' WHERE param="thumbnail_tooltip"';
        $row = pwg_db_fetch_assoc( pwg_query($query) );

        $params = unserialize($row['value']);
        $values = array(
                  'DISPLAY_NAME'         => $params['display_name'],
                  'value1'               => $params['value1'],
                  'value2'               => $params['value2'],
                  'value3'               => $params['value3'],
                  'value4'               => $params['value4'],
                  'value5'               => $params['value5'],
                  'value6'               => $params['value6'],
                  'separator'            => $params['separator']
        );
        
        foreach($tpl_var as $cle=>$valeur) {
          if ($params['display_name']==true) {
        $query = "
                  SELECT name, hit, comment, author, rating_score, CONCAT(width, 'x', height) AS dimensions, filesize FROM ".IMAGES_TABLE."
                  WHERE id = ".(int)$tpl_var[$cle]['id']."
                ;";
            $row = pwg_db_fetch_assoc( pwg_query($query) );

        $details = array();
        $details_param = array();

        $details['tn_type1'] = str_replace('"', '\"', strip_tags($row['name']));

        if (!empty($row['hit'])) {
                  $details['tn_type2'] = $row['hit'].' '.strtolower(l10n('Visits'));
                  $details['tn_type3'] = '('.$row['hit'].' '.strtolower(l10n('Visits')).')';
              if (!empty($row['rating_score'])) { $type8 = ', '.strtolower(l10n('Rating score')).' '.$row['rating_score']; } else { $type8 = ''; }
                  $details['tn_type8'] = '('.$row['hit'].' '.strtolower(l10n('Visits')).$type8.')';
        }

        if (!empty($row['comment'])) {
                  $details['tn_type4'] = str_replace('"', '\"', strip_tags($row['comment']));
        }

        if (!empty($row['author'])) {
                  $details['tn_type5'] = $row['author'];
        }

        if (!empty($row['author'])) {
                  $details['tn_type6'] = (preg_match('#(,|\/)#i', $row['author'])) ? str_replace(array('(',')'), '', ucfirst(l10n('author(s) : %s', $row['author']))) : l10n('Author').' : '.$row['author'];
        }

        if (!empty($row['rating_score'])) {
                  $details['tn_type7'] = strtolower(l10n('Rating score')).' '.$row['rating_score'];
        }

        if (!empty($row['dimensions'])) {
                  $details['tn_type9'] = l10n('Dimensions').' : '.$row['dimensions'];
        }

                if (!empty($row['filesize'])) {
                  if (($params['separator']=='1') && (!empty($details['tn_type9']))) { $details['tn_type9'].= ' - '; } elseif (($params['separator']!='1') && (!empty($details['tn_type9']))) { $details['tn_type9'].= ' '; } else { $details['tn_type9'] = ' '; } 
                  $details['tn_type9'].= l10n('Filesize').' : '.l10n('%d Kb', $row['filesize']); 
                }

        if ((!empty($details[$values['value1']])) && ($details[$values['value1']]!='none')) { $details_param[] = $details[$values['value1']]; }
        if ((!empty($details[$values['value2']])) && ($details[$values['value2']]!='none')) { $details_param[] = $details[$values['value2']]; }
        if ((!empty($details[$values['value3']])) && ($details[$values['value3']]!='none')) { $details_param[] = $details[$values['value3']]; }
        if ((!empty($details[$values['value4']])) && ($details[$values['value4']]!='none')) { $details_param[] = $details[$values['value4']]; }
        if ((!empty($details[$values['value5']])) && ($details[$values['value5']]!='none')) { $details_param[] = $details[$values['value5']]; }
        if ((!empty($details[$values['value6']])) && ($details[$values['value6']]!='none')) { $details_param[] = $details[$values['value6']]; }  

        if ($params['separator']=='1') { $title = implode(' - ', $details_param); } else { $title = implode(' ', $details_param); }

        $tpl_var[$cle]['TN_TITLE'] = $title;
      }
          else {
            $tpl_var[$cle]['TN_TITLE'] = null;
          }
    }
    return $tpl_var;
  }


  function Author_Description_affich($tpl_var) {
    global $user, $lang;

        $query = 'SELECT param, value, comment FROM ' . CONFIG_TABLE . ' WHERE param="thumbnail_tooltip";';
        $row = pwg_db_fetch_assoc( pwg_query($query) );

    $params = unserialize($row['value']);
        $values = array('DISPLAY_AUTHOR_CAT' => $params['display_author_cat']);

        if ($params['display_author_cat']==true) {
      foreach($tpl_var as $cle=>$valeur) {
        $query = "SELECT author FROM ".IMAGE_CATEGORY_TABLE." INNER JOIN ".IMAGES_TABLE." ON image_id = id WHERE category_id = ".(int)$tpl_var[$cle]['id']." AND author<>'' GROUP BY author";
            $result = pwg_query($query);
            $row = pwg_db_fetch_assoc($result); 

                $auteur = '';

            if (!empty($row['author'])) {
                  do {
                    $auteur .= $row['author'].', ';
                  } while ($row = pwg_db_fetch_assoc($result));

                  $auteur = substr($auteur, 0, -2);
              if (preg_match('#(,|\/)#i', $auteur )) { $auteur = str_replace(array('(',')'), '', ucfirst(sprintf($lang['author(s) : %s'], $auteur))); } else { $auteur = $lang['Author'].' : '.$auteur ; }
              if (!empty($tpl_var[$cle]['DESCRIPTION'])) { $tpl_var[$cle]['DESCRIPTION'] = $tpl_var[$cle]['DESCRIPTION'].'<br/>'.$auteur; } else { $tpl_var[$cle]['DESCRIPTION'] = $auteur; }
            }
      }
    }
    return $tpl_var;
  }
}

?>