{\'Photo added by\'|@translate}

{$PAB}

'; } return preg_replace($search, $replacement, $content); } add_event_handler('loc_begin_picture', 'pab'); function pab(){ global $conf, $page, $template,$pwg_loaded_plugins; 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']; $showpab = $conf['Photo_add_by_show']; if($showpab == 1 and (isset($pwg_loaded_plugins['see_photos_by_user']))){ $query2 = 'SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU 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 (isset($pwg_loaded_plugins['see_photos_by_user']))){ $urlpab = get_root_url().'index.php?/user-'.$userab.'-'.$pab; $pab2 =''.$pab.''; }else{ $pab2=$pab; } }else{ $pab2=$pab; } $template->assign(array('PAB' => $pab2,)); } } ?>