ByMind

 
//получаем общее число записей на стене этого пользователя
        $total = $inDB->rows_count('cms_user_wall', "  user_id = $user_id AND   usertype = '$usertype'");
        $pages = ceil($total / $perpage);
 
        if ($total){
            //получаем нужную страницу записей стены
            $sql = "SELECT w.*, g.gender, g.imageurl, u.nickname as author, u.login as author_login, u.is_deleted, w.pubdate
                    FROM cms_user_wall w
					INNER JOIN cms_users u ON u.id = w.author_id
					INNER JOIN cms_user_profiles g ON g.user_id = u.id
                    WHERE w.user_id = $user_id AND w.usertype = '$usertype'
                    ORDER BY w.pubdate DESC
                    LIMIT ".(($page-1)*$perpage).", $perpage";
 
            $result     = $inDB->query($sql);
 
			if (!function_exists('usrImageNOdb')){
            $inCore->includeFile('components/users/includes/usercore.php');
			}
 

 
//получаем общее число записей на стене этого пользователя
        $total = $inDB->rows_count('cms_user_wall', "usertype = '$usertype'");
        $pages = ceil($total / $perpage);
 
        if ($total){
            //получаем нужную страницу записей стены
            $sql = "SELECT w.*, g.gender, g.imageurl, u.nickname as author, u.login as author_login, u.is_deleted, w.pubdate
                    FROM cms_user_wall w
					INNER JOIN cms_users u ON u.id = w.author_id
					INNER JOIN cms_user_profiles g ON g.user_id = u.id
                    WHERE w.usertype = '$usertype'
                    ORDER BY w.pubdate DESC
                    LIMIT ".(($page-1)*$perpage).", $perpage";
 
            $result     = $inDB->query($sql);
 
			if (!function_exists('usrImageNOdb')){
            $inCore->includeFile('components/users/includes/usercore.php');
			}