<?php
    include("database_setup.php");

    session_start();

    //Take variable
//    $photoName = $_GET["x1"];
    $photoName = "friend_300.jpg";
    $user = $_SESSION["username"];

    if(strcmp($_GET["x2"], "") == 0) {
        $fileType = "Homepage_Photo";
    }
    else {
        $fileType = "Watermarked_Process";
    }

    if($conn) {
        $query = "SELECT Photo_Location.File_Name, File_Location.File_Location, Photos.Photo_Title ";
        $query .= "FROM Photos, Photo_Location, File_Location ";
        $query .= "WHERE Photo_Location.File_Name = '$photoName' AND Photo_Location.Photo_No = Photos.Photo_No AND ";

        if(strcmp($fileType, "Homepage_Photo") == 0) {
            $query .= "Photos.Username = '$user' AND Photos.Watermark = '0' AND File_Location.File_Type = '$fileType' AND ";
        }
        else {
            $query .= "Photos.Username = '$user' AND Photos.Watermark = '1' AND File_Location.File_Type = '$fileType' AND ";
        }
        $query .= "File_Location.File_Type = Photo_Location.File_Type";

        $queryResult = mysql_query($query);

        if($queryResult) {
            if(mysql_num_rows($queryResult) != 0) {
                $_SESSION["picName"] = mysql_result($queryResult, 0, "File_Name");
                $_SESSION["location"] = mysql_result($queryResult, 0, "File_Location");
                $_SESSION["title"] = mysql_result($queryResult, 0, "Photo_Title");

                session_write_close();
                header("Location: http://www.sig-share.com/site/photo_dl3.php");
            }
            else {
                echo "not found " . $fileType;
            }
        }
    }
?>