source: extensions/Photo_add_by/initpicture.php @ 27458

<?php

//Ajout du prefiltre
add_event_handler('loc_begin_picture', 'pabI', 55 );

function pabI()
 {
        global $template;
        $template->set_prefilter('picture', 'pabIT');
 }


function pabIT($content, &$smarty)
 {
 
 global $conf;
 
  $search = '#<div id="'.$conf['Photo_add_by'].'" class="imageInfo">#';

  $replacement = '
  {if $PAB}
  <div id="pab1" class="imageInfo">
    <dt>{\'Photo added by\'|@translate}</dt>
    <dd>{$PAB}</dd>
  </div>
{/if}
<div id="'.$conf['Photo_add_by'].'" class="imageInfo">';

  return preg_replace($search, $replacement, $content);
 }

add_event_handler('loc_begin_picture', 'pab');

function pab()
{
global $conf, $page, $template;
load_language('plugin.lang', PAB_PATH);
load_language('lang', PHPWG_ROOT_PATH.PWG_LOCAL_DIR, array('no_fallback'=>true, 'local'=>true) );

  if ( !empty($page['image_id']) )   
  {
 
  $query = '
select added_by
  FROM ' . IMAGES_TABLE . '
  WHERE id = \''.$page['image_id'].'\'
  ;';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$userab=$row['added_by'];

  $query = '
select '.$conf['user_fields']['username'].' AS username
  FROM ' . USERS_TABLE . '
  WHERE '.$conf['user_fields']['id'].' = \''.$userab.'\'
  ;';
$result = pwg_query($query);
$row = pwg_db_fetch_assoc($result);
$pab=$row['username'];

$PASPBY = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'see_photos_by_user';"));
$showpab = $conf['Photo_add_by_show'];
if($showpab == 1 and $PASPBY['state'] == 'active')
{
$query2 = '
SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU, IT.id
 FROM ' . USERS_TABLE . ' as UT
 INNER JOIN '.IMAGES_TABLE.' AS IT ON IT.added_by = UT.id
 INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON IT.id = ic.image_id
  '.get_sql_condition_FandF
  (
    array
      (
        'forbidden_categories' => 'category_id',
        'visible_categories' => 'category_id',
        'visible_images' => 'id'
      ),
    'WHERE'
  ).'
 GROUP BY IT.added_by
 HAVING PBU >'.$conf['see_photos_by_user_nbphotos'].'
 ORDER BY '.$conf['see_photos_by_user_order'].'
 LIMIT '.$conf['see_photos_by_user_limit'].';';

$result2 = pwg_query($query2);

$userok = array();
while ($row2 = pwg_db_fetch_assoc($result2))
 {
  $userok[] = $row2['username'];
}
if(in_array($pab, $userok) and $showpab == 1 and $PASPBY['state'] == 'active')
{
$urlpab = get_root_url().'index.php?/user-'.($pab);
$pab2 ='<a href="'.$urlpab.'">'.$pab.'</a>';
}
else
{
$pab2=$pab;
}
}
else
{
$pab2=$pab;
}
$template->assign(array('PAB' => $pab2,));

  }
}

?>