File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/lsh/safa_php_files/class.user.php

<?php
require_once('lidhja_me_db.php');
class USER
{

private $conn;
	
	public function __construct()
	{
		$database = new Database();
		$db = $database->dbConnection();
		$this->conn = $db;
    }
	
	public function runQuery($sql)
	{
		$stmt = $this->conn->prepare($sql);
		return $stmt;
	}
	public function is_loggedin()
	{
		if(isset($_SESSION['user_session']) && isset($_SESSION['user_session_username']) && isset($_SESSION['user_session_category']))
		{
			return true;
		}
	}

public function redirect($url)
	{
		header("Location: $url");
	}
	
	public function doLogout()
	{
		session_destroy();
		unset($_SESSION['user_session']);
		unset($_SESSION['user_session_username']);
		unset($_SESSION['user_session_category']);
		unset($_SESSION['user_session_email']);
		unset($_SESSION['user_name']);
		unset($_SESSION['user_phone']);
		unset($_SESSION['user_session_foto']);
		return true;
	}
	public function register($uname,$umail,$upass,$firstname,$category,$phone,$gender,$location)
	{
		try
		{
			require_once('class.fuctions.php');
			$ip= get_client_ip(); 
			$new_password = password_hash($upass, PASSWORD_DEFAULT);
			$stmt = $this->conn->prepare("INSERT INTO perdoruesit(username, email, pass, name, phone, ip, category, address, status, joiningdate,gjinia)VALUES(:uname, :umail, :upass, :name, :phone, :ip, :category, :address, :status, :joiningdate, :gjinia)");	
			$stmt->execute(array(':uname'=>$uname, ':umail'=>$umail, ':upass'=>$new_password, ':name'=>$firstname, ':phone'=>$phone, ':ip'=>$ip, ':category'=>$category, ':address'=>$location, ':status'=>"1", ':joiningdate'=>$now, ':gjinia'=>$gender));													   	
			$_SESSION['user_session']=$this->conn->lastInsertId();
			$_SESSION['user_session_username'] = $uname;
			echo $_SESSION['user_session_category'] = $category;
			$_SESSION['user_session_email'] = $umail;
			$_SESSION['user_phone'] = $phone;
			$_SESSION['user_name'] = $firstname;
			$_SESSION['user_session_foto'] ="avatar.jpg";
			setcookie("user_session", $_SESSION['user_session'], strtotime( '+30 days' ), "/", "", "", TRUE);
			setcookie("user_session_username", $uname, strtotime( '+30 days' ), "/", "", "", TRUE);
    		setcookie("pass", $new_password, strtotime( '+30 days' ), "/", "", "", TRUE); 
			$user_new_id = base64_encode($_SESSION['user_session']);
		if (!file_exists("../images/users/$user_new_id")) { mkdir("../images/users/$user_new_id", 0755);}
		if($category!="Benutzer")
		{
			$zgjidh_paketen = $this->conn->prepare("SELECT * FROM paketat WHERE id='1' LIMIT 1");
			$zgjidh_paketen->execute(array());
			$zgjidh_paketen_row=$zgjidh_paketen->fetch(PDO::FETCH_ASSOC);
$addpagesat =$this->conn->prepare("INSERT INTO pagesat(user_id, kohezgjatja, metoda, shuma, paketa, kategorite, emri_paketes, package_type, limiti, tipet) 
VALUES(:user_id, :kohezgjatja, :metoda, :shuma, :paketa, :kategorite, :emri_paketes, :package_type, :limiti, :tipet)");
$addpagesat->execute(array(':user_id'=>$_SESSION['user_session'], ':kohezgjatja'=>$zgjidh_paketen_row["kohezgjatja"], ':metoda'=>"-", ':shuma'=>$zgjidh_paketen_row["amount"], ':paketa'=>$zgjidh_paketen_row["id"], ':kategorite'=>$zgjidh_paketen_row["kategorite"], 
':emri_paketes'=>$zgjidh_paketen_row["emri"], ':package_type'=>$zgjidh_paketen_row["package_type"], ':limiti'=>$zgjidh_paketen_row["limiti"], ':tipet'=>$zgjidh_paketen_row["tipet"]));													   	
			$pagesat_id=$this->conn->lastInsertId();
			
			$updateblerjet = $this->conn->prepare("INSERT INTO blerjet(user_id,kohezgjatja, paketa, package_type, 
			dtblerjes, limiti, pagesat_id, tipet, limiti_paketes,kategorite, emri)VALUES(:user_id,:kohezgjatja,:paketa,:package_type,:dtblerjes,:limiti,:pagesat_id,:tipet,:limiti_paketes,:kategorite,:emri)");
			$updateblerjet->execute(array(':user_id'=>$_SESSION['user_session'], ':kohezgjatja'=>$zgjidh_paketen_row["kohezgjatja"], ':paketa'=>$zgjidh_paketen_row["id"], ':package_type'=>$zgjidh_paketen_row["package_type"], ':dtblerjes'=>$now, 
':limiti'=>$zgjidh_paketen_row["limiti"], ':pagesat_id'=>$pagesat_id, ':tipet'=>$zgjidh_paketen_row["tipet"], ':limiti_paketes'=>$zgjidh_paketen_row["limiti"], ':kategorite'=>$zgjidh_paketen_row["kategorite"], ':emri'=>$zgjidh_paketen_row["emri"]));
		}
		require_once("../languages/de/header.de.php");
		$from = "noreply@termmelo.de";
		$subject = 'Bitte bestätigen Sie Ihre Registrierung';
		$message = '<!DOCTYPE html><html><head><meta charset="UTF-8">
		<title>Termmelo.de - Bitte bestätigen Sie Ihre Registrierung</title>	
		</head><body style="margin:0px; font-family:Tahoma, Geneva, sans-serif;">	    
		<div class="he" style="padding:8px 0; background: #3797dd; color:#fff; box-shadow: 0px 5px 5px 0px rgba(0, 0, 0, 0.2); border-radius:0px 0px 50px 50px; width:100%; margin:0 auto; text-align:center;">
<a href="'.$lang["link"].'/" style="text-align:center;"><img src="'.$lang["link"].'/images/logo-light.png" width="180" class="a" alt="'.$lang["link"].'" style="border:none;"></a>	
</div>
<div class="c" style="padding:24px; font-size:12px;">
<div class="a" style="font-size:16px;font-weight:bold; text-align:Center;">Bitte bestätigen Sie Ihre Registrierung</div><br><br>
<b>Herzlich Willkommen '.$uname.',</b><br><br>
<p>Mit Ihrem kostenlosen Termmelo-Benutzerkonto können Sie von verschiedenen Geräten jederzeit sicher auf alle Vorteile von Termmelo zugreifen.</p>
		<p style="float:left;">Bitte klicken Sie auf folgenden Link, um Ihre Registrierung zu bestätigen: <div class="link" style="display:inline;"><a href="'.$lang["link"].'/login/'.$user_new_id.'-'.$uname.'-'.$umail.'" style="border-radius: 20px;    padding: 5px 20px;text-decoration:none;
    text-transform: uppercase;
    line-height:3.8;
   background: #3797dd;font-size: 10px;color: white;font-weight:bold; margin-left:10px;" class="link"> Registrierung bestätigen und vervollständigen!</a></div></p><br>
		<p>Sie haben Fragen? Unser Support steht Ihnen gerne zur Verfügung:</p>
<b>Supportzeiten:</b> Montag bis Freitag von 9 Uhr bis 17 Uhr<br>
<b>E-Mail:</b> info@termmelo.de<br>
<b>Mob.:</b> +49 1520 777 77 12 <br>
<br><br><br>
Mit freundlichen Grüßen<br>
<b>Ihr termmelo.de-Team</b>
<br><br><br><br>
				<div style="margin-bottom:0; overflow:hidden; text-align:center; height:45px;">
								<a class="top-icon-circle" target="_blank" style=" margin-left: 10px; color:white;" href="https://www.facebook.com/termmelo/">
									<img src="'.$lang["link"].'/images/fb_icon.png" style="width: 41px;">
								</a>
								<a class="top-icon-circle"  style="margin-left: 10px; color:white;" target="_blank" href="https://twitter.com/TermmeloGroup">
									<img src="'.$lang["link"].'/images/Twitter.png" style="width: 32px;">
								</a>
								<a class="top-icon-circle" target="_blank" style=" margin-left: 15px; color:white;" href="https://plus.google.com/u/1/107498993784792360277">
									<img src="'.$lang["link"].'/images/google_circle_color.png" style="width: 31px;">
								</a>
								<a class="top-icon-circle" style=" margin-left: 15px; color:white;" target="_blank" href="https://www.instagram.com/termmelo/">
									<img src="'.$lang["link"].'/images/63ea781df1f2a6c0184301a5dc636980_instagram-logo-clipart-transparent-instagram-clipart_1000-1000.png" style="width: 29px;">
								</a>
					</div>
	
		</div><div style="width:99%;margin:10px auto; text-align:center; font-size:11px;color:#716E6E" class="foo">www.termmelo.de ist ein Immobilien Portal der Termmelo Group GbR <br>
Termmelo Group GbR · Kastanienweg 11, 85652 Pliening · Deutschland <br>
Tel. +49 89 740 42 665 · Fax +49 89 740 42 667 · info@termmelo.de · www.termmelo.de<br>
</div></body></html>';
		$headers = "From: $from\n";
        $headers .= "MIME-Version: 1.0\n";
        $headers .= "Content-type: text/html; charset=iso-8859-1\n";
		mail($umail, $subject, $message, $headers);
		}
		catch(PDOException $e)
		{
			echo $e->getMessage();
		}				
	}
	
	
	public function doLogin($uname,$umail,$upass)
	{
		try
		{
			require_once('class.fuctions.php');
			$ip= get_client_ip(); 
			$stmt = $this->conn->prepare("SELECT COUNT(id) as countedid,id, username, email, pass, category,status,name,phone,avatar FROM perdoruesit WHERE username=:uname OR email=:umail");
			$stmt->execute(array(':uname'=>$uname, ':umail'=>$umail));
			$userRow=$stmt->fetch(PDO::FETCH_ASSOC);
			if($userRow["countedid"] == 1)
			{
				if(password_verify($upass, $userRow['pass']))
				{
					$user_id=$_SESSION['user_session'] = $userRow['id'];
					$_SESSION['user_session_username'] = $userRow['username'];
					$_SESSION['user_session_category'] = $userRow['category'];
					$_SESSION['user_session_email'] = $userRow['email'];
					$_SESSION['user_name'] = $userRow['name'];
					$_SESSION['user_phone'] = $userRow['phone'];
					if($userRow['avatar'] != "avatar.jpg"){$_SESSION['user_session_foto'] = $userRow['avatar'];}else{$_SESSION['user_session_foto']="avatar.jpg";}
			if($userRow['status']=='0'){$updateuser = $this->conn->prepare("UPDATE `perdoruesit` SET `status`='1', lastlogin=:lastlogin, ip=:ip WHERE id=:user_id");
			$updateuser->bindparam(":lastlogin", $now);
			$updateuser->bindparam(":ip", $ip);
			$updateuser->bindparam(":user_id", $user_id);
			$updateuser->execute();
			
					 if($userRow['category'] !='Benutzer')
				 {
			$updatepronat = $this->conn->prepare("UPDATE `pronat` SET `status`='1' WHERE agjenti=:user_id");
			$updatepronat->bindparam(":user_id", $user_id);
			$updatepronat->execute();
				 }}
					return true;
				}
				else
				{
					return false;
				}
			}
		}
		catch(PDOException $e)
		{
			echo $e->getMessage();
		}
	}
	
		public function updateuser($name,$web,$fax,$mobile,$email,$tel,$address,$description,$facebook,$gplus,$twitter,$skype,$password,$newpassword,$repeatpassword,$pt,$bn,$ba,$city,
		$opl,$sa,$lf,$ibs,$s,$Blog,$linkedin,$showbussinesname, $trego_emrin, $latlong, $impressum, $gender)
	{
		try 
		{		
			$checkmail = $this->conn->prepare("SELECT COUNT(email) as countedemail FROM perdoruesit WHERE id !=:eid AND email=:em");
			$checkmail->execute(array(':eid'=>$_SESSION['user_session'], ':em'=>$email));
			$num=$checkmail->fetch(PDO::FETCH_ASSOC);
			if($num["countedemail"] > 0){echo "<div class='error-box margin-top-30'><p>Diese E-Mail-Adresse existiert bereits</p><div class='small-triangle'></div><div class='small-icon'><i class='jfont'>X</i></div></div>"; exit();}
	 	if(empty($password) && empty($newpassword) && empty($repeatpassword))
	{
			$stmt = $this->conn->prepare("UPDATE perdoruesit SET name=:name, email=:email, phone=:tel, address=:address, description=:description, 
			fb=:facebook, gog=:gplus, tw=:twitter, sk=:skype, titulli_profesionit=:pt, emri_biznesit=:bn, adresa_biznesit=:ba, qyteti_biznesit=:city, licensa=:opl, 
			zona_sherbimit=:sa, gjuhet=:lf, vite_pune=:ibs, specialitete=:s, linkedin=:linkedin, blog=:blog, web=:web, fax=:fax, mobile=:mobile 
			, showbussinesname=:showbussinesname, trego_emrin=:trego_emrin, latlong=:latlong, historikufirmes=:impressum , gjinia=:gjinia where id=:user_id");
			$stmt->bindparam(":name", $name);
			$stmt->bindparam(":email", $email);	
			$stmt->bindparam(":tel", $tel);	
			$stmt->bindparam(":address", $address);	
			$stmt->bindparam(":description", $description);	
			$stmt->bindparam(":facebook", $facebook);	
			$stmt->bindparam(":gplus", $gplus);	
			$stmt->bindparam(":twitter", $twitter);	
			$stmt->bindparam(":skype", $skype);
			$stmt->bindparam(":pt", $pt);
			$stmt->bindparam(":bn", $bn);
			$stmt->bindparam(":ba", $ba);
			$stmt->bindparam(":city", $city);
			$stmt->bindparam(":opl", $opl);
			$stmt->bindparam(":sa", $sa);
			$stmt->bindparam(":lf", $lf);
			$stmt->bindparam(":ibs", $ibs);
			$stmt->bindparam(":s", $s);
			$stmt->bindparam(":linkedin", $linkedin);
			$stmt->bindparam(":blog", $Blog);
			$stmt->bindparam(":web", $web);
			$stmt->bindparam(":fax", $fax);
			$stmt->bindparam(":mobile", $mobile);	
			$stmt->bindparam(":trego_emrin", $trego_emrin);	
			$stmt->bindparam(":showbussinesname", $showbussinesname);
			$stmt->bindparam(":latlong", $latlong);		
			$stmt->bindparam(":impressum", $impressum);	
			$stmt->bindparam(":gjinia", $gender);				
			$stmt->bindparam(":user_id", $_SESSION['user_session']);	
			$stmt->execute();		
			echo"<div class='success-box margin-top-30'><p>ERFOLGREICH GEUPDATED</p><div class='small-triangle'></div><div class='small-icon'><i class='fa fa-check' aria-hidden='true'></i></div></div>";exit();
	}elseif(!empty($password) && !empty($newpassword) && !empty($repeatpassword))
	{
			$passwordstmt = $this->conn->prepare("SELECT pass FROM perdoruesit WHERE id=:U_id");
			$passwordstmt->execute(array(':U_id'=>$_SESSION['user_session']));
			$passworduserRow=$passwordstmt->fetch(PDO::FETCH_ASSOC);
	if(password_verify($password, $passworduserRow['pass']))
	{	
	 if($newpassword === $repeatpassword)
	{	
			$newpass=password_hash($newpassword, PASSWORD_DEFAULT);
			$stmt = $this->conn->prepare("UPDATE perdoruesit SET name=:name, email=:email, phone=:tel, address=:address, description=:description, 
			fb=:facebook, gog=:gplus, tw=:twitter, sk=:skype, titulli_profesionit=:pt, emri_biznesit=:bn, adresa_biznesit=:ba, qyteti_biznesit=:city, licensa=:opl, 
			zona_sherbimit=:sa, gjuhet=:lf, vite_pune=:ibs, specialitete=:s, linkedin=:linkedin, blog=:blog, web=:web, fax=:fax, mobile=:mobile, pass=:pass
, showbussinesname=:showbussinesname, trego_emrin=:trego_emrin, latlong=:latlong, historikufirmes=:impressum , gjinia=:gjinia where id=:user_id");
			$stmt->bindparam(":name", $name);
			$stmt->bindparam(":email", $email);	
			$stmt->bindparam(":tel", $tel);	
			$stmt->bindparam(":address", $address);	
			$stmt->bindparam(":description", $description);	
			$stmt->bindparam(":facebook", $facebook);	
			$stmt->bindparam(":gplus", $gplus);	
			$stmt->bindparam(":twitter", $twitter);	
			$stmt->bindparam(":skype", $skype);
			$stmt->bindparam(":pt", $pt);
			$stmt->bindparam(":bn", $bn);
			$stmt->bindparam(":ba", $ba);
			$stmt->bindparam(":city", $city);
			$stmt->bindparam(":opl", $opl);
			$stmt->bindparam(":sa", $sa);
			$stmt->bindparam(":lf", $lf);
			$stmt->bindparam(":ibs", $ibs);
			$stmt->bindparam(":s", $s);
			$stmt->bindparam(":linkedin", $linkedin);
			$stmt->bindparam(":blog", $Blog);
			$stmt->bindparam(":web", $web);
			$stmt->bindparam(":fax", $fax);
			$stmt->bindparam(":mobile", $mobile);		
			$stmt->bindparam(":pass", $newpass);	
			$stmt->bindparam(":trego_emrin", $trego_emrin);	
			$stmt->bindparam(":showbussinesname", $showbussinesname);	
			$stmt->bindparam(":latlong", $latlong);		
			$stmt->bindparam(":impressum", $impressum);		
			$stmt->bindparam(":gjinia", $gender);				
			$stmt->bindparam(":user_id", $_SESSION['user_session']);		
			$stmt->execute();	
			echo"<div class='success-box margin-top-30'><p>ERFOLGREICH GEUPDATED</p><div class='small-triangle'></div><div class='small-icon'><i class='fa fa-check' aria-hidden='true'></i></div></div>";
			exit();
	}
	else
	{
		echo"<div class='error-box margin-top-30'><p>Dein neues Passwort stimmt nicht überein</p><div class='small-triangle'></div><div class='small-icon'><i class='jfont'>X</i></div></div>";
	exit();
	}
	}
	else
	{
		echo"<div class='error-box margin-top-30'><p>Ihr aktuelles Passwort stimmt nicht überein</p><div class='small-triangle'></div><div class='small-icon'><i class='jfont'>X</i></div></div>";
	exit();
	}
	}
					$_SESSION['user_session_email'] = $email;
					$_SESSION['user_name'] = $name;
					$_SESSION['user_phone'] = $tel;
					
		}
		catch(PDOException $e)
		{
			echo $e->getMessage();
		}				
	}
	
	
	
}
?>

Batal

⬅ Naik ke lsh 37 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘add_likes.php	php	3.1 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘add_property.php	php	897 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.ImageFilter.php	php	6.3 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.advices.php	php	12.6 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.avatar.php	php	3.2 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.bussinesmap.php	php	924 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.fuctions.php	php	3.1 KB	2018-03-30 18:55	✏️ Edit 👁️ View
🐘class.graphic.php	php	5.3 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.help.php	php	7.1 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.history.php	php	7.8 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.images.php	php	3.4 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.jobs.php	php	7.2 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.kontrolli_paketave.php	php	1023 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.maklerfinder.php	php	12.2 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.map.php	php	17.4 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.notification.php	php	3.1 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.pagination.php	php	14.1 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.payments.php	php	7.8 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.property.php	php	22.4 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.reviews.php	php	12.3 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.savedproperties.php	php	11.9 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.search.php	php	13.9 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.status.php	php	1.6 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘class.user.php	php	15.5 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘getcoordinates.php	php	3.5 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘image_resize.php	php	803 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘include_languages.php	php	648 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘lidhja_me_db.php	php	700 B	2019-01-24 22:39	✏️ Edit 👁️ View
🐘login.php	php	9.3 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘report.php	php	1008 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘search.php	php	34.2 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘send_query.php	php	1 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘session.php	php	92 B	2018-03-02 23:04	✏️ Edit 👁️ View
🐘signup.php	php	4.8 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘status.php	php	716 B	2018-04-02 02:32	✏️ Edit 👁️ View
🐘upload.php	php	3.6 KB	2018-03-02 23:04	✏️ Edit 👁️ View
🐘user_system.php	php	2 KB	2018-03-02 23:04	✏️ Edit 👁️ View