';print_r($w);print"

';print_r($this->pages);print'

";print_r($images);
	return $images;
}

function getUserImagesForAjax($id) {

	global $dbi;

	$sql="select user_id, file,pos from image_users where user_id=$id order by pos";
	$res=sql_query($sql,$dbi);
	$n=sql_num_rows($res,$dbi); $i=0;

	while(list($id1, $image)=sql_fetch_array($res,$dbi)) {
		$size=@GetImageSize(PATH."Image/users/$image");
		$data[]=array(id1=>$id1, pic=>$image, thumb=>str_replace('.','_t.',$image), x=>$size[0], y=>$size[1]);
	}
	return $data;
}


function getUserMainImage($id) {
	if($auth->multi_images) {
		global $dbi;
		$sql="select file from image_users where user=$id and main=1";
		$res=sql_query($sql,$dbi);
		list($image)=sql_fetch_array($res,$dbi);
	}else{
		$image=$this->makeUserSingleImageName($id).'.jpg';
		if(!is_file(USER_IMAGES.$image)) return;
	}
	return $image;
}

function getMegrNyilAccept($id) {
	global $dbi;
	$sql="select megr_nyil_date from users where id='$id'";
	$res=sql_query($sql,$dbi);
	list($date)=sql_fetch_array($res,$dbi);
	return $date;
}
function updateMegrNyilAccept($id) {
	global $dbi;
	$sql="update users set megr_nyil_date='".date("Y-m-d")."' where id='$id'";
	sql_query($sql,$dbi);
}

/**
 * @todo Lorand:biztos hogy $post[cimzett] egy t�mb?
 * @todo Lorand:biztos hogy $users egy t�mb?
 */
function sendNewsletter($post,$debug=false) {

	global $dbi,$SITEGLOBALS;
	$trans=new translator($SITEGLOBALS[LANGUAGE],0);

	extract($post);

	foreach($users as $id){
		$userdata[]=$this->getUserData($id);
	}

	// ha nem j�tt postb�l content,blurb
	if(!$content) {
		$c=new content;
		extract(is_numeric($newsletter) ? $c->getContentData($newsletter) : $c->getContentByCode($newsletter));
	}

	if($frame) {
		$frame_content = is_numeric($frame) ? $c->getContentData($frame) : $c->getContentByCode($frame);
		$content=str_ireplace('#content#',$content,$frame_content[content]);
	}

	$headers="From: $SITEGLOBALS[MAIL_FROM]\nContent-Type: text/html; charset=ISO-8859-2 ";

	foreach($userdata as $u){
		$email=$u[email];
		$unsubscribe=$this->unsubscribeURL($u[id],$email);

		$subst_codes=array('name'=>$u[name], 'unsubscribe'=>$unsubscribe);
		if($subst) $subst_codes=array_merge($subst_codes,$subst);

		$body=$content;
		foreach($subst_codes as $f=> $r) {
			$body=str_ireplace("#$f#",$r?$r:'---',$body);
		}
		$body=str_ireplace('\"','"',$body);

		if($t=$SITEGLOBALS['SELLER_DATA']){
			$body.=	"


".$t[company]."

"
					."".$trans->getSingleTranslation('TEXT_PHONE').": ".$t[phone1]."
"
					."".$trans->getSingleTranslation('TEXT_ADDRESS').": ".$t[address1]."
"
					.""."www: ".$t[web];
		}

		if($debug)
			print"".htmlentities($email)."
".$blurb."
$body
";
		else
			mail($email,$blurb,$body,$headers);
	}
}
function resendNewsLetter($post,$debug=false){
	global $dbi,$SITEGLOBALS;

	$headers="From: $SITEGLOBALS[MAIL_FROM]\nContent-Type: text/html; charset=ISO-8859-2 ";

	$sql="select email,concat(firstname,' ',lastname) from users where id in ($post[users])";
	$res=sql_query($sql,$dbi);
	while(list($email,$name)=sql_fetch_array($res,$dbi)){
		$body=str_ireplace('#name#',$name,$post[content]);
		$email="$name <$email>";

		if($debug)
			print"".htmlentities($email)."
".$blurb."
$body
";
		else
			mail($email,$post[blurb],$body,$headers);
	}
}
function unsubscribeURL($id,$email){
	return WEBPATH."index.php?page=unsubscribe&id=$id&email=$email";
}
function unsubscribeNewsletter($id,$email) {
	global $dbi;
	$sql="update users set newsletter_send=0 where id='$id' and email='$email'";
	sql_query($sql,$dbi);
	return mysql_affected_rows($dbi);
}

function regByEmailURL($user_id,$email) {
	return WEBPATH."index.php?page=reg_by_email&email=$email&key=".md5(CODE.$user_id.$email);
}
function getUserDataForRegByEmail($email,$key) {
	global $dbi;
	$sql="select id,email,firstname as fname,lastname as lname,phone from users where email='$email'";
	$res=sql_query($sql,$dbi);
	$a=sql_fetch_assoc($res,$dbi);
	if($key==md5(CODE.$a[id].$a[email])) return $a;
}

function urlChars() {
	$chars=array('�','�','�','�','�','�','�','�','�','�','�','�','�','�','�','�','�','�');
	//foreach($chars as $i=>$c) $chars[$i]=iconv("ISO-8859-2", "UTF-8", $c);
	return $chars;
}

function getHistory($user_id){

	global $dbi;

	$sql="select * from user_history where user_id=$user_id order by timestamp desc";
	//echo $sql;
	$res=sql_query($sql,$dbi);
	while($r=sql_fetch_assoc($res,$dbi)){
		switch($r[type]){
			case 'U':
				$r[type]='frissites';
				break;
			case 'I':
				$r[type]='letrehozas';
				break;
			case 'D':
				$r[type]='torles';
				break;
		}

		switch($r[change_table]){
			case 'users':
				$r[change_table]='alapadat';
				break;
			case 'property_values':
				$r[change_table]='tulajdonsag';
				break;
		}

		$data[]=$r;
	}
	//echo "
";print_r($data);
	return $data;
}

} // class v�ge
?>