/extremedating/trunk

<?PHP

/*

    ExtremeDating - a Hackathon 2013 project.

    Copyright (C) 2013 Gustav Hartvigsson <gustav.hartvigsson@gmail.com>

    Copyright (C) 2013 Daniel Johansson <maila@danieljohansson.nu>

    This program is free software: you can redistribute it and/or modify

    it under the terms of the GNU Affero General Public License as

    published by the Free Software Foundation, either version 3 of the

    License, or (at your option) any later version.

    This program is distributed in the hope that it will be useful,

    but WITHOUT ANY WARRANTY; without even the implied warranty of

    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    GNU Affero General Public License for more details.

    You should have received a copy of the GNU Affero General Public License

    along with this program.  If not, see <http://www.gnu.org/licenses/>.

*/

if($profilename != $username) {

	$relationinfo = $db->query("SELECT * from dateInterests WHERE(user1='$username' AND user2='$profilename')");

	$relationquery = $relationinfo->fetchAll();

  $newusername = $db->query("SELECT firstName, surName FROM Users WHERE loginName = '{$profilename}'");

  $newusername = $newusername->fetchAll();

  $newusername = $newusername[0]['firstName'] . " " . $newusername[0]['surName'];

	if($relationquery != array()) {

    ?>

		<p>Du har visat intresse för en lunchdejt med den här personen<p />

		<form method="POST" action="">

		<button type="Submit" name="Unsubscribe">Sluta visa intresse</button>

		</form>

    <?php

		$relationinfo = $db->query("SELECT * from dateInterests WHERE(user1='$profilename' AND user2='$username')");

		$relationquery = $relationinfo->fetchAll();

		if($relationquery != array()) {

			echo $newusername . ' vill gärna äta lunch med dig också, skicka ett mail och bestäm träff!';

			include 'planlunch.php';

			include 'showlunchsuggestions.php';

		}

	} else {

    ?>

		<p>Vill du gå på lunch med den här personen?</p>

		<form method="POST" action="">

		<button type="Submit" name="Subscribe">Visa intresse</button>

		</form>

    <?php

	}

	if (isset($_POST['Subscribe'])) {

		$relationinfo = $db->query("SELECT * from dateInterests WHERE(user1='$username' AND user2='$profilename')");

		$relationquery = $relationinfo->fetchAll();

		if($relationquery == array()) {

			$db->exec("INSERT INTO dateInterests VALUES ('$username', '$profilename')");

			echo '<p>Du har visat intresse för lunch med personen</p>';

			sleep(.5);

			header("Location:./profile.php?uid=" . $profilename);

		}

	}

	if (isset($_POST['Unsubscribe'])) 

	{ 

		$db->exec("DELETE FROM dateInterests WHERE (user1='$username' AND user2='$profilename')");

		echo '<p>Du har slutat visa intresse för lunch med personen</p>'; 

		sleep(.5);

		header("Location:./profile.php?uid=" . $profilename);

	}

}