Чем могу- помогу

ALTER TABLE cms_user_photos CHANGE pubdate pubdate datetime

/////////////////////////////// VIEW PHOTO ////////////
if ($do=='viewphoto'){
..........
........
......

}
///////////////////////////////////////////////////////

if ($myprofile || $inCore->userIsAdmin($user_id)) {
 echo '<div style="margin-top:5px">';
  echo '<a style="height:16px; line-height:16px; margin-right:5px; padding-left:20px; background:url(/components/users/images/edit.gif) no-repeat;" href="/users/'.$usr['id'].'/editphoto'.$photoid.'.html">'.$_LANG['EDIT'].'</a> ';
  echo '<a style="height:16px; line-height:16px; padding-left:20px; background:url(/components/users/images/delete.gif) no-repeat;"  href="/users/'.$usr['id'].'/delphoto'.$photoid.'.html">'.$_LANG['DELETE'].'</a> ';
 echo '</div>';
}

					$inCore->loadLib('tags');

                    //Вывод голосования за фото
                    $inCore->loadLib('karma');

    	            	echo '<div class="photo_bar">';
			           	echo '<table width="" cellspacing="0" cellpadding="4" align="center"><tr>';
				     	echo '<td width=""><strong>Добавлена:</strong> '.$inCore->dateformat($photo['pubdate']).'</td>';

					$karma = cmsKarma('userphoto', $photo['id']);

					echo '<td width=""><strong>'.$_LANG['HITS'].': </strong> '.$photo['hits'].'</td>';
					echo '<td width=""><strong>'.$_LANG['RATING'].': </strong><span id="karmapoints">'.cmsKarmaFormatSmall($karma['points']).'</span></td>';
					
					echo '<td width="">'.cmsKarmaButtons('userphoto', $photo['id']).'</td>';
					if ($myprofile || $inCore->userIsAdmin($user_id)) {
						echo '<td  width="">';
							echo '<a style="height:16px; line-height:16px; margin-right:5px; padding-left:20px; background:url(/components/users/images/edit.gif) no-repeat;" href="/users/'.$usr['id'].'/editphoto'.$photoid.'.html">'.$_LANG['EDIT'].'</a> ';
							echo '<a style="height:16px; line-height:16px; padding-left:20px; background:url(/components/users/images/delete.gif) no-repeat;"  href="/users/'.$usr['id'].'/delphoto'.$photoid.'.html">'.$_LANG['DELETE'].'</a> ';
						echo '</td>';
					}
			     	echo '</tr></table>';
		        	echo '</div>';					
					//конец вывода голосования за фото

INSERT INTO cms_rating_targets(id, target, component,is_user_affect, user_weight, target_table, target_title) 
       values('', 'userphoto', 'users', '1', '5', 'cms_user_photos', 'Личное фото')

    /**
     * Возвращает последние личные фотографии друзей
     * @param int $user_id
     * @param int $limit
     * @return array
     */
    public static function getUserFriendsUserPhotos($user_id, $limit=10){

        $inDB           = cmsDatabase::getInstance();
        $inCore         = cmsCore::getInstance();

        $friends        = self::getFriends($user_id);

        if (!$friends) { return false; }

        $friends_sql    = '';

        foreach($friends as $id=>$friend){
            $friends_sql .= 'u.id = '.$friend['id'];
            if ($id < sizeof($friends)-1){ $friends_sql .= ' OR '; }
        }


          $sql = "SELECT DISTINCT p.id, p.title, p.user_id, u.id as user_id, u.nickname as nickname, u.login as login,
                       IF(DATE_FORMAT(p.pubdate, '%d-%m-%Y')=DATE_FORMAT(NOW(), '%d-%m-%Y'), DATE_FORMAT(p.pubdate, '<strong>Cегодня</strong> в %H:%i'),
                       IF(DATEDIFF(NOW(), p.pubdate)=1, DATE_FORMAT(p.pubdate, 'Вчера в %H:%i'),DATE_FORMAT(p.pubdate, '%d, %M') ))  as pubdate
                FROM cms_user_photos p, cms_users u
                WHERE p.user_id = u.id AND  ({$friends_sql})
                ORDER BY p.pubdate DESC
                ";

        if ($limit) { $sql .= 'LIMIT '.$limit; }

        $result = $inDB->query($sql);

        $photos = array();

        if (!$inDB->num_rows($result)){ return false; }

        while ($photo = $inDB->fetch_assoc($result)){
            $photo['pubdate'] = $inCore->getRusDate($photo['pubdate']);
            $photos[] = $photo;
        }

        return $photos;

    }

// ============================================================================ //
// ============================================================================ //

/////////////////////////////// VIEW PROFILE //////
if ($do=='profile'){

...........
.........
.......

}

        $usr['friends_photos']  = cmsUser::getUserFriendsPhotos($usr['id']);

        $usr['friends_user_photos']  = cmsUser::getUserFriendsUserPhotos($usr['id']);

 {if $usr.friends_photos} 

{if $usr.friends_photos || $usr.friends_user_photos}

                               
                                        {foreach key=tid item=photo from=$usr.friends_photos}
                                            <tr>
                                                <td class="date">
                                                    {$photo.pubdate}
                                                </td>
                                                <td>
                                                    <a href="{profile_url login=$photo.login}" class="nickname">{$photo.nickname}</a> →
                                                    <a href="/photos/photo{$photo.id}.html">{$photo.title}</a>
                                                </td>                                                
                                            </tr>
                                        {/foreach}

                                        {foreach key=tid item=photo from=$usr.friends_user_photos}
                                            <tr>
                                                <td class="date">
                                                    {$photo.pubdate}
                                                </td>
                                                <td>
                                                    <a href="{profile_url login=$photo.login}" class="nickname">{$photo.nickname}</a> →
                                                    <a href="/users/{$photo.user_id}/photo{$photo.id}.html">{$photo.title}</a>
                                                </td>
                                            </tr>
                                        {/foreach}

/* Всплывающее окошко */
#popup_container{font-family:Arial, sans-serif;font-size:12px;width: 380px;background:#FFF;border:solid 5px #a5bede;color:#000}
#popup_title{font-size:13px;font-weight:bold;color:white;line-height:1;margin:0;background:#6D84B4 none repeat scroll 0 0;border:1px solid #3B5998;padding:6px;position:relative}
#popup_content{border-left:1px solid #aaa;border-right:1px solid #aaa;border-bottom:1px solid #aaa;padding:0em;margin:0em}
#popup_message{padding:10px 30px 10px 30px}
#popup_panel{text-align:right;background:#f2f2f2;border-top:1px solid #ccc;margin:0;padding:3px;padding-right:10px;}
#popup_prompt{margin: .5em 0em}

{* ==================меню в профиле======== *}
							<div id="usermenu" style="text-align:center;">
                            <div class="usr_profile_menu">
...................
.....................
.........................
....

{* ===============================меню в профиле================================================= *}
							<div id="usermenu" style="text-align:center;">
                            <div class="usr_profile_menu">
              <input type="hidden" name="nickname" value="{$usr.nickname}" />             
							<table cellpadding="0" cellspacing="1" align="center" style="margin-left:auto;margin-right:auto"><tr>
							{if !$myprofile}
							<td><a id="newmess" href="/users/{$usr.id}/sendmessage.html" title="{$LANG.WRITE_MESS}"><img src="/components/users/images/profilemenu/message.gif" border="0"/></a></td>
							{/if}
                            {if !$myprofile && $cfg.sw_friends}
                            	{if !$usr.isfriend}
                                	{if !$usr.isfriend_not_add}
                                	<td><a id="friends" href="/users/{$usr.id}/friendship.html" title="{$LANG.ADD_TO_FRIEND}"><img src="/components/users/images/profilemenu/friends.gif" border="0"/></a></td>
                                    {else}
                                    <td><a href="/users/{$usr.id}/nofriends.html" title="{$LANG.STOP_FRIENDLY}"><img src="/components/users/images/profilemenu/nofriends.gif" border="0"/></a></td>
                                	{/if}
                                {else}
                                <td><a href="/users/{$usr.id}/nofriends.html" title="{$LANG.STOP_FRIENDLY}"><img src="/components/users/images/profilemenu/nofriends.gif" border="0"/></a>
                                {/if}
                            {/if}

{add_js file="components/users/js/popup.js"}

<div id="addwall" style="display:none">{$usr.addwall_html}</div>

<div id="addwall">{$usr.addwall_html}</div>

{literal}
	<script type="text/javascript">
		$(document).ready(function(){
			$("#profiletabs > ul#tabs").tabs();
		});
	</script>
{/literal}

{literal}
	<script type="text/javascript">
		$(document).ready(function(){
			$("#profiletabs > ul#tabs").tabs();
			$("#addwall").css("display", "none");
		});
	</script>
{/literal}

<?php if($inUser->id){ ?>
   <a href="/forum/active.html">Активные темы на форуме</a>
<?php } ?>

 function routes_forum(){

        //RewriteRule ^forum/active.html$ /index.php?view=forum&do=active&id=$1
        $routes[] = array(
                            '_uri'  => '/^forum\/active.html$/i',
                            'do'    => 'active',
                            1       => 'id',
                         );

///////////////////////////// VIEW FORUMS LIST ////////////////////
if ($do=='view'){
................
.................
....................		
}	

///////////////////////////// АКТИВНЫЕ ТЕМЫ ////////////////////////
if ($do=='active'){
			$inPage->setTitle('Активные темы форума');
			$inPage->addPathway('Активные темы форума', $_SERVER['REQUEST_URI']);
if(usrCheckAuth()) {
       $id = $inUser->id;
    
    if ($inUser->id){
        $logdate = $_SESSION['user']['logdate'];
    } else {
        $logdate = '9999-01-01 12:00:00';
    }
		$kolvo = 15; //сколько активных тем выводить на странице
		$groupsql = forumUserAuthSQL('f.');
		
		$tsql = "SELECT t.*, COUNT(p.id) as postsnum, f.id as fid, f.title as forum, u.id as uid,
		         u.nickname as starter, u.login as login, f.auth_group as auth_group
						 FROM cms_forum_threads t, cms_forum_posts p, cms_forums f, cms_users u
						 WHERE p.thread_id = t.id AND t.user_id = u.id AND t.forum_id = f.id $groupsql AND (p.editdate > '$logdate')
						 GROUP BY p.thread_id
						 ORDER BY t.pubdate DESC
						 LIMIT $kolvo";
						 
		$result = $inDB->query($tsql) ;
		$threads = array();
		
		if ($inDB->num_rows($result)){
		
				$threads = array();

				while ($t = $inDB->fetch_assoc($result)){
					$next = sizeof($threads);							

					$pages = ceil($t['postsnum'] / $cfg['pp_thread']);				
					$lastmessage = threadLastMessageData($t['id']);							

					$threads[$next]['date']         = strip_tags($lastmessage['date']);
					$threads[$next]['author']       = $lastmessage['user'];
					$threads[$next]['authorhref']   = cmsUser::getProfileURL($lastmessage['login']);
					$threads[$next]['starter']      = $t['starter'];
					$threads[$next]['starterhref']  = cmsUser::getProfileURL($t['login']);
					$threads[$next]['topic']        = ucfirst($t['title']);
					$threads[$next]['topicdesc']    = ucfirst($t['description']);
					$threads[$next]['topichref']    = '/forum/thread'.$t['id'].'-'.$pages.'.html#new';
					$threads[$next]['forum']        = ucfirst($t['forum']);
					$threads[$next]['forumhref']    = '/forum/'.$t['fid'];

                    $threads[$next]['secret']       = 0;
                    if ($t['auth_group']>0) {
                        $threads[$next]['secret']   = 1;
                    }

					if (strlen($lastmessage['msg'])>70) { $lastmessage['msg'] = substr($lastmessage['msg'], 0, 70).'...'; }

                    $msg = $lastmessage['msg'];

                    $threads[$next]['msg'] = $msg;

					if ($t['postsnum']==1) {
						$threads[$next]['act'] = 'начинает тему';
					} else { 
						$threads[$next]['act'] = 'отвечает в теме';
					}										
				}

				$smarty = $inCore->initSmarty('components', 'com_forum_active.tpl');			
				$smarty->assign('threads', $threads);
				$smarty->assign('cfg', $cfg);				
				$smarty->display('com_forum_active.tpl');	
														
		} else { echo '<h2>Нет активных тем на форуме!!!</h2>'; }

} else { usrAccessDenied(); }

}

<table width="100%" cellspacing="0" cellpadding="5" border="0" >
{foreach key=tid item=thread from=$threads}
	<tr>
		<td style="font-size: 12px;" align="left" valign="top" width="">
			<div><a href="{$thread.topichref}" style="font-weight:bold">{$thread.topic}</a></div>
			<div class="thread_desc">{$thread.topicdesc}</div>
		</td>
		<td style="font-size: 12px;" class="" valign="top" width="120">
			<div><strong>Автор:</strong><br><a href="{$thread.starterhref}">{$thread.starter}</a>
		</td>		
		<td style="font-size: 12px;" class="" valign="top" width="200">
			<div><strong>Последнее сообщение: </strong></div>
			<div>{$thread.date} от <a href="{$thread.authorhref}">{$thread.author}</a></div>
		</td>
	</tr>
{/foreach}
</table>

<table width="100%" cellspacing="0" cellpadding="5" border="0" >
    {foreach key=tid item=thread from=$threads}

        <tr>
            <td align="left" class="mod_fweb2_date" width="70"><div style="text-align:center">{$thread.date}</div></td>
            <td width="13">
                {if !$thread.secret}
                    <img src="/modules/mod_forum/user.gif" border="0" />
                {else}
                    <img src="/modules/mod_forum/hidden.gif" border="0" title="Скрытая тема - видна только вашей группе"/>
                {/if}
            </td>
            <td style="padding-left:0px"><a href="{$thread.authorhref}" class="mod_fweb2_userlink">{$thread.author}</a> {$thread.act} «<a href="{$thread.topichref}" class="mod_fweb2_topiclink">{$thread.topic}</a>»
            {if $cfg.showforum neq 0} на форуме «<a href="{$thread.forumhref}">{$thread.forum}</a>»{/if}</td>
        </tr>

        {if $cfg.showtext neq 0}
        <tr>
            <td> </td>
            <td colspan="2"><div class="mod_fweb2_shorttext">{$thread.msg}</div></td>
        </tr>
        {/if}

    {/foreach}
</table>

$sql    = "SELECT id, login FROM cms_users WHERE (login LIKE '$data') AND (is_deleted = 0) LIMIT 1";

$sql    = "SELECT id, login FROM cms_users WHERE (login LIKE '$data') LIMIT 1";

   if ($do=='register'){
…..
…..
…..
        if($msg==''){

            if ($inCore->checkCaptchaCode($code)){
…..
…..

$sql = "SELECT id, login, email FROM cms_users WHERE (login LIKE '$login' OR email LIKE '$email') AND (is_deleted = 0)";

$sql = "SELECT id, login, email FROM cms_users WHERE (login LIKE '$login' OR email LIKE '$email') LIMIT 1";