copy phpbb_root/*.php to *.php
copy phpbb_root/admin/*.php to admin/*.php
copy phpbb_root/album_mod/*.* to album_mod/*.*
copy phpbb_root/language/lang_english/*.php to language/lang_english/*.php
copy phpbb_root/templates/subSilver/*.* to templates/subSilver/*.*
copy phpbb_root/templates/subSilver/admin/*.* to templates/subSilver/admin/*.*
copy phpbb_root/templates/subSilver/images/*.* to templates/subSilver/images/*.*
copy phpbb_root/templates/subSilver/images/lang_english/*.* to templates/subSilver/images/lang_english/*.*

CREATE TABLE bb_album (
  pic_id int(11) UNSIGNED NOT NULL auto_increment,
  pic_filename varchar(255) NOT NULL,
  pic_thumbnail varchar(255),
  pic_title varchar(255) NOT NULL,
  pic_desc text,
  pic_user_id mediumint(8) NOT NULL,
  pic_username varchar(32),
  pic_user_ip char(8) NOT NULL DEFAULT '0',
  pic_time int(11) UNSIGNED NOT NULL,
  pic_cat_id mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
  pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
  pic_lock tinyint(3) NOT NULL DEFAULT '0',
  pic_approval tinyint(3) NOT NULL DEFAULT '1',
  PRIMARY KEY (pic_id),
  KEY pic_cat_id (pic_cat_id),
  KEY pic_user_id (pic_user_id),
  KEY pic_time (pic_time));

CREATE TABLE bb_album_rate (
  rate_pic_id int(11) UNSIGNED NOT NULL,
  rate_user_id mediumint(8) NOT NULL,
  rate_user_ip char(8) NOT NULL,
  rate_point tinyint(3) UNSIGNED NOT NULL,
  KEY rate_pic_id (rate_pic_id),
  KEY rate_user_id (rate_user_id),
  KEY rate_user_ip (rate_user_ip),
  KEY rate_point (rate_point));

CREATE TABLE bb_album_comment (
  comment_id int(11) UNSIGNED NOT NULL auto_increment,
  comment_pic_id int(11) UNSIGNED NOT NULL,
  comment_user_id mediumint(8) NOT NULL,
  comment_username varchar(32),
  comment_user_ip char(8) NOT NULL,
  comment_time int(11) UNSIGNED NOT NULL,
  comment_text TEXT,
  comment_edit_time int(11) UNSIGNED,
  comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
  comment_edit_user_id mediumint(8),
  PRIMARY KEY(comment_id),
  KEY comment_pic_id (comment_pic_id),
  KEY comment_user_id (comment_user_id),
  KEY comment_user_ip (comment_user_ip),
  KEY comment_time (comment_time));

CREATE TABLE bb_album_cat (
  cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
  cat_title varchar(255) NOT NULL,
  cat_desc text,
  cat_order mediumint(8) NOT NULL,
  cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
  cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
  cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
  cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
  cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
  cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
  cat_view_groups varchar(255),
  cat_upload_groups varchar(255),
  cat_rate_groups varchar(255),
  cat_comment_groups varchar(255),
  cat_edit_groups varchar(255),
  cat_delete_groups varchar(255),
  cat_moderator_groups varchar(255),
  cat_approval tinyint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (cat_id),
  KEY cat_order (cat_order));

CREATE TABLE bb_album_config (
  config_name varchar(255) NOT NULL,
  config_value varchar(255) NOT NULL,
  PRIMARY KEY (config_name));

INSERT INTO bb_album_config VALUES ('max_pics', '1024');
INSERT INTO bb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO bb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO bb_album_config VALUES ('max_file_size', '128000');
INSERT INTO bb_album_config VALUES ('max_width', '800');
INSERT INTO bb_album_config VALUES ('max_height', '600');
INSERT INTO bb_album_config VALUES ('rows_per_page', '3');
INSERT INTO bb_album_config VALUES ('cols_per_page', '4');
INSERT INTO bb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO bb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO bb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO bb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO bb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO bb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO bb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO bb_album_config VALUES ('png_allowed', '1');
INSERT INTO bb_album_config VALUES ('gif_allowed', '0');
INSERT INTO bb_album_config VALUES ('desc_length', '512');
INSERT INTO bb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO bb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO bb_album_config VALUES ('personal_gallery', '0');
INSERT INTO bb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO bb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO bb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO bb_album_config VALUES ('rate', '1');
INSERT INTO bb_album_config VALUES ('rate_scale', '10');
INSERT INTO bb_album_config VALUES ('comment', '1');
INSERT INTO bb_album_config VALUES ('gd_version', '2');
INSERT INTO bb_album_config VALUES ('album_version', '.0.54');

INSERT INTO bb_album_config VALUES ('watermark_images', 0);
INSERT INTO bb_album_config VALUES ('watermark_source', '');

Create folders:
album_mod/upload
album_mod/upload/cache

CHMOD 777 (with your FTP-client)
album_mod/upload
album_mod/upload/cache

require('config.'. PHP_EXT);

// Album MOD
include($phpbb_root_path . 'album_mod/album_constants.' . $phpEx);

  'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

  // Album MOD
  'L_ALBUM' => $lang['Album'],
  'U_ALBUM' => append_sid('album.'.$phpEx),

<a href="{U_INDEX}"><b>{L_HOME}</b></a>·

<a href="{U_ALBUM}" title="{L_ALBUM}" />{L_ALBUM}</a>·

$images['icon_mod']            = $_main .'icon_mod.gif';

// Album MOD
$images['upload_pic']          = $_lang .'upload_pic.gif';
$images['no_thumbnail']        = $_main .'nothumbnail.jpg';

  'U_SEARCH_USER' => append_sid("search.$phpEx?search_author=" . $u_search_author),

 // Photo Album Addon v2.x.x by Smartor
  'U_PERSONAL_GALLERY' => append_sid("album_personal.$phpEx?user_id=" . $profiledata['user_id']),
  'L_PERSONAL_GALLERY' => sprintf($lang['Personal_Gallery_Of_User'], $profiledata['username']),

<p class="med"><a href="{U_SEARCH_USER}" class="med">{L_SEARCH_USER_POSTS}</a></p>

<p class="med"><a href="{U_PERSONAL_GALLERY}" class="genmed">{L_PERSONAL_GALLERY}</a></p>

//
// Photo Album Addon v2.x.x by Smartor
//
$lang['Album'] = 'Фотоальбом';
$lang['Personal_Gallery_Of_User'] = 'Персональная галерея пользователя %s';

//
// Photo Album Addon v2.x.x by Smartor
//
$lang['Photo_Album'] = 'Фотоальбом';
$lang['Categories'] = 'Категории';
$lang['Clear_Cache'] = 'Очистить кэш';
$lang['Personal_Galleries'] = 'Персональные галереи';

'L_PICS' => $lang['Pics'],

// <!-- BEGIN Last Pic On Personal Imdex -->
   'L_LAST_PIC' => $lang['Last_Pic'],
#   'L_LAST_PIC_THUMB' => $lang['Last_Index_Thumbnail'],
// <!-- END Last Pic On Personal Imdex -->

while( $row = $db->sql_fetchrow($result) )
{
   $memberrow[] = $row;
}

// <!-- BEGIN Last Pic On Personal Imdex -->
// check whter we are running an album with CLowN's SP mod..
// and correct album picture url
if (defined('ALBUM_SP_CONFIG_TABLE'))
{
   $album_pic_url = 'album_showpage.'.$phpEx;
}
else
{
   $album_pic_url = 'album_page'.$phpEx;
}
// <!-- END Last Pic On Personal Imdex -->

#
#-----[ FIND ]----------------------------------------------------------------
#

for ($i = 0; $i < count($memberrow); $i++)
{

#
#-----[ AFTER, ADD ]----------------------------------------------------------
#

// <!-- BEGIN Last Pic On Personal Imdex -->
   $users_last_pic_title = '';
   $users_last_pic_time = '';
   $users_last_pic_info = '';

   if (!isset($album_config['last_pic_title_length']))
   {
      $album_config['last_pic_title_length'] = 20;
   }

   If ( $memberrow[$i]['last_pic'] )
   {
      $sql = "SELECT pic_title, pic_time
            FROM " . ALBUM_TABLE . " WHERE pic_id = '".$memberrow[$i]['last_pic']."'
               AND pic_approval = 1
            ORDER BY pic_time DESC
            LIMIT 1";
      if ( !($query_result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain last pic infos', '', __LINE__, __FILE__, $sql);
      }
      $result = $db->sql_query($sql);

      while ($row = $db->sql_fetchrow($result))
      {
         $users_last_pic_title = $row['pic_title'];
         $users_last_pic_time = $row['pic_time'];
      }

      $show_pic_url = ($album_config['fullpic_popup']==0) ? $album_pic_url : 'album_pic.' . $phpEx;
      $show_pic_target = ($album_config['fullpic_popup']==0) ? '_self' : '_blank';

      $users_last_pic = '<a href="'.$show_pic_url.'?pic_id='.$memberrow[$i]['last_pic'].'" class="postlink" target="'.$show_pic_target.'"><img src="album_thumbnail.php?pic_id='.$memberrow[$i]['last_pic'].'" alt="'.$users_last_pic_title.'" title="'.$users_last_pic_title.'" border="0" /></a>';

      $users_last_pic_title = (strlen($users_last_pic_title) > $album_config['last_pic_title_length']) ? substr($users_last_pic_title, 0, $album_config['last_pic_title_length']) . '...' : $users_last_pic_title;

      $users_last_pic_info = '<a href="'.$show_pic_url.'?pic_id='.$memberrow[$i]['last_pic'].'" alt="'.$users_last_pic_title.'" title="'.$users_last_pic_title.'" class="postlink" target="'.$show_pic_target.'">'.$users_last_pic_title.'</a>';
   }
   else
   {
      $users_last_album_pic = $lang['No_Pics'];
#      $users_last_pic_info = $lang['No_Pics'];
   }
// <!-- END Last Pic On Personal Imdex -->

'JOINED' => create_date($lang['DATE_FORMAT'], $memberrow[$i]['user_regdate'], $board_config['board_timezone']),

// <!-- BEGIN Last Pic On Personal Imdex -->
      'LAST_PIC' => $users_last_pic,
      'LAST_PIC_INFO' => $users_last_pic_info,
      'LAST_PIC_TIME' => create_date($board_config['default_dateformat'], $users_last_pic_time, $board_config['board_timezone']),
// <!-- END Last Pic On Personal Imdex -->

 <th class="thCornerR" nowrap="nowrap">&nbsp;{L_PICS}&nbsp;</th>

 <th class="thTop" nowrap="nowrap">&nbsp;{L_PICS}&nbsp;</th>
     <th class="thCornerR" nowrap="nowrap">&nbsp;{L_LAST_PIC}&nbsp;</th>

  <td class="{memberrow.ROW_CLASS}" align="center"><span class="gensmall">{memberrow.PICS}</span></td>

 <td class="{memberrow.ROW_CLASS}" align="center"><span class="gensmall">{memberrow.LAST_PIC}<br />{memberrow.LAST_PIC_INFO}<br />({memberrow.LAST_PIC_TIME})</span></td>

  <td class="catBottom" colspan="3"

3

4

/*
+----------------------------------------------------------
| Recent Public Pics

/*
+----------------------------------------------------------
| Highest Rated Pics
| by MarkFulton.com
+----------------------------------------------------------
*/

if ($allowed_cat != '')
{
   $sql = "SELECT p.pic_id, p.pic_title, p.pic_desc, p.pic_user_id, p.pic_user_ip, p.pic_username, p.pic_time, p.pic_cat_id, p.pic_view_count, u.user_id, u.username, r.rate_pic_id, AVG(r.rate_point) AS rating, COUNT(DISTINCT c.comment_id) AS comments
         FROM ". ALBUM_TABLE ." AS p
            LEFT JOIN ". USERS_TABLE ." AS u ON p.pic_user_id = u.user_id
            LEFT JOIN ". ALBUM_CAT_TABLE ." AS ct ON p.pic_cat_id = ct.cat_id
            LEFT JOIN ". ALBUM_RATE_TABLE ." AS r ON p.pic_id = r.rate_pic_id
            LEFT JOIN ". ALBUM_COMMENT_TABLE ." AS c ON p.pic_id = c.comment_pic_id
         WHERE p.pic_cat_id IN ($allowed_cat) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )
         GROUP BY p.pic_id
         ORDER BY rating DESC
         LIMIT ". $album_config['cols_per_page'];
   if( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not query highest rated pics information', '', __LINE__, __FILE__, $sql);
   }

   $highestrow = array();

   while( $row = $db->sql_fetchrow($result) )
   {
      $highestrow[] = $row;
   }

   if (count($highestrow) > 0)
   {
      for ($i = 0; $i < count($highestrow); $i += $album_config['cols_per_page'])
      {
         $template->assign_block_vars('highest_pics', array());

         for ($j = $i; $j < ($i + $album_config['cols_per_page']); $j++)
         {
            if( $j >= count($highestrow) )
            {
               break;
            }

            if(!$highestrow[$j]['rating'])
            {
               $highestrow[$j]['rating'] = $lang['Not_rated'];
            }
            else
            {
               $highestrow[$j]['rating'] = round($highestrow[$j]['rating'], 2);
            }

            $template->assign_block_vars('highest_pics.highest_col', array(
               'U_PIC' => ($album_config['fullpic_popup']) ? append_sid("album_pic.$phpEx?pic_id=". $highestrow[$j]['pic_id']) : append_sid("album_page.$phpEx?pic_id=". $highestrow[$j]['pic_id']),
               'THUMBNAIL' => append_sid("album_thumbnail.$phpEx?pic_id=". $highestrow[$j]['pic_id']),
               'DESC' => $highestrow[$j]['pic_desc']
               )
            );

            if( ($highestrow[$j]['user_id'] == ALBUM_GUEST) or ($highestrow[$j]['username'] == '') )
            {
               $highest_poster = ($highestrow[$j]['pic_username'] == '') ? $lang['Guest'] : $highestrow[$j]['pic_username'];
            }
            else
            {
               $highest_poster = '<a href="'. append_sid("profile.$phpEx?mode=viewprofile&amp;". POST_USERS_URL .'='. $highestrow[$j]['user_id']) .'">'. $highestrow[$j]['username'] .'</a>';
            }

            $template->assign_block_vars('highest_pics.highest_detail', array(
               'H_TITLE' => $highestrow[$j]['pic_title'],
               'H_POSTER' => $highest_poster,
               'H_TIME' => create_date($board_config['default_dateformat'], $highestrow[$j]['pic_time'], $board_config['board_timezone']),

               'H_VIEW' => $highestrow[$j]['pic_view_count'],

               'H_RATING' => ($album_config['rate'] == 1) ? ( '<a href="'. append_sid("album_rate.$phpEx?pic_id=". $highestrow[$j]['pic_id']) . '">' . $lang['Rating'] . '</a>: ' . $highestrow[$j]['rating'] . '<br />') : '',

               'H_COMMENTS' => ($album_config['comment'] == 1) ? ( '<a href="'. append_sid("album_comment.$phpEx?pic_id=". $highestrow[$j]['pic_id']) . '">' . $lang['Comments'] . '</a>: ' . $highestrow[$j]['comments'] . '<br />') : '',

               'H_IP' => ($userdata['user_level'] == ADMIN) ? $lang['IP_Address'] . ': <a href="http://www.nic.com/cgi-bin/whois.cgi?query=' . decode_ip($highestrow[$j]['pic_user_ip']) . '" target="_blank">' . decode_ip($highestrow[$j]['pic_user_ip']) .'</a><br />' : ''
               )
            );
         }
      }
   }
   else
   {
      //
      // No Pics Found
      //
      $template->assign_block_vars('no_pics', array());
   }
}
else
{
   //
   // No Cats Found
   //
   $template->assign_block_vars('no_pics', array());
}

  <!-- END recent_pics -->
</table>

<p />

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
  <tr>
   <th height="25" colspan="{S_COLS}" nowrap="nowrap">Фото с высоким рейтингом</th>
  </tr>
  <!-- BEGIN no_pics -->
  <tr>
   <td class="row1" align="center" colspan="{S_COLS}" height="50"><span class="gen">{L_NO_PICS}</span></td>
  </tr>
  <!-- END no_pics -->
  <!-- BEGIN highest_pics -->
  <tr>
  <!-- BEGIN highest_col -->
   <td class="row1" width="{S_COL_WIDTH}" align="center"><a href="{highest_pics.highest_col.U_PIC}" {TARGET_BLANK}><img src="{highest_pics.highest_col.THUMBNAIL}" border="0" alt="{highest_pics.highest_col.DESC}" title="{highest_pics.highest_col.DESC}" vspace="10" /></a></td>
  <!-- END highest_col -->
  </tr>
  <tr>
  <!-- BEGIN highest_detail -->
    <td class="row2"><span class="gensmall">{L_PIC_TITLE}: {highest_pics.highest_detail.H_TITLE}<br />
     {L_POSTER}: {highest_pics.highest_detail.H_POSTER}<br />{L_POSTED}: {highest_pics.highest_detail.H_TIME}<br />
     {L_VIEW}: {highest_pics.highest_detail.H_VIEW}<br />{highest_pics.highest_detail.H_RATING}{highest_pics.highest_detail.H_COMMENTS}{highest_pics.highest_detail.H_IP}</span>
   </td>
  <!-- END highest_detail -->
  </tr>
  <!-- END highest_pics -->
</table>

//
// Generate page

//Pictures: hack by DENZO
   $query = "SELECT pic_username FROM " . ALBUM_TABLE . " WHERE pic_username='".$profiledata['username']."'";
   $query_result = @$db->sql_query($query);
   $pictures = 0;
   $pictures = $db->sql_numrows($query_result);
   $pics = '<span class="gen">Total pictures: </span></td>
<td><b><span class="gen">'.$pictures.'</b></td>
</tr>
<td align="right" nowrap="nowrap"><span class="gen">';
$lang['LOCATION'] = $pics.$lang['LOCATION'];
//Pictures: hack by DENZO

//active leechers begin

//
// BEGIN: Fetch Recent album comments
//
$recent_comment = '';
$template->assign_block_vars('recent_comment', array());   

   $sql = "SELECT *
         FROM `bb_album_comment`
         ORDER BY `comment_id` DESC LIMIT 10";
         
   if ( !($result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, "Could not obtain information needed.", "", __LINE__, __FILE__, $sql);
   }

   while( $row = $db->sql_fetchrow($result) )
   {
         $recent_comment .= '
         <a href="album_comment.php?comment_id=' . $row['comment_id'] .'">'. $row['comment_text'] . '</a><hr>
         
      ';               
   }
   
   $template->assign_vars(array(
         'RECENT_COMMENT_NAME' => $lang['Recently Submited Comments'],
         'RECENT_COMMENT' => $recent_comment
   ));
   
//
// END: Fetch Recent album comments
//

<?php if (!empty($bb_cfg['sidebar1_static_content_path'])) include($bb_cfg['sidebar1_static_content_path']); ?>

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
<tr>
<td class="catHead" height="25"><span><b>{RECENT_COMMENT_NAME}</b></span></td>
</tr>
<tr>
<td class="row1" align="left"><span class="gensmall">
<!-- BEGIN recent_comment -->
{RECENT_COMMENT}
<!-- END recent_comment -->
</span></td>
</tr>
</table>
<br />

// Recently Submited album comments
$lang['Recently Submited Comments'] = 'Новые Комментарии';

// Allow cron
if (IS_ADMIN || IS_MOD)

// Album stats block
      // Last Pic Data
      $sql = "SELECT pic_id, pic_title, pic_time, pic_desc, pic_username, pic_user_id FROM " . ALBUM_TABLE . "
         WHERE pic_approval = 1
         AND pic_lock = 0 # Don't show if picture locked
         ORDER BY pic_time DESC
         LIMIT 1";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain last pic data', '', __LINE__, __FILE__, $sql);
      }
      $row = $db->sql_fetchrow($result);
      $db->sql_freeresult($result);

      $last_pic_id = $row['pic_id'];
      $last_pic_title = '<a href="album_showpage.php?pic_id='.$last_pic_id.'">'.$row['pic_title'].'</a>';
      $last_pic = '<a href="album_comment.php?pic_id='.$last_pic_id.'"><img src="album_thumbnail.php?pic_id='.$last_pic_id.'" alt="'.$row['pic_desc'].'" title="'.$row['pic_desc'].'"></a>';
      $last_pic_time = $row['pic_time'];
      $last_pic_poster = '<a href="profile.php?mode=viewprofile&u='.$row['pic_user_id'].'">'.$row['pic_username'].'</a>';
      $last_pic_poster_id = $row['pic_user_id'];

      // Total Pics and Views
      $sql = "SELECT count(*) AS total_pics, SUM(pic_view_count) AS total_view FROM " . ALBUM_TABLE . "
         WHERE pic_approval = 1";
      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain image count ', '', __LINE__, __FILE__, $sql);
      }
      $row = $db->sql_fetchrow($result);
      $db->sql_freeresult($result);

      $TotalImages = $row['total_pics'];
      $pic_view_count = $row['total_view'];

      // Total Ratings
      $sql = "SELECT count(*) AS total_rates, SUM(rate_point) AS rate_points FROM " . ALBUM_RATE_TABLE;
      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain image rating count ', '', __LINE__, __FILE__, $sql);
      }
      $row = $db->sql_fetchrow($result);
      $db->sql_freeresult($result);

      $total_rates = $row['total_rates'];
      $rate_points = $row['rate_points'];

      // Total Comments
      $sql = "SELECT count(*) AS total_comments FROM " . ALBUM_COMMENT_TABLE;
      if( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, 'Could not obtain image comment count ', '', __LINE__, __FILE__, $sql);
      }
      $row = $db->sql_fetchrow($result);
      $db->sql_freeresult($result);

      $total_comments = $row['total_comments'];

      $template->assign_vars(array(
         'ALBUM_STATS' => $lang['Title_album-stats'],
         'TOTAL_IMAGES' => sprintf($lang['total_pics'], $TotalImages),
         'TOTAL_PICVIEW' => sprintf($lang['viewed'], $pic_view_count),
         'TOTAL_RATES' => sprintf($lang['votes'], $total_rates),
         'TOTAL_RATEPOINT' => sprintf($lang['vote_points'], $rate_points),
         'TOTAL_COMMENTS' => sprintf($lang['comments'], $total_comments),
         'LAST_PIC' => $last_pic,
         'LAST_PIC_ID' => $last_pic_id,
         'LAST_PIC_TITLE' => sprintf($lang['newest_pic'], $last_pic_title),
         'LAST_PIC_POSTER' => sprintf($lang['posted_by'], $last_pic_poster),
         'LAST_PIC_TIME' => sprintf($lang['posted_at'], (create_date($lang['DATE_FORMAT'], $last_pic_time, $bb_cfg['board_timezone'])))
      ));
// Album stats block

<?php if (!empty($bb_cfg['sidebar1_static_content_path'])) include($bb_cfg['sidebar1_static_content_path']); ?>

   <table width="200px" cellpadding="2" cellspacing="1" border="0" class="forumline">
         <tr>
            <td class="cat" height="25"><span><b>{ALBUM_STATS}</b></span></td>
         </tr>
         <tr>
            <td class="row1"><span class="gensmall">{TOTAL_IMAGES}{TOTAL_PICVIEW}{TOTAL_RATES}{TOTAL_RATEPOINT}{TOTAL_COMMENTS}</span></td>
         </tr>
         <tr>
            <td class="row1"><span class="gensmall">{LAST_PIC_TITLE}{LAST_PIC_TIME}{LAST_PIC_POSTER}</span></td>
         </tr>
         <tr>
            <td align="center">
               <table border="1"><tr><td>{LAST_PIC}</td></tr></table>
            </td>
         <tr>
      </table>
      <br />

$lang['Title_album-stats'] = 'Альбом статистика';

$lang['total_pics'] = 'У нас есть <b>%s</b> фото в фото альбоме. ';
$lang['viewed'] = 'Были просмотрены <b>%s</b> раз, ';
$lang['votes'] = 'оценены <b>%s</b> раз ';
$lang['vote_points'] = 'сумма всех оценок <b>%s</b> баллов. ';
$lang['comments'] = 'Кроме того были написаны <b>%s</b> комментариев.';

$lang['newest_pic'] = 'Последняя загруженная фотография <b>%s</b> ';
$lang['posted_at'] = 'и размещена на сайте %s ';
$lang['posted_by'] = 'от <b>%s</b>.';

//
// Generate page
//

// <!-- BEGIN Users Last Album Pic -->
   $sql = "SELECT pic_id, pic_title, pic_time, pic_desc FROM " . ALBUM_TABLE . " WHERE pic_username='".$profiledata['username']."'
#      AND pic_lock = 0
      AND pic_approval = 1
      ORDER BY pic_time DESC
      LIMIT 1";
   if ( !($query_result = $db->sql_query($sql)) )
   {
      message_die(GENERAL_ERROR, 'Could not obtain uploaded pics information', '', __LINE__, __FILE__, $sql);
   }
   $result = $db->sql_query($sql);
   $users_last_album_pic_id = '';
   $users_last_album_pic_title = '';
   $users_last_album_pic_desc = '';
   while ($row = mysql_fetch_array($result))
   {
      $users_last_album_pic_id = $row['pic_id'];
      $users_last_album_pic_title = $row['pic_title'];
      $users_last_album_pic_desc = $row['pic_desc'];
      $users_last_album_pic_time = $row['pic_time'];
   }

   If ( $users_last_album_pic_id )
   {
      $users_last_album_pic = '<a href="album_pic.php?pic_id=';
      $users_last_album_pic .= $users_last_album_pic_id;
      $users_last_album_pic .= '" target="_blank" class="postlink"><img src="album_thumbnail.php?pic_id=';
      $users_last_album_pic .= $users_last_album_pic_id;
      $users_last_album_pic .= '" alt="'.$users_last_album_pic_desc.'" title="'.$users_last_album_pic_desc.'" border="0" /></a>';
   }
   else
   {
      $users_last_album_pic = '';
   }
// <!-- END Users Last Album Pic -->

//
// Generate page
//

// <!-- BEGIN Users Last Album Pic -->
if ($users_last_album_pic)
{
   $template->assign_block_vars("users_last_album_pic", array(
      'LAST_ALBUM_PIC' => $users_last_album_pic,
      'L_USERS_LAST_ALBUM_PIC' => $lang['Users_Last_Album_Pic'],
      'LAST_ALBUM_PIC_TITLE' => $users_last_album_pic_title,
      'LAST_ALBUM_PIC_TIME' => '('.create_date($lang['DATE_FORMAT'], $users_last_album_pic_time, $board_config['board_timezone']).')'));
}
// <!-- END Users Last Album Pic -->

$lang['Users_Last_Album_Pic'] = 'Последняя загруженая фотка:';

   <td class="row1" align="center" class="explaintitle">
      <!-- BEGIN users_last_album_pic -->
      {users_last_album_pic.L_USERS_LAST_ALBUM_PIC}<br /><br />
      <table cellspacing="0" cellpadding="0" border="0">
         <tr><td align="center">
            <table cellspacing="0" cellpadding="0" border="3">
               <tr><td>{users_last_album_pic.LAST_ALBUM_PIC}</td></tr>
            </table>
         </td></tr>
         <tr><td align="center" class="row1">
            <span class="genmed"><b>{users_last_album_pic.LAST_ALBUM_PIC_TITLE}</b><br /></span>
            <span class="gensmall">{users_last_album_pic.LAST_ALBUM_PIC_TIME}</span>
         </td></tr>
      </table>
      <!-- END users_last_album_pic -->
   </td>