function getUsernameByEmail($email)
{
    $query = "select * from user_profile_details WHERE email='{$email}' ";
    $result_set = mysql_query($query);
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) == 1) {
            $userProfile = mysql_fetch_array($result_set);
            $username = $userProfile['username'];
            return $username;
        } else {
            return "";
        }
    }
}
function getCVPathByUsername($username)
{
    $query = "select * from user_cv WHERE username='******' ";
    $result_set = mysql_query($query);
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) == 1) {
            $userCV = mysql_fetch_array($result_set);
            $userCVPath = $userCV['cv_file_path'];
            return $userCVPath;
        } else {
            return null;
        }
    }
}
function singleSearch($tableName, $searchTerm, $searchTxt)
{
    $counter = 0;
    $allUsernamesWithDuplicates = array();
    $result_set = mysql_query("select * from  " . $tableName . "  where " . $searchTerm . " ='{$searchTxt}'");
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) > 0) {
            while ($result = mysql_fetch_assoc($result_set)) {
                $allUsernamesWithDuplicates[$counter] = $result['username'];
                $counter++;
            }
        }
    }
    $allUsernamesWithNoDuplicates = array_unique($allUsernamesWithDuplicates);
    return $allUsernamesWithNoDuplicates;
}
function getProjectsListByUsername($username)
{
    $projectsArray = array();
    $query = "select * from user_project WHERE username='******' ";
    $result_set = mysql_query($query);
    if (isQuerySuccess($result_set)) {
        $recordCount = 0;
        if (mysql_num_rows($result_set) > 0) {
            while ($row = mysql_fetch_array($result_set)) {
                $projectsArray[$recordCount] = $row;
                $recordCount = $recordCount + 1;
            }
        }
    }
    return $projectsArray;
}
function getAllUsernames()
{
    $result_set = mysql_query("select * from user_login where status='NORMAL USER'");
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) > 0) {
            $usernames = array();
            $counter = 0;
            while ($result = mysql_fetch_assoc($result_set)) {
                $usernames[$counter] = $result['username'];
                $counter++;
            }
            return $usernames;
        } else {
            return null;
        }
    }
}
function signIn($username, $password)
{
    if (hasNotSensitiveCharacters($username)) {
        if (hasNotSensitiveCharacters($password)) {
            $password = encodeString($password);
            $query = "select * from user_login WHERE username='******' AND password='******'";
            $result_set = mysql_query($query);
            if (isQuerySuccess($result_set)) {
                if (mysql_num_rows($result_set) == 1) {
                    $userLogin = mysql_fetch_array($result_set);
                    $_SESSION['username'] = $userLogin['username'];
                    redirect_to("userHome");
                    return "";
                } else {
                    return "Invalid Login details";
                }
            }
        } else {
            return "Password has invalid characters";
        }
    } else {
        return "Username has invalid characters";
    }
}
function isAdminAlreadyExists($username)
{
    $query = "select * from user_login WHERE status='ADMIN USER' ";
    $result_set = mysql_query($query);
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) > 0) {
            return true;
        } else {
            return false;
        }
    }
}
function hasPicUploadedOnce($username)
{
    $response = false;
    $query = "select * from user_profile_details WHERE username='******' ";
    $result_set = mysql_query($query);
    if (isQuerySuccess($result_set)) {
        if (mysql_num_rows($result_set) == 1) {
            $userProfile = mysql_fetch_array($result_set);
            $userProfilePicPath = $userProfile["picture_file_path"];
            if ($userProfilePicPath != "") {
                $response = true;
            }
        }
    }
    return $response;
}