<?
///////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////
//		Fisier functii.
//		A nu se modifica fara autorizarea dezvoltatorilor.
///////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////


// CHECK USER 
function CheckLogin(){
if (isset($_SESSION['user']) && $_SESSION['user'] != '')
	{
		return true;
	}
elseif (isset($_COOKIE['username'],$_COOKIE['password'])){
		include('include/sql_connect.php');
		$user = $_COOKIE['username'];
		$pass = $_COOKIE['password'];
		
		$checkdb = mysqli_query($dbhandle ,"select count(username) as chk from users where username = '$user' and password = '$pass' and status = 'Active'");
		while($row = mysqli_fetch_array($checkdb)){ 
		$check = $row['chk'];
		}
			if ($check !== '1'){return false;}
			elseif ($check == '1'){
				$user_id_q = mysqli_query($dbhandle,"select id from users where username = '$user' and password = '$pass' and status = 'Active'");
				while($row2 = mysqli_fetch_array($user_id_q)){ 
				$user_id = $row2['id'];}
				$_SESSION['user'] = $user_id;
				return true;
			}

	}
else {return false;}
}

//-----------------------------------------------------------------------------

// CHECK ADMIN 
function IsAdmin(){
if (isset($_SESSION['user']) && $_SESSION['user'] != '')
	{
		include('include/sql_connect.php');
		$query = mysqli_query($dbhandle, "select count(*) as cnt from enadm where id_user = ".$_SESSION['user']);
		while($row = mysqli_fetch_array($query)){
			$cnt = $row['cnt'];
		}

		if($cnt > 0 ){
			return true;
		}
		else{
			return false;
		}
	}
	else {
			return false;
		}
}

//-----------------------------------------------------------------------------


//Check and change rang by points
function Check_rank($user_id){
	include('include/sql_connect.php');
	$check_points_sql = "SELECT * FROM user_points WHERE user_id = $user_id;";	
	$check_points_result = mysqli_query($dbhandle, $check_points_sql);	
	
	while($check_points_row = mysqli_fetch_assoc($check_points_result)){
		$points_value = $check_points_row['points'];	
		
		if($points_value < 200){
			$new_rank = "Noob";
		}
		
		else if($points_value < 400){
			$new_rank = "Starter";
		}
		else if($points_value < 700){
			$new_rank = "Average";
		}
		else if($points_value < 1100){
			$new_rank = "Not Bad";
		}
		else if($points_value < 1600){
			$new_rank = "Learning";
		}
		else if($points_value < 2200){
			$new_rank = "Student";
		}
		else if($points_value < 2900){
			$new_rank = "Explorer";
		}
		else if($points_value < 3700){
			$new_rank = "Graduate";
		}
		else if($points_value < 4700){
			$new_rank = "Professional";
		}
		else if($points_value < 5600){
			$new_rank = "Professor";
		}
		else if($points_value < 6700){
			$new_rank = "Doctor";
		}
		else if($points_value < 7900){
			$new_rank = "Engineer";
		}
		else if($points_value < 9200){
			$new_rank = "Electronoober";
		}
	}
	$update_rank = mysqli_query($dbhandle, "UPDATE user_points SET rank = '$new_rank' WHERE user_id = '$user_id'");	
}
//-----------------------------------------------------------------------------


// Remiove the style="" line
function remove_style($text){
	
	$first_split = explode("style=&quot;", $text,2);	
	$second_split = explode("&quot;", $first_split[1],2);	
	$final_text = $first_split[0].$second_split[1];
	
	return($final_text);	
	
	
}
//-----------------------------------------------------------------------------


// GET DATA
function GetData($tab, $col, $wh, $dat){
		include('include/sql_connect.php');
		$query = mysqli_query($dbhandle, "select $col as col from $tab where $wh = '$dat' limit 1");
		while($row = mysqli_fetch_array($query)){
			$data = $row['col'];
		}
		return $data;
}

//-----------------------------------------------------------------------------

// USER DATA 
function UserData($user_id){
		include('include/sql_connect.php');
		$user_data = array();
		$user_den_sel=mysqli_query($dbhandle, "select * from users where id = '$user_id' ");
		while ($row = mysqli_fetch_array($user_den_sel)){
			$user_data['username'] = $row['username'];
			$user_data['firstname'] = $row['firstname'];
			$user_data['lastname'] = $row['lastname'];
			$user_data['email'] = $row['email'];
			$user_data['position'] = $row['job'];
			$user_data['lang'] = $row['lang'];
			}
		return $user_data;
}
//-----------------------------------------------------------------------------

// USER DATA 
function UserProfile($user_id){
		include('include/sql_connect.php');
		$user_data = array();
		$user_den_sel=mysqli_query($dbhandle, "select * from users_profile where id_user = '$user_id' ");
		while ($row = mysqli_fetch_array($user_den_sel)){
			$f_query = mysqli_query($dbhandle, "select * from followers where user_id = $user_id");
			$fl_query = mysqli_query($dbhandle, "select * from followers where follower_id = $user_id");
			$p_query = mysqli_query($dbhandle, "select * from projects where id_user = $user_id");
			$t_query = mysqli_query($dbhandle, "select * from tutorials where id_user = $user_id");
			$s_query = mysqli_query($dbhandle, "select * from subscribers where id_user = $user_id");
			$user_data['first_name'] = $row['first_name'];
			$user_data['last_name'] = $row['last_name'];
			$user_data['show_name'] = $row['show_name'];
			$user_data['sex'] = $row['sex'];
			$user_data['birthday'] = $row['birthday'];
			$user_data['job'] = $row['job'];
			$user_data['website'] = $row['website'];
			$user_data['phone'] = $row['phone'];
			$user_data['company'] = $row['company'];
			$user_data['about'] = $row['about'];
			$user_data['address1'] = $row['address1'];
			$user_data['address2'] = $row['address2'];
			$user_data['city'] = $row['city'];
			$user_data['state'] = $row['state'];
			$user_data['zip'] = $row['zip'];
			$user_data['timezone'] = $row['timezone'];
			$user_data['picture'] = $row['picture'];
			$user_data['followers'] = mysqli_num_rows($f_query);
			$user_data['following'] = mysqli_num_rows($fl_query);
			$user_projects = mysqli_num_rows($p_query);
			$user_tutorials = mysqli_num_rows($t_query);
			$user_tutorials = mysqli_num_rows($t_query);
			$user_subscribed = mysqli_num_rows($s_query);
			$user_data['projects'] = $user_projects + $user_tutorials;
			$user_data['subscribed'] = $user_subscribed;
		}
		return $user_data;
}
//-----------------------------------------------------------------------------


// GENERATORS
function GenNr($name){
include('include/sql_connect.php');
		$gen_select=mysqli_query($dbhandle, "select nr + 1 as nr from generators where name = '$name'");
		while ($row = mysqli_fetch_array($gen_select)){$nr = $row['nr'];}
		$up = mysqli_query($dbhandle, "update generators set nr = '$nr' where name = '$name'");
		return $nr;
}
//-----------------------------------------------------------------------------


//-----------------------------------------------------------------------------
// GET RANDOM USERS
function GetRandUsers($nr){
		include('include/sql_connect.php');
		$i = 0;
		$user_data = array();
		$user_den_sel=mysqli_query($dbhandle, "select * from users_profile where id != ".$_SESSION['user']." and picture != 'no-image_avatar.png' and id not in (select user_id from followers where follower_id = ".$_SESSION['user'].") order by RAND() limit $nr");
		while ($row = mysqli_fetch_array($user_den_sel)){
			$f_query = mysqli_query($dbhandle, "select * from followers where user_id = ".$row['id_user']);
			$p_query = mysqli_query($dbhandle, "select * from projects where id_user = ".$row['id_user']);
			$t_query = mysqli_query($dbhandle, "select * from tutorials where id_user = ".$row['id_user']);
			$user_data[$i] = array();
			$user_data[$i]['id'] = $row['id_user'];
			$user_data[$i]['first_name'] = $row['first_name'];
			$user_data[$i]['last_name'] = $row['last_name'];
			$user_data[$i]['show_name'] = $row['show_name'];
			$user_data[$i]['sex'] = $row['sex'];
			$user_data[$i]['birthday'] = $row['birthday'];
			$user_data[$i]['job'] = $row['job'];
			$user_data[$i]['website'] = $row['website'];
			$user_data[$i]['company'] = $row['company'];
			$user_data[$i]['about'] = $row['about'];
			$user_data[$i]['address1'] = $row['address1'];
			$user_data[$i]['address2'] = $row['address2'];
			$user_data[$i]['city'] = $row['city'];
			$user_data[$i]['state'] = $row['state'];
			$user_data[$i]['zip'] = $row['zip'];
			$user_data[$i]['timezone'] = $row['timezone'];
			$user_data[$i]['picture'] = $row['picture'];
			$user_data[$i]['followers'] = mysqli_num_rows($f_query);
			$user_data[$i]['projects'] = mysqli_num_rows($p_query);
			$user_projects = mysqli_num_rows($p_query);
			$user_tutorials = mysqli_num_rows($t_query);
			$user_data[$i]['projects'] = $user_projects + $user_tutorials;
			$i++;
		}
		return $user_data;
}


function GetRandUsersNL($nr){
		include('include/sql_connect.php');
		$i = 0;
		$user_data = array();
		$user_den_sel=mysqli_query($dbhandle, "select * from users_profile where picture != 'no-image_avatar.png' order by RAND() limit $nr");
		while ($row = mysqli_fetch_array($user_den_sel)){
			$f_query = mysqli_query($dbhandle, "select * from followers where user_id = ".$row['id_user']);
			$p_query = mysqli_query($dbhandle, "select * from projects where id_user = ".$row['id_user']);
			$t_query = mysqli_query($dbhandle, "select * from tutorials where id_user = ".$row['id_user']);
			$user_data[$i] = array();
			$user_data[$i]['id'] = $row['id_user'];
			$user_data[$i]['first_name'] = $row['first_name'];
			$user_data[$i]['last_name'] = $row['last_name'];
			$user_data[$i]['show_name'] = $row['show_name'];
			$user_data[$i]['sex'] = $row['sex'];
			$user_data[$i]['birthday'] = $row['birthday'];
			$user_data[$i]['job'] = $row['job'];
			$user_data[$i]['website'] = $row['website'];
			$user_data[$i]['company'] = $row['company'];
			$user_data[$i]['about'] = $row['about'];
			$user_data[$i]['address1'] = $row['address1'];
			$user_data[$i]['address2'] = $row['address2'];
			$user_data[$i]['city'] = $row['city'];
			$user_data[$i]['state'] = $row['state'];
			$user_data[$i]['zip'] = $row['zip'];
			$user_data[$i]['timezone'] = $row['timezone'];
			$user_data[$i]['picture'] = $row['picture'];
			$user_data[$i]['followers'] = mysqli_num_rows($f_query);
			$user_projects = mysqli_num_rows($p_query);
			$user_tutorials = mysqli_num_rows($t_query);
			$user_data[$i]['projects'] = $user_projects + $user_tutorials;
			$i++;
		}
		return $user_data;
}
//-----------------------------------------------------------------------------

// IS FOLLOWING
function IsFollowing($id_follower, $id_user){
		include('include/sql_connect.php');
		$follow_query = mysqli_query($dbhandle, "select * from followers where follower_id = $id_follower and user_id = $id_user ");
		if($follow_query){
			if(mysqli_num_rows($follow_query) > 0){
				return true;
			}else{
				return false;
			}
		}
}

//-----------------------------------------------------------------------------


// NUMBER OF LIKES (PROJECT)
function NumLikes($id_project){
		include('include/sql_connect.php');
		$NumLikeQuery = mysqli_query($dbhandle, "select count(*) as cnt from projects_like where id_project = ".$id_project);
		while($row = mysqli_fetch_array($NumLikeQuery)){
			$cnt = $row['cnt'];
		}
		return $cnt;
}
		
		
//-----------------------------------------------------------------------------


// IS LIKED(PROJECT)
function IsLiked($id_project,$id_user){
	include('include/sql_connect.php');	
	$likequery = mysqli_query($dbhandle, "select * from projects_like where id_user = ".$id_user." AND id_project = ".$id_project);
	if(mysqli_num_rows($likequery) > 0){
		return true;
	}else{
		return false;
	}
}
//-----------------------------------------------------------------------------


// IS VOTED (CONTEST)
function IsVotedContest($id_project,$id_user,$id_contest){
	include('include/sql_connect.php');	
	$votequery = mysqli_query($dbhandle, "select * from Contests_votes where User_id = ".$id_user." AND Project_id = ".$id_project." AND Contest_id = ".$id_contest);
	if(mysqli_num_rows($votequery) > 0){
		return true;
	}else{
		return false;
	}
}
//-----------------------------------------------------------------------------


// Is a contest finished?

function ContestNotFinished($contest_id){
	include('include/sql_connect.php');
	
	
	$query_finished = mysqli_query($dbhandle, "select * from Contests where id = $contest_id");
	$row_finished = mysqli_fetch_assoc($query_finished);
	$TheEndDate = $row_finished['End_date'];
	
	$now    = time();
	$target = strtotime($row_finished['End_date']);
	$diff   = $now - $target;
	
   	if($diff > 0){
		return false;
	}
	
	else{
		return true;
	}	
	
}


// IS LIKED(PROJECT)
function IsFavourite($id_project,$id_user,$type){
	include('include/sql_connect.php');	
	$favquery = mysqli_query($dbhandle, "select * from favourites where id_user = ".$id_user." AND id_project = ".$id_project ."  AND type = '$type'");
	if(mysqli_num_rows($favquery) > 0){
		return true;
	}else{
		return false;
	}
}
//-----------------------------------------------------------------------------

// NUMBER OF LIKES (TUTORIAL)
function NumLikesTut($id_project){
		include('include/sql_connect.php');
		$NumLikeQuery = mysqli_query($dbhandle, "select count(*) as cnt from tutorials_likes where id_project = ".$id_project);
		while($row = mysqli_fetch_array($NumLikeQuery)){
			$cnt = $row['cnt'];
		}
		return $cnt;
}	
//-----------------------------------------------------------------------------


// NUMBER OF VOTES (CONTEST)
function NumVotesContest($id_project, $id_contest){
		include('include/sql_connect.php');
	
		$sql_NumVotesContest = "select count(*) as cnt from Contests_votes where Project_id = $id_project AND  Contest_id = $id_contest  ;";
		$NumVotesContestQuery = mysqli_query($dbhandle, $sql_NumVotesContest);
		
	
		while($row = mysqli_fetch_array($NumVotesContestQuery)){
			$cnt = $row['cnt'];
		}
		return $cnt;
}	
//-----------------------------------------------------------------------------


// IS LIKED(TUTORIAL)
function IsLikedTut($id_project,$id_user){
	include('include/sql_connect.php');	
	$likequery = mysqli_query($dbhandle, "select * from tutorials_likes where id_user = ".$id_user." AND id_project = ".$id_project);
	if(mysqli_num_rows($likequery) > 0){
		return true;
	}else{
		return false;
	}
}
//-----------------------------------------------------------------------------

// NUMBER OF LIKES (STATUS)
function NumLikesStatus($id_status){
		include('include/sql_connect.php');
		$NumLikeQuery = mysqli_query($dbhandle, "select count(*) as cnt from statuses_like where id_status = ".$id_status);
		while($row = mysqli_fetch_array($NumLikeQuery)){
			$cnt = $row['cnt'];
		}
		return $cnt;
}
		
		
//-----------------------------------------------------------------------------

// IS LIKED(STATUS)
function IsLikedStatus($id_project,$id_user){
	include('include/sql_connect.php');	
	$likequery = mysqli_query($dbhandle, "select * from statuses_like where id_user = ".$id_user." AND id_status = ".$id_project);
	if(mysqli_num_rows($likequery) > 0){
		return true;
	}else{
		return false;
	}
}
//-----------------------------------------------------------------------------

// PROJECT DATA 
function ProjectData($project_id){
		include('include/sql_connect.php');
		$project_data = array();
		$query=mysqli_query($dbhandle, "select * from projects where id = '$project_id' ");
		while ($row = mysqli_fetch_array($query)){
			$project_data['title'] = $row['title'];
			$project_data['description'] = $row['description'];
			$project_data['thumb'] = $row['thumb'];
			$project_data['status'] = $row['status'];
			$project_data['external_link'] = $row['external_link'];
			$project_data['gallery_description'] = $row['gallery_description'];
			$project_data['created_at'] = $row['created_at'];
			$project_data['id_user'] = $row['id_user'];
			$project_data['likes'] = NumLikes($project_id);
			
			$project_data['category'] = $row['category'];
			$project_data['subcategory'] = $row['subcategory'];
			$project_data['visibility'] = $row['visibility'];
		}
		$i = 1;
		$gallery_query = mysqli_query($dbhandle, "select * from projects_gallery where id_project = $project_id order by nr");
		if(mysqli_num_rows($gallery_query) > 0){
			while($rw = mysqli_fetch_array($gallery_query)){
				$project_data['gallery'.$i] = 'yes';
				$project_data['gallery_img_id'.$i] = $rw['id'];
				$project_data['gallery_title'.$i] = $rw['title'];
				$project_data['gallery_type'.$i] = $rw['type'];
				$project_data['gallery_image'.$i] = $rw['image'];
				$project_data['gallery_video'.$i] = $rw['video'];
				$i++;
			}
		}
		
		while($i < 5){
			$project_data['gallery'.$i] = 'no';
			$i++;
		}
		
		$tags_query = mysqli_query($dbhandle, "SELECT t.tag as tag FROM `projects_tags` pt 
												join tags t on t.id = pt.id_tag
												WHERE id_project = $project_id");
		while($rt = mysqli_fetch_array($tags_query)){
			$tags .= $rt['tag'].',';
		}
		$tags = substr($tags, 0, -1);
		$project_data['tags'] = $tags;

		return $project_data;
}
//-----------------------------------------------------------------------------

// TUTORIAL DATA 
function TutorialData($tutorial_id){
		include('include/sql_connect.php');
		$project_data = array();
		$query=mysqli_query($dbhandle, "select * from tutorials where id = '$tutorial_id' ");
		if( mysqli_num_rows($query) <= 0){
			return 0;
		}
		while ($row = mysqli_fetch_array($query)){
			$project_data['title'] = $row['title'];
			$project_data['description'] = $row['description'];
			$project_data['thumb'] = $row['thumb'];
			$project_data['external_link'] = $row['external_link'];
			$project_data['created_at'] = $row['created_at'];
			$project_data['id_user'] = $row['id_user'];
			$project_data['visibility'] = $row['visibility'];
			$project_data['likes'] = NumLikesTut($tutorial_id);
		}
		
		$steps_query = mysqli_query($dbhandle, "select * from tutorials_steps where id_tutorial = '$tutorial_id' order by nr");
		if(mysqli_num_rows($steps_query) > 0){
			$project_data['steps']= mysqli_fetch_array($steps_query);
			
		}
		
		$tags_query = mysqli_query($dbhandle, "SELECT t.tag as tag FROM `tutorials_tags` pt 
												join tags t on t.id = pt.id_tag
												WHERE id_tutorial = $tutorial_id");
		while($rt = mysqli_fetch_array($tags_query)){
			$tags .= $rt['tag'].',';
		}
		$tags = substr($tags, 0, -1);
		$project_data['tags'] = $tags;

		return $project_data;
}
//-----------------------------------------------------------------------------

function AddTagsToProject($tags, $id_project){
	include('include/sql_connect.php');
	$tags = explode(",",$tags);
	foreach($tags as $tag){
		$query = mysqli_query($dbhandle, "select id from tags where tag = '$tag'");
		if(mysqli_num_rows($query) > 0){
			while($row = mysqli_fetch_array($query)){
				mysqli_query($dbhandle, "insert into projects_tags (id_project, id_tag) values (".$id_project.", ".$row['id'].")");
			}
		}
		else{
			mysqli_query($dbhandle, "insert into tags (tag) values ('$tag')");
			$last_id = $dbhandle->insert_id;
			mysqli_query($dbhandle, "insert into projects_tags (id_project, id_tag) values (".$id_project.", ".$last_id.")");
		}
	}
}


function AddTagsToTutorial($tags, $id_tutorial){
	include('include/sql_connect.php');
	$tags = explode(",",$tags);
	foreach($tags as $tag){
		$query = mysqli_query($dbhandle, "select id from tags where tag = '$tag'");
		if(mysqli_num_rows($query) > 0){
			while($row = mysqli_fetch_array($query)){
				mysqli_query($dbhandle, "insert into tutorials_tags (id_tutorial, id_tag) values (".$id_tutorial.", ".$row['id'].")");
			}
		}
		else{
			mysqli_query($dbhandle, "insert into tags (tag) values ('$tag')");
			$last_id = $dbhandle->insert_id;
			mysqli_query($dbhandle, "insert into tutorials_tags (id_tutorial, id_tag) values (".$id_tutorial.", ".$last_id.")");
		}
	}
}

//-----------------------------------------------------------------------------


// TIME AGO 
function get_timeago( $ptime )
{
    $estimate_time = time() - $ptime;

    if( $estimate_time < 1 )
    {
        return 'less than 1 second ago';
    }

    $condition = array(
                12 * 30 * 24 * 60 * 60  =>  'year',
                30 * 24 * 60 * 60       =>  'month',
                24 * 60 * 60            =>  'day',
                60 * 60                 =>  'hour',
                60                      =>  'minute',
                1                       =>  'second'
    );

    foreach( $condition as $secs => $str )
    {
        $d = $estimate_time / $secs;

        if( $d >= 1 )
        {
            $r = round( $d );
            return 'about ' . $r . ' ' . $str . ( $r > 1 ? 's' : '' ) . ' ago';
        }
    }
}


// GENERATE THUMBNAIL


function generate_image_thumbnail($source_image_path, $thumbnail_image_path, $wi, $he)
{
	
$THUMBNAIL_IMAGE_MAX_WIDTH = $wi;
$THUMBNAIL_IMAGE_MAX_HEIGHT = $he;

    list($source_image_width, $source_image_height, $source_image_type) = getimagesize($source_image_path);
    switch ($source_image_type) {
        case IMAGETYPE_GIF:
            $source_gd_image = imagecreatefromgif($source_image_path);
            break;
        case IMAGETYPE_JPEG:
            $source_gd_image = imagecreatefromjpeg($source_image_path);
            break;
        case IMAGETYPE_PNG:
            $source_gd_image = imagecreatefrompng($source_image_path);
            break;
    }
    if ($source_gd_image === false) {
        return false;
    }
    $source_aspect_ratio = $source_image_width / $source_image_height;
    $thumbnail_aspect_ratio = $THUMBNAIL_IMAGE_MAX_WIDTH / $THUMBNAIL_IMAGE_MAX_HEIGHT;
    if ($source_image_width <= $THUMBNAIL_IMAGE_MAX_WIDTH && $source_image_height <= $THUMBNAIL_IMAGE_MAX_HEIGHT) {
        $thumbnail_image_width = $source_image_width;
        $thumbnail_image_height = $source_image_height;
    } elseif ($thumbnail_aspect_ratio > $source_aspect_ratio) {
        $thumbnail_image_width = (int) ($THUMBNAIL_IMAGE_MAX_HEIGHT * $source_aspect_ratio);
        $thumbnail_image_height = $THUMBNAIL_IMAGE_MAX_HEIGHT;
    } else {
        $thumbnail_image_width = $THUMBNAIL_IMAGE_MAX_WIDTH;
        $thumbnail_image_height = (int) ($THUMBNAIL_IMAGE_MAX_WIDTH / $source_aspect_ratio);
    }
    $thumbnail_gd_image = imagecreatetruecolor($thumbnail_image_width, $thumbnail_image_height);
    imagecopyresampled($thumbnail_gd_image, $source_gd_image, 0, 0, 0, 0, $thumbnail_image_width, $thumbnail_image_height, $source_image_width, $source_image_height);

    $img_disp = imagecreatetruecolor($THUMBNAIL_IMAGE_MAX_WIDTH,$THUMBNAIL_IMAGE_MAX_WIDTH);
    $backcolor = imagecolorallocate($img_disp,0,0,0);
    imagefill($img_disp,0,0,$backcolor);

        imagecopy($img_disp, $thumbnail_gd_image, (imagesx($img_disp)/2)-(imagesx($thumbnail_gd_image)/2), (imagesy($img_disp)/2)-(imagesy($thumbnail_gd_image)/2), 0, 0, imagesx($thumbnail_gd_image), imagesy($thumbnail_gd_image));

    imagejpeg($img_disp, $thumbnail_image_path, 90);
    imagedestroy($source_gd_image);
    imagedestroy($thumbnail_gd_image);
    imagedestroy($img_disp);
    return true;
}


// Get Comment count for Projects
function getCommCountP($id){
	include('include/sql_connect.php');
	$comments_q = mysqli_query($dbhandle,"SELECT  count(*) as total FROM projects_comments WHERE id_project = ".$id); 
	$row_c = mysqli_fetch_assoc($comments_q);
		$count = $row_c['total'];
	
	return $count;
	}
// Get Comment count for Tutorials
function getCommCountT($id){
	include('include/sql_connect.php');
	$comments_q = mysqli_query($dbhandle,"SELECT  count(*) as total FROM tutorials_comments WHERE id_project = ".$id); 
	$row_c = mysqli_fetch_assoc($comments_q);
		$count = $row_c['total'];
	
	return $count;
	}

// Get Comment count for Projects
function getCommCountS($id){
	include('include/sql_connect.php');
	$comments_q = mysqli_query($dbhandle,"SELECT  count(*) as total FROM status_comments WHERE id_status = ".$id); 
	$row_c = mysqli_fetch_assoc($comments_q);
		$count = $row_c['total'];
	
	return $count;
	}


// Remove inline css from strings
function RemoveInlineCSS($text){
	$result = preg_replace('/style=\\"[^\\"]*/', '', $text);
	return $result;
}

//Get views
function GetViews($type,$id){
	include('include/sql_connect.php');
	if($type == 'project'){
		$query = mysqli_query($dbhandle, "select count(*) as cnt from (select * from projects_views where id_project = $id group by ip) t");
	}
	if($type == 'tutorial'){
		$query = mysqli_query($dbhandle, "select count(*) as cnt from (select * from tutorials_views where id_tutorial = $id group by ip) t");
	}
	while($row = mysqli_fetch_array($query)){
		$cnt = $row['cnt'];
	}
	return $cnt;
}

//sendmail 

function x_sendmail($to, $subj, $content, $subsc){

	include ('utils/phpmailer/src/Exception.php');
	include ('utils/phpmailer/src/PHPMailer.php');
	include ('utils/phpmailer/src/SMTP.php');

	$msg = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html style="width:100%;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;padding:0;Margin:0;">
	 <head> 
	  <meta charset="UTF-8"> 
	  <meta content="width=device-width, initial-scale=1" name="viewport"> 
	  <meta name="x-apple-disable-message-reformatting"> 
	  <meta http-equiv="X-UA-Compatible" content="IE=edge"> 
	  <meta content="telephone=no" name="format-detection"> 
	  <title>Electronoobs Sign In</title> 
	  <!--[if (mso 16)]>
		<style type="text/css">
		a {text-decoration: none;}
		</style>
		<![endif]--> 
	  <!--[if gte mso 9]><style>sup { font-size: 100% !important; }</style><![endif]--> 
	  <!--[if !mso]><!-- --> 
	  <link href="https://fonts.googleapis.com/css?family=Lato:400,400i,700,700i" rel="stylesheet"> 
	  <!--<![endif]--> 
	  <style type="text/css">
	@media only screen and (max-width:600px) {p, ul li, ol li, a { font-size:16px!important; line-height:150%!important } h1 { font-size:30px!important; text-align:center; line-height:120%!important } h2 { font-size:26px!important; text-align:center; line-height:120%!important } h3 { font-size:20px!important; text-align:center; line-height:120%!important } h1 a { font-size:30px!important } h2 a { font-size:26px!important } h3 a { font-size:20px!important } .es-menu td a { font-size:16px!important } .es-header-body p, .es-header-body ul li, .es-header-body ol li, .es-header-body a { font-size:16px!important } .es-footer-body p, .es-footer-body ul li, .es-footer-body ol li, .es-footer-body a { font-size:16px!important } .es-infoblock p, .es-infoblock ul li, .es-infoblock ol li, .es-infoblock a { font-size:12px!important } *[class="gmail-fix"] { display:none!important } .es-m-txt-c, .es-m-txt-c h1, .es-m-txt-c h2, .es-m-txt-c h3 { text-align:center!important } .es-m-txt-r, .es-m-txt-r h1, .es-m-txt-r h2, .es-m-txt-r h3 { text-align:right!important } .es-m-txt-l, .es-m-txt-l h1, .es-m-txt-l h2, .es-m-txt-l h3 { text-align:left!important } .es-m-txt-r img, .es-m-txt-c img, .es-m-txt-l img { display:inline!important } .es-button-border { display:block!important } a.es-button { font-size:20px!important; display:block!important; border-width:15px 25px 15px 25px!important } .es-btn-fw { border-width:10px 0px!important; text-align:center!important } .es-adaptive table, .es-btn-fw, .es-btn-fw-brdr, .es-left, .es-right { width:100%!important } .es-content table, .es-header table, .es-footer table, .es-content, .es-footer, .es-header { width:100%!important; max-width:600px!important } .es-adapt-td { display:block!important; width:100%!important } .adapt-img { width:100%!important; height:auto!important } .es-m-p0 { padding:0px!important } .es-m-p0r { padding-right:0px!important } .es-m-p0l { padding-left:0px!important } .es-m-p0t { padding-top:0px!important } .es-m-p0b { padding-bottom:0!important } .es-m-p20b { padding-bottom:20px!important } .es-mobile-hidden, .es-hidden { display:none!important } .es-desk-hidden { display:table-row!important; width:auto!important; overflow:visible!important; float:none!important; max-height:inherit!important; line-height:inherit!important } .es-desk-menu-hidden { display:table-cell!important } table.es-table-not-adapt, .esd-block-html table { width:auto!important } table.es-social { display:inline-block!important } table.es-social td { display:inline-block!important } }
	#outlook a {
		padding:0;
	}
	.ExternalClass {
		width:100%;
	}
	.ExternalClass,
	.ExternalClass p,
	.ExternalClass span,
	.ExternalClass font,
	.ExternalClass td,
	.ExternalClass div {
		line-height:100%;
	}
	.es-button {
		mso-style-priority:100!important;
		text-decoration:none!important;
	}
	a[x-apple-data-detectors] {
		color:inherit!important;
		text-decoration:none!important;
		font-size:inherit!important;
		font-family:inherit!important;
		font-weight:inherit!important;
		line-height:inherit!important;
	}
	.es-desk-hidden {
		display:none;
		float:left;
		overflow:hidden;
		width:0;
		max-height:0;
		line-height:0;
		mso-hide:all;
	}
	</style> 
	 </head> 
	 <body style="width:100%;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;-webkit-text-size-adjust:100%;-ms-text-size-adjust:100%;padding:0;Margin:0;"> 
	  <div class="es-wrapper-color" style="background-color:#F4F4F4;"> 
	   <!--[if gte mso 9]>
				<v:background xmlns:v="urn:schemas-microsoft-com:vml" fill="t">
					<v:fill type="tile" color="#f4f4f4"></v:fill>
				</v:background>
			<![endif]--> 
	   <table class="es-wrapper" width="100%" cellspacing="0" cellpadding="0" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;padding:0;Margin:0;width:100%;height:100%;background-repeat:repeat;background-position:center top;"> 
		 <tr class="gmail-fix" height="0" style="border-collapse:collapse;"> 
		  <td style="padding:0;Margin:0;"> 
		   <table width="600" cellspacing="0" cellpadding="0" border="0" align="center" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;"> 
			 <tr style="border-collapse:collapse;"> 
			  <td cellpadding="0" cellspacing="0" border="0" style="padding:0;Margin:0;line-height:1px;min-width:600px;" height="0"> <img src="https://esputnik.com/repository/applications/images/blank.gif" style="display:block;border:0;outline:none;text-decoration:none;-ms-interpolation-mode:bicubic;max-height:0px;min-height:0px;min-width:600px;width:600px;" alt width="600" height="1"> </td> 
			 </tr> 
		   </table> </td> 
		 </tr> 
		 <tr style="border-collapse:collapse;"> 
		  <td valign="top" style="padding:0;Margin:0;"> 
		   <table class="es-content" cellspacing="0" cellpadding="0" align="center" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%;"> 
			 <tr style="border-collapse:collapse;"> 
			  <td style="padding:0;Margin:0;background-color:transparent;background-position:left top;" bgcolor="transparent" align="center"> 
			   <table class="es-content-body" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:transparent;" width="600" cellspacing="0" cellpadding="0" bgcolor="rgba(0, 0, 0, 0)" align="center"> 
				 <tr style="border-collapse:collapse;"> 
				  <td style="padding:0;Margin:0;padding-top:20px;padding-left:30px;padding-right:30px;background-position:left top;background-color:#337ab7;" bgcolor="#337ab7" align="left"> 
				   <!--[if mso]><table width="540" cellpadding="0" cellspacing="0"><tr><td width="174" valign="top"><![endif]--> 
				   <table class="es-left" cellspacing="0" cellpadding="0" align="left" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;float:left;"> 
					 <tr style="border-collapse:collapse;"> 
					  <td class="es-m-p0r es-m-p20b" width="174" valign="top" align="center" style="padding:0;Margin:0;"> 
					   <table style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-position:left top;" width="100%" cellspacing="0" cellpadding="0"> 
						 <tr style="border-collapse:collapse;"> 
						  <td align="center" style="padding:0;Margin:0;padding-bottom:15px;padding-left:15px;padding-right:15px;"> <img class="adapt-img" src="https://electronoobs.io/images/theme/logo_circle.png" alt style="display:block;border:0;outline:none;text-decoration:none;-ms-interpolation-mode:bicubic;" width="94"></td> 
						 </tr> 
					   </table> </td> 
					 </tr> 
				   </table> 
				   <!--[if mso]></td><td width="20"></td><td width="346" valign="top"><![endif]--> 
				   <table cellspacing="0" cellpadding="0" align="right" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;"> 
					 <tr style="border-collapse:collapse;"> 
					  <td width="346" align="left" style="padding:0;Margin:0;"> 
					   <table width="100%" cellspacing="0" cellpadding="0" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;"> 
						 <tr style="border-collapse:collapse;"> 
						  <td align="left" style="padding:0;Margin:0;padding-top:20px;"> <span style="font-size:42px;">ELECTRONOOBS</span> </td> 
						 </tr> 
					   </table> </td> 
					 </tr> 
				   </table> 
				   <!--[if mso]></td></tr></table><![endif]--> </td> 
				 </tr> 
			   </table> </td> 
			 </tr> 
		   </table> 
		   <table class="es-content" cellspacing="0" cellpadding="0" align="center" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%;"> 
			 <tr style="border-collapse:collapse;"> 
			  <td align="center" style="padding:0;Margin:0;"> 
			   <table class="es-content-body" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:#FFFFFF;" width="600" cellspacing="0" cellpadding="0" bgcolor="#ffffff" align="center"> 
				 <tr style="border-collapse:collapse;"> 
				  <td align="left" style="padding:0;Margin:0;"> 
				   <table width="100%" cellspacing="0" cellpadding="0" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;"> 
					 <tr style="border-collapse:collapse;"> 
					  <td width="600" valign="top" align="center" style="padding:0;Margin:0;"> 
					   <table style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:#FFFFFF;" width="100%" cellspacing="0" cellpadding="0" bgcolor="#ffffff"> 
						 <tr style="border-collapse:collapse;"> 
						  <td class="es-m-txt-l" bgcolor="#ffffff" align="center" style="Margin:0;padding-bottom:15px;padding-top:20px;padding-left:30px;padding-right:30px;"> <p style="Margin:0;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-size:32px;font-family:helvetica, \'helvetica neue\', arial, verdana, sans-serif;line-height:48px;color:#337AB7;"><strong>
						  <!-- TITLU -->
						  
							'.$subj.'
						  
						  <!-- END TITLU -->
						  
						  </strong><br></p> </td> 
						 </tr> 
						 <tr style="border-collapse:collapse;"> 
						  <td class="es-m-txt-l" bgcolor="#ffffff" align="left" style="Margin:0;padding-top:20px;padding-bottom:20px;padding-left:30px;padding-right:30px;"> <p style="Margin:0;-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-size:18px;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;line-height:27px;color:#666666;">
						  <!-- CONTINUT -->
						  
							'.$content.'
							
						  <!-- END CONTINUT -->
						  </p>
						 </tr> 
					   </table> </td> 
					 </tr> 
				   </table> </td> 
				 </tr> 
			   </table> </td> 
			 </tr> 
		   </table> 
		   <table class="es-content" cellspacing="0" cellpadding="0" align="center" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;table-layout:fixed !important;width:100%;"> 
			 <tr style="border-collapse:collapse;"> 
			  <td align="center" style="padding:0;Margin:0;"> 
			   <table class="es-content-body" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;background-color:transparent;" width="600" cellspacing="0" cellpadding="0" align="center"> 
				 <tr style="border-collapse:collapse;"> 
				  <td align="left" style="padding:0;Margin:0;"> 
				   <table width="100%" cellspacing="0" cellpadding="0" style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:collapse;border-spacing:0px;"> 
					 <tr style="border-collapse:collapse;"> 
					  <td width="600" valign="top" align="center" style="padding:0;Margin:0;"> 
					   <table style="mso-table-lspace:0pt;mso-table-rspace:0pt;border-collapse:separate;border-spacing:0px;background-color:#C0EDE0;border-radius:4px;" width="100%" cellspacing="0" cellpadding="0" bgcolor="#c0ede0"> 
						 <tr style="border-collapse:collapse;"> 
						  <td bgcolor="#337ab7" align="center" style="padding:0;Margin:0;padding-top:30px;padding-left:30px;padding-right:30px;"> <h3 style="Margin:0;line-height:24px;mso-line-height-rule:exactly;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;font-size:20px;font-style:normal;font-weight:normal;color:#111111;">Need more help?</h3> </td> 
						 </tr> 
						 <tr style="border-collapse:collapse;"> 
						  <td esdev-links-color="#66bb7f" bgcolor="#337ab7" align="center" style="padding:0;Margin:0;padding-bottom:30px;padding-left:30px;padding-right:30px;"> <a target="_blank" href="https://electronoobs.io" style="-webkit-text-size-adjust:none;-ms-text-size-adjust:none;mso-line-height-rule:exactly;font-family:lato, \'helvetica neue\', helvetica, arial, sans-serif;font-size:18px;text-decoration:underline;color:#FFFFFF;">We`re here, ready to talk</a></td> 
						 </tr>
 						 <tr style="border-collapse:collapse;"> 
						  <td bgcolor="#337ab7" align="center" style="padding:30px;Margin:0; font-size: 14px;"> 	<a href="https://electronoobs.io/account_settings" style="color:#fff;">If you want to unsubscribe from this emails please uncheck notifications in your account settings page on electronoobs.io </a></td>
						 </tr> 
					   </table> </td> 
					 </tr> 
				   </table> </td> 
				 </tr> 
			   </table> </td> 
			 </tr> 
		   </table> </td> 
		 </tr> 
	   </table> 
	  </div>  
	 </body>
	</html>';

	$mail = new PHPMailer\PHPMailer\PHPMailer();                              // Passing `true` enables exceptions
	$mail->isSMTP();
	$mail->SMTPDebug = 0;
	$mail->Host = 'mail.electronoobs.io';
	$mail->Port = 465;
	$mail->SMTPSecure = 'ssl';
	$mail->SMTPAuth = true;
	$mail->Username = "admin@electronoobs.io";
	$mail->Password = "3cWHWK^]XbLO";
	$mail->setFrom('admin@electronoobs.io', 'Electronoobs.io');
	$mail->addAddress($to, '');
	$mail->Subject = $subj;
	$mail->msgHTML($msg);
	if (!$mail->send()) {
		return 'Eroare'.$mail->ErrorInfo ;
	} else {
		return 'Succes';
	}
	
	
}


?><?
$username = "r70183elec_en";
$password = "M@sterK3y@123";
$hostname = "localhost";
$db = 'r70183elec_en';
$dbhandle = mysqli_connect($hostname, $username, $password, $db, 3306) or die('Could not connect: ' . mysqli_error());

$username2 = "r70183elec_forum";
$password2 = "M@sterK3y@123";
$hostname2 = "localhost";
$db2 = 'r70183elec_forum';
$dbhandle_forum = mysqli_connect($hostname2, $username2, $password2, $db2, 3306) or die('Could not connect: ' . mysqli_error());
?>
<!DOCTYPE html>
<html lang="en">
<head>
 

<br />
<b>Warning</b>:  Undefined variable $dbhandle in <b>/home/r70183elec/public_html/include/meta.php</b> on line <b>71</b><br />
<br />
<b>Fatal error</b>:  Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in /home/r70183elec/public_html/include/meta.php:71
Stack trace:
#0 /home/r70183elec/public_html/include/meta.php(71): mysqli_query()
#1 /home/r70183elec/public_html/index.php(25): include('/home/r70183ele...')
#2 {main}
  thrown in <b>/home/r70183elec/public_html/include/meta.php</b> on line <b>71</b><br />