Александр

 
   <div class="avatar_min">
     <img src="............" border="0">
   </div>
 

 
.avatar_min{float:left;overflow:hidden;height:49px;width:49px}
 

 
    /**
     * Удаляет старые записи ленты
     * @param int $pubdays
     * @return bool
     */
    static function removeOldLog($pubdays = 60){
 
        $inDB   = cmsDatabase::getInstance();
 
        $sql = "DELETE FROM cms_actions_log WHERE DATEDIFF(NOW(), pubdate) > '{$pubdays}'";
 
        $inDB->query($sql);
 
        return true;
 
    }
 

if ($do=='search'){
..........
........
.......

 
	$querysql = "SELECT		        
				 u.id as id,
				 u.login,
				 u.nickname,
				 u.group_id,
                 u.logdate as flogdate,
		         u.is_deleted as is_deleted,
                 u.birthdate, u.rating,
				 u.status as microstatus,
                 p.city, p.karma as karma, p.imageurl, 
				 p.gender as gender
                 FROM cms_users u
				 LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				 WHERE u.is_deleted = 0 AND u.is_locked = 0 AND u.group_id != 2 $s
				 ORDER BY city DESC";
 

if ($do=='view'){
..........
..........
.............
 

			$sql = "SELECT		        
				    u.id as id,
				    u.login,
				    u.nickname,
                                    u.group_id,
				    u.logdate as flogdate,
		            u.is_deleted as is_deleted,
                    u.birthdate, u.rating,
				    u.status as microstatus,
                    p.city, p.karma as karma, p.imageurl, 
				    p.gender as gender
                    FROM cms_users u
				    LEFT JOIN cms_user_profiles p ON p.user_id = u.id
				    WHERE u.is_locked = 0 AND u.is_deleted = 0 AND u.group_id != 2
					ORDER BY ".$orderby." ".$orderto."
					LIMIT ".(($page-1)*$perpage).", $perpage";
		} else {
 
		$sql = "SELECT		        
				    o.user_id as id,
				    u.login,
				    u.nickname,
                                    u.group_id,
					u.logdate as flogdate,
		            u.is_deleted as is_deleted,
                    u.birthdate, u.rating,
				    u.status as microstatus,
                    p.city, p.karma as karma, p.imageurl, 
				    p.gender as gender
				    FROM cms_online o
                    LEFT JOIN cms_users u ON  u.id = o.user_id
				    LEFT  JOIN cms_user_profiles p ON p.user_id = u.id
				    WHERE u.is_locked = 0 AND u.is_deleted = 0 AND u.group_id != 2
                    GROUP BY o.user_id
					ORDER BY ".$orderby." ".$orderto."
					LIMIT ".(($page-1)*$perpage).", $perpage";

 
				thumb1=96,
				thumb2=600,
 

 $this->info['tab']              = 'Статьи';

$smarty = $inCore->initSmarty('modules', 'mod_usermenu.tpl');

$new_friend  =  $inDB->rows_count('cms_user_friends', "to_id = '$inUser->id' AND is_accepted = '0'");

$smarty->assign('new_friend', $new_friend);

{$new_friend}