Сквозная авторизация и единая база пользователей для 1.10.3 (часть 2, общие аватарки)

ALTER TABLE `cms_user_profiles` ADD `imageurl_host` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

if (!$file_name || !file_exists(PATH.'/images/users/avatars/'.$file_name)){

if (!$file_name){

 
			if ($size == 'small'){
				return '/images/users/avatars/small/'.$file_name;
			} else {
				return '/images/users/avatars/'.$file_name;
			}
 

 
$inDB=cmsDatabase::getInstance();
                     $host = $inDB->get_field('cms_user_profiles', 'user_id='.$user_id, 'imageurl_host');
                        if (!$host) {$host = 'http://'.$_SERVER['HTTP_HOST'].'/';}
			if ($size == 'small'){
				return $host.'/images/users/avatars/small/'.$file_name;
			} else {
				return $host.'/images/users/avatars/'.$file_name;
			}
 

$sql = "UPDATE cms_user_profiles SET imageurl = '{$file['filename']}' WHERE user_id = '$id' LIMIT 1";

 
$host = 'http://'.$_SERVER['HTTP_HOST'].'/';
			$sql = "UPDATE cms_user_profiles SET imageurl = '{$file['filename']}', imageurl_host='$host' WHERE user_id = '$id' LIMIT 1";
 

$sql = "UPDATE cms_user_profiles SET imageurl = '$filename' WHERE user_id = '$id' LIMIT 1";

 
                $host = 'http://'.$_SERVER['HTTP_HOST'].'/';
		$sql = "UPDATE cms_user_profiles SET imageurl = '$filename', imageurl_host='$host' WHERE user_id = '$id' LIMIT 1";